function render($ele_value, $caption, $markupName, $isDisabled, $element, $entry_id)
{
global $xoopsDB, $xoopsUser, $myts;
$renderer = new formulizeElementRenderer();
$form_handler = xoops_getmodulehandler('forms', 'formulize');
$id_form = $element->getVar('id_form');
if ($entry_id != "new") {
$owner = getEntryOwner($entry_id, $id_form);
} else {
$owner = $xoopsUser ? $xoopsUser->getVar('uid') : 0;
}
$formObject = $form_handler->get($id_form);
$isDisabled = false;
if (strstr(getCurrentURL(), "printview.php")) {
$isDisabled = true;
// disabled all elements if we're on the printable view
}
$ele_desc = $element->getVar('ele_desc', "f");
if (strstr($ele_value[2], "#*=:*")) {
// if we've got a link on our hands... -- jwe 7/29/04
// new process for handling links...May 10 2008...new datastructure for formulize 3.0
$boxproperties = explode("#*=:*", $ele_value[2]);
$sourceFid = $boxproperties[0];
$sourceHandle = $boxproperties[1];
$sourceEntryIds = explode(",", trim($boxproperties[2], ","));
// grab the user's groups and the module id
global $regcode;
if ($regcode) {
// if we're dealing with a registration code, determine group membership based on the code
$reggroupsq = q("SELECT reg_codes_groups FROM " . XOOPS_DB_PREFIX . "_reg_codes WHERE reg_codes_code=\"{$regcode}\"");
$groups = explode("&8(%\$", $reggroupsq[0]['reg_codes_groups']);
if ($groups[0] === "") {
unset($groups);
}
// if a code has no groups associated with it, then kill the null value that will be in position 0 in the groups array.
$groups[] = XOOPS_GROUP_USERS;
$groups[] = XOOPS_GROUP_ANONYMOUS;
} else {
$groups = $xoopsUser ? $xoopsUser->getGroups() : array(0 => XOOPS_GROUP_ANONYMOUS);
}
$module_id = getFormulizeModId();
$pgroups = array();
// handle new linkscope option -- August 30 2006
$emptylist = false;
if ($ele_value[3]) {
$scopegroups = explode(",", $ele_value[3]);
if (!in_array("all", $scopegroups)) {
if ($ele_value[4]) {
// limit by user's groups
foreach ($groups as $gid) {
// want to loop so we can get rid of reg users group simply
if ($gid == XOOPS_GROUP_USERS) {
continue;
}
if (in_array($gid, $scopegroups)) {
$pgroups[] = $gid;
}
}
} else {
// just use scopegroups
$pgroups = $scopegroups;
}
if (count($pgroups) == 0) {
// specific scope was specified, and nothing found, so we should show nothing
$emptylist = true;
}
} else {
if ($ele_value[4]) {
// all groups selected, but limiting by user's groups is turned on
foreach ($groups as $gid) {
// want to loop so we can get rid of reg users group simply
if ($gid == XOOPS_GROUP_USERS) {
continue;
}
$pgroups[] = $gid;
}
} else {
// all groups should be used
unset($pgroups);
$allgroupsq = q("SELECT groupid FROM " . $xoopsDB->prefix("groups"));
// . " WHERE groupid != " . XOOPS_GROUP_USERS); // use all groups now, if all groups are picked, with no restrictions on membership or anything, then use all groups
foreach ($allgroupsq as $thisgid) {
$pgroups[] = $thisgid['groupid'];
}
}
}
}
// Note: OLD WAY: if no groups were found, then pguidq will be empty and so all entries will be shown, no restrictions
// NEW WAY: if a specific group(s) was specified, and no match with the current user was found, then we return an empty list
array_unique($pgroups);
// remove duplicate groups from the list
if ($ele_value[6] and count($pgroups) > 0) {
$pgroupsfilter = " (";
$start = true;
foreach ($pgroups as $thisPgroup) {
if (!$start) {
$pgroupsfilter .= " AND ";
}
$pgroupsfilter .= "EXISTS(SELECT 1 FROM " . $xoopsDB->prefix("formulize_entry_owner_groups") . " AS t2 WHERE t2.groupid={$thisPgroup} AND t2.fid={$sourceFid} AND t2.entry_id=t1.entry_id)";
$start = false;
}
$pgroupsfilter .= ")";
} elseif (count($pgroups) > 0) {
$pgroupsfilter = " t2.groupid IN (" . formulize_db_escape(implode(",", $pgroups)) . ") AND t2.entry_id=t1.entry_id AND t2.fid={$sourceFid}";
} else {
$pgroupsfilter = "";
}
$sourceFormObject = $form_handler->get($sourceFid);
list($conditionsfilter, $conditionsfilter_oom, $parentFormFrom) = buildConditionsFilterSQL($ele_value[5], $sourceFid, $entry_id, $owner, $formObject, "t1");
// if there is a restriction in effect, then add some SQL to reject options that have already been selected ??
$restrictSQL = "";
if ($ele_value[9]) {
$restrictSQL = " AND (\n\t\t\t\tNOT EXISTS (\n\t\t\t\tSELECT 1 FROM " . $xoopsDB->prefix("formulize_" . $formObject->getVar('form_handle')) . " AS t4 WHERE t4.`" . $element->getVar('ele_handle') . "` LIKE CONCAT( '%,', t1.`entry_id` , ',%' ) AND t4.entry_id != " . intval($entry_id);
$restrictSQL .= $renderer->addEntryRestrictionSQL($ele_value[9], $id_form, $groups);
// pass in the flag about restriction scope, and the form id, and the groups
$restrictSQL .= " ) OR EXISTS (\n\t\t\t\tSELECT 1 FROM " . $xoopsDB->prefix("formulize_" . $formObject->getVar('form_handle')) . " AS t4 WHERE t4.`" . $element->getVar('ele_handle') . "` LIKE CONCAT( '%,', t1.`entry_id` , ',%' ) AND t4.entry_id = " . intval($entry_id);
$restrictSQL .= $renderer->addEntryRestrictionSQL($ele_value[9], $id_form, $groups);
$restrictSQL .= ") )";
}
static $cachedSourceValuesQ = array();
static $cachedSourceValuesAutocompleteFile = array();
static $cachedSourceValuesAutocompleteLength = array();
// setup the sort order based on ele_value[12], which is an element id number
$sortOrder = $ele_value[15] == 2 ? " DESC" : "ASC";
if ($ele_value[12] == "none" or !$ele_value[12]) {
$sortOrderClause = " ORDER BY t1.`{$sourceHandle}` {$sortOrder}";
} else {
list($sortHandle) = convertElementIdsToElementHandles(array($ele_value[12]), $sourceFormObject->getVar('id_form'));
$sortOrderClause = " ORDER BY t1.`{$sortHandle}` {$sortOrder}";
}
if ($pgroupsfilter) {
// if there is a groups filter, then join to the group ownership table
$sourceValuesQ = "SELECT t1.entry_id, t1.`" . $sourceHandle . "` FROM " . $xoopsDB->prefix("formulize_" . $sourceFormObject->getVar('form_handle')) . " AS t1, " . $xoopsDB->prefix("formulize_entry_owner_groups") . " AS t2 {$parentFormFrom} WHERE {$pgroupsfilter} {$conditionsfilter} {$conditionsfilter_oom} {$restrictSQL} GROUP BY t1.entry_id {$sortOrderClause}";
} else {
// otherwise just query the source table
$sourceValuesQ = "SELECT t1.entry_id, t1.`" . $sourceHandle . "` FROM " . $xoopsDB->prefix("formulize_" . $sourceFormObject->getVar('form_handle')) . " AS t1 {$parentFormFrom} WHERE t1.entry_id>0 {$conditionsfilter} {$conditionsfilter_oom} {$restrictSQL} GROUP BY t1.entry_id {$sortOrderClause}";
}
//print "$sourceValuesQ<br><br>";
if (!$isDisabled) {
// set the default selections, based on the entry_ids that have been selected as the defaults, if applicable
$hasNoValues = trim($boxproperties[2]) == "" ? true : false;
$useDefaultsWhenEntryHasNoValue = $ele_value[14];
if (($entry_id == "new" or $useDefaultsWhenEntryHasNoValue and $hasNoValues) and (is_array($ele_value[13]) and count($ele_value[13]) > 0 or $ele_value[13])) {
$defaultSelected = $ele_value[13];
} else {
$defaultSelected = "";
}
$form_ele = new XoopsFormSelect($caption, $markupName, $defaultSelected, $ele_value[0], $ele_value[1]);
$form_ele->setExtra("onchange=\"javascript:formulizechanged=1;\" jquerytag='{$markupName}'");
if ($ele_value[0] == 1) {
// add the initial default entry, singular or plural based on whether the box is one line or not.
$form_ele->addOption("none", _AM_FORMLINK_PICK);
}
} else {
$disabledHiddenValue = array();
$disabledOutputText = array();
}
if (!isset($cachedSourceValuesQ[$sourceValuesQ])) {
$element_handler = xoops_getmodulehandler('elements', 'formulize');
$sourceElementObject = $element_handler->get($boxproperties[1]);
if ($sourceElementObject->isLinked) {
// need to jump one more level back to get value that this value is pointing at
$sourceEleValue = $sourceElementObject->getVar('ele_value');
$originalSource = explode("#*=:*", $sourceEleValue[2]);
include_once XOOPS_ROOT_PATH . "/modules/formulize/class/data.php";
$data_handler = new formulizeDataHandler($originalSource[0]);
}
$reslinkedvaluesq = $xoopsDB->query($sourceValuesQ);
if ($reslinkedvaluesq) {
while ($rowlinkedvaluesq = $xoopsDB->fetchRow($reslinkedvaluesq)) {
if ($rowlinkedvaluesq[1] === "") {
continue;
}
if ($sourceElementObject->isLinked) {
$rowlinkedvaluesq[1] = $data_handler->getElementValueInEntry(trim($rowlinkedvaluesq[1], ","), $originalSource[1]);
}
$linkedElementOptions[$rowlinkedvaluesq[0]] = strip_tags($rowlinkedvaluesq[1]);
}
}
$cachedSourceValuesQ[$sourceValuesQ] = $linkedElementOptions;
/* ALTERED - 20100318 - freeform - jeff/julian - start */
if (!$isDisabled and $ele_value[8] == 1) {
// write the possible values to a cached file so we can look them up easily when we need them, don't want to actually send them to the browser, since it could be huge, but don't want to replicate all the logic that has already gathered the values for us, each time there's an ajax request
$cachedLinkedOptionsFileName = "formulize_linkedOptions_" . str_replace(".", "", microtime(true));
formulize_scandirAndClean(XOOPS_ROOT_PATH . "/cache/", "formulize_linkedOptions_");
$cachedLinkedOptions = fopen(XOOPS_ROOT_PATH . "/cache/{$cachedLinkedOptionsFileName}", "w");
fwrite($cachedLinkedOptions, "<?php\n\r");
$maxLength = 0;
foreach ($linkedElementOptions as $id => $text) {
$thisTextLength = strlen($text);
$maxLength = $thisTextLength > $maxLength ? $thisTextLength : $maxLength;
$text = str_replace("\$", "\\\$", $text);
$quotedText = "\"" . str_replace("\"", "\\\"", html_entity_decode($text, ENT_QUOTES)) . "\"";
$singleQuotedText = str_replace("'", "\\'", "[{$quotedText},{$id}]");
fwrite($cachedLinkedOptions, "if(stristr({$quotedText}, \$term)){ \$found[]='" . $singleQuotedText . "'; }\n");
}
fwrite($cachedLinkedOptions, "?>");
fclose($cachedLinkedOptions);
$cachedSourceValuesAutocompleteFile[$sourceValuesQ] = $cachedLinkedOptionsFileName;
$cachedSourceValuesAutocompleteLength[$sourceValuesQ] = $maxLength;
}
}
// if we're rendering an autocomplete box
if (!$isDisabled and $ele_value[8] == 1) {
// do autocomplete rendering logic here
if ($boxproperties[2]) {
$default_value = trim($boxproperties[2], ",");
$data_handler_autocomplete = new formulizeDataHandler($boxproperties[0]);
$default_value_user = $data_handler_autocomplete->getElementValueInEntry(trim($boxproperties[2], ","), $boxproperties[1]);
}
$renderedComboBox = $renderer->formulize_renderQuickSelect($markupName, $cachedSourceValuesAutocompleteFile[$sourceValuesQ], $default_value, $default_value_user, $cachedSourceValuesAutocompleteLength[$sourceValuesQ]);
$form_ele = new xoopsFormLabel($caption, $renderedComboBox);
$form_ele->setDescription(html_entity_decode($ele_desc, ENT_QUOTES));
}
// only do this if we're rendering a normal element, that is not disabled
if (!$isDisabled and $ele_value[8] == 0) {
$form_ele->addOptionArray($cachedSourceValuesQ[$sourceValuesQ]);
}
// only do this if we're rendering a normal element (may be disabled)
if ($ele_value[8] == 0) {
foreach ($sourceEntryIds as $thisEntryId) {
if (!$isDisabled) {
$form_ele->setValue($thisEntryId);
} else {
$disabledName = $ele_value[1] ? $markupName . "[]" : $markupName;
$disabledHiddenValue[] = "<input type=hidden name=\"{$disabledName}\" value=\"{$thisEntryId}\">";
$disabledOutputText[] = $cachedSourceValuesQ[$sourceValuesQ][$thisEntryId];
// the text value of the option(s) that are currently selected
}
}
}
if ($isDisabled) {
$form_ele = new XoopsFormLabel($caption, implode(", ", $disabledOutputText) . implode("\n", $disabledHiddenValue));
$form_ele->setDescription(html_entity_decode($ele_desc, ENT_QUOTES));
} elseif ($ele_value[8] == 0) {
// this is a hack because the size attribute is private and only has a getSize and not a setSize, setting the size can only be done through the constructor
$count = count($form_ele->getOptions());
$size = $ele_value[0];
$new_size = $count < $size ? $count : $size;
$form_ele->_size = $new_size;
}
/* ALTERED - 20100318 - freeform - jeff/julian - stop */
} else {
// or if we don't have a link...
$selected = array();
$options = array();
$disabledOutputText = array();
$disabledHiddenValue = array();
$disabledHiddenValues = "";
// add the initial default entry, singular or plural based on whether the box is one line or not.
if ($ele_value[0] == 1) {
$options["none"] = _AM_FORMLINK_PICK;
}
// set opt_count to 1 if the box is NOT a multiple selection box. -- jwe 7/26/04
if ($ele_value[1]) {
$opt_count = 0;
} else {
$opt_count = 1;
}
$hiddenOutOfRangeValuesToWrite = array();
while ($i = each($ele_value[2])) {
// handle requests for full names or usernames -- will only kick in if there is no saved value (otherwise ele_value will have been rewritten by the loadValues function in the form display
// note: if the user is about to make a proxy entry, then the list of users displayed will be from their own groups, but not from the groups of the user they are about to make a proxy entry for. ie: until the proxy user is known, the choice of users for this list can only be based on the current user. This could lead to confusing or buggy situations, such as users being selected who are outside the groups of the proxy user (who will become the owner) and so there will be an invalid value stored for this element in the db.
if ($i['key'] === "{FULLNAMES}" or $i['key'] === "{USERNAMES}") {
// ADDED June 18 2005 to handle pulling in usernames for the user's group(s)
if ($i['key'] === "{FULLNAMES}") {
$nametype = "name";
}
if ($i['key'] === "{USERNAMES}") {
$nametype = "uname";
}
if (isset($ele_value[2]['{OWNERGROUPS}'])) {
$groups = $ele_value[2]['{OWNERGROUPS}'];
} else {
global $regcode;
if ($regcode) {
// if we're dealing with a registration code, determine group membership based on the code
$reggroupsq = q("SELECT reg_codes_groups FROM " . XOOPS_DB_PREFIX . "_reg_codes WHERE reg_codes_code=\"{$regcode}\"");
$groups = explode("&8(%\$", $reggroupsq[0]['reg_codes_groups']);
if ($groups[0] === "") {
unset($groups);
}
// if a code has no groups associated with it, then kill the null value that will be in position 0 in the groups array.
$groups[] = XOOPS_GROUP_USERS;
$groups[] = XOOPS_GROUP_ANONYMOUS;
} else {
global $xoopsUser;
$groups = $xoopsUser ? $xoopsUser->getGroups() : array(0 => XOOPS_GROUP_ANONYMOUS);
}
}
$pgroups = array();
if ($ele_value[3]) {
$scopegroups = explode(",", $ele_value[3]);
if (!in_array("all", $scopegroups)) {
if ($ele_value[4]) {
// limit by users's groups
foreach ($groups as $gid) {
// want to loop so we can get rid of reg users group simply
if ($gid == XOOPS_GROUP_USERS) {
continue;
}
if (in_array($gid, $scopegroups)) {
$pgroups[] = $gid;
}
}
if (count($pgroups) > 0) {
unset($groups);
$groups = $pgroups;
} else {
$groups = array();
}
} else {
// don't limit by user's groups
$groups = $scopegroups;
}
} else {
// use all
if (!$ele_value[4]) {
// really use all (otherwise, we're just going with all user's groups, so existing value of $groups will be okay
unset($groups);
global $xoopsDB;
$allgroupsq = q("SELECT groupid FROM " . $xoopsDB->prefix("groups"));
// . " WHERE groupid != " . XOOPS_GROUP_USERS); // removed exclusion of registered users group March 18 2009, since it doesn't make sense in this situation. All groups should mean everyone, period.
foreach ($allgroupsq as $thisgid) {
$groups[] = $thisgid['groupid'];
}
}
}
}
$namelist = gatherNames($groups, $nametype, $ele_value[6], $ele_value[5]);
foreach ($namelist as $auid => $aname) {
$options[$auid] = $aname;
}
} elseif ($i['key'] === "{SELECTEDNAMES}") {
// loadValue in formDisplay will create a second option with this key that contains an array of the selected values
$selected = $i['value'];
} elseif ($i['key'] === "{OWNERGROUPS}") {
// do nothing with this piece of metadata that gets set in loadValue, since it's used above
} else {
// regular selection list....
$options[$opt_count] = $myts->stripSlashesGPC($i['key']);
if (strstr($i['key'], _formulize_OUTOFRANGE_DATA)) {
$hiddenOutOfRangeValuesToWrite[$opt_count] = str_replace(_formulize_OUTOFRANGE_DATA, "", $i['key']);
// if this is an out of range value, grab the actual value so we can stick it in a hidden element later
}
if ($i['value'] > 0) {
$selected[] = $opt_count;
}
$opt_count++;
}
}
$count = count($options);
$size = $ele_value[0];
$final_size = $count < $size ? $count : $size;
$form_ele1 = new XoopsFormSelect($caption, $markupName, $selected, $final_size, $ele_value[1]);
$form_ele1->setExtra("onchange=\"javascript:formulizechanged=1;\" jquerytag='{$markupName}'");
// must check the options for uitext before adding to the element -- aug 25, 2007
foreach ($options as $okey => $ovalue) {
$options[$okey] = formulize_swapUIText($ovalue, $element->getVar('ele_uitext'));
}
$form_ele1->addOptionArray($options);
if ($selected) {
if (is_array($selected)) {
$hiddenElementName = $ele_value[1] ? $form_ele1->getName() . "[]" : $form_ele1->getName();
foreach ($selected as $thisSelected) {
$disabledOutputText[] = $options[$thisSelected];
$disabledHiddenValue[] = "<input type=hidden name=\"{$hiddenElementName}\" value=\"{$thisSelected}\">";
}
} elseif ($ele_value[1]) {
// need to keep [] in the hidden element name if multiple values are expected, even if only one is chosen
$disabledOutputText[] = $options[$selected];
$disabledHiddenValue[] = "<input type=hidden name=\"" . $form_ele1->getName() . "[]\" value=\"{$selected}\">";
} else {
$disabledOutputText[] = $options[$selected];
$disabledHiddenValue[] = "<input type=hidden name=\"" . $form_ele1->getName() . "\" value=\"{$selected}\">";
}
}
$renderedHoorvs = "";
if (count($hiddenOutOfRangeValuesToWrite) > 0) {
foreach ($hiddenOutOfRangeValuesToWrite as $hoorKey => $hoorValue) {
$thisHoorv = new xoopsFormHidden('formulize_hoorv_' . $true_ele_id . '_' . $hoorKey, $hoorValue);
$renderedHoorvs .= $thisHoorv->render() . "\n";
unset($thisHoorv);
}
}
if ($isDisabled) {
$disabledHiddenValues = implode("\n", $disabledHiddenValue);
// glue the individual value elements together into a set of values
$renderedElement = implode(", ", $disabledOutputText);
} elseif ($ele_value[8] == 1) {
// autocomplete construction: make sure that $renderedElement is the final output of this chunk of code
// write the possible values to a cached file so we can look them up easily when we need them, don't want to actually send them to the browser, since it could be huge, but don't want to replicate all the logic that has already gathered the values for us, each time there's an ajax request
$cachedOptionsFileName = "formulize_Options_" . str_replace(".", "", microtime(true));
formulize_scandirAndClean(XOOPS_ROOT_PATH . "/cache/", "formulize_Options_");
$cachedOptions = fopen(XOOPS_ROOT_PATH . "/cache/{$cachedOptionsFileName}", "w");
fwrite($cachedOptions, "<?php\n\r");
$maxLength = 0;
foreach ($options as $id => $text) {
$thisTextLength = strlen($text);
$maxLength = $thisTextLength > $maxLength ? $thisTextLength : $maxLength;
//$quotedText = "\"".str_replace("\"", "\\\"", trim($text))."\"";
$quotedText = "\"" . str_replace("\"", "\\\"", $text) . "\"";
fwrite($cachedOptions, "if(stristr({$quotedText}, \$term)){ \$found[]='[{$quotedText},{$id}]'; }\n\r");
}
fwrite($cachedOptions, "?>");
fclose($cachedOptions);
//print_r($selected); print_r($options);
$defaultSelected = is_array($selected) ? $selected[0] : $selected;
$renderedComboBox = $renderer->formulize_renderQuickSelect($markupName, $cachedOptionsFileName, $defaultSelected, $options[$defaultSelected], $maxLength);
$form_ele2 = new xoopsFormLabel($caption, $renderedComboBox);
$renderedElement = $form_ele2->render();
} else {
// normal element
$renderedElement = $form_ele1->render();
}
$form_ele = new XoopsFormLabel($caption, "<nobr>{$renderedElement}</nobr>\n{$renderedHoorvs}\n{$disabledHiddenValues}\n");
$form_ele->setDescription(html_entity_decode($ele_desc, ENT_QUOTES));
}
// end of if we have a link on our hands. -- jwe 7/29/04
return $form_ele;
}
