/**
* Login method
* @param String pUsername
* @param String pPassword
*/
function LogIn($pUsername, $pPassword)
{
// username and password are stored in the database
global $cUserNameFieldType, $cPasswordFieldType, $cUserNameField, $cPasswordField, $cDisplayNameField;
$logged = false;
$strUsername = (string) $pUsername;
$strPassword = (string) $pPassword;
$loginSet = ProjectSettings::getForLogin();
$cipherer = RunnerCipherer::getForLogin($loginSet);
$sUsername = $strUsername;
$sPassword = $strPassword;
if ($cipherer->isFieldEncrypted($cUserNameField)) {
$strUsername = $cipherer->MakeDBValue($cUserNameField, $strUsername, "", true);
} else {
if (NeedQuotes($cUserNameFieldType)) {
$strUsername = $this->connection->prepareString($strUsername);
} else {
$strUsername = 0 + $strUsername;
}
}
if ($cipherer->isFieldEncrypted($cPasswordField)) {
$strPassword = $cipherer->MakeDBValue($cPasswordField, $strPassword, "", true);
} else {
if (NeedQuotes($cPasswordFieldType)) {
$strPassword = $this->connection->prepareString($strPassword);
} else {
$strPassword = 0 + $strPassword;
}
}
if ($loginSet) {
if (!$this->pSet->isCaseInsensitiveUsername()) {
$where = $this->getFieldSQLDecrypt($cUserNameField) . "=" . $strUsername . " and " . $this->getFieldSQLDecrypt($cPasswordField) . "=" . $strPassword;
} else {
$where = $this->connection->upper($this->getFieldSQLDecrypt($cUserNameField)) . "=" . $this->pSet->getCaseSensitiveUsername($strUsername) . " and " . $this->getFieldSQLDecrypt($cPasswordField) . "=" . $strPassword;
}
$tempSQLQuery = $loginSet->GetTableData(".sqlquery");
$tempSQLQuery->addWhere($where);
$strSQL = $tempSQLQuery->toSql();
} else {
$strSQL = "select * from " . $this->connection->addTableWrappers("DashboardUsers") . " where " . $this->connection->addFieldWrappers($cUserNameField) . "=" . $strUsername . " and " . $this->connection->addFieldWrappers($cPasswordField) . "=" . $strPassword;
}
$data = $cipherer->DecryptFetchedArray($this->connection->query($strSQL)->fetchAssoc());
if ($data) {
if ($this->pSet->getCaseSensitiveUsername(@$data[$cUserNameField]) == $this->pSet->getCaseSensitiveUsername($sUsername) && @$data[$cPasswordField] == $sPassword) {
$logged = true;
$pDisplayUsername = $data[$cDisplayNameField] != '' ? $data[$cDisplayNameField] : $sUsername;
}
}
if ($logged && $this->isCaptchaOk) {
DoLogin(false, $pUsername, $pDisplayUsername, "", ACCESS_LEVEL_USER, $pPassword, $this);
SetAuthSessionData($pUsername, $data, $this->fromFacebook, $pPassword, $this);
return true;
}
if ($this->auditObj) {
$this->auditObj->LogLoginFailed($pUsername);
$this->auditObj->LoginUnsuccessful($pUsername);
}
return false;
}
function suggestValue($value, $searchFor, &$response, &$row)
{
if (!GetGlobalData("handleSearchSuggestInLookup", true)) {
parent::suggestValue($value, $searchFor, $response, $row);
return;
}
global $conn;
$lookupSQL = buildLookupSQL($this->lookupPageType, $this->field, $this->pageObject->tName, "", $value, false, true, false, true, true, true);
$this->fillLookupFieldsIndexes();
$rs_lookup = db_query($lookupSQL, $conn);
if ($data = db_fetch_numarray($rs_lookup)) {
if ($this->isDisplayFieldEncrypted) {
$lookup_value = $this->ciphererDisplay->DecryptField($this->lookupType == LT_QUERY ? $this->displayFieldName : $this->field, $data[$this->displayFieldIndex]);
} else {
$lookup_value = $data[$this->displayFieldIndex];
}
parent::suggestValue($lookup_value, $searchFor, $response, $row);
}
}
/**
* Get for the dependent lookup an array containing the link field values with even indices
* and the corresponding displayed values with odd indices
*
* @intellisense
* @param String parentVal
* @param String childVal
* @param Boolean doCategoryFilter
* @param Boolean initialLoad
* @return Array
*/
public function loadLookupContent($parentVal, $childVal = "", $doCategoryFilter = true, $initialLoad = true)
{
$response = array();
$pSet = $this->pageObject->pSetEdit;
if ($this->bUseCategory && $doCategoryFilter) {
if ($this->lookupType == LT_QUERY) {
$tempParentVal = $this->ciphererDisplay->MakeDBValue($pSet->getCategoryControl($this->field), $parentVal, "", true);
} else {
$tempParentVal = make_db_value($this->field, $parentVal);
}
if ($tempParentVal === "null" || 0 == strlen($parentVal)) {
return $response;
}
}
$LookupSQL = $this->getLookupSQL($parentVal, $childVal, $doCategoryFilter, $this->LCType == LCT_AJAX && $initialLoad);
$lookupIndexes = GetLookupFieldsIndexes($pSet, $this->field);
$qResult = $this->lookupConnection->query($LookupSQL);
if ($this->LCType !== LCT_AJAX || $this->multiselect) {
$isUnique = $pSet->isLookupUnique($this->field);
while ($data = $qResult->fetchNumeric()) {
if ($this->lookupType == LT_QUERY && $isUnique) {
if (!isset($uniqueArray)) {
$uniqueArray = array();
}
if (in_array($data[$lookupIndexes["displayFieldIndex"]], $uniqueArray)) {
continue;
}
$uniqueArray[] = $data[$lookupIndexes["displayFieldIndex"]];
}
$response[] = $data[$lookupIndexes["linkFieldIndex"]];
$response[] = $data[$lookupIndexes["displayFieldIndex"]];
}
} else {
$data = $qResult->fetchNumeric();
// one record only
if ($data && (strlen($childVal) || !$qResult->fetchNumeric())) {
$response[] = $data[$lookupIndexes["linkFieldIndex"]];
$response[] = $data[$lookupIndexes["displayFieldIndex"]];
}
}
return $response;
}
/**
* construct SQL WHERE clause for Advanced search
* @intellisense
*/
function StrWhereAdv($strField, $SearchFor, $strSearchOption, $SearchFor2, $etype, $isSuggest)
{
global $strTableName;
$pSet = new ProjectSettings($strTableName, PAGE_SEARCH);
$cipherer = new RunnerCipherer($strTableName);
$type = $pSet->getFieldType($strField);
$isOracle = false;
$ismssql=false;
$isdb2=false;
$btexttype=IsTextType($type);
$btexttype=false;
$isMysql = true;
if(IsBinaryType($type))
return "";
if($strSearchOption=='Empty')
{
if(IsCharType($type) && (!$ismssql || !$btexttype) && !$isOracle)
{
return "(".GetFullFieldNameForInsert($pSet, $strField)." is null or ".GetFullFieldNameForInsert($pSet, $strField)."='')";
}
elseif ($ismssql && $btexttype)
{
return "(".GetFullFieldNameForInsert($pSet, $strField)." is null or ".GetFullFieldNameForInsert($pSet, $strField)." LIKE '')";
}
else
{
return GetFullFieldNameForInsert($pSet, $strField)." is null";
}
}
$like="like";
if($pSet->getEditFormat($strField) == EDIT_FORMAT_LOOKUP_WIZARD)
{
if($pSet->multiSelect($strField))
$SearchFor=splitvalues($SearchFor);
else
$SearchFor=array($SearchFor);
$ret="";
foreach($SearchFor as $searchValue)
{
$value = $searchValue;
if(!($value=="null" || $value=="Null" || $value==""))
{
if(strlen($ret))
$ret.=" or ";
if($strSearchOption=="Equals")
{
$value=make_db_value($strField,$value);
if(!($value=="null" || $value=="Null"))
$ret.=GetFullFieldName($strField, "", false).'='.$value;
}
elseif($isSuggest)
{
$ret.=" ".GetFullFieldName($strField, "", false)." ".$like." ".db_prepare_string('%'.$value.'%');
}
else
{
if(strpos($value,",")!==false || strpos($value,'"')!==false)
$value = '"'.str_replace('"','""',$value).'"';
if ($isMysql)
{
$value = str_replace('\\\\', '\\\\\\\\', $value);
}
//for search by multiply Lookup wizard field
$ret.=GetFullFieldName($strField, "", false)." = ".db_prepare_string($value);
$ret.=" or ".GetFullFieldName($strField, "", false)." ".$like." ".db_prepare_string("%,".$value.",%");
$ret.=" or ".GetFullFieldName($strField, "", false)." ".$like." ".db_prepare_string("%,".$value);
$ret.=" or ".GetFullFieldName($strField, "", false)." ".$like." ".db_prepare_string($value.",%");
}
}
}
if(strlen($ret))
$ret="(".$ret.")";
return $ret;
}
if($pSet->getEditFormat($strField) == EDIT_FORMAT_CHECKBOX)
{
if($SearchFor=="none")
return "";
if(NeedQuotes($type))
{
$isOracle = false;
if($SearchFor=="on")
{
$whereStr = "(".GetFullFieldName($strField)."<>'0' ";
if (!$isOracle)
{
$whereStr .= " and ".GetFullFieldName($strField)."<>'' ";
}
$whereStr .= " and ".GetFullFieldName($strField)." is not null)";
return $whereStr;
}
elseif($SearchFor=="off")
{
$whereStr = "(".GetFullFieldName($strField)."='0' ";
if (!$isOracle)
{
$whereStr .= " or ".GetFullFieldName($strField)."='' ";
}
$whereStr .= " or ".GetFullFieldName($strField)." is null)";
}
}
else
{
if($SearchFor=="on")
{
return "(".GetFullFieldName($strField)."<>0 and ".GetFullFieldName($strField)." is not null)";
}
elseif($SearchFor=="off")
{
return "(".GetFullFieldName($strField)."=0 or ".GetFullFieldName($strField)." is null)";
}
}
}
$value1 = $cipherer->MakeDBValue($strField, $SearchFor, $etype, "", true);
$value2 = false;
$cleanvalue2 = false;
if($strSearchOption == "Between")
{
$cleanvalue2 = prepare_for_db($strField,$SearchFor2,$etype);
$value2 = make_db_value($strField,$SearchFor2,$etype);
}
if($strSearchOption!="Contains" && $strSearchOption!="Starts with" && ($value1==="null" || $value2==="null" )
&& !$cipherer->isFieldPHPEncrypted($strField))
return "";
if(IsCharType($type) && !$btexttype)
{
if(!$cipherer->isFieldPHPEncrypted($strField))
{
$value1 = $pSet->isEnableUpper($value1);
$value2 = $pSet->isEnableUpper($value2);
$gstrField = $pSet->isEnableUpper(GetFullFieldName($strField, "", false));
}
else
$gstrField = GetFullFieldName($strField, "", false);
}
elseif($strSearchOption=="Contains" || $strSearchOption=="Starts with")
{
$gstrField = db_field2char(GetFullFieldName($strField, "", false),$type);
}
elseif($pSet->getViewFormat($strField)==FORMAT_TIME)
{
$gstrField = db_field2time(GetFullFieldName($strField, "", false),$type);
}
else
{
$gstrField = GetFullFieldName($strField, "", false);
}
$ret="";
if($strSearchOption=="Contains")
{
if ($isMysql)
{
$SearchFor = str_replace('\\\\', '\\\\\\\\', $SearchFor);
}
if($cipherer->isFieldPHPEncrypted($strField))
return $gstrField."=".$cipherer->MakeDBValue($strField, $SearchFor);
if(IsCharType($type) && !$btexttype)
return $gstrField." ".$like." ".$pSet->isEnableUpper(db_prepare_string("%".$SearchFor."%"));
else
return $gstrField." ".$like." ".db_prepare_string("%".$SearchFor."%");
}
else if($strSearchOption=="Equals")
{
return $gstrField."=".$value1;
}
else if($strSearchOption=="Starts with")
{
if ($isMysql)
{
$SearchFor = str_replace('\\\\', '\\\\\\\\', $SearchFor);
}
if(IsCharType($type) && !$btexttype)
return $gstrField." ".$like." ".$pSet->isEnableUpper(db_prepare_string($SearchFor."%"));
else
return $gstrField." ".$like." ".db_prepare_string($SearchFor."%");
}
else if($strSearchOption=="More than") return $gstrField.">".$value1;
else if($strSearchOption=="Less than") return $gstrField."<".$value1;
else if($strSearchOption=="Equal or more than") return $gstrField.">=".$value1;
else if($strSearchOption=="Equal or less than") return $gstrField."<=".$value1;
else if($strSearchOption=="Between")
{
$ret=$gstrField.">=".$value1." and ";
if (IsDateFieldType($type))
{
$timeArr = db2time($cleanvalue2);
// for dates without time, add one day
if ($timeArr[3]==0 && $timeArr[4]==0 && $timeArr[5]==0)
{
$timeArr = adddays($timeArr, 1);
$value2 = $timeArr[0]."-".$timeArr[1]."-".$timeArr[2];
$value2 = add_db_quotes($strField, $value2, $strTableName);
$ret .= $gstrField."<".$value2;
}
else
{
$ret.=$gstrField."<=".$value2;
}
}
else
{
$ret.=$gstrField."<=".$value2;
}
return $ret;
}
return "";
}
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_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;
}
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;
}
<?php
@ini_set("display_errors","1");
@ini_set("display_startup_errors","1");
include("include/dbcommon.php");
include('classes/remindpwdpage.php');
include('include/xtempl.php');
require_once(getabspath("classes/cipherer.php"));
$reminded = false;
$sentMailResults = array();
$cipherer = new RunnerCipherer("webreport_users");
$xt = new Xtempl();
$sessPrefix = 'remind';
$id = postvalue("id")!=="" ? postvalue("id") : 1;
$cEmailField = "email";
$layout = new TLayout("remind2", "BoldOrange", "MobileOrange");
$layout->version = 2;
$layout->blocks["top"] = array();
$layout->containers["remind"] = array();
$layout->containers["remind"][] = array("name"=>"remindheader",
"block"=>"remindheader", "substyle"=>2 );
$layout->containers["remind"][] = array("name"=>"message",
"block"=>"message_block", "substyle"=>1 );
<?php
@ini_set("display_errors", "1");
@ini_set("display_startup_errors", "1");
require_once "include/dbcommon.php";
require_once "include/DashboardUsers_variables.php";
require_once getabspath("classes/cipherer.php");
require_once "classes/registerpage.php";
$regCipherer = new RunnerCipherer($strTableName);
$registered = false;
//event for onsubmit
$strMessage = "";
$allow_registration = true;
$strUsername = "";
$strPassword = "";
$strEmail = "";
$sentMailResults = array();
$values = array();
$keys = array();
$id = postvalue("id") != "" ? postvalue("id") : 1;
require_once 'include/xtempl.php';
$isNeedSettings = true;
$xt = new Xtempl();
$layout = new TLayout("register_basic_left", "CityBlueWave", "MobileBlueWave");
$layout->version = 2;
$layout->blocks["top"] = array();
$layout->containers["fields"] = array();
$layout->container_properties["fields"] = array();
$layout->containers["fields"][] = array("name" => "regheader", "block" => "regheader", "substyle" => 2);
$layout->containers["fields"][] = array("name" => "message", "block" => "message_block", "substyle" => 1);
$layout->containers["fields"][] = array("name" => "regfields_simple", "block" => "", "substyle" => 1);
if ($pageType != PAGE_REGISTER && (!isLogged() || !CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Search"))) {
$returnJSON = array("success" => false, "error" => "Error: You have not permissions to read the " . $tableName . " table's data");
echo printJSON($returnJSON);
return;
}
// set db connection
$_connection = $cman->byTable($strTableName);
$pSet = new ProjectSettings($strTableName, $pageType);
$denyChecking = $pSet->allowDuplicateValues($fieldName);
$denyChecking = $denyChecking && ($strTableName != "DashboardUsers" || $fieldName != $cUserNameField && $fieldName != $cEmailField);
if ($denyChecking) {
$returnJSON = array("success" => false, "error" => "Duplicated values are allowed");
echo printJSON($returnJSON);
return;
}
$cipherer = new RunnerCipherer($strTableName, $pSet);
if ($cipherer->isFieldEncrypted($fieldName)) {
$value = $cipherer->MakeDBValue($fieldName, $value, $fieldControlType, true);
} else {
$value = make_db_value($fieldName, $value, $fieldControlType, "", $strTableName);
}
if ($value == "null") {
$fieldSQL = RunnerPage::_getFieldSQL($fieldName, $_connection, $pSet);
} else {
$fieldSQL = RunnerPage::_getFieldSQLDecrypt($fieldName, $_connection, $pSet, $cipherer);
}
$where = $fieldSQL . ($value == "null" ? ' is ' : '=') . $value;
$sql = "SELECT count(*) from " . $_connection->addTableWrappers($pSet->getOriginalTableName()) . " where " . $where;
$qResult = $_connection->query($sql);
if (!$qResult || !($data = $qResult->fetchNumeric())) {
$returnJSON = array("success" => false, "error" => "Error: Wrong SQL query");
/**
* 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 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;
}
header("Expires: Thu, 01 Jan 1970 00:00:01 GMT");
$table = postvalue("table");
$pageType = postvalue("table");
$strTableName = GetTableByShort($table);
if (!checkTableName($table)) {
exit(0);
}
include "include/" . $table . "_variables.php";
$gSettings = new ProjectSettings($strTableName, $pageType);
$field = postvalue('searchField');
$value = postvalue('searchFor');
$lookupValue = postvalue('lookupValue');
$LookupSQL = "";
$response = array();
$output = "";
$cipherer = new RunnerCipherer($strTableName);
$strLoginTable = "";
if ($strTableName != $strLoginTable) {
if (!isLogged()) {
return;
}
if (!CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Edit") && !CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Add") && !CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Search")) {
return;
}
} else {
$checkResult = true;
if ($checkResult) {
if (!isLogged()) {
return;
}
if (!CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Edit") && !CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Add") && !CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Search")) {
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;
}
$returnJSON = array("success" => false, "error" => "Error: You have not permissions to read the ".$tableName." table's data");
echo "<div>".printJSON($returnJSON)."</div>";
return;
}
$pSet = new ProjectSettings(GetTableByShort($tableName), $pageType);
$denyChecking = $pSet->allowDuplicateValues( $fieldName );
if( $denyChecking )
{
$returnJSON = array("success" => false, "error" => "Duplicated values are allowed");
echo "<div>".printJSON($returnJSON)."</div>";
return;
}
$cipherer = new RunnerCipherer($tableName, $pSet);
if( $cipherer->isFieldEncrypted($fieldName) )
$value = $cipherer->MakeDBValue($fieldName, $value, $fieldControlType, "", true);
else
$value = make_db_value($fieldName, $value, $fieldControlType, "", $tableName);
$where = GetFullFieldName($fieldName, $tableName, false).( $value == "null" ? ' is ' : '=' ).$value;
$sql = "SELECT count(*) from ".AddTableWrappers( $pSet->getOriginalTableName() )." where ".$where;
$rs = db_query($sql, $conn);
if( !$rs || !($data = db_fetch_numarray($rs)) )
{
$returnJSON = array("success" => false, "error" => "Error: Wrong SQL query");
echo "<div>".printJSON($returnJSON)."</div>";
return;
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;
}
protected function assignCipherer()
{
$this->cipherer = RunnerCipherer::getForLogin();
}
/**
* DEPRECATED. Use RunnerPage::keysSQLExpression instead
* Construct WHERE clause with key values
*
* @param &Array $keys
* @param String $table Teh data source table name OPTIONAL
*
* @return String
* @intellisense
* @deprecated
*/
function KeyWhere(&$keys, $table = "")
{
global $strTableName, $cman;
if (!$table) {
$table = $strTableName;
}
$strWhere = "";
$pSet = new ProjectSettings($table);
$cipherer = new RunnerCipherer($table);
$connection = $cman->byTable($table);
$keyFields = $pSet->getTableKeys();
foreach ($keyFields as $kf) {
if (strlen($strWhere)) {
$strWhere .= " and ";
}
$value = $cipherer->MakeDBValue($kf, $keys[$kf], "", true);
if ($connection->dbType == nDATABASE_Oracle) {
$valueisnull = $value === "null" || $value == "''";
} else {
$valueisnull = $value === "null";
}
if ($valueisnull) {
$strWhere .= RunnerPage::_getFieldSQL($kf, $connection, $pSet) . " is null";
} else {
$strWhere .= RunnerPage::_getFieldSQLDecrypt($kf, $connection, $pSet, $cipherer) . "=" . $cipherer->MakeDBValue($kf, $keys[$kf], "", true);
}
}
return $strWhere;
}
<?php
@ini_set("display_errors", "1");
@ini_set("display_startup_errors", "1");
require_once "include/dbcommon.php";
header("Expires: Thu, 01 Jan 1970 00:00:01 GMT");
require_once "include/StockMaster_variables.php";
$mode = postvalue("mode");
require_once "classes/searchclause.php";
$cipherer = new RunnerCipherer($strTableName);
require_once 'include/xtempl.php';
$xt = new Xtempl();
$layout = new TLayout("detailspreview", "CityBlueWave", "MobileBlueWave");
$layout->version = 2;
$layout->blocks["bare"] = array();
$layout->containers["dcount"] = array();
$layout->container_properties["dcount"] = array();
$layout->containers["dcount"][] = array("name" => "detailspreviewheader", "block" => "", "substyle" => 1);
$layout->containers["dcount"][] = array("name" => "detailspreviewdetailsfount", "block" => "", "substyle" => 1);
$layout->containers["dcount"][] = array("name" => "detailspreviewdispfirst", "block" => "display_first", "substyle" => 1);
$layout->skins["dcount"] = "empty";
$layout->blocks["bare"][] = "dcount";
$layout->containers["detailspreviewgrid"] = array();
$layout->container_properties["detailspreviewgrid"] = array();
$layout->containers["detailspreviewgrid"][] = array("name" => "detailspreviewfields", "block" => "details_data", "substyle" => 1);
$layout->skins["detailspreviewgrid"] = "grid";
$layout->blocks["bare"][] = "detailspreviewgrid";
$page_layouts["StockMaster_detailspreview"] = $layout;
$layout->skinsparams = array();
$layout->skinsparams["empty"] = array("button" => "button1");
$layout->skinsparams["menu"] = array("button" => "button1");
<?php
@ini_set("display_errors", "1");
@ini_set("display_startup_errors", "1");
require_once "include/dbcommon.php";
require_once 'classes/remindpwdpage.php';
require_once 'include/xtempl.php';
require_once getabspath("classes/cipherer.php");
$reminded = false;
$sentMailResults = array();
$cipherer = RunnerCipherer::getForLogin();
$xt = new Xtempl();
$sessPrefix = 'remind';
$id = postvalue("id") !== "" ? postvalue("id") : 1;
$cEmailField = "email";
$layout = new TLayout("remind5", "CityBlueWave", "MobileBlueWave");
$layout->version = 2;
$layout->blocks["top"] = array();
$layout->containers["fields"] = array();
$layout->container_properties["fields"] = array();
$layout->containers["fields"][] = array("name" => "remindheader", "block" => "remindheader", "substyle" => 2);
$layout->containers["fields"][] = array("name" => "message", "block" => "message_block", "substyle" => 1);
$layout->containers["fields"][] = array("name" => "remindfields", "block" => "", "substyle" => 1);
$layout->containers["fields"][] = array("name" => "remindbuttons", "block" => "remindbuttons", "substyle" => 2);
$layout->skins["fields"] = "fields";
$layout->blocks["top"][] = "fields";
$page_layouts["remind"] = $layout;
$layout->skinsparams = array();
$layout->skinsparams["empty"] = array("button" => "button1");
$layout->skinsparams["menu"] = array("button" => "button1");
$layout->skinsparams["hmenu"] = array("button" => "button1");
<?php
@ini_set("display_errors", "1");
@ini_set("display_startup_errors", "1");
require_once "include/dbcommon.php";
require_once "include/ConsolidatedStockEnquiry_users_variables.php";
require_once getabspath("classes/cipherer.php");
require_once "classes/registerpage.php";
$regCipherer = new RunnerCipherer($strTableName);
$registered = false;
//event for onsubmit
$strMessage = "";
$allow_registration = true;
$strUsername = "";
$strPassword = "";
$strEmail = "";
$sentMailResults = array();
$values = array();
$keys = array();
$id = postvalue("id") != "" ? postvalue("id") : 1;
require_once 'include/xtempl.php';
$isNeedSettings = true;
$xt = new Xtempl();
$layout = new TLayout("register2", "CityBlueWave", "MobileBlueWave");
$layout->version = 2;
$layout->blocks["top"] = array();
$layout->containers["register"] = array();
$layout->container_properties["register"] = array();
$layout->containers["register"][] = array("name" => "regheader", "block" => "regheader", "substyle" => 2);
$layout->containers["register"][] = array("name" => "message", "block" => "message_block", "substyle" => 1);
$layout->containers["register"][] = array("name" => "wrapper", "block" => "", "substyle" => 1, "container" => "fields");
/**
* Use for count details recs number, if subQueryes not supported, or keys have different types
*
* @param integer $i
* @param array $detailid
* @intellisense
*/
function countDetailsRecsNoSubQ($dInd, &$detailid)
{
global $tables_data, $masterTablesData, $detailsTablesData, $allDetailsTablesArr, $cman;
$dDataSourceTable = $this->allDetailsTablesArr[$dInd]['dDataSourceTable'];
$detPSet = $this->pSet->getTable($dDataSourceTable);
$detCipherer = new RunnerCipherer($dDataSourceTable, $detPSet);
$detConnection = $cman->byTable($dDataSourceTable);
$detailsQuery = $detPSet->getSQLQuery();
$dSqlWhere = $detailsQuery->WhereToSql();
$detailKeys = $detPSet->getDetailKeysByMasterTable($this->tName);
$securityClause = SecuritySQL("Search", $dDataSourceTable);
// add where
if (strlen($securityClause)) {
$dSqlWhere = whereAdd($dSqlWhere, $securityClause);
}
$masterwhere = "";
foreach ($this->masterKeysByD[$dInd] as $idx => $val) {
if ($masterwhere) {
$masterwhere .= " and ";
}
$mastervalue = $detCipherer->MakeDBValue($detailKeys[$idx], $detailid[$idx], "", true);
if ($mastervalue == "null") {
$masterwhere .= RunnerPage::_getFieldSQL($detailKeys[$idx], $detConnection, $detPSet) . " is NULL ";
} else {
$masterwhere .= RunnerPage::_getFieldSQLDecrypt($detailKeys[$idx], $detConnection, $detPSet, $detCipherer) . "=" . $mastervalue;
}
}
return SQLQuery::gSQLRowCount_int($detailsQuery->HeadToSql(), $detailsQuery->FromToSql(), $dSqlWhere, $detailsQuery->GroupByToSql(), $detailsQuery->Having()->toSql($detailsQuery), $masterwhere, "", $detConnection);
}
$lookupConnection = $cman->byTable($lookupTable);
} 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);
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;
}
$mode = postvalue("mode");
$table = postvalue("table");
$field = postvalue("field");
$pageType = postvalue('pagetype');
$mainTable = postvalue("maintable");
$mainField = postvalue("mainfield");
$lookup = false;
if ($mainTable && $mainField) {
$lookup = true;
}
if (!checkTableName($table)) {
exit(0);
}
require_once "include/" . $table . "_variables.php";
$pSet = new ProjectSettings(GetTableByShort($table), $pageType);
$cipherer = new RunnerCipherer(GetTableByShort($table), $pSet);
$_connection = $cman->byTable($strTableName);
if (!$pSet->checkFieldPermissions($field)) {
$returnJSON = array("success" => false, "error" => 'Error: You have not permission for read this text');
echo printJSON($returnJSON);
return;
}
if (!$gQuery->HasGroupBy()) {
// Do not select any fields except current (full text) field.
// If query has 'group by' clause then other fields are used in it and we may not simply cut 'em off.
// Just don't do anything in that case.
$gQuery->RemoveAllFieldsExcept($pSet->getFieldIndex($field));
}
$keysArr = $pSet->getTableKeys();
$keys = array();
foreach ($keysArr as $ind => $k) {
}
$strWhereClause = KeyWhere($keys);
$queryObj = $pSet->getQueryObject();
if ($queryObj->HasGroupBy()) {
// Do not select any fields except current (file) field.
// If query has 'group by' clause then other fields are used in it and we may not simply cut 'em off.
// Just don't do anything in that case.
$queryObj->RemoveAllFieldsExcept($pSet->getFieldIndex($field));
}
$rs = db_query($queryObj->gSQLWhere($strWhereClause), $conn);
if ($isDBFile) {
if ($rs && ($data = db_fetch_array($rs))) {
$value = db_stripslashesbinary($data[$field]);
}
} else {
$cipherer = new RunnerCipherer($strTableName, $pSet);
$row = $cipherer->DecryptFetchedArray($rs);
if (!is_null($row)) {
$filesArray = my_json_decode($row[$field]);
if (!is_array($filesArray) || count($filesArray) == 0) {
if ($row[$field] == "") {
$filesArray = array();
} else {
$uploadedFile = $upload_handler->get_file_object($row[$field]);
if (is_null($uploadedFile)) {
$filesArray = array();
} else {
$filesArray = array(my_json_decode(my_json_encode($uploadedFile)));
}
}
}
$response = array();
$searchOpt = postvalue("start") ? "Starts with" : "Contains";
$searchField = GoodFieldName(postvalue('searchField'));
$strSecuritySql = SecuritySQL("Search", $strTableName);
$numberOfSuggests = GetGlobalData("searchSuggestsNumber", 10);
$pSet = new ProjectSettings($strTableName, PAGE_SEARCH);
if ($searchField == "") {
$allSearchFields = $pSet->getGoogleLikeFields();
} else {
// array of fields which were added in wizard for search
$allSearchFields = $pSet->getAllSearchFields();
}
require_once getabspath('classes/controls/EditControlsContainer.php');
$detailKeys = array();
$masterWhere = "";
$cipherer = new RunnerCipherer($strTableName);
$controls = new EditControlsContainer(null, $pSet, PAGE_LIST, $cipherer);
if (@$_SESSION[$strTableName . "_mastertable"] != "") {
$masterTablesInfoArr = $pSet->getMasterTablesArr($strTableName);
for ($i = 0; $i < count($masterTablesInfoArr); $i++) {
if ($_SESSION[$strTableName . "_mastertable"] != $masterTablesInfoArr[$i]['mDataSourceTable']) {
continue;
}
if ($masterTablesInfoArr[$i]['dispInfo']) {
$detailKeys = $masterTablesInfoArr[$i]['detailKeys'];
for ($j = 0; $j < count($detailKeys); $j++) {
$masterWhere .= " and " . $controls->getControl($detailKeys[$j])->getSuggestWhere('Equals', @$_SESSION[$strTableName . "_masterkey" . ($j + 1)]);
}
}
break;
}
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;
}
<?php
@ini_set("display_errors", "1");
@ini_set("display_startup_errors", "1");
include "include/dbcommon.php";
header("Expires: Thu, 01 Jan 1970 00:00:01 GMT");
include "include/pad_pad_customer_variables.php";
$mode = postvalue("mode");
if (!isLogged()) {
return;
}
if (!CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Search")) {
return;
}
$cipherer = new RunnerCipherer($strTableName);
include 'include/xtempl.php';
$xt = new Xtempl();
$layout = new TLayout("detailspreview", "RoundedGreen", "MobileGreen");
$layout->blocks["bare"] = array();
$layout->containers["dcount"] = array();
$layout->containers["dcount"][] = array("name" => "detailspreviewheader", "block" => "", "substyle" => 1);
$layout->containers["dcount"][] = array("name" => "detailspreviewdetailsfount", "block" => "", "substyle" => 1);
$layout->containers["dcount"][] = array("name" => "detailspreviewdispfirst", "block" => "display_first", "substyle" => 1);
$layout->skins["dcount"] = "empty";
$layout->blocks["bare"][] = "dcount";
$layout->containers["detailspreviewgrid"] = array();
$layout->containers["detailspreviewgrid"][] = array("name" => "detailspreviewfields", "block" => "details_data", "substyle" => 1);
$layout->skins["detailspreviewgrid"] = "grid";
$layout->blocks["bare"][] = "detailspreviewgrid";
$page_layouts["pad_pad_customer_detailspreview"] = $layout;
$recordsCounter = 0;
function loadSelectContent($pageType, $childFieldName, $parentVal, $doCategoryFilter = true, $childVal = "", $initialLoad = true)
{
global $conn, $LookupSQL, $strTableName;
$pSet = new ProjectSettings($strTableName, $pageType);
$response = array();
$lookupType = $pSet->getLookupType($childFieldName);
$isUnique = $pSet->isLookupUnique($childFieldName);
if ($pSet->useCategory($childFieldName) && $doCategoryFilter) {
if ($lookupType == LT_QUERY) {
$lookupTable = $pSet->getLookupTable($childFieldName);
$cipherer = new RunnerCipherer($lookupTable);
$tempParentVal = $cipherer->MakeDBValue($pSet->getCategoryControl($childFieldName), $parentVal, "", $lookupTable, true);
} else {
$tempParentVal = make_db_value($childFieldName, $parentVal);
}
if ($tempParentVal === "null") {
return $response;
}
}
$LookupSQL = buildLookupSQL($pageType, $childFieldName, $strTableName, $parentVal, $childVal, $doCategoryFilter, $pSet->fastType($childFieldName) && $initialLoad);
$lookupIndexes = GetLookupFieldsIndexes($pSet, $childFieldName);
$rs = db_query($LookupSQL, $conn);
if (!$pSet->fastType($childFieldName)) {
while ($data = db_fetch_numarray($rs)) {
if ($lookupType == LT_QUERY && $isUnique) {
if (!isset($uniqueArray)) {
$uniqueArray = array();
}
if (in_array($data[$lookupIndexes["displayFieldIndex"]], $uniqueArray)) {
continue;
}
$uniqueArray[] = $data[$lookupIndexes["displayFieldIndex"]];
}
$response[] = $data[$lookupIndexes["linkFieldIndex"]];
$response[] = $data[$lookupIndexes["displayFieldIndex"]];
}
} else {
$data = db_fetch_numarray($rs);
// one record only
if ($data && (strlen($childVal) || !db_fetch_numarray($rs))) {
$response[] = $data[$lookupIndexes["linkFieldIndex"]];
$response[] = $data[$lookupIndexes["displayFieldIndex"]];
}
}
return $response;
}
