PHP Category::getCategorySearchKeyWhere Examples

Example #1

File: category_list_uil.php Project: saurabhs4/demoshop

<?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);