PHP RunnerPage类代码示例

 /**
  * 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';
    }
//.........这里部分代码省略.........