/** * Static function for create list page * Read params from setting * Create object of class in accordance with mode displaying page * @param String strTableName * @param Array options */ static function &createListPage($strTableName, $options) { global $isGroupSecurity; $gSettings = new ProjectSettings($strTableName, $options['pageType']); $gQuery = $gSettings->getSQLQuery(); $params = $options; $params['tName'] = $strTableName; $params['origTName'] = $gSettings->getOriginalTableName(); $params['gPageSize'] = $gSettings->getInitialPageSize(); $params['gOrderIndexes'] = $gSettings->getOrderIndexes(); $params['gstrOrderBy'] = $gQuery->OrderByToSql(); $params['gsqlHead'] = $gQuery->HeadToSql(); $params['gsqlFrom'] = $gQuery->FromToSql(); $params['gsqlWhereExpr'] = $gQuery->WhereToSql(); $params['gsqlGroupBy'] = $gQuery->GroupByToSql(); $params['gsqlHaving'] = $gQuery->Having()->toSql($gQuery); $params['nSecOptions'] = $gSettings->getAdvancedSecurityType(); $params['nLoginMethod'] = GetGlobalData("nLoginMethod", 0); $params['recsPerRowList'] = isMobile() ? 1 : $gSettings->getRecordsPerRowList(); $params['mainTableOwnerID'] = $gSettings->getTableOwnerIdField(); $params['exportTo'] = $gSettings->hasExportPage(); $params['printFriendly'] = $gSettings->hasPrintPage(); $params['deleteRecs'] = $gSettings->hasDelete(); $params["isGroupSecurity"] = $isGroupSecurity; $params['arrKeyFields'] = $gSettings->getTableKeys(); $params["isUseInlineAdd"] = $gSettings->hasInlineAdd(); $params["isUseInlineEdit"] = $gSettings->hasInlineEdit(); $params["panelSearchFields"] = $gSettings->getPanelSearchFields(); $params['listGridLayout'] = $gSettings->getListGridLayout(); $params['createLoginPage'] = GetGlobalData("createLoginPage", false); $params['noRecordsFirstPage'] = $gSettings->noRecordsOnFirstPage(); $params['totalsFields'] = $gSettings->getTotalsFields(); $params['listAjax'] = $gSettings->ajaxBasedListPage(); $params['arrRecsPerPage'] = $gSettings->getRecordsPerPageArray(); $params['isScrollGridBody'] = $gSettings->getScrollGridBody(); $params['viewPDF'] = $gSettings->isViewPagePDF() || $gSettings->isPrinterPagePDF(); $params['audit'] = GetAuditObject($table); $params['listFields'] = array(); $allfields = $gSettings->getListFields(); foreach ($allfields as $f) { if (!$gSettings->appearOnListPage($f)) { continue; } $params['listFields'][] = array("fName" => $f, "goodFieldName" => GoodFieldName($f), "valueFieldName" => GoodFieldName($f) . "_value", "viewFormat" => $gSettings->getViewFormat($f), "editFormat" => $gSettings->getEditFormat($f)); } // choose class by mode if ($params["mode"] == LIST_SIMPLE) { $pageObject = new ListPage_Simple($params); } else { if ($params["mode"] == LIST_AJAX) { $pageObject = new ListPage_Ajax($params); } else { if ($params["mode"] == LIST_LOOKUP) { $pageObject = new ListPage_Lookup($params); } else { if ($params["mode"] == LIST_DETAILS || $params["mode"] == LIST_DASHDETAILS) { $pageObject = new ListPage_DPInline($params); } else { if ($params["mode"] == RIGHTS_PAGE) { $pageObject = new RightsPage($params); } else { if ($params["mode"] == MEMBERS_PAGE) { $pageObject = new MembersPage($params); } else { if ($params["mode"] == LIST_DASHBOARD) { $pageObject = new ListPage_Dashboard($params); } } } } } } } $pageObject->init(); return $pageObject; }
$viewContainer->isDetailsPreview = true; $b = true; $qResult = $pageObject->connection->query($strSQL); $data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc()); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["Grp_id"])); $keylink .= "&key2=" . runner_htmlspecialchars(rawurlencode(@$data["StockCode"])); $keylink .= "&key3=" . runner_htmlspecialchars(rawurlencode(@$data["Coy_Id"])); // Grp_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("Grp_id", $data, $keylink); $row["Grp_id_value"] = $value; $format = $pSet->getViewFormat("Grp_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($pSet->getFieldType("Grp_id"))) { $class = ' rnr-field-number'; } $row["Grp_id_class"] = $class; // StockCode -
function WRViewFormat($field, $table = "") { $pSet = new ProjectSettings($table); return $pSet->getViewFormat($field); }
/** * Static function for create list page * Read params from setting * Create object of class in accordance with mode displaying page */ function &createListPage($table, $options) { global $bSubqueriesSupported, $strTableName, $conn, $locale_info, $isGroupSecurity; $gSettings = new ProjectSettings($strTableName, $options['pageType']); $gQuery = $gSettings->getSQLQuery(); $params = array(); $params = $options; $params['origTName'] = $gSettings->getOriginalTableName(); $params['sessionPrefix'] = $strTableName; $params['tName'] = $table; $params['conn'] =& $conn; $params['gPageSize'] = $gSettings->getInitialPageSize(); $params['gOrderIndexes'] = $gSettings->getOrderIndexes(); $params['gstrOrderBy'] = $gQuery->OrderByToSql(); $params['gsqlHead'] = $gQuery->HeadToSql(); $params['gsqlFrom'] = $gQuery->FromToSql(); $params['gsqlWhereExpr'] = $gQuery->WhereToSql(); $params['gsqlGroupBy'] = $gQuery->GroupByToSql(); $params['gsqlHaving'] = $gQuery->Having()->toSql($gQuery); $params['locale_info'] =& $locale_info; $params["subQueriesSupp"] = $bSubqueriesSupported; $params['nSecOptions'] = $gSettings->getAdvancedSecurityType(); $params['nLoginMethod'] = GetGlobalData("nLoginMethod", 0); $params['recsPerRowList'] = $gSettings->getRecordsPerRowList(); $params['dbType'] = GetGlobalData("dbType", 0); $params['mainTableOwnerID'] = $gSettings->getTableOwnerIdField(); $params['moveNext'] = $gSettings->useMoveNext(); $params['exportTo'] = $gSettings->hasExportPage(); $params['printFriendly'] = $gSettings->hasPrintPage(); $params['deleteRecs'] = $gSettings->hasDelete(); $params['rowHighlite'] = $gSettings->highlightRows(); $params["isGroupSecurity"] = $isGroupSecurity; $params['arrKeyFields'] = $gSettings->getTableKeys(); $params["isUseInlineAdd"] = $gSettings->hasInlineAdd(); $params["isUseInlineEdit"] = $gSettings->hasInlineEdit(); $params["isUseInlineJs"] = $params["isUseInlineAdd"] || $params["isUseInlineEdit"]; $params["panelSearchFields"] = $gSettings->getPanelSearchFields(); $params['isVerLayout'] = $gSettings->isVerticalLayoutList(); $params['isDisplayLoading'] = $gSettings->displayLoading(); $params['createLoginPage'] = GetGlobalData("createLoginPage", false); $params['subQueriesSupAccess'] = $gSettings->tableSupportsSubqueries(); $params['noRecordsFirstPage'] = $gSettings->noRecordsOnFirstPage(); $params['totalsFields'] = $gSettings->getTotalsFields(); $params['listIcons'] = $gSettings->iconsOnList(); $params['edit'] = $gSettings->hasEditPage(); $params['inlineEdit'] = $gSettings->hasInlineEdit(); $params['iCopy'] = $gSettings->hasCopyPage(); $params['iView'] = $gSettings->hasViewPage(); $params['listAjax'] = $gSettings->ajaxBasedListPage(); $params['arrRecsPerPage'] = $gSettings->getRecordsPerPageArray(); $params['isScrollGridBody'] = $gSettings->getScrollGridBody(); $params['audit'] = GetAuditObject($table); $params['listFields'] = array(); $allfields = $gSettings->getListFields(); foreach ($allfields as $f) { if (!$gSettings->appearOnListPage($f)) { continue; } $params['listFields'][] = array("fName" => $f, "goodFieldName" => GoodFieldName($f), "valueFieldName" => GoodFieldName($f) . "_value", "viewFormat" => $gSettings->getViewFormat($f), "editFormat" => $gSettings->getEditFormat($f)); } // choose class by mode if ($params["mode"] == LIST_SIMPLE) { $pageObject = new ListPage_Simple($params); } else { if ($params["mode"] == LIST_AJAX) { $pageObject = new ListPage_Ajax($params); } else { if ($params["mode"] == LIST_LOOKUP) { $pageObject = new ListPage_Lookup($params); } else { if ($params["mode"] == LIST_DETAILS) { $pageObject = new ListPage_DPInline($params); } else { if ($params["mode"] == RIGHTS_PAGE) { $pageObject = new RightsPage($params); } else { if ($params["mode"] == MEMBERS_PAGE) { $pageObject = new MembersPage($params); } } } } } } return $pageObject; }
$pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); $viewContainer->isDetailsPreview = true; $b = true; $qResult = $pageObject->connection->query($strSQL); $data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc()); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["Groupid"])); // Groupid - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("Groupid", $data, $keylink); $row["Groupid_value"] = $value; $format = $pSet->getViewFormat("Groupid"); $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($pSet->getFieldType("Groupid"))) { $class = ' rnr-field-number'; } $row["Groupid_class"] = $class; // GroupName -
$pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); $viewContainer->isDetailsPreview = true; $b = true; $qResult = $pageObject->connection->query($strSQL); $data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc()); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["ID"])); // ID - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("ID", $data, $keylink); $row["ID_value"] = $value; $format = $pSet->getViewFormat("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($pSet->getFieldType("ID"))) { $class = ' rnr-field-number'; } $row["ID_class"] = $class; // GroupID -
$viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); $viewContainer->isDetailsPreview = true; $b = true; $qResult = $pageObject->connection->query($strSQL); $data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc()); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["grp_id"])); $keylink .= "&key2=" . runner_htmlspecialchars(rawurlencode(@$data["coy_id"])); // grp_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("grp_id", $data, $keylink); $row["grp_id_value"] = $value; $format = $pSet->getViewFormat("grp_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($pSet->getFieldType("grp_id"))) { $class = ' rnr-field-number'; } $row["grp_id_class"] = $class; // coy_id -
$viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); $viewContainer->isDetailsPreview = true; $b = true; $qResult = $pageObject->connection->query($strSQL); $data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc()); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; $keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["GroupID"])); $keylink .= "&key2=" . runner_htmlspecialchars(rawurlencode(@$data["CompanyID"])); // GroupID - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("GroupID", $data, $keylink); $row["GroupID_value"] = $value; $format = $pSet->getViewFormat("GroupID"); $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($pSet->getFieldType("GroupID"))) { $class = ' rnr-field-number'; } $row["GroupID_class"] = $class; // CompanyID -
require_once getabspath('classes/controls/ViewControlsContainer.php'); $pSet = new ProjectSettings($strTableName, PAGE_LIST); $viewContainer = new ViewControlsContainer($pSet, PAGE_LIST); $viewContainer->isDetailsPreview = true; $b = true; $qResult = $pageObject->connection->query($strSQL); $data = $cipherer->DecryptFetchedArray($qResult->fetchAssoc()); while ($data && $recordsCounter < $display_count) { $recordsCounter++; $row = array(); $keylink = ""; // BranchCloudFolder - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("BranchCloudFolder", $data, $keylink); $row["BranchCloudFolder_value"] = $value; $format = $pSet->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($pSet->getFieldType("BranchCloudFolder"))) { $class = ' rnr-field-number'; } $row["BranchCloudFolder_class"] = $class; // BranchLastSyncDate - Short Date