/**
* 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
