function GetCmpstByGM($var, $gm) { global $tbl_sys_msg, $page_main, $tbl_list_compensate; if ($var["serverindex"] == null || $var["serverindex"] == "") { $js_src = <<<_js_src <script type='text/javascript' src='/js/checkbox.js'></script> <script type='text/javascript' src='/js/page.js'></script> <script type='text/javascript'> function cancel(id) { \tdocument.form1.target = "_block" \tdocument.form1.action_name.value='124'; \tdocument.form1.id.value=id; \tdocument.form1.submit(); } </script> _js_src; echo $js_src . "\n"; echo "<script type='text/javascript' src='/js/log_info.js'></script>\n"; form($var, $gm); echo "<input type='hidden' name='flag' />\n"; echo "<input type='hidden' name='role_name' />\n"; echo "<input type='hidden' name='str' />\n"; echo "<input type='hidden' name='urs' />\n"; echo "<input type='hidden' name='id' />"; checkbox(false, true); ReturnAndBack(); $ret = eachServerFrame($var, $gm); ReturnAndBack(); echo "</form>\n"; return $ret; } $serv_id = intval($var["serverindex"]); $gm_name = mysql_escape_string($gm); $filter = ""; if ($var["flag"] != "" || $var["role_name"] != "") { $filter = " and"; if ($var["flag"] != "") { $filter .= " reason like '%#[" . $var["flag"] . "[%'"; } if ($var["flag"] != "" && $var["role_name"] != "") { $filter .= " and"; } if ($var["role_name"] != "") { $k = $var["role_name"]; $filter .= " (reason like '%[" . $k . ",%' or reason like '%," . $k . "]%' or reason like '%," . $k . ",%' or reason like '%[" . $k . "]%')"; } } $query = "select gca_uId, gm, action_id, reason, action_state from tbl_gm_compensate_action where server_id = '{$serv_id}' and gm = '{$gm_name}'" . $filter . " order by gca_uId desc"; page($var, $query, 123, "GMS", 0, $result, $page, $desc); echo "<table class='list_table'>\n"; echo "<tr><th style='width:60px;'>" . $page_main["user_name"] . "</th><th style='width:160px;'>" . $page_main["event_type"] . "</th><th>" . $tbl_sys_msg["desc"] . "</th><th style='width:60px;'>" . $tbl_sys_msg["act"] . "</th><th style='width:80px;'>" . $tbl_sys_msg["status"] . "</th></tr>\n"; while ($row = mysql_fetch_row($result)) { printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td class='server' title='" . $serv_id . "'>%s</td></tr>", $row[1], GetGMCommandLogAction($row[2]), LogInfo($row[3]), hasAuth(124, $gm) && $row[4] == 1 ? "<input type=button value='" . $tbl_sys_msg["cancel"] . "' onclick='cancel(" . $row[0] . ")'/>" : "", $tbl_list_compensate[$row[4]]); } echo "</table>\n"; echo $page; return true; }
/** * @param Array keys * @param Boolean forLookup * @param String _table * @param String _field * @param String pageType * @return Array */ public function GetAddedDataLookupQuery($keys, $forLookup, $_table, $_field, $pageType) { $lookupMainSettings = getLookupMainTableSettings($this->tName, $_table, $_field, $pageType); if(!$lookupMainSettings) return array(); global $conn; $LookupSQL = ""; $mainField = $_field; $mainTable = $lookupMainSettings->getTableName(); $linkFieldName = $lookupMainSettings->getLinkField($mainField); $dispfield = $lookupMainSettings->getDisplayField($mainField); $nLookupType = $lookupMainSettings->getLookupType($mainField); if($nLookupType == LT_QUERY) { if($lookupMainSettings->getCustomDisplay($mainField)) $this->pSet->getSQLQuery()->AddCustomExpression($dispfield, $this->pSet, $mainTable, $mainField); $lookupQueryObj = $this->pSet->getSQLQuery()->CloneObject(); } else { $LookupSQL = "select "; $LookupSQL .= GetFullFieldName($linkFieldName, $this->tName, true); if($linkFieldName != $dispfield) $LookupSQL .= "," . $this->pSet->getLWDisplayField($mainField, true); $LookupSQL.=" from ".AddTableWrappers($this->strOriginalTableName); } $data = 0; $lookupIndexes = array("linkFieldIndex" => 0, "displayFieldIndex" => 0); if(count($keys)) { $where = KeyWhere($keys); if($nLookupType == LT_QUERY) $LookupSQL = $lookupQueryObj->toSql(whereAdd($lookupQueryObj->m_where->toSql($lookupQueryObj), $where)); else $LookupSQL.=" where ".$where; $lookupIndexes = GetLookupFieldsIndexes($lookupMainSettings, $mainField); LogInfo($LookupSQL); if($forLookup) { $rs=db_query($LookupSQL,$conn); $data = $this->cipherer->DecryptFetchedArray($rs); } else if($LookupSQL) { $rs = db_query($LookupSQL,$conn); $data = db_fetch_numarray($rs); $data[$lookupIndexes["linkFieldIndex"]] = $this->cipherer->DecryptField($linkFieldName, $data[$lookupIndexes["linkFieldIndex"]]); if($nLookupType == LT_QUERY) $data[$lookupIndexes["displayFieldIndex"]] = $this->cipherer->DecryptField($dispfield, $data[$lookupIndexes["displayFieldIndex"]]); } } return array($data, array("linkField" => $linkFieldName, "displayField" => $dispfield , "linkFieldIndex" => $lookupIndexes["linkFieldIndex"], "displayFieldIndex" => $lookupIndexes["displayFieldIndex"])); }
function displayHelp() { LogInfo("You can use script with following switches:\n"); foreach (self::$ACCEPTED[0] as $key => $value) { LogInfo(sprintf(" --%-15s %s", $key, $value)); } foreach (self::$ACCEPTED[1] as $key => $value) { LogInfo(sprintf(" --%-7s%-8s %s", $key, " [param]", $value)); } }
/** * Connect to the data source. * <p>When a fatal log event is not encountered, but FALSE is returned, * it means that the connectiong mechanism has not been implemented for * this given query at a particular level. This behavior is only * expected when calling DataSource::connect() explicitly. * @return bool TRUE is successful, FALSE otherwise. */ function connect() { if ($this->isConnected) { if (IsLogEnabled('DEBUG')) { LogDebug("already connected", $this); } return TRUE; } else { LogInfo("connecting: " . print_r($this, TRUE), $this); register_shutdown_function(array($this, "shutdown")); $this->isConnected = TRUE; return FALSE; } }
/** * Read current values from the database * * @return {array} array of current record data */ function getCurrentRecordInternal() { if (!is_null($this->data)) { return $this->data; } global $conn; $query = $this->gQuery->Copy(); $strWhereClause = KeyWhere($this->keys); $strSQL = $this->gQuery->gSQLWhere($strWhereClause); $strSQLbak = $strSQL; // Before Query event if ($this->eventsObject->exists("BeforeQueryEdit")) { $this->eventsObject->BeforeQueryEdit($strSQL, $strWhereClause, $this); } if ($strSQLbak == $strSQL) { $strSQL = $this->gQuery->gSQLWhere($strWhereClause); } LogInfo($strSQL); $rs = db_query($strSQL, $conn); $this->data = $this->cipherer->DecryptFetchedArray($rs); if (!$this->data && $this->mode == EDIT_SIMPLE) { return $this->data; } foreach ($this->editFields as $fName) { if (@$_POST["a"] != "edited" && $this->pSet->isAutoUpdate($fName) && $this->pSet->getDefaultValue($fName) !== "") { $this->data[$fName] = $this->pSet->getDefaultValue($fName); } } if ($this->readEditValues) { foreach ($this->editFields as $fName) { $editFormat = $this->pSet->getEditFormat($fName); if ($editFormat == EDIT_FORMAT_DATABASE_FILE && $editFormat != EDIT_FORMAT_DATABASE_IMAGE && $editFormat != EDIT_FORMAT_FILE && !$this->pSet->isReadonly($fName)) { $this->data[$fName] = $this->editValues[$fName]; } } } if ($this->eventsObject->exists("ProcessValuesEdit")) { $this->eventsObject->ProcessValuesEdit($this->data, $this); } return $this->data; }
function GetAddedDataLookupQuery($pageObject, $keys, $forLookup) { global $conn, $strTableName, $strOriginalTableName; $LookupSQL = ""; $linkfield = ""; $dispfield = ""; $noBlobReplace = false; $lookupFieldName = ""; if ($LookupSQL && $nLookupType != LT_QUERY) { $LookupSQL .= " from " . AddTableWrappers($strOriginalTableName); } $data = 0; $lookupIndexes = array("linkFieldIndex" => 0, "displayFieldIndex" => 0); if (count($keys)) { $where = KeyWhere($keys); if ($nLookupType == LT_QUERY) { $LookupSQL = $lookupQueryObj->toSql(whereAdd($lookupQueryObj->m_where->toSql($lookupQueryObj), $where)); } else { $LookupSQL .= " where " . $where; } $lookupIndexes = GetLookupFieldsIndexes($lookupPSet, $lookupFieldName); LogInfo($LookupSQL); if ($forLookup) { $rs = db_query($LookupSQL, $conn); $data = $pageObject->cipherer->DecryptFetchedArray($rs); } else { if ($LookupSQL) { $rs = db_query($LookupSQL, $conn); $data = db_fetch_numarray($rs); $data[$lookupIndexes["linkFieldIndex"]] = $pageObject->cipherer->DecryptField($linkFieldName, $data[$lookupIndexes["linkFieldIndex"]]); if ($nLookupType == LT_QUERY) { $data[$lookupIndexes["displayFieldIndex"]] = $pageObject->cipherer->DecryptField($dispfield, $data[$lookupIndexes["displayFieldIndex"]]); } } } } return array($data, array("linkField" => $linkFieldName, "displayField" => $dispfield, "linkFieldIndex" => $lookupIndexes["linkFieldIndex"], "displayFieldIndex" => $lookupIndexes["displayFieldIndex"])); }
/** * Returns a count of the number of messages * @return integer */ function getNumberOfMessages() { $status = imap_status($this->_connection, $this->_server_string, SA_ALL); //get all messages in debug mode so we can reprocess them //DebugEcho($this->_server_string); //DebugDump($status); if ($status) { return $status->messages; } else { LogInfo("Error imap_status did not return a value"); DebugDump($this); return 0; } }
$strSQL .= " " . trim($strOrderBy); $rowcount = false; if ($eventObj->exists("ListGetRowCount")) { $masterKeysReq = array(); for ($i = 0; $i < count($pageObject->detailKeysByM); $i++) { $masterKeysReq[] = $_SESSION[$strTableName . "_masterkey" . ($i + 1)]; } $rowcount = $eventObj->ListGetRowCount($pageObject->searchClauseObj, $_SESSION[$strTableName . "_mastertable"], $masterKeysReq, $selected_recs, $pageObject); } if ($rowcount !== false) { $numrows = $rowcount; } else { $numrows = $gQuery->gSQLRowCount($strWhereClause, $strHavingClause, $strSearchCriteria); } } LogInfo($strSQL); $mypage = (int) $_SESSION[$strTableName . "_pagenumber"]; if (!$mypage) { $mypage = 1; } // page size $PageSize = (int) $_SESSION[$strTableName . "_pagesize"]; if (!$PageSize) { $PageSize = $pageObject->pSet->getInitialPageSize(); } if ($PageSize < 0) { $all = 1; } $recno = 1; $records = 0; $maxpages = 1;
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 GetAllCompensate($var, $gm) { global $page_action_name, $page_main, $tbl_sys_msg, $tbl_game_server; if ($var["serverindex"] == null || $var["serverindex"] == "" and $var["flag"] == "" and $var["role_name"] == "") { $strjs = <<<_strjs <script type="text/javascript" src="/js/page.js"></script> <script type="text/javascript"> function pass(obj,id){ \tdocument.form1.action_name.value='54'; \tdocument.form1.id.value=id; \tdocument.form1.serverid.value = \$(obj).parents(".panel").attr("id").substring(4); \tdocument.form1.target='_block'; \tdocument.form1.submit(); } function cancel(obj,id) { \tdocument.form1.action_name.value='55'; \tdocument.form1.id.value=id; \tdocument.form1.serverid.value = \$(obj).parents(".panel").attr("id").substring(4); \tdocument.form1.target='_block'; \tdocument.form1.submit(); } function pass_all(){ \tdocument.form1.action_name.value='54'; \tdocument.form1.target='_block'; \tdocument.form1.submit(); } function cancel_all(){ \tdocument.form1.action_name.value='55'; \tdocument.form1.target='_block'; \tdocument.form1.submit(); } </script> _strjs; echo $strjs . "\n"; echo "<script type='text/javascript' src='/js/page.js'></script>\n"; echo "<script type='text/javascript' src='/js/log_info.js'></script>\n"; echo "<script type='text/javascript' src='/js/checkbox.js'></script>\n"; form($var, $gm); checkbox(true, true); echo "<input type='hidden' name='flag' />\n"; echo "<input type='hidden' name='role_name' />\n"; echo "<input type='hidden' name='str' />\n"; echo "<input type='hidden' name='urs' />\n"; echo "<input type='hidden' name='id'/>\n"; $ret = eachServerFrame($var, $gm); ReturnAndBack(); echo "</form>\n"; return $ret; } else { $serv_id = intval($var["serverindex"]); } $filter = ""; if ($var["flag"] != "" || $var["role_name"] != "") { $filter = " and"; if ($var["flag"] != "") { $filter .= " reason like '%#[" . $var["flag"] . "[%'"; } if ($var["flag"] != "" && $var["role_name"] != "") { $filter .= " and"; } if ($var["role_name"] != "") { $k = $var["role_name"]; $filter .= " (reason like '%[" . $k . ",%' or reason like '%," . $k . "]%' or reason like '%," . $k . ",%' or reason like '%[" . $k . "]%')"; } } $query_string = "select gca_uId, gm, action_id, reason from tbl_gm_compensate_action where action_state = 1 and server_id = '{$serv_id}'" . $filter . " order by gca_uId desc"; page($var, $query_string, 53, "GMS", 0, $result, $page, $desc); echo "<table class='list_table'>\n"; echo "<tr><th style='width:60px;'>" . $page_main["user_name"] . "</th><th style='width:120px;'>" . $page_main["event_type"] . "</th><th>" . $tbl_sys_msg["desc"] . "</th><th style='width:120px;'>" . $tbl_sys_msg["act"] . "</th><th>" . $tbl_sys_msg["server"] . "</th></tr>\n"; while ($row = mysql_fetch_row($result)) { printf("<tr><td align='center'>%s</td><td><input type='checkbox' name='ids[]' value='%d_%d'/>%s</td><td>%s</td><td align='center'>%s%s</td><td>%s</td></tr>\n", $row[1], $row[0], $serv_id, GetGMCommandLogAction($row[2]), LogInfo($row[3]), hasAuth(54, $gm) ? "<input type=button value='" . $tbl_sys_msg["pass"] . "' onclick='pass(this," . $row[0] . ")'/>" : "", hasAuth(55, $gm) ? "<input type=button value='" . $tbl_sys_msg["cancel"] . "' onclick='cancel(this," . $row[0] . ")'/>" : "", $tbl_game_server[$serv_id][2]); } echo "</table>\n"; echo "<table class='list_table'>\n"; echo "<tr><td>"; if (HasAuth(54, $gm)) { echo "<input type='button' onclick='pass_all()' value='" . $page_action_name[54] . "' />"; } if (HasAuth(55, $gm)) { echo "<input type='button' onclick='cancel_all()' value='" . $page_action_name[55] . "' />"; } echo "</td></tr>\n"; echo "</table>\n"; echo $page; return true; }
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; }
<?php // try to connect to server with different protocols/ and userids require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . "postie-functions.php"; include_once dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . "wp-config.php"; require_once "postie-functions.php"; $config = config_Read(); extract($config); $title = __("Postie Diagnosis"); $parent_file = 'options-general.php?page=postie/postie.php'; get_currentuserinfo(); if (!current_user_can('manage_options')) { LogInfo("non-admin tried to set options"); echo "<h2> Sorry only admin can run this file</h2>"; exit; } DebugEcho("Error log: " . ini_get('error_log')); ?> <div class="wrap"> <h1>Postie Configuration Test</h1> <?php if (isMarkdownInstalled()) { EchoInfo("You currently have the Markdown plugin installed. It will cause problems if you send in HTML email. Please turn it off if you intend to send email using HTML."); } if (!isPostieInCorrectDirectory()) { EchoInfo("Warning! Postie expects to be in its own directory named postie."); } else { EchoInfo("Postie is in " . dirname(__FILE__)); } if (defined('ALTERNATE_WP_CRON') && ALTERNATE_WP_CRON) { EchoInfo("Alternate cron is enabled");
/** * Read current values from the database * @return Array The current record data */ public function getCurrentRecordInternal() { if (!is_null($this->data)) { return $this->data; } $strWhereClause = ""; $orderClause = ""; $keysSet = $this->checkKeysSet(); if ($keysSet) { $strWhereClause = KeyWhere($this->keys); } elseif ($this->mode == VIEW_DASHBOARD) { $whereComponents = $this->getWhereComponents(); $strWhereClause = $whereComponents["searchWhere"]; } else { $orderClause = $this->getOrderByClause(); $strWhereClause = $_SESSION[$this->sessionPrefix . "_where"]; } if ($this->pSet->getAdvancedSecurityType() != ADVSECURITY_ALL) { $strWhereClause = whereAdd($strWhereClause, SecuritySQL("Search", $this->tName)); } $strSQL = $this->gQuery->gSQLWhere($strWhereClause); if (!$keysSet) { $strSQL = applyDBrecordLimit($strSQL . $orderClause, 1, $this->connection->dbType); } $strSQLbak = $strSQL; $strWhereClauseBak = $strWhereClause; if ($this->eventsObject->exists("BeforeQueryView")) { $this->eventsObject->BeforeQueryView($strSQL, $strWhereClause, $this); } if ($strSQLbak == $strSQL && $strWhereClauseBak != $strWhereClause) { // user didn't change the query string but changed $strWhereClause $strSQL = $this->gQuery->gSQLWhere($strWhereClause); if (!$keysSet) { $strSQL = applyDBrecordLimit($strSQL . $orderClause, 1, $this->connection->dbType); } } LogInfo($strSQL); $fetchedArray = $this->connection->query($strSQL)->fetchAssoc(); $this->data = $this->cipherer->DecryptFetchedArray($fetchedArray); if (!$keysSet) { $this->keys = $this->getKeysFromData($this->data); $this->setKeysForJs(); } if (sizeof($this->data) && $this->eventsObject->exists("ProcessValuesView")) { $this->eventsObject->ProcessValuesView($this->data, $this); } return $this->data; }
/** * @intellisense * @param RunnerPage pageObj * @param String strSQL * @param &Array blobs */ function ExecuteUpdate(&$pageObj, $strSQL, &$blobs) { $blobTypes = array(); if ($pageObj->connection->dbType == nDATABASE_Informix) { foreach ($blobs as $fieldname => $fieldvalue) { $blobTypes[$fieldname] = $pageObj->pSet->getFieldType($fieldname); } } LogInfo($strSQL); if (!$pageObj->connection->execWithBlobProcessing($strSQL, $blobs, $blobTypes)) { $pageObj->setDatabaseError($pageObj->connection->lastError()); return false; } return true; }
function GetBackEquipFun($var, $gm) { $attr = $var["attr"]; $item_type = intval($var["item_type"]); $server_id = intval($var["serverid"]); $role_name = $var["role_name"]; $reason = $var["reason"]; $attr_array = explode(";", $attr); $temp = explode(",", $attr_array[0]); $item_name = $temp[0]; $item_type = $temp[1]; $item_id = $temp[2]; $param = array(); $param["role_name"] = $role_name; $param["item_name"] = UTF82Local($item_name); $param["item_type"] = $item_type; SetParamInfo($param, explode(",", $attr_array[1]), "St"); SetParamInfo($param, explode(",", $attr_array[2]), "SA"); SetParamInfo($param, explode(",", $attr_array[3]), "Ad"); SetParamInfo($param, explode(",", $attr_array[4]), "Ar1"); SetParamInfo($param, explode(",", $attr_array[5]), "Ar2"); SetParamInfo($param, explode(",", $attr_array[6]), "Ar3"); SetParamInfo($param, explode(",", $attr_array[7]), "Ar4"); SetParamInfo($param, explode(",", $attr_array[8]), "In"); SetParamInfo($param, explode(",", $attr_array[9]), "IAA"); SetParamInfo($param, explode(",", $attr_array[10]), "Du"); SetParamInfo($param, explode(",", $attr_array[11]), "Bd"); SetParamInfo($param, explode(",", $attr_array[12]), "Su"); global $tbl_game_server; $gas_host = $tbl_game_server[$server_id][0]; $gas_port = $tbl_game_server[$server_id][1]; $ret = PostData($gas_host, $gas_port, "GetBackEquip", $param); $action = array("role_name" => $role_name, "type" => $item_type, "item" => $item_name, "item_id" => $item_id, "reason" => $reason); if (intval($ret) != 200) { PrintNotice(LogInfo($action, false, $ret)); BackAndRefresh($tbl_sys_msg["success"]); return true; } if (LogGMCommand($gm, $var["action_name"], $action, $server_id)) { PrintNotice(LogInfo($action, true)); BackAndRefresh($tbl_sys_msg["success"]); return true; } return false; }
/** * Returns a count of the number of messages * @return integer */ function getNumberOfMessages() { $status = imap_status($this->_connection, $this->_mailbox, SA_ALL); DebugDump($status); if ($status) { return max($status->messages, imap_num_msg($this->_connection)); } else { LogInfo("Error imap_status did not return a value"); //DebugDump($this); return 0; } }
function WriteFragment($download, &$opt) { $this->frags[$download['id']] = $download; $available = count($this->frags); for ($i = 0; $i < $available; $i++) { if (isset($this->frags[$this->lastFrag + 1])) { $frag = $this->frags[$this->lastFrag + 1]; if ($frag['response'] !== false) { LogDebug("Writing fragment " . $frag['id'] . " to flv file"); if (!isset($opt['file'])) { $opt['debug'] = false; if ($this->play) { $outFile = STDOUT; } else { if ($this->outFile) { if ($opt['filesize']) { $outFile = JoinUrl($this->outDir, $this->outFile . '-' . $this->fileCount++ . ".flv"); } else { $outFile = JoinUrl($this->outDir, $this->outFile . ".flv"); } } else { if ($opt['filesize']) { $outFile = JoinUrl($this->outDir, $this->baseFilename . '-' . $this->fileCount++ . ".flv"); } else { $outFile = JoinUrl($this->outDir, $this->baseFilename . ".flv"); } } } $this->InitDecoder(); $this->DecodeFragment($frag['response'], $frag['id'], $opt); $opt['file'] = WriteFlvFile($outFile, $this->audio, $this->video); if ($this->metadata) { WriteMetadata($this, $opt['file']); } $opt['debug'] = $this->debug; $this->InitDecoder(); } $flvData = $this->DecodeFragment($frag['response'], $frag['id'], $opt); if (strlen($flvData)) { $status = fwrite($opt['file'], $flvData, strlen($flvData)); if (!$status) { LogError("Failed to write flv data"); } if (!$this->play) { $this->filesize = ftell($opt['file']) / (1024 * 1024); } } $this->lastFrag = $frag['id']; } else { $this->lastFrag += 1; LogDebug("Skipping failed fragment " . $this->lastFrag); } unset($this->frags[$this->lastFrag]); } else { break; } if ($opt['tDuration'] and $opt['duration'] + $this->duration >= $opt['tDuration']) { LogInfo(""); LogInfo($opt['duration'] + $this->duration . " seconds of content has been recorded successfully.", true); return STOP_PROCESSING; } if ($opt['filesize'] and $this->filesize >= $opt['filesize']) { $this->filesize = 0; $opt['duration'] += $this->duration; fclose($opt['file']); unset($opt['file']); } } if (!count($this->frags)) { unset($this->frags); } return true; }
function DisplayMasterTableInfo_Customers($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "dbo.Customers"; //$strSQL = "SELECT ID, Name, [Father Name], Address, Contact, Location, [Customer Type] FROM dbo.Customers"; $sqlHead = "SELECT ID, Name, [Father Name], Address, Contact, Location, [Customer Type]"; $sqlFrom = "FROM dbo.Customers"; $sqlWhere = ""; $sqlTail = ""; $where = ""; $mKeys = array(); $showKeys = ""; global $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterlist", "BoldOrange", "MobileOrange"); $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["Customers_masterlist"] = $layout; if ($detailtable == "dbo.Customer Module Assignment") { $where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]); $showKeys .= " " . GetFieldLabel("dbo_Customers", "ID") . ": " . $keys[1 - 1]; $xt->assign('showKeys', $showKeys); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Search"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($sqlWhere, $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $sqlHead . ' ' . $sqlFrom . $strWhere . $sqlTail; // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = db_fetch_array($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["ID"])); // ID - $value = ""; $value = ProcessLargeText(GetData($data, "ID", ""), "field=ID" . $keylink); $xt->assign("ID_mastervalue", $value); // Name - $value = ""; $value = ProcessLargeText(GetData($data, "Name", ""), "field=Name" . $keylink); $xt->assign("Name_mastervalue", $value); // Father Name - $value = ""; $value = ProcessLargeText(GetData($data, "Father Name", ""), "field=Father+Name" . $keylink); $xt->assign("Father_Name_mastervalue", $value); // Address - $value = ""; $value = ProcessLargeText(GetData($data, "Address", ""), "field=Address" . $keylink); $xt->assign("Address_mastervalue", $value); // Contact - $value = ""; $value = ProcessLargeText(GetData($data, "Contact", ""), "field=Contact" . $keylink); $xt->assign("Contact_mastervalue", $value); // Location - $value = ""; $value = DisplayLookupWizard("Location", $data["Location"], $data, $keylink, MODE_LIST); $xt->assign("Location_mastervalue", $value); // Customer Type - $value = ""; $value = DisplayLookupWizard("Customer Type", $data["Customer Type"], $data, $keylink, MODE_LIST); $xt->assign("Customer_Type_mastervalue", $value); $xt->display("Customers_masterlist.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; }
/** * Builds SQL query, for retrieve data from DB * */ function buildSQL() { $this->gstrOrderBy = $this->gQuery->OrderByToSql(); $this->gsqlHead = $this->gQuery->HeadToSql(); $this->gsqlFrom = $this->gQuery->FromToSql(); $this->gsqlWhereExpr = $this->gQuery->WhereToSql(); $this->gsqlGroupBy = $this->gQuery->GroupByToSql(); $this->gsqlHaving = $this->gQuery->Having()->toSql($gQuery); $agregateFields = $this->pSet->getListOfFieldsByExprType(true); $this->searchClauseObj->haveAgregateFields = count($agregateFields) > 0; $searchWhereClause = $this->searchClauseObj->getWhere($this->pSet->getListOfFieldsByExprType(false), $this->controls); $searchHavingClause = $this->searchClauseObj->getWhere($agregateFields, $this->controls); $this->strWhereClause = whereAdd($this->strWhereClause, $searchWhereClause); $this->strHavingClause = whereAdd($this->strHavingClause, $searchHavingClause); $strSecuritySql = SecuritySQL("Search", $this->tName); $this->strWhereClause = whereAdd($this->strWhereClause, $strSecuritySql); if ($this->noRecordsFirstPage && !count($_GET) && !count($_POST)) { $this->strWhereClause = whereAdd($this->strWhereClause, "1=0"); } //add where clause with foreign keys of current table and it's master table master keys $where = $this->addWhereWithMasterTable(); $this->strWhereClause = whereAdd($this->strWhereClause, $where); if ($this->dbType == nDATABASE_DB2) { $this->gsqlHead .= ", ROW_NUMBER() over () as DB2_ROW_NUMBER "; } $this->strSearchCriteria = postvalue('criteria'); if ($this->searchClauseObj->isUsedSearchFor && !$this->searchClauseObj->isUsedFieldsForSearch) { $this->strSearchCriteria = "or"; } $strSQL = SQLQuery::gSQLWhere_having($this->gsqlHead, $this->gsqlFrom, $this->gsqlWhereExpr, $this->gsqlGroupBy, $this->gsqlHaving, $this->strWhereClause, $this->strHavingClause, $this->strSearchCriteria); // order by $strSQL .= " " . trim($this->strOrderBy); // save SQL for use in "Export" and "Printer-friendly" pages $_SESSION[$this->sessionPrefix . "_sql"] = $strSQL; $_SESSION[$this->sessionPrefix . "_where"] = $this->strWhereClause; $_SESSION[$this->sessionPrefix . "_having"] = $this->strHavingClause; $_SESSION[$this->sessionPrefix . "_criteria"] = $this->strSearchCriteria; $_SESSION[$this->sessionPrefix . "_order"] = $this->strOrderBy; // select and display records $this->addMasterDetailSubQuery(); $strSQLbak = $strSQL; if ($this->eventExists("BeforeQueryList")) { $tstrWhereClause = $this->strWhereClause; $tstrOrderBy = $this->strOrderBy; $this->eventsObject->BeforeQueryList($strSQL, $tstrWhereClause, $tstrOrderBy, $this); $this->strWhereClause = $tstrWhereClause; $this->strOrderBy = $tstrOrderBy; } // Rebuild SQL if needed if ($strSQL != $strSQLbak) { // changed $strSQL - old style $this->numRowsFromSQL = GetRowCount($strSQL); } else { $strSQL = SQLQuery::gSQLWhere_having($this->gsqlHead, $this->gsqlFrom, $this->gsqlWhereExpr, $this->gsqlGroupBy, $this->gsqlHaving, $this->strWhereClause, $this->strHavingClause, $this->strSearchCriteria); $strSQL .= " " . trim($this->strOrderBy); $rowcount = false; if ($this->eventExists("ListGetRowCount")) { $rowcount = $this->eventsObject->ListGetRowCount($this->searchClauseObj, $this->masterTable, $this->masterKeysReq, null, $this); } if ($rowcount !== false) { $this->numRowsFromSQL = $rowcount; } else { $this->numRowsFromSQL = SQLQuery::gSQLRowCount_int($this->gsqlHead, $this->gsqlFrom, $this->gsqlWhereExpr, $this->gsqlGroupBy, $this->gsqlHaving, $this->strWhereClause, $this->strHavingClause, $this->strSearchCriteria); } } LogInfo($strSQL); $this->querySQL = $strSQL; }
function DisplayMasterTableInfo_Module($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "dbo.Module"; //$strSQL = "SELECT ID, [Module Type], [Module Status], [Module Condition], [Serial Num], [Entry Date] FROM dbo.[Module]"; $sqlHead = "SELECT ID, [Module Type], [Module Status], [Module Condition], [Serial Num], [Entry Date]"; $sqlFrom = "FROM dbo.[Module]"; $sqlWhere = ""; $sqlTail = ""; $where = ""; global $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterprint", "BoldOrange", "MobileOrange"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["Module_masterprint"] = $layout; if ($detailtable == "dbo.Anomalies") { $where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]); } if ($detailtable == "dbo.Customer Module Assignment") { $where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]); } if ($detailtable == "dbo.Readings") { $where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Export"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($sqlWhere, $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $sqlHead . ' ' . $sqlFrom . $strWhere . $sqlTail; // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = db_fetch_array($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["ID"])); // ID - $value = ""; $value = ProcessLargeText(GetData($data, "ID", ""), "field=ID" . $keylink, "", MODE_PRINT); $xt->assign("ID_mastervalue", $value); // Module Type - $value = ""; $value = DisplayLookupWizard("Module Type", $data["Module Type"], $data, $keylink, MODE_PRINT); $xt->assign("Module_Type_mastervalue", $value); // Module Status - $value = ""; $value = DisplayLookupWizard("Module Status", $data["Module Status"], $data, $keylink, MODE_PRINT); $xt->assign("Module_Status_mastervalue", $value); // Module Condition - $value = ""; $value = DisplayLookupWizard("Module Condition", $data["Module Condition"], $data, $keylink, MODE_PRINT); $xt->assign("Module_Condition_mastervalue", $value); // Serial Num - $value = ""; $value = ProcessLargeText(GetData($data, "Serial Num", ""), "field=Serial+Num" . $keylink, "", MODE_PRINT); $xt->assign("Serial_Num_mastervalue", $value); // Entry Date - Short Date $value = ""; $value = ProcessLargeText(GetData($data, "Entry Date", "Short Date"), "field=Entry+Date" . $keylink, "", MODE_PRINT); $xt->assign("Entry_Date_mastervalue", $value); $xt->display("Module_masterprint.htm"); $strTableName = $oldTableName; }
/** * @param Boolean forLookup * @param String mainTableShortName * @param String mainField * @param String pageType * @return Array */ protected function GetAddedDataLookupQuery($forLookup, $mainTableShortName, $mainField, $pageType) { $lookupMainSettings = getLookupMainTableSettings($this->tName, $mainTableShortName, $mainField, $pageType); if (!$lookupMainSettings) { return array(); } $LookupSQL = ""; $mainTable = $lookupMainSettings->getTableName(); $linkFieldName = $lookupMainSettings->getLinkField($mainField); $dispfield = $lookupMainSettings->getDisplayField($mainField); if ($lookupMainSettings->getCustomDisplay($mainField)) { $this->pSet->getSQLQuery()->AddCustomExpression($dispfield, $this->pSet, $mainTable, $mainField); } $lookupQueryObj = $this->pSet->getSQLQuery()->CloneObject(); $data = array(); $lookupIndexes = array("linkFieldIndex" => 0, "displayFieldIndex" => 0); if (count($this->keys)) { $where = KeyWhere($this->keys); $LookupSQL = $lookupQueryObj->toSql(whereAdd($lookupQueryObj->m_where->toSql($lookupQueryObj), $where)); $lookupIndexes = GetLookupFieldsIndexes($lookupMainSettings, $mainField); LogInfo($LookupSQL); if ($forLookup) { $data = $this->cipherer->DecryptFetchedArray($this->connection->query($LookupSQL)->fetchAssoc()); } else { if ($LookupSQL) { $data = $this->connection->query($LookupSQL)->fetchNumeric(); $data[$lookupIndexes["linkFieldIndex"]] = $this->cipherer->DecryptField($linkFieldName, $data[$lookupIndexes["linkFieldIndex"]]); $data[$lookupIndexes["displayFieldIndex"]] = $this->cipherer->DecryptField($dispfield, $data[$lookupIndexes["displayFieldIndex"]]); } } } return array($data, array("linkField" => $linkFieldName, "displayField" => $dispfield, "linkFieldIndex" => $lookupIndexes["linkFieldIndex"], "displayFieldIndex" => $lookupIndexes["displayFieldIndex"])); }
function DisplayMasterTableInfo_GE_ESTADO_CIVIL($params) { global $cman; $detailtable = $params["detailtable"]; $keys = $params["keys"]; $xt = new Xtempl(); $tName = "GE.ESTADO_CIVIL"; $settings = new ProjectSettings($tName, PAGE_LIST); $cipherer = new RunnerCipherer($tName); $connection = $cman->byTable($tName); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_LIST); $where = ""; $keysAssoc = array(); $showKeys = ""; if ($detailtable == "GE.PERSONA_DISPONIBLE") { $keysAssoc["ESTADO_CIVIL_ID"] = $keys[1 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("ESTADO_CIVIL_ID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ESTADO_CIVIL_ID", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("ESTADO_CIVIL_ID", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_ESTADO_CIVIL", "ESTADO_CIVIL_ID") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if (!$where) { return; } $str = SecuritySQL("Search"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->WhereToSql(), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); LogInfo($strSQL); $data = $cipherer->DecryptFetchedArray($connection->query($strSQL)->fetchAssoc()); if (!$data) { return; } // reassign pagetitlelabel function adding extra params $xt->assign_function("pagetitlelabel", "xt_pagetitlelabel", array("record" => $data, "settings" => $settings)); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["ESTADO_CIVIL_ID"])); $xt->assign("ESTADO_CIVIL_ID_mastervalue", $viewControls->showDBValue("ESTADO_CIVIL_ID", $data, $keylink)); $format = $settings->getViewFormat("ESTADO_CIVIL_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("ESTADO_CIVIL_ID"))) { $class = ' rnr-field-number'; } $xt->assign("ESTADO_CIVIL_ID_class", $class); // add class for field header as field value $xt->assign("NOMBRE_mastervalue", $viewControls->showDBValue("NOMBRE", $data, $keylink)); $format = $settings->getViewFormat("NOMBRE"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("NOMBRE"))) { $class = ' rnr-field-number'; } $xt->assign("NOMBRE_class", $class); // add class for field header as field value $xt->assign("FEC_CREACION_mastervalue", $viewControls->showDBValue("FEC_CREACION", $data, $keylink)); $format = $settings->getViewFormat("FEC_CREACION"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FEC_CREACION"))) { $class = ' rnr-field-number'; } $xt->assign("FEC_CREACION_class", $class); // add class for field header as field value $xt->assign("USUARIO_CREACION_mastervalue", $viewControls->showDBValue("USUARIO_CREACION", $data, $keylink)); $format = $settings->getViewFormat("USUARIO_CREACION"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("USUARIO_CREACION"))) { $class = ' rnr-field-number'; } $xt->assign("USUARIO_CREACION_class", $class); // add class for field header as field value $xt->assign("FEC_ULTIMA_MOD_mastervalue", $viewControls->showDBValue("FEC_ULTIMA_MOD", $data, $keylink)); $format = $settings->getViewFormat("FEC_ULTIMA_MOD"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FEC_ULTIMA_MOD"))) { $class = ' rnr-field-number'; } $xt->assign("FEC_ULTIMA_MOD_class", $class); // add class for field header as field value $xt->assign("USUARIO_ULTIMA_MOD_mastervalue", $viewControls->showDBValue("USUARIO_ULTIMA_MOD", $data, $keylink)); $format = $settings->getViewFormat("USUARIO_ULTIMA_MOD"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("USUARIO_ULTIMA_MOD"))) { $class = ' rnr-field-number'; } $xt->assign("USUARIO_ULTIMA_MOD_class", $class); // add class for field header as field value $layout = GetPageLayout("GE_ESTADO_CIVIL", 'masterlist'); if ($layout) { $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"'); } $xt->displayPartial(GetTemplateName("GE_ESTADO_CIVIL", "masterlist")); }
function DisplayMasterTableInfo_LU_Anomaly_Type($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "dbo.LU_Anomaly Type"; //$strSQL = "SELECT Code, [Tamper Type] FROM dbo.[LU_Anomaly Type]"; $sqlHead = "SELECT Code, [Tamper Type]"; $sqlFrom = "FROM dbo.[LU_Anomaly Type]"; $sqlWhere = ""; $sqlTail = ""; $where = ""; global $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterprint", "BoldOrange", "MobileOrange"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["LU_Anomaly_Type_masterprint"] = $layout; if ($detailtable == "dbo.Anomalies") { $where .= GetFullFieldName("Code") . "=" . make_db_value("Code", $keys[1 - 1]); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Export"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($sqlWhere, $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $sqlHead . ' ' . $sqlFrom . $strWhere . $sqlTail; // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = db_fetch_array($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["Code"])); // Code - $value = ""; $value = ProcessLargeText(GetData($data, "Code", ""), "field=Code" . $keylink, "", MODE_PRINT); $xt->assign("Code_mastervalue", $value); // Tamper Type - $value = ""; $value = ProcessLargeText(GetData($data, "Tamper Type", ""), "field=Tamper+Type" . $keylink, "", MODE_PRINT); $xt->assign("Tamper_Type_mastervalue", $value); $xt->display("LU_Anomaly_Type_masterprint.htm"); $strTableName = $oldTableName; }
function DisplayMasterTableInfo_BranchMaster($params) { global $cman; $detailtable = $params["detailtable"]; $keys = $params["keys"]; $xt = new Xtempl(); $tName = "BranchMaster"; $xt->eventsObject = getEventObject($tName); $settings = new ProjectSettings($tName, PAGE_LIST); $cipherer = new RunnerCipherer($tName); $connection = $cman->byTable($tName); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_LIST); $where = ""; $keysAssoc = array(); $showKeys = ""; if ($detailtable == "Fact_SalesTransaction") { $keysAssoc["GroupID"] = $keys[1 - 1]; $keysAssoc["CompanyID"] = $keys[2 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("GroupID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("GroupID", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("GroupID", $keysAssoc); $showKeys .= " " . GetFieldLabel("BranchMaster", "GroupID") . ": " . $keyValue; $where .= " and "; $showKeys .= " , "; $where .= RunnerPage::_getFieldSQLDecrypt("CompanyID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("CompanyID", $keys[2 - 1], "", true); $keyValue = $viewControls->showDBValue("CompanyID", $keysAssoc); $showKeys .= " " . GetFieldLabel("BranchMaster", "CompanyID") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if (!$where) { return; } $str = SecuritySQL("Search", $tName); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->WhereToSql(), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); LogInfo($strSQL); $data = $cipherer->DecryptFetchedArray($connection->query($strSQL)->fetchAssoc()); if (!$data) { return; } // reassign pagetitlelabel function adding extra params $xt->assign_function("pagetitlelabel", "xt_pagetitlelabel", array("record" => $data, "settings" => $settings)); $keylink = ""; $xt->assign("BranchCloudFolder_mastervalue", $viewControls->showDBValue("BranchCloudFolder", $data, $keylink)); $format = $settings->getViewFormat("BranchCloudFolder"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("BranchCloudFolder"))) { $class = ' rnr-field-number'; } $xt->assign("BranchCloudFolder_class", $class); // add class for field header as field value $xt->assign("BranchLastSyncDate_mastervalue", $viewControls->showDBValue("BranchLastSyncDate", $data, $keylink)); $format = $settings->getViewFormat("BranchLastSyncDate"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("BranchLastSyncDate"))) { $class = ' rnr-field-number'; } $xt->assign("BranchLastSyncDate_class", $class); // add class for field header as field value $xt->assign("l_mastervalue", $viewControls->showDBValue("l", $data, $keylink)); $format = $settings->getViewFormat("l"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("l"))) { $class = ' rnr-field-number'; } $xt->assign("l_class", $class); // add class for field header as field value $layout = GetPageLayout("BranchMaster", 'masterlist'); if ($layout) { $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"'); } $xt->displayPartial(GetTemplateName("BranchMaster", "masterlist")); }
/** * Read current values from the database * * @return {array} array of current record data */ function getCurrentRecordInternal() { if (!is_null($this->data)) return $this->data; global $gstrOrderBy, $conn; $strWhereClause = ''; $strHavingClause = ''; if(!$this->all) { $strWhereClause = KeyWhere($this->keys); if($this->pSet->getAdvancedSecurityType()!=ADVSECURITY_ALL) $strWhereClause = whereAdd($strWhereClause, SecuritySQL("Search")); $strSQL = $this->gQuery->gSQLWhere($strWhereClause); } else { if ($_SESSION[$this->tName."_SelectedSQL"]!="" && @$_REQUEST["records"]=="") { $strSQL = $_SESSION[$this->tName."_SelectedSQL"]; $strWhereClause=@$_SESSION[$this->tName."_SelectedWhere"]; } else { $strWhereClause = @$_SESSION[$this->tName."_where"]; $strHavingClause = @$_SESSION[$this->tName."_having"]; $strSearchCriteria = @$_SESSION[$this->tName."_criteria"]; $joinFromPart = @$_SESSION[$this->tName."_joinFromPart"]; if($this->pSet->getAdvancedSecurityType()==ADVSECURITY_VIEW_OWN && $strWhereClause=="") $strWhereClause = whereAdd($strWhereClause, SecuritySQL("Search")); //$strSQL = $this->gQuery->gSQLWhere($strWhereClause, $strHavingClause, $strSearchCriteria); $strSQL = SQLQuery::gSQLWhere_having($this->gQuery->HeadToSql(), $this->gQuery->FromToSql().$joinFromPart, $this->gQuery->WhereToSql(), $this->gQuery->GroupByToSql(), $this->gQuery->Having()->toSql($this->gQuery), $strWhereClause, $strHavingClause, $strSearchCriteria); } // order by $strOrderBy = $_SESSION[$this->tName."_order"]; if(!$strOrderBy) $strOrderBy = $gstrOrderBy; $strSQL.=" ".trim($strOrderBy); } $strSQLbak = $strSQL; if($this->eventsObject->exists("BeforeQueryView")) $this->eventsObject->BeforeQueryView($strSQL, $strWhereClause, $this); if($strSQLbak == $strSQL) { //$strSQL = $this->gQuery->gSQLWhere($strWhereClause, $strHavingClause); $strSQL = SQLQuery::gSQLWhere_having($this->gQuery->HeadToSql(), $this->gQuery->FromToSql().$joinFromPart, $this->gQuery->WhereToSql(), $this->gQuery->GroupByToSql(), $this->gQuery->Having()->toSql($this->gQuery), $strWhereClause, $strHavingClause, $strSearchCriteria); if($this->all) { $numrows = $this->gQuery->gSQLRowCount($strWhereClause, $strHavingClause, $strSearchCriteria); $strSQL.=" ".trim($strOrderBy); } } else { // changed $strSQL - old style if($this->all) $numrows = GetRowCount($strSQL); } if(!$this->all) { LogInfo($strSQL); $rs = db_query($strSQL, $conn); } else { // Pagination: $nPageSize = 0; if(@$_REQUEST["records"]=="page" && $numrows) { $mypage = (integer)@$_SESSION[$this->tName."_pagenumber"]; $nPageSize = (integer)@$_SESSION[$this->tName."_pagesize"]; if($numrows <= ($mypage-1)*$nPageSize) $mypage = ceil($numrows/$nPageSize); if(!$nPageSize) $nPageSize = $gPageSize; if(!$mypage) $mypage = 1; $strSQL.=" limit ".(($mypage-1)*$nPageSize).",".$nPageSize; } $rs = db_query($strSQL,$conn); } $this->data = $this->cipherer->DecryptFetchedArray($rs); if(sizeof($this->data) && $this->eventsObject->exists("ProcessValuesView")) $this->eventsObject->ProcessValuesView($this->data, $this); return $this->data; }
/** * This method sorts thru the mime parts of the message. It is looking for files labeled - "applefile" - current * this part of the file attachment is not supported * @param object */ function filter_AppleFile(&$mimeDecodedEmail) { $newParts = array(); $found = false; for ($i = 0; $i < count($mimeDecodedEmail->parts); $i++) { if ($mimeDecodedEmail->parts[$i]->ctype_secondary == "applefile") { $found = true; LogInfo("Removing 'applefile'"); } else { $newParts[] = $mimeDecodedEmail->parts[$i]; } } if ($found && $newParts) { $mimeDecodedEmail->parts = $newParts; //This is now the filtered list of just the preferred type. } }
if ($summary[0]["sgs"]) { // global totals $globaltotals_count = 0; $globaltotals_min = array(); $globaltotals_max = array(); $globaltotals_dispmin = array(); $globaltotals_dispmax = array(); $globaltotals_sum = array(); foreach ($rpt_array['totals'] as $fld){ if ($fld['show']) { $globaltotals_sum[fldname($fld)] = 0; } } } echo LogInfo($strSQL); $rs = db_query($strSQL, $conn); $start = true; $align_skip = false; $groupstart = array(); for ($i = 0; $i < count($rpt_array['group_fields']) - 1; $i++){ $arr = $rpt_array['group_fields'][$i]; $groupstart[$arr['name']] = 0; $groupvalue[$arr['name']] = ""; }
/** * Read current values from the database * * @return {array} array of current record data */ function getCurrentRecordInternal() { if (!is_null($this->data)) { return $this->data; } global $gstrOrderBy, $conn; $strWhereClause = ''; $strHavingClause = ''; if (!$this->all) { // show one record only $this->setKeys(); $strWhereClause = KeyWhere($this->keys); $strSQL = $this->gQuery->gSQLWhere($strWhereClause); } else { if ($_SESSION[$this->tName . "_SelectedSQL"] != "" && @$_REQUEST["records"] == "") { $strSQL = $_SESSION[$this->tName . "_SelectedSQL"]; $strWhereClause = @$_SESSION[$this->tName . "_SelectedWhere"]; } else { $strWhereClause = @$_SESSION[$this->tName . "_where"]; $strHavingClause = @$_SESSION[$this->tName . "_having"]; $strSearchCriteria = @$_SESSION[$this->tName . "_criteria"]; $strSQL = $this->gQuery->gSQLWhere($strWhereClause, $strHavingClause, $strSearchCriteria); } // order by $strOrderBy = $_SESSION[$this->tName . "_order"]; if (!$strOrderBy) { $strOrderBy = $gstrOrderBy; } $strSQL .= " " . trim($strOrderBy); } $strSQLbak = $strSQL; if ($this->eventsObject->exists("BeforeQueryView")) { $this->eventsObject->BeforeQueryView($strSQL, $strWhereClause, $this); } if ($strSQLbak == $strSQL) { $strSQL = $this->gQuery->gSQLWhere($strWhereClause, $strHavingClause); if ($this->all) { $numrows = $this->gQuery->gSQLRowCount($strWhereClause, $strHavingClause, $strSearchCriteria); $strSQL .= " " . trim($strOrderBy); } } else { // changed $strSQL - old style if ($this->all) { $numrows = GetRowCount($strSQL); } } if (!$this->all) { LogInfo($strSQL); $rs = db_query($strSQL, $conn); } else { // Pagination: $nPageSize = 0; if (@$_REQUEST["records"] == "page" && $numrows) { $mypage = (int) @$_SESSION[$this->tName . "_pagenumber"]; $nPageSize = (int) @$_SESSION[$this->tName . "_pagesize"]; if ($numrows <= ($mypage - 1) * $nPageSize) { $mypage = ceil($numrows / $nPageSize); } if (!$nPageSize) { $nPageSize = $gPageSize; } if (!$mypage) { $mypage = 1; } $maxrecs = $nPageSize; $strSQL .= " limit " . $nPageSize . " offset " . ($mypage - 1) * $nPageSize; } $rs = db_query($strSQL, $conn); } $this->data = $this->cipherer->DecryptFetchedArray($rs); if (sizeof($this->data) && $this->eventsObject->exists("ProcessValuesView")) { $this->eventsObject->ProcessValuesView($this->data, $this); } return $this->data; }
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; }