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;
}
