$params["needSearchClauseObj"] = false; $pageObject = new RemindPasswordPage($params); $pageObject->init(); $pageObject->addCommonJs(); $pageObject->fillSetCntrlMaps(); $pageObject->body["end"] .= "<script>"; $pageObject->body['end'] .= "window.controlsMap = ".my_json_encode($pageObject->controlsHTMLMap).";"; $pageObject->body['end'] .= "window.viewControlsMap = ".my_json_encode($pageObject->viewControlsHTMLMap).";"; $pageObject->body['end'] .= "window.settings = ".my_json_encode($pageObject->jsSettings).";</script>"; $pageObject->body['end'] .= "<script language=\"JavaScript\" src=\"".GetRootPathForResources("include/runnerJS/RunnerAll.js")."\"></script>\r\n"; $pageObject->body["end"] .= "<script>".$pageObject->PrepareJS()."</script>"; $pageObject->addButtonHandlers(); $xt->assign("closewindow_attrs", 'style="display:none" id="closeWindowRemind"'); $isUseCaptcha = false; $pageObject->isCaptchaOk = 1; $onFly = postvalue("onFly"); if( !$onFly ) $pageObject->assignFormFooterAndHeaderBricks( true ); if($onFly == 2) $id = 1; $strUsernameEmail=""; $strEmail=""; $strMessage=""; if (@$_POST["btnSubmit"] == "Remind")
///////////////////////////////////////////////////////////// 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) { $id = 1; } $flyId = $id + 1; $xt = new Xtempl(); // assign an id $xt->assign("id", $id); $templatefile = $inlineedit == EDIT_INLINE ? "app_modules_inline_edit.htm" : "app_modules_edit.htm"; //array of params for classes $params = array("pageType" => PAGE_EDIT, "id" => $id); $params['tName'] = $strTableName; $params['xt'] =& $xt; $params['mode'] = $inlineedit; $params['includes_js'] = $includes_js; $params['includes_jsreq'] = $includes_jsreq; $params['includes_css'] = $includes_css; $params['locale_info'] = $locale_info; $params['templatefile'] = $templatefile; $params['pageEditLikeInline'] = $inlineedit == EDIT_INLINE; //Get array of tabs for edit page $params['useTabsOnEdit'] = $gSettings->useTabsOnEdit(); if ($params['useTabsOnEdit']) {
if (count($srchFields)) { $firstFieldParams = $srchFields[0]; } else { $firstFieldParams['fName'] = "id"; $firstFieldParams['eType'] = ''; $firstFieldParams['value1'] = ''; $firstFieldParams['opt'] = ''; $firstFieldParams['value2'] = ''; $firstFieldParams['not'] = false; } // create control $ctrlBlockArr = $searchControlBuilder->buildSearchCtrlBlockArr($id, $firstFieldParams['fName'], 0, $firstFieldParams['opt'], $firstFieldParams['not'], false, $firstFieldParams['value1'], $firstFieldParams['value2']); if (isEnableSection508()) { $xt->assign_section("id_label", "<label for=\"" . GetInputElementId("id", $id, PAGE_SEARCH) . "\">", "</label>"); } else { $xt->assign("id_label", true); } $xt->assign("id_fieldblock", true); $xt->assignbyref("id_editcontrol", $ctrlBlockArr['searchcontrol']); $xt->assign("id_notbox", $ctrlBlockArr['notbox']); // create second control, if need it $xt->assignbyref("id_editcontrol1", $ctrlBlockArr['searchcontrol1']); // create search type select $xt->assign("searchtype_id", $ctrlBlockArr['searchtype']); $isFieldNeedSecCtrl = $searchControlBuilder->isNeedSecondCtrl("id"); $ctrlInd = 0; if ($isFieldNeedSecCtrl) { $pageObject->controlsMap["search"]["searchBlocks"][] = array('fName' => "id", 'recId' => $id, 'ctrlsMap' => array(0 => $ctrlInd, 1 => $ctrlInd + 1)); $ctrlInd += 2; } else { $pageObject->controlsMap["search"]["searchBlocks"][] = array('fName' => "id", 'recId' => $id, 'ctrlsMap' => array(0 => $ctrlInd));
function DisplayMasterTableInfo_BranchMaster($params) { global $cman; $detailtable = $params["detailtable"]; $keys = $params["keys"]; $xt = new Xtempl(); $tName = "BranchMaster"; $xt->eventsObject = getEventObject($tName); $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 == "Fact_SalesTransaction") { $keysAssoc["GroupID"] = $keys[1 - 1]; $keysAssoc["CompanyID"] = $keys[2 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("GroupID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("GroupID", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("GroupID", $keysAssoc); $showKeys .= " " . GetFieldLabel("BranchMaster", "GroupID") . ": " . $keyValue; $where .= " and "; $showKeys .= " , "; $where .= RunnerPage::_getFieldSQLDecrypt("CompanyID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("CompanyID", $keys[2 - 1], "", true); $keyValue = $viewControls->showDBValue("CompanyID", $keysAssoc); $showKeys .= " " . GetFieldLabel("BranchMaster", "CompanyID") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if (!$where) { return; } $str = SecuritySQL("Search", $tName); 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 = ""; $xt->assign("BranchCloudFolder_mastervalue", $viewControls->showDBValue("BranchCloudFolder", $data, $keylink)); $format = $settings->getViewFormat("BranchCloudFolder"); $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("BranchCloudFolder"))) { $class = ' rnr-field-number'; } $xt->assign("BranchCloudFolder_class", $class); // add class for field header as field value $xt->assign("BranchLastSyncDate_mastervalue", $viewControls->showDBValue("BranchLastSyncDate", $data, $keylink)); $format = $settings->getViewFormat("BranchLastSyncDate"); $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("BranchLastSyncDate"))) { $class = ' rnr-field-number'; } $xt->assign("BranchLastSyncDate_class", $class); // add class for field header as field value $xt->assign("l_mastervalue", $viewControls->showDBValue("l", $data, $keylink)); $format = $settings->getViewFormat("l"); $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("l"))) { $class = ' rnr-field-number'; } $xt->assign("l_class", $class); // add class for field header as field value $layout = GetPageLayout("BranchMaster", 'masterlist'); if ($layout) { $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"'); } $xt->displayPartial(GetTemplateName("BranchMaster", "masterlist")); }
$templatefile = "app_group_modules_inline_add.htm"; } else { $templatefile = "app_group_modules_add.htm"; } $id = postvalue("id"); if (intval($id) == 0) { $id = 1; } //If undefined session value for mastet table, but exist post value master table, than take second //It may be happen only when use dpInline mode on page add if (!@$_SESSION[$sessionPrefix . "_mastertable"] && postvalue("mastertable")) { $_SESSION[$sessionPrefix . "_mastertable"] = postvalue("mastertable"); } $xt = new Xtempl(); // assign an id $xt->assign("id", $id); $auditObj = GetAuditObject($strTableName); //array of params for classes $params = array("pageType" => PAGE_ADD, "id" => $id, "mode" => $inlineadd); $params['xt'] =& $xt; $params['tName'] = $strTableName; $params['includes_js'] = $includes_js; $params['locale_info'] = $locale_info; $params['includes_css'] = $includes_css; $params['useTabsOnAdd'] = $gSettings->useTabsOnAdd(); $params['templatefile'] = $templatefile; $params['includes_jsreq'] = $includes_jsreq; $params['pageAddLikeInline'] = $inlineadd == ADD_INLINE; $params['needSearchClauseObj'] = false; $params['strOriginalTableName'] = $strOriginalTableName; if ($params['useTabsOnAdd']) {
function DisplayMasterTableInfo_pad_pad_sspd($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "pad.pad_sspd"; //$strSQL = "SELECT id, tahun, sspdno, sspdtgl, sspdjam, invoice_id, keterangan, bulan_telat, hitung_bunga, denda, bunga, jml_bayar, sisa, jenis_bayar, printed, tp_id, is_validated, is_valid, enabled, created, create_uid, updated, update_uid, petugas_id, pejabat_id FROM \"pad\".pad_sspd "; $cipherer = new RunnerCipherer($strTableName); $settings = new ProjectSettings($strTableName, PAGE_PRINT); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_PRINT); $where = ""; global $pageObject, $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterprint", "RoundedGreen", "MobileGreen"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["pad_pad_sspd_masterprint"] = $layout; $showKeys = ""; if ($detailtable == "public.pad_payment") { $where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[1 - 1], "", "", true); $showKeys .= " " . "Id" . ": " . $keys[1 - 1]; $xt->assign('showKeys', $showKeys); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Export"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->m_where->toSql($masterQuery), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = $cipherer->DecryptFetchedArray($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $xt->assign("id_mastervalue", $viewControls->showDBValue("id", $data, $keylink)); // tahun - $xt->assign("tahun_mastervalue", $viewControls->showDBValue("tahun", $data, $keylink)); // sspdno - $xt->assign("sspdno_mastervalue", $viewControls->showDBValue("sspdno", $data, $keylink)); // sspdtgl - Short Date $xt->assign("sspdtgl_mastervalue", $viewControls->showDBValue("sspdtgl", $data, $keylink)); // sspdjam - Time $xt->assign("sspdjam_mastervalue", $viewControls->showDBValue("sspdjam", $data, $keylink)); // invoice_id - $xt->assign("invoice_id_mastervalue", $viewControls->showDBValue("invoice_id", $data, $keylink)); // keterangan - $xt->assign("keterangan_mastervalue", $viewControls->showDBValue("keterangan", $data, $keylink)); // bulan_telat - $xt->assign("bulan_telat_mastervalue", $viewControls->showDBValue("bulan_telat", $data, $keylink)); // hitung_bunga - $xt->assign("hitung_bunga_mastervalue", $viewControls->showDBValue("hitung_bunga", $data, $keylink)); // denda - Number $xt->assign("denda_mastervalue", $viewControls->showDBValue("denda", $data, $keylink)); // bunga - Number $xt->assign("bunga_mastervalue", $viewControls->showDBValue("bunga", $data, $keylink)); // jml_bayar - $xt->assign("jml_bayar_mastervalue", $viewControls->showDBValue("jml_bayar", $data, $keylink)); // sisa - Number $xt->assign("sisa_mastervalue", $viewControls->showDBValue("sisa", $data, $keylink)); // jenis_bayar - $xt->assign("jenis_bayar_mastervalue", $viewControls->showDBValue("jenis_bayar", $data, $keylink)); // printed - $xt->assign("printed_mastervalue", $viewControls->showDBValue("printed", $data, $keylink)); // tp_id - $xt->assign("tp_id_mastervalue", $viewControls->showDBValue("tp_id", $data, $keylink)); // is_validated - $xt->assign("is_validated_mastervalue", $viewControls->showDBValue("is_validated", $data, $keylink)); // is_valid - $xt->assign("is_valid_mastervalue", $viewControls->showDBValue("is_valid", $data, $keylink)); // enabled - $xt->assign("enabled_mastervalue", $viewControls->showDBValue("enabled", $data, $keylink)); // created - Short Date $xt->assign("created_mastervalue", $viewControls->showDBValue("created", $data, $keylink)); // create_uid - $xt->assign("create_uid_mastervalue", $viewControls->showDBValue("create_uid", $data, $keylink)); // updated - Short Date $xt->assign("updated_mastervalue", $viewControls->showDBValue("updated", $data, $keylink)); // update_uid - $xt->assign("update_uid_mastervalue", $viewControls->showDBValue("update_uid", $data, $keylink)); // petugas_id - $xt->assign("petugas_id_mastervalue", $viewControls->showDBValue("petugas_id", $data, $keylink)); // pejabat_id - $xt->assign("pejabat_id_mastervalue", $viewControls->showDBValue("pejabat_id", $data, $keylink)); $xt->display("pad_pad_sspd_masterprint.htm"); $strTableName = $oldTableName; }
} if ($listarray !== false) { $rs = $listarray; } else { if ($numrows) { $maxrecs = $PageSize; $strSQL .= " limit " . $PageSize . " offset " . ($mypage - 1) * $PageSize; } $rs = db_query($strSQL, $conn); } // hide colunm headers if needed $recordsonpage = $numrows - ($mypage - 1) * $PageSize; if ($recordsonpage > $PageSize) { $recordsonpage = $PageSize; } $xt->assign("page_number", true); $xt->assign("maxpages", $maxpages); $xt->assign("pageno", $mypage); } else { $listarray = false; if ($eventObj->exists("ListQuery")) { $listarray = $eventObj->ListQuery($pageObject->searchClauseObj, $arrFieldForSort, $arrHowFieldSort, $_SESSION[$strTableName . "_mastertable"], $masterKeysReq, $selected_recs, $PageSize, $mypage, $pageObject); } if ($listarray !== false) { $rs = $listarray; } else { $rs = db_query($strSQL, $conn); } $recordsonpage = $numrows; $maxpages = ceil($recordsonpage / 30); $xt->assign("page_number", true);
include('include/xtempl.php'); $xt = new Xtempl(); $h_includes = ""; $b_includes = ""; $h_includes .= ' <link rel="stylesheet" href="'.GetRootPathForResources("include/css/jquery-ui.css").'" type="text/css"> <link rel="stylesheet" href="'.GetRootPathForResources("include/css/dstyle.css").'" type="text/css"> <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.min.js").'"></script> <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.dimensions.pack.js").'"></script> <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery-ui.js").'"></script> '."\r\n"; $xt->assign("h_includes", $h_includes); $arr_UserGroups = GetUserGroup(); $b_includes .= '<script type="text/javascript">'."\r\n"; $b_includes .= ' $(document).ready(function(){ $("#alert").dialog({ title: "Message", draggable: false, resizable: false, bgiframe: true, autoOpen: false, modal: true, buttons: { Ok: function() { $(this).dialog("close");
$inlineview = postvalue("onFly") ? true : false; //If show view as popUp, get parent Id if ($inlineview) { $parId = postvalue("parId"); } else { $parId = 0; } //Set page id if (postvalue("id")) { $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();
$b_includes = ""; $h_includes .= ' <link rel="stylesheet" href="'.GetRootPathForResources("include/css/jquery-ui.css").'" type="text/css"> <link rel="stylesheet" href="'.GetRootPathForResources("include/css/dstyle.css").'" type="text/css"> <link rel="stylesheet" href="'.GetRootPathForResources("include/fancybox/jquery.fancybox.css").'" type="text/css" media="screen"> <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.min.js").'"></script> <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.dimensions.pack.js").'"></script> <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.easing.js").'"></script> <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.fancybox.pack.js").'"></script> <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery-ui.js").'"></script> <script type="text/javascript" src="'.GetRootPathForResources("include/js/json.js").'"></script> '."\r\n"; $xt->assign("h_includes", $h_includes); $_SESSION["webreport".GoodFieldName($_SESSION["webreports"]["settings"]["name"])."_search"]=""; $b_includes .= ' <script type="text/javascript">'."\r\n"; if (is_wr_db() && count($arr_tables_db)) { $b_includes .= ' var NEXT_PAGE_URL = "'.GetTableLink("webreport1").'", PREV_PAGE_URL = "'.GetTableLink("webreport").'"; '."\r\n"; } else { $b_includes .= ' var NEXT_PAGE_URL = "'.GetTableLink("webreport3").'", PREV_PAGE_URL = "'.GetTableLink("webreport").'";
function DisplayMasterTableInfo_app_users($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "app.users"; //$strSQL = "SELECT userid, nama, created, disabled, passwd, id, kd_kantor, kd_kanwil, kd_tp, kd_kanwil_bank, kd_kppbb_bank, kd_bank_tunggal, kd_bank_persepsi, nip, jabatan, handphone, create_uid, update_uid, updated, last_login, is_login, is_logout, last_ip FROM app.users "; $cipherer = new RunnerCipherer($strTableName); $settings = new ProjectSettings($strTableName, PAGE_PRINT); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_PRINT); $where = ""; global $pageObject, $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterprint", "RoundedGreen", "MobileGreen"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["app_users_masterprint"] = $layout; $showKeys = ""; if ($detailtable == "app.user_groups") { $where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[1 - 1], "", "", true); $showKeys .= " " . "Id" . ": " . $keys[1 - 1]; $xt->assign('showKeys', $showKeys); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Export"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->m_where->toSql($masterQuery), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = $cipherer->DecryptFetchedArray($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // userid - $xt->assign("userid_mastervalue", $viewControls->showDBValue("userid", $data, $keylink)); // nama - $xt->assign("nama_mastervalue", $viewControls->showDBValue("nama", $data, $keylink)); // created - Short Date $xt->assign("created_mastervalue", $viewControls->showDBValue("created", $data, $keylink)); // disabled - $xt->assign("disabled_mastervalue", $viewControls->showDBValue("disabled", $data, $keylink)); // passwd - $xt->assign("passwd_mastervalue", $viewControls->showDBValue("passwd", $data, $keylink)); // id - $xt->assign("id_mastervalue", $viewControls->showDBValue("id", $data, $keylink)); // kd_kantor - $xt->assign("kd_kantor_mastervalue", $viewControls->showDBValue("kd_kantor", $data, $keylink)); // kd_kanwil - $xt->assign("kd_kanwil_mastervalue", $viewControls->showDBValue("kd_kanwil", $data, $keylink)); // kd_tp - $xt->assign("kd_tp_mastervalue", $viewControls->showDBValue("kd_tp", $data, $keylink)); // kd_kanwil_bank - $xt->assign("kd_kanwil_bank_mastervalue", $viewControls->showDBValue("kd_kanwil_bank", $data, $keylink)); // kd_kppbb_bank - $xt->assign("kd_kppbb_bank_mastervalue", $viewControls->showDBValue("kd_kppbb_bank", $data, $keylink)); // kd_bank_tunggal - $xt->assign("kd_bank_tunggal_mastervalue", $viewControls->showDBValue("kd_bank_tunggal", $data, $keylink)); // kd_bank_persepsi - $xt->assign("kd_bank_persepsi_mastervalue", $viewControls->showDBValue("kd_bank_persepsi", $data, $keylink)); // nip - $xt->assign("nip_mastervalue", $viewControls->showDBValue("nip", $data, $keylink)); // jabatan - $xt->assign("jabatan_mastervalue", $viewControls->showDBValue("jabatan", $data, $keylink)); // handphone - $xt->assign("handphone_mastervalue", $viewControls->showDBValue("handphone", $data, $keylink)); // create_uid - $xt->assign("create_uid_mastervalue", $viewControls->showDBValue("create_uid", $data, $keylink)); // update_uid - $xt->assign("update_uid_mastervalue", $viewControls->showDBValue("update_uid", $data, $keylink)); // updated - Short Date $xt->assign("updated_mastervalue", $viewControls->showDBValue("updated", $data, $keylink)); // last_login - Short Date $xt->assign("last_login_mastervalue", $viewControls->showDBValue("last_login", $data, $keylink)); // is_login - $xt->assign("is_login_mastervalue", $viewControls->showDBValue("is_login", $data, $keylink)); // is_logout - $xt->assign("is_logout_mastervalue", $viewControls->showDBValue("is_logout", $data, $keylink)); // last_ip - $xt->assign("last_ip_mastervalue", $viewControls->showDBValue("last_ip", $data, $keylink)); $xt->display("app_users_masterprint.htm"); $strTableName = $oldTableName; }
//array of params for classes $params = array(); $params["id"] = $id; $params["xt"] =& $xt; $params["pageType"] = PAGE_LOGIN; $params["tName"] = NOT_TABLE_BASED_TNAME; $params["templatefile"] = "login.htm"; $params["needSearchClauseObj"] = false; $pageObject = new LoginPage($params); $pageObject->init(); $adSubmit = false; // begin proccess captcha $pageObject->isCaptchaOk = 1; $useCaptcha = false; // end proccess captcha $xt->assign("loginlink_attrs", 'id="submitLogin' . $id . '"'); // Before Process event if ($globalEvents->exists("BeforeProcessLogin")) { $globalEvents->BeforeProcessLogin($pageObject); } $myurl = @$_SESSION["MyURL"]; // clear saved URL if not received return=true if (postvalue("return") != "true" && @$_POST["btnSubmit"] != "Login" && !$adSubmit) { $myurl = ""; } unset($_SESSION["MyURL"]); if (postvalue("a") == "logout") { $pageObject->Logout(true); } $pageObject->fromFacebook = false; $_SESSION["fromFacebook"] = false;
//$gQuery->ReplaceFieldsWithDummies(GetBinaryFieldsIndices()); $cipherer = new RunnerCipherer($strTableName); $strWhereClause = ""; $strHavingClause = ""; $strSearchCriteria = "and"; $selected_recs = array(); $options = "1"; header("Expires: Thu, 01 Jan 1970 00:00:01 GMT"); include 'include/xtempl.php'; include 'classes/runnerpage.php'; $xt = new Xtempl(); $id = postvalue("id") != "" ? postvalue("id") : 1; $phpVersion = (int) substr(phpversion(), 0, 1); if ($phpVersion > 4) { include "include/export_functions.php"; $xt->assign("groupExcel", true); } else { $xt->assign("excel", true); } //array of params for classes $params = array("pageType" => PAGE_EXPORT, "id" => $id, "tName" => $strTableName); $params["xt"] =& $xt; if (!$eventObj->exists("ListGetRowCount") && !$eventObj->exists("ListQuery")) { $params["needSearchClauseObj"] = false; } $pageObject = new RunnerPage($params); // Before Process event if ($eventObj->exists("BeforeProcessExport")) { $eventObj->BeforeProcessExport($conn, $pageObject); } if (@$_REQUEST["a"] != "") {
function DisplayMasterTableInfo_pad_pad_kelurahan($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; $detailPageObj = $params["detailPageObj"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "pad.pad_kelurahan"; $settings = new ProjectSettings($strTableName, PAGE_LIST); $cipherer = new RunnerCipherer($strTableName); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_LIST); $where = ""; $mKeys = array(); $showKeys = ""; global $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterlist", "RoundedGreen", "MobileGreen"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterlistheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterlistfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["pad_pad_kelurahan_masterlist"] = $layout; if ($detailtable == "pad.pad_customer_usaha") { $where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[1 - 1], "", "", true); $showKeys .= " " . "Id" . ": " . $keys[1 - 1]; $xt->assign('showKeys', $showKeys); } if ($detailtable == "pad.pad_customer") { $where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[1 - 1], "", "", true); $showKeys .= " " . "Id" . ": " . $keys[1 - 1]; $xt->assign('showKeys', $showKeys); } if ($detailtable == "pad.pad_daftar") { $where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[1 - 1], "", "", true); $showKeys .= " " . "Id" . ": " . $keys[1 - 1]; $where .= " and "; $showKeys .= " , "; $where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[2 - 1], "", "", true); $showKeys .= " " . "Id" . ": " . $keys[2 - 1]; $xt->assign('showKeys', $showKeys); } if (!$where) { $strTableName = $oldTableName; 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(); // $strSQL = AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = $cipherer->DecryptFetchedArray($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $value = ""; $xt->assign("id_mastervalue", $viewControls->showDBValue("id", $data, $keylink)); // kecamatan_id - $value = ""; $xt->assign("kecamatan_id_mastervalue", $viewControls->showDBValue("kecamatan_id", $data, $keylink)); // kode - $value = ""; $xt->assign("kode_mastervalue", $viewControls->showDBValue("kode", $data, $keylink)); // nama - $value = ""; $xt->assign("nama_mastervalue", $viewControls->showDBValue("nama", $data, $keylink)); // tmt - Short Date $value = ""; $xt->assign("tmt_mastervalue", $viewControls->showDBValue("tmt", $data, $keylink)); // enabled - $value = ""; $xt->assign("enabled_mastervalue", $viewControls->showDBValue("enabled", $data, $keylink)); // created - Short Date $value = ""; $xt->assign("created_mastervalue", $viewControls->showDBValue("created", $data, $keylink)); // create_uid - $value = ""; $xt->assign("create_uid_mastervalue", $viewControls->showDBValue("create_uid", $data, $keylink)); // updated - Short Date $value = ""; $xt->assign("updated_mastervalue", $viewControls->showDBValue("updated", $data, $keylink)); // update_uid - $value = ""; $xt->assign("update_uid_mastervalue", $viewControls->showDBValue("update_uid", $data, $keylink)); $viewControls->addControlsJSAndCSS(); $detailPageObj->viewControlsMap['mViewControlsMap'] = $viewControls->viewControlsMap; $layout = GetPageLayout("pad_pad_kelurahan", 'masterlist'); if ($layout) { $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"'); } $xt->display("pad_pad_kelurahan_masterlist.htm"); $strTableName = $oldTableName; }
$inlineview = postvalue("onFly") ? true : false; //If show view as popUp, get parent Id if ($inlineview) { $parId = postvalue("parId"); } else { $parId = 0; } //Set page id if (postvalue("id")) { $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; $params["all"] = $all; //Get array of tabs for edit page $params['useTabsOnView'] = $gSettings->useTabsOnView(); if ($params['useTabsOnView']) { $params['arrViewTabs'] = $gSettings->getViewTabs(); } $pageObject = new ViewPage($params); // SearchClause class stuff $pageObject->searchClauseObj->parseRequest(); $_SESSION[$strTableName . '_advsearch'] = serialize($pageObject->searchClauseObj); // proccess big google maps // add button events if exist
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 ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("USUARIO_CREACION"))) { $class = ' rnr-field-number'; } $xt->assign("USUARIO_CREACION_class", $class); // add class for field header as field value $xt->assign("FEC_ULTIMA_MOD_mastervalue", $viewControls->showDBValue("FEC_ULTIMA_MOD", $data, $keylink)); $format = $settings->getViewFormat("FEC_ULTIMA_MOD"); $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_ULTIMA_MOD"))) { $class = ' rnr-field-number'; } $xt->assign("FEC_ULTIMA_MOD_class", $class); // add class for field header as field value $xt->assign("USUARIO_ULTIMA_MOD_mastervalue", $viewControls->showDBValue("USUARIO_ULTIMA_MOD", $data, $keylink)); $format = $settings->getViewFormat("USUARIO_ULTIMA_MOD"); $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("USUARIO_ULTIMA_MOD"))) { $class = ' rnr-field-number'; } $xt->assign("USUARIO_ULTIMA_MOD_class", $class); // add class for field header as field value $layout = GetPageLayout("GE_ESTADO_CIVIL", 'masterlist'); if ($layout) { $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"'); } $xt->displayPartial(GetTemplateName("GE_ESTADO_CIVIL", "masterlist")); }
///////////////////////////////////////////////////////////// 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) { $id = 1; } $flyId = $id + 1; $xt = new Xtempl(); // assign an id $xt->assign("id", $id); $templatefile = $inlineedit == EDIT_INLINE ? "public_pad_payment_inline_edit.htm" : "public_pad_payment_edit.htm"; //array of params for classes $params = array("pageType" => PAGE_EDIT, "id" => $id); $params['tName'] = $strTableName; $params['xt'] =& $xt; $params['mode'] = $inlineedit; $params['includes_js'] = $includes_js; $params['includes_jsreq'] = $includes_jsreq; $params['includes_css'] = $includes_css; $params['locale_info'] = $locale_info; $params['templatefile'] = $templatefile; $params['pageEditLikeInline'] = $inlineedit == EDIT_INLINE; //Get array of tabs for edit page $params['useTabsOnEdit'] = $gSettings->useTabsOnEdit(); if ($params['useTabsOnEdit']) {
$message = ""; $next = array(); $prev = array(); $all = postvalue("all"); $pdf = postvalue("pdf"); //Show view page as popUp or not $inlineview = postvalue("onFly") ? true : false; //If show view as popUp, get parent Id $parId = $inlineview ? postvalue("parId") : 0; //Set page id $id = postvalue("id"); $id = $id ? $id : 1; $xt->assign("id", $id); $keys = array(); $keys["id"] = postvalue("editid1"); //array of params for classes $params = array("pageType" => PAGE_VIEW); $params["id"] = $id; $params["xt"] = &$xt; $params["all"] = $all; $params["keys"] = $keys; $params["tName"] = $strTableName; //Get array of tabs for edit page $params['useTabsOnView'] = $gSettings->useTabsOnView(); if( $params['useTabsOnView'] ) $params['arrViewTabs'] = $gSettings->getViewTabs();
function runner_error_handler($errno, $errstr, $errfile, $errline) { global $strLastSQL; if ($errno == 2048) { return 0; } if ($errno == 8192) { if ($errstr == "Assigning the return value of new by reference is deprecated") { return 0; } if (strpos($errstr, "set_magic_quotes_runtime")) { return 0; } } if ($errno == 2 && strpos($errstr, "has been disabled for security reasons")) { return 0; } if ($errno == 2 && strpos($errstr, "Data is not in a recognized format")) { return 0; } if ($errno == 8 && !strncmp($errstr, "Undefined index", 15)) { return 0; } if (strpos($errstr, "It is not safe to rely on the system's timezone settings.")) { return 0; } if (strpos($errstr, "fopen(") === 0) { return 0; } // show error htm if (!class_exists("Xtempl")) { require_once getabspath("include/xtempl.php"); } $xt = new Xtempl(); $xt->assign('errno', $errno); $xt->assign('errstr', $errstr); $url = $_SERVER["SERVER_NAME"] . $_SERVER["SCRIPT_NAME"]; if (array_key_exists("QUERY_STRING", $_SERVER)) { $url .= "?" . htmlspecialchars($_SERVER["QUERY_STRING"]); } $xt->assign('url', $url); $xt->assign('errfile', $errfile); $xt->assign('errline', $errline); $sqlStr = isset($strLastSQL) ? htmlspecialchars(substr($strLastSQL, 0, 1024)) : ''; $xt->assign('sqlStr', $sqlStr); $debugInfoArr = parse_backtrace($errfile, $errline); $xt->assign_loopsection('debugRow', $debugInfoArr); $xt->display('error.htm'); exit(0); }
$templatefile = "pad_pad_terima_line_inline_add.htm"; } else { $templatefile = "pad_pad_terima_line_add.htm"; } $id = postvalue("id"); if (intval($id) == 0) { $id = 1; } //If undefined session value for mastet table, but exist post value master table, than take second //It may be happen only when use dpInline mode on page add if (!@$_SESSION[$sessionPrefix . "_mastertable"] && postvalue("mastertable")) { $_SESSION[$sessionPrefix . "_mastertable"] = postvalue("mastertable"); } $xt = new Xtempl(); // assign an id $xt->assign("id", $id); $auditObj = GetAuditObject($strTableName); //array of params for classes $params = array("pageType" => PAGE_ADD, "id" => $id, "mode" => $inlineadd); $params['xt'] =& $xt; $params['tName'] = $strTableName; $params['includes_js'] = $includes_js; $params['locale_info'] = $locale_info; $params['includes_css'] = $includes_css; $params['useTabsOnAdd'] = $gSettings->useTabsOnAdd(); $params['templatefile'] = $templatefile; $params['includes_jsreq'] = $includes_jsreq; $params['pageAddLikeInline'] = $inlineadd == ADD_INLINE; $params['needSearchClauseObj'] = false; $params['strOriginalTableName'] = $strOriginalTableName; if ($params['useTabsOnAdd']) {
if ($mastertable == "pad.pad_kecamatan") { $where = ""; $where .= GetFullFieldName("kecamatan_id", $strTableName, false) . "=" . make_db_value("kecamatan_id", $_SESSION[$strTableName . "_masterkey1"]); } if ($mastertable == "pad.pad_kelurahan") { $where = ""; $where .= GetFullFieldName("kelurahan_id", $strTableName, false) . "=" . make_db_value("kelurahan_id", $_SESSION[$strTableName . "_masterkey1"]); } $str = SecuritySQL("Search"); if (strlen($str)) { $where .= " and " . $str; } $strSQL = $gQuery->gSQLWhere($where); $strSQL .= " " . $gstrOrderBy; $rowcount = $gQuery->gSQLRowCount($where); $xt->assign("row_count", $rowcount); if ($rowcount) { $xt->assign("details_data", true); $rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs);
$templatefile = "pad_pad_teguran_inline_add.htm"; } else { $templatefile = "pad_pad_teguran_add.htm"; } $id = postvalue("id"); if (intval($id) == 0) { $id = 1; } //If undefined session value for mastet table, but exist post value master table, than take second //It may be happen only when use dpInline mode on page add if (!@$_SESSION[$sessionPrefix . "_mastertable"] && postvalue("mastertable")) { $_SESSION[$sessionPrefix . "_mastertable"] = postvalue("mastertable"); } $xt = new Xtempl(); // assign an id $xt->assign("id", $id); $auditObj = GetAuditObject($strTableName); //array of params for classes $params = array("pageType" => PAGE_ADD, "id" => $id, "mode" => $inlineadd); $params['xt'] =& $xt; $params['tName'] = $strTableName; $params['includes_js'] = $includes_js; $params['locale_info'] = $locale_info; $params['includes_css'] = $includes_css; $params['useTabsOnAdd'] = $gSettings->useTabsOnAdd(); $params['templatefile'] = $templatefile; $params['includes_jsreq'] = $includes_jsreq; $params['pageAddLikeInline'] = $inlineadd == ADD_INLINE; $params['needSearchClauseObj'] = false; $params['strOriginalTableName'] = $strOriginalTableName; if ($params['useTabsOnAdd']) {
// 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>'; $pageObject->body['end'] .= "window.controlsMap = " . my_json_encode($pageObject->controlsHTMLMap) . ";"; $pageObject->body['end'] .= "window.settings = " . my_json_encode($pageObject->jsSettings) . ";"; $pageObject->body['end'] .= '</script>'; $pageObject->body["end"] .= "<script language=\"JavaScript\" src=\"include/runnerJS/RunnerAll.js\"></script>\r\n"; $pageObject->addCommonJs(); $pageObject->body["end"] .= "<script>" . $pageObject->PrepareJS() . "</script>"; $xt->assignbyref("body", $pageObject->body); $xt->assign("importfile_attrs", "id=\"file_ImportFileName" . $pageObject->id . "\" name=\"file_ImportFileName" . $pageObject->id . "\""); $xt->assign("backtolist_attrs", "id=\"backButton" . $pageObject->id . "\""); $xt->assign("importlink_attrs", "id=\"saveButton" . $pageObject->id . "\""); $xt->assign("error_message", $error_message); $xt->display("Readings_import.htm"); ?>
function DisplayMasterTableInfo_Module($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "dbo.Module"; //$strSQL = "SELECT ID, [Module Type], [Module Status], [Module Condition], [Serial Num], [Entry Date] FROM dbo.[Module]"; $sqlHead = "SELECT ID, [Module Type], [Module Status], [Module Condition], [Serial Num], [Entry Date]"; $sqlFrom = "FROM dbo.[Module]"; $sqlWhere = ""; $sqlTail = ""; $where = ""; global $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterprint", "BoldOrange", "MobileOrange"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["Module_masterprint"] = $layout; if ($detailtable == "dbo.Anomalies") { $where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]); } if ($detailtable == "dbo.Customer Module Assignment") { $where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]); } if ($detailtable == "dbo.Readings") { $where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Export"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($sqlWhere, $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $sqlHead . ' ' . $sqlFrom . $strWhere . $sqlTail; // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = db_fetch_array($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["ID"])); // ID - $value = ""; $value = ProcessLargeText(GetData($data, "ID", ""), "field=ID" . $keylink, "", MODE_PRINT); $xt->assign("ID_mastervalue", $value); // Module Type - $value = ""; $value = DisplayLookupWizard("Module Type", $data["Module Type"], $data, $keylink, MODE_PRINT); $xt->assign("Module_Type_mastervalue", $value); // Module Status - $value = ""; $value = DisplayLookupWizard("Module Status", $data["Module Status"], $data, $keylink, MODE_PRINT); $xt->assign("Module_Status_mastervalue", $value); // Module Condition - $value = ""; $value = DisplayLookupWizard("Module Condition", $data["Module Condition"], $data, $keylink, MODE_PRINT); $xt->assign("Module_Condition_mastervalue", $value); // Serial Num - $value = ""; $value = ProcessLargeText(GetData($data, "Serial Num", ""), "field=Serial+Num" . $keylink, "", MODE_PRINT); $xt->assign("Serial_Num_mastervalue", $value); // Entry Date - Short Date $value = ""; $value = ProcessLargeText(GetData($data, "Entry Date", "Short Date"), "field=Entry+Date" . $keylink, "", MODE_PRINT); $xt->assign("Entry_Date_mastervalue", $value); $xt->display("Module_masterprint.htm"); $strTableName = $oldTableName; }
$templatefile = "pad_pad_customer_inline_add.htm"; } else { $templatefile = "pad_pad_customer_add.htm"; } $id = postvalue("id"); if (intval($id) == 0) { $id = 1; } //If undefined session value for mastet table, but exist post value master table, than take second //It may be happen only when use dpInline mode on page add if (!@$_SESSION[$sessionPrefix . "_mastertable"] && postvalue("mastertable")) { $_SESSION[$sessionPrefix . "_mastertable"] = postvalue("mastertable"); } $xt = new Xtempl(); // assign an id $xt->assign("id", $id); $auditObj = GetAuditObject($strTableName); //array of params for classes $params = array("pageType" => PAGE_ADD, "id" => $id, "mode" => $inlineadd); $params['xt'] =& $xt; $params['tName'] = $strTableName; $params['includes_js'] = $includes_js; $params['locale_info'] = $locale_info; $params['includes_css'] = $includes_css; $params['useTabsOnAdd'] = $gSettings->useTabsOnAdd(); $params['templatefile'] = $templatefile; $params['includes_jsreq'] = $includes_jsreq; $params['pageAddLikeInline'] = $inlineadd == ADD_INLINE; $params['needSearchClauseObj'] = false; $params['strOriginalTableName'] = $strOriginalTableName; if ($params['useTabsOnAdd']) {
$layout->skinsparams["menu"] = array("button" => "button1"); $layout->skinsparams["hmenu"] = array("button" => "button1"); $layout->skinsparams["undermenu"] = array("button" => "button1"); $layout->skinsparams["fields"] = array("button" => "button1"); $layout->skinsparams["form"] = array("button" => "button1"); $layout->skinsparams["1"] = array("button" => "button1"); $layout->skinsparams["2"] = array("button" => "button1"); $layout->skinsparams["3"] = array("button" => "button1"); $params = array(); $params["id"] = $id; $params['xt'] =& $xt; $params['tName'] = $strTableName; $params["pageType"] = PAGE_REGISTER; $params["templatefile"] = "register.htm"; $params["needSearchClauseObj"] = false; $xt->assign("closewindow_attrs", 'style="display:none" id="closeWindowRegister"'); $xt->eventsObject =& $globalEvents; $pageObject = new RegisterPage($params); $pageObject->init(); $isUseCaptcha = $globalEvents->existsCAPTCHA(PAGE_REGISTER); // Before Process event if ($globalEvents->exists("BeforeProcessRegister")) { $globalEvents->BeforeProcessRegister($pageObject); } //Send activation link to user's email $includes = GetBaseScriptsForPage(false); if (@$_GET["a"] == "activate") { $username = base64_decode(@$_GET["u"]); $code = @$_GET["code"]; if ($regCipherer->isFieldEncrypted("username")) { $strUsername = $regCipherer->MakeDBValue("username", $username, "", true);