예제 #1
2
 /**
  * Static function for create list page
  * Read params from setting 
  * Create object of class in accordance with mode displaying page
  * @param String strTableName
  * @param Array options
  */
 static function &createListPage($strTableName, $options)
 {
     global $isGroupSecurity;
     $gSettings = new ProjectSettings($strTableName, $options['pageType']);
     $gQuery = $gSettings->getSQLQuery();
     $params = $options;
     $params['tName'] = $strTableName;
     $params['origTName'] = $gSettings->getOriginalTableName();
     $params['gPageSize'] = $gSettings->getInitialPageSize();
     $params['gOrderIndexes'] = $gSettings->getOrderIndexes();
     $params['gstrOrderBy'] = $gQuery->OrderByToSql();
     $params['gsqlHead'] = $gQuery->HeadToSql();
     $params['gsqlFrom'] = $gQuery->FromToSql();
     $params['gsqlWhereExpr'] = $gQuery->WhereToSql();
     $params['gsqlGroupBy'] = $gQuery->GroupByToSql();
     $params['gsqlHaving'] = $gQuery->Having()->toSql($gQuery);
     $params['nSecOptions'] = $gSettings->getAdvancedSecurityType();
     $params['nLoginMethod'] = GetGlobalData("nLoginMethod", 0);
     $params['recsPerRowList'] = isMobile() ? 1 : $gSettings->getRecordsPerRowList();
     $params['mainTableOwnerID'] = $gSettings->getTableOwnerIdField();
     $params['exportTo'] = $gSettings->hasExportPage();
     $params['printFriendly'] = $gSettings->hasPrintPage();
     $params['deleteRecs'] = $gSettings->hasDelete();
     $params["isGroupSecurity"] = $isGroupSecurity;
     $params['arrKeyFields'] = $gSettings->getTableKeys();
     $params["isUseInlineAdd"] = $gSettings->hasInlineAdd();
     $params["isUseInlineEdit"] = $gSettings->hasInlineEdit();
     $params["panelSearchFields"] = $gSettings->getPanelSearchFields();
     $params['listGridLayout'] = $gSettings->getListGridLayout();
     $params['createLoginPage'] = GetGlobalData("createLoginPage", false);
     $params['noRecordsFirstPage'] = $gSettings->noRecordsOnFirstPage();
     $params['totalsFields'] = $gSettings->getTotalsFields();
     $params['listAjax'] = $gSettings->ajaxBasedListPage();
     $params['arrRecsPerPage'] = $gSettings->getRecordsPerPageArray();
     $params['isScrollGridBody'] = $gSettings->getScrollGridBody();
     $params['viewPDF'] = $gSettings->isViewPagePDF() || $gSettings->isPrinterPagePDF();
     $params['audit'] = GetAuditObject($table);
     $params['listFields'] = array();
     $allfields = $gSettings->getListFields();
     foreach ($allfields as $f) {
         if (!$gSettings->appearOnListPage($f)) {
             continue;
         }
         $params['listFields'][] = array("fName" => $f, "goodFieldName" => GoodFieldName($f), "valueFieldName" => GoodFieldName($f) . "_value", "viewFormat" => $gSettings->getViewFormat($f), "editFormat" => $gSettings->getEditFormat($f));
     }
     // choose class by mode
     if ($params["mode"] == LIST_SIMPLE) {
         $pageObject = new ListPage_Simple($params);
     } else {
         if ($params["mode"] == LIST_AJAX) {
             $pageObject = new ListPage_Ajax($params);
         } else {
             if ($params["mode"] == LIST_LOOKUP) {
                 $pageObject = new ListPage_Lookup($params);
             } else {
                 if ($params["mode"] == LIST_DETAILS || $params["mode"] == LIST_DASHDETAILS) {
                     $pageObject = new ListPage_DPInline($params);
                 } else {
                     if ($params["mode"] == RIGHTS_PAGE) {
                         $pageObject = new RightsPage($params);
                     } else {
                         if ($params["mode"] == MEMBERS_PAGE) {
                             $pageObject = new MembersPage($params);
                         } else {
                             if ($params["mode"] == LIST_DASHBOARD) {
                                 $pageObject = new ListPage_Dashboard($params);
                             }
                         }
                     }
                 }
             }
         }
     }
     $pageObject->init();
     return $pageObject;
 }
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;
}
예제 #3
0
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;
}
예제 #4
0
 } else {
     $connId = $gSettings->getNotProjectLookupTableConnId($f);
     $lookupConnection = strlen($connId) ? $cman->byId($connId) : $cman->getDefault();
 }
 $linkFieldName = $gSettings->getLinkField($f);
 $displayFieldName = $gSettings->getDisplayField($f);
 $linkAndDisplaySame = $displayFieldName == $linkFieldName;
 $lookupOrderBy = $gSettings->getLookupOrderBy($f);
 $lwDisplayField = RunnerPage::sqlFormattedDisplayField($f, $lookupConnection, $gSettings);
 if ($lookupConnection->dbType == nDATABASE_MSSQLServer) {
     $strUniqueOrderBy = $lookupOrderBy;
 }
 if ($LookupType == LT_QUERY) {
     $lookupPSet = new ProjectSettings($lookupTable, $pageType);
     $lookupCipherer = new RunnerCipherer($lookupTable);
     $lookupQueryObj = $lookupPSet->getSQLQuery();
     if ($gSettings->getCustomDisplay($f)) {
         $lookupQueryObj->AddCustomExpression($displayFieldName, $lookupPSet, $strTableName, $f);
     }
     $lookupQueryObj->ReplaceFieldsWithDummies($lookupPSet->getBinaryFieldsIndices());
 } else {
     $LookupSQLTable = "SELECT ";
     $lwLinkField = $lookupConnection->addFieldWrappers($gSettings->getLinkField($f));
     if ($gSettings->isLookupUnique($f)) {
         $LookupSQLTable .= "DISTINCT ";
     }
     $LookupSQLTable .= $cipherer->GetLookupFieldName($lwLinkField, $f, null, true);
     if ($lookupConnection->dbType == nDATABASE_MSSQLServer) {
         if ($strUniqueOrderBy && $gSettings->isLookupUnique($f)) {
             $LookupSQLTable .= "," . $lookupConnection->addFieldWrappers($strUniqueOrderBy);
         }
예제 #5
0
 /**
  * Static function for create list page
  * Read params from setting 
  * Create object of class in accordance with mode displaying page 
  */
 function &createListPage($table, $options)
 {
     global $bSubqueriesSupported, $strTableName, $conn, $locale_info, $isGroupSecurity;
     $gSettings = new ProjectSettings($strTableName, $options['pageType']);
     $gQuery = $gSettings->getSQLQuery();
     $params = array();
     $params = $options;
     $params['origTName'] = $gSettings->getOriginalTableName();
     $params['sessionPrefix'] = $strTableName;
     $params['tName'] = $table;
     $params['conn'] =& $conn;
     $params['gPageSize'] = $gSettings->getInitialPageSize();
     $params['gOrderIndexes'] = $gSettings->getOrderIndexes();
     $params['gstrOrderBy'] = $gQuery->OrderByToSql();
     $params['gsqlHead'] = $gQuery->HeadToSql();
     $params['gsqlFrom'] = $gQuery->FromToSql();
     $params['gsqlWhereExpr'] = $gQuery->WhereToSql();
     $params['gsqlGroupBy'] = $gQuery->GroupByToSql();
     $params['gsqlHaving'] = $gQuery->Having()->toSql($gQuery);
     $params['locale_info'] =& $locale_info;
     $params["subQueriesSupp"] = $bSubqueriesSupported;
     $params['nSecOptions'] = $gSettings->getAdvancedSecurityType();
     $params['nLoginMethod'] = GetGlobalData("nLoginMethod", 0);
     $params['recsPerRowList'] = $gSettings->getRecordsPerRowList();
     $params['dbType'] = GetGlobalData("dbType", 0);
     $params['mainTableOwnerID'] = $gSettings->getTableOwnerIdField();
     $params['moveNext'] = $gSettings->useMoveNext();
     $params['exportTo'] = $gSettings->hasExportPage();
     $params['printFriendly'] = $gSettings->hasPrintPage();
     $params['deleteRecs'] = $gSettings->hasDelete();
     $params['rowHighlite'] = $gSettings->highlightRows();
     $params["isGroupSecurity"] = $isGroupSecurity;
     $params['arrKeyFields'] = $gSettings->getTableKeys();
     $params["isUseInlineAdd"] = $gSettings->hasInlineAdd();
     $params["isUseInlineEdit"] = $gSettings->hasInlineEdit();
     $params["isUseInlineJs"] = $params["isUseInlineAdd"] || $params["isUseInlineEdit"];
     $params["panelSearchFields"] = $gSettings->getPanelSearchFields();
     $params['isVerLayout'] = $gSettings->isVerticalLayoutList();
     $params['isDisplayLoading'] = $gSettings->displayLoading();
     $params['createLoginPage'] = GetGlobalData("createLoginPage", false);
     $params['subQueriesSupAccess'] = $gSettings->tableSupportsSubqueries();
     $params['noRecordsFirstPage'] = $gSettings->noRecordsOnFirstPage();
     $params['totalsFields'] = $gSettings->getTotalsFields();
     $params['listIcons'] = $gSettings->iconsOnList();
     $params['edit'] = $gSettings->hasEditPage();
     $params['inlineEdit'] = $gSettings->hasInlineEdit();
     $params['iCopy'] = $gSettings->hasCopyPage();
     $params['iView'] = $gSettings->hasViewPage();
     $params['listAjax'] = $gSettings->ajaxBasedListPage();
     $params['arrRecsPerPage'] = $gSettings->getRecordsPerPageArray();
     $params['isScrollGridBody'] = $gSettings->getScrollGridBody();
     $params['audit'] = GetAuditObject($table);
     $params['listFields'] = array();
     $allfields = $gSettings->getListFields();
     foreach ($allfields as $f) {
         if (!$gSettings->appearOnListPage($f)) {
             continue;
         }
         $params['listFields'][] = array("fName" => $f, "goodFieldName" => GoodFieldName($f), "valueFieldName" => GoodFieldName($f) . "_value", "viewFormat" => $gSettings->getViewFormat($f), "editFormat" => $gSettings->getEditFormat($f));
     }
     // choose class by mode
     if ($params["mode"] == LIST_SIMPLE) {
         $pageObject = new ListPage_Simple($params);
     } else {
         if ($params["mode"] == LIST_AJAX) {
             $pageObject = new ListPage_Ajax($params);
         } else {
             if ($params["mode"] == LIST_LOOKUP) {
                 $pageObject = new ListPage_Lookup($params);
             } else {
                 if ($params["mode"] == LIST_DETAILS) {
                     $pageObject = new ListPage_DPInline($params);
                 } else {
                     if ($params["mode"] == RIGHTS_PAGE) {
                         $pageObject = new RightsPage($params);
                     } else {
                         if ($params["mode"] == MEMBERS_PAGE) {
                             $pageObject = new MembersPage($params);
                         }
                     }
                 }
             }
         }
     }
     return $pageObject;
 }
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;
}
예제 #7
0
	/**
	 * Get master record
	 *
	 * User function
	 * Using only in events by users
	 * @return{array}
	 * @intellisense
	 */
	function getMasterRecord()
	{
		if (!is_null($this->masterRecordData))
			return $this->masterRecordData;
		
		if(!$this->masterTable)
			return null;
			
	
		global $detailsTablesData, $masterTablesData;	
		$settings = new ProjectSettings($this->masterTable, PAGE_LIST);
		
		$where = "";
		$masterTablesInfoArr = $this->pSet->getMasterTablesArr($this->tName);
		for($i=0; $i < count($masterTablesInfoArr); $i++) 
		{
			if($this->masterTable == $masterTablesInfoArr[$i]['mDataSourceTable']) 
			{
				$masterKeys = $this->getActiveMasterKeys();
				$cipherer = new RunnerCipherer($this->masterTable);
				for($j=0; $j < count($masterTablesInfoArr[$i]['masterKeys']); $j++)
				{
					if($j)
						$where.= " and ";
					$mKey = $masterTablesInfoArr[$i]['masterKeys'][$j];
					$where.= $settings->getFullNameField($mKey)."=".$cipherer->MakeDBValue($mKey, $masterKeys[$j], "", "", true);
				}
			}
		}
		
		if(!$where)
			return null;
					
		$masterQuery = $settings->getSQLQuery();
		
		$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();
		
		global $conn;
		
		LogInfo($strSQL);
		$rs = db_query($strSQL,$conn);
		$this->masterRecordData = $cipherer->DecryptFetchedArray($rs);
		return $this->masterRecordData;
	}
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_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;
}
예제 #10
0
 /**
  * Get master record
  *
  * User function
  * Using only in events by users
  * @return{array}
  * @intellisense
  */
 function getMasterRecord()
 {
     if (!is_null($this->masterRecordData)) {
         return $this->masterRecordData;
     }
     if (!$this->masterTable) {
         return null;
     }
     $where = "";
     $masterTablesInfoArr = $this->pSet->getMasterTablesArr($this->tName);
     for ($i = 0; $i < count($masterTablesInfoArr); $i++) {
         if ($this->masterTable == $masterTablesInfoArr[$i]['mDataSourceTable']) {
             for ($j = 0; $j < count($masterTablesInfoArr[$i]['detailKeys']); $j++) {
                 $masterKeys[] = @$_SESSION[$this->sessionPrefix . "_masterkey" . ($j + 1)];
             }
             $cipherer = new RunnerCipherer($this->masterTable);
             for ($j = 0; $j < count($masterTablesInfoArr[$i]['masterKeys']); $j++) {
                 if ($j) {
                     $where .= " and ";
                 }
                 $mKey = $masterTablesInfoArr[$i]['masterKeys'][$j];
                 $where .= GetFullFieldName($mKey, "", false) . "=" . $cipherer->MakeDBValue($mKey, $masterKeys[$j], "", "", true);
             }
         }
     }
     if (!$where) {
         return null;
     }
     global $conn;
     $settings = new ProjectSettings($this->masterTable, PAGE_LIST);
     $masterQuery = $settings->getSQLQuery();
     $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);
     $rs = db_query($strSQL, $conn);
     $this->masterRecordData = $cipherer->DecryptFetchedArray($rs);
     return $this->masterRecordData;
 }
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"));
}
예제 #12
0
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;
}
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;
}
function DisplayMasterTableInfo_pad_pad_daftar($params)
{
    $detailtable = $params["detailtable"];
    $keys = $params["keys"];
    global $conn, $strTableName;
    $xt = new Xtempl();
    $oldTableName = $strTableName;
    $strTableName = "pad.pad_daftar";
    //$strSQL = "SELECT id,   rp,   pb,   formno,   reg_date,   customernm,   kecamatan_id,   kelurahan_id,   kabupaten,   alamat,   kodepos,   telphone,   wpnama,   wpalamat,   wpkelurahan,   wpkecamatan,   wpkabupaten,   wptelp,   wpkodepos,   pnama,   palamat,   pkelurahan,   pkecamatan,   pkabupaten,   ptelp,   pkodepos,   ijin1,   ijin1no,   ijin1tgl,   ijin1tglakhir,   ijin2,   ijin2no,   ijin2tgl,   ijin2tglakhir,   ijin3,   ijin3no,   ijin3tgl,   ijin3tglakhir,   ijin4,   ijin4no,   ijin4tgl,   ijin4tglakhir,   enabled,   create_date,   create_uid,   write_date,   write_uid,   op_nm,   op_alamat,   op_usaha_id,   op_so,   op_kecamatan_id,   op_kelurahan_id,   op_latitude,   op_longitude,   kd_restojmlmeja,   kd_restojmlkursi,   kd_restojmltamu,   kd_filmkursi,   kd_filmpertunjukan,   kd_filmtarif,   kd_bilyarmeja,   kd_bilyartarif,   kd_bilyarkegiatan,   kd_diskopengunjung,   kd_diskotarif,   kd_waletvolume,   email,   op_pajak_id,   npwpd,   passwd  FROM \"pad\".pad_daftar ";
    $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_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 ($detailtable == "pad.pad_daftar_kd_det") {
        $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));
    //	rp -
    $xt->assign("rp_mastervalue", $viewControls->showDBValue("rp", $data, $keylink));
    //	pb -
    $xt->assign("pb_mastervalue", $viewControls->showDBValue("pb", $data, $keylink));
    //	formno -
    $xt->assign("formno_mastervalue", $viewControls->showDBValue("formno", $data, $keylink));
    //	reg_date - Short Date
    $xt->assign("reg_date_mastervalue", $viewControls->showDBValue("reg_date", $data, $keylink));
    //	customernm -
    $xt->assign("customernm_mastervalue", $viewControls->showDBValue("customernm", $data, $keylink));
    //	kecamatan_id -
    $xt->assign("kecamatan_id_mastervalue", $viewControls->showDBValue("kecamatan_id", $data, $keylink));
    //	kelurahan_id -
    $xt->assign("kelurahan_id_mastervalue", $viewControls->showDBValue("kelurahan_id", $data, $keylink));
    //	kabupaten -
    $xt->assign("kabupaten_mastervalue", $viewControls->showDBValue("kabupaten", $data, $keylink));
    //	alamat -
    $xt->assign("alamat_mastervalue", $viewControls->showDBValue("alamat", $data, $keylink));
    //	kodepos -
    $xt->assign("kodepos_mastervalue", $viewControls->showDBValue("kodepos", $data, $keylink));
    //	telphone -
    $xt->assign("telphone_mastervalue", $viewControls->showDBValue("telphone", $data, $keylink));
    //	wpnama -
    $xt->assign("wpnama_mastervalue", $viewControls->showDBValue("wpnama", $data, $keylink));
    //	wpalamat -
    $xt->assign("wpalamat_mastervalue", $viewControls->showDBValue("wpalamat", $data, $keylink));
    //	wpkelurahan -
    $xt->assign("wpkelurahan_mastervalue", $viewControls->showDBValue("wpkelurahan", $data, $keylink));
    //	wpkecamatan -
    $xt->assign("wpkecamatan_mastervalue", $viewControls->showDBValue("wpkecamatan", $data, $keylink));
    //	wpkabupaten -
    $xt->assign("wpkabupaten_mastervalue", $viewControls->showDBValue("wpkabupaten", $data, $keylink));
    //	wptelp -
    $xt->assign("wptelp_mastervalue", $viewControls->showDBValue("wptelp", $data, $keylink));
    //	wpkodepos -
    $xt->assign("wpkodepos_mastervalue", $viewControls->showDBValue("wpkodepos", $data, $keylink));
    //	pnama -
    $xt->assign("pnama_mastervalue", $viewControls->showDBValue("pnama", $data, $keylink));
    //	palamat -
    $xt->assign("palamat_mastervalue", $viewControls->showDBValue("palamat", $data, $keylink));
    //	pkelurahan -
    $xt->assign("pkelurahan_mastervalue", $viewControls->showDBValue("pkelurahan", $data, $keylink));
    //	pkecamatan -
    $xt->assign("pkecamatan_mastervalue", $viewControls->showDBValue("pkecamatan", $data, $keylink));
    //	pkabupaten -
    $xt->assign("pkabupaten_mastervalue", $viewControls->showDBValue("pkabupaten", $data, $keylink));
    //	ptelp -
    $xt->assign("ptelp_mastervalue", $viewControls->showDBValue("ptelp", $data, $keylink));
    //	pkodepos -
    $xt->assign("pkodepos_mastervalue", $viewControls->showDBValue("pkodepos", $data, $keylink));
    //	ijin1 -
    $xt->assign("ijin1_mastervalue", $viewControls->showDBValue("ijin1", $data, $keylink));
    //	ijin1no -
    $xt->assign("ijin1no_mastervalue", $viewControls->showDBValue("ijin1no", $data, $keylink));
    //	ijin1tgl - Short Date
    $xt->assign("ijin1tgl_mastervalue", $viewControls->showDBValue("ijin1tgl", $data, $keylink));
    //	ijin1tglakhir - Short Date
    $xt->assign("ijin1tglakhir_mastervalue", $viewControls->showDBValue("ijin1tglakhir", $data, $keylink));
    //	ijin2 -
    $xt->assign("ijin2_mastervalue", $viewControls->showDBValue("ijin2", $data, $keylink));
    //	ijin2no -
    $xt->assign("ijin2no_mastervalue", $viewControls->showDBValue("ijin2no", $data, $keylink));
    //	ijin2tgl - Short Date
    $xt->assign("ijin2tgl_mastervalue", $viewControls->showDBValue("ijin2tgl", $data, $keylink));
    //	ijin2tglakhir - Short Date
    $xt->assign("ijin2tglakhir_mastervalue", $viewControls->showDBValue("ijin2tglakhir", $data, $keylink));
    //	ijin3 -
    $xt->assign("ijin3_mastervalue", $viewControls->showDBValue("ijin3", $data, $keylink));
    //	ijin3no -
    $xt->assign("ijin3no_mastervalue", $viewControls->showDBValue("ijin3no", $data, $keylink));
    //	ijin3tgl - Short Date
    $xt->assign("ijin3tgl_mastervalue", $viewControls->showDBValue("ijin3tgl", $data, $keylink));
    //	ijin3tglakhir - Short Date
    $xt->assign("ijin3tglakhir_mastervalue", $viewControls->showDBValue("ijin3tglakhir", $data, $keylink));
    //	ijin4 -
    $xt->assign("ijin4_mastervalue", $viewControls->showDBValue("ijin4", $data, $keylink));
    //	ijin4no -
    $xt->assign("ijin4no_mastervalue", $viewControls->showDBValue("ijin4no", $data, $keylink));
    //	ijin4tgl - Short Date
    $xt->assign("ijin4tgl_mastervalue", $viewControls->showDBValue("ijin4tgl", $data, $keylink));
    //	ijin4tglakhir - Short Date
    $xt->assign("ijin4tglakhir_mastervalue", $viewControls->showDBValue("ijin4tglakhir", $data, $keylink));
    //	enabled -
    $xt->assign("enabled_mastervalue", $viewControls->showDBValue("enabled", $data, $keylink));
    //	create_date - Short Date
    $xt->assign("create_date_mastervalue", $viewControls->showDBValue("create_date", $data, $keylink));
    //	create_uid -
    $xt->assign("create_uid_mastervalue", $viewControls->showDBValue("create_uid", $data, $keylink));
    //	write_date - Short Date
    $xt->assign("write_date_mastervalue", $viewControls->showDBValue("write_date", $data, $keylink));
    //	write_uid -
    $xt->assign("write_uid_mastervalue", $viewControls->showDBValue("write_uid", $data, $keylink));
    //	op_nm -
    $xt->assign("op_nm_mastervalue", $viewControls->showDBValue("op_nm", $data, $keylink));
    //	op_alamat -
    $xt->assign("op_alamat_mastervalue", $viewControls->showDBValue("op_alamat", $data, $keylink));
    //	op_usaha_id -
    $xt->assign("op_usaha_id_mastervalue", $viewControls->showDBValue("op_usaha_id", $data, $keylink));
    //	op_so -
    $xt->assign("op_so_mastervalue", $viewControls->showDBValue("op_so", $data, $keylink));
    //	op_kecamatan_id -
    $xt->assign("op_kecamatan_id_mastervalue", $viewControls->showDBValue("op_kecamatan_id", $data, $keylink));
    //	op_kelurahan_id -
    $xt->assign("op_kelurahan_id_mastervalue", $viewControls->showDBValue("op_kelurahan_id", $data, $keylink));
    //	op_latitude - Number
    $xt->assign("op_latitude_mastervalue", $viewControls->showDBValue("op_latitude", $data, $keylink));
    //	op_longitude - Number
    $xt->assign("op_longitude_mastervalue", $viewControls->showDBValue("op_longitude", $data, $keylink));
    //	kd_restojmlmeja -
    $xt->assign("kd_restojmlmeja_mastervalue", $viewControls->showDBValue("kd_restojmlmeja", $data, $keylink));
    //	kd_restojmlkursi -
    $xt->assign("kd_restojmlkursi_mastervalue", $viewControls->showDBValue("kd_restojmlkursi", $data, $keylink));
    //	kd_restojmltamu -
    $xt->assign("kd_restojmltamu_mastervalue", $viewControls->showDBValue("kd_restojmltamu", $data, $keylink));
    //	kd_filmkursi -
    $xt->assign("kd_filmkursi_mastervalue", $viewControls->showDBValue("kd_filmkursi", $data, $keylink));
    //	kd_filmpertunjukan -
    $xt->assign("kd_filmpertunjukan_mastervalue", $viewControls->showDBValue("kd_filmpertunjukan", $data, $keylink));
    //	kd_filmtarif - Number
    $xt->assign("kd_filmtarif_mastervalue", $viewControls->showDBValue("kd_filmtarif", $data, $keylink));
    //	kd_bilyarmeja -
    $xt->assign("kd_bilyarmeja_mastervalue", $viewControls->showDBValue("kd_bilyarmeja", $data, $keylink));
    //	kd_bilyartarif - Number
    $xt->assign("kd_bilyartarif_mastervalue", $viewControls->showDBValue("kd_bilyartarif", $data, $keylink));
    //	kd_bilyarkegiatan -
    $xt->assign("kd_bilyarkegiatan_mastervalue", $viewControls->showDBValue("kd_bilyarkegiatan", $data, $keylink));
    //	kd_diskopengunjung -
    $xt->assign("kd_diskopengunjung_mastervalue", $viewControls->showDBValue("kd_diskopengunjung", $data, $keylink));
    //	kd_diskotarif - Number
    $xt->assign("kd_diskotarif_mastervalue", $viewControls->showDBValue("kd_diskotarif", $data, $keylink));
    //	kd_waletvolume -
    $xt->assign("kd_waletvolume_mastervalue", $viewControls->showDBValue("kd_waletvolume", $data, $keylink));
    //	email -
    $xt->assign("email_mastervalue", $viewControls->showDBValue("email", $data, $keylink));
    //	op_pajak_id -
    $xt->assign("op_pajak_id_mastervalue", $viewControls->showDBValue("op_pajak_id", $data, $keylink));
    //	npwpd -
    $xt->assign("npwpd_mastervalue", $viewControls->showDBValue("npwpd", $data, $keylink));
    //	passwd -
    $xt->assign("passwd_mastervalue", $viewControls->showDBValue("passwd", $data, $keylink));
    $xt->display("pad_pad_daftar_masterprint.htm");
    $strTableName = $oldTableName;
}
예제 #15
0
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;
}
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;
}
예제 #17
0
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"));
}
예제 #18
0
function buildLookupSQL($pageType, $field, $table, $parentVal, $childVal = "", $doCategoryFilter = true, $doValueFilter = false, $addCategoryField = false, $doWhereFilter = true, $oneRecordMode = false, $doValueFilterByLinkField = false)
{
    global $strTableName;
    if (!strlen($table)) {
        $table = $strTableName;
    }
    $pSet = new ProjectSettings($table, $pageType);
    //	read settings
    $nLookupType = $pSet->getLookupType($field);
    if ($nLookupType != LT_LOOKUPTABLE && $nLookupType != LT_QUERY) {
        return "";
    }
    $lookupTable = $pSet->getLookupTable($field);
    $displayFieldName = $pSet->getDisplayField($field);
    $linkFieldName = $pSet->getLinkField($field);
    $linkAndDisplaySame = $displayFieldName == $linkFieldName;
    $bUnique = $pSet->isLookupUnique($field);
    $strLookupWhere = GetLWWhere($field, $pageType, $table);
    $strOrderBy = $pSet->getLookupOrderBy($field);
    if (strlen($strOrderBy)) {
        $strOrderBy = GetFullFieldName($strOrderBy, $lookupTable);
        if ($pSet->isLookupDesc($field)) {
            $strOrderBy .= ' DESC';
        }
    }
    $bDesc = $pSet->isLookupDesc($field);
    $strCategoryFilter = $pSet->getCategoryFilter($field);
    if ($nLookupType == LT_QUERY) {
        $lookupPSet = new ProjectSettings($lookupTable, $pageType);
        $cipherer = new RunnerCipherer($lookupTable, $lookupPSet);
    } else {
        $cipherer = new RunnerCipherer($table, $pSet);
    }
    if ($doCategoryFilter) {
        if ($nLookupType == LT_QUERY) {
            $parentVal = $cipherer->MakeDBValue($strCategoryFilter, $parentVal, "", $lookupTable, true);
        } else {
            $parentVal = make_db_value($pSet->getCategoryControl($field), $parentVal, '', '', $table);
        }
    }
    if ($doValueFilter) {
        if ($pageType != PAGE_SEARCH || $doValueFilterByLinkField) {
            if ($nLookupType == LT_QUERY) {
                $childWhereField = $pSet->getLWLinkField($field, false);
            } else {
                $childWhereField = $pSet->getLWLinkField($field, true);
            }
        } else {
            if ($nLookupType == LT_QUERY) {
                $childWhereField = $pSet->getLWDisplayField($field, false);
            } else {
                $childWhereField = $pSet->getLWDisplayField($field, true);
            }
        }
        if ($nLookupType == LT_QUERY) {
            $childVal = $cipherer->MakeDBValue($childWhereField, $childVal, "", $lookupTable, true);
        } else {
            if ($linkAndDisplaySame) {
                $childVal = make_db_value($field, $childVal, '', '', $table);
            } else {
                $childVal = add_db_quotes($field, $childVal, $table, 200);
            }
        }
    }
    //	build Where clause
    $categoryWhere = "";
    $childWhere = "";
    if ($pSet->useCategory($field) && $doCategoryFilter) {
        $condition = "=" . $parentVal;
        if ($parentVal === "null") {
            $condition = " is null";
        }
        if ($nLookupType == LT_QUERY) {
            $categoryWhere = $cipherer->GetFieldName(AddFieldWrappers($strCategoryFilter), $strCategoryFilter) . $condition;
        } else {
            $categoryWhere = AddFieldWrappers($strCategoryFilter) . $condition;
        }
    }
    if ($doValueFilter) {
        $condition = "=" . $childVal;
        if ($childVal === "null") {
            $condition = " is null";
        }
        if ($nLookupType == LT_QUERY) {
            if ($pageType != PAGE_SEARCH || $pSet->lookupControlType($field) == LCT_LIST || $doValueFilterByLinkField) {
                $childWhere = GetFullFieldName($pSet->getLinkField($field), $lookupTable, false) . $condition;
            } else {
                if (!$pSet->getCustomDisplay($field)) {
                    $childWhere = $cipherer->GetFieldName($lookupPSet->getFullNameField($displayFieldName), $field) . $condition;
                } else {
                    $childWhere = $pSet->getDisplayField($field) . $condition;
                }
            }
        } else {
            if ($pageType != PAGE_SEARCH || $doValueFilterByLinkField) {
                $childWhere = $pSet->getLWLinkField($field, true) . $condition;
            } else {
                $childWhere = $pSet->getLWDisplayField($field, true) . $condition;
            }
        }
    }
    $strWhere = "";
    if ($doWhereFilter && strlen($strLookupWhere)) {
        $strWhere = "(" . $strLookupWhere . ")";
    }
    if (strlen($categoryWhere)) {
        if (strlen($strWhere)) {
            $strWhere .= " AND ";
        }
        $strWhere .= $categoryWhere;
    }
    if (strlen($childWhere)) {
        if (strlen($strWhere)) {
            $strWhere .= " AND ";
        }
        $strWhere .= $childWhere;
    }
    //	build SQL string
    if ($nLookupType == LT_QUERY) {
        $lookupQueryObj = $lookupPSet->getSQLQuery();
        if ($pSet->getCustomDisplay($field)) {
            $lookupQueryObj->AddCustomExpression($displayFieldName, $lookupPSet, $table, $field);
        }
        $lookupQueryObj->ReplaceFieldsWithDummies($lookupPSet->getBinaryFieldsIndices());
        $strWhere = whereAdd($lookupQueryObj->m_where->toSql($lookupQueryObj), $strWhere);
        $LookupSQL = $lookupQueryObj->toSql($strWhere, strlen($strOrderBy) ? ' ORDER BY ' . $strOrderBy : null, null, $oneRecordMode);
    } else {
        $LookupSQL = "SELECT ";
        if ($bUnique && !$oneRecordMode) {
            $LookupSQL .= "DISTINCT ";
        }
        $LookupSQL .= $pSet->getLWLinkField($field);
        if (!$linkAndDisplaySame) {
            $LookupSQL .= "," . $pSet->getLWDisplayField($field);
        }
        if ($addCategoryField && strlen($strCategoryFilter)) {
            $LookupSQL .= "," . AddFieldWrappers($strCategoryFilter);
        }
        $LookupSQL .= " FROM " . AddTableWrappers($lookupTable);
        if (strlen($strWhere)) {
            $LookupSQL .= " WHERE " . $strWhere;
        }
        //	order by clause
        if (strlen($strOrderBy)) {
            $LookupSQL .= " ORDER BY " . AddTableWrappers($lookupTable) . "." . $strOrderBy;
        }
        if ($oneRecordMode) {
            $LookupSQL .= " limit 1";
        }
    }
    return $LookupSQL;
}
예제 #19
0
<?php

$strTableName = "company";
$_SESSION["OwnerID"] = $_SESSION["_" . $strTableName . "_OwnerID"];
$strOriginalTableName = "company";
$gstrOrderBy = "";
if (strlen($gstrOrderBy) && strtolower(substr($gstrOrderBy, 0, 8)) != "order by") {
    $gstrOrderBy = "order by " . $gstrOrderBy;
}
// alias for 'SQLQuery' object
$gSettings = new ProjectSettings("company");
$gQuery = $gSettings->getSQLQuery();
$eventObj =& $tableEvents["company"];
$reportCaseSensitiveGroupFields = false;
$gstrSQL = $gQuery->gSQLWhere("");
function DisplayMasterTableInfoForPrint_GE_PERSONA_DISPONIBLE($params)
{
    global $cman;
    $detailtable = $params["detailtable"];
    $keys = $params["keys"];
    $xt = new Xtempl();
    $tName = "GE.PERSONA_DISPONIBLE";
    $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 == "GE.PERSONA_DISPONIBLEXEJERCICIO") {
        $keysAssoc["USERNAME"] = $keys[1 - 1];
        $keysAssoc["ES_REAL"] = $keys[2 - 1];
        $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[1 - 1], "", true);
        $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue;
        $where .= " and ";
        $showKeys .= " , ";
        $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[2 - 1], "", true);
        $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue;
        $xt->assign('showKeys', $showKeys);
    }
    if ($detailtable == "GE.PERSONA_DISPONIBLEXCOLOR_PELO") {
        $keysAssoc["ES_REAL"] = $keys[1 - 1];
        $keysAssoc["USERNAME"] = $keys[2 - 1];
        $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[1 - 1], "", true);
        $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue;
        $where .= " and ";
        $showKeys .= " , ";
        $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[2 - 1], "", true);
        $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue;
        $xt->assign('showKeys', $showKeys);
    }
    if ($detailtable == "GE.PERSONA_DISPONIBLEXIDIOMA") {
        $keysAssoc["USERNAME"] = $keys[1 - 1];
        $keysAssoc["ES_REAL"] = $keys[2 - 1];
        $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[1 - 1], "", true);
        $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue;
        $where .= " and ";
        $showKeys .= " , ";
        $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[2 - 1], "", true);
        $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue;
        $xt->assign('showKeys', $showKeys);
    }
    if ($detailtable == "GE.PERSONA_DISPONIBLEXOCUPACION") {
        $keysAssoc["ES_REAL"] = $keys[1 - 1];
        $keysAssoc["USERNAME"] = $keys[2 - 1];
        $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[1 - 1], "", true);
        $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue;
        $where .= " and ";
        $showKeys .= " , ";
        $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[2 - 1], "", true);
        $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue;
        $xt->assign('showKeys', $showKeys);
    }
    if ($detailtable == "GE.PERSONA_DISPONIBLEXRELIGION") {
        $keysAssoc["USERNAME"] = $keys[1 - 1];
        $keysAssoc["ES_REAL"] = $keys[2 - 1];
        $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[1 - 1], "", true);
        $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue;
        $where .= " and ";
        $showKeys .= " , ";
        $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[2 - 1], "", true);
        $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue;
        $xt->assign('showKeys', $showKeys);
    }
    if ($detailtable == "GE.PERSONA_DISPONIBLEXINTERES") {
        $keysAssoc["ES_REAL"] = $keys[1 - 1];
        $keysAssoc["USERNAME"] = $keys[2 - 1];
        $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[1 - 1], "", true);
        $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue;
        $where .= " and ";
        $showKeys .= " , ";
        $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[2 - 1], "", true);
        $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue;
        $xt->assign('showKeys', $showKeys);
    }
    if ($detailtable == "GE.PERSONA_DISPONIBLEXMASCOTA") {
        $keysAssoc["USERNAME"] = $keys[1 - 1];
        $keysAssoc["ES_REAL"] = $keys[2 - 1];
        $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[1 - 1], "", true);
        $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue;
        $where .= " and ";
        $showKeys .= " , ";
        $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[2 - 1], "", true);
        $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc);
        $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue;
        $xt->assign('showKeys', $showKeys);
    }
    if (!$where) {
        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();
    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["USERNAME"]));
    $keylink .= "&key2=" . runner_htmlspecialchars(rawurlencode(@$data["ES_REAL"]));
    $xt->assign("USERNAME_mastervalue", $viewControls->showDBValue("USERNAME", $data, $keylink));
    $format = $settings->getViewFormat("USERNAME");
    $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("USERNAME"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("USERNAME_class", $class);
    // add class for field header as field value
    $xt->assign("ES_REAL_mastervalue", $viewControls->showDBValue("ES_REAL", $data, $keylink));
    $format = $settings->getViewFormat("ES_REAL");
    $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("ES_REAL"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("ES_REAL_class", $class);
    // add class for field header as field value
    $xt->assign("COLOR_OJOS_ID_mastervalue", $viewControls->showDBValue("COLOR_OJOS_ID", $data, $keylink));
    $format = $settings->getViewFormat("COLOR_OJOS_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("COLOR_OJOS_ID"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("COLOR_OJOS_ID_class", $class);
    // add class for field header as field value
    $xt->assign("COLOR_PIEL_ID_mastervalue", $viewControls->showDBValue("COLOR_PIEL_ID", $data, $keylink));
    $format = $settings->getViewFormat("COLOR_PIEL_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("COLOR_PIEL_ID"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("COLOR_PIEL_ID_class", $class);
    // add class for field header as field value
    $xt->assign("CONTEXTURA_ID_mastervalue", $viewControls->showDBValue("CONTEXTURA_ID", $data, $keylink));
    $format = $settings->getViewFormat("CONTEXTURA_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("CONTEXTURA_ID"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("CONTEXTURA_ID_class", $class);
    // add class for field header as field value
    $xt->assign("NIVEL_EDUCACION_ID_mastervalue", $viewControls->showDBValue("NIVEL_EDUCACION_ID", $data, $keylink));
    $format = $settings->getViewFormat("NIVEL_EDUCACION_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("NIVEL_EDUCACION_ID"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("NIVEL_EDUCACION_ID_class", $class);
    // add class for field header as field value
    $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("FUMADOR_ID_mastervalue", $viewControls->showDBValue("FUMADOR_ID", $data, $keylink));
    $format = $settings->getViewFormat("FUMADOR_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("FUMADOR_ID"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("FUMADOR_ID_class", $class);
    // add class for field header as field value
    $xt->assign("BEBEDOR_ID_mastervalue", $viewControls->showDBValue("BEBEDOR_ID", $data, $keylink));
    $format = $settings->getViewFormat("BEBEDOR_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("BEBEDOR_ID"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("BEBEDOR_ID_class", $class);
    // add class for field header as field value
    $xt->assign("FRECUENCIA_EJERCICIO_ID_mastervalue", $viewControls->showDBValue("FRECUENCIA_EJERCICIO_ID", $data, $keylink));
    $format = $settings->getViewFormat("FRECUENCIA_EJERCICIO_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("FRECUENCIA_EJERCICIO_ID"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("FRECUENCIA_EJERCICIO_ID_class", $class);
    // add class for field header as field value
    $xt->assign("SALARIO_ID_mastervalue", $viewControls->showDBValue("SALARIO_ID", $data, $keylink));
    $format = $settings->getViewFormat("SALARIO_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("SALARIO_ID"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("SALARIO_ID_class", $class);
    // add class for field header as field value
    $xt->assign("ALTURA_mastervalue", $viewControls->showDBValue("ALTURA", $data, $keylink));
    $format = $settings->getViewFormat("ALTURA");
    $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("ALTURA"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("ALTURA_class", $class);
    // add class for field header as field value
    $xt->assign("PESO_mastervalue", $viewControls->showDBValue("PESO", $data, $keylink));
    $format = $settings->getViewFormat("PESO");
    $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("PESO"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("PESO_class", $class);
    // add class for field header as field value
    $xt->assign("NUM_HIJOS_mastervalue", $viewControls->showDBValue("NUM_HIJOS", $data, $keylink));
    $format = $settings->getViewFormat("NUM_HIJOS");
    $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("NUM_HIJOS"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("NUM_HIJOS_class", $class);
    // add class for field header as field value
    $xt->assign("QUIERE_HIJOS_mastervalue", $viewControls->showDBValue("QUIERE_HIJOS", $data, $keylink));
    $format = $settings->getViewFormat("QUIERE_HIJOS");
    $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("QUIERE_HIJOS"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("QUIERE_HIJOS_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
    $xt->assign("TIPO_RELACION_ID_mastervalue", $viewControls->showDBValue("TIPO_RELACION_ID", $data, $keylink));
    $format = $settings->getViewFormat("TIPO_RELACION_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("TIPO_RELACION_ID"))) {
        $class = ' rnr-field-number';
    }
    $xt->assign("TIPO_RELACION_ID_class", $class);
    // add class for field header as field value
    $layout = GetPageLayout("GE_PERSONA_DISPONIBLE", 'masterprint');
    if ($layout) {
        $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"');
    }
    $xt->displayPartial(GetTemplateName("GE_PERSONA_DISPONIBLE", "masterprint"));
}