function DisplayMasterTableInfo_pad_pad_customer_usaha($params)
{
$detailtable = $params["detailtable"];
$keys = $params["keys"];
$detailPageObj = $params["detailPageObj"];
global $conn, $strTableName;
$xt = new Xtempl();
$oldTableName = $strTableName;
$strTableName = "pad.pad_customer_usaha";
$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_customer_usaha_masterlist"] = $layout;
if ($detailtable == "pad.pad_spt") {
$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("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));
// konterid -
$value = "";
$xt->assign("konterid_mastervalue", $viewControls->showDBValue("konterid", $data, $keylink));
// reg_date - Short Date
$value = "";
$xt->assign("reg_date_mastervalue", $viewControls->showDBValue("reg_date", $data, $keylink));
// customer_id -
$value = "";
$xt->assign("customer_id_mastervalue", $viewControls->showDBValue("customer_id", $data, $keylink));
// usaha_id -
$value = "";
$xt->assign("usaha_id_mastervalue", $viewControls->showDBValue("usaha_id", $data, $keylink));
// so -
$value = "";
$xt->assign("so_mastervalue", $viewControls->showDBValue("so", $data, $keylink));
// kecamatan_id -
$value = "";
$xt->assign("kecamatan_id_mastervalue", $viewControls->showDBValue("kecamatan_id", $data, $keylink));
// kelurahan_id -
$value = "";
$xt->assign("kelurahan_id_mastervalue", $viewControls->showDBValue("kelurahan_id", $data, $keylink));
// notes -
$value = "";
$xt->assign("notes_mastervalue", $viewControls->showDBValue("notes", $data, $keylink));
// enabled -
$value = "";
$xt->assign("enabled_mastervalue", $viewControls->showDBValue("enabled", $data, $keylink));
// create_uid -
$value = "";
$xt->assign("create_uid_mastervalue", $viewControls->showDBValue("create_uid", $data, $keylink));
// customer_status_id -
$value = "";
$xt->assign("customer_status_id_mastervalue", $viewControls->showDBValue("customer_status_id", $data, $keylink));
// aktifnotes -
$value = "";
$xt->assign("aktifnotes_mastervalue", $viewControls->showDBValue("aktifnotes", $data, $keylink));
// tmt - Short Date
$value = "";
$xt->assign("tmt_mastervalue", $viewControls->showDBValue("tmt", $data, $keylink));
// air_zona_id -
$value = "";
$xt->assign("air_zona_id_mastervalue", $viewControls->showDBValue("air_zona_id", $data, $keylink));
// air_manfaat_id -
$value = "";
$xt->assign("air_manfaat_id_mastervalue", $viewControls->showDBValue("air_manfaat_id", $data, $keylink));
// def_pajak_id -
$value = "";
$xt->assign("def_pajak_id_mastervalue", $viewControls->showDBValue("def_pajak_id", $data, $keylink));
// opnm -
$value = "";
$xt->assign("opnm_mastervalue", $viewControls->showDBValue("opnm", $data, $keylink));
// opalamat -
$value = "";
$xt->assign("opalamat_mastervalue", $viewControls->showDBValue("opalamat", $data, $keylink));
// latitude - Number
$value = "";
$xt->assign("latitude_mastervalue", $viewControls->showDBValue("latitude", $data, $keylink));
// longitude - Number
$value = "";
$xt->assign("longitude_mastervalue", $viewControls->showDBValue("longitude", $data, $keylink));
// created - Short Date
$value = "";
$xt->assign("created_mastervalue", $viewControls->showDBValue("created", $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));
// kd_restojmlmeja -
$value = "";
$xt->assign("kd_restojmlmeja_mastervalue", $viewControls->showDBValue("kd_restojmlmeja", $data, $keylink));
// kd_restojmlkursi -
$value = "";
$xt->assign("kd_restojmlkursi_mastervalue", $viewControls->showDBValue("kd_restojmlkursi", $data, $keylink));
// kd_restojmltamu -
$value = "";
$xt->assign("kd_restojmltamu_mastervalue", $viewControls->showDBValue("kd_restojmltamu", $data, $keylink));
// kd_filmkursi -
$value = "";
$xt->assign("kd_filmkursi_mastervalue", $viewControls->showDBValue("kd_filmkursi", $data, $keylink));
// kd_filmpertunjukan -
$value = "";
$xt->assign("kd_filmpertunjukan_mastervalue", $viewControls->showDBValue("kd_filmpertunjukan", $data, $keylink));
// kd_filmtarif - Number
$value = "";
$xt->assign("kd_filmtarif_mastervalue", $viewControls->showDBValue("kd_filmtarif", $data, $keylink));
// kd_bilyarmeja -
$value = "";
$xt->assign("kd_bilyarmeja_mastervalue", $viewControls->showDBValue("kd_bilyarmeja", $data, $keylink));
// kd_bilyartarif - Number
$value = "";
$xt->assign("kd_bilyartarif_mastervalue", $viewControls->showDBValue("kd_bilyartarif", $data, $keylink));
// kd_bilyarkegiatan -
$value = "";
$xt->assign("kd_bilyarkegiatan_mastervalue", $viewControls->showDBValue("kd_bilyarkegiatan", $data, $keylink));
// kd_diskopengunjung -
$value = "";
$xt->assign("kd_diskopengunjung_mastervalue", $viewControls->showDBValue("kd_diskopengunjung", $data, $keylink));
// kd_diskotarif - Number
$value = "";
$xt->assign("kd_diskotarif_mastervalue", $viewControls->showDBValue("kd_diskotarif", $data, $keylink));
// mall_id -
$value = "";
$xt->assign("mall_id_mastervalue", $viewControls->showDBValue("mall_id", $data, $keylink));
// cash_register -
$value = "";
$xt->assign("cash_register_mastervalue", $viewControls->showDBValue("cash_register", $data, $keylink));
// pelaporan -
$value = "";
$xt->assign("pelaporan_mastervalue", $viewControls->showDBValue("pelaporan", $data, $keylink));
// pembukuan -
$value = "";
$xt->assign("pembukuan_mastervalue", $viewControls->showDBValue("pembukuan", $data, $keylink));
// bandara -
$value = "";
$xt->assign("bandara_mastervalue", $viewControls->showDBValue("bandara", $data, $keylink));
// wajib_pajak -
$value = "";
$xt->assign("wajib_pajak_mastervalue", $viewControls->showDBValue("wajib_pajak", $data, $keylink));
// jumlah_karyawan -
$value = "";
$xt->assign("jumlah_karyawan_mastervalue", $viewControls->showDBValue("jumlah_karyawan", $data, $keylink));
// tanggal_tutup - Short Date
$value = "";
$xt->assign("tanggal_tutup_mastervalue", $viewControls->showDBValue("tanggal_tutup", $data, $keylink));
// parkir_luas -
$value = "";
$xt->assign("parkir_luas_mastervalue", $viewControls->showDBValue("parkir_luas", $data, $keylink));
// parkir_masuk -
$value = "";
$xt->assign("parkir_masuk_mastervalue", $viewControls->showDBValue("parkir_masuk", $data, $keylink));
// parkir_tarif_mobil - Number
$value = "";
$xt->assign("parkir_tarif_mobil_mastervalue", $viewControls->showDBValue("parkir_tarif_mobil", $data, $keylink));
// parkir_tambahan - Number
$value = "";
$xt->assign("parkir_tambahan_mastervalue", $viewControls->showDBValue("parkir_tambahan", $data, $keylink));
// parkir_kapasitas_mobil -
$value = "";
$xt->assign("parkir_kapasitas_mobil_mastervalue", $viewControls->showDBValue("parkir_kapasitas_mobil", $data, $keylink));
// parkir_mobil_hari -
$value = "";
$xt->assign("parkir_mobil_hari_mastervalue", $viewControls->showDBValue("parkir_mobil_hari", $data, $keylink));
// parkir_keluar -
$value = "";
$xt->assign("parkir_keluar_mastervalue", $viewControls->showDBValue("parkir_keluar", $data, $keylink));
// parkir_motor_luas -
$value = "";
$xt->assign("parkir_motor_luas_mastervalue", $viewControls->showDBValue("parkir_motor_luas", $data, $keylink));
// parkir_motor_masuk -
$value = "";
$xt->assign("parkir_motor_masuk_mastervalue", $viewControls->showDBValue("parkir_motor_masuk", $data, $keylink));
// parkir_motor_keluar -
$value = "";
$xt->assign("parkir_motor_keluar_mastervalue", $viewControls->showDBValue("parkir_motor_keluar", $data, $keylink));
// parkir_tarif_motor - Number
$value = "";
$xt->assign("parkir_tarif_motor_mastervalue", $viewControls->showDBValue("parkir_tarif_motor", $data, $keylink));
// parkir_motor_tambahan - Number
$value = "";
$xt->assign("parkir_motor_tambahan_mastervalue", $viewControls->showDBValue("parkir_motor_tambahan", $data, $keylink));
// parkir_kapasitas_motor -
$value = "";
$xt->assign("parkir_kapasitas_motor_mastervalue", $viewControls->showDBValue("parkir_kapasitas_motor", $data, $keylink));
// parkir_motor_hari -
$value = "";
$xt->assign("parkir_motor_hari_mastervalue", $viewControls->showDBValue("parkir_motor_hari", $data, $keylink));
// kelompok_usaha_id -
$value = "";
$xt->assign("kelompok_usaha_id_mastervalue", $viewControls->showDBValue("kelompok_usaha_id", $data, $keylink));
// zona_id -
$value = "";
$xt->assign("zona_id_mastervalue", $viewControls->showDBValue("zona_id", $data, $keylink));
// manfaat_id -
$value = "";
$xt->assign("manfaat_id_mastervalue", $viewControls->showDBValue("manfaat_id", $data, $keylink));
// golongan_id -
$value = "";
$xt->assign("golongan_id_mastervalue", $viewControls->showDBValue("golongan_id", $data, $keylink));
// id_old -
$value = "";
$xt->assign("id_old_mastervalue", $viewControls->showDBValue("id_old", $data, $keylink));
$viewControls->addControlsJSAndCSS();
$detailPageObj->viewControlsMap['mViewControlsMap'] = $viewControls->viewControlsMap;
$layout = GetPageLayout("pad_pad_customer_usaha", 'masterlist');
if ($layout) {
$xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"');
}
$xt->display("pad_pad_customer_usaha_masterlist.htm");
$strTableName = $oldTableName;
}
$master["func"] = "DisplayMasterTableInfo_pad_pad_daftar_status";
$master["params"] = $params;
$xt->assignbyref("showmasterfile", $master);
$xt->assign("mastertable_block", true);
$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_daftar_status_masterprint"] = $layout;
$layout = GetPageLayout("pad_pad_daftar_status", 'masterprint');
if ($layout) {
$rtl = $pageObject->xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
}
$strSQL = $_SESSION[$strTableName . "_sql"];
$isPdfView = false;
$hasEvents = false;
if ($pageObject->pSet->isUsebuttonHandlers() || $isPdfView || $hasEvents) {
$pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/loadfirst.js\"></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) . ";";
// update_uid -
$viewContainer->recId = $recordsCounter;
$value = $viewContainer->showDBValue("update_uid", $data, $keylink);
$row["update_uid_value"] = $value;
// npwpd_old -
$viewContainer->recId = $recordsCounter;
$value = $viewContainer->showDBValue("npwpd_old", $data, $keylink);
$row["npwpd_old_value"] = $value;
// id_old -
$viewContainer->recId = $recordsCounter;
$value = $viewContainer->showDBValue("id_old", $data, $keylink);
$row["id_old_value"] = $value;
$rowinfo[] = $row;
$data = $cipherer->DecryptFetchedArray($rs);
}
$xt->assign_loopsection("details_row", $rowinfo);
}
$returnJSON = array("success" => true);
$xt->load_template("pad_pad_customer_detailspreview.htm");
$returnJSON["body"] = $xt->fetch_loaded();
if ($mode != "inline") {
$returnJSON["counter"] = postvalue("counter");
$layout = GetPageLayout(GoodFieldName($strTableName), 'detailspreview');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$returnJSON["style"] = "styles/" . $layout->style . "/style" . $rtl . ".css";
$returnJSON["pageStyle"] = "pagestyles/" . $layout->name . $rtl . ".css";
$returnJSON["layout"] = $layout->style . " page-" . $layout->name . ".css";
}
}
echo "<textarea>" . htmlspecialchars(my_json_encode($returnJSON)) . "</textarea>";
$master["func"] = "DisplayMasterTableInfo_pad_pad_usaha";
$master["params"] = $params;
$xt->assignbyref("showmasterfile", $master);
$xt->assign("mastertable_block", true);
$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_usaha_masterprint"] = $layout;
$layout = GetPageLayout("pad_pad_usaha", 'masterprint');
if ($layout) {
$rtl = $pageObject->xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
}
$strSQL = $_SESSION[$strTableName . "_sql"];
$isPdfView = false;
$hasEvents = false;
if ($pageObject->pSet->isUsebuttonHandlers() || $isPdfView || $hasEvents) {
$pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/loadfirst.js\"></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) . ";";
$master["func"] = "DisplayMasterTableInfo_pad_pad_customer";
$master["params"] = $params;
$xt->assignbyref("showmasterfile", $master);
$xt->assign("mastertable_block", true);
$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_customer_masterprint"] = $layout;
$layout = GetPageLayout("pad_pad_customer", 'masterprint');
if ($layout) {
$rtl = $pageObject->xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
}
$strSQL = $_SESSION[$strTableName . "_sql"];
$isPdfView = false;
$hasEvents = false;
if ($pageObject->pSet->isUsebuttonHandlers() || $isPdfView || $hasEvents) {
$pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/loadfirst.js\"></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) . ";";
$options["masterKeysReq"][$i] = $_REQUEST["masterkey" . $i];
$i++;
}
$pageObject = ListPage::createListPage($strTableName, $options);
$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["app_apps_masterlist"] = $layout;
$layout = GetPageLayout("app_apps", 'masterlist');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
include_once getabspath('classes/controls/ViewControlsContainer.php');
$viewControls = new ViewControlsContainer(new ProjectSettings("app.apps", PAGE_LIST), PAGE_LIST);
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
if (!$noBlobReplace) {
$gQuery->ReplaceFieldsWithDummies($pageObject->pSet->getBinaryFieldsIndices());
}
if ($mode != LIST_DETAILS) {
$options["masterKeysReq"][$i] = $_REQUEST["masterkey" . $i];
$i++;
}
$pageObject = ListPage::createListPage($strTableName, $options);
$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_jenis_pajak_masterlist"] = $layout;
$layout = GetPageLayout("pad_pad_jenis_pajak", 'masterlist');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
include_once getabspath('classes/controls/ViewControlsContainer.php');
$viewControls = new ViewControlsContainer(new ProjectSettings("pad.pad_jenis_pajak", PAGE_LIST), PAGE_LIST);
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
if (!$noBlobReplace) {
$gQuery->ReplaceFieldsWithDummies($pageObject->pSet->getBinaryFieldsIndices());
}
if ($mode != LIST_DETAILS) {
$master["func"] = "DisplayMasterTableInfo_pad_pad_sspd";
$master["params"] = $params;
$xt->assignbyref("showmasterfile", $master);
$xt->assign("mastertable_block", true);
$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;
$layout = GetPageLayout("pad_pad_sspd", 'masterprint');
if ($layout) {
$rtl = $pageObject->xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
}
$strSQL = $_SESSION[$strTableName . "_sql"];
$isPdfView = false;
$hasEvents = false;
if ($pageObject->pSet->isUsebuttonHandlers() || $isPdfView || $hasEvents) {
$pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/loadfirst.js\"></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) . ";";
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
$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_usaha_masterlist"] = $layout;
$layout = GetPageLayout("pad_pad_usaha", 'masterlist');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
include_once getabspath('classes/controls/ViewControlsContainer.php');
$viewControls = new ViewControlsContainer(new ProjectSettings("pad.pad_usaha", PAGE_LIST), PAGE_LIST);
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
if (!$noBlobReplace) {
$gQuery->ReplaceFieldsWithDummies($pageObject->pSet->getBinaryFieldsIndices());
}
if ($mode != LIST_DETAILS) {
$master["func"] = "DisplayMasterTableInfo_pad_pad_kecamatan";
$master["params"] = $params;
$xt->assignbyref("showmasterfile", $master);
$xt->assign("mastertable_block", true);
$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_kecamatan_masterprint"] = $layout;
$layout = GetPageLayout("pad_pad_kecamatan", 'masterprint');
if ($layout) {
$rtl = $pageObject->xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
}
$strSQL = $_SESSION[$strTableName . "_sql"];
$isPdfView = false;
$hasEvents = false;
if ($pageObject->pSet->isUsebuttonHandlers() || $isPdfView || $hasEvents) {
$pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/loadfirst.js\"></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) . ";";
$options["masterKeysReq"][$i] = $_REQUEST["masterkey" . $i];
$i++;
}
$pageObject = ListPage::createListPage($strTableName, $options);
$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_daftar_masterlist"] = $layout;
$layout = GetPageLayout("pad_pad_daftar", 'masterlist');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
include_once getabspath('classes/controls/ViewControlsContainer.php');
$viewControls = new ViewControlsContainer(new ProjectSettings("pad.pad_daftar", PAGE_LIST), PAGE_LIST);
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
if (!$noBlobReplace) {
$gQuery->ReplaceFieldsWithDummies($pageObject->pSet->getBinaryFieldsIndices());
}
if ($mode != LIST_DETAILS) {
$master["func"] = "DisplayMasterTableInfo_pad_pad_reklame_kelas_jalan";
$master["params"] = $params;
$xt->assignbyref("showmasterfile", $master);
$xt->assign("mastertable_block", true);
$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_reklame_kelas_jalan_masterprint"] = $layout;
$layout = GetPageLayout("pad_pad_reklame_kelas_jalan", 'masterprint');
if ($layout) {
$rtl = $pageObject->xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
}
$strSQL = $_SESSION[$strTableName . "_sql"];
$isPdfView = false;
$hasEvents = false;
if ($pageObject->pSet->isUsebuttonHandlers() || $isPdfView || $hasEvents) {
$pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/loadfirst.js\"></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) . ";";
function DisplayMasterTableInfoForPrint_calendar_table($params)
{
global $cman;
$detailtable = $params["detailtable"];
$keys = $params["keys"];
$xt = new Xtempl();
$tName = "calendar_table";
$xt->eventsObject = getEventObject($tName);
$cipherer = new RunnerCipherer($tName);
$settings = new ProjectSettings($tName, PAGE_PRINT);
$connection = $cman->byTable($tName);
$masterQuery = $settings->getSQLQuery();
$viewControls = new ViewControlsContainer($settings, PAGE_PRINT);
$where = "";
$keysAssoc = array();
$showKeys = "";
if ($detailtable == "Fact_SalesTransaction") {
$keysAssoc["dt"] = $keys[1 - 1];
$where .= RunnerPage::_getFieldSQLDecrypt("dt", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("dt", $keys[1 - 1], "", true);
$keyValue = $viewControls->showDBValue("dt", $keysAssoc);
$showKeys .= " " . GetFieldLabel("calendar_table", "dt") . ": " . $keyValue;
$xt->assign('showKeys', $showKeys);
}
if ($detailtable == "Current Year Sales") {
$keysAssoc["dt"] = $keys[1 - 1];
$where .= RunnerPage::_getFieldSQLDecrypt("dt", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("dt", $keys[1 - 1], "", true);
$keyValue = $viewControls->showDBValue("dt", $keysAssoc);
$showKeys .= " " . GetFieldLabel("calendar_table", "dt") . ": " . $keyValue;
$xt->assign('showKeys', $showKeys);
}
if (!$where) {
return;
}
$str = SecuritySQL("Export", $tName);
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();
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["dt"]));
$xt->assign("dt_mastervalue", $viewControls->showDBValue("dt", $data, $keylink));
$format = $settings->getViewFormat("dt");
$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("dt"))) {
$class = ' rnr-field-number';
}
$xt->assign("dt_class", $class);
// add class for field header as field value
$xt->assign("y_mastervalue", $viewControls->showDBValue("y", $data, $keylink));
$format = $settings->getViewFormat("y");
$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("y"))) {
$class = ' rnr-field-number';
}
$xt->assign("y_class", $class);
// add class for field header as field value
$xt->assign("q_mastervalue", $viewControls->showDBValue("q", $data, $keylink));
$format = $settings->getViewFormat("q");
$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("q"))) {
$class = ' rnr-field-number';
}
$xt->assign("q_class", $class);
// add class for field header as field value
$xt->assign("m_mastervalue", $viewControls->showDBValue("m", $data, $keylink));
$format = $settings->getViewFormat("m");
$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("m"))) {
$class = ' rnr-field-number';
}
$xt->assign("m_class", $class);
// add class for field header as field value
$xt->assign("d_mastervalue", $viewControls->showDBValue("d", $data, $keylink));
$format = $settings->getViewFormat("d");
$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("d"))) {
$class = ' rnr-field-number';
}
$xt->assign("d_class", $class);
// add class for field header as field value
$xt->assign("dw_mastervalue", $viewControls->showDBValue("dw", $data, $keylink));
$format = $settings->getViewFormat("dw");
$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("dw"))) {
$class = ' rnr-field-number';
}
$xt->assign("dw_class", $class);
// add class for field header as field value
$xt->assign("monthName_mastervalue", $viewControls->showDBValue("monthName", $data, $keylink));
$format = $settings->getViewFormat("monthName");
$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("monthName"))) {
$class = ' rnr-field-number';
}
$xt->assign("monthName_class", $class);
// add class for field header as field value
$xt->assign("dayName_mastervalue", $viewControls->showDBValue("dayName", $data, $keylink));
$format = $settings->getViewFormat("dayName");
$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("dayName"))) {
$class = ' rnr-field-number';
}
$xt->assign("dayName_class", $class);
// add class for field header as field value
$xt->assign("w_mastervalue", $viewControls->showDBValue("w", $data, $keylink));
$format = $settings->getViewFormat("w");
$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("w"))) {
$class = ' rnr-field-number';
}
$xt->assign("w_class", $class);
// add class for field header as field value
$xt->assign("isWeekday_mastervalue", $viewControls->showDBValue("isWeekday", $data, $keylink));
$format = $settings->getViewFormat("isWeekday");
$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("isWeekday"))) {
$class = ' rnr-field-number';
}
$xt->assign("isWeekday_class", $class);
// add class for field header as field value
$xt->assign("isHoliday_mastervalue", $viewControls->showDBValue("isHoliday", $data, $keylink));
$format = $settings->getViewFormat("isHoliday");
$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("isHoliday"))) {
$class = ' rnr-field-number';
}
$xt->assign("isHoliday_class", $class);
// add class for field header as field value
$xt->assign("holidayDescr_mastervalue", $viewControls->showDBValue("holidayDescr", $data, $keylink));
$format = $settings->getViewFormat("holidayDescr");
$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("holidayDescr"))) {
$class = ' rnr-field-number';
}
$xt->assign("holidayDescr_class", $class);
// add class for field header as field value
$xt->assign("isPayday_mastervalue", $viewControls->showDBValue("isPayday", $data, $keylink));
$format = $settings->getViewFormat("isPayday");
$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("isPayday"))) {
$class = ' rnr-field-number';
}
$xt->assign("isPayday_class", $class);
// add class for field header as field value
$xt->assign("yearQuarterText_mastervalue", $viewControls->showDBValue("yearQuarterText", $data, $keylink));
$format = $settings->getViewFormat("yearQuarterText");
$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("yearQuarterText"))) {
$class = ' rnr-field-number';
}
$xt->assign("yearQuarterText_class", $class);
// add class for field header as field value
$xt->assign("yearMonthInt_mastervalue", $viewControls->showDBValue("yearMonthInt", $data, $keylink));
$format = $settings->getViewFormat("yearMonthInt");
$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("yearMonthInt"))) {
$class = ' rnr-field-number';
}
$xt->assign("yearMonthInt_class", $class);
// add class for field header as field value
$xt->assign("yearMonthText_mastervalue", $viewControls->showDBValue("yearMonthText", $data, $keylink));
$format = $settings->getViewFormat("yearMonthText");
$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("yearMonthText"))) {
$class = ' rnr-field-number';
}
$xt->assign("yearMonthText_class", $class);
// add class for field header as field value
$xt->assign("yearWeekInt_mastervalue", $viewControls->showDBValue("yearWeekInt", $data, $keylink));
$format = $settings->getViewFormat("yearWeekInt");
$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("yearWeekInt"))) {
$class = ' rnr-field-number';
}
$xt->assign("yearWeekInt_class", $class);
// add class for field header as field value
$xt->assign("yearWeekText_mastervalue", $viewControls->showDBValue("yearWeekText", $data, $keylink));
$format = $settings->getViewFormat("yearWeekText");
$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("yearWeekText"))) {
$class = ' rnr-field-number';
}
$xt->assign("yearWeekText_class", $class);
// add class for field header as field value
$xt->assign("monthWeekInt_mastervalue", $viewControls->showDBValue("monthWeekInt", $data, $keylink));
$format = $settings->getViewFormat("monthWeekInt");
$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("monthWeekInt"))) {
$class = ' rnr-field-number';
}
$xt->assign("monthWeekInt_class", $class);
// add class for field header as field value
$xt->assign("monthWeekText_mastervalue", $viewControls->showDBValue("monthWeekText", $data, $keylink));
$format = $settings->getViewFormat("monthWeekText");
$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("monthWeekText"))) {
$class = ' rnr-field-number';
}
$xt->assign("monthWeekText_class", $class);
// add class for field header as field value
$xt->assign("fiscalYear_mastervalue", $viewControls->showDBValue("fiscalYear", $data, $keylink));
$format = $settings->getViewFormat("fiscalYear");
$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("fiscalYear"))) {
$class = ' rnr-field-number';
}
$xt->assign("fiscalYear_class", $class);
// add class for field header as field value
$xt->assign("fiscalMonth_mastervalue", $viewControls->showDBValue("fiscalMonth", $data, $keylink));
$format = $settings->getViewFormat("fiscalMonth");
$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("fiscalMonth"))) {
$class = ' rnr-field-number';
}
$xt->assign("fiscalMonth_class", $class);
// add class for field header as field value
$xt->assign("fiscalQuarter_mastervalue", $viewControls->showDBValue("fiscalQuarter", $data, $keylink));
$format = $settings->getViewFormat("fiscalQuarter");
$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("fiscalQuarter"))) {
$class = ' rnr-field-number';
}
$xt->assign("fiscalQuarter_class", $class);
// add class for field header as field value
$xt->assign("fiscalYearMonthText_mastervalue", $viewControls->showDBValue("fiscalYearMonthText", $data, $keylink));
$format = $settings->getViewFormat("fiscalYearMonthText");
$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("fiscalYearMonthText"))) {
$class = ' rnr-field-number';
}
$xt->assign("fiscalYearMonthText_class", $class);
// add class for field header as field value
$layout = GetPageLayout("calendar_table", 'masterprint');
if ($layout) {
$xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"');
}
$xt->displayPartial(GetTemplateName("calendar_table", "masterprint"));
}
function DisplayMasterTableInfo_pad_pad_spt($params)
{
$detailtable = $params["detailtable"];
$keys = $params["keys"];
$detailPageObj = $params["detailPageObj"];
global $conn, $strTableName;
$xt = new Xtempl();
$oldTableName = $strTableName;
$strTableName = "pad.pad_spt";
$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_spt_masterlist"] = $layout;
if ($detailtable == "pad.pad_air_tanah_hit") {
$where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[1 - 1], "", "", true);
$showKeys .= " " . "Id" . ": " . $keys[1 - 1];
$xt->assign('showKeys', $showKeys);
}
if ($detailtable == "pad.pad_stpd") {
$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("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));
// tahun -
$value = "";
$xt->assign("tahun_mastervalue", $viewControls->showDBValue("tahun", $data, $keylink));
// sptno -
$value = "";
$xt->assign("sptno_mastervalue", $viewControls->showDBValue("sptno", $data, $keylink));
// customer_id -
$value = "";
$xt->assign("customer_id_mastervalue", $viewControls->showDBValue("customer_id", $data, $keylink));
// customer_usaha_id -
$value = "";
$xt->assign("customer_usaha_id_mastervalue", $viewControls->showDBValue("customer_usaha_id", $data, $keylink));
// rekening_id -
$value = "";
$xt->assign("rekening_id_mastervalue", $viewControls->showDBValue("rekening_id", $data, $keylink));
// pajak_id -
$value = "";
$xt->assign("pajak_id_mastervalue", $viewControls->showDBValue("pajak_id", $data, $keylink));
// type_id -
$value = "";
$xt->assign("type_id_mastervalue", $viewControls->showDBValue("type_id", $data, $keylink));
// so -
$value = "";
$xt->assign("so_mastervalue", $viewControls->showDBValue("so", $data, $keylink));
// masadari - Short Date
$value = "";
$xt->assign("masadari_mastervalue", $viewControls->showDBValue("masadari", $data, $keylink));
// masasd - Short Date
$value = "";
$xt->assign("masasd_mastervalue", $viewControls->showDBValue("masasd", $data, $keylink));
// jatuhtempotgl - Short Date
$value = "";
$xt->assign("jatuhtempotgl_mastervalue", $viewControls->showDBValue("jatuhtempotgl", $data, $keylink));
// r_bayarid -
$value = "";
$xt->assign("r_bayarid_mastervalue", $viewControls->showDBValue("r_bayarid", $data, $keylink));
// minimal_omset - Number
$value = "";
$xt->assign("minimal_omset_mastervalue", $viewControls->showDBValue("minimal_omset", $data, $keylink));
// dasar - Number
$value = "";
$xt->assign("dasar_mastervalue", $viewControls->showDBValue("dasar", $data, $keylink));
// tarif - Number
$value = "";
$xt->assign("tarif_mastervalue", $viewControls->showDBValue("tarif", $data, $keylink));
// denda - Number
$value = "";
$xt->assign("denda_mastervalue", $viewControls->showDBValue("denda", $data, $keylink));
// bunga - Number
$value = "";
$xt->assign("bunga_mastervalue", $viewControls->showDBValue("bunga", $data, $keylink));
// setoran - Number
$value = "";
$xt->assign("setoran_mastervalue", $viewControls->showDBValue("setoran", $data, $keylink));
// kenaikan - Number
$value = "";
$xt->assign("kenaikan_mastervalue", $viewControls->showDBValue("kenaikan", $data, $keylink));
// kompensasi - Number
$value = "";
$xt->assign("kompensasi_mastervalue", $viewControls->showDBValue("kompensasi", $data, $keylink));
// lain2 - Number
$value = "";
$xt->assign("lain2_mastervalue", $viewControls->showDBValue("lain2", $data, $keylink));
// pajak_terhutang -
$value = "";
$xt->assign("pajak_terhutang_mastervalue", $viewControls->showDBValue("pajak_terhutang", $data, $keylink));
// air_manfaat_id -
$value = "";
$xt->assign("air_manfaat_id_mastervalue", $viewControls->showDBValue("air_manfaat_id", $data, $keylink));
// air_zona_id -
$value = "";
$xt->assign("air_zona_id_mastervalue", $viewControls->showDBValue("air_zona_id", $data, $keylink));
// meteran_awal -
$value = "";
$xt->assign("meteran_awal_mastervalue", $viewControls->showDBValue("meteran_awal", $data, $keylink));
// meteran_akhir -
$value = "";
$xt->assign("meteran_akhir_mastervalue", $viewControls->showDBValue("meteran_akhir", $data, $keylink));
// volume - Number
$value = "";
$xt->assign("volume_mastervalue", $viewControls->showDBValue("volume", $data, $keylink));
// satuan -
$value = "";
$xt->assign("satuan_mastervalue", $viewControls->showDBValue("satuan", $data, $keylink));
// r_panjang - Number
$value = "";
$xt->assign("r_panjang_mastervalue", $viewControls->showDBValue("r_panjang", $data, $keylink));
// r_lebar - Number
$value = "";
$xt->assign("r_lebar_mastervalue", $viewControls->showDBValue("r_lebar", $data, $keylink));
// r_muka - Number
$value = "";
$xt->assign("r_muka_mastervalue", $viewControls->showDBValue("r_muka", $data, $keylink));
// r_banyak - Number
$value = "";
$xt->assign("r_banyak_mastervalue", $viewControls->showDBValue("r_banyak", $data, $keylink));
// r_luas - Number
$value = "";
$xt->assign("r_luas_mastervalue", $viewControls->showDBValue("r_luas", $data, $keylink));
// r_tarifid -
$value = "";
$xt->assign("r_tarifid_mastervalue", $viewControls->showDBValue("r_tarifid", $data, $keylink));
// r_kontrak - Number
$value = "";
$xt->assign("r_kontrak_mastervalue", $viewControls->showDBValue("r_kontrak", $data, $keylink));
// r_lama -
$value = "";
$xt->assign("r_lama_mastervalue", $viewControls->showDBValue("r_lama", $data, $keylink));
// r_jalan_id -
$value = "";
$xt->assign("r_jalan_id_mastervalue", $viewControls->showDBValue("r_jalan_id", $data, $keylink));
// r_jalanklas_id -
$value = "";
$xt->assign("r_jalanklas_id_mastervalue", $viewControls->showDBValue("r_jalanklas_id", $data, $keylink));
// r_lokasi -
$value = "";
$xt->assign("r_lokasi_mastervalue", $viewControls->showDBValue("r_lokasi", $data, $keylink));
// r_judul -
$value = "";
$xt->assign("r_judul_mastervalue", $viewControls->showDBValue("r_judul", $data, $keylink));
// r_kelurahan_id -
$value = "";
$xt->assign("r_kelurahan_id_mastervalue", $viewControls->showDBValue("r_kelurahan_id", $data, $keylink));
// r_lokasi_id -
$value = "";
$xt->assign("r_lokasi_id_mastervalue", $viewControls->showDBValue("r_lokasi_id", $data, $keylink));
// r_calculated - Number
$value = "";
$xt->assign("r_calculated_mastervalue", $viewControls->showDBValue("r_calculated", $data, $keylink));
// r_nsr - Number
$value = "";
$xt->assign("r_nsr_mastervalue", $viewControls->showDBValue("r_nsr", $data, $keylink));
// r_nsrno -
$value = "";
$xt->assign("r_nsrno_mastervalue", $viewControls->showDBValue("r_nsrno", $data, $keylink));
// r_nsrtgl - Short Date
$value = "";
$xt->assign("r_nsrtgl_mastervalue", $viewControls->showDBValue("r_nsrtgl", $data, $keylink));
// r_nsl_kecamatan_id -
$value = "";
$xt->assign("r_nsl_kecamatan_id_mastervalue", $viewControls->showDBValue("r_nsl_kecamatan_id", $data, $keylink));
// r_nsl_type_id -
$value = "";
$xt->assign("r_nsl_type_id_mastervalue", $viewControls->showDBValue("r_nsl_type_id", $data, $keylink));
// r_nsl_nilai - Number
$value = "";
$xt->assign("r_nsl_nilai_mastervalue", $viewControls->showDBValue("r_nsl_nilai", $data, $keylink));
// notes -
$value = "";
$xt->assign("notes_mastervalue", $viewControls->showDBValue("notes", $data, $keylink));
// unit_id -
$value = "";
$xt->assign("unit_id_mastervalue", $viewControls->showDBValue("unit_id", $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));
// terimanip -
$value = "";
$xt->assign("terimanip_mastervalue", $viewControls->showDBValue("terimanip", $data, $keylink));
// terimatgl - Short Date
$value = "";
$xt->assign("terimatgl_mastervalue", $viewControls->showDBValue("terimatgl", $data, $keylink));
// kirimtgl - Short Date
$value = "";
$xt->assign("kirimtgl_mastervalue", $viewControls->showDBValue("kirimtgl", $data, $keylink));
// isprint_dc -
$value = "";
$xt->assign("isprint_dc_mastervalue", $viewControls->showDBValue("isprint_dc", $data, $keylink));
// r_nsr_id -
$value = "";
$xt->assign("r_nsr_id_mastervalue", $viewControls->showDBValue("r_nsr_id", $data, $keylink));
// r_lokasi_pasang_id -
$value = "";
$xt->assign("r_lokasi_pasang_id_mastervalue", $viewControls->showDBValue("r_lokasi_pasang_id", $data, $keylink));
// r_lokasi_pasang_val - Number
$value = "";
$xt->assign("r_lokasi_pasang_val_mastervalue", $viewControls->showDBValue("r_lokasi_pasang_val", $data, $keylink));
// r_jalanklas_val - Number
$value = "";
$xt->assign("r_jalanklas_val_mastervalue", $viewControls->showDBValue("r_jalanklas_val", $data, $keylink));
// r_sudut_pandang_id -
$value = "";
$xt->assign("r_sudut_pandang_id_mastervalue", $viewControls->showDBValue("r_sudut_pandang_id", $data, $keylink));
// r_sudut_pandang_val - Number
$value = "";
$xt->assign("r_sudut_pandang_val_mastervalue", $viewControls->showDBValue("r_sudut_pandang_val", $data, $keylink));
// r_tinggi - Number
$value = "";
$xt->assign("r_tinggi_mastervalue", $viewControls->showDBValue("r_tinggi", $data, $keylink));
// r_njop - Number
$value = "";
$xt->assign("r_njop_mastervalue", $viewControls->showDBValue("r_njop", $data, $keylink));
// r_status -
$value = "";
$xt->assign("r_status_mastervalue", $viewControls->showDBValue("r_status", $data, $keylink));
// r_njop_ketinggian - Number
$value = "";
$xt->assign("r_njop_ketinggian_mastervalue", $viewControls->showDBValue("r_njop_ketinggian", $data, $keylink));
// status_pembayaran -
$value = "";
$xt->assign("status_pembayaran_mastervalue", $viewControls->showDBValue("status_pembayaran", $data, $keylink));
// rek_no_paneng -
$value = "";
$xt->assign("rek_no_paneng_mastervalue", $viewControls->showDBValue("rek_no_paneng", $data, $keylink));
// sptno_lengkap -
$value = "";
$xt->assign("sptno_lengkap_mastervalue", $viewControls->showDBValue("sptno_lengkap", $data, $keylink));
// sptno_lama -
$value = "";
$xt->assign("sptno_lama_mastervalue", $viewControls->showDBValue("sptno_lama", $data, $keylink));
// r_nama -
$value = "";
$xt->assign("r_nama_mastervalue", $viewControls->showDBValue("r_nama", $data, $keylink));
// r_alamat -
$value = "";
$xt->assign("r_alamat_mastervalue", $viewControls->showDBValue("r_alamat", $data, $keylink));
// omset1 - Number
$value = "";
$xt->assign("omset1_mastervalue", $viewControls->showDBValue("omset1", $data, $keylink));
// omset2 - Number
$value = "";
$xt->assign("omset2_mastervalue", $viewControls->showDBValue("omset2", $data, $keylink));
// omset3 - Number
$value = "";
$xt->assign("omset3_mastervalue", $viewControls->showDBValue("omset3", $data, $keylink));
// omset4 - Number
$value = "";
$xt->assign("omset4_mastervalue", $viewControls->showDBValue("omset4", $data, $keylink));
// omset5 - Number
$value = "";
$xt->assign("omset5_mastervalue", $viewControls->showDBValue("omset5", $data, $keylink));
// omset6 - Number
$value = "";
$xt->assign("omset6_mastervalue", $viewControls->showDBValue("omset6", $data, $keylink));
// omset7 - Number
$value = "";
$xt->assign("omset7_mastervalue", $viewControls->showDBValue("omset7", $data, $keylink));
// omset8 - Number
$value = "";
$xt->assign("omset8_mastervalue", $viewControls->showDBValue("omset8", $data, $keylink));
// omset9 - Number
$value = "";
$xt->assign("omset9_mastervalue", $viewControls->showDBValue("omset9", $data, $keylink));
// omset10 - Number
$value = "";
$xt->assign("omset10_mastervalue", $viewControls->showDBValue("omset10", $data, $keylink));
// omset11 - Number
$value = "";
$xt->assign("omset11_mastervalue", $viewControls->showDBValue("omset11", $data, $keylink));
// omset12 - Number
$value = "";
$xt->assign("omset12_mastervalue", $viewControls->showDBValue("omset12", $data, $keylink));
// omset13 - Number
$value = "";
$xt->assign("omset13_mastervalue", $viewControls->showDBValue("omset13", $data, $keylink));
// omset14 - Number
$value = "";
$xt->assign("omset14_mastervalue", $viewControls->showDBValue("omset14", $data, $keylink));
// omset15 - Number
$value = "";
$xt->assign("omset15_mastervalue", $viewControls->showDBValue("omset15", $data, $keylink));
// omset16 - Number
$value = "";
$xt->assign("omset16_mastervalue", $viewControls->showDBValue("omset16", $data, $keylink));
// omset17 - Number
$value = "";
$xt->assign("omset17_mastervalue", $viewControls->showDBValue("omset17", $data, $keylink));
// omset18 - Number
$value = "";
$xt->assign("omset18_mastervalue", $viewControls->showDBValue("omset18", $data, $keylink));
// omset19 - Number
$value = "";
$xt->assign("omset19_mastervalue", $viewControls->showDBValue("omset19", $data, $keylink));
// omset20 - Number
$value = "";
$xt->assign("omset20_mastervalue", $viewControls->showDBValue("omset20", $data, $keylink));
// omset21 - Number
$value = "";
$xt->assign("omset21_mastervalue", $viewControls->showDBValue("omset21", $data, $keylink));
// omset22 - Number
$value = "";
$xt->assign("omset22_mastervalue", $viewControls->showDBValue("omset22", $data, $keylink));
// omset23 - Number
$value = "";
$xt->assign("omset23_mastervalue", $viewControls->showDBValue("omset23", $data, $keylink));
// omset24 - Number
$value = "";
$xt->assign("omset24_mastervalue", $viewControls->showDBValue("omset24", $data, $keylink));
// omset25 - Number
$value = "";
$xt->assign("omset25_mastervalue", $viewControls->showDBValue("omset25", $data, $keylink));
// omset26 - Number
$value = "";
$xt->assign("omset26_mastervalue", $viewControls->showDBValue("omset26", $data, $keylink));
// omset27 - Number
$value = "";
$xt->assign("omset27_mastervalue", $viewControls->showDBValue("omset27", $data, $keylink));
// omset28 - Number
$value = "";
$xt->assign("omset28_mastervalue", $viewControls->showDBValue("omset28", $data, $keylink));
// omset29 - Number
$value = "";
$xt->assign("omset29_mastervalue", $viewControls->showDBValue("omset29", $data, $keylink));
// omset30 - Number
$value = "";
$xt->assign("omset30_mastervalue", $viewControls->showDBValue("omset30", $data, $keylink));
// omset31 - Number
$value = "";
$xt->assign("omset31_mastervalue", $viewControls->showDBValue("omset31", $data, $keylink));
// keterangan1 -
$value = "";
$xt->assign("keterangan1_mastervalue", $viewControls->showDBValue("keterangan1", $data, $keylink));
// keterangan2 -
$value = "";
$xt->assign("keterangan2_mastervalue", $viewControls->showDBValue("keterangan2", $data, $keylink));
// keterangan3 -
$value = "";
$xt->assign("keterangan3_mastervalue", $viewControls->showDBValue("keterangan3", $data, $keylink));
// keterangan4 -
$value = "";
$xt->assign("keterangan4_mastervalue", $viewControls->showDBValue("keterangan4", $data, $keylink));
// keterangan5 -
$value = "";
$xt->assign("keterangan5_mastervalue", $viewControls->showDBValue("keterangan5", $data, $keylink));
// keterangan6 -
$value = "";
$xt->assign("keterangan6_mastervalue", $viewControls->showDBValue("keterangan6", $data, $keylink));
// keterangan7 -
$value = "";
$xt->assign("keterangan7_mastervalue", $viewControls->showDBValue("keterangan7", $data, $keylink));
// keterangan8 -
$value = "";
$xt->assign("keterangan8_mastervalue", $viewControls->showDBValue("keterangan8", $data, $keylink));
// keterangan9 -
$value = "";
$xt->assign("keterangan9_mastervalue", $viewControls->showDBValue("keterangan9", $data, $keylink));
// keterangan10 -
$value = "";
$xt->assign("keterangan10_mastervalue", $viewControls->showDBValue("keterangan10", $data, $keylink));
// keterangan11 -
$value = "";
$xt->assign("keterangan11_mastervalue", $viewControls->showDBValue("keterangan11", $data, $keylink));
// keterangan12 -
$value = "";
$xt->assign("keterangan12_mastervalue", $viewControls->showDBValue("keterangan12", $data, $keylink));
// keterangan13 -
$value = "";
$xt->assign("keterangan13_mastervalue", $viewControls->showDBValue("keterangan13", $data, $keylink));
// keterangan14 -
$value = "";
$xt->assign("keterangan14_mastervalue", $viewControls->showDBValue("keterangan14", $data, $keylink));
// keterangan15 -
$value = "";
$xt->assign("keterangan15_mastervalue", $viewControls->showDBValue("keterangan15", $data, $keylink));
// keterangan16 -
$value = "";
$xt->assign("keterangan16_mastervalue", $viewControls->showDBValue("keterangan16", $data, $keylink));
// keterangan17 -
$value = "";
$xt->assign("keterangan17_mastervalue", $viewControls->showDBValue("keterangan17", $data, $keylink));
// keterangan18 -
$value = "";
$xt->assign("keterangan18_mastervalue", $viewControls->showDBValue("keterangan18", $data, $keylink));
// keterangan19 -
$value = "";
$xt->assign("keterangan19_mastervalue", $viewControls->showDBValue("keterangan19", $data, $keylink));
// keterangan20 -
$value = "";
$xt->assign("keterangan20_mastervalue", $viewControls->showDBValue("keterangan20", $data, $keylink));
// keterangan21 -
$value = "";
$xt->assign("keterangan21_mastervalue", $viewControls->showDBValue("keterangan21", $data, $keylink));
// keterangan22 -
$value = "";
$xt->assign("keterangan22_mastervalue", $viewControls->showDBValue("keterangan22", $data, $keylink));
// keterangan23 -
$value = "";
$xt->assign("keterangan23_mastervalue", $viewControls->showDBValue("keterangan23", $data, $keylink));
// keterangan24 -
$value = "";
$xt->assign("keterangan24_mastervalue", $viewControls->showDBValue("keterangan24", $data, $keylink));
// keterangan25 -
$value = "";
$xt->assign("keterangan25_mastervalue", $viewControls->showDBValue("keterangan25", $data, $keylink));
// keterangan26 -
$value = "";
$xt->assign("keterangan26_mastervalue", $viewControls->showDBValue("keterangan26", $data, $keylink));
// keterangan27 -
$value = "";
$xt->assign("keterangan27_mastervalue", $viewControls->showDBValue("keterangan27", $data, $keylink));
// keterangan28 -
$value = "";
$xt->assign("keterangan28_mastervalue", $viewControls->showDBValue("keterangan28", $data, $keylink));
// keterangan29 -
$value = "";
$xt->assign("keterangan29_mastervalue", $viewControls->showDBValue("keterangan29", $data, $keylink));
// keterangan30 -
$value = "";
$xt->assign("keterangan30_mastervalue", $viewControls->showDBValue("keterangan30", $data, $keylink));
// keterangan31 -
$value = "";
$xt->assign("keterangan31_mastervalue", $viewControls->showDBValue("keterangan31", $data, $keylink));
// doc_no -
$value = "";
$xt->assign("doc_no_mastervalue", $viewControls->showDBValue("doc_no", $data, $keylink));
// cara_bayar -
$value = "";
$xt->assign("cara_bayar_mastervalue", $viewControls->showDBValue("cara_bayar", $data, $keylink));
// kelompok_usaha_id -
$value = "";
$xt->assign("kelompok_usaha_id_mastervalue", $viewControls->showDBValue("kelompok_usaha_id", $data, $keylink));
// zona_id -
$value = "";
$xt->assign("zona_id_mastervalue", $viewControls->showDBValue("zona_id", $data, $keylink));
// manfaat_id -
$value = "";
$xt->assign("manfaat_id_mastervalue", $viewControls->showDBValue("manfaat_id", $data, $keylink));
// golongan -
$value = "";
$xt->assign("golongan_mastervalue", $viewControls->showDBValue("golongan", $data, $keylink));
// omset_lain - Number
$value = "";
$xt->assign("omset_lain_mastervalue", $viewControls->showDBValue("omset_lain", $data, $keylink));
// keterangan_lain -
$value = "";
$xt->assign("keterangan_lain_mastervalue", $viewControls->showDBValue("keterangan_lain", $data, $keylink));
// ijin_no -
$value = "";
$xt->assign("ijin_no_mastervalue", $viewControls->showDBValue("ijin_no", $data, $keylink));
// jenis_masa -
$value = "";
$xt->assign("jenis_masa_mastervalue", $viewControls->showDBValue("jenis_masa", $data, $keylink));
// skpd_lama -
$value = "";
$xt->assign("skpd_lama_mastervalue", $viewControls->showDBValue("skpd_lama", $data, $keylink));
// proses -
$value = "";
$xt->assign("proses_mastervalue", $viewControls->showDBValue("proses", $data, $keylink));
// tanggal_validasi - Short Date
$value = "";
$xt->assign("tanggal_validasi_mastervalue", $viewControls->showDBValue("tanggal_validasi", $data, $keylink));
// bulan -
$value = "";
$xt->assign("bulan_mastervalue", $viewControls->showDBValue("bulan", $data, $keylink));
// no_telp -
$value = "";
$xt->assign("no_telp_mastervalue", $viewControls->showDBValue("no_telp", $data, $keylink));
// usaha_id -
$value = "";
$xt->assign("usaha_id_mastervalue", $viewControls->showDBValue("usaha_id", $data, $keylink));
// multiple -
$value = "";
$xt->assign("multiple_mastervalue", $viewControls->showDBValue("multiple", $data, $keylink));
// bulan_telat -
$value = "";
$xt->assign("bulan_telat_mastervalue", $viewControls->showDBValue("bulan_telat", $data, $keylink));
$viewControls->addControlsJSAndCSS();
$detailPageObj->viewControlsMap['mViewControlsMap'] = $viewControls->viewControlsMap;
$layout = GetPageLayout("pad_pad_spt", 'masterlist');
if ($layout) {
$xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"');
}
$xt->display("pad_pad_spt_masterlist.htm");
$strTableName = $oldTableName;
}
$options["masterKeysReq"][$i] = $_REQUEST["masterkey" . $i];
$i++;
}
$pageObject = ListPage::createListPage($strTableName, $options);
$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_customer_masterlist"] = $layout;
$layout = GetPageLayout("pad_pad_customer", 'masterlist');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
include_once getabspath('classes/controls/ViewControlsContainer.php');
$viewControls = new ViewControlsContainer(new ProjectSettings("pad.pad_customer", PAGE_LIST), PAGE_LIST);
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
if (!$noBlobReplace) {
$gQuery->ReplaceFieldsWithDummies($pageObject->pSet->getBinaryFieldsIndices());
}
if ($mode != LIST_DETAILS) {
function RunnerPage(&$params)
{
global $locale_info, $cCharset, $page_layouts;
// copy properties to object
RunnerApply($this, $params);
$this->pSet = new ProjectSettings($this->tName, $this->pageType);
$this->pSetEdit = $this->pSet;
$this->cipherer = new RunnerCipherer($this->tName, $this->pSet);
include_once getabspath("classes/controls/EditControlsContainer.php");
$this->controls = new EditControlsContainer($this);
include_once getabspath("classes/controls/ViewControlsContainer.php");
$this->viewControls = new ViewControlsContainer($this->pSet, $this->pageType, $this);
$this->gQuery = $this->pSet->getSQLQuery();
//set google map configuration
$this->googleMapCfg = array('markerAsLinkToView' => true, 'isUseMainMaps' => false, 'isUseFieldsMaps' => false, 'isUseGoogleMap' => false, 'APIcode' => GetGlobalData("apiGoogleMapsCode", ""), 'mainMapIds' => array(), 'fieldMapsIds' => array(), 'mapsData' => array());
$this->debugJSMode = false;
if ($this->flyId < $this->id + 1) {
$this->flyId = $this->id + 1;
}
// get permissions
if ($this->tName) {
$this->permis[$this->tName] = $this->getPermissions();
$this->eventsObject =& getEventObject($this->tName);
}
if (!$this->sessionPrefix) {
$this->sessionPrefix = $this->tName;
}
$this->setSessionVariables();
// get locking object
$this->lockingObj = GetLockingObject($this->tName);
$this->is508 = isEnableSection508();
$this->isEncryptionEnabled = isEncryptionEnabled();
$this->isEncryptionByPHPEnabled = isEncryptionByPHPEnabled();
$this->isUseVideo = $this->pSet->isUseVideo();
$this->isUseAudio = $this->pSet->isUseAudio();
$this->strCaption = GetTableCaption(GoodFieldName($this->tName));
$this->isTableType = $this->pSet->isTableType();
$this->isAddWebRep = GetGlobalData("isAddWebRep", false);
// get details keys by master table
$this->detailKeysByM = $this->pSet->getDetailKeysByMasterTable($this->masterTable);
$this->isDynamicPerm = GetGlobalData("isDynamicPerm", false);
$this->shortTableName = $this->pSet->getShortTableName();
$this->showAddInPopup = $this->pSet->isShowAddInPopup();
$this->showEditInPopup = $this->pSet->isShowEditInPopup();
$this->showViewInPopup = $this->pSet->isShowViewInPopup();
$this->isResizeColumns = $this->pSet->isResizeColumns();
$this->isUseAjaxSuggest = $this->pSet->isUseAjaxSuggest();
$this->useDetailsPreview = $this->pSet->isUseDetailsPreview();
$this->isShowDetailTables = displayDetailsOn($this->tName, $this->pageType);
// get all details table for current table
$this->allDetailsTablesArr = $this->pSet->getDetailTablesArr();
// set template file
$this->setTemplateFile();
// init jsSettings
$this->jsSettings["tableSettings"][$this->tName] = array();
$this->jsSettings["tableSettings"][$this->tName]["proxy"] = array("proxy" => "");
$this->jsSettings["tableSettings"][$this->tName]['fieldSettings'] = array();
$this->settingsMap["globalSettings"] = array();
$this->settingsMap["globalSettings"]["ext"] = "php";
$this->settingsMap["globalSettings"]["charSet"] = $cCharset;
$this->settingsMap["globalSettings"]["debugMode"] = $this->debugJSMode;
$this->settingsMap["globalSettings"]["googleMapsApiCode"] = $this->googleMapCfg['APIcode'];
$this->settingsMap["globalSettings"]["shortTNames"][$this->tName] = $this->shortTableName;
//isMobile
$this->settingsMap["globalSettings"]["isMobile"] = isMobile();
// s508 must be in global settings
$this->settingsMap['globalSettings']['s508'] = $this->is508;
$this->settingsMap["globalSettings"]["locale"]["dateFormat"] = $locale_info["LOCALE_IDATE"];
$this->settingsMap["globalSettings"]["locale"]["startWeekDay"] = $locale_info["LOCALE_IFIRSTDAYOFWEEK"];
$this->settingsMap["globalSettings"]["locale"]["dateDelimiter"] = $locale_info["LOCALE_SDATE"];
$this->settingsMap["tableSettings"] = array();
$this->settingsMap['tableSettings']['hasEvents'] = array("default" => false, "jsName" => "hasEvents");
$this->settingsMap["tableSettings"]["listIcons"] = array("default" => false, "jsName" => "listIcons");
$this->settingsMap["tableSettings"]["strCaption"] = array("default" => "", "jsName" => "strCaption");
$this->settingsMap["tableSettings"]["isUseAudio"] = array("default" => false, "jsName" => "isUseAudio");
$this->settingsMap["tableSettings"]["isUseVideo"] = array("default" => false, "jsName" => "isUseVideo");
$this->settingsMap['tableSettings']['isVerLayout'] = array("default" => false, "jsName" => "isVertLayout");
$this->settingsMap["tableSettings"]["rowHighlite"] = array("default" => false, "jsName" => "isUseHighlite");
$this->settingsMap["tableSettings"]["isUseToolTips"] = array("default" => false, "jsName" => "isUseToolTips");
$this->settingsMap['tableSettings']['recsPerRowList'] = array("default" => 1, "jsName" => "recsPerRowList");
$this->settingsMap["tableSettings"]["showAddInPopup"] = array("default" => false, "jsName" => "showAddInPopup");
$this->settingsMap["tableSettings"]["showEditInPopup"] = array("default" => false, "jsName" => "showEditInPopup");
$this->settingsMap["tableSettings"]["showViewInPopup"] = array("default" => false, "jsName" => "showViewInPopup");
$this->settingsMap["tableSettings"]["isResizeColumns"] = array("default" => false, "jsName" => "isUseResize");
$this->settingsMap["tableSettings"]["isUseAjaxSuggest"] = array("default" => true, "jsName" => "ajaxSuggest");
$this->settingsMap["tableSettings"]["useDetailsPreview"] = array("default" => false, "jsName" => "isUseDP");
$this->settingsMap['tableSettings']['isUsebuttonHandlers'] = array("default" => false, "jsName" => "isUseButtons");
if ($this->pageType == PAGE_REGISTER || $this->pageType == PAGE_CHANGEPASS) {
$layout = GetPageLayout('', $this->pageType);
} else {
$layout = GetPageLayout($this->shortTableName, $this->pageType);
}
if ($layout) {
$rtl = $this->xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$this->jsSettings['tableSettings'][$this->tName]['pageCSS'] = "styles/" . $layout->style . '/style' . $rtl . ".css";
$this->jsSettings['tableSettings'][$this->tName]['pageLayout'] = "pagestyles/" . $layout->name . $rtl . ".css";
$this->jsSettings['tableSettings'][$this->tName]['pageSkinStyle'] = $layout->style . " page-" . $layout->name;
}
$this->settingsMap["fieldSettings"]["UseTimestamp"] = array("default" => false, "jsName" => "isUseTimeStamp");
$this->settingsMap["fieldSettings"]["strName"] = array("default" => "", "jsName" => "strName");
$this->settingsMap["fieldSettings"]["ShowTime"] = array("default" => false, "jsName" => "showTime");
$this->settingsMap["fieldSettings"]["EditFormat"] = array("default" => "", "jsName" => "editFormat");
$this->settingsMap["fieldSettings"]["DateEditType"] = array("default" => EDIT_DATE_SIMPLE, "jsName" => "dateEditType");
$this->settingsMap["fieldSettings"]["RTEType"] = array("default" => "", "jsName" => "RTEType");
$this->settingsMap["fieldSettings"]["ViewFormat"] = array("default" => "", "jsName" => "viewFormat");
$this->settingsMap["fieldSettings"]["validateAs"] = array("default" => null, "jsName" => "validation");
$this->settingsMap["fieldSettings"]["strEditMask"] = array("default" => null, "jsName" => "mask");
$this->settingsMap["fieldSettings"]["LastYearFactor"] = array("default" => 10, "jsName" => "lastYear");
$this->settingsMap["fieldSettings"]["InitialYearFactor"] = array("default" => 100, "jsName" => "initialYear");
$this->jsSettings["tableSettings"][$this->tName]["strCaption"] = $this->strCaption;
$this->jsSettings["tableSettings"][$this->tName]["pageMode"] = $this->mode;
if ($this->listAjax) {
$this->jsSettings['tableSettings'][$this->tName]['pageMode'] = LIST_AJAX;
}
if ($this->lockingObj) {
$this->jsSettings['tableSettings'][$this->tName]['locking'] = true;
}
//If current table has detail tables
if (count($this->allDetailsTablesArr)) {
if ($this->pageType == PAGE_LIST) {
$this->jsSettings['tableSettings'][$this->tName]['detailTables'] = array();
}
$this->jsSettings['tableSettings'][$this->tName]['isShowDetails'] = $this->isShowDetailTables;
for ($i = 0; $i < count($this->allDetailsTablesArr); $i++) {
$this->settingsMap["globalSettings"]['shortTNames'][$this->allDetailsTablesArr[$i]['dDataSourceTable']] = $this->allDetailsTablesArr[$i]['dShortTable'];
if ($this->pageType == PAGE_LIST) {
$this->jsSettings['tableSettings'][$this->tName]['detailTables'][$this->allDetailsTablesArr[$i]['dDataSourceTable']] = array('dispChildCount' => $this->allDetailsTablesArr[$i]['dispChildCount'], 'hideChild' => $this->allDetailsTablesArr[$i]['hideChild'], 'listShowType' => $this->allDetailsTablesArr[$i]['previewOnList'], 'addShowType' => $this->allDetailsTablesArr[$i]['previewOnAdd'], 'editShowType' => $this->allDetailsTablesArr[$i]['previewOnEdit'], 'viewShowType' => $this->allDetailsTablesArr[$i]['previewOnView']);
if ($this->allDetailsTablesArr[$i]['previewOnList'] == DP_POPUP) {
$this->jsSettings['tableSettings'][$this->tName]['isUsePopUp'] = true;
}
// field names of master keys of current table for passed details table name
$this->masterKeysByD[$i] = $this->pSet->getMasterKeysByDetailTable($this->allDetailsTablesArr[$i]['dDataSourceTable']);
}
}
if (($this->pageType == PAGE_ADD || $this->pageType == PAGE_EDIT) && $this->isShowDetailTables) {
$this->controlsMap["dControlsMap"] = array();
}
}
$this->controlsMap["video"] = array();
$this->controlsMap['toolTips'] = array();
$this->addLookupSettings();
$this->addMultiUploadSettings();
if ($this->mode != LIST_DETAILS) {
$this->controlsMap["controls"] = array();
if (!$this->pageAddLikeInline && !$this->pageEditLikeInline) {
$this->controlsMap["search"] = array();
$this->controlsMap["search"]["searchBlocks"] = array();
$this->controlsMap["search"]["panelSearchFields"] = $this->pSet->GetPanelSearchFields();
$this->controlsMap["search"]["allSearchFields"] = $this->pSet->getAllSearchFields();
$this->controlsMap["search"]["googleLikeFields"] = $this->pSet->getGoogleLikeFields();
if ($this->pageType != PAGE_SEARCH) {
$this->controlsMap["search"]["submitPageType"] = $this->pageType;
} else {
if (postvalue("rname")) {
$this->controlsMap["search"]["submitPageType"] = "dreport";
$this->controlsMap["search"]["baseParams"]["rname"] = postvalue("rname");
if ($_SESSION["crossLink"]) {
if (substr($_SESSION["crossLink"], 0, 1) == "&") {
$_SESSION["crossLink"] = substr($_SESSION["crossLink"], 1);
}
$alink = explode("&", $_SESSION["crossLink"]);
foreach ($alink as $param) {
$arrtmp = explode("=", $param);
$this->controlsMap["search"]["baseParams"][$arrtmp[0]] = $arrtmp[1];
}
}
} elseif (postvalue("cname")) {
$this->controlsMap["search"]["submitPageType"] = "dchart";
$this->controlsMap["search"]["baseParams"]["cname"] = postvalue("cname");
} else {
$this->controlsMap["search"]["submitPageType"] = $this->isTableType;
}
}
}
}
$this->timepicker = $this->timepicker || $this->pSet->isUseTimeForSearch();
$this->isUseToolTips = $this->isUseToolTips || $this->pSet->isUseToolTips();
$this->googleMapCfg["APIcode"] = "";
if ($this->xt) {
$this->xt->assign("pagetitle", $this->getPageTitle());
}
}
function DisplayMasterTableInfo_pad_pad_sspd($params)
{
$detailtable = $params["detailtable"];
$keys = $params["keys"];
$detailPageObj = $params["detailPageObj"];
global $conn, $strTableName;
$xt = new Xtempl();
$oldTableName = $strTableName;
$strTableName = "pad.pad_sspd";
$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_sspd_masterlist"] = $layout;
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("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));
// tahun -
$value = "";
$xt->assign("tahun_mastervalue", $viewControls->showDBValue("tahun", $data, $keylink));
// sspdno -
$value = "";
$xt->assign("sspdno_mastervalue", $viewControls->showDBValue("sspdno", $data, $keylink));
// sspdtgl - Short Date
$value = "";
$xt->assign("sspdtgl_mastervalue", $viewControls->showDBValue("sspdtgl", $data, $keylink));
// sspdjam - Time
$value = "";
$xt->assign("sspdjam_mastervalue", $viewControls->showDBValue("sspdjam", $data, $keylink));
// invoice_id -
$value = "";
$xt->assign("invoice_id_mastervalue", $viewControls->showDBValue("invoice_id", $data, $keylink));
// keterangan -
$value = "";
$xt->assign("keterangan_mastervalue", $viewControls->showDBValue("keterangan", $data, $keylink));
// bulan_telat -
$value = "";
$xt->assign("bulan_telat_mastervalue", $viewControls->showDBValue("bulan_telat", $data, $keylink));
// hitung_bunga -
$value = "";
$xt->assign("hitung_bunga_mastervalue", $viewControls->showDBValue("hitung_bunga", $data, $keylink));
// denda - Number
$value = "";
$xt->assign("denda_mastervalue", $viewControls->showDBValue("denda", $data, $keylink));
// bunga - Number
$value = "";
$xt->assign("bunga_mastervalue", $viewControls->showDBValue("bunga", $data, $keylink));
// jml_bayar -
$value = "";
$xt->assign("jml_bayar_mastervalue", $viewControls->showDBValue("jml_bayar", $data, $keylink));
// sisa - Number
$value = "";
$xt->assign("sisa_mastervalue", $viewControls->showDBValue("sisa", $data, $keylink));
// jenis_bayar -
$value = "";
$xt->assign("jenis_bayar_mastervalue", $viewControls->showDBValue("jenis_bayar", $data, $keylink));
// printed -
$value = "";
$xt->assign("printed_mastervalue", $viewControls->showDBValue("printed", $data, $keylink));
// tp_id -
$value = "";
$xt->assign("tp_id_mastervalue", $viewControls->showDBValue("tp_id", $data, $keylink));
// is_validated -
$value = "";
$xt->assign("is_validated_mastervalue", $viewControls->showDBValue("is_validated", $data, $keylink));
// is_valid -
$value = "";
$xt->assign("is_valid_mastervalue", $viewControls->showDBValue("is_valid", $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));
// petugas_id -
$value = "";
$xt->assign("petugas_id_mastervalue", $viewControls->showDBValue("petugas_id", $data, $keylink));
// pejabat_id -
$value = "";
$xt->assign("pejabat_id_mastervalue", $viewControls->showDBValue("pejabat_id", $data, $keylink));
$viewControls->addControlsJSAndCSS();
$detailPageObj->viewControlsMap['mViewControlsMap'] = $viewControls->viewControlsMap;
$layout = GetPageLayout("pad_pad_sspd", 'masterlist');
if ($layout) {
$xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"');
}
$xt->display("pad_pad_sspd_masterlist.htm");
$strTableName = $oldTableName;
}
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
$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;
$layout = GetPageLayout("pad_pad_kelurahan", 'masterlist');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
include_once getabspath('classes/controls/ViewControlsContainer.php');
$viewControls = new ViewControlsContainer(new ProjectSettings("pad.pad_kelurahan", PAGE_LIST), PAGE_LIST);
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
if (!$noBlobReplace) {
$gQuery->ReplaceFieldsWithDummies($pageObject->pSet->getBinaryFieldsIndices());
}
if ($mode != LIST_DETAILS) {
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
$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["app_modules_masterlist"] = $layout;
$layout = GetPageLayout("app_modules", 'masterlist');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
include_once getabspath('classes/controls/ViewControlsContainer.php');
$viewControls = new ViewControlsContainer(new ProjectSettings("app.modules", PAGE_LIST), PAGE_LIST);
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
if (!$noBlobReplace) {
$gQuery->ReplaceFieldsWithDummies($pageObject->pSet->getBinaryFieldsIndices());
}
if ($mode != LIST_DETAILS) {
$options["masterKeysReq"][$i] = $_REQUEST["masterkey" . $i];
$i++;
}
$pageObject = ListPage::createListPage($strTableName, $options);
$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_spt_masterlist"] = $layout;
$layout = GetPageLayout("pad_pad_spt", 'masterlist');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
include_once getabspath('classes/controls/ViewControlsContainer.php');
$viewControls = new ViewControlsContainer(new ProjectSettings("pad.pad_spt", PAGE_LIST), PAGE_LIST);
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
if (!$noBlobReplace) {
$gQuery->ReplaceFieldsWithDummies($pageObject->pSet->getBinaryFieldsIndices());
}
if ($mode != LIST_DETAILS) {
$master["func"] = "DisplayMasterTableInfo_pad_pad_rekening";
$master["params"] = $params;
$xt->assignbyref("showmasterfile", $master);
$xt->assign("mastertable_block", true);
$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_rekening_masterprint"] = $layout;
$layout = GetPageLayout("pad_pad_rekening", 'masterprint');
if ($layout) {
$rtl = $pageObject->xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
}
$strSQL = $_SESSION[$strTableName . "_sql"];
$isPdfView = false;
$hasEvents = false;
if ($pageObject->pSet->isUsebuttonHandlers() || $isPdfView || $hasEvents) {
$pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/loadfirst.js\"></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) . ";";
/**
* Add detail JS and CSS files to the master's files list
* @param &RunnerPage dtPageObject
*/
protected function copyDetailPreviewJSAndCSS(&$dtPageObject)
{
$layout = GetPageLayout(GoodFieldName($dtPageObject->tName), $dtPageObject->pageType);
if ($layout) {
$this->AddCSSFile($layout->getCSSFiles(isRTL(), isPageLayoutMobile($this->templatefile)));
}
//Add detail's js files to master's files
$this->copyAllJSFiles($dtPageObject->grabAllJSFiles());
//Add detail's css files to master's files
$this->copyAllCSSFiles($dtPageObject->grabAllCSSFiles());
}
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;
}
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
$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_air_zona_masterlist"] = $layout;
$layout = GetPageLayout("pad_pad_air_zona", 'masterlist');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
include_once getabspath('classes/controls/ViewControlsContainer.php');
$viewControls = new ViewControlsContainer(new ProjectSettings("pad.pad_air_zona", PAGE_LIST), PAGE_LIST);
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
if (!$noBlobReplace) {
$gQuery->ReplaceFieldsWithDummies($pageObject->pSet->getBinaryFieldsIndices());
}
if ($mode != LIST_DETAILS) {
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"));
}
function DisplayMasterTableInfo_pad_pad_customer($params)
{
$detailtable = $params["detailtable"];
$keys = $params["keys"];
$detailPageObj = $params["detailPageObj"];
global $conn, $strTableName;
$xt = new Xtempl();
$oldTableName = $strTableName;
$strTableName = "pad.pad_customer";
$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_customer_masterlist"] = $layout;
if ($detailtable == "pad.pad_spt") {
$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_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_detail") {
$where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[1 - 1], "", "", true);
$showKeys .= " " . "Id" . ": " . $keys[1 - 1];
$xt->assign('showKeys', $showKeys);
}
if ($detailtable == "pad.pad_terima") {
$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("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));
// parent -
$value = "";
$xt->assign("parent_mastervalue", $viewControls->showDBValue("parent", $data, $keylink));
// npwpd -
$value = "";
$xt->assign("npwpd_mastervalue", $viewControls->showDBValue("npwpd", $data, $keylink));
// rp -
$value = "";
$xt->assign("rp_mastervalue", $viewControls->showDBValue("rp", $data, $keylink));
// pb -
$value = "";
$xt->assign("pb_mastervalue", $viewControls->showDBValue("pb", $data, $keylink));
// formno -
$value = "";
$xt->assign("formno_mastervalue", $viewControls->showDBValue("formno", $data, $keylink));
// reg_date - Short Date
$value = "";
$xt->assign("reg_date_mastervalue", $viewControls->showDBValue("reg_date", $data, $keylink));
// nama -
$value = "";
$xt->assign("nama_mastervalue", $viewControls->showDBValue("nama", $data, $keylink));
// kecamatan_id -
$value = "";
$xt->assign("kecamatan_id_mastervalue", $viewControls->showDBValue("kecamatan_id", $data, $keylink));
// kelurahan_id -
$value = "";
$xt->assign("kelurahan_id_mastervalue", $viewControls->showDBValue("kelurahan_id", $data, $keylink));
// kabupaten -
$value = "";
$xt->assign("kabupaten_mastervalue", $viewControls->showDBValue("kabupaten", $data, $keylink));
// alamat -
$value = "";
$xt->assign("alamat_mastervalue", $viewControls->showDBValue("alamat", $data, $keylink));
// kodepos -
$value = "";
$xt->assign("kodepos_mastervalue", $viewControls->showDBValue("kodepos", $data, $keylink));
// telphone -
$value = "";
$xt->assign("telphone_mastervalue", $viewControls->showDBValue("telphone", $data, $keylink));
// wpnama -
$value = "";
$xt->assign("wpnama_mastervalue", $viewControls->showDBValue("wpnama", $data, $keylink));
// wpalamat -
$value = "";
$xt->assign("wpalamat_mastervalue", $viewControls->showDBValue("wpalamat", $data, $keylink));
// wpkelurahan -
$value = "";
$xt->assign("wpkelurahan_mastervalue", $viewControls->showDBValue("wpkelurahan", $data, $keylink));
// wpkecamatan -
$value = "";
$xt->assign("wpkecamatan_mastervalue", $viewControls->showDBValue("wpkecamatan", $data, $keylink));
// wpkabupaten -
$value = "";
$xt->assign("wpkabupaten_mastervalue", $viewControls->showDBValue("wpkabupaten", $data, $keylink));
// wptelp -
$value = "";
$xt->assign("wptelp_mastervalue", $viewControls->showDBValue("wptelp", $data, $keylink));
// wpkodepos -
$value = "";
$xt->assign("wpkodepos_mastervalue", $viewControls->showDBValue("wpkodepos", $data, $keylink));
// pnama -
$value = "";
$xt->assign("pnama_mastervalue", $viewControls->showDBValue("pnama", $data, $keylink));
// palamat -
$value = "";
$xt->assign("palamat_mastervalue", $viewControls->showDBValue("palamat", $data, $keylink));
// pkelurahan -
$value = "";
$xt->assign("pkelurahan_mastervalue", $viewControls->showDBValue("pkelurahan", $data, $keylink));
// pkecamatan -
$value = "";
$xt->assign("pkecamatan_mastervalue", $viewControls->showDBValue("pkecamatan", $data, $keylink));
// pkabupaten -
$value = "";
$xt->assign("pkabupaten_mastervalue", $viewControls->showDBValue("pkabupaten", $data, $keylink));
// ptelp -
$value = "";
$xt->assign("ptelp_mastervalue", $viewControls->showDBValue("ptelp", $data, $keylink));
// pkodepos -
$value = "";
$xt->assign("pkodepos_mastervalue", $viewControls->showDBValue("pkodepos", $data, $keylink));
// ijin1 -
$value = "";
$xt->assign("ijin1_mastervalue", $viewControls->showDBValue("ijin1", $data, $keylink));
// ijin1no -
$value = "";
$xt->assign("ijin1no_mastervalue", $viewControls->showDBValue("ijin1no", $data, $keylink));
// ijin1tgl - Short Date
$value = "";
$xt->assign("ijin1tgl_mastervalue", $viewControls->showDBValue("ijin1tgl", $data, $keylink));
// ijin1tglakhir - Short Date
$value = "";
$xt->assign("ijin1tglakhir_mastervalue", $viewControls->showDBValue("ijin1tglakhir", $data, $keylink));
// ijin2 -
$value = "";
$xt->assign("ijin2_mastervalue", $viewControls->showDBValue("ijin2", $data, $keylink));
// ijin2no -
$value = "";
$xt->assign("ijin2no_mastervalue", $viewControls->showDBValue("ijin2no", $data, $keylink));
// ijin2tgl - Short Date
$value = "";
$xt->assign("ijin2tgl_mastervalue", $viewControls->showDBValue("ijin2tgl", $data, $keylink));
// ijin2tglakhir - Short Date
$value = "";
$xt->assign("ijin2tglakhir_mastervalue", $viewControls->showDBValue("ijin2tglakhir", $data, $keylink));
// ijin3 -
$value = "";
$xt->assign("ijin3_mastervalue", $viewControls->showDBValue("ijin3", $data, $keylink));
// ijin3no -
$value = "";
$xt->assign("ijin3no_mastervalue", $viewControls->showDBValue("ijin3no", $data, $keylink));
// ijin3tgl - Short Date
$value = "";
$xt->assign("ijin3tgl_mastervalue", $viewControls->showDBValue("ijin3tgl", $data, $keylink));
// ijin3tglakhir - Short Date
$value = "";
$xt->assign("ijin3tglakhir_mastervalue", $viewControls->showDBValue("ijin3tglakhir", $data, $keylink));
// ijin4 -
$value = "";
$xt->assign("ijin4_mastervalue", $viewControls->showDBValue("ijin4", $data, $keylink));
// ijin4no -
$value = "";
$xt->assign("ijin4no_mastervalue", $viewControls->showDBValue("ijin4no", $data, $keylink));
// ijin4tgl - Short Date
$value = "";
$xt->assign("ijin4tgl_mastervalue", $viewControls->showDBValue("ijin4tgl", $data, $keylink));
// ijin4tglakhir - Short Date
$value = "";
$xt->assign("ijin4tglakhir_mastervalue", $viewControls->showDBValue("ijin4tglakhir", $data, $keylink));
// kukuhno -
$value = "";
$xt->assign("kukuhno_mastervalue", $viewControls->showDBValue("kukuhno", $data, $keylink));
// kukuhnip -
$value = "";
$xt->assign("kukuhnip_mastervalue", $viewControls->showDBValue("kukuhnip", $data, $keylink));
// kukuhtgl - Short Date
$value = "";
$xt->assign("kukuhtgl_mastervalue", $viewControls->showDBValue("kukuhtgl", $data, $keylink));
// kukuh_jabat_id -
$value = "";
$xt->assign("kukuh_jabat_id_mastervalue", $viewControls->showDBValue("kukuh_jabat_id", $data, $keylink));
// kukuhprinted -
$value = "";
$xt->assign("kukuhprinted_mastervalue", $viewControls->showDBValue("kukuhprinted", $data, $keylink));
// enabled -
$value = "";
$xt->assign("enabled_mastervalue", $viewControls->showDBValue("enabled", $data, $keylink));
// create_uid -
$value = "";
$xt->assign("create_uid_mastervalue", $viewControls->showDBValue("create_uid", $data, $keylink));
// tmt - Short Date
$value = "";
$xt->assign("tmt_mastervalue", $viewControls->showDBValue("tmt", $data, $keylink));
// customer_status_id -
$value = "";
$xt->assign("customer_status_id_mastervalue", $viewControls->showDBValue("customer_status_id", $data, $keylink));
// kembalitgl - Short Date
$value = "";
$xt->assign("kembalitgl_mastervalue", $viewControls->showDBValue("kembalitgl", $data, $keylink));
// kembalioleh -
$value = "";
$xt->assign("kembalioleh_mastervalue", $viewControls->showDBValue("kembalioleh", $data, $keylink));
// kartuprinted -
$value = "";
$xt->assign("kartuprinted_mastervalue", $viewControls->showDBValue("kartuprinted", $data, $keylink));
// kembalinip -
$value = "";
$xt->assign("kembalinip_mastervalue", $viewControls->showDBValue("kembalinip", $data, $keylink));
// penerimanm -
$value = "";
$xt->assign("penerimanm_mastervalue", $viewControls->showDBValue("penerimanm", $data, $keylink));
// penerimaalamat -
$value = "";
$xt->assign("penerimaalamat_mastervalue", $viewControls->showDBValue("penerimaalamat", $data, $keylink));
// penerimatgl - Short Date
$value = "";
$xt->assign("penerimatgl_mastervalue", $viewControls->showDBValue("penerimatgl", $data, $keylink));
// catatnip -
$value = "";
$xt->assign("catatnip_mastervalue", $viewControls->showDBValue("catatnip", $data, $keylink));
// kirimtgl - Short Date
$value = "";
$xt->assign("kirimtgl_mastervalue", $viewControls->showDBValue("kirimtgl", $data, $keylink));
// batastgl - Short Date
$value = "";
$xt->assign("batastgl_mastervalue", $viewControls->showDBValue("batastgl", $data, $keylink));
// petugas_jabat_id -
$value = "";
$xt->assign("petugas_jabat_id_mastervalue", $viewControls->showDBValue("petugas_jabat_id", $data, $keylink));
// pencatat_jabat_id -
$value = "";
$xt->assign("pencatat_jabat_id_mastervalue", $viewControls->showDBValue("pencatat_jabat_id", $data, $keylink));
// created - Short Date
$value = "";
$xt->assign("created_mastervalue", $viewControls->showDBValue("created", $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));
// npwpd_old -
$value = "";
$xt->assign("npwpd_old_mastervalue", $viewControls->showDBValue("npwpd_old", $data, $keylink));
// id_old -
$value = "";
$xt->assign("id_old_mastervalue", $viewControls->showDBValue("id_old", $data, $keylink));
$viewControls->addControlsJSAndCSS();
$detailPageObj->viewControlsMap['mViewControlsMap'] = $viewControls->viewControlsMap;
$layout = GetPageLayout("pad_pad_customer", 'masterlist');
if ($layout) {
$xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"');
}
$xt->display("pad_pad_customer_masterlist.htm");
$strTableName = $oldTableName;
}
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"));
}
function DisplayMasterTableInfo_app_users($params)
{
$detailtable = $params["detailtable"];
$keys = $params["keys"];
$detailPageObj = $params["detailPageObj"];
global $conn, $strTableName;
$xt = new Xtempl();
$oldTableName = $strTableName;
$strTableName = "app.users";
$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["app_users_masterlist"] = $layout;
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("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"]));
// userid -
$value = "";
$xt->assign("userid_mastervalue", $viewControls->showDBValue("userid", $data, $keylink));
// nama -
$value = "";
$xt->assign("nama_mastervalue", $viewControls->showDBValue("nama", $data, $keylink));
// created - Short Date
$value = "";
$xt->assign("created_mastervalue", $viewControls->showDBValue("created", $data, $keylink));
// disabled -
$value = "";
$xt->assign("disabled_mastervalue", $viewControls->showDBValue("disabled", $data, $keylink));
// passwd -
$value = "";
$xt->assign("passwd_mastervalue", $viewControls->showDBValue("passwd", $data, $keylink));
// id -
$value = "";
$xt->assign("id_mastervalue", $viewControls->showDBValue("id", $data, $keylink));
// kd_kantor -
$value = "";
$xt->assign("kd_kantor_mastervalue", $viewControls->showDBValue("kd_kantor", $data, $keylink));
// kd_kanwil -
$value = "";
$xt->assign("kd_kanwil_mastervalue", $viewControls->showDBValue("kd_kanwil", $data, $keylink));
// kd_tp -
$value = "";
$xt->assign("kd_tp_mastervalue", $viewControls->showDBValue("kd_tp", $data, $keylink));
// kd_kanwil_bank -
$value = "";
$xt->assign("kd_kanwil_bank_mastervalue", $viewControls->showDBValue("kd_kanwil_bank", $data, $keylink));
// kd_kppbb_bank -
$value = "";
$xt->assign("kd_kppbb_bank_mastervalue", $viewControls->showDBValue("kd_kppbb_bank", $data, $keylink));
// kd_bank_tunggal -
$value = "";
$xt->assign("kd_bank_tunggal_mastervalue", $viewControls->showDBValue("kd_bank_tunggal", $data, $keylink));
// kd_bank_persepsi -
$value = "";
$xt->assign("kd_bank_persepsi_mastervalue", $viewControls->showDBValue("kd_bank_persepsi", $data, $keylink));
// nip -
$value = "";
$xt->assign("nip_mastervalue", $viewControls->showDBValue("nip", $data, $keylink));
// jabatan -
$value = "";
$xt->assign("jabatan_mastervalue", $viewControls->showDBValue("jabatan", $data, $keylink));
// handphone -
$value = "";
$xt->assign("handphone_mastervalue", $viewControls->showDBValue("handphone", $data, $keylink));
// create_uid -
$value = "";
$xt->assign("create_uid_mastervalue", $viewControls->showDBValue("create_uid", $data, $keylink));
// update_uid -
$value = "";
$xt->assign("update_uid_mastervalue", $viewControls->showDBValue("update_uid", $data, $keylink));
// updated - Short Date
$value = "";
$xt->assign("updated_mastervalue", $viewControls->showDBValue("updated", $data, $keylink));
// last_login - Short Date
$value = "";
$xt->assign("last_login_mastervalue", $viewControls->showDBValue("last_login", $data, $keylink));
// is_login -
$value = "";
$xt->assign("is_login_mastervalue", $viewControls->showDBValue("is_login", $data, $keylink));
// is_logout -
$value = "";
$xt->assign("is_logout_mastervalue", $viewControls->showDBValue("is_logout", $data, $keylink));
// last_ip -
$value = "";
$xt->assign("last_ip_mastervalue", $viewControls->showDBValue("last_ip", $data, $keylink));
$viewControls->addControlsJSAndCSS();
$detailPageObj->viewControlsMap['mViewControlsMap'] = $viewControls->viewControlsMap;
$layout = GetPageLayout("app_users", 'masterlist');
if ($layout) {
$xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"');
}
$xt->display("app_users_masterlist.htm");
$strTableName = $oldTableName;
}
}
$dControlsMap = array();
$dViewControlsMap = array();
$flyId = $ids + 1;
for ($d = 0; $d < count($dpParams['ids']); $d++) {
$options = array();
//array of params for classes
$options["mode"] = LIST_DETAILS;
$options["pageType"] = PAGE_LIST;
$options["masterPageType"] = PAGE_ADD;
$options["mainMasterPageType"] = PAGE_ADD;
$options['masterTable'] = "pad.pad_customer";
$options['firstTime'] = 1;
$strTableName = $dpParams['strTableNames'][$d];
include_once "include/" . GetTableURL($strTableName) . "_settings.php";
$layout = GetPageLayout(GoodFieldName($strTableName), PAGE_LIST);
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
$options['xt'] = new Xtempl();
$options['id'] = $dpParams['ids'][$d];
$options['flyId'] = $flyId++;
$mkr = 1;
foreach ($mKeys[$strTableName] as $mk) {
if ($defvalues[$mk]) {
$options['masterKeysReq'][$mkr++] = $defvalues[$mk];
} else {
$options['masterKeysReq'][$mkr++] = '';
}
$options["masterKeysReq"][$i] = $_REQUEST["masterkey" . $i];
$i++;
}
$pageObject = ListPage::createListPage($strTableName, $options);
$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_rekening_masterlist"] = $layout;
$layout = GetPageLayout("pad_pad_rekening", 'masterlist');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
$xt->cssFiles[] = array("stylepath" => "styles/" . $layout->style . '/style' . $rtl . ".css", "pagestylepath" => "pagestyles/" . $layout->name . $rtl . ".css");
$xt->IEcssFiles[] = array("stylepathIE" => "styles/" . $layout->style . '/styleIE' . ".css");
}
include_once getabspath('classes/controls/ViewControlsContainer.php');
$viewControls = new ViewControlsContainer(new ProjectSettings("pad.pad_rekening", PAGE_LIST), PAGE_LIST);
$viewControls->addControlsJSAndCSS();
$pageObject->includes_js = array_merge($pageObject->includes_js, $viewControls->includes_js);
$pageObject->includes_jsreq = array_merge($pageObject->includes_jsreq, $viewControls->includes_jsreq);
$pageObject->includes_css = array_merge($pageObject->includes_css, $viewControls->includes_css);
if (!$noBlobReplace) {
$gQuery->ReplaceFieldsWithDummies($pageObject->pSet->getBinaryFieldsIndices());
}
if ($mode != LIST_DETAILS) {
