function DisplayMasterTableInfo_GE_ESTADO_CIVIL($params) { global $cman; $detailtable = $params["detailtable"]; $keys = $params["keys"]; $xt = new Xtempl(); $tName = "GE.ESTADO_CIVIL"; $settings = new ProjectSettings($tName, PAGE_LIST); $cipherer = new RunnerCipherer($tName); $connection = $cman->byTable($tName); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_LIST); $where = ""; $keysAssoc = array(); $showKeys = ""; if ($detailtable == "GE.PERSONA_DISPONIBLE") { $keysAssoc["ESTADO_CIVIL_ID"] = $keys[1 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("ESTADO_CIVIL_ID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ESTADO_CIVIL_ID", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("ESTADO_CIVIL_ID", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_ESTADO_CIVIL", "ESTADO_CIVIL_ID") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if (!$where) { return; } $str = SecuritySQL("Search"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->WhereToSql(), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); LogInfo($strSQL); $data = $cipherer->DecryptFetchedArray($connection->query($strSQL)->fetchAssoc()); if (!$data) { return; } // reassign pagetitlelabel function adding extra params $xt->assign_function("pagetitlelabel", "xt_pagetitlelabel", array("record" => $data, "settings" => $settings)); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["ESTADO_CIVIL_ID"])); $xt->assign("ESTADO_CIVIL_ID_mastervalue", $viewControls->showDBValue("ESTADO_CIVIL_ID", $data, $keylink)); $format = $settings->getViewFormat("ESTADO_CIVIL_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("ESTADO_CIVIL_ID"))) { $class = ' rnr-field-number'; } $xt->assign("ESTADO_CIVIL_ID_class", $class); // add class for field header as field value $xt->assign("NOMBRE_mastervalue", $viewControls->showDBValue("NOMBRE", $data, $keylink)); $format = $settings->getViewFormat("NOMBRE"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("NOMBRE"))) { $class = ' rnr-field-number'; } $xt->assign("NOMBRE_class", $class); // add class for field header as field value $xt->assign("FEC_CREACION_mastervalue", $viewControls->showDBValue("FEC_CREACION", $data, $keylink)); $format = $settings->getViewFormat("FEC_CREACION"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FEC_CREACION"))) { $class = ' rnr-field-number'; } $xt->assign("FEC_CREACION_class", $class); // add class for field header as field value $xt->assign("USUARIO_CREACION_mastervalue", $viewControls->showDBValue("USUARIO_CREACION", $data, $keylink)); $format = $settings->getViewFormat("USUARIO_CREACION"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("USUARIO_CREACION"))) { $class = ' rnr-field-number'; } $xt->assign("USUARIO_CREACION_class", $class); // add class for field header as field value $xt->assign("FEC_ULTIMA_MOD_mastervalue", $viewControls->showDBValue("FEC_ULTIMA_MOD", $data, $keylink)); $format = $settings->getViewFormat("FEC_ULTIMA_MOD"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FEC_ULTIMA_MOD"))) { $class = ' rnr-field-number'; } $xt->assign("FEC_ULTIMA_MOD_class", $class); // add class for field header as field value $xt->assign("USUARIO_ULTIMA_MOD_mastervalue", $viewControls->showDBValue("USUARIO_ULTIMA_MOD", $data, $keylink)); $format = $settings->getViewFormat("USUARIO_ULTIMA_MOD"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("USUARIO_ULTIMA_MOD"))) { $class = ' rnr-field-number'; } $xt->assign("USUARIO_ULTIMA_MOD_class", $class); // add class for field header as field value $layout = GetPageLayout("GE_ESTADO_CIVIL", 'masterlist'); if ($layout) { $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"'); } $xt->displayPartial(GetTemplateName("GE_ESTADO_CIVIL", "masterlist")); }
function DisplayMasterTableInfo_BranchMaster($params) { global $cman; $detailtable = $params["detailtable"]; $keys = $params["keys"]; $xt = new Xtempl(); $tName = "BranchMaster"; $xt->eventsObject = getEventObject($tName); $settings = new ProjectSettings($tName, PAGE_LIST); $cipherer = new RunnerCipherer($tName); $connection = $cman->byTable($tName); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_LIST); $where = ""; $keysAssoc = array(); $showKeys = ""; if ($detailtable == "Fact_SalesTransaction") { $keysAssoc["GroupID"] = $keys[1 - 1]; $keysAssoc["CompanyID"] = $keys[2 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("GroupID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("GroupID", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("GroupID", $keysAssoc); $showKeys .= " " . GetFieldLabel("BranchMaster", "GroupID") . ": " . $keyValue; $where .= " and "; $showKeys .= " , "; $where .= RunnerPage::_getFieldSQLDecrypt("CompanyID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("CompanyID", $keys[2 - 1], "", true); $keyValue = $viewControls->showDBValue("CompanyID", $keysAssoc); $showKeys .= " " . GetFieldLabel("BranchMaster", "CompanyID") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if (!$where) { return; } $str = SecuritySQL("Search", $tName); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->WhereToSql(), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); LogInfo($strSQL); $data = $cipherer->DecryptFetchedArray($connection->query($strSQL)->fetchAssoc()); if (!$data) { return; } // reassign pagetitlelabel function adding extra params $xt->assign_function("pagetitlelabel", "xt_pagetitlelabel", array("record" => $data, "settings" => $settings)); $keylink = ""; $xt->assign("BranchCloudFolder_mastervalue", $viewControls->showDBValue("BranchCloudFolder", $data, $keylink)); $format = $settings->getViewFormat("BranchCloudFolder"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("BranchCloudFolder"))) { $class = ' rnr-field-number'; } $xt->assign("BranchCloudFolder_class", $class); // add class for field header as field value $xt->assign("BranchLastSyncDate_mastervalue", $viewControls->showDBValue("BranchLastSyncDate", $data, $keylink)); $format = $settings->getViewFormat("BranchLastSyncDate"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("BranchLastSyncDate"))) { $class = ' rnr-field-number'; } $xt->assign("BranchLastSyncDate_class", $class); // add class for field header as field value $xt->assign("l_mastervalue", $viewControls->showDBValue("l", $data, $keylink)); $format = $settings->getViewFormat("l"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("l"))) { $class = ' rnr-field-number'; } $xt->assign("l_class", $class); // add class for field header as field value $layout = GetPageLayout("BranchMaster", 'masterlist'); if ($layout) { $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"'); } $xt->displayPartial(GetTemplateName("BranchMaster", "masterlist")); }
public function getFieldSQLDecrypt() { return RunnerPage::_getFieldSQLDecrypt($this->field, $this->connection, $this->pageObject->pSetEdit, $this->pageObject->cipherer); }
} } if (!$linkAndDisplaySame) { $LookupSQLTable .= "," . ($lwDisplayField == $lwLinkField ? $cipherer->GetFieldName($lwDisplayField, $f, true) : $lwDisplayField); } $LookupSQLTable .= " FROM " . $lookupConnection->addTableWrappers($lookupTable) . " "; } $strLookupWhere = GetLWWhere($f, $pageType, $strTableName); if ($strLookupWhere) { $strLookupWhere = " (" . $strLookupWhere . ") AND "; } if ($LookupType == LT_QUERY) { if ($gSettings->getCustomDisplay($f)) { $likeField = $searchByLinkField ? $linkFieldName : $displayFieldName; } else { $likeField = RunnerPage::_getFieldSQLDecrypt($searchByLinkField ? $linkFieldName : $displayFieldName, $lookupConnection, $lookupPSet, $cipherer); } } else { $likeField = $cipherer->GetFieldName($lwDisplayField, $f); } if ($searchByLinkField) { $likeConditionField = $LookupType == LT_QUERY ? $linkFieldName : $f; } else { $likeConditionField = $LookupType == LT_QUERY ? $displayFieldName : $f; } $likeWheres = array(); foreach ($values as $fieldValue) { if ($LookupType == LT_QUERY) { $likeWheres[] = $likeField . $lookupCipherer->GetLikeClause($likeConditionField, $fieldValue); } else { $likeWheres[] = $likeField . $cipherer->GetLikeClause($likeConditionField, $fieldValue);
function Chart(&$ch_array, $param) { global $field_labels; if ($this->webchart) { $this->chrt_array = Convert_Old_Chart($ch_array); } else { $this->chrt_array = $ch_array; } $this->setConnection(); $this->pSet = new ProjectSettings($this->chrt_array['tables'][0]); $this->showDetails = $param['showDetails']; if ($this->showDetails) { $this->detailTablesData = $this->pSet->getDetailTablesArr(); } $this->hasFlash = $param["hasFlash"]; $this->pageId = $param["pageId"]; $this->chrt_array["appearance"]["autoupdate"] = false; $this->numRecordsToShow = $this->chrt_array['appearance']['maxbarscroll']; if ($this->numRecordsToShow < 1) { $this->numRecordsToShow = 1; } $this->table_type = $this->chrt_array["table_type"]; if (!$this->table_type) { $this->table_type = "project"; } $this->webchart = $param["webchart"]; $this->cname = $param["cname"]; $this->chartPreview = $param["chartPreview"]; $this->dashChart = $param["dashChart"]; $this->sessionPrefix = $this->chrt_array['tables'][0]; if ($this->dashChart) { $this->dashTName = $param["dashTName"]; $this->dashElementName = $param["dashElementName"]; $this->sessionPrefix = $this->dashTName . "_" . $this->sessionPrefix; } $this->gstrOrderBy = $param["gstrOrderBy"]; $TableName = GoodFieldName($this->chrt_array['tables'][0]); // #10461, $this->setConnection(); needs to be called after value is assigned to $this->webchart $this->setConnection(); if ($this->isProjectDB()) { $this->cipherer = new RunnerCipherer($this->chrt_array['tables'][0]); } $this->header = $this->chrt_array['appearance']['head']; $this->footer = $this->chrt_array['appearance']['foot']; $this->y_axis_label = $this->chrt_array['appearance']['y_axis_label']; for ($i = 0; $i < count($this->chrt_array['parameters']) - 1; $i++) { if (isset($this->chrt_array['parameters'][$i]['currencyFormat'])) { $this->arrFormatCurrency[] = $this->chrt_array['parameters'][$i]['currencyFormat']; } else { if ($this->chrt_array['appearance']['scur'] == "false") { $this->arrFormatCurrency[] = ""; } else { $this->arrFormatCurrency[] = $this->chrt_array['appearance']['scur']; } } if (isset($this->chrt_array['parameters'][$i]['decimalFormat'])) { $this->arrFormatDecimal[] = $this->chrt_array['parameters'][$i]['decimalFormat']; } else { $this->arrFormatDecimal[] = $this->chrt_array['appearance']['dec']; } $this->arrFormatCustomer[] = $this->chrt_array['parameters'][$i]['customFormat']; $this->arrFormatCustomerStr[] = $this->chrt_array['parameters'][$i]['customFormatStr']; if ($this->chrt_array["chart_type"]["type"] == "ohlc" || $this->chrt_array["chart_type"]["type"] == "candlestick") { $this->arrOHLC_color[] = "#" . $this->chrt_array['parameters'][$i]['ohlcColor']; if ($this->table_type != "db") { $this->arrOHLC_open[] = $this->chrt_array['parameters'][$i]['ohlcOpen']; $this->arrOHLC_high[] = $this->chrt_array['parameters'][$i]['ohlcHigh']; $this->arrOHLC_low[] = $this->chrt_array['parameters'][$i]['ohlcLow']; $this->arrOHLC_close[] = $this->chrt_array['parameters'][$i]['ohlcClose']; } else { if ($this->chrt_array['parameters'][$i]['agr_func']) { $this->arrOHLC_open[] = $this->chrt_array['parameters'][$i]['agr_func'] . "_" . $this->chrt_array['parameters'][$i]['table'] . "_" . $this->chrt_array['parameters'][$i]['ohlcOpen']; $this->arrOHLC_high[] = $this->chrt_array['parameters'][$i]['agr_func'] . "_" . $this->chrt_array['parameters'][$i]['table'] . "_" . $this->chrt_array['parameters'][$i]['ohlcHigh']; $this->arrOHLC_low[] = $this->chrt_array['parameters'][$i]['agr_func'] . "_" . $this->chrt_array['parameters'][$i]['table'] . "_" . $this->chrt_array['parameters'][$i]['ohlcLow']; $this->arrOHLC_close[] = $this->chrt_array['parameters'][$i]['agr_func'] . "_" . $this->chrt_array['parameters'][$i]['table'] . "_" . $this->chrt_array['parameters'][$i]['ohlcClose']; } else { $this->arrOHLC_open[] = $this->chrt_array['parameters'][$i]['table'] . "_" . $this->chrt_array['parameters'][$i]['ohlcOpen']; $this->arrOHLC_high[] = $this->chrt_array['parameters'][$i]['table'] . "_" . $this->chrt_array['parameters'][$i]['ohlcHigh']; $this->arrOHLC_low[] = $this->chrt_array['parameters'][$i]['table'] . "_" . $this->chrt_array['parameters'][$i]['ohlcLow']; $this->arrOHLC_close[] = $this->chrt_array['parameters'][$i]['table'] . "_" . $this->chrt_array['parameters'][$i]['ohlcClose']; } } if ($this->chrt_array["chart_type"]["type"] == "candlestick") { $this->arrOHLC_candle[] = "#" . $this->chrt_array['parameters'][$i]['ohlcCandleColor']; } } elseif ($this->chrt_array['parameters'][$i]['name'] != "") { if ($this->table_type != "db") { $this->arrDataSeries[] = $this->chrt_array['parameters'][$i]['agr_func'] ? $this->chrt_array['parameters'][$i]['label'] : $this->chrt_array['parameters'][$i]['name']; if ($this->chrt_array["chart_type"]["type"] == "bubble") { $this->arrDataSize[] = $this->chrt_array['parameters'][$i]['size']; } } else { $this->arrDataSeries[] = $this->chrt_array['parameters'][$i]['agr_func'] ? $this->chrt_array['parameters'][$i]['agr_func'] . "_" . $this->chrt_array['parameters'][$i]['table'] . "_" . $this->chrt_array['parameters'][$i]['name'] : $this->chrt_array['parameters'][$i]['table'] . "_" . $this->chrt_array['parameters'][$i]['name']; if ($this->chrt_array["chart_type"]["type"] == "bubble") { $this->arrDataSize[] = $this->chrt_array['parameters'][$i]['table'] . "_" . $this->chrt_array['parameters'][$i]['size']; } } if (isset($this->chrt_array['appearance']['scolor' . ($i + 1) . '1'])) { $this->arrDataColor[] = $this->chrt_array['appearance']['scolor' . ($i + 1) . '1']; } else { $this->arrDataColor[] = $this->chrt_array['parameters'][$i]['series_color']; } if ($this->chrt_array["chart_type"]["type"] == "gauge") { for ($k = 0; is_array($this->chrt_array["parameters"][$i]["gaugeColorZone"]) && $k < count($this->chrt_array["parameters"][$i]["gaugeColorZone"]); $k++) { $beginColor = (double) @$this->chrt_array["parameters"][$i]["gaugeColorZone"][$k]["gaugeBeginColor"]; $endColor = (double) @$this->chrt_array["parameters"][$i]["gaugeColorZone"][$k]["gaugeEndColor"]; $gColor = "#" . @$this->chrt_array["parameters"][$i]["gaugeColorZone"][$k]["gaugeColor"]; $this->arrGaugeColor[count($this->arrDataSeries) - 1][] = array($beginColor, $endColor, $gColor); } } } if ($this->table_type == "project" && !$this->webchart) { if ($this->chrt_array["chart_type"]["type"] != "candlestick" && $this->chrt_array["chart_type"]["type"] != "ohlc") { $this->arrDataLabels[] = $this->chart_xmlencode(GetFieldLabel(GoodFieldName($TableName), GoodFieldName($this->chrt_array['parameters'][$i]['name']))); } else { $this->arrDataLabels[] = $this->chart_xmlencode(GetFieldLabel(GoodFieldName($TableName), GoodFieldName($this->chrt_array['parameters'][$i]['ohlcOpen']))); } } else { if (!$this->chart_xmlencode($this->chrt_array['parameters'][$i]['label'])) { if ($this->chrt_array["chart_type"]["type"] != "candlestick" && $this->chrt_array["chart_type"]["type"] != "ohlc") { $this->arrDataLabels[] = $this->chart_xmlencode($this->chrt_array['parameters'][$i]['name']); } else { $this->arrDataLabels[] = $this->chart_xmlencode($this->chrt_array['parameters'][$i]['ohlcOpen']); } } else { $this->arrDataLabels[] = $this->chart_xmlencode($this->chrt_array['parameters'][$i]['label']); } } } if ($this->chrt_array["chart_type"]["type"] != "gauge") { if ($this->table_type != "db") { $this->strLabel = $this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['name']; } else { $this->strLabel = $this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['agr_func'] ? $this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['agr_func'] . "_" . $this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['table'] . "_" . $this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['name'] : $this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['table'] . "_" . $this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['name']; } for ($j = 0; $j < count($this->chrt_array['fields']); $j++) { if ($this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['name'] == $this->chrt_array['fields'][$j]['name']) { if ($this->table_type == "project") { $this->label2 = $this->chart_xmlencode(GetFieldLabel($TableName, GoodFieldName($this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['name']))); } else { $this->label2 = $this->chart_xmlencode($this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['name']); } } } } if ($this->chrt_array["chart_type"]["type"] != "ohlc" && $this->chrt_array["chart_type"]["type"] != "candlestick") { foreach ($this->arrDataColor as $ind => $val) { if ($ind == 0) { $this->arrAxesColor = "#000000"; } else { $this->arrAxesColor = "#" . $this->arrDataColor[$ind]; } } } else { foreach ($this->arrOHLC_color as $ind => $val) { if ($ind == 0) { $this->arrAxesColor = "#000000"; } else { $this->arrAxesColor = "#" . $this->arrOHLC_color[$ind]; } } } // prepare search params $gQuery = $this->pSet->getSQLQuery(); $masterWhere = ""; if (!$this->dashChart) { $masterTable = $_SESSION[$this->sessionPrefix . "_mastertable"]; $detailKeysByM = $this->pSet->getDetailKeysByMasterTable($masterTable); if (count($detailKeysByM)) { for ($i = 0; $i < count($detailKeysByM); $i++) { if ($i != 0) { $masterWhere .= " and "; } if ($this->cipherer && isEncryptionByPHPEnabled()) { $mValue = $this->cipherer->MakeDBValue($detailKeysByM[$i], $_SESSION[$this->sessionPrefix . "_masterkey" . ($i + 1)]); } else { $mValue = make_db_value($detailKeysByM[$i], $_SESSION[$this->sessionPrefix . "_masterkey" . ($i + 1)]); } if (strlen($mValue) != 0) { $masterWhere .= RunnerPage::_getFieldSQLDecrypt($detailKeysByM[$i], $this->connection, $this->pSet, $this->cipherer) . "=" . $mValue; } else { $masterWhere .= "1=0"; } } } } $strWhereClause = ""; $searchHavingClause = ""; $strSearchCriteria = "and"; global $strTableName; // search where for basic charts if (!$this->webchart) { if (!$this->chartPreview && isset($_SESSION[$this->sessionPrefix . '_advsearch'])) { $searchClauseObj = SearchClause::UnserializeObject($_SESSION[$this->sessionPrefix . '_advsearch']); include_once getabspath('classes/controls/EditControlsContainer.php'); $editControls = new EditControlsContainer(null, $this->pSet, PAGE_SEARCH, $this->cipherer); $whereComponents = RunnerPage::sGetWhereComponents($gQuery, $this->pSet, $searchClauseObj, $editControls, $this->connection); $strWhereClause = $whereComponents["searchWhere"]; foreach ($whereComponents["filterWhere"] as $fWhere) { $strWhereClause = whereAdd($strWhereClause, $fWhere); } $searchHavingClause = $whereComponents["searchHaving"]; foreach ($whereComponents["filterHaving"] as $fHaving) { $searchHavingClause = whereAdd($searchHavingClause, $fHaving); } $strSearchCriteria = $whereComponents["searchUnionRequired"] ? "or" : "and"; } } else { if ($this->table_type != "project") { $strTableName = "webchart" . $this->cname; } $strWhereClause = CalcSearchParam($this->table_type != "project"); } if ($strWhereClause) { $this->chrt_array['where'] .= $this->chrt_array['where'] ? " AND (" . $strWhereClause . ")" : " WHERE (" . $strWhereClause . ")"; } if ($this->table_type == "project") { if (SecuritySQL("Search", $this->chrt_array['tables'][0])) { $strWhereClause = whereAdd($strWhereClause, SecuritySQL("Search", $strTableName)); } $this->strSQL = $gQuery->gSQLWhere($strWhereClause, $searchHavingClause, $strSearchCriteria); $strOrderBy = $this->gstrOrderBy; $this->strSQL .= " " . $strOrderBy; if ($masterWhere) { $strWhereClause = whereAdd($strWhereClause, $masterWhere); } $strSQLbak = $this->strSQL; if (tableEventExists("BeforeQueryChart", $strTableName)) { $tstrSQL = $this->strSQL; $eventObj = getEventObject($strTableName); $eventObj->BeforeQueryChart($tstrSQL, $strWhereClause, $strOrderBy); $this->strSQL = $tstrSQL; } if ($strSQLbak == $this->strSQL) { $this->strSQL = $gQuery->gSQLWhere($strWhereClause, $searchHavingClause, $strSearchCriteria); $this->strSQL .= " " . $strOrderBy; } } if ($this->cname && $this->table_type == "db") { $this->strSQL = $this->chrt_array['sql'] . $this->chrt_array['where'] . $this->chrt_array['group_by'] . $this->chrt_array['order_by']; } elseif ($this->cname && $this->table_type == "custom") { if (!IsStoredProcedure($this->chrt_array['sql'])) { $sql_query = $this->chrt_array['sql']; if ($this->connection->dbType == nDATABASE_MSSQLServer) { $pos = strrpos(strtoupper($sql_query), "ORDER BY"); if ($pos) { $sql_query = substr($sql_query, 0, $pos); } } if ($this->connection->dbType != nDATABASE_Oracle) { $this->strSQL = "select * from (" . $sql_query . ") as " . $this->connection->addFieldWrappers("custom_query") . $this->chrt_array['where']; } else { $this->strSQL = "select * from (" . $sql_query . ")" . $this->chrt_array['where']; } } else { $this->strSQL = $this->chrt_array['sql']; } } if (tableEventExists("UpdateChartSettings", $strTableName)) { $eventObj = getEventObject($strTableName); $eventObj->UpdateChartSettings($this); } }
$pSet = new ProjectSettings($strTableName, $pageType); $denyChecking = $pSet->allowDuplicateValues($fieldName); $denyChecking = $denyChecking && ($strTableName != "DashboardUsers" || $fieldName != $cUserNameField && $fieldName != $cEmailField); if ($denyChecking) { $returnJSON = array("success" => false, "error" => "Duplicated values are allowed"); echo printJSON($returnJSON); return; } $cipherer = new RunnerCipherer($strTableName, $pSet); if ($cipherer->isFieldEncrypted($fieldName)) { $value = $cipherer->MakeDBValue($fieldName, $value, $fieldControlType, true); } else { $value = make_db_value($fieldName, $value, $fieldControlType, "", $strTableName); } if ($value == "null") { $fieldSQL = RunnerPage::_getFieldSQL($fieldName, $_connection, $pSet); } else { $fieldSQL = RunnerPage::_getFieldSQLDecrypt($fieldName, $_connection, $pSet, $cipherer); } $where = $fieldSQL . ($value == "null" ? ' is ' : '=') . $value; $sql = "SELECT count(*) from " . $_connection->addTableWrappers($pSet->getOriginalTableName()) . " where " . $where; $qResult = $_connection->query($sql); if (!$qResult || !($data = $qResult->fetchNumeric())) { $returnJSON = array("success" => false, "error" => "Error: Wrong SQL query"); echo printJSON($returnJSON); return; } $hasDuplicates = $data[0] ? true : false; $returnJSON = array("success" => true, "hasDuplicates" => $hasDuplicates, "error" => ""); echo printJSON($returnJSON); return;
/** * DEPRECATED. Use RunnerPage::keysSQLExpression instead * Construct WHERE clause with key values * * @param &Array $keys * @param String $table Teh data source table name OPTIONAL * * @return String * @intellisense * @deprecated */ function KeyWhere(&$keys, $table = "") { global $strTableName, $cman; if (!$table) { $table = $strTableName; } $strWhere = ""; $pSet = new ProjectSettings($table); $cipherer = new RunnerCipherer($table); $connection = $cman->byTable($table); $keyFields = $pSet->getTableKeys(); foreach ($keyFields as $kf) { if (strlen($strWhere)) { $strWhere .= " and "; } $value = $cipherer->MakeDBValue($kf, $keys[$kf], "", true); if ($connection->dbType == nDATABASE_Oracle) { $valueisnull = $value === "null" || $value == "''"; } else { $valueisnull = $value === "null"; } if ($valueisnull) { $strWhere .= RunnerPage::_getFieldSQL($kf, $connection, $pSet) . " is null"; } else { $strWhere .= RunnerPage::_getFieldSQLDecrypt($kf, $connection, $pSet, $cipherer) . "=" . $cipherer->MakeDBValue($kf, $keys[$kf], "", true); } } return $strWhere; }
/** * Use for count details recs number, if subQueryes not supported, or keys have different types * * @param integer $i * @param array $detailid * @intellisense */ function countDetailsRecsNoSubQ($dInd, &$detailid) { global $tables_data, $masterTablesData, $detailsTablesData, $allDetailsTablesArr, $cman; $dDataSourceTable = $this->allDetailsTablesArr[$dInd]['dDataSourceTable']; $detPSet = $this->pSet->getTable($dDataSourceTable); $detCipherer = new RunnerCipherer($dDataSourceTable, $detPSet); $detConnection = $cman->byTable($dDataSourceTable); $detailsQuery = $detPSet->getSQLQuery(); $dSqlWhere = $detailsQuery->WhereToSql(); $detailKeys = $detPSet->getDetailKeysByMasterTable($this->tName); $securityClause = SecuritySQL("Search", $dDataSourceTable); // add where if (strlen($securityClause)) { $dSqlWhere = whereAdd($dSqlWhere, $securityClause); } $masterwhere = ""; foreach ($this->masterKeysByD[$dInd] as $idx => $val) { if ($masterwhere) { $masterwhere .= " and "; } $mastervalue = $detCipherer->MakeDBValue($detailKeys[$idx], $detailid[$idx], "", true); if ($mastervalue == "null") { $masterwhere .= RunnerPage::_getFieldSQL($detailKeys[$idx], $detConnection, $detPSet) . " is NULL "; } else { $masterwhere .= RunnerPage::_getFieldSQLDecrypt($detailKeys[$idx], $detConnection, $detPSet, $detCipherer) . "=" . $mastervalue; } } return SQLQuery::gSQLRowCount_int($detailsQuery->HeadToSql(), $detailsQuery->FromToSql(), $dSqlWhere, $detailsQuery->GroupByToSql(), $detailsQuery->Having()->toSql($detailsQuery), $masterwhere, "", $detConnection); }
/** * Get a where condition basing on curren't lookup control's values * @param String childVal * @return String */ protected function getChildWhere($childVal) { if ($this->lookupType == LT_QUERY) { $childWhereField = $this->pageObject->pSetEdit->getLinkField($this->field); $fullLinkFieldName = RunnerPage::_getFieldSQLDecrypt($this->pageObject->pSetEdit->getLinkField($this->field), $this->lookupConnection, $this->lookupPSet, $this->ciphererDisplay); } else { $fullLinkFieldName = $this->lwLinkField; } $childValues = $this->multiselect ? splitvalues($childVal) : array($childVal); $childWheres = array(); foreach ($childValues as $childValue) { if ($this->lookupType == LT_QUERY) { $dbValue = $this->ciphererDisplay->MakeDBValue($childWhereField, $childValue, "", true); } else { $dbValue = make_db_value($this->field, $childValue, '', '', $this->tName); } $childWheres[] = $fullLinkFieldName . ($dbValue === "null" ? " is null" : "=" . $dbValue); } return implode(' OR ', $childWheres); }
/** * Get filter's WHERE clause condition basing on the filter's type * * @param String filterType A string representing the filter's type * @param String fName * @param String fValue * @param String dbType * @return String */ function getFilterWhereByType($filterType, $fName, $fValue, $sValue, $parentValues, $connection) { $pSet = new ProjectSettings($this->tName, PAGE_SEARCH); $fullFieldName = RunnerPage::_getFieldSQLDecrypt($fName, $connection, $pSet, $this->cipherer); $fieldType = $pSet->getFieldType($fName); $dateField = IsDateFieldType($fieldType); $timeField = IsTimeType($fieldType); if ($dateField || $timeField) { include_once getabspath("classes/controls/FilterControl.php"); include_once getabspath("classes/controls/FilterIntervalSlider.php"); include_once getabspath("classes/controls/FilterIntervalDateSlider.php"); } switch ($filterType) { case 'interval': $intervalData = $pSet->getFilterIntervalDatabyIndex($fName, $fValue); if (!count($intervalData)) { return ""; } include_once getabspath("classes/controls/FilterControl.php"); include_once getabspath("classes/controls/FilterIntervalList.php"); return FilterIntervalList::getIntervalFilterWhere($fName, $intervalData, $pSet, $this->cipherer, $this->tName, $connection); case 'equals': if (!count($parentValues)) { return $fullFieldName . "=" . $this->cipherer->MakeDBValue($fName, $fValue, "", true); } $wheres = array(); $wheres[] = $fullFieldName . "=" . $this->cipherer->MakeDBValue($fName, $fValue, "", true); $parentFiltersNames = $pSet->getParentFiltersNames($fName); foreach ($parentFiltersNames as $key => $parentName) { $wheres[] = RunnerPage::_getFieldSQLDecrypt($parentName, $connection, $pSet, $this->cipherer) . "=" . $this->cipherer->MakeDBValue($parentName, $parentValues[$key], "", true); } return "(" . implode(" AND ", $wheres) . ")"; case 'checked': if ($fValue != "on" && $fValue != "off") { return ""; } $bNeedQuotes = NeedQuotes($fieldType); include_once getabspath("classes/controls/Control.php"); include_once getabspath("classes/controls/CheckboxField.php"); return CheckboxField::constructFieldWhere($fullFieldName, $bNeedQuotes, $fValue == "on", $pSet->getFieldType($fName), $connection->dbType); case 'slider': if ($dateField) { return FilterIntervalDateSlider::getDateSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); } if ($timeField) { include_once getabspath("classes/controls/FilterIntervalTimeSlider.php"); return FilterIntervalTimeSlider::getTimeSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); } return $this->cipherer->MakeDBValue($fName, $fValue, "", true) . "<=" . $fullFieldName . " AND " . $fullFieldName . "<=" . $this->cipherer->MakeDBValue($fName, $sValue, "", true); case 'moreequal': if ($dateField) { return FilterIntervalDateSlider::getDateSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); } if ($timeField) { include_once getabspath("classes/controls/FilterIntervalTimeSlider.php"); return FilterIntervalTimeSlider::getTimeSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); } return $this->cipherer->MakeDBValue($fName, $fValue, "", true) . "<=" . $fullFieldName; case 'lessequal': if ($dateField) { return FilterIntervalDateSlider::getDateSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); } if ($timeField) { include_once getabspath("classes/controls/FilterIntervalTimeSlider.php"); return FilterIntervalTimeSlider::getTimeSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); } return $fullFieldName . "<=" . $this->cipherer->MakeDBValue($fName, $fValue, "", true); default: return ""; } }
function DisplayMasterTableInfoForPrint_calendar_table($params) { global $cman; $detailtable = $params["detailtable"]; $keys = $params["keys"]; $xt = new Xtempl(); $tName = "calendar_table"; $xt->eventsObject = getEventObject($tName); $cipherer = new RunnerCipherer($tName); $settings = new ProjectSettings($tName, PAGE_PRINT); $connection = $cman->byTable($tName); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_PRINT); $where = ""; $keysAssoc = array(); $showKeys = ""; if ($detailtable == "Fact_SalesTransaction") { $keysAssoc["dt"] = $keys[1 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("dt", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("dt", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("dt", $keysAssoc); $showKeys .= " " . GetFieldLabel("calendar_table", "dt") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if ($detailtable == "Current Year Sales") { $keysAssoc["dt"] = $keys[1 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("dt", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("dt", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("dt", $keysAssoc); $showKeys .= " " . GetFieldLabel("calendar_table", "dt") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if (!$where) { return; } $str = SecuritySQL("Export", $tName); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->m_where->toSql($masterQuery), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); LogInfo($strSQL); $data = $cipherer->DecryptFetchedArray($connection->query($strSQL)->fetchAssoc()); if (!$data) { return; } // reassign pagetitlelabel function adding extra params $xt->assign_function("pagetitlelabel", "xt_pagetitlelabel", array("record" => $data, "settings" => $settings)); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["dt"])); $xt->assign("dt_mastervalue", $viewControls->showDBValue("dt", $data, $keylink)); $format = $settings->getViewFormat("dt"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("dt"))) { $class = ' rnr-field-number'; } $xt->assign("dt_class", $class); // add class for field header as field value $xt->assign("y_mastervalue", $viewControls->showDBValue("y", $data, $keylink)); $format = $settings->getViewFormat("y"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("y"))) { $class = ' rnr-field-number'; } $xt->assign("y_class", $class); // add class for field header as field value $xt->assign("q_mastervalue", $viewControls->showDBValue("q", $data, $keylink)); $format = $settings->getViewFormat("q"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("q"))) { $class = ' rnr-field-number'; } $xt->assign("q_class", $class); // add class for field header as field value $xt->assign("m_mastervalue", $viewControls->showDBValue("m", $data, $keylink)); $format = $settings->getViewFormat("m"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("m"))) { $class = ' rnr-field-number'; } $xt->assign("m_class", $class); // add class for field header as field value $xt->assign("d_mastervalue", $viewControls->showDBValue("d", $data, $keylink)); $format = $settings->getViewFormat("d"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("d"))) { $class = ' rnr-field-number'; } $xt->assign("d_class", $class); // add class for field header as field value $xt->assign("dw_mastervalue", $viewControls->showDBValue("dw", $data, $keylink)); $format = $settings->getViewFormat("dw"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("dw"))) { $class = ' rnr-field-number'; } $xt->assign("dw_class", $class); // add class for field header as field value $xt->assign("monthName_mastervalue", $viewControls->showDBValue("monthName", $data, $keylink)); $format = $settings->getViewFormat("monthName"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("monthName"))) { $class = ' rnr-field-number'; } $xt->assign("monthName_class", $class); // add class for field header as field value $xt->assign("dayName_mastervalue", $viewControls->showDBValue("dayName", $data, $keylink)); $format = $settings->getViewFormat("dayName"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("dayName"))) { $class = ' rnr-field-number'; } $xt->assign("dayName_class", $class); // add class for field header as field value $xt->assign("w_mastervalue", $viewControls->showDBValue("w", $data, $keylink)); $format = $settings->getViewFormat("w"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("w"))) { $class = ' rnr-field-number'; } $xt->assign("w_class", $class); // add class for field header as field value $xt->assign("isWeekday_mastervalue", $viewControls->showDBValue("isWeekday", $data, $keylink)); $format = $settings->getViewFormat("isWeekday"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("isWeekday"))) { $class = ' rnr-field-number'; } $xt->assign("isWeekday_class", $class); // add class for field header as field value $xt->assign("isHoliday_mastervalue", $viewControls->showDBValue("isHoliday", $data, $keylink)); $format = $settings->getViewFormat("isHoliday"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("isHoliday"))) { $class = ' rnr-field-number'; } $xt->assign("isHoliday_class", $class); // add class for field header as field value $xt->assign("holidayDescr_mastervalue", $viewControls->showDBValue("holidayDescr", $data, $keylink)); $format = $settings->getViewFormat("holidayDescr"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("holidayDescr"))) { $class = ' rnr-field-number'; } $xt->assign("holidayDescr_class", $class); // add class for field header as field value $xt->assign("isPayday_mastervalue", $viewControls->showDBValue("isPayday", $data, $keylink)); $format = $settings->getViewFormat("isPayday"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("isPayday"))) { $class = ' rnr-field-number'; } $xt->assign("isPayday_class", $class); // add class for field header as field value $xt->assign("yearQuarterText_mastervalue", $viewControls->showDBValue("yearQuarterText", $data, $keylink)); $format = $settings->getViewFormat("yearQuarterText"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("yearQuarterText"))) { $class = ' rnr-field-number'; } $xt->assign("yearQuarterText_class", $class); // add class for field header as field value $xt->assign("yearMonthInt_mastervalue", $viewControls->showDBValue("yearMonthInt", $data, $keylink)); $format = $settings->getViewFormat("yearMonthInt"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("yearMonthInt"))) { $class = ' rnr-field-number'; } $xt->assign("yearMonthInt_class", $class); // add class for field header as field value $xt->assign("yearMonthText_mastervalue", $viewControls->showDBValue("yearMonthText", $data, $keylink)); $format = $settings->getViewFormat("yearMonthText"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("yearMonthText"))) { $class = ' rnr-field-number'; } $xt->assign("yearMonthText_class", $class); // add class for field header as field value $xt->assign("yearWeekInt_mastervalue", $viewControls->showDBValue("yearWeekInt", $data, $keylink)); $format = $settings->getViewFormat("yearWeekInt"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("yearWeekInt"))) { $class = ' rnr-field-number'; } $xt->assign("yearWeekInt_class", $class); // add class for field header as field value $xt->assign("yearWeekText_mastervalue", $viewControls->showDBValue("yearWeekText", $data, $keylink)); $format = $settings->getViewFormat("yearWeekText"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("yearWeekText"))) { $class = ' rnr-field-number'; } $xt->assign("yearWeekText_class", $class); // add class for field header as field value $xt->assign("monthWeekInt_mastervalue", $viewControls->showDBValue("monthWeekInt", $data, $keylink)); $format = $settings->getViewFormat("monthWeekInt"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("monthWeekInt"))) { $class = ' rnr-field-number'; } $xt->assign("monthWeekInt_class", $class); // add class for field header as field value $xt->assign("monthWeekText_mastervalue", $viewControls->showDBValue("monthWeekText", $data, $keylink)); $format = $settings->getViewFormat("monthWeekText"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("monthWeekText"))) { $class = ' rnr-field-number'; } $xt->assign("monthWeekText_class", $class); // add class for field header as field value $xt->assign("fiscalYear_mastervalue", $viewControls->showDBValue("fiscalYear", $data, $keylink)); $format = $settings->getViewFormat("fiscalYear"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("fiscalYear"))) { $class = ' rnr-field-number'; } $xt->assign("fiscalYear_class", $class); // add class for field header as field value $xt->assign("fiscalMonth_mastervalue", $viewControls->showDBValue("fiscalMonth", $data, $keylink)); $format = $settings->getViewFormat("fiscalMonth"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("fiscalMonth"))) { $class = ' rnr-field-number'; } $xt->assign("fiscalMonth_class", $class); // add class for field header as field value $xt->assign("fiscalQuarter_mastervalue", $viewControls->showDBValue("fiscalQuarter", $data, $keylink)); $format = $settings->getViewFormat("fiscalQuarter"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("fiscalQuarter"))) { $class = ' rnr-field-number'; } $xt->assign("fiscalQuarter_class", $class); // add class for field header as field value $xt->assign("fiscalYearMonthText_mastervalue", $viewControls->showDBValue("fiscalYearMonthText", $data, $keylink)); $format = $settings->getViewFormat("fiscalYearMonthText"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("fiscalYearMonthText"))) { $class = ' rnr-field-number'; } $xt->assign("fiscalYearMonthText_class", $class); // add class for field header as field value $layout = GetPageLayout("calendar_table", 'masterprint'); if ($layout) { $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"'); } $xt->displayPartial(GetTemplateName("calendar_table", "masterprint")); }
function DisplayMasterTableInfoForPrint_GE_PERSONA_DISPONIBLE($params) { global $cman; $detailtable = $params["detailtable"]; $keys = $params["keys"]; $xt = new Xtempl(); $tName = "GE.PERSONA_DISPONIBLE"; $cipherer = new RunnerCipherer($tName); $settings = new ProjectSettings($tName, PAGE_PRINT); $connection = $cman->byTable($tName); $masterQuery = $settings->getSQLQuery(); $viewControls = new ViewControlsContainer($settings, PAGE_PRINT); $where = ""; $keysAssoc = array(); $showKeys = ""; if ($detailtable == "GE.PERSONA_DISPONIBLEXEJERCICIO") { $keysAssoc["USERNAME"] = $keys[1 - 1]; $keysAssoc["ES_REAL"] = $keys[2 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue; $where .= " and "; $showKeys .= " , "; $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[2 - 1], "", true); $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if ($detailtable == "GE.PERSONA_DISPONIBLEXCOLOR_PELO") { $keysAssoc["ES_REAL"] = $keys[1 - 1]; $keysAssoc["USERNAME"] = $keys[2 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue; $where .= " and "; $showKeys .= " , "; $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[2 - 1], "", true); $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if ($detailtable == "GE.PERSONA_DISPONIBLEXIDIOMA") { $keysAssoc["USERNAME"] = $keys[1 - 1]; $keysAssoc["ES_REAL"] = $keys[2 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue; $where .= " and "; $showKeys .= " , "; $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[2 - 1], "", true); $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if ($detailtable == "GE.PERSONA_DISPONIBLEXOCUPACION") { $keysAssoc["ES_REAL"] = $keys[1 - 1]; $keysAssoc["USERNAME"] = $keys[2 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue; $where .= " and "; $showKeys .= " , "; $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[2 - 1], "", true); $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if ($detailtable == "GE.PERSONA_DISPONIBLEXRELIGION") { $keysAssoc["USERNAME"] = $keys[1 - 1]; $keysAssoc["ES_REAL"] = $keys[2 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue; $where .= " and "; $showKeys .= " , "; $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[2 - 1], "", true); $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if ($detailtable == "GE.PERSONA_DISPONIBLEXINTERES") { $keysAssoc["ES_REAL"] = $keys[1 - 1]; $keysAssoc["USERNAME"] = $keys[2 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue; $where .= " and "; $showKeys .= " , "; $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[2 - 1], "", true); $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if ($detailtable == "GE.PERSONA_DISPONIBLEXMASCOTA") { $keysAssoc["USERNAME"] = $keys[1 - 1]; $keysAssoc["ES_REAL"] = $keys[2 - 1]; $where .= RunnerPage::_getFieldSQLDecrypt("USERNAME", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("USERNAME", $keys[1 - 1], "", true); $keyValue = $viewControls->showDBValue("USERNAME", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "USERNAME") . ": " . $keyValue; $where .= " and "; $showKeys .= " , "; $where .= RunnerPage::_getFieldSQLDecrypt("ES_REAL", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ES_REAL", $keys[2 - 1], "", true); $keyValue = $viewControls->showDBValue("ES_REAL", $keysAssoc); $showKeys .= " " . GetFieldLabel("GE_PERSONA_DISPONIBLE", "ES_REAL") . ": " . $keyValue; $xt->assign('showKeys', $showKeys); } if (!$where) { return; } $str = SecuritySQL("Export"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($masterQuery->m_where->toSql($masterQuery), $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql(); LogInfo($strSQL); $data = $cipherer->DecryptFetchedArray($connection->query($strSQL)->fetchAssoc()); if (!$data) { return; } // reassign pagetitlelabel function adding extra params $xt->assign_function("pagetitlelabel", "xt_pagetitlelabel", array("record" => $data, "settings" => $settings)); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["USERNAME"])); $keylink .= "&key2=" . runner_htmlspecialchars(rawurlencode(@$data["ES_REAL"])); $xt->assign("USERNAME_mastervalue", $viewControls->showDBValue("USERNAME", $data, $keylink)); $format = $settings->getViewFormat("USERNAME"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("USERNAME"))) { $class = ' rnr-field-number'; } $xt->assign("USERNAME_class", $class); // add class for field header as field value $xt->assign("ES_REAL_mastervalue", $viewControls->showDBValue("ES_REAL", $data, $keylink)); $format = $settings->getViewFormat("ES_REAL"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("ES_REAL"))) { $class = ' rnr-field-number'; } $xt->assign("ES_REAL_class", $class); // add class for field header as field value $xt->assign("COLOR_OJOS_ID_mastervalue", $viewControls->showDBValue("COLOR_OJOS_ID", $data, $keylink)); $format = $settings->getViewFormat("COLOR_OJOS_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("COLOR_OJOS_ID"))) { $class = ' rnr-field-number'; } $xt->assign("COLOR_OJOS_ID_class", $class); // add class for field header as field value $xt->assign("COLOR_PIEL_ID_mastervalue", $viewControls->showDBValue("COLOR_PIEL_ID", $data, $keylink)); $format = $settings->getViewFormat("COLOR_PIEL_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("COLOR_PIEL_ID"))) { $class = ' rnr-field-number'; } $xt->assign("COLOR_PIEL_ID_class", $class); // add class for field header as field value $xt->assign("CONTEXTURA_ID_mastervalue", $viewControls->showDBValue("CONTEXTURA_ID", $data, $keylink)); $format = $settings->getViewFormat("CONTEXTURA_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("CONTEXTURA_ID"))) { $class = ' rnr-field-number'; } $xt->assign("CONTEXTURA_ID_class", $class); // add class for field header as field value $xt->assign("NIVEL_EDUCACION_ID_mastervalue", $viewControls->showDBValue("NIVEL_EDUCACION_ID", $data, $keylink)); $format = $settings->getViewFormat("NIVEL_EDUCACION_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("NIVEL_EDUCACION_ID"))) { $class = ' rnr-field-number'; } $xt->assign("NIVEL_EDUCACION_ID_class", $class); // add class for field header as field value $xt->assign("ESTADO_CIVIL_ID_mastervalue", $viewControls->showDBValue("ESTADO_CIVIL_ID", $data, $keylink)); $format = $settings->getViewFormat("ESTADO_CIVIL_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("ESTADO_CIVIL_ID"))) { $class = ' rnr-field-number'; } $xt->assign("ESTADO_CIVIL_ID_class", $class); // add class for field header as field value $xt->assign("FUMADOR_ID_mastervalue", $viewControls->showDBValue("FUMADOR_ID", $data, $keylink)); $format = $settings->getViewFormat("FUMADOR_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FUMADOR_ID"))) { $class = ' rnr-field-number'; } $xt->assign("FUMADOR_ID_class", $class); // add class for field header as field value $xt->assign("BEBEDOR_ID_mastervalue", $viewControls->showDBValue("BEBEDOR_ID", $data, $keylink)); $format = $settings->getViewFormat("BEBEDOR_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("BEBEDOR_ID"))) { $class = ' rnr-field-number'; } $xt->assign("BEBEDOR_ID_class", $class); // add class for field header as field value $xt->assign("FRECUENCIA_EJERCICIO_ID_mastervalue", $viewControls->showDBValue("FRECUENCIA_EJERCICIO_ID", $data, $keylink)); $format = $settings->getViewFormat("FRECUENCIA_EJERCICIO_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FRECUENCIA_EJERCICIO_ID"))) { $class = ' rnr-field-number'; } $xt->assign("FRECUENCIA_EJERCICIO_ID_class", $class); // add class for field header as field value $xt->assign("SALARIO_ID_mastervalue", $viewControls->showDBValue("SALARIO_ID", $data, $keylink)); $format = $settings->getViewFormat("SALARIO_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("SALARIO_ID"))) { $class = ' rnr-field-number'; } $xt->assign("SALARIO_ID_class", $class); // add class for field header as field value $xt->assign("ALTURA_mastervalue", $viewControls->showDBValue("ALTURA", $data, $keylink)); $format = $settings->getViewFormat("ALTURA"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("ALTURA"))) { $class = ' rnr-field-number'; } $xt->assign("ALTURA_class", $class); // add class for field header as field value $xt->assign("PESO_mastervalue", $viewControls->showDBValue("PESO", $data, $keylink)); $format = $settings->getViewFormat("PESO"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("PESO"))) { $class = ' rnr-field-number'; } $xt->assign("PESO_class", $class); // add class for field header as field value $xt->assign("NUM_HIJOS_mastervalue", $viewControls->showDBValue("NUM_HIJOS", $data, $keylink)); $format = $settings->getViewFormat("NUM_HIJOS"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("NUM_HIJOS"))) { $class = ' rnr-field-number'; } $xt->assign("NUM_HIJOS_class", $class); // add class for field header as field value $xt->assign("QUIERE_HIJOS_mastervalue", $viewControls->showDBValue("QUIERE_HIJOS", $data, $keylink)); $format = $settings->getViewFormat("QUIERE_HIJOS"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("QUIERE_HIJOS"))) { $class = ' rnr-field-number'; } $xt->assign("QUIERE_HIJOS_class", $class); // add class for field header as field value $xt->assign("FEC_CREACION_mastervalue", $viewControls->showDBValue("FEC_CREACION", $data, $keylink)); $format = $settings->getViewFormat("FEC_CREACION"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FEC_CREACION"))) { $class = ' rnr-field-number'; } $xt->assign("FEC_CREACION_class", $class); // add class for field header as field value $xt->assign("USUARIO_CREACION_mastervalue", $viewControls->showDBValue("USUARIO_CREACION", $data, $keylink)); $format = $settings->getViewFormat("USUARIO_CREACION"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("USUARIO_CREACION"))) { $class = ' rnr-field-number'; } $xt->assign("USUARIO_CREACION_class", $class); // add class for field header as field value $xt->assign("FEC_ULTIMA_MOD_mastervalue", $viewControls->showDBValue("FEC_ULTIMA_MOD", $data, $keylink)); $format = $settings->getViewFormat("FEC_ULTIMA_MOD"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FEC_ULTIMA_MOD"))) { $class = ' rnr-field-number'; } $xt->assign("FEC_ULTIMA_MOD_class", $class); // add class for field header as field value $xt->assign("USUARIO_ULTIMA_MOD_mastervalue", $viewControls->showDBValue("USUARIO_ULTIMA_MOD", $data, $keylink)); $format = $settings->getViewFormat("USUARIO_ULTIMA_MOD"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("USUARIO_ULTIMA_MOD"))) { $class = ' rnr-field-number'; } $xt->assign("USUARIO_ULTIMA_MOD_class", $class); // add class for field header as field value $xt->assign("TIPO_RELACION_ID_mastervalue", $viewControls->showDBValue("TIPO_RELACION_ID", $data, $keylink)); $format = $settings->getViewFormat("TIPO_RELACION_ID"); $class = " rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; } if ($format == FORMAT_CHECKBOX) { $class = ' rnr-field-checkbox'; } if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("TIPO_RELACION_ID"))) { $class = ' rnr-field-number'; } $xt->assign("TIPO_RELACION_ID_class", $class); // add class for field header as field value $layout = GetPageLayout("GE_PERSONA_DISPONIBLE", 'masterprint'); if ($layout) { $xt->assign("pageattrs", 'class="' . $layout->style . " page-" . $layout->name . '"'); } $xt->displayPartial(GetTemplateName("GE_PERSONA_DISPONIBLE", "masterprint")); }
/** * @param String value * @param String in * @return String */ protected function getMultiselectLookupResolvingSQL($value, $in) { if (!$this->pSet->multiSelect($this->field)) { return ""; } $where = GetLWWhere($this->field, $this->pSet->getEditPageType()); if ($this->nLookupType == LT_QUERY) { $inWhere = RunnerPage::_getFieldSQLDecrypt($this->linkFieldName, $this->lookupConnection, $this->lookupPSet, $this->cipherer) . " in (" . $in . ")"; if (strlen($where)) { $inWhere .= " and (" . $where . ")"; } $LookupSQL = $this->lookupQueryObj->toSql(whereAdd($this->lookupQueryObj->m_where->toSql($this->lookupQueryObj), $inWhere)); } else { $LookupSQL = $this->LookupSQL . $this->lookupConnection->addFieldWrappers($this->pSet->getLinkField($this->field)) . " in (" . $in . ")"; if (strlen($where)) { $LookupSQL .= " and (" . $where . ")"; } } return $LookupSQL; }
function getOrderSql() { if ($this->_interval == 0) { $fname = $this->_oldAlgorithm ? RunnerPage::_getFieldSQLDecrypt($this->_name, $this->_connection, $this->pSet, $this->cipherer) : cached_ffn($this->_name); return $fname . ' ' . $this->_orderBy . ' '; } else { $grp = $this->getSqlList(); $newgrp = array(); foreach ($grp as $g) { $newgrp[] = $g . ' ' . $this->_orderBy . ' '; } return join(', ', $newgrp); } }
/** * Get a correct field name for SQL query building * @param String fName * @return String */ protected function getDbFieldName($fName) { return RunnerPage::_getFieldSQLDecrypt($fName, $this->connection, $this->pSet, $this->cipherer); }