$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);
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));
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").'";
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_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
}
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);
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 (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));
/////////////////////////////////////////////////////////////
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);
