/**
  * Get a filter's SQL where clause condition 
  *
  * @param String fName
  * @param Array intervalData
  * @param Object pSet
  * @param Object cipherer
  * @param String tableName
  * @return String
  */
 static function getIntervalFilterWhere($fName, $intervalData, $pSet, $cipherer, $tableName, $connection)
 {
     $fullFieldName = RunnerPage::_getFieldSQL($fName, $connection, $pSet);
     if ($intervalData["remainder"]) {
         $index = $intervalData["index"];
         $intervalsData = $pSet->getFilterIntervals($fName);
         $conditions = array();
         foreach ($intervalsData as $intervalData) {
             if ($intervalData["noLimits"]) {
                 return "1=0";
             }
             if ($intervalData["index"] == $index) {
                 continue;
             }
             $conditions[] = FilterIntervalList::getLimitsConditions($fName, $fullFieldName, $intervalData, $cipherer, $tableName, $connection, true);
         }
         return implode(" AND ", $conditions);
     }
     if ($intervalData["noLimits"]) {
         return $fullFieldName . " is not NULL AND " . $fullFieldName . " <> '' ";
     }
     return FilterIntervalList::getLimitsConditions($fName, $fullFieldName, $intervalData, $cipherer, $tableName, $connection);
 }

 function LookupTextField($field, $pageObject, $id, $connection)
 {
     parent::EditControl($field, $pageObject, $id, $connection);
     $this->format = EDIT_FORMAT_LOOKUP_WIZARD;
     $this->lookupPageType = $this->pageObject->pSetEdit->getPageTypeByFieldEditFormat($this->field, EDIT_FORMAT_LOOKUP_WIZARD);
     $this->localPSet = new ProjectSettings($this->pageObject->tName, $this->lookupPageType);
     $this->lookupTable = $this->localPSet->getLookupTable($this->field);
     $this->lookupType = $this->localPSet->getLookupType($this->field);
     if ($this->lookupType == LT_QUERY) {
         $this->lookupPSet = new ProjectSettings($this->lookupTable);
     }
     $this->displayFieldName = $this->localPSet->getDisplayField($this->field);
     $this->linkFieldName = $this->localPSet->getLinkField($this->field);
     $this->linkAndDisplaySame = $this->displayFieldName == $this->linkFieldName;
     $this->ciphererLink = new RunnerCipherer($this->pageObject->tName);
     if ($this->lookupType == LT_QUERY) {
         $this->ciphererDisplay = new RunnerCipherer($this->lookupTable);
     } else {
         $this->ciphererDisplay = $this->ciphererLink;
     }
     $this->LCType = $this->localPSet->lookupControlType($this->field);
     $this->multiselect = $this->localPSet->multiSelect($this->field);
     $this->lwLinkField = $connection->addFieldWrappers($this->localPSet->getLinkField($this->field));
     $this->lwDisplayFieldWrapped = RunnerPage::sqlFormattedDisplayField($this->field, $connection, $this->localPSet);
     $this->customDisplay = $this->localPSet->getCustomDisplay($this->field);
 }

	function AddPage(&$params)
	{
		parent::RunnerPage($params);
		
		$this->formBricks["header"] = "addheader";
		$this->formBricks["footer"] = "addbuttons";		
	}

	function ViewPage(&$params)
	{
		parent::RunnerPage($params);
		
		$this->setKeysForJs();
		
		$this->formBricks["header"] = "viewheader";
		$this->formBricks["footer"] = "viewbuttons";		
	}

 function RemindPasswordPage(&$params)
 {
     parent::RunnerPage($params);
     $this->pSet = new ProjectSettings("DashboardUsers", $this->pageType);
     $this->pSetEdit = $this->pSet;
     $this->formBricks["header"] = "remindheader";
     $this->formBricks["footer"] = "remindbuttons";
     $this->assignFormFooterAndHeaderBricks(true);
 }

	function EditPage(&$params)
	{
		parent::RunnerPage($params);
		
		$this->editFields = $this->getFieldsByPageType();
		$this->setKeys( $this->keys );
		
		$this->formBricks["header"] = "editheader";
		$this->formBricks["footer"] = "editbuttons";	
	}

	function LoginPage(&$params) 
	{
		// call parent constructor
		parent::RunnerPage($params);
		
		$this->auditObj = GetAuditObject();
		
		$this->formBricks["header"] = "loginheader";
		$this->formBricks["footer"] = "loginbuttons";
	}

 /**
  * @constructor
  */
 function LoginPage(&$params)
 {
     // call parent constructor
     parent::RunnerPage($params);
     $this->pSet = new ProjectSettings("ConsolidatedStockEnquiry_users", $this->pageType);
     $this->pSetEdit = $this->pSet;
     $this->pSetSearch = new ProjectSettings($this->tName, PAGE_SEARCH);
     $this->auditObj = GetAuditObject();
     $this->formBricks["header"] = "loginheader";
     $this->formBricks["footer"] = "loginbuttons";
     $this->assignFormFooterAndHeaderBricks(true);
 }

 function RegisterPage(&$params = "")
 {
     parent::RunnerPage($params);
     // fill global password settings
     $this->pwdStrong = GetGlobalData("pwdStrong", false);
     if ($this->pwdStrong) {
         $this->settingsMap["globalSettings"]["pwdLen"] = GetGlobalData("pwdLen", 0);
         $this->settingsMap["globalSettings"]["pwdUnique"] = GetGlobalData("pwdUnique", 0);
         $this->settingsMap["globalSettings"]["pwdDigits"] = GetGlobalData("pwdDigits", 0);
         $this->settingsMap["globalSettings"]["pwdStrong"] = true;
         $this->settingsMap["globalSettings"]["pwdUpperLower"] = GetGlobalData("pwdUpperLower", false);
     }
     $this->formBricks["header"] = "regheader";
     $this->formBricks["footer"] = "regbuttons";
     $this->assignFormFooterAndHeaderBricks(true);
 }

 function ChangePasswordPage(&$params = "")
 {
     parent::RunnerPage($params);
     $this->pSet = new ProjectSettings("DashboardUsers", $this->pageType);
     $this->pSetEdit = $this->pSet;
     // fill global password settings
     $this->pwdStrong = GetGlobalData("pwdStrong", false);
     if ($this->pwdStrong) {
         $this->settingsMap["globalSettings"]["pwdLen"] = GetGlobalData("pwdLen", 0);
         $this->settingsMap["globalSettings"]["pwdUnique"] = GetGlobalData("pwdUnique", 0);
         $this->settingsMap["globalSettings"]["pwdDigits"] = GetGlobalData("pwdDigits", 0);
         $this->settingsMap["globalSettings"]["pwdStrong"] = true;
         $this->settingsMap["globalSettings"]["pwdUpperLower"] = GetGlobalData("pwdUpperLower", false);
     }
     $this->formBricks["header"] = "changeheader";
     $this->formBricks["footer"] = "changebuttons";
     $this->assignFormFooterAndHeaderBricks(true);
 }

$params["id"] = $id;
$params["mode"] = $mode;
$params["calendar"] = $calendar;
$params["timepicker"] = $timepicker;
$params['xt'] =& $xt;
$params['shortTableName'] = 'Electricity_Rates';
$params['origTName'] = $strOriginalTableName;
$params['sessionPrefix'] = $sessionPrefix;
$params['tName'] = $strTableName;
$params['includes_js'] = $includes_js;
$params['includes_jsreq'] = $includes_jsreq;
$params['includes_css'] = $includes_css;
$params['locale_info'] = $locale_info;
$params['pageType'] = PAGE_SEARCH;
//PAGE_SEARCH,$id,$calendar
$pageObject = new RunnerPage($params);
// create reusable searchControl builder instance
$searchControllerId = postvalue('searchControllerId') ? postvalue('searchControllerId') : $pageObject->id;
//	Before Process event
if ($eventObj->exists("BeforeProcessSearch")) {
    $eventObj->BeforeProcessSearch($conn);
}
// add constants and files for simple view
if ($mode == SEARCH_SIMPLE) {
    $searchControlBuilder = new AdvancedSearchControl($searchControllerId, $strTableName, $pageObject->searchClauseObj, $pageObject);
    // add button events if exist
    $pageObject->addButtonHandlers();
    $includes .= "<script language=\"JavaScript\" src=\"include/loadfirst.js\"></script>\r\n";
    //$includes.="<script language=\"JavaScript\" src=\"include/customlabels.js\"></script>\r\n";
    $includes .= "<script type=\"text/javascript\" src=\"include/lang/" . getLangFileName(mlang_getcurrentlang()) . ".js\"></script>";
    // if not simple, this div already exist on page

            $_SESSION[$strTableName . "_masterkey" . $i] = $masterKeys["masterkey" . $i];
            $i++;
        }
    }
    if (isset($_SESSION[$strTableName . "_masterkey" . $i])) {
        unset($_SESSION[$strTableName . "_masterkey" . $i]);
    }
} else {
    $mastertable = $_SESSION[$strTableName . "_mastertable"];
}
$params = array();
$params['id'] = 1;
$params['xt'] =& $xt;
$params['tName'] = $strTableName;
$params['pageType'] = "detailspreview";
$pageObject = new RunnerPage($params);
if ($mastertable == "company") {
    $where = "";
    $where .= $pageObject->getFieldSQLDecrypt("Coy_Id") . "=" . make_db_value("Coy_Id", $_SESSION[$strTableName . "_masterkey1"]);
    $where .= " and ";
    $where .= $pageObject->getFieldSQLDecrypt("Grp_id") . "=" . make_db_value("Grp_id", $_SESSION[$strTableName . "_masterkey2"]);
}
$str = SecuritySQL("Search", $strTableName);
if (strlen($str)) {
    $where .= " and " . $str;
}
$strSQL = $gQuery->gSQLWhere($where);
$strSQL .= " " . $gstrOrderBy;
$rowcount = $gQuery->gSQLRowCount($where, $pageObject->connection);
$xt->assign("row_count", $rowcount);
if ($rowcount) {

$layout->containers["master"][] = array("name" => "masterinfoprint", "block" => "mastertable_block", "substyle" => 1);
$layout->skins["master"] = "empty";
$layout->blocks["top"][] = "master";
$layout->skins["pdf"] = "empty";
$layout->blocks["top"][] = "pdf";
$page_layouts["System_Users_print"] = $layout;
include 'include/xtempl.php';
include 'classes/runnerpage.php';
$xt = new Xtempl();
$id = postvalue("id") != "" ? postvalue("id") : 1;
$all = postvalue("all");
$pageName = "print.php";
//array of params for classes
$params = array("pageType" => PAGE_PRINT, "id" => $id, "tName" => $strTableName);
$params["xt"] =& $xt;
$pageObject = new RunnerPage($params);
// add button events if exist
$pageObject->addButtonHandlers();
// Modify query: remove blob fields from fieldlist.
// Blob fields on a print page are shown using imager.php (for example).
// They don't need to be selected from DB in print.php itself.
if (!postvalue("pdf")) {
    $gQuery->ReplaceFieldsWithDummies(GetBinaryFieldsIndices());
}
//	Before Process event
if ($eventObj->exists("BeforeProcessPrint")) {
    $eventObj->BeforeProcessPrint($conn);
}
$strWhereClause = "";
$strHavingClause = "";
$selected_recs = array();

$layout = new TLayout("import", "BoldOrange", "MobileOrange");
$layout->blocks["top"] = array();
$layout->containers["import"] = array();
$layout->containers["import"][] = array("name" => "importheader", "block" => "", "substyle" => 2);
$layout->containers["import"][] = array("name" => "importheader_text", "block" => "", "substyle" => 3);
$layout->containers["import"][] = array("name" => "errormessage", "block" => "", "substyle" => 1);
$layout->containers["import"][] = array("name" => "importfields", "block" => "", "substyle" => 1);
$layout->containers["import"][] = array("name" => "importbuttons", "block" => "", "substyle" => 2);
$layout->skins["import"] = "fields";
$layout->blocks["top"][] = "import";
$page_layouts["Readings_import"] = $layout;
//array of params for classes
$params = array("pageType" => PAGE_IMPORT, "id" => $id, "tName" => $strTableName);
$params["xt"] =& $xt;
$params["needSearchClauseObj"] = false;
$pageObject = new RunnerPage($params);
// add button events if exist
$pageObject->addButtonHandlers();
$pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/loadfirst.js\"></script>\r\n";
$pageObject->body["begin"] .= "<script>\r\n";
$pageObject->body["begin"] .= "function importMore(id)\r\n";
$pageObject->body["begin"] .= "{\r\n";
$pageObject->body["begin"] .= "\tif(\$('#importDebugInfoTable'+id).css('display')=='none')\r\n";
$pageObject->body["begin"] .= "\t\t\$('#importDebugInfoTable'+id).show();\r\n";
$pageObject->body["begin"] .= "\telse\r\n";
$pageObject->body["begin"] .= "\t\t\$('#importDebugInfoTable'+id).hide();\r\n";
$pageObject->body["begin"] .= "}\r\n";
$pageObject->body["begin"] .= "</script>\r\n";
$pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/lang/" . getLangFileName(mlang_getcurrentlang()) . ".js\"></script>";
$pageObject->fillSetCntrlMaps();
$pageObject->body['end'] .= '<script>';

function DisplayMasterTableInfo_GE_ESTADO_CIVIL($params)
{
    global $cman;
    $detailtable = $params["detailtable"];
    $keys = $params["keys"];
    $xt = new Xtempl();
    $tName = "GE.ESTADO_CIVIL";
    $settings = new ProjectSettings($tName, PAGE_LIST);
    $cipherer = new RunnerCipherer($tName);
    $connection = $cman->byTable($tName);
    $masterQuery = $settings->getSQLQuery();
    $viewControls = new ViewControlsContainer($settings, PAGE_LIST);
    $where = "";
    $keysAssoc = array();
    $showKeys = "";
    if ($detailtable == "GE.PERSONA_DISPONIBLE") {
        $keysAssoc["ESTADO_CIVIL_ID"] = $keys[1 - 1];
        $where .= RunnerPage::_getFieldSQLDecrypt("ESTADO_CIVIL_ID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ESTADO_CIVIL_ID", $keys[1 - 1], "", true);
        $keyValue = $viewControls->showDBValue("ESTADO_CIVIL_ID", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_ESTADO_CIVIL", "ESTADO_CIVIL_ID") . ": " . $keyValue;
        $xt->assign('showKeys', $showKeys);
    }
    if (!$where) {
        return;
    }
    $str = SecuritySQL("Search");
    if (strlen($str)) {
        $where .= " and " . $str;
    }
    $strWhere = whereAdd($masterQuery->WhereToSql(), $where);
    if (strlen($strWhere)) {
        $strWhere = " where " . $strWhere . " ";
    }
    $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql();
    LogInfo($strSQL);
    $data = $cipherer->DecryptFetchedArray($connection->query($strSQL)->fetchAssoc());
    if (!$data) {
        return;
    }
    // reassign pagetitlelabel function adding extra params
    $xt->assign_function("pagetitlelabel", "xt_pagetitlelabel", array("record" => $data, "settings" => $settings));
    $keylink = "";
    $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["ESTADO_CIVIL_ID"]));
    $xt->assign("ESTADO_CIVIL_ID_mastervalue", $viewControls->showDBValue("ESTADO_CIVIL_ID", $data, $keylink));
    $format = $settings->getViewFormat("ESTADO_CIVIL_ID");
    $class = " rnr-field-text";
    if ($format == FORMAT_FILE) {
        $class = ' rnr-field-file';
    }
    if ($format == FORMAT_AUDIO) {
        $class = ' rnr-field-audio';
    }
    if ($format == FORMAT_CHECKBOX) {
        $class = ' rnr-field-checkbox';
    }
    if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("ESTADO_CIVIL_ID"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("ESTADO_CIVIL_ID_class", $class);
    // add class for field header as field value
    $xt->assign("NOMBRE_mastervalue", $viewControls->showDBValue("NOMBRE", $data, $keylink));
    $format = $settings->getViewFormat("NOMBRE");
    $class = " rnr-field-text";
    if ($format == FORMAT_FILE) {
        $class = ' rnr-field-file';
    }
    if ($format == FORMAT_AUDIO) {
        $class = ' rnr-field-audio';
    }
    if ($format == FORMAT_CHECKBOX) {
        $class = ' rnr-field-checkbox';
    }
    if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("NOMBRE"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("NOMBRE_class", $class);
    // add class for field header as field value
    $xt->assign("FEC_CREACION_mastervalue", $viewControls->showDBValue("FEC_CREACION", $data, $keylink));
    $format = $settings->getViewFormat("FEC_CREACION");
    $class = " rnr-field-text";
    if ($format == FORMAT_FILE) {
        $class = ' rnr-field-file';
    }
    if ($format == FORMAT_AUDIO) {
        $class = ' rnr-field-audio';
    }
    if ($format == FORMAT_CHECKBOX) {
        $class = ' rnr-field-checkbox';
    }
    if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FEC_CREACION"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("FEC_CREACION_class", $class);
    // add class for field header as field value
    $xt->assign("USUARIO_CREACION_mastervalue", $viewControls->showDBValue("USUARIO_CREACION", $data, $keylink));
    $format = $settings->getViewFormat("USUARIO_CREACION");
    $class = " rnr-field-text";
    if ($format == FORMAT_FILE) {
        $class = ' rnr-field-file';
    }
//.........这里部分代码省略.........

         }
     }
     if (!$linkAndDisplaySame) {
         $LookupSQLTable .= "," . ($lwDisplayField == $lwLinkField ? $cipherer->GetFieldName($lwDisplayField, $f, true) : $lwDisplayField);
     }
     $LookupSQLTable .= " FROM " . $lookupConnection->addTableWrappers($lookupTable) . " ";
 }
 $strLookupWhere = GetLWWhere($f, $pageType, $strTableName);
 if ($strLookupWhere) {
     $strLookupWhere = " (" . $strLookupWhere . ")  AND ";
 }
 if ($LookupType == LT_QUERY) {
     if ($gSettings->getCustomDisplay($f)) {
         $likeField = $searchByLinkField ? $linkFieldName : $displayFieldName;
     } else {
         $likeField = RunnerPage::_getFieldSQLDecrypt($searchByLinkField ? $linkFieldName : $displayFieldName, $lookupConnection, $lookupPSet, $cipherer);
     }
 } else {
     $likeField = $cipherer->GetFieldName($lwDisplayField, $f);
 }
 if ($searchByLinkField) {
     $likeConditionField = $LookupType == LT_QUERY ? $linkFieldName : $f;
 } else {
     $likeConditionField = $LookupType == LT_QUERY ? $displayFieldName : $f;
 }
 $likeWheres = array();
 foreach ($values as $fieldValue) {
     if ($LookupType == LT_QUERY) {
         $likeWheres[] = $likeField . $lookupCipherer->GetLikeClause($likeConditionField, $fieldValue);
     } else {
         $likeWheres[] = $likeField . $cipherer->GetLikeClause($likeConditionField, $fieldValue);

    $id = postvalue("id");
} else {
    $id = 1;
}
//$isNeedSettings = true;//($inlineview && postvalue("isNeedSettings") == 'true') || (!$inlineview);
// assign an id
$xt->assign("id", $id);
//array of params for classes
$params = array("pageType" => PAGE_VIEW, "id" => $id, "tName" => $strTableName);
$params["xt"] =& $xt;
//Get array of tabs for edit page
$params['useTabsOnView'] = useTabsOnView($strTableName);
if ($params['useTabsOnView']) {
    $params['arrViewTabs'] = GetViewTabs($strTableName);
}
$pageObject = new RunnerPage($params);
// SearchClause class stuff
$pageObject->searchClauseObj->parseRequest();
$_SESSION[$strTableName . '_advsearch'] = serialize($pageObject->searchClauseObj);
// proccess big google maps
// add button events if exist
$pageObject->addButtonHandlers();
//For show detail tables on master page view
$dpParams = array();
if ($pageObject->isShowDetailTables && !isMobile()) {
    $ids = $id;
    $pageObject->jsSettings['tableSettings'][$strTableName]['dpParams'] = array();
}
//	Before Process event
if ($eventObj->exists("BeforeProcessView")) {
    $eventObj->BeforeProcessView($conn);

 /**
  * Add js files and scripts
  *
  */
 function addCommonJs()
 {
     // call parent if need RunnerJS API
     RunnerPage::addCommonJs();
     $this->addJsGroupsAndRights();
 }

				$pageObject->AddCSSFile($layout->getCSSFiles(isRTL(), isMobile()));
			}

			$options['id'] = $dpParams['ids'][$d];
			$options['flyId'] = $pageObject->genId()+1;
			$options['tName'] = $strTableName;
			$options['pageType'] = PAGE_CHART;
			$options['shortTableName'] = GetTableURL($strTableName);
			$_params["chartname"] = GetTableURL($strTableName);
			$_params["table"] = $strTableName;
			$_params["ctype"] = $dpParams['params'][$d];
			$_params["singlePage"] = true;
			$_params["id"] = $options['flyId'];
			$options["xt"]->assign_function($options['shortTableName']."_chart","xt_showchart", $_params);

			$chartPageObject = new RunnerPage($options);
			$chartPageObject->init();
			$options["xt"]->assign("chart_block",true);
			$options["xt"]->assign("asearch_link",true);
			$options["xt"]->assign("search_records_block",true);
			$options["xt"]->assign("exportpdflink_attrs","onclick='chart.saveAsPDF();'");
			$options["xt"]->assign("searchform_showall",true);
			$options["xt"]->assign("showallbutton_attrs","onclick=\"window.location.href='".GetTableLink($options['shortTableName'], "chart", "a=showall")."';\"");
			$options["xt"]->assign("advsearchlink_attrs", "id=\"advButton".$id."\"");
			$options["xt"]->assign("style_block",true);
			$options["xt"]->assign("shiftstyle_block", true);
			$chartPageObject->addControlsJSAndCSS();
			$chartPageObject->fillSetCntrlMaps();
			$chartPageObject->body["begin"] = '';
			$chartPageObject->body["end"] = '';
			$options["xt"]->assign("body",$chartPageObject->body);	

$layout->skins["master"] = "empty";
$layout->blocks["top"][] = "master";
$layout->skins["pdf"] = "empty";
$layout->blocks["top"][] = "pdf";
$page_layouts["pad_pad_daftar_hist_print"] = $layout;
include 'include/xtempl.php';
include 'classes/runnerpage.php';
$cipherer = new RunnerCipherer($strTableName);
$xt = new Xtempl();
$id = postvalue("id") != "" ? postvalue("id") : 1;
$all = postvalue("all");
$pageName = "print.php";
//array of params for classes
$params = array("id" => $id, "tName" => $strTableName, "pageType" => PAGE_PRINT);
$params["xt"] =& $xt;
$pageObject = new RunnerPage($params);
// add button events if exist
$pageObject->addButtonHandlers();
// Modify query: remove blob fields from fieldlist.
// Blob fields on a print page are shown using imager.php (for example).
// They don't need to be selected from DB in print.php itself.
$noBlobReplace = false;
if (!postvalue("pdf") && !$noBlobReplace) {
    $gQuery->ReplaceFieldsWithDummies($pageObject->pSet->getBinaryFieldsIndices());
}
//	Before Process event
if ($eventObj->exists("BeforeProcessPrint")) {
    $eventObj->BeforeProcessPrint($conn, $pageObject);
}
$strWhereClause = "";
$strHavingClause = "";