/** * Add to the page master info page's extra js/css files * @param String mPageType the master page type * @param String mTableName the master page data source table name * @param String mShortTableName the master page short table name */ protected function addMasterInfoJSAndCSS($mPageType, $mTableName, $mShortTableName) { if ($mPageType == PAGE_CHART) { $mastertype = "masterchart"; } elseif ($mPageType == PAGE_REPORT) { $mastertype = "masterreport"; } else { // $mPageType == PAGE_LIST $mastertype = "masterlist"; } if ($mPageType != PAGE_CHART) { include_once getabspath('classes/controls/ViewControlsContainer.php'); $viewControls = new ViewControlsContainer(new ProjectSettings($mTableName, $mPageType), $mPageType); $viewControls->addControlsJSAndCSS(); $this->includes_js = array_merge($this->includes_js, $viewControls->includes_js); $this->includes_jsreq = array_merge($this->includes_jsreq, $viewControls->includes_jsreq); $this->includes_css = array_merge($this->includes_css, $viewControls->includes_css); $this->viewControlsMap['mViewControlsMap'] = $viewControls->viewControlsMap; } $layout = GetPageLayout($mShortTableName, $mastertype); $layoutMobile = isPageLayoutMobile(GetTemplateName($mShortTableName, $mastertype)); $this->AddCSSFile($layout->getCSSFiles(isRTL(), $layoutMobile)); }
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_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")); }
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // spt_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("spt_id", $data, $keylink); $row["spt_id_value"] = $value; // vol - Number $viewContainer->recId = $recordsCounter;
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // zona_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("zona_id", $data, $keylink); $row["zona_id_value"] = $value; // manfaat_id - $viewContainer->recId = $recordsCounter;
$returnJSON = array("success" => false, "error" => 'Error: Wrong SQL query'); echo printJSON($returnJSON); return; } $fieldValue = $data[$field]; $sessionPrefix = $pSet->getOriginalTableName(); if ($mode == LIST_DASHBOARD) { //set the session prefix for the dashboard list page $sessionPrefix = "Dashboard_" . $pSet->getOriginalTableName(); } if ($lookup) { //set the session prefix for the lookup list page $sessionPrefix = $pSet->getOriginalTableName() . "_lookup_" . $mainTable . '_' . $mainField; } $searchClauseObj = SearchClause::UnserializeObject($_SESSION[$sessionPrefix . "_advsearch"]); $container = new ViewControlsContainer($pSet, PAGE_LIST, null); $cViewControl = $container->getControl($field); if ($cViewControl->localControlsContainer && !$cViewControl->linkAndDisplaySame) { $cViewControl->localControlsContainer->fullText = true; } else { $cViewControl->container->fullText = true; } if ($searchClauseObj) { if ($searchClauseObj->bIsUsedSrch || $useViewControl) { $cViewControl->searchClauseObj = $searchClauseObj; $cViewControl->searchHighlight = true; } } $htmlEncodedValue = $cViewControl->showDBValue($data, ""); $returnJSON = array("success" => true, "textCont" => nl2br($htmlEncodedValue)); echo printJSON($returnJSON);
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // pajak_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("pajak_id", $data, $keylink); $row["pajak_id_value"] = $value; // tarif - Number $viewContainer->recId = $recordsCounter;
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // group_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("group_id", $data, $keylink); $row["group_id_value"] = $value; // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // module_id - $viewContainer->recId = $recordsCounter;
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // usaha_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("usaha_id", $data, $keylink); $row["usaha_id_value"] = $value; // nourut - $viewContainer->recId = $recordsCounter;
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 labelFormat($fieldName, $data) { $table = $this->sessionPrefix; if ($this->table_type == "db" && count($this->chrt_array['customLabels'])) { $fieldName = $this->chrt_array['customLabels'][$fieldName]; } $strViewFormat = $this->pSet->getViewFormat($fieldName); $strEditFormat = $this->pSet->getEditFormat($fieldName); include_once getabspath('classes/controls/ViewControlsContainer.php'); $viewControls = new ViewControlsContainer($this->pSet, PAGE_CHART); $value = html_special_decode($viewControls->showDBValue($fieldName, $data)); if (strlen($value) > 50) { $value = substr($value, 0, 47) . "..."; } return $this->chart_xmlencode($value); }
function DisplayMasterTableInfo_pad_pad_daftar_status($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "pad.pad_daftar_status"; //$strSQL = "SELECT id, kode, uraian FROM \"pad\".pad_daftar_status "; $cipherer = new RunnerCipherer($strTableName); $settings = new ProjectSettings($strTableName, PAGE_PRINT); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_PRINT); $where = ""; global $pageObject, $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterprint", "RoundedGreen", "MobileGreen"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["pad_pad_daftar_status_masterprint"] = $layout; $showKeys = ""; if ($detailtable == "pad.pad_daftar_hist") { $where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[1 - 1], "", "", true); $showKeys .= " " . "Id" . ": " . $keys[1 - 1]; $xt->assign('showKeys', $showKeys); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Export"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->m_where->toSql($masterQuery), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = $cipherer->DecryptFetchedArray($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $xt->assign("id_mastervalue", $viewControls->showDBValue("id", $data, $keylink)); // kode - $xt->assign("kode_mastervalue", $viewControls->showDBValue("kode", $data, $keylink)); // uraian - $xt->assign("uraian_mastervalue", $viewControls->showDBValue("uraian", $data, $keylink)); $xt->display("pad_pad_daftar_status_masterprint.htm"); $strTableName = $oldTableName; }
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // konterid - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("konterid", $data, $keylink); $row["konterid_value"] = $value; // reg_date - Short Date $viewContainer->recId = $recordsCounter;
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // tahun - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("tahun", $data, $keylink); $row["tahun_value"] = $value; // stpdno - $viewContainer->recId = $recordsCounter;
if ($rowcount) { $xt->assign("details_data", true); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); $viewContainer->isDetailsPreview = true; $b = true; $qResult = $pageObject->connection->query($strSQL); $data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc()); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["Grp_id"])); $keylink .= "&key2=" . runner_htmlspecialchars(rawurlencode(@$data["StockCode"])); $keylink .= "&key3=" . runner_htmlspecialchars(rawurlencode(@$data["Coy_Id"])); // Grp_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("Grp_id", $data, $keylink); $row["Grp_id_value"] = $value;
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // user_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("user_id", $data, $keylink); $row["user_id_value"] = $value; // group_id - $viewContainer->recId = $recordsCounter;
function DisplayMasterTableInfo_app_users($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "app.users"; //$strSQL = "SELECT userid, nama, created, disabled, passwd, id, kd_kantor, kd_kanwil, kd_tp, kd_kanwil_bank, kd_kppbb_bank, kd_bank_tunggal, kd_bank_persepsi, nip, jabatan, handphone, create_uid, update_uid, updated, last_login, is_login, is_logout, last_ip FROM app.users "; $cipherer = new RunnerCipherer($strTableName); $settings = new ProjectSettings($strTableName, PAGE_PRINT); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_PRINT); $where = ""; global $pageObject, $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterprint", "RoundedGreen", "MobileGreen"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["app_users_masterprint"] = $layout; $showKeys = ""; if ($detailtable == "app.user_groups") { $where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[1 - 1], "", "", true); $showKeys .= " " . "Id" . ": " . $keys[1 - 1]; $xt->assign('showKeys', $showKeys); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Export"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->m_where->toSql($masterQuery), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = $cipherer->DecryptFetchedArray($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // userid - $xt->assign("userid_mastervalue", $viewControls->showDBValue("userid", $data, $keylink)); // nama - $xt->assign("nama_mastervalue", $viewControls->showDBValue("nama", $data, $keylink)); // created - Short Date $xt->assign("created_mastervalue", $viewControls->showDBValue("created", $data, $keylink)); // disabled - $xt->assign("disabled_mastervalue", $viewControls->showDBValue("disabled", $data, $keylink)); // passwd - $xt->assign("passwd_mastervalue", $viewControls->showDBValue("passwd", $data, $keylink)); // id - $xt->assign("id_mastervalue", $viewControls->showDBValue("id", $data, $keylink)); // kd_kantor - $xt->assign("kd_kantor_mastervalue", $viewControls->showDBValue("kd_kantor", $data, $keylink)); // kd_kanwil - $xt->assign("kd_kanwil_mastervalue", $viewControls->showDBValue("kd_kanwil", $data, $keylink)); // kd_tp - $xt->assign("kd_tp_mastervalue", $viewControls->showDBValue("kd_tp", $data, $keylink)); // kd_kanwil_bank - $xt->assign("kd_kanwil_bank_mastervalue", $viewControls->showDBValue("kd_kanwil_bank", $data, $keylink)); // kd_kppbb_bank - $xt->assign("kd_kppbb_bank_mastervalue", $viewControls->showDBValue("kd_kppbb_bank", $data, $keylink)); // kd_bank_tunggal - $xt->assign("kd_bank_tunggal_mastervalue", $viewControls->showDBValue("kd_bank_tunggal", $data, $keylink)); // kd_bank_persepsi - $xt->assign("kd_bank_persepsi_mastervalue", $viewControls->showDBValue("kd_bank_persepsi", $data, $keylink)); // nip - $xt->assign("nip_mastervalue", $viewControls->showDBValue("nip", $data, $keylink)); // jabatan - $xt->assign("jabatan_mastervalue", $viewControls->showDBValue("jabatan", $data, $keylink)); // handphone - $xt->assign("handphone_mastervalue", $viewControls->showDBValue("handphone", $data, $keylink)); // create_uid - $xt->assign("create_uid_mastervalue", $viewControls->showDBValue("create_uid", $data, $keylink)); // update_uid - $xt->assign("update_uid_mastervalue", $viewControls->showDBValue("update_uid", $data, $keylink)); // updated - Short Date $xt->assign("updated_mastervalue", $viewControls->showDBValue("updated", $data, $keylink)); // last_login - Short Date $xt->assign("last_login_mastervalue", $viewControls->showDBValue("last_login", $data, $keylink)); // is_login - $xt->assign("is_login_mastervalue", $viewControls->showDBValue("is_login", $data, $keylink)); // is_logout - $xt->assign("is_logout_mastervalue", $viewControls->showDBValue("is_logout", $data, $keylink)); // last_ip - $xt->assign("last_ip_mastervalue", $viewControls->showDBValue("last_ip", $data, $keylink)); $xt->display("app_users_masterprint.htm"); $strTableName = $oldTableName; }
function GetTotals($field, $value, $stype, $iNumberOfRows, $sFormat, $ptype) { global $strTableName; $pSet = new ProjectSettings($strTableName, $ptype); $days = 0; if ($stype == "AVERAGE") { if ($iNumberOfRows) { if ($sFormat == FORMAT_TIME) { if ($value) { $value = round($value / $iNumberOfRows, 0); $s = $value % 60; $value -= $s; $value /= 60; $m = $value % 60; $value -= $m; $value /= 60; $h = $value % 24; $value -= $h; $value /= 24; $d = $value; $value = ($d != 0 ? $d . 'd ' : '') . mysprintf("%02d:%02d:%02d", array($h, $m, $s)); } } else { $value = round($value / $iNumberOfRows, 2); } } else { return ""; } } if ($stype == "TOTAL") { if ($sFormat == FORMAT_TIME) { if ($value) { $s = $value % 60; $value -= $s; $value /= 60; $m = $value % 60; $value -= $m; $value /= 60; $h = $value % 24; $value -= $h; $value /= 24; $d = $value; $value = ($d != 0 ? $d . 'd ' : '') . mysprintf("%02d:%02d:%02d", array($h, $m, $s)); } } } $sValue = ""; $data = array($field => $value); if ($sFormat == FORMAT_CURRENCY) { $sValue = str_format_currency($value); } else { if ($sFormat == FORMAT_PERCENT) { $sValue = str_format_number($value * 100) . "%"; } else { if ($sFormat == FORMAT_NUMBER) { $sValue = str_format_number($value, $pSet->isDecimalDigits($field)); } else { if ($sFormat == FORMAT_CUSTOM && $stype != "COUNT") { include_once getabspath('classes/controls/ViewControlsContainer.php'); $viewControls = new ViewControlsContainer($pSet, $ptype); $sValue = $viewControls->showDBValue($field, $data); } else { $sValue = $value; } } } } if ($stype == "COUNT") { return $value; } if ($stype == "TOTAL") { return $sValue; } if ($stype == "AVERAGE") { return $sValue; } return ""; }
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // tahun - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("tahun", $data, $keylink); $row["tahun_value"] = $value; // sptno - $viewContainer->recId = $recordsCounter;
function DisplayMasterTableInfo_pad_pad_jenis_pajak($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "pad.pad_jenis_pajak"; //$strSQL = "SELECT id, usaha_id, nama, rekening_id, rekening_kd_sub, rekdenda_id, masapajak, jatuhtempo, multiple, jalan_kelas_id, tmt, enabled, created, create_uid, updated, update_uid FROM \"pad\".pad_jenis_pajak "; $cipherer = new RunnerCipherer($strTableName); $settings = new ProjectSettings($strTableName, PAGE_PRINT); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_PRINT); $where = ""; global $pageObject, $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterprint", "RoundedGreen", "MobileGreen"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["pad_pad_jenis_pajak_masterprint"] = $layout; $showKeys = ""; 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_tarif_pajak") { $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 ($detailtable == "pad.pad_terima_line") { $where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[1 - 1], "", "", true); $showKeys .= " " . "Id" . ": " . $keys[1 - 1]; $xt->assign('showKeys', $showKeys); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Export"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->m_where->toSql($masterQuery), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = $cipherer->DecryptFetchedArray($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $xt->assign("id_mastervalue", $viewControls->showDBValue("id", $data, $keylink)); // usaha_id - $xt->assign("usaha_id_mastervalue", $viewControls->showDBValue("usaha_id", $data, $keylink)); // nama - $xt->assign("nama_mastervalue", $viewControls->showDBValue("nama", $data, $keylink)); // rekening_id - $xt->assign("rekening_id_mastervalue", $viewControls->showDBValue("rekening_id", $data, $keylink)); // rekening_kd_sub - $xt->assign("rekening_kd_sub_mastervalue", $viewControls->showDBValue("rekening_kd_sub", $data, $keylink)); // rekdenda_id - $xt->assign("rekdenda_id_mastervalue", $viewControls->showDBValue("rekdenda_id", $data, $keylink)); // masapajak - $xt->assign("masapajak_mastervalue", $viewControls->showDBValue("masapajak", $data, $keylink)); // jatuhtempo - $xt->assign("jatuhtempo_mastervalue", $viewControls->showDBValue("jatuhtempo", $data, $keylink)); // multiple - $xt->assign("multiple_mastervalue", $viewControls->showDBValue("multiple", $data, $keylink)); // jalan_kelas_id - $xt->assign("jalan_kelas_id_mastervalue", $viewControls->showDBValue("jalan_kelas_id", $data, $keylink)); // tmt - Short Date $xt->assign("tmt_mastervalue", $viewControls->showDBValue("tmt", $data, $keylink)); // enabled - $xt->assign("enabled_mastervalue", $viewControls->showDBValue("enabled", $data, $keylink)); // created - Short Date $xt->assign("created_mastervalue", $viewControls->showDBValue("created", $data, $keylink)); // create_uid - $xt->assign("create_uid_mastervalue", $viewControls->showDBValue("create_uid", $data, $keylink)); // updated - Short Date $xt->assign("updated_mastervalue", $viewControls->showDBValue("updated", $data, $keylink)); // update_uid - $xt->assign("update_uid_mastervalue", $viewControls->showDBValue("update_uid", $data, $keylink)); $xt->display("pad_pad_jenis_pajak_masterprint.htm"); $strTableName = $oldTableName; }
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // tahun - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("tahun", $data, $keylink); $row["tahun_value"] = $value; // terimano - $viewContainer->recId = $recordsCounter;
if ($rowcount) { $xt->assign("details_data", true); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); $viewContainer->isDetailsPreview = true; $b = true; $qResult = $pageObject->connection->query($strSQL); $data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc()); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["Groupid"])); // Groupid - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("Groupid", $data, $keylink); $row["Groupid_value"] = $value; $format = $pSet->getViewFormat("Groupid"); $class = "rnr-field-text";
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; }
$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) { } unset($_SESSION["message_add"]); unset($_SESSION["message_edit"]); // prepare code for build page $pageObject->prepareForBuildPage(); $includesArr = array(); $masterTablesInfoArr = $pageObject->pSet->getMasterTablesArr($strTableName);
function DisplayMasterTableInfo_pad_pad_sspd($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "pad.pad_sspd"; //$strSQL = "SELECT id, tahun, sspdno, sspdtgl, sspdjam, invoice_id, keterangan, bulan_telat, hitung_bunga, denda, bunga, jml_bayar, sisa, jenis_bayar, printed, tp_id, is_validated, is_valid, enabled, created, create_uid, updated, update_uid, petugas_id, pejabat_id FROM \"pad\".pad_sspd "; $cipherer = new RunnerCipherer($strTableName); $settings = new ProjectSettings($strTableName, PAGE_PRINT); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_PRINT); $where = ""; global $pageObject, $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterprint", "RoundedGreen", "MobileGreen"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["pad_pad_sspd_masterprint"] = $layout; $showKeys = ""; if ($detailtable == "public.pad_payment") { $where .= GetFullFieldName("id", "", false) . "=" . $cipherer->MakeDBValue("id", $keys[1 - 1], "", "", true); $showKeys .= " " . "Id" . ": " . $keys[1 - 1]; $xt->assign('showKeys', $showKeys); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Export"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->m_where->toSql($masterQuery), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = $cipherer->DecryptFetchedArray($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $xt->assign("id_mastervalue", $viewControls->showDBValue("id", $data, $keylink)); // tahun - $xt->assign("tahun_mastervalue", $viewControls->showDBValue("tahun", $data, $keylink)); // sspdno - $xt->assign("sspdno_mastervalue", $viewControls->showDBValue("sspdno", $data, $keylink)); // sspdtgl - Short Date $xt->assign("sspdtgl_mastervalue", $viewControls->showDBValue("sspdtgl", $data, $keylink)); // sspdjam - Time $xt->assign("sspdjam_mastervalue", $viewControls->showDBValue("sspdjam", $data, $keylink)); // invoice_id - $xt->assign("invoice_id_mastervalue", $viewControls->showDBValue("invoice_id", $data, $keylink)); // keterangan - $xt->assign("keterangan_mastervalue", $viewControls->showDBValue("keterangan", $data, $keylink)); // bulan_telat - $xt->assign("bulan_telat_mastervalue", $viewControls->showDBValue("bulan_telat", $data, $keylink)); // hitung_bunga - $xt->assign("hitung_bunga_mastervalue", $viewControls->showDBValue("hitung_bunga", $data, $keylink)); // denda - Number $xt->assign("denda_mastervalue", $viewControls->showDBValue("denda", $data, $keylink)); // bunga - Number $xt->assign("bunga_mastervalue", $viewControls->showDBValue("bunga", $data, $keylink)); // jml_bayar - $xt->assign("jml_bayar_mastervalue", $viewControls->showDBValue("jml_bayar", $data, $keylink)); // sisa - Number $xt->assign("sisa_mastervalue", $viewControls->showDBValue("sisa", $data, $keylink)); // jenis_bayar - $xt->assign("jenis_bayar_mastervalue", $viewControls->showDBValue("jenis_bayar", $data, $keylink)); // printed - $xt->assign("printed_mastervalue", $viewControls->showDBValue("printed", $data, $keylink)); // tp_id - $xt->assign("tp_id_mastervalue", $viewControls->showDBValue("tp_id", $data, $keylink)); // is_validated - $xt->assign("is_validated_mastervalue", $viewControls->showDBValue("is_validated", $data, $keylink)); // is_valid - $xt->assign("is_valid_mastervalue", $viewControls->showDBValue("is_valid", $data, $keylink)); // enabled - $xt->assign("enabled_mastervalue", $viewControls->showDBValue("enabled", $data, $keylink)); // created - Short Date $xt->assign("created_mastervalue", $viewControls->showDBValue("created", $data, $keylink)); // create_uid - $xt->assign("create_uid_mastervalue", $viewControls->showDBValue("create_uid", $data, $keylink)); // updated - Short Date $xt->assign("updated_mastervalue", $viewControls->showDBValue("updated", $data, $keylink)); // update_uid - $xt->assign("update_uid_mastervalue", $viewControls->showDBValue("update_uid", $data, $keylink)); // petugas_id - $xt->assign("petugas_id_mastervalue", $viewControls->showDBValue("petugas_id", $data, $keylink)); // pejabat_id - $xt->assign("pejabat_id_mastervalue", $viewControls->showDBValue("pejabat_id", $data, $keylink)); $xt->display("pad_pad_sspd_masterprint.htm"); $strTableName = $oldTableName; }
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // usaha_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("usaha_id", $data, $keylink); $row["usaha_id_value"] = $value; // nama - $viewContainer->recId = $recordsCounter;
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // rekening_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("rekening_id", $data, $keylink); $row["rekening_id_value"] = $value; // status_anggaran - Number $viewContainer->recId = $recordsCounter;
for ($i = 0; $i < count($rpt_array['group_fields']) - 1; $i++){ $arr = $rpt_array['group_fields'][$i]; $groupstart[$arr['name']] = 0; $groupvalue[$arr['name']] = ""; } $rowinfo = array(); $fields_type = array(); if (is_wr_custom()) $fields_type = WRGetAllCustomFieldType(); include_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($_SESSION["webobject"]["table"], PAGE_REPORT); $viewControls = new ViewControlsContainer($pSet, PAGE_REPORT); while ($data = db_fetch_array($rs)){ $firstnewgroup = true; $row = array(); $arr_group = array(); $arr_value = array(); // check if starting new group for ($i = 0; $i < count($rpt_array['group_fields']) - 1; $i++){ $arr = $rpt_array['group_fields'][$i]; $newgroup_[$arr['name']] = false; $arr_group[$i]["newgroup"] = false; $arr_group[$i]["name"] = GoodFieldName($arr['name']); $arr_group[$i]["group_order"] = $arr['group_order']; $arr_group[$i]["groupId4"] = 1 + 6 * ($arr['group_order'] - 1); $arr_group[$i]["int_type"] = $arr['int_type'];
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // parent - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("parent", $data, $keylink); $row["parent_value"] = $value; // npwpd - $viewContainer->recId = $recordsCounter;
$rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array(); $data = $cipherer->DecryptFetchedArray($rs); require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["id"])); // id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("id", $data, $keylink); $row["id_value"] = $value; // daftar_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("daftar_id", $data, $keylink); $row["daftar_id_value"] = $value; // status_id - $viewContainer->recId = $recordsCounter;