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"));
}
h_group=document.getElementById("select_group_list").offsetHeight;
if(h_group<=h_select)
document.getElementById("select_group_list").style.height=h_select;';
if(!count($arr_tables_db))
$b_includes.= '$("#li_db").hide();';
if(!count($arr_tables_project))
$b_includes.= '$("#li_project").hide();';
if(!count($arr_tables_custom))
$b_includes.= '$("#li_custom").hide();';
$b_includes.= '
});
</script>'."\r\n";
$xt->assign("b_includes", $b_includes);
if (@$_SESSION['webreports']['settings']['title'] != "") {
$xt->assign("report_title",", "."Title".": ".@$_SESSION['webreports']['settings']['title']);
} else {
$xt->assign("report_title","");
}
$xt->assign("wr_pagestylepath", $wr_pagestylepath);
$xt->assign("table_list",$table_list);
$xt->assign("group_list",$group_list);
$templatefile = GetTemplateName("", "webreport_admin");
$xt->display($templatefile);
?>
$pageObject->updatePageLayoutAndCSS('', 'success');
$xt->assign("email", $strEmail);
$xt->assign("activation_block", true);
$xt->assign("registered_block", true);
$xt->assign("body", $pageObject->body);
$xt->assign("loginlink_attrs", "onclick=\"document.forms.loginform.submit();return false;\" id=\"ProceedToLogin\"");
if (postvalue("onFly") == 1) {
$pageObject->templatefile = GetTemplateName("", "register_success");
$xt->assign("id", $id);
$xt->assign("footer", false);
$xt->assign("header", false);
$xt->assign("body", true);
$pageObject->displayAJAX($pageObject->templatefile, $id + 1);
exit;
}
return $pageObject->display(GetTemplateName("", "register_success"));
// return $pageObject->display for .net compatibility
} elseif ($sentMailResults['message']) {
$xt->assign("message", "<div class='message rnr-error'>" . $sentMailResults['message'] . "</div>");
$xt->assign("message_block", true);
}
} else {
if ($globalEvents->exists("AfterUnsuccessfulRegistration")) {
$globalEvents->AfterUnsuccessfulRegistration($values, $strMessage, $pageObject);
}
if ($strMessage != "") {
$xt->assign("message", "<div class='message rnr-error'>" . $strMessage . "</div>");
$xt->assign("message_block", true);
}
}
}
$xt->assign("admin_sql", $create_butt);
}
else
$xt->assign("admin_sql",false);
if(count($arr_tables_db) || count($arr_tables_project) || count($arr_tables_custom))
{
$create_butt="<a id=\"report_createbtn\" class=\"rnr-button\" onmouseover=\"this.focus();\" name=\"report_createbtn\" wtype=\"report\" href=\"#\">"."Create Report"."</a>";
$create_butt.="<a id=\"chart_createbtn\" class=\"rnr-button\" onmouseover=\"this.focus();\" name=\"chart_createbtn\" wtype=\"chart\" href=\"#\">"."Create chart"."</a>";
$xt->assign("create_report_chart", $create_butt);
}
else
{
if($wr_is_standalone && !isWRAdmin())
$xt->assign("create_report_chart", "<b>"."You do not have permissions to create reports and charts. Contact administrator in this regard."."</b>");
}
if($_SESSION["UserID"]=="Guest" && $wr_is_standalone)
$xt->assign("create_report_chart", "<b>"."You do not have permissions to create reports and charts. Contact administrator in this regard."."</b>");
$xt->assign("wr_pagestylepath", $wr_pagestylepath);
$xt->assign("shared_reports", $shared_reports);
$xt->assign("private_reports", $private_reports);
$xt->assign("shared_charts", $shared_charts);
$xt->assign("private_charts", $private_charts);
$templatefile = GetTemplateName("", "webreport");
$xt->display($templatefile);
?>
/**
* Set template file
*/
public function setTemplateFile()
{
if ($this->mode == ADD_INLINE) {
$this->templatefile = GetTemplateName($this->shortTableName, "inline_add");
}
parent::setTemplateFile();
}
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($pSet->getFieldType("LastUpdate"))) {
$class = ' rnr-field-number';
}
$row["LastUpdate_class"] = $class;
$rowinfo[] = $row;
if ($b) {
$rowinfo2[] = $row;
$b = false;
}
$data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc());
}
$xt->assign_loopsection("details_row", $rowinfo);
$xt->assign_loopsection("details_row_header", $rowinfo2);
// assign class for header
}
$returnJSON = array("success" => true);
$xt->load_template(GetTemplateName("StockMaster", "detailspreview"));
$returnJSON["body"] = $xt->fetch_loaded();
if ($mode != "inline") {
$returnJSON["counter"] = postvalue("counter");
$layout = GetPageLayout(GoodFieldName($strTableName), 'detailspreview');
if ($layout) {
foreach ($layout->getCSSFiles(isRTL(), isMobile()) as $css) {
$returnJSON['CSSFiles'][] = $css;
}
}
}
echo printJSON($returnJSON);
exit;
$pageObject->body["begin"] .= GetBaseScriptsForPage(false);
$pageObject->fillSetCntrlMaps();
$pageObject->body['end'] .= '<script>';
$pageObject->body['end'] .= "window.controlsMap = ".my_json_encode($pageObject->controlsHTMLMap).";";
$pageObject->body['end'] .= "window.viewControlsMap = ".my_json_encode($pageObject->viewControlsHTMLMap).";";
$pageObject->body['end'] .= "window.settings = ".my_json_encode($pageObject->jsSettings).";";
$pageObject->body['end'] .= '</script>';
$pageObject->body["end"] .= "<script language=\"JavaScript\" src=\"".GetRootPathForResources("include/runnerJS/RunnerAll.js")."\"></script>\r\n";
$pageObject->addCommonJs();
$pageObject->body["end"] .= "<script>".$pageObject->PrepareJS()."</script>";
$xt->assignbyref("body",$pageObject->body);
$pageObject->display(GetTemplateName("webreport_users", "export"));
function ExportToExcel_old($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject)
{
global $cCharset;
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment;Filename=".GetTableURL($strTableName).".xls");
echo "<html>";
echo "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\">";
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=".$cCharset."\">";
echo "<body>";
echo "<table border=1>";
WriteTableData($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject);
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($pSet->getFieldType("IsActive"))) {
$class = ' rnr-field-number';
}
$row["IsActive_class"] = $class;
$rowinfo[] = $row;
if ($b) {
$rowinfo2[] = $row;
$b = false;
}
$data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc());
}
$xt->assign_loopsection("details_row", $rowinfo);
$xt->assign_loopsection("details_row_header", $rowinfo2);
// assign class for header
}
$returnJSON = array("success" => true);
$xt->load_template(GetTemplateName("GroupMaster", "detailspreview"));
$returnJSON["body"] = $xt->fetch_loaded();
if ($mode != "inline") {
$returnJSON["counter"] = postvalue("counter");
$layout = GetPageLayout(GoodFieldName($strTableName), 'detailspreview');
if ($layout) {
foreach ($layout->getCSSFiles(isRTL(), isMobile()) as $css) {
$returnJSON['CSSFiles'][] = $css;
}
}
}
echo printJSON($returnJSON);
exit;
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($pSet->getFieldType("coy_city"))) {
$class = ' rnr-field-number';
}
$row["coy_city_class"] = $class;
$rowinfo[] = $row;
if ($b) {
$rowinfo2[] = $row;
$b = false;
}
$data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc());
}
$xt->assign_loopsection("details_row", $rowinfo);
$xt->assign_loopsection("details_row_header", $rowinfo2);
// assign class for header
}
$returnJSON = array("success" => true);
$xt->load_template(GetTemplateName("company", "detailspreview"));
$returnJSON["body"] = $xt->fetch_loaded();
if ($mode != "inline") {
$returnJSON["counter"] = postvalue("counter");
$layout = GetPageLayout(GoodFieldName($strTableName), 'detailspreview');
if ($layout) {
foreach ($layout->getCSSFiles(isRTL(), isMobile()) as $css) {
$returnJSON['CSSFiles'][] = $css;
}
}
}
echo printJSON($returnJSON);
exit;
$layout->skins["fields"] = "fields";
$layout->blocks["top"][] = "fields";
$page_layouts["changepwd_success"] = $layout;
$layout->skinsparams = array();
$layout->skinsparams["empty"] = array("button" => "button1");
$layout->skinsparams["menu"] = array("button" => "button1");
$layout->skinsparams["hmenu"] = array("button" => "button1");
$layout->skinsparams["undermenu"] = array("button" => "button1");
$layout->skinsparams["fields"] = array("button" => "button1");
$layout->skinsparams["form"] = array("button" => "button1");
$layout->skinsparams["1"] = array("button" => "button1");
$layout->skinsparams["2"] = array("button" => "button1");
$layout->skinsparams["3"] = array("button" => "button1");
$pageObject->updatePageLayoutAndCSS('', 'success');
$xt->assign("body", true);
return $pageObject->display(GetTemplateName("", "changepwd_success"));
// return $xt->display for .net compatibility
}
}
} else {
$message = "Invalid password";
}
} else {
$xt->assign("backlink_attrs", "href=\"" . runner_htmlspecialchars($_SESSION["changepwd_referer"]) . "\"");
}
if ($message) {
$xt->assign("message", "<div class='message rnr-error'>" . $message . "</div>");
$xt->assign("message_block", true);
}
foreach ($changePwdFields as $fName) {
$parameters = array();
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($pSet->getFieldType("CompanyLastSyncDate"))) {
$class = ' rnr-field-number';
}
$row["CompanyLastSyncDate_class"] = $class;
$rowinfo[] = $row;
if ($b) {
$rowinfo2[] = $row;
$b = false;
}
$data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc());
}
$xt->assign_loopsection("details_row", $rowinfo);
$xt->assign_loopsection("details_row_header", $rowinfo2);
// assign class for header
}
$returnJSON = array("success" => true);
$xt->load_template(GetTemplateName("CompanyMaster", "detailspreview"));
$returnJSON["body"] = $xt->fetch_loaded();
if ($mode != "inline") {
$returnJSON["counter"] = postvalue("counter");
$layout = GetPageLayout(GoodFieldName($strTableName), 'detailspreview');
if ($layout) {
foreach ($layout->getCSSFiles(isRTL(), isMobile()) as $css) {
$returnJSON['CSSFiles'][] = $css;
}
}
}
echo printJSON($returnJSON);
exit;
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"));
}
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($pSet->getFieldType("l"))) {
$class = ' rnr-field-number';
}
$row["l_class"] = $class;
$rowinfo[] = $row;
if ($b) {
$rowinfo2[] = $row;
$b = false;
}
$data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc());
}
$xt->assign_loopsection("details_row", $rowinfo);
$xt->assign_loopsection("details_row_header", $rowinfo2);
// assign class for header
}
$returnJSON = array("success" => true);
$xt->load_template(GetTemplateName("BranchMaster", "detailspreview"));
$returnJSON["body"] = $xt->fetch_loaded();
if ($mode != "inline") {
$returnJSON["counter"] = postvalue("counter");
$layout = GetPageLayout(GoodFieldName($strTableName), 'detailspreview');
if ($layout) {
foreach ($layout->getCSSFiles(isRTL(), isMobile()) as $css) {
$returnJSON['CSSFiles'][] = $css;
}
}
}
echo printJSON($returnJSON);
exit;
}
});
</script>';
if ($_SESSION["back_to_menu"])
$xt->assign("back_to_menu", true);
else
$xt->assign("back_to_menu", false);
$xt->assign("wr_pagestylepath", $wr_pagestylepath);
$xt->assign("chart_block", true);
$xt->assign("chart_constructor", $show_dchart);
$xt->assign("load_flash_player", $load_flash_player);
if (!IsStoredProcedure($chrt_array['sql']))
$xt->assign("testAdvSearch", testAdvSearch($chrt_array['tables'][0]));
else
$xt->assign("testAdvSearch", false);
$chart_name_js = jsreplace(postvalue('cname'));
$xt->assign("chart_name_js", $chart_name_js);
$xt->assign("chart_title", runner_htmlspecialchars($chrt_array['title']));
$xt->assign("short_table_name", runner_htmlspecialchars($chrt_array['settings']['short_table_name']));
$xt->assign("short_table_name_js", jsreplace($chrt_array['settings']['short_table_name']));
$xt->assign("ext", "php");
$searchType = (!is_wr_project()) ? GetTableLink("dsearch") : GetTableLink(runner_htmlspecialchars($chrt_array['settings']['short_table_name']), "search");
$xt->assign("searchHref", "href='" . $searchType . "?cname=" . $chart_name_js . "'");
$templatefile = GetTemplateName("", "dchart");
$xt->display($templatefile);
?>
$inlineedit = EDIT_SIMPLE;
$xt = new Xtempl();
$id = postvalue("id");
if(intval($id)==0)
$id = 1;
// assign an id
$xt->assign("id", $id);
if($inlineedit == EDIT_INLINE)
$templatefile = GetTemplateName("webreport_users", "inline_edit");
else
$templatefile = GetTemplateName("webreport_users", "edit");
$keys = array();
$savedKeys = array();
$keysChanged = false;
$keys["id"] = postvalue("editid1");
$savedKeys["id"] = postvalue("editid1");
//array of params for classes
$params = array("pageType" => PAGE_EDIT);
$params["id"] = $id;
$params["keys"] = $keys;
$params['tName'] = $strTableName;
$params['xt'] = &$xt;
/**
* display error message
* @intellisense
*/
function runner_error_handler($errno, $errstr, $errfile, $errline)
{
global $strLastSQL;
if ($errno == 2048 || $errno == 8) {
return 0;
}
if ($errno == 8192) {
if ($errstr == "Assigning the return value of new by reference is deprecated") {
return 0;
}
if (strpos($errstr, "set_magic_quotes_runtime")) {
return 0;
}
}
if ($errno == 2) {
if (strpos($errstr, "Can't contact LDAP server")) {
return 0;
}
if (strpos($errstr, "Invalid credentials")) {
return 0;
}
}
if ($errno == 2 && strpos($errstr, "has been disabled for security reasons")) {
return 0;
}
if ($errno == 2 && strpos($errstr, "Data is not in a recognized format")) {
return 0;
}
if ($errno == 8 && !strncmp($errstr, "Undefined index", 15)) {
return 0;
}
if (strpos($errstr, "It is not safe to rely on the system's timezone settings.")) {
return 0;
}
if (strpos($errstr, "fopen(") === 0) {
return 0;
}
if ($errno == 2 && strpos($errstr, "facebook.com")) {
return 0;
}
if ($errno == 2 && strpos($errstr, "ldap") !== false) {
return 0;
}
// show error htm
if (!class_exists("Xtempl")) {
require_once getabspath("include/xtempl.php");
}
$xt = new Xtempl();
$xt->assign('errno', $errno);
$xt->assign('errstr', $errstr);
$url = $_SERVER["SERVER_NAME"] . $_SERVER["SCRIPT_NAME"];
if (array_key_exists("QUERY_STRING", $_SERVER)) {
$url .= "?" . runner_htmlspecialchars($_SERVER["QUERY_STRING"]);
}
$xt->assign('url', $url);
$xt->assign('errfile', $errfile);
$xt->assign('errline', $errline);
$sqlStr = isset($strLastSQL) ? runner_htmlspecialchars(substr($strLastSQL, 0, 1024)) : '';
$xt->assign('sqlStr', $sqlStr);
$debugInfoArr = parse_backtrace($errfile, $errline);
$xt->assign_loopsection('debugRow', $debugInfoArr);
$xt->displayPartial(GetTemplateName("", 'error'));
exit(0);
}
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($pSet->getFieldType("Fact_Salescol"))) {
$class = ' rnr-field-number';
}
$row["Fact_Salescol_class"] = $class;
$rowinfo[] = $row;
if ($b) {
$rowinfo2[] = $row;
$b = false;
}
$data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc());
}
$xt->assign_loopsection("details_row", $rowinfo);
$xt->assign_loopsection("details_row_header", $rowinfo2);
// assign class for header
}
$returnJSON = array("success" => true);
$xt->load_template(GetTemplateName("Fact_SalesTransaction", "detailspreview"));
$returnJSON["body"] = $xt->fetch_loaded();
if ($mode != "inline") {
$returnJSON["counter"] = postvalue("counter");
$layout = GetPageLayout(GoodFieldName($strTableName), 'detailspreview');
if ($layout) {
foreach ($layout->getCSSFiles(isRTL(), isMobile()) as $css) {
$returnJSON['CSSFiles'][] = $css;
}
}
}
echo printJSON($returnJSON);
exit;
{
if($(sort_order).val()>0)
return;
$(sort_order).show();
// count number of sort fields
var optionsCount=0;
// find the options available
$("td.sort_order select").each( function() {
var curVal=parseInt($(this).val());
if(curVal>0)
{
optionsCount++;
}
});
// set the max value
$(sort_order).val(optionsCount+1);
$(sort_order).trigger("change");
}
});
showNewRow();
});
</script>'."\r\n";
}
$xt->assign("chart_name_preview",$_SESSION['webcharts']['settings']['name']);
$xt->assign("b_includes", $b_includes);
$templatefile = GetTemplateName("", "webchart2");
$xt->display($templatefile);
?>
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"));
}
case "align" :
$templatefile = GetTemplateName("", "dreport3" . $preview);
break;
case "tabular" :
$templatefile = GetTemplateName("", "dreport6" . $preview);
break;
default :
$templatefile = GetTemplateName("", "dreport" . $preview);
break;
}
if ($cross_table == "true")
if (postvalue("edit"))
$templatefile = GetTemplateName("", "dreport5_style");
else
$templatefile = GetTemplateName("", "dreport5" . $preview);
if ($modePrint)
$templatefile = str_replace("report", "print", $templatefile);
if ($modePrint) {
if (@$_REQUEST["format"]) {
$xt->assign("stylesheetlink", false);
} else {
$xt->assign("stylesheetlink", true);
}
}
$xt->assign("report_name_preview", $_SESSION['webreports']['settings']['name']);
include('include/xtempl.php');
include('classes/runnerpage.php');
$xt = new Xtempl();
// id that used to add to controls names
if(postvalue("id"))
$id = postvalue("id");
else
$id = 1;
// for usual page show proccess
$mode = SEARCH_SIMPLE;
$templatefile = GetTemplateName("webreport_users", "search");
// for ajax query, used when page buffers new control
if(postvalue("mode")=="inlineLoadCtrl"){
$mode = SEARCH_LOAD_CONTROL;
}
$params = array();
$params["id"] = $id;
$params["mode"] = $mode;
$params['xt'] = &$xt;
$params['templatefile'] = $templatefile;
$params['shortTableName'] = 'webreport_users';
$params['origTName'] = $strOriginalTableName;
$params['sessionPrefix'] = $sessionPrefix;
}
elseif (postvalue('cname'))
{
$contents_block["begin"].='action="'.GetTableLink("dchart").'?cname='.runner_htmlspecialchars(rawurlencode(postvalue("cname"))).'" ';
}
$contents_block["begin"] .= 'name="editform"><input type="hidden" id="a" name="a" value="advsearch">';
$contents_block["end"] = '</form>';
$xt->assignbyref("contents_block",$contents_block);
$xt->assign("searchbutton_attrs", 'name="SearchButton" onclick="document.forms.editform.submit();"');
$xt->assign("resetbutton_attrs", 'onclick="return ResetControls();"');
$xt->assign("backbutton_attrs", "onclick=\"document.forms.editform.a.value='return'; document.forms.editform.submit();\"");
$xt->assign("conditions_block",true);
$xt->assign("search_button",true);
$xt->assign("reset_button",true);
$xt->assign("back_button",true);
$xt->assign("wr_pagestylepath", $wr_pagestylepath);
$xt->assign("dynamic", "true");
if (postvalue('rname')) {
$xt->assign("rname", postvalue('rname'));
}
if (postvalue('cname')) {
$xt->assign("cname", postvalue('cname'));
}
$templatefile = GetTemplateName("", "dsearch");
$xt->assign( "reportTitle", runner_htmlspecialchars( $xml_array['settings']['title'] ) );
$xt->display($templatefile);
?>
/**
* Set template file if it empty
* @intellisense
*/
function setTemplateFile()
{
if (!$this->templatefile) {
$this->templatefile = GetTemplateName($this->shortTableName, $this->pageType);
}
$this->xt->set_template($this->templatefile);
}
$xt->assignbyref("body",$pageObject->body);
if($globalEvents->exists("BeforeShowRemindPwd"))
$globalEvents->BeforeShowRemindPwd($xt,$pageObject->templatefile, $pageObject);
// submit on popup page
if (postvalue("onFly") == 2)
{
if(@$strMessage) {
$returnJSON['message'] = $strMessage;
}
if (($pageObject->isCaptchaOk == 0) && ($isUseCaptcha)) {
$returnJSON['message'] = "Invalid security code.";
}
if ($reminded) {
$pageObject->templatefile = GetTemplateName("", "remind_success");
$xt->assign("id",$id);
$xt->assign("footer",false);
$xt->assign("header",false);
$xt->assign("body",true);
$pageObject->displayAJAX($pageObject->templatefile, $id+1);
exit();
}
echo printJSON($returnJSON);
exit();
}
// load popup page
if (postvalue("onFly") == 1)
{
$xt->assign("message_block",true);
$result.="<table class=\"sql_result\" cellpadding=\"1\" cellspacing=\"1\" border=\"0\">";
$result.="<tr><thead><tr>".$res_head."</tr></thead>";
$result.="<tbody>".$res_body."</tbody>";
$result.="</tr></table>";
}
else
{
$total_rows=$i;
$xt->assign("res_head", $res_head);
$xt->assign("res_body", $res_body);
$xt->assign("sql_result_block", true);
$xt->assign("total_count", $total_rows);
}
}
}
else
{
$xt->assign("sql_message_block", true);
$result="<p>No records to display</p>";
}
}
if(postvalue("sql")=="makesql")
{
echo $result;
exit();
}
else
$templatefile = GetTemplateName("", "web_query");
$xt->display($templatefile);
?>
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"));
}
var svgSupported = window.SVGAngle != undefined;
var str="";
if (!svgSupported)
{
str = "<center>";
str += "' . "" . '<br /><br />";
str += "<a href=\\"http://www.adobe.com/go/getflashplayer\\"><img border=\\"0\\" src=\\"http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif\\" /></a><br />";
str += "</center>";
}
if (typeof(ActiveXObject) != "undefined") {
try { a = new ActiveXObject("ShockwaveFlash.ShockwaveFlash");d = a.GetVariable("$version"); }
catch (e) { d = false; }
if (!d) {
$("div.center_div").html( str );
}
} else if ((navigator.product == "Gecko" && window.find && !navigator.savePreferences)
|| (navigator.userAgent.indexOf("WebKit") != -1 || navigator.userAgent.indexOf("Konqueror") != -1))
{
div = $("div[id*=\'__chart_generated_container__\']");
if ( div[0] == undefined ) {
$("div.center_div").html( str );
} else {
$(div).appendTo("div.center_div");
}
}
</script>';
$xt->assign("wr_pagestylepath", $wr_pagestylepath);
$xt->assign("chart_constructor", $show_dchart);
$xt->assign("load_flash_player", $load_flash_player);
$templatefile = GetTemplateName("", "dchart_preview");
$xt->display($templatefile);
$layout->skins["toplinks"] = "empty";
$layout->blocks["top"][] = "toplinks";
$layout->containers["hmenu"] = array();
$layout->container_properties["hmenu"] = array();
$layout->containers["hmenu"][] = array("name" => "hmenu", "block" => "menu_block", "substyle" => 1);
$layout->skins["hmenu"] = "hmenu";
$layout->blocks["top"][] = "hmenu";
$page_layouts["Stock_Dashboard_dashboard"] = $layout;
$layout->skinsparams = array();
$layout->skinsparams["empty"] = array("button" => "button1");
$layout->skinsparams["menu"] = array("button" => "button1");
$layout->skinsparams["hmenu"] = array("button" => "button1");
$layout->skinsparams["undermenu"] = array("button" => "button1");
$layout->skinsparams["fields"] = array("button" => "button1");
$layout->skinsparams["form"] = array("button" => "button1");
$layout->skinsparams["1"] = array("button" => "button1");
$layout->skinsparams["2"] = array("button" => "button1");
$layout->skinsparams["3"] = array("button" => "button1");
$xt = new Xtempl();
$id = postvalue("id");
$id = $id != "" ? $id : 1;
//array of params for classes
$params = array();
$params["id"] = $id;
$params["xt"] =& $xt;
$params["tName"] = $strTableName;
$params["pageType"] = PAGE_DASHBOARD;
$params["templatefile"] = GetTemplateName("Stock_Dashboard", "dashboard");
$pageObject = new DashboardPage($params);
$pageObject->init();
$pageObject->process();
$inlineadd = ADD_MASTER;
elseif($onFly)
{
$inlineadd = ADD_ONTHEFLY;
$sessionPrefix = $strTableName."_add";
}
else
$inlineadd = ADD_SIMPLE;
if($inlineadd == ADD_INLINE)
{
$templatefile = GetTemplateName("webreport_users", "inline_add");
}
else
{
$templatefile = GetTemplateName("webreport_users", "add");
}
$id = postvalue("id");
if(intval($id)==0)
$id = 1;
//If undefined session value for mastet table, but exist post value master table, than take second
//It may be happen only when use dpInline mode on page add
if(!@$_SESSION[$sessionPrefix."_mastertable"] && postvalue("mastertable"))
$_SESSION[$sessionPrefix."_mastertable"] = postvalue("mastertable");
$xt = new Xtempl();
// assign an id
$xt->assign("id",$id);