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;
}
function drawSubLinks($subform_id, $sub_entries, $uid, $groups, $frid, $mid, $fid, $entry, $customCaption = "", $customElements = "", $defaultblanks = 0, $showViewButtons = 1, $captionsForHeadings = 0, $overrideOwnerOfNewEntries = "", $mainFormOwner = 0, $hideaddentries = "", $subformConditions = null, $subformElementId = 0, $rowsOrForms = 'row', $addEntriesText = _formulize_ADD_ENTRIES, $subform_element_object = null)
{
$nestedSubform = false;
if (isset($GLOBALS['formulize_inlineSubformFrid'])) {
$frid = $GLOBALS['formulize_inlineSubformFrid'];
$nestedSubform = true;
}
$member_handler = xoops_gethandler('member');
$gperm_handler = xoops_gethandler('groupperm');
$addEntriesText = $addEntriesText ? $addEntriesText : _formulize_ADD_ENTRIES;
global $xoopsDB, $nosubforms;
$GLOBALS['framework'] = $frid;
$form_handler = xoops_getmodulehandler('forms', 'formulize');
// limit the sub_entries array to just the entries that match the conditions, if any
if (is_array($subformConditions) and is_array($sub_entries[$subform_id])) {
list($conditionsFilter, $conditionsFilterOOM, $curlyBracketFormFrom) = buildConditionsFilterSQL($subformConditions, $subform_id, $entry, $mainFormOwner, $fid);
// pass in mainFormOwner as the comparison ID for evaluating {USER} so that the included entries are consistent when an admin looks at a set of entries made by someone else.
$subformObject = $form_handler->get($subform_id);
$sql = "SELECT entry_id FROM " . $xoopsDB->prefix("formulize_" . $subformObject->getVar('form_handle')) . "{$curlyBracketFormFrom} WHERE entry_id IN (" . implode(", ", $sub_entries[$subform_id]) . ") {$conditionsFilter} {$conditionsFilterOOM}";
$sub_entries[$subform_id] = array();
if ($res = $xoopsDB->query($sql)) {
while ($array = $xoopsDB->fetchArray($res)) {
$sub_entries[$subform_id][] = $array['entry_id'];
}
}
}
include_once XOOPS_ROOT_PATH . "/modules/formulize/include/extract.php";
$target_sub_to_use = (isset($_POST['target_sub']) and $_POST['target_sub'] != 0) ? $_POST['target_sub'] : $subform_id;
$elementq = q("SELECT fl_key1, fl_key2, fl_common_value, fl_form2_id FROM " . $xoopsDB->prefix("formulize_framework_links") . " WHERE fl_frame_id=" . intval($frid) . " AND fl_form2_id=" . intval($fid) . " AND fl_form1_id=" . intval($target_sub_to_use));
// element_to_write is used below in writing results of "add x entries" clicks, plus it is used for defaultblanks on first drawing blank entries, so we need to get this outside of the saving routine
if (count($elementq) > 0) {
$element_to_write = $elementq[0]['fl_key1'];
$value_source = $elementq[0]['fl_key2'];
$value_source_form = $elementq[0]['fl_form2_id'];
} else {
$elementq = q("SELECT fl_key2, fl_key1, fl_common_value, fl_form1_id FROM " . $xoopsDB->prefix("formulize_framework_links") . " WHERE fl_frame_id=" . intval($frid) . " AND fl_form1_id=" . intval($fid) . " AND fl_form2_id=" . intval($target_sub_to_use));
$element_to_write = $elementq[0]['fl_key2'];
$value_source = $elementq[0]['fl_key1'];
$value_source_form = $elementq[0]['fl_form1_id'];
}
if (0 == strlen($element_to_write)) {
error_log("Relationship {$frid} for subform {$subform_id} on form {$fid} is invalid.");
$to_return = array("c1" => "", "c2" => "", "sigle" => "");
global $xoopsUser;
if (is_object($xoopsUser) and in_array(XOOPS_GROUP_ADMIN, $xoopsUser->getGroups())) {
if (0 == $frid) {
$to_return['single'] = "This subform cannot be shown because no relationship is active.";
} else {
$to_return['single'] = "This subform cannot be shown because relationship {$frid} for subform " . "{$subform_id} on form {$fid} is invalid.";
}
}
return $to_return;
}
// check for adding of a sub entry, and handle accordingly -- added September 4 2006
static $subformInstance;
$subformInstance = !isset($subformInstance) ? 100 : $subformInstance;
$subformInstance++;
if ($_POST['target_sub'] and $_POST['target_sub'] == $subform_id and $_POST['target_sub_instance'] == $subformElementId . $subformInstance) {
// important we only do this on the run through for that particular sub form (hence target_sub == sfid), and also only for the specific instance of this subform on the page too, since not all entries may apply to all subform instances any longer with conditions in effect now
// need to handle things differently depending on whether it's a common value or a linked selectbox type of link
// uid links need to result in a "new" value in the displayElement boxes -- odd things will happen if people start adding linked values to entries that aren't theirs!
if ($element_to_write != 0) {
if ($elementq[0]['fl_common_value']) {
// grab the value from the parent element -- assume that it is a textbox of some kind!
if (isset($_POST['de_' . $value_source_form . '_' . $entry . '_' . $value_source])) {
$value_to_write = $_POST['de_' . $value_source_form . '_' . $entry . '_' . $value_source];
} else {
// get this entry and see what the source value is
$data_handler = new formulizeDataHandler($value_source_form);
$value_to_write = $data_handler->getElementValueInEntry($entry, $value_source);
}
} else {
$value_to_write = $entry;
}
$sub_entry_new = "";
for ($i = 0; $i < $_POST['numsubents']; $i++) {
// actually goahead and create the requested number of new sub entries...start with the key field, and then do all textboxes with defaults too...
//$subEntWritten = writeElementValue($_POST['target_sub'], $element_to_write, "new", $value_to_write, "", "", true); // Last param is override that allows direct writing to linked selectboxes if we have prepped the value first!
if ($overrideOwnerOfNewEntries) {
$creation_user_touse = $mainFormOwner;
} else {
$creation_user_touse = "";
}
$subEntWritten = writeElementValue($_POST['target_sub'], $element_to_write, "new", $value_to_write, $creation_user_touse, "", true);
// Last param is override that allows direct writing to linked selectboxes if we have prepped the value first!
$element_handler = xoops_getmodulehandler('elements', 'formulize');
if (!isset($elementsForDefaults)) {
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('ele_type', 'text'), 'OR');
$criteria->add(new Criteria('ele_type', 'textarea'), 'OR');
$criteria->add(new Criteria('ele_type', 'date'), 'OR');
$criteria->add(new Criteria('ele_type', 'radio'), 'OR');
$elementsForDefaults = $element_handler->getObjects($criteria, $_POST['target_sub']);
// get all the text or textarea elements in the form
}
foreach ($elementsForDefaults as $thisDefaultEle) {
// need to write in any default values for any text boxes or text areas that are in the subform. Perhaps other elements could be included too, but that would take too much work right now. (March 9 2009)
$defaultTextToWrite = "";
$ele_value_for_default = $thisDefaultEle->getVar('ele_value');
switch ($thisDefaultEle->getVar('ele_type')) {
case "text":
$defaultTextToWrite = getTextboxDefault($ele_value_for_default[2], $_POST['target_sub'], $subEntWritten);
// position 2 is default value for text boxes
break;
case "textarea":
$defaultTextToWrite = getTextboxDefault($ele_value_for_default[0], $_POST['target_sub'], $subEntWritten);
// position 0 is default value for text boxes
break;
case "date":
$defaultTextToWrite = getDateElementDefault($ele_value_for_default[0]);
if (false === $defaultTextToWrite) {
$defaultTextToWrite = "";
} else {
$defaultTextToWrite = date("c", $defaultTextToWrite);
}
break;
case "radio":
$thisDefaultEleValue = $thisDefaultEle->getVar('ele_value');
$defaultTextToWrite = array_search(1, $thisDefaultEleValue);
}
if ($defaultTextToWrite) {
writeElementValue($_POST['target_sub'], $thisDefaultEle->getVar('ele_id'), $subEntWritten, $defaultTextToWrite);
}
}
$sub_entry_written[] = $subEntWritten;
}
} else {
$sub_entry_new = "new";
// this happens in uid-link situations?
$sub_entry_written = "";
}
// need to also enforce any equals conditions that are on the subform element, if any, and assign those values to the entries that were just added
if (is_array($subformConditions)) {
$filterValues = array();
foreach ($subformConditions[1] as $i => $thisOp) {
if ($thisOp == "=" and $subformConditions[3][$i] != "oom" and $subformConditions[2][$i] != "{BLANK}") {
$conditionElementObject = $element_handler->get($subformConditions[0][$i]);
$filterValues[$subformConditions[0][$i]] = prepareLiteralTextForDB($conditionElementObject, $subformConditions[2][$i]);
}
}
if (count($filterValues) > 0) {
foreach ($sub_entry_written as $thisSubEntry) {
formulize_writeEntry($filterValues, $thisSubEntry);
}
}
}
}
// need to do a number of checks here, including looking for single status on subform, and not drawing in add another if there is an entry for a single
$sub_single_result = getSingle($subform_id, $uid, $groups, $member_handler, $gperm_handler, $mid);
$sub_single = $sub_single_result['flag'];
if ($sub_single) {
unset($sub_entries);
$sub_entries[$subform_id][0] = $sub_single_result['entry'];
}
if (!is_array($sub_entries[$subform_id])) {
$sub_entries[$subform_id] = array();
}
if ($sub_entry_new and !$sub_single and $_POST['target_sub'] == $subform_id) {
for ($i = 0; $i < $_POST['numsubents']; $i++) {
array_unshift($sub_entries[$subform_id], $sub_entry_new);
}
}
if (is_array($sub_entry_written) and !$sub_single and $_POST['target_sub'] == $subform_id) {
foreach ($sub_entry_written as $sew) {
array_unshift($sub_entries[$subform_id], $sew);
}
}
if (!$customCaption) {
// get the title of this subform
// help text removed for F4.0 RC2, this is an experiment
$subtitle = q("SELECT desc_form FROM " . $xoopsDB->prefix("formulize_id") . " WHERE id_form = {$subform_id}");
$col_one = "<p id=\"subform-caption-f{$fid}-sf{$subform_id}\" class=\"subform-caption\"><b>" . trans($subtitle[0]['desc_form']) . "</b></p>";
// <p style=\"font-weight: normal;\">" . _formulize_ADD_HELP;
} else {
$col_one = "<p id=\"subform-caption-f{$fid}-sf{$subform_id}\" class=\"subform-caption\"><b>" . trans($customCaption) . "</b></p>";
// <p style=\"font-weight: normal;\">" . _formulize_ADD_HELP;
}
/*if(intval($sub_entries[$subform_id][0]) != 0 OR $sub_entry_new OR is_array($sub_entry_written)) {
if(!$nosubforms) { $col_one .= "<br>" . _formulize_ADD_HELP2; }
$col_one .= "<br>" . _formulize_ADD_HELP3;
} */
// list the entries, including links to them and delete checkboxes
// get the headerlist for the subform and convert it into handles
// note big assumption/restriction that we are only using the first header found (ie: only specify one header for a sub form!)
// setup the array of elements to draw
if (is_array($customElements)) {
$headingDescriptions = array();
$headerq = q("SELECT ele_caption, ele_colhead, ele_desc, ele_id FROM " . $xoopsDB->prefix("formulize") . " WHERE ele_id IN (" . implode(", ", $customElements) . ") ORDER BY ele_order");
foreach ($headerq as $thisHeaderResult) {
$elementsToDraw[] = $thisHeaderResult['ele_id'];
$headingDescriptions[] = $thisHeaderResult['ele_desc'] ? $thisHeaderResult['ele_desc'] : "";
if ($captionsForHeadings) {
$headersToDraw[] = $thisHeaderResult['ele_caption'];
} else {
$headersToDraw[] = $thisHeaderResult['ele_colhead'] ? $thisHeaderResult['ele_colhead'] : $thisHeaderResult['ele_caption'];
}
}
} else {
$subHeaderList = getHeaderList($subform_id);
$subHeaderList1 = getHeaderList($subform_id, true);
if (isset($subHeaderList[0])) {
$headersToDraw[] = trans($subHeaderList[0]);
}
if (isset($subHeaderList[1])) {
$headersToDraw[] = trans($subHeaderList[1]);
}
if (isset($subHeaderList[2])) {
$headersToDraw[] = trans($subHeaderList[2]);
}
$elementsToDraw = array_slice($subHeaderList1, 0, 3);
}
$need_delete = 0;
$drawnHeadersOnce = false;
if ($rowsOrForms == "row" or $rowsOrForms == '') {
$col_two = "<table id=\"formulize-subform-table-{$subform_id}\" class=\"formulize-subform-table\">";
} else {
$col_two = "";
if (!strstr($_SERVER['PHP_SELF'], "formulize/printview.php")) {
$col_two .= "<div id=\"subform-{$subformElementId}\" class=\"subform-accordion-container\" subelementid=\"{$subformElementId}\" style=\"display: none;\">";
}
$col_two .= "<input type='hidden' name='subform_entry_" . $subformElementId . "_active' id='subform_entry_" . $subformElementId . "_active' value='' />";
include_once XOOPS_ROOT_PATH . "/modules/formulize/class/data.php";
$data_handler = new formulizeDataHandler($subform_id);
}
$deFrid = $frid ? $frid : "";
// need to set this up so we can pass it as part of the displayElement function, necessary to establish the framework in case this is a framework and no subform element is being used, just the default draw-in-the-one-to-many behaviour
// if there's been no form submission, and there's no sub_entries, and there are default blanks to show, then do everything differently -- sept 8 2007
if (!$_POST['form_submitted'] and count($sub_entries[$subform_id]) == 0 and $defaultblanks > 0 and ($rowsOrForms == "row" or $rowsOrForms == '')) {
for ($i = 0; $i < $defaultblanks; $i++) {
// nearly same header drawing code as in the 'else' for drawing regular entries
if (!$drawnHeadersOnce) {
$col_two .= "<tr><td>\n";
$col_two .= "<input type=\"hidden\" name=\"formulize_subformValueSource_{$subform_id}\" value=\"{$value_source}\">\n";
$col_two .= "<input type=\"hidden\" name=\"formulize_subformValueSourceForm_{$subform_id}\" value=\"{$value_source_form}\">\n";
$col_two .= "<input type=\"hidden\" name=\"formulize_subformValueSourceEntry_{$subform_id}\" value=\"{$entry}\">\n";
$col_two .= "<input type=\"hidden\" name=\"formulize_subformElementToWrite_{$subform_id}\" value=\"{$element_to_write}\">\n";
$col_two .= "<input type=\"hidden\" name=\"formulize_subformSourceType_{$subform_id}\" value=\"" . $elementq[0]['fl_common_value'] . "\">\n";
$col_two .= "<input type=\"hidden\" name=\"formulize_subformId_{$subform_id}\" value=\"{$subform_id}\">\n";
// this is probably redundant now that we're tracking sfid in the names of the other elements
$col_two .= "</td>\n";
foreach ($headersToDraw as $x => $thishead) {
if ($thishead) {
$headerHelpLinkPart1 = $headingDescriptions[$i] ? "<a href=\"#\" onclick=\"return false;\" alt=\"" . $headingDescriptions[$x] . "\" title=\"" . $headingDescriptions[$x] . "\">" : "";
$headerHelpLinkPart2 = $headerHelpLinkPart1 ? "</a>" : "";
$col_two .= "<th><p>{$headerHelpLinkPart1}<b>{$thishead}</b>{$headerHelpLinkPart2}</p></th>\n";
}
}
$col_two .= "</tr>\n";
$drawnHeadersOnce = true;
}
$col_two .= "<tr>\n<td>";
$col_two .= "</td>\n";
include_once XOOPS_ROOT_PATH . "/modules/formulize/include/elementdisplay.php";
foreach ($elementsToDraw as $thisele) {
if ($thisele) {
ob_start();
// critical that we *don't* ask for displayElement to return the element object, since this way the validation logic is passed back through the global space also (ugh). Otherwise, no validation logic possible for subforms.
$renderResult = displayElement($deFrid, $thisele, "subformCreateEntry_" . $i . "_" . $subformElementId);
$col_two_temp = ob_get_contents();
ob_end_clean();
if ($col_two_temp or $renderResult == "rendered") {
// only draw in a cell if there actually is an element rendered (some elements might be rendered as nothing (such as derived values)
$col_two .= "<td>{$col_two_temp}</td>\n";
} else {
$col_two .= "<td>******</td>";
}
}
}
$col_two .= "</tr>\n";
}
} elseif (count($sub_entries[$subform_id]) > 0) {
// need to figure out the proper order for the sub entries based on the properties set for this form
// for now, hard code to the word number field to suit the map site only
// if it's the word subform, then sort the entries differently
/*if($subform_id == 281) {
$sortClause = " fas_281, block_281, word_number ";
}
elseif ($subform_id == 283) {
$sortClause = " fas_283 ";
}
else {*/
$sortClause = " entry_id ";
//}
$sformObject = $form_handler->get($subform_id);
$subEntriesOrderSQL = "SELECT entry_id FROM " . $xoopsDB->prefix("formulize_" . $sformObject->getVar('form_handle')) . " WHERE entry_id IN (" . implode(",", $sub_entries[$subform_id]) . ") ORDER BY {$sortClause}";
if ($subEntriesOrderRes = $xoopsDB->query($subEntriesOrderSQL)) {
$sub_entries[$subform_id] = array();
while ($subEntriesOrderArray = $xoopsDB->fetchArray($subEntriesOrderRes)) {
$sub_entries[$subform_id][] = $subEntriesOrderArray['entry_id'];
}
}
$currentSubformInstance = $subformInstance;
foreach ($sub_entries[$subform_id] as $sub_ent) {
if ($sub_ent != "") {
if ($rowsOrForms == 'row' or $rowsOrForms == '') {
if (!$drawnHeadersOnce) {
$col_two .= "<tr><th></th>\n";
foreach ($headersToDraw as $i => $thishead) {
if ($thishead) {
$headerHelpLinkPart1 = $headingDescriptions[$i] ? "<a href=\"#\" onclick=\"return false;\" alt=\"" . $headingDescriptions[$i] . "\" title=\"" . $headingDescriptions[$i] . "\">" : "";
$headerHelpLinkPart2 = $headerHelpLinkPart1 ? "</a>" : "";
$col_two .= "<th><p>{$headerHelpLinkPart1}<b>{$thishead}</b>{$headerHelpLinkPart2}</p></th>\n";
}
}
$col_two .= "</tr>\n";
$drawnHeadersOnce = true;
}
$col_two .= "<tr>\n<td>";
// check to see if we draw a delete box or not
if ($sub_ent !== "new" and "hideaddentries" != $hideaddentries and formulizePermHandler::user_can_delete_entry($subform_id, $uid, $sub_ent) and !strstr($_SERVER['PHP_SELF'], "formulize/printview.php")) {
// note: if the add/delete entry buttons are hidden, then these delete checkboxes are hidden as well
$need_delete = 1;
$col_two .= "<input type=checkbox name=delbox{$sub_ent} value={$sub_ent}></input>";
}
$col_two .= "</td>\n";
include_once XOOPS_ROOT_PATH . "/modules/formulize/include/elementdisplay.php";
foreach ($elementsToDraw as $thisele) {
if ($thisele) {
ob_start();
// critical that we *don't* ask for displayElement to return the element object, since this way the validation logic is passed back through the global space also (ugh). Otherwise, no validation logic possible for subforms.
$renderResult = displayElement($deFrid, $thisele, $sub_ent);
$col_two_temp = ob_get_contents();
ob_end_clean();
if ($col_two_temp or $renderResult == "rendered") {
// only draw in a cell if there actually is an element rendered (some elements might be rendered as nothing (such as derived values)
$col_two .= "<td>{$col_two_temp}</td>\n";
} else {
$col_two .= "<td>******</td>";
}
}
}
if (!$nosubforms and $showViewButtons and !strstr($_SERVER['PHP_SELF'], "formulize/printview.php")) {
$col_two .= "<td><input type=button name=view" . $sub_ent . " value='" . _formulize_SUBFORM_VIEW . "' onclick=\"javascript:goSub('{$sub_ent}', '{$subform_id}');return false;\"></input></td>\n";
}
$col_two .= "</tr>\n";
} else {
// display the full form
$headerValues = array();
foreach ($elementsToDraw as $thisele) {
$value = $data_handler->getElementValueInEntry($sub_ent, $thisele);
$element_object = _getElementObject($thisele);
$value = prepvalues($value, $element_object->getVar("ele_handle"), $sub_ent);
if (is_array($value)) {
$value = implode(" - ", $value);
}
// may be an array if the element allows multiple selections (checkboxes, multiselect list boxes, etc)
$headerValues[] = $value;
}
$headerToWrite = implode(" — ", $headerValues);
if (str_replace(" — ", "", $headerToWrite) == "") {
$headerToWrite = _AM_ELE_SUBFORM_NEWENTRY_LABEL;
}
// check to see if we draw a delete box or not
$deleteBox = "";
if ($sub_ent !== "new" and formulizePermHandler::user_can_delete_entry($subform_id, $uid, $sub_ent) and !strstr($_SERVER['PHP_SELF'], "formulize/printview.php")) {
$need_delete = 1;
$deleteBox = "<input type=checkbox name=delbox{$sub_ent} value={$sub_ent}></input> ";
}
if (!strstr($_SERVER['PHP_SELF'], "formulize/printview.php")) {
$col_two .= "<div class=\"subform-deletebox\">{$deleteBox}</div><div class=\"subform-entry-container\" id=\"subform-" . $subform_id . "-" . "{$sub_ent}\">\r\n\t<p class=\"subform-header\"><a href=\"#\"><span class=\"accordion-name\">" . $headerToWrite . "</span></a></p>\r\n\t<div class=\"accordion-content content\">";
}
ob_start();
$GLOBALS['formulize_inlineSubformFrid'] = $frid;
if ($display_screen = get_display_screen_for_subform($subform_element_object)) {
$subScreen_handler = xoops_getmodulehandler('formScreen', 'formulize');
$subScreenObject = $subScreen_handler->get($display_screen);
$subScreen_handler->render($subScreenObject, $sub_ent, null, true);
} else {
// SHOULD CHANGE THIS TO USE THE DEFAULT SCREEN FOR THE FORM!!!!!!????
$renderResult = displayForm($subform_id, $sub_ent, "", "", "", "", "formElementsOnly");
}
if (!$nestedSubform) {
unset($GLOBALS['formulize_inlineSubformFrid']);
}
$col_two_temp = ob_get_contents();
ob_end_clean();
$col_two .= $col_two_temp;
if (!strstr($_SERVER['PHP_SELF'], "formulize/printview.php")) {
$col_two .= "</div>\n</div>\n";
}
}
}
}
$subformInstance = $currentSubformInstance;
// instance counter might have changed because the form could include other subforms
}
if ($rowsOrForms == 'row' or $rowsOrForms == '') {
// complete the table if we're drawing rows
$col_two .= "</table>";
} else {
if (!strstr($_SERVER['PHP_SELF'], "formulize/printview.php")) {
$col_two .= "</div>";
// close of the subform-accordion-container
}
static $jqueryUILoaded = false;
if (!$jqueryUILoaded) {
$col_two .= "<script type=\"text/javascript\" src=\"" . XOOPS_URL . "/modules/formulize/libraries/jquery/jquery-ui-1.8.2.custom.min.js\"></script>\n";
$col_two .= "<link rel=\"stylesheet\" type=\"text/css\" href=\"" . XOOPS_URL . "/modules/formulize/libraries/jquery/css/start/jquery-ui-1.8.2.custom.css\">\n";
$jqueryUILoaded = true;
}
$col_two .= "\n\r\n<script type=\"text/javascript\">\r\n\tjQuery(document).ready(function() {\r\n\t\tjQuery(\"#subform-{$subformElementId}\").accordion({\r\n\t\t\tautoHeight: false, // no fixed height for sections\r\n\t\t\tcollapsible: true, // sections can be collapsed\r\n\t\t\tactive: ";
if ($_POST['target_sub_instance'] == $subformElementId . $subformInstance and $_POST['target_sub'] == $subform_id) {
$col_two .= count($sub_entries[$subform_id]) - $_POST['numsubents'];
} elseif (is_numeric($_POST['subform_entry_' . $subformElementId . '_active'])) {
$col_two .= $_POST['subform_entry_' . $subformElementId . '_active'];
} else {
$col_two .= 'false';
}
$col_two .= ",\r\n\t\t\theader: \"> div > p.subform-header\"\r\n\t\t});\r\n\t\tjQuery(\"#subform-{$subformElementId}\").fadeIn();\r\n\t});\r\n</script>";
}
// end of if we're closing the subform inferface where entries are supposed to be collapsable forms
$deleteButton = "";
if ((count($sub_entries[$subform_id]) > 0 and $sub_entries[$subform_id][0] != "" or $sub_entry_new or is_array($sub_entry_written)) and $need_delete) {
$deleteButton = " <input type=button name=deletesubs value='" . _formulize_DELETE_CHECKED . "' onclick=\"javascript:sub_del('{$subform_id}');\">";
static $deletesubsflagIncluded = false;
if (!$deletesubsflagIncluded) {
$col_one .= "\n<input type=hidden name=deletesubsflag value=''>\n";
$deletesubsflagIncluded = true;
}
}
// if the 'add x entries button' should be hidden or visible
if ("hideaddentries" != $hideaddentries) {
$allowed_to_add_entries = false;
if ("subform" == $hideaddentries or 1 == $hideaddentries) {
// for compatability, accept '1' which is the old value which corresponds to the new use-subform-permissions (saved as "subform")
// user can add entries if they have permission on the sub form
$allowed_to_add_entries = $gperm_handler->checkRight("add_own_entry", $subform_id, $groups, $mid);
} else {
// user can add entries if they have permission on the main form
// the user should only be able to add subform entries if they can *edit* the main form entry, since adding a subform entry
// is like editing the main form entry. otherwise they could add subform entries on main form entries owned by other users
$allowed_to_add_entries = formulizePermHandler::user_can_edit_entry($fid, $uid, $entry);
}
if ($allowed_to_add_entries and !strstr($_SERVER['PHP_SELF'], "formulize/printview.php")) {
if (count($sub_entries[$subform_id]) == 1 and $sub_entries[$subform_id][0] === "" and $sub_single) {
$col_two .= "<p><input type=button name=addsub value='" . _formulize_ADD_ONE . "' onclick=\"javascript:add_sub('{$subform_id}', 1, " . $subformElementId . $subformInstance . ");\"></p>";
} elseif (!$sub_single) {
$use_simple_add_one_button = isset($subform_element_object->ele_value["simple_add_one_button"]) ? 1 == $subform_element_object->ele_value["simple_add_one_button"] : false;
$col_two .= "<p><input type=button name=addsub value='" . ($use_simple_add_one_button ? trans($subform_element_object->ele_value['simple_add_one_button_text']) : _formulize_ADD) . "' onclick=\"javascript:add_sub('{$subform_id}', window.document.formulize.addsubentries{$subform_id}{$subformElementId}{$subformInstance}.value, " . $subformElementId . $subformInstance . ");\">";
if ($use_simple_add_one_button) {
$col_two .= "<input type=\"hidden\" name=addsubentries{$subform_id}{$subformElementId}{$subformInstance} id=addsubentries{$subform_id}{$subformElementId}{$subformInstance} value=\"1\">";
} else {
$col_two .= "<input type=text name=addsubentries{$subform_id}{$subformElementId}{$subformInstance} id=addsubentries{$subform_id}{$subformElementId}{$subformInstance} value=1 size=2 maxlength=2>";
$col_two .= $addEntriesText;
}
$col_two .= $deleteButton . "</p>";
}
}
}
$to_return['c1'] = $col_one;
$to_return['c2'] = $col_two;
$to_return['single'] = $col_one . $col_two;
if (is_object($subform_element_object)) {
global $xoopsUser;
$show_element_edit_link = (is_object($xoopsUser) and in_array(XOOPS_GROUP_ADMIN, $xoopsUser->getGroups()));
$edit_link = "";
if ($show_element_edit_link) {
$edit_link = "<a class=\"formulize-element-edit-link\" tabindex=\"-1\" href=\"" . XOOPS_URL . "/modules/formulize/admin/ui.php?page=element&aid=0&ele_id=" . $subform_element_object->getVar("ele_id") . "\" target=\"_blank\">edit element</a>";
}
$to_return['single'] = "<div class=\"formulize-subform-" . $subform_element_object->getVar("ele_handle") . "\">{$edit_link} {$col_one} {$col_two}</div>";
}
return $to_return;
}
}
break;
case 'get_element_html':
include_once XOOPS_ROOT_PATH . "/modules/formulize/include/elementdisplay.php";
displayElement("", formulize_db_escape($_GET['param2']), intval($_GET['param3']));
break;
case 'get_element_value':
$handle = $_GET['param1'];
$entryId = intval($_GET['param3']);
include_once XOOPS_ROOT_PATH . "/modules/formulize/include/functions.php";
include_once XOOPS_ROOT_PATH . "/modules/formulize/include/extract.php";
include_once XOOPS_ROOT_PATH . "/modules/formulize/class/data.php";
$element_handler = xoops_getmodulehandler('elements', 'formulize');
$elementObject = $element_handler->get(formulize_db_escape($handle));
$data_handler = new formulizeDataHandler($elementObject->getVar('id_form'));
$dbValue = $data_handler->getElementValueInEntry($entryId, $handle);
$preppedValue = prepvalues($dbValue, $handle, $entryId);
print getHTMLForList($preppedValue, $handle, $entryId, 1);
// 1 is a flag to include the icon for switching to an editable element
break;
case 'get_element_row_html':
include_once XOOPS_ROOT_PATH . "/modules/formulize/include/functions.php";
include_once XOOPS_ROOT_PATH . "/modules/formulize/include/elementdisplay.php";
include_once XOOPS_ROOT_PATH . "/modules/formulize/include/extract.php";
$sendBackValue = array();
$element_handler = xoops_getmodulehandler('elements', 'formulize');
foreach ($_GET as $k => $v) {
if ($k == 'elementId' or $k == 'entryId' or $k == 'fid' or $k == 'frid' or substr($k, 0, 8) == 'onetoone') {
// serveral onetoone keys can be passed back too
if ($k == 'onetooneentries' or $k == 'onetoonefids') {
${$k} = unserialize($v);
$ele_display = $elementObject->getVar('ele_display');
$userCanAccessElement = false;
if ($ele_display == 1) {
$userCanAccessElement = true;
} elseif (strstr($ele_display, ",")) {
// comma separated list of groups
$allowedGroups = explode(",", trim($ele_display, ","));
if (array_intersect($groups, $allowedGroups)) {
$userCanAccessElement = true;
}
}
if ($userCanAccessElement) {
// USER IS ALLOWED TO SEE THIS ELEMENT
include_once XOOPS_ROOT_PATH . "/modules/formulize/class/data.php";
$data_handler = new formulizeDataHandler($fid);
$fileInfo = $data_handler->getElementValueInEntry($entry_id, $elementObject);
$fileInfo = unserialize($fileInfo);
$filePath = XOOPS_ROOT_PATH . "/uploads/formulize_" . $fid . "_" . $entry_id . "_" . $element_id . "/" . $fileInfo['name'];
if (file_exists($filePath)) {
header('Content-Description: File Transfer');
header('Content-Type: ' . $fileInfo['type']);
header('Content-Disposition: attachment; filename=' . $element_handler->getFileDisplayName($fileInfo['name']));
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
header('Content-Length: ' . $fileInfo['size']);
readfile($filePath);
exit;
} else {
include "../../header.php";
function generateHiddenElements($elements, $entry)
{
$hiddenElements = array();
foreach ($elements as $thisElement) {
// display these elements as hidden elements with the default value
$fid = $thisElement->getVar('id_form');
switch ($thisElement->getVar('ele_type')) {
case "radio":
if ($entry == "new") {
$indexer = 1;
foreach ($thisElement->getVar('ele_value') as $k => $v) {
if ($v == 1) {
$hiddenElements[$thisElement->getVar('ele_id')] = new xoopsFormHidden('de_' . $fid . '_' . $entry . '_' . $thisElement->getVar('ele_id'), $indexer);
}
$indexer++;
}
}
break;
case "checkbox":
if ($entry == "new") {
$indexer = 1;
foreach ($thisElement->getVar('ele_value') as $k => $v) {
if ($v == 1) {
$hiddenElements[$thisElement->getVar('ele_id')][] = new xoopsFormHidden('de_' . $fid . '_' . $entry . '_' . $thisElement->getVar('ele_id') . "[]", $indexer);
}
$indexer++;
}
} else {
$data_handler = new formulizeDataHandler($thisElement->getVar('id_form'));
$checkBoxOptions = $data_handler->getElementValueInEntry($entry, $thisElement);
$indexer = 1;
foreach ($thisElement->getVar('ele_value') as $k => $v) {
if (strstr($checkBoxOptions, $k)) {
$hiddenElements[$thisElement->getVar('ele_id')][] = new xoopsFormHidden('de_' . $fid . '_' . $entry . '_' . $thisElement->getVar('ele_id') . "[]", $indexer);
}
$indexer++;
}
}
break;
case "yn":
if ($entry == "new") {
$ele_value = $thisElement->getVar('ele_value');
// check to see if Yes is the value, and if so, set 1, otherwise, set 2. 2 is the value used when No is the selected option in YN radio buttons
$yesNoValue = $ele_value['_YES'] == 1 ? 1 : 2;
$hiddenElements[$thisElement->getVar('ele_id')] = new xoopsFormHidden('de_' . $fid . '_' . $entry . '_' . $thisElement->getVar('ele_id'), $yesNoValue);
}
break;
case "text":
if ($entry == "new") {
global $myts;
if (!$myts) {
$myts =& MyTextSanitizer::getInstance();
}
$ele_value = $thisElement->getVar('ele_value');
$hiddenElements[$thisElement->getVar('ele_id')] = new xoopsFormHidden('de_' . $fid . '_' . $entry . '_' . $thisElement->getVar('ele_id'), $myts->htmlSpecialChars(getTextboxDefault($ele_value[2], $thisElement->getVar('id_form'), $entry)));
} else {
include_once XOOPS_ROOT_PATH . "/modules/formulize/class/data.php";
$data_handler = new formulizeDataHandler($fid);
$hiddenElements[$thisElement->getVar('ele_id')] = new xoopsFormHidden('de_' . $fid . '_' . $entry . '_' . $thisElement->getVar('ele_id'), $data_handler->getElementValueInEntry($entry, $thisElement));
}
break;
case "textarea":
if ($entry == "new") {
global $myts;
if (!$myts) {
$myts =& MyTextSanitizer::getInstance();
}
$ele_value = $thisElement->getVar('ele_value');
$hiddenElements[$thisElement->getVar('ele_id')] = new xoopsFormHidden('de_' . $fid . '_' . $entry . '_' . $thisElement->getVar('ele_id'), $myts->htmlSpecialChars(getTextboxDefault($ele_value[0], $thisElement->getVar('id_form'), $entry)));
} else {
include_once XOOPS_ROOT_PATH . "/modules/class/data.php";
$data_handler = new formulizeDataHandler($fid);
$hiddenElements[$thisElement->getVar('ele_id')] = new xoopsFormHidden('de_' . $fid . '_' . $entry . '_' . $thisElement->getVar('ele_id'), $data_handler->getElementValueInEntry($entry, $thisElement));
}
break;
case "date":
if ($entry == "new") {
$ele_value = $thisElement->getVar('ele_value');
if ($ele_value[0] == "" or $ele_value[0] == "YYYY-mm-dd") {
$valueToUse = "";
} elseif (ereg_replace("[^A-Z{}]", "", $ele_value[0]) === "{TODAY}") {
$number = ereg_replace("[^0-9+-]", "", $ele_value[0]);
$valueToUse = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") + $number, date("Y")));
} else {
$valueToUse = $ele_value[0];
}
$hiddenElements[$thisElement->getVar('ele_id')] = new xoopsFormHidden('de_' . $fid . '_' . $entry . '_' . $thisElement->getVar('ele_id'), $valueToUse);
}
break;
}
}
return $hiddenElements;
}
