<?php require_once '../common/config/config.inc.php'; require_once SOURCE_ROOT . 'classes/class.sort.php'; require_once SOURCE_ROOT . 'classes/class.paging.php'; require_once SOURCE_ROOT . 'classes/class.category.php'; $_SESSION['sessCategoryRedirectURL'] = ''; if ($_SERVER['QUERY_STRING'] != '') { $_SESSION['sessCategoryRedirectURL'] = $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING']; } else { $_SESSION['sessCategoryRedirectURL'] = $_SERVER['PHP_SELF']; } $objCategory = new Category(); $objPaging = new Paging(); if (isset($_REQUEST['frmSearchPressed']) && $_REQUEST['frmSearchPressed'] == 'Yes') { $varSearchWhr .= $objCategory->getCategorySearchKeyWhere($_GET); } $arrCategoryFlds = array('pkCategoryID', 'CategoryName', 'CategoryStatus', 'CategoryDateAdded', 'CategoryDateModified', 'count(pkProductID) as ProductCount'); $varPageStart = $objPaging->getPageStartLimit($_GET['page'], ADMIN_PAGE_RECORD_SIZE); $varLimit = $varPageStart . ',' . ADMIN_PAGE_RECORD_SIZE; if ($_GET['sortBy'] != '' && $_GET['orderBy'] != '') { $varSortBy = $_GET['sortBy'] . ' ' . $_GET['orderBy']; } else { $varSortBy = 'CategoryDateAdded DESC'; } $varTable = TABLE_CATEGORIES . ' LEFT JOIN ' . TABLE_PRODUCTS . ' ON ' . TABLE_CATEGORIES . '.pkCategoryID = ' . TABLE_PRODUCTS . '.fkCategoryID'; $varSearchWhr = '1' . $varSearchWhr . ' GROUP BY pkCategoryID'; $arrCategoryList = $objGeneral->getRecord($varTable, $arrCategoryFlds, $varSearchWhr, $varSortBy, $varLimit); $arrCategoryListAll = $objGeneral->getRecord($varTable, $arrCategoryFlds, $varSearchWhr); $NumberofRows = count($arrCategoryListAll); $varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, ADMIN_PAGE_RECORD_SIZE);