function getCtrlSearchTypeOptions($fName, $selOpt, $not)
{
$options = parent::getCtrlSearchTypeOptions($fName, $selOpt, $not);
if (strlen($fName)) {
$fType = GetEditFormat($fName, $this->tName);
} else {
$fType = EDIT_FORMAT_TEXT_FIELD;
}
if ($fType == EDIT_FORMAT_DATE || $fType == EDIT_FORMAT_TIME) {
$options .= "<option value=\"NOT Equals\" " . ($selOpt == "Equals" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_EQUALS") . "</option>";
$options .= "<option value=\"NOT More than\" " . ($selOpt == "More than" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_MORE_THAN") . "</option>";
$options .= "<option value=\"NOT Less than\" " . ($selOpt == "Less than" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_LESS_THAN") . "</option>";
$options .= "<option value=\"NOT Between\" " . ($selOpt == "Between" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_BETWEEN") . "</option>";
$options .= "<option value=\"NOT Empty\" " . ($selOpt == "Empty" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_EMPTY") . "</option>";
} elseif ($fType == EDIT_FORMAT_LOOKUP_WIZARD) {
if (Multiselect($fName, $this->tName)) {
$options .= "<OPTION value=\"NOT Contains\" " . ($selOpt == "Contains" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_CONTAINS") . "</option>";
} else {
$options .= "<OPTION value=\"NOT Equals\" " . ($selOpt == "Equals" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_EQUALS") . "</option>";
}
} elseif ($fType == EDIT_FORMAT_TEXT_FIELD || $fType == EDIT_FORMAT_TEXT_AREA || $fType == EDIT_FORMAT_PASSWORD || $fType == EDIT_FORMAT_HIDDEN || $fType == EDIT_FORMAT_READONLY) {
$options .= "<option value=\"NOT Contains\" " . ($selOpt == "Contains" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_CONTAINS") . "</option>";
$options .= "<option value=\"NOT Equals\" " . ($selOpt == "Equals" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_EQUALS") . "</option>";
$options .= "<option value=\"NOT Starts with\" " . ($selOpt == "Starts with" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_STARTS_WITH") . "</option>";
$options .= "<option value=\"NOT More than\" " . ($selOpt == "More than" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_MORE_THAN") . "</option>";
$options .= "<option value=\"NOT Less than\" " . ($selOpt == "Less than" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_LESS_THAN") . "</option>";
$options .= "<option value=\"NOT Between\" " . ($selOpt == "Between" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_BETWEEN") . "</option>";
$options .= "<option value=\"NOT Empty\" " . ($selOpt == "Empty" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_EMPTY") . "</option>";
} else {
$options .= "<option value=\"NOT Equals\" " . ($selOpt == "Equals" && $not ? "selected" : "") . ">" . mlang_message("SEARCH_NOT_EQUALS") . "</option>";
}
return $options;
}
function fillGroupsArr()
{
// select groups list
$this->groupsArr[] = array(-1, "<" . mlang_message("AA_GROUP_ADMIN") . ">");
$this->groupsArr[] = array(-2, "<" . mlang_message("AA_GROUP_DEFAULT") . ">");
$this->groupsArr[] = array(-3, "<" . mlang_message("AA_GROUP_GUEST") . ">");
$trs = db_query("select GroupID,Label from [uggroups] order by Label", $this->conn);
while ($tdata = db_fetch_numarray($trs)) {
$this->groupsArr[] = array($tdata[0], $tdata[1]);
}
}
$keylink = "";
$k = 0;
foreach ($keys as $idx => $val) {
if ($k != 0) {
$keylink .= "&";
}
$keylink .= "editid" . ++$k . "=" . htmlspecialchars(rawurlencode(@$val));
}
$permis = $pageObject->getPermissions();
if (count($keys)) {
$message .= "</br>";
if (GetTableData($strTableName, ".edit", false) && $permis['edit']) {
$message .= ' <a href=\'User_Roles_edit.php?' . $keylink . '\'>' . mlang_message("EDIT") . '</a> ';
}
if (GetTableData($strTableName, ".view", false) && $permis['search']) {
$message .= ' <a href=\'User_Roles_view.php?' . $keylink . '\'>' . mlang_message("VIEW") . '</a> ';
}
}
$mesClass = "mes_ok";
}
} elseif ($inlineadd != ADD_INLINE) {
$mesClass = "mes_not";
}
} else {
$message = $usermessage;
$status = "DECLINED";
$readavalues = true;
}
}
$message = "<div class='message " . $mesClass . "'>" . $message . "</div>";
// PRG rule, to avoid POSTDATA resend
/**
* Calcs pagination info
*
*/
function buildPagination()
{
// hide colunm headers if needed
$this->recordsOnPage = $this->numRowsFromSQL - ($this->myPage - 1) * $this->pageSize;
if ($this->recordsOnPage > $this->pageSize && $this->pageSize != -1) {
$this->recordsOnPage = $this->pageSize;
}
$this->colsOnPage = $this->recsPerRowList;
if ($this->colsOnPage > $this->recordsOnPage) {
$this->colsOnPage = $this->recordsOnPage;
}
if ($this->colsOnPage < 1) {
$this->colsOnPage = 1;
}
// Pagination:
if (!$this->numRowsFromSQL && $this->deleteMessage == '') {
$this->rowsFound = false;
$message = ($this->is508 == true ? "<a name=\"skipdata\"></a>" : "") . mlang_message("NO_RECORDS");
$message = "<span name=\"notfound_message" . $this->id . "\">" . $message . "</span>";
$this->xt->assign("message", $message);
$this->xt->assign("message_block", true);
} else {
$this->rowsFound = true;
$maxRecords = $this->numRowsFromSQL;
$this->xt->assign("message_block", false);
if ($this->listAjax) {
$this->xt->assign("message_block", true);
$this->xt->displayBrickHidden("message");
} else {
if ($this->deleteMessage != '') {
$this->xt->assign("message_block", true);
}
}
$this->xt->assign("records_found", $this->numRowsFromSQL);
if ($this->pageSize && $this->pageSize != -1) {
$this->maxPages = ceil($maxRecords / $this->pageSize);
}
if ($this->myPage > $this->maxPages) {
$this->myPage = $this->maxPages;
}
if ($this->myPage < 1) {
$this->myPage = 1;
}
$this->jsSettings["tableSettings"][$this->tName]['maxPages'] = $this->maxPages;
$this->maxRecs = $this->pageSize;
$this->xt->assign("page", $this->myPage);
$this->xt->assign("maxpages", $this->maxPages);
$this->xt->assign("pagination_block", false);
// write pagination
if ($this->maxPages > 1) {
$this->xt->assign("pagination_block", true);
$pagination = "<table rows='1' cols='1' align='center' width='auto' border='0' name='paginationTable" . $this->id . "'>";
$pagination .= "<tr valign='center'><td align='center'>";
$counterstart = $this->myPage - 9;
if ($this->myPage % 10) {
$counterstart = $this->myPage - $this->myPage % 10 + 1;
}
$counterend = $counterstart + 9;
if ($counterend > $this->maxPages) {
$counterend = $this->maxPages;
}
if ($counterstart != 1) {
$pagination .= $this->getPaginationLink(1, mlang_message("FIRST")) . " : ";
$pagination .= $this->getPaginationLink($counterstart - 1, mlang_message("PREVIOUS")) . " ";
}
$pagination .= "<b>[</b>";
for ($counter = $counterstart; $counter <= $counterend; $counter++) {
if ($counter != $this->myPage) {
$pagination .= " " . $this->getPaginationLink($counter, $counter, true);
} else {
$pagination .= " <b>" . $counter . "</b>";
}
}
$pagination .= " <b>]</b>";
if ($counterend != $this->maxPages) {
$pagination .= " " . $this->getPaginationLink($counterend + 1, mlang_message("NEXT")) . " : ";
$pagination .= " " . $this->getPaginationLink($this->maxPages, mlang_message("LAST"));
}
$pagination .= "</td></tr></table>";
$this->xt->assign("pagination", $pagination);
} elseif ($this->listAjax) {
$this->xt->assign("pagination_block", true);
$this->xt->displayBrickHidden("pagination");
}
}
}
$keylink = "";
$k = 0;
foreach ($keys as $idx => $val) {
if ($k != 0) {
$keylink .= "&";
}
$keylink .= "editid" . ++$k . "=" . htmlspecialchars(rawurlencode(@$val));
}
$permis = $pageObject->getPermissions();
if (count($keys)) {
$message .= "</br>";
if (GetTableData($strTableName, ".edit", false) && $permis['edit']) {
$message .= ' <a href=\'LU_Module_Status_edit.php?' . $keylink . '\'>' . mlang_message("EDIT") . '</a> ';
}
if (GetTableData($strTableName, ".view", false) && $permis['search']) {
$message .= ' <a href=\'LU_Module_Status_view.php?' . $keylink . '\'>' . mlang_message("VIEW") . '</a> ';
}
}
$mesClass = "mes_ok";
}
} elseif ($inlineadd != ADD_INLINE) {
$mesClass = "mes_not";
}
} else {
$message = $usermessage;
$status = "DECLINED";
$readavalues = true;
}
}
$message = "<div class='message " . $mesClass . "'>" . $message . "</div>";
// PRG rule, to avoid POSTDATA resend
function xt_process_template(&$xt, $str)
{
// parse template file tag by tag
$start = 0;
$literal = false;
$len = strlen($str);
while (true) {
$pos = strpos($str, "{", $start);
if ($pos === false) {
echo substr($str, $start, $len - $start);
break;
}
$section = false;
$var = false;
$message = false;
if (substr($str, $pos + 1, 6) == "BEGIN ") {
$section = true;
} elseif (substr($str, $pos + 1, 1) == '$') {
$var = true;
} elseif (substr($str, $pos + 1, 14) == 'mlang_message ') {
$message = true;
} else {
// no tag, just '{' char
echo substr($str, $start, $pos - $start + 1);
$start = $pos + 1;
continue;
}
echo substr($str, $start, $pos - $start);
if ($section) {
// section
$endpos = strpos($str, "}", $pos);
if ($endpos === false) {
$xt->report_error("Page is broken");
return;
}
$section_name = trim(substr($str, $pos + 7, $endpos - $pos - 7));
$endtag = "{END " . $section_name . "}";
$endpos1 = strpos($str, $endtag, $endpos);
if ($endpos1 === false) {
echo "End tag not found:" . htmlspecialchars($endtag);
$xt->report_error("Page is broken");
return;
}
$section = substr($str, $endpos + 1, $endpos1 - $endpos - 1);
$start = $endpos1 + strlen($endtag);
$var = xt_getvar($xt, $section_name);
if ($var === false) {
continue;
}
$begin = "";
$end = "";
if (is_array($var)) {
$begin = @$var["begin"];
$end = @$var["end"];
$var = @$var["data"];
}
if (!is_array($var)) {
// if section
echo $begin;
xt_process_template($xt, $section);
$xt->processVar($end, $varparams);
} else {
// foreach section
echo $begin;
$keys = array_keys($var);
foreach ($keys as $i) {
$xt->xt_stack[] =& $var[$i];
if (is_array($var[$i]) && array_key_exists("begin", $var[$i])) {
echo $var[$i]["begin"];
}
xt_process_template($xt, $section);
array_pop($xt->xt_stack);
if (is_array($var[$i]) && array_key_exists("end", $var[$i])) {
echo $var[$i]["end"];
}
}
$xt->processVar($end, $varparams);
}
} elseif ($var) {
// display a variable or call a function
$endpos = strpos($str, "}", $pos);
if ($endpos === false) {
$xt->report_error("Page is broken");
return;
}
$varparams = array();
$var_name = trim(substr($str, $pos + 2, $endpos - $pos - 2));
if (strpos($var_name, " ") !== FALSE) {
$varparams = explode(" ", $var_name);
$var_name = $varparams[0];
unset($varparams[0]);
}
$start = $endpos + 1;
$var = xt_getvar($xt, $var_name);
if ($var === false) {
continue;
}
$xt->processVar($var, $varparams);
} elseif ($message) {
$endpos = strpos($str, "}", $pos);
if ($endpos === false) {
$xt->report_error("Page is broken");
return;
}
$tag = trim(substr($str, $pos + 15, $endpos - $pos - 15));
$start = $endpos + 1;
echo htmlspecialchars(mlang_message($tag));
}
}
}
$layout->skins["details"] = "empty";
$layout->blocks["top"][] = "details";
$page_layouts["Customers_edit"] = $layout;
if (sizeof($_POST) == 0 && postvalue('ferror') && !postvalue("editid1")) {
$returnJSON['success'] = false;
$returnJSON['message'] = mlang_message("INLINE_ERROR");
$returnJSON['fatalError'] = true;
echo "<textarea>" . htmlspecialchars(my_json_encode($returnJSON)) . "</textarea>";
exit;
} else {
if (sizeof($_POST) == 0 && postvalue('ferror') && postvalue("editid1")) {
if (postvalue('fly')) {
echo -1;
exit;
} else {
$_SESSION["message_edit"] = "<< " . mlang_message("INLINE_ERROR") . " >>";
}
}
}
/////////////////////////////////////////////////////////////
//init variables
/////////////////////////////////////////////////////////////
if (postvalue("editType") == "inline") {
$inlineedit = EDIT_INLINE;
} elseif (postvalue("editType") == EDIT_POPUP) {
$inlineedit = EDIT_POPUP;
} else {
$inlineedit = EDIT_SIMPLE;
}
$id = postvalue("id");
if (intval($id) == 0) {
$keylink = "";
$k = 0;
foreach ($keys as $idx => $val) {
if ($k != 0) {
$keylink .= "&";
}
$keylink .= "editid" . ++$k . "=" . htmlspecialchars(rawurlencode(@$val));
}
$permis = $pageObject->getPermissions();
if (count($keys)) {
$message .= "</br>";
if (GetTableData($strTableName, ".edit", false) && $permis['edit']) {
$message .= ' <a href=\'System_Users_edit.php?' . $keylink . '\'>' . mlang_message("EDIT") . '</a> ';
}
if (GetTableData($strTableName, ".view", false) && $permis['search']) {
$message .= ' <a href=\'System_Users_view.php?' . $keylink . '\'>' . mlang_message("VIEW") . '</a> ';
}
}
$mesClass = "mes_ok";
}
} elseif ($inlineadd != ADD_INLINE) {
$mesClass = "mes_not";
}
} else {
$message = $usermessage;
$status = "DECLINED";
$readavalues = true;
}
}
$message = "<div class='message " . $mesClass . "'>" . $message . "</div>";
// PRG rule, to avoid POSTDATA resend
/**
* Add common html code for all modes on list page
*/
function addCommonHtml()
{
$this->body["begin"] .= "<div id=\"search_suggest\" class=\"search_suggest\"></div>";
if ($this->is508) {
$this->body["begin"] .= "<a href=\"#skipdata\" title=\"" . mlang_message("508_SKIP_DATA") . "\" class=\"runner-s508\">" . mlang_message("508_SKIP_DATA") . "</a>";
$this->body["begin"] .= "<a href=\"#skipmenu\" title=\"" . mlang_message("508_SKIP_MENU") . "\" class=\"runner-s508\">" . mlang_message("508_SKIP_MENU") . "</a>";
$this->body["begin"] .= "<a href=\"#skipsearch\" title=\"" . mlang_message("508_SKIP_SEARCH") . "\" class=\"runner-s508\">" . mlang_message("508_SKIP_SEARCH") . "</a>";
$this->body["begin"] .= "<a href=\"templates/helpshortcut.htm\" title=\"" . mlang_message("508_HELP") . "\" class=\"runner-s508\">" . mlang_message("508_HELP") . "</a>";
}
//prepare for dispaly master table info on details table
$this->displayMasterTableInfo();
}
/**
* Search panel on list template handler
*
* @param array $params
*/
function DisplaySearchPanel(&$params)
{
global $gLoadSearchControls;
$dispNoneStyle = 'style="display: none;"';
$xt = new Xtempl();
$xt->assign('searchPanel', $this->isDisplaySearchPanel);
$xt->assign('id', $this->id);
// search panel radio button assign
$searchRadio = $this->searchControlBuilder->getSearchRadio();
$xt->assign_section("all_checkbox_label", $searchRadio['all_checkbox_label'][0], $searchRadio['all_checkbox_label'][1]);
$xt->assign_section("any_checkbox_label", $searchRadio['any_checkbox_label'][0], $searchRadio['any_checkbox_label'][1]);
$xt->assignbyref("all_checkbox", $searchRadio['all_checkbox']);
$xt->assignbyref("any_checkbox", $searchRadio['any_checkbox']);
$xt->assign("searchbutton_attrs", "id=\"searchButton" . $this->id . "\" ");
$showHideOpt_mess = $this->srchPanelAttrs['ctrlTypeComboStatus'] ? mlang_message("SEARCH_HIDE_OPTIONS_BUTTON") : mlang_message("SEARCH_SHOW_OPTIONS_BUTTON");
// show hide search type opt message
$xt->assign("showHideOpt_mess", $showHideOpt_mess);
$xt->assign("srchOpt_attrs", 'style="display: none;"');
if ($this->searchClauseObj->getUsedCtrlsCount() > 0) {
$xt->assign("srchCritTopCont_attrs", '');
} else {
$xt->assign("srchCritTopCont_attrs", 'style="display: none;"');
}
if ($this->searchClauseObj->getUsedCtrlsCount() > 1) {
$xt->assign("srchCritBottomCont_attrs", '');
} else {
$xt->assign("srchCritBottomCont_attrs", 'style="display: none;"');
}
if ($this->searchClauseObj->getUsedCtrlsCount() > 0) {
$xt->assign("bottomSearchButt_attrs", '');
} else {
$xt->assign("bottomSearchButt_attrs", 'style="display: none;"');
}
// array for assign
$srchCtrlBlocksArr = array();
$recId = $this->pageObj->genId();
// build search controls for each field, first we need to build used controls, because cached must have last index
for ($j = 0; $j < count($this->allSearchFields); $j++) {
$this->pageObj->fillFieldToolTips($this->allSearchFields[$j]);
$xt->assign("addSearch_" . GoodFieldName($this->allSearchFields[$j]), true);
$srchFields = $this->searchClauseObj->getSearchCtrlParams($this->allSearchFields[$j]);
$ctrlInd = 0;
$isFieldNeedSecCtrl = $this->searchControlBuilder->isNeedSecondCtrl($this->allSearchFields[$j]);
// add field that should be always shown on panel
if (!count($srchFields) && in_array($this->allSearchFields[$j], $this->panelSearchFields)) {
$srchFields[] = array('opt' => '', 'not' => '', 'value1' => '', 'value2' => '');
}
// build used ctrls
for ($i = 0; $i < count($srchFields); $i++) {
// build used ctrl
$srchCtrlBlocksArr[] = $this->searchControlBuilder->buildSearchCtrlBlockArr($recId, $this->allSearchFields[$j], $ctrlInd, $srchFields[$i]['opt'], $srchFields[$i]['not'], false, $srchFields[$i]['value1'], $srchFields[$i]['value2']);
if ($isFieldNeedSecCtrl) {
$this->pageObj->controlsMap["search"]["searchBlocks"][] = array('fName' => $this->allSearchFields[$j], 'recId' => $recId, 'ctrlsMap' => array(0 => $ctrlInd, 1 => $ctrlInd + 1));
$ctrlInd += 2;
} else {
$this->pageObj->controlsMap["search"]["searchBlocks"][] = array('fName' => $this->allSearchFields[$j], 'recId' => $recId, 'ctrlsMap' => array(0 => $ctrlInd));
$ctrlInd++;
}
// increment ID
$recId = $this->pageObj->genId();
// make 0 for cached ctrls and build cache ctrls
$ctrlInd = 0;
}
// use this criteria, for create cached ctrls. Because, it can slow page with big amout of ctrls
if (count($this->allSearchFields) < $gLoadSearchControls) {
// add cached ctrl
$srchCtrlBlocksArr[] = $this->searchControlBuilder->buildSearchCtrlBlockArr($recId, $this->allSearchFields[$j], $ctrlInd, '', false, true, '', '');
if ($isFieldNeedSecCtrl) {
$this->pageObj->controlsMap["search"]["searchBlocks"][] = array('fName' => $this->allSearchFields[$j], 'recId' => $recId, 'ctrlsMap' => array(0 => $ctrlInd, 1 => $ctrlInd + 1));
$ctrlInd += 2;
} else {
$this->pageObj->controlsMap["search"]["searchBlocks"][] = array('fName' => $this->allSearchFields[$j], 'recId' => $recId, 'ctrlsMap' => array(0 => $ctrlInd));
$ctrlInd++;
}
$recId = $this->pageObj->genId();
}
}
// assign blocks with ctrls
$xt->assign_loopsection('searchCtrlBlock', $srchCtrlBlocksArr);
// display templ
$xt->display($this->pageObj->shortTableName . "_search_panel.htm");
}
function searchAssign()
{
$this->pageObj->xt->assign("asearch_link", $this->searchPerm);
$this->pageObj->xt->assign("asearchlink_attrs", "id=\"asearch_" . $this->id . "\" name=\"asearch_" . $this->id . "\" href=\"" . $this->pageObj->shortTableName . "_search.php\" onclick=\"window.location.href='" . $this->pageObj->shortTableName . "_search.php';return false;\"");
if (isEnableSection508() && $this->searchPerm) {
$searchPerm = array();
$searchPerm["begin"] = "<a name=\"skipsearch\"></a>";
} else {
$searchPerm = $this->searchPerm;
}
$this->pageObj->xt->assign("searchform_block", $searchPerm);
if (isMobile()) {
$this->pageObj->xt->assign("searchformmobile_block", $searchPerm);
}
$this->pageObj->xt->assign("searchformbuttons_block", $searchPerm);
$this->pageObj->xt->assign("searchform_text", true);
$this->pageObj->xt->assign("searchform_search", true);
$this->pageObj->xt->assign("searchform_showall", true);
if (!$this->searchClauseObj->isUsedSrch()) {
$this->pageObj->xt->assign("showAllCont_attrs", 'style="display: none;"');
}
$srchButtTitle = mlang_message("SEARCH");
$this->pageObj->xt->assign("searchbutton_attrs", "id=\"searchButtTop" . $this->id . "\" title=\"" . $srchButtTitle . '"');
$this->pageObj->xt->assign("showallbutton_attrs", "id=\"showAll" . $this->id . "\"");
}
$keylink = "";
$k = 0;
foreach ($keys as $idx => $val) {
if ($k != 0) {
$keylink .= "&";
}
$keylink .= "editid" . ++$k . "=" . htmlspecialchars(rawurlencode(@$val));
}
$permis = $pageObject->getPermissions();
if (count($keys)) {
$message .= "</br>";
if (GetTableData($strTableName, ".edit", false) && $permis['edit']) {
$message .= ' <a href=\'Customer_Module_Assignment_edit.php?' . $keylink . '\'>' . mlang_message("EDIT") . '</a> ';
}
if (GetTableData($strTableName, ".view", false) && $permis['search']) {
$message .= ' <a href=\'Customer_Module_Assignment_view.php?' . $keylink . '\'>' . mlang_message("VIEW") . '</a> ';
}
}
$mesClass = "mes_ok";
}
} elseif ($inlineadd != ADD_INLINE) {
$mesClass = "mes_not";
}
} else {
$message = $usermessage;
$status = "DECLINED";
$readavalues = true;
}
}
$message = "<div class='message " . $mesClass . "'>" . $message . "</div>";
// PRG rule, to avoid POSTDATA resend
function getFormattedRow($value)
{
$row = array('row_data' => true);
$keylink = "";
for ($i = 0; $i < count($this->tKeyFields); $i++) {
$keylink .= "&key" . ($i + 1) . "=" . htmlspecialchars(rawurlencode(@$value[$this->tKeyFields[$i]]));
}
for ($i = 0; $i < count($this->fieldsArr); $i++) {
// for change pseudo foreach with condition with PHP for
// foreach Fields as @f filter @f.bReportPage && (@TABLE.bReportShowDetails || @TABLE.arrReportGroupFields[strGroupField==@f.strName && nGroupInterval==0].len) order nReportPageOrder
$pass = false;
for ($j = 0; $j < count($this->repGroupFields); $j++) {
if (!$this->fieldsArr[$i]['repPage'] || !($this->repShowDet || $this->repGroupFields[$j]['strGroupField'] == $this->fieldsArr[$i]['name'] && $this->repGroupFields[$j]['groupInterval'] === 0)) {
$pass = true;
}
}
if ($pass) {
continue;
}
if ($this->fieldsArr[$i]['viewFormat'] == FORMAT_DATABASE_IMAGE) {
if (!$this->forExport) {
if ($this->fieldsArr[$i]['showThumb']) {
$val .= "<a ";
if (IsUseiBox($this->fieldsArr[$i]['name'], $this->tName)) {
$val .= " rel='ibox'";
} else {
$val .= " target=_blank";
}
$val .= " href=\"imager.php?table=" . $this->shortTName . "&field=" . rawurlencode(htmlspecialchars($this->fieldsArr[$i]['name'])) . $keylink . "\">";
$val .= "<img border=0";
if (isEnableSection508()) {
$val .= " alt=\"Image from DB\"";
}
$val .= " src=\"imager.php?table=" . $this->shortTName . "&field=" . rawurlencode(htmlspecialchars($this->fieldsArr[$i]['thumbnail'])) . "&alt=" . rawurlencode(htmlspecialchars($this->fieldsArr[$i]['repPage'])) . $keylink . "\">";
$val .= "</a>";
} else {
$val = "<img";
if ($this->fieldsArr[$i]['imageWidth']) {
$val .= " width=" . $this->fieldsArr[$i]['imageWidth'];
}
if ($this->fieldsArr[$i]['imageHeight']) {
$val .= " height=" . $this->fieldsArr[$i]['imageHeight'];
}
$val .= " border=0";
if (isEnableSection508()) {
$val .= " alt=\"Image from DB\"";
}
$val .= " src=\"imager.php?table=" . $this->shortTName . "&field=" . rawurlencode(htmlspecialchars($this->fieldsArr[$i]['name'])) . $keylink . "\">";
}
} else {
$val = mlang_message("LONG_BINARY");
}
} elseif ($this->fieldsArr[$i]['viewFormat'] == FORMAT_FILE_IMAGE) {
if (!$this->forExport) {
if (CheckImageExtension($value[$this->fieldsArr[$i]['name']])) {
if ($this->fieldsArr[$i]['showThumb']) {
// show thumbnail
$thumbname = $this->fieldsArr[$i]['thumbnail'] . $value[$this->fieldsArr[$i]['name']];
if (substr($this->fieldsArr[$i]['strhlPrefix'], 0, 7) != "http://" && !myfile_exists(getabspath($this->fieldsArr[$i]['strhlPrefix'] . $thumbname))) {
$thumbname = $value[$this->fieldsArr[$i]['name']];
}
$val = "<a";
if (IsUseiBox($this->fieldsArr[$i]['name'], $this->tName)) {
$val .= " rel='ibox'";
} else {
$val .= " target=_blank";
}
$val .= " href=\"" . htmlspecialchars(AddLinkPrefix($this->fieldsArr[$i]['name'], $value[$this->fieldsArr[$i]['name']])) . "\">";
$val .= "<img";
if ($thumbname == $value[$this->fieldsArr[$i]['name']]) {
if ($this->fieldsArr[$i]['imageWidth']) {
$val .= " width=" . $this->fieldsArr[$i]['imageWidth'];
}
if ($this->fieldsArr[$i]['imageHeight']) {
$val .= " height=" . $this->fieldsArr[$i]['imageHeight'];
}
}
$val .= " border=0";
if (isEnableSection508()) {
$val .= " alt=\"" . htmlspecialchars($value[$this->fieldsArr[$i]['name']]) . "\"";
}
$val .= " src=\"" . htmlspecialchars(AddLinkPrefix($this->fieldsArr[$i]['name'], $thumbname)) . "\"></a>";
} else {
$val = "<img";
if ($this->fieldsArr[$i]['imageWidth']) {
$val .= " width=" . $this->fieldsArr[$i]['imageWidth'];
}
if ($this->fieldsArr[$i]['imageHeight']) {
$val .= " height=" . $this->fieldsArr[$i]['imageHeight'];
}
$val .= " border=0";
if (isEnableSection508()) {
$val .= " alt=\"" . htmlspecialchars($value[$this->fieldsArr[$i]['name']]) . "\"";
}
$val .= " src=\"" . htmlspecialchars(AddLinkPrefix($this->fieldsArr[$i]['name'], $value[$this->fieldsArr[$i]['name']])) . "\">";
}
}
} else {
$val = mlang_message("LONG_BINARY");
}
} elseif ($this->fieldsArr[$i]['viewFormat'] == FORMAT_DATABASE_FILE) {
if (!$this->forExport) {
if ($this->fieldsArr[$i]['fileName']) {
$filename = $value[$this->fieldsArr[$i]['fileName']];
if (!$filename) {
$filename = "file.bin";
}
} else {
$filename = "file.bin";
}
if (strlen($value[$this->fieldsArr[$i]['name']])) {
$val = "<a href=\"getfile.php?table=" . $this->shortTName . "&filename=" . rawurlencode($filename) . "&field=" . rawurlencode(htmlspecialchars($this->fieldsArr[$i]['name'])) . $keylink . "\">";
$val .= htmlspecialchars($filename);
$val .= "</a>";
}
} else {
$val = mlang_message("LONG_BINARY");
}
} elseif (($this->fieldsArr[$i]['editFormat'] == EDIT_FORMAT_LOOKUP_WIZARD || $this->fieldsArr[$i]['editFormat'] == EDIT_FORMAT_RADIO) && GetLookupType($this->fieldsArr[$i]['name'], $this->tName) == LT_LOOKUPTABLE) {
$val = DisplayLookupWizard($this->fieldsArr[$i]['name'], $value[$this->fieldsArr[$i]['name']], $value, $keylink, $this->mode);
} elseif (NeedEncode($this->fieldsArr[$i]['name'], $this->tName)) {
$val = ProcessLargeText(GetData($value, $this->fieldsArr[$i]['name'], $this->fieldsArr[$i]['viewFormat']), "field=" . rawurlencode($this->fieldsArr[$i]['name']) . $keylink, "", $this->mode);
} else {
//$val = GetData($value, $this->fieldsArr[$i]['name'], $this->fieldsArr[$i]['viewFormat']);
if ($this->fieldsArr[$i]['viewFormat'] == FORMAT_CHECKBOX && $this->forExport) {
$val = GetData($value, $this->fieldsArr[$i]['name'], FORMAT_NONE);
} else {
$val = GetData($value, $this->fieldsArr[$i]['name'], $this->fieldsArr[$i]['viewFormat']);
}
}
$row[$this->fieldsArr[$i]['goodName'] . "_value"] = $val;
}
if ($this->repLayout == REPORT_BLOCK) {
$row[GoodFieldName('nonewgroup')] = true;
}
return $row;
}
$xt->assign("guestlink_attrs", "href=\"menu.php\"");
}
if (postvalue("username")) {
$xt->assign("username_attrs", ($is508 == true ? "id=\"username\" " : "") . "value=\"" . htmlspecialchars($pUsername) . "\"");
} else {
$xt->assign("username_attrs", ($is508 == true ? "id=\"username\" " : "") . "value=\"" . htmlspecialchars(refine(@$_COOKIE["username"])) . "\"");
}
$password_attrs = "onkeydown=\"e=event; if(!e) e = window.event; if (e.keyCode != 13) return; e.cancel = true; e.cancelBubble=true; document.forms[0].submit(); return false;\"";
if (postvalue("password")) {
$password_attrs .= ($is508 == true ? " id=\"password\"" : "") . " value=\"" . htmlspecialchars($pPassword) . "\"";
} else {
$password_attrs .= ($is508 == true ? " id=\"password\"" : "") . " value=\"" . htmlspecialchars(refine(@$_COOKIE["password"])) . "\"";
}
$xt->assign("password_attrs", $password_attrs);
if (@$_GET["message"] == "expired") {
$message = mlang_message("SESSION_EXPIRED");
}
if ($message) {
$xt->assign("message_block", true);
$xt->assign("message", $message);
}
$pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/loadfirst.js\"></script>";
$pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/lang/" . getLangFileName(mlang_getcurrentlang()) . ".js\"></script>";
$pageObject->body["begin"] .= "<form method=post action=\"login.php\" id=form1 name=form1>\n\t\t<input type=hidden name=btnSubmit value=\"Login\">";
$pageObject->body["end"] .= "</form>\n<script>\nfunction elementVisible(jselement)\n{ \n\tdo\n\t{\n\t\tif (jselement.style.display.toUpperCase() == 'NONE')\n\t\t\treturn false;\n\t\tjselement=jselement.parentNode; \n\t}\n\twhile (jselement.tagName.toUpperCase() != 'BODY'); \n\treturn true;\n}\nif(elementVisible(document.forms[0].elements['username']))\n\tdocument.forms[0].elements['username'].focus();\n</script>";
$pageObject->addCommonJs();
// button handlers file names
//fill jsSettings and ControlsHTMLMap
$pageObject->fillSetCntrlMaps();
$pageObject->body['end'] .= '<script>';
$pageObject->body['end'] .= "window.controlsMap = " . my_json_encode($pageObject->controlsHTMLMap) . ";";
$keylink = "";
$k = 0;
foreach ($keys as $idx => $val) {
if ($k != 0) {
$keylink .= "&";
}
$keylink .= "editid" . ++$k . "=" . htmlspecialchars(rawurlencode(@$val));
}
$permis = $pageObject->getPermissions();
if (count($keys)) {
$message .= "</br>";
if (GetTableData($strTableName, ".edit", false) && $permis['edit']) {
$message .= ' <a href=\'LU_Locations_edit.php?' . $keylink . '\'>' . mlang_message("EDIT") . '</a> ';
}
if (GetTableData($strTableName, ".view", false) && $permis['search']) {
$message .= ' <a href=\'LU_Locations_view.php?' . $keylink . '\'>' . mlang_message("VIEW") . '</a> ';
}
}
$mesClass = "mes_ok";
}
} elseif ($inlineadd != ADD_INLINE) {
$mesClass = "mes_not";
}
} else {
$message = $usermessage;
$status = "DECLINED";
$readavalues = true;
}
}
$message = "<div class='message " . $mesClass . "'>" . $message . "</div>";
// PRG rule, to avoid POSTDATA resend
function GetLockInfo($strtable, $keys, $links, $pageid)
{
$page = GetTableURL($strtable) . "_edit.php";
$skeys = "";
foreach ($keys as $ind => $val) {
if (strlen($skeys)) {
$skeys .= "&";
}
$skeys .= rawurlencode($val);
}
$rstmp = $this->TableObj->Query(AddFieldWrappers("table") . "=" . db_prepare_string($strtable) . " and " . AddFieldWrappers("keys") . "=" . db_prepare_string($skeys) . " and " . AddFieldWrappers("sessionid") . "<>'" . session_id() . "' and " . AddFieldWrappers("action") . "=1", AddFieldWrappers("id") . " asc");
if ($data = db_fetch_array($rstmp)) {
$sdate = now();
$arrDateTime = db2time($data["startdatetime"]);
$str = mysprintf($this->LockAdmin, array($data["userid"], round(secondsPassedFrom($data["startdatetime"]) / 60, 2)));
if ($links) {
$str .= '<a class="unlock" href="#" onclick="Runner.pages.PageManager.getAt(\'' . $strtable . '\', ' . $pageid . ').locking.UnlockAdmin(\'' . htmlspecialchars(jsreplace($skeys)) . '\',\'' . $data["sessionid"] . '\',\'no\');return false;">' . mlang_message("LOCK_UNLOCK") . '</a>';
$str .= '<a class="edit" href="#" onclick="Runner.pages.PageManager.getAt(\'' . $strtable . '\', ' . $pageid . ').locking.UnlockAdmin(\'' . htmlspecialchars(jsreplace($skeys)) . '\',\'' . $data["sessionid"] . '\',\'yes\');return false;">' . mlang_message("LOCK_EDIT") . '</a>';
}
return $str;
} else {
return "";
}
}
$keylink = "";
$k = 0;
foreach ($keys as $idx => $val) {
if ($k != 0) {
$keylink .= "&";
}
$keylink .= "editid" . ++$k . "=" . htmlspecialchars(rawurlencode(@$val));
}
$permis = $pageObject->getPermissions();
if (count($keys)) {
$message .= "</br>";
if (GetTableData($strTableName, ".edit", false) && $permis['edit']) {
$message .= ' <a href=\'LU_Customer_Type_edit.php?' . $keylink . '\'>' . mlang_message("EDIT") . '</a> ';
}
if (GetTableData($strTableName, ".view", false) && $permis['search']) {
$message .= ' <a href=\'LU_Customer_Type_view.php?' . $keylink . '\'>' . mlang_message("VIEW") . '</a> ';
}
}
$mesClass = "mes_ok";
}
} elseif ($inlineadd != ADD_INLINE) {
$mesClass = "mes_not";
}
} else {
$message = $usermessage;
$status = "DECLINED";
$readavalues = true;
}
}
$message = "<div class='message " . $mesClass . "'>" . $message . "</div>";
// PRG rule, to avoid POSTDATA resend
$keylink = "";
$k = 0;
foreach ($keys as $idx => $val) {
if ($k != 0) {
$keylink .= "&";
}
$keylink .= "editid" . ++$k . "=" . htmlspecialchars(rawurlencode(@$val));
}
$permis = $pageObject->getPermissions();
if (count($keys)) {
$message .= "</br>";
if (GetTableData($strTableName, ".edit", false) && $permis['edit']) {
$message .= ' <a href=\'Electricity_Rates_edit.php?' . $keylink . '\'>' . mlang_message("EDIT") . '</a> ';
}
if (GetTableData($strTableName, ".view", false) && $permis['search']) {
$message .= ' <a href=\'Electricity_Rates_view.php?' . $keylink . '\'>' . mlang_message("VIEW") . '</a> ';
}
}
$mesClass = "mes_ok";
}
} elseif ($inlineadd != ADD_INLINE) {
$mesClass = "mes_not";
}
} else {
$message = $usermessage;
$status = "DECLINED";
$readavalues = true;
}
}
$message = "<div class='message " . $mesClass . "'>" . $message . "</div>";
// PRG rule, to avoid POSTDATA resend
$keylink = "";
$k = 0;
foreach ($keys as $idx => $val) {
if ($k != 0) {
$keylink .= "&";
}
$keylink .= "editid" . ++$k . "=" . htmlspecialchars(rawurlencode(@$val));
}
$permis = $pageObject->getPermissions();
if (count($keys)) {
$message .= "</br>";
if (GetTableData($strTableName, ".edit", false) && $permis['edit']) {
$message .= ' <a href=\'Month_Billings_edit.php?' . $keylink . '\'>' . mlang_message("EDIT") . '</a> ';
}
if (GetTableData($strTableName, ".view", false) && $permis['search']) {
$message .= ' <a href=\'Month_Billings_view.php?' . $keylink . '\'>' . mlang_message("VIEW") . '</a> ';
}
}
$mesClass = "mes_ok";
}
} elseif ($inlineadd != ADD_INLINE) {
$mesClass = "mes_not";
}
} else {
$message = $usermessage;
$status = "DECLINED";
$readavalues = true;
}
}
$message = "<div class='message " . $mesClass . "'>" . $message . "</div>";
// PRG rule, to avoid POSTDATA resend
function DoInsertRecordSQL($table, &$avalues, &$blobfields, $pageid, &$pageObject)
{
global $error_happened, $conn, $inlineadd, $usermessage, $message, $failed_inline_add, $keys, $strTableName;
// make SQL string
$strSQL = "insert into " . AddTableWrappers($table) . " ";
$strFields = "(";
$strValues = "(";
$blobs = PrepareBlobs($avalues, $blobfields);
foreach ($avalues as $akey => $value) {
$strFields .= GetFullFieldName($akey) . ", ";
if (in_array($akey, $blobfields)) {
$strValues .= $value . ", ";
} else {
$strValues .= add_db_quotes($akey, $value) . ", ";
}
}
if (substr($strFields, -2) == ", ") {
$strFields = substr($strFields, 0, strlen($strFields) - 2);
}
if (substr($strValues, -2) == ", ") {
$strValues = substr($strValues, 0, strlen($strValues) - 2);
}
$strSQL .= $strFields . ") values " . $strValues . ")";
if (!ExecuteUpdate($strSQL, $blobs, true)) {
return false;
}
if ($error_happened) {
return false;
}
$pageObject->ProcessFiles();
if ($inlineadd == ADD_INLINE) {
$status = "ADDED";
$message = "" . mlang_message("RECORD_ADDED") . "";
$IsSaved = true;
} else {
$message = "<<< " . mlang_message("RECORD_ADDED") . " >>>";
}
if ($usermessage != "") {
$message = $usermessage;
}
$auditObj = GetAuditObject($table);
if ($inlineadd == ADD_SIMPLE || $inlineadd == ADD_INLINE || $inlineadd == ADD_ONTHEFLY || $inlineadd == ADD_POPUP || $inlineadd == ADD_MASTER || tableEventExists("AfterAdd", $strTableName) || $auditObj) {
$failed_inline_add = false;
$keyfields = GetTableKeys();
foreach ($keyfields as $k) {
if (array_key_exists($k, $avalues)) {
$keys[$k] = $avalues[$k];
} elseif (IsAutoincField($k)) {
$lastrs = db_query("select @@IDENTITY", $conn);
if ($lastdata = db_fetch_numarray($lastrs)) {
$keys[$k] = $lastdata[0];
}
} else {
$failed_inline_add = true;
}
}
}
return true;
}
function getDelButtonHtml($fName, $recId)
{
$html = '<img id = "' . $this->getDelButtonId($fName, $recId) . '" ctrlId="' . $recId . '" fName="' . GoodFieldName($fName) . '" class="searchPanelButton" src="images/search/closeRed.gif" alt="' . mlang_message("DELETE_CONTROL") . '">';
return $html;
}
/**
* Fill groups array from DB, call after save
*
*/
function fillGroups()
{
$this->groups[] = array(-1, "<" . mlang_message("AA_GROUP_ADMIN") . ">");
$this->groupFullChecked[] = true;
$trs = db_query("select GroupID,Label from [uggroups] order by Label", $this->conn);
while ($tdata = db_fetch_array($trs)) {
$this->groups[] = array($tdata['GroupID'], $tdata['Label']);
$this->groupFullChecked[] = true;
}
}
@ini_set("display_errors", "1");
@ini_set("display_startup_errors", "1");
session_cache_limiter("none");
include "include/dbcommon.php";
header("Expires: Thu, 01 Jan 1970 00:00:01 GMT");
set_time_limit(600);
include "include/Readings_variables.php";
include "include/import_functions.php";
$strOriginalTableName = "[dbo].[Readings]";
if (!@$_SESSION["UserID"]) {
$_SESSION["MyURL"] = $_SERVER["SCRIPT_NAME"] . "?" . $_SERVER["QUERY_STRING"];
header("Location: login.php?message=expired");
return;
}
if (!CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Import")) {
echo "<p>" . mlang_message("NO_PERMISSIONS") . "<a href=\"login.php\">" . mlang_message("BACK_TO_LOGIN") . "</a></p>";
return;
}
// keys array
$keys[] = AddFieldWrappers("Record ID");
$keys_present = 1;
$total_records = 0;
$goodlines = 0;
// Create audit object
$auditObj = GetAuditObject($strTableName);
function getFieldNamesByHeaders($fields)
{
global $strTableName, $conn, $strOriginalTableName, $ext;
// check fields in column headers
// check that we have labes in column headers
$fieldsNotFoundArr = array();
function ExportExcelRecord($arrdata, $datatype, $row, $objPHPExcel)
{
global $cCharset, $locale_info;
$col = -1;
foreach ($arrdata as $field => $data) {
$col++;
$colLetter = PHPExcel_Cell::stringFromColumnIndex($col);
if ($datatype[$field] == "binary") {
if (!$data) {
continue;
}
if (!function_exists("imagecreatefromstring")) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($col, $row + 1, mlang_message("LONG_BINARY"));
continue;
}
$error_handler = set_error_handler("empty_error_handler");
$gdImage = imagecreatefromstring($data);
if ($error_handler) {
set_error_handler($error_handler);
}
if ($gdImage) {
$objDrawing = new PHPExcel_Worksheet_MemoryDrawing();
$objDrawing->setImageResource($gdImage);
$objDrawing->setCoordinates($colLetter . ($row + 1));
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
$width = $objDrawing->getWidth() * 0.143;
$height = $objDrawing->getHeight() * 0.75;
if ($objPHPExcel->setActiveSheetIndex(0)->getRowDimension($row + 1)->getRowHeight() < $height) {
$objPHPExcel->setActiveSheetIndex(0)->getRowDimension($row + 1)->setRowHeight($height);
}
$objPHPExcel->getActiveSheet()->getColumnDimension($colLetter)->setAutoSize(false);
if ($objPHPExcel->setActiveSheetIndex(0)->getColumnDimension($colLetter)->getWidth() < $width) {
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension($colLetter)->setWidth($width);
}
}
} elseif ($datatype[$field] == "file") {
if (!file_exists(getUploadFolder($field) . $data) || !$data) {
continue;
}
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setPath(getUploadFolder($field) . $data);
$objDrawing->setCoordinates($colLetter . ($row + 1));
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
$width = $objDrawing->getWidth() * 0.143;
$height = $objDrawing->getHeight() * 0.75;
if ($objPHPExcel->setActiveSheetIndex(0)->getRowDimension($row + 1)->getRowHeight() < $height) {
$objPHPExcel->setActiveSheetIndex(0)->getRowDimension($row + 1)->setRowHeight($height);
}
$objPHPExcel->getActiveSheet()->getColumnDimension($colLetter)->setAutoSize(false);
if ($objPHPExcel->setActiveSheetIndex(0)->getColumnDimension($colLetter)->getWidth() < $width) {
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension($colLetter)->setWidth($width);
}
} else {
$data = PHPExcel_Shared_String::ConvertEncoding($data, 'UTF-8', $cCharset);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($col, $row + 1, $data);
if ($datatype[$field] == "date") {
$objPHPExcel->setActiveSheetIndex(0)->getStyle($colLetter . ($row + 1))->getNumberFormat()->setFormatCode($locale_info["LOCALE_SSHORTDATE"] . " hh:mm:ss");
}
}
}
}
