<?php
require_once 'common/config/config.inc.php';
require_once SOURCE_ROOT . 'classes/class.paging.php';
require_once SOURCE_ROOT . 'classes/class.category.php';
//CREATING THE CLASS OBJECTS FOR INCLUDING CLASS FILES
$objCategory = new Category();
$objPaging = new Paging();
//CREATING THE FIELDS ARRAYS TO SHOW & TABLE (IF JOIN OR OTHER CONDITION EXISTS) & A WHERE CONDITION
if (isset($_REQUEST['frmSearchPressed']) && $_REQUEST['frmSearchPressed'] == 'Yes') {
$varSearchWhr .= $objCategory->getCategoryFrontEndSearchKey($_GET);
}
//Listing product by category
if ($_GET['categoryID']) {
$varSearchWhr .= $objCategory->getCategoryFrontEndSearchKey($_GET);
}
$arrProductFlds = array('pkProductID', 'fkCategoryID', 'ProductName', 'ProductCode', 'ProductDescription', 'ProductSpecifications', 'ProductCost', 'ProductActualCost', 'ProductQuantity', 'ProductStatus', 'ProductImage');
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], SITE_RECORD_LIMIT);
$varLimit = $varPageStart . ',' . SITE_RECORD_LIMIT;
$varSearchWhr = ' 1 ' . $varSearchWhr . ' AND ProductStatus = \'Active\'';
$arrProductList = $objGeneral->getRecord(TABLE_PRODUCTS, $arrProductFlds, $varSearchWhr, '', $varLimit);
$arrProduct = $objGeneral->getRecord(TABLE_PRODUCTS, $arrProductFlds, $varSearchWhr);
//code for paging
$NumberofRows = count($arrProduct);
$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, SITE_RECORD_LIMIT);
//end for paging
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US">
