require_once SOURCE_ROOT . 'classes/class.client.php';
require_once SOURCE_ROOT . 'classes/class.clients_login.php';
require_once SOURCE_ROOT . '/classes/excelwriter.php';
$objClientLogin = new ClientsLogin();
$objClientLogin->isValidClients();
$objSessionRedirectUrl = new SessionRedirectUrl();
$objUrns = new Urns();
$objPaging = new Paging();
$varClientID = $_SESSION['sessClientID'];
$varWhere = "1 AND urns.fkClientID=" . $varClientID . " AND niches.fkClientID =" . $varClientID;
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessClientPagingLimit']);
$varLimit = $varPageStart . ',' . $_SESSION['sessClientPagingLimit'];
$arrUrnsFlds = array('pkUrnID', 'fkNicheID', 'NicheTitle', 'urns.fkClientID', 'UrnTitle', 'UrnFirstName', 'UrnLastName', 'Public', 'UrnSuffix', 'UrnAddedDate', 'UrnTagNumber');
$arrUrnsRecord = $objGeneral->getRecord('niches JOIN urns ON niches.pkNicheID = urns.fkNicheID', $arrUrnsFlds, $varWhere);
$NumberofRows = count($arrUrnsRecord);
$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessClientPagingLimit']);
$arrUrnsList = $objUrns->getUrnsList('niches JOIN urns ON niches.pkNicheID = urns.fkNicheID', $arrUrnsFlds, $varLimit, $varWhere);
$excel = new ExcelWriter("urns_list.xls");
if ($excel == false) {
echo $excel->error;
}
$main_array = array('<b>Urn ID</b>', '<b>Niche ID</b>', '<b>Niche Title</b>', '<b>Client ID</b>', '<b>Urn Title</b>', '<b>First Name</b>', '<b>Last Name</b>', '<b>Public</b>', '<b>Suffix</b>', '<b>Added Date</b>', '<b>Tag Number</b>');
$columnTitles = array_values($main_array);
$numColumns = count($columnTitles);
$row++;
$arrSeparator = array_fill(0, 24, ' ');
$excel->writeLine($arrSeparator);
$row++;
$arrSeparator = array_fill(0, 24, ' ');
$excel->writeLine($arrSeparator);
$row++;
if ($_SERVER['QUERY_STRING'] != '') {
$_SESSION['sessTaxRedirectUrl'] = $_SERVER['PHP_SELF'] . '?' . $_SERVER['QUERY_STRING'];
} else {
$_SESSION['sessTaxRedirectUrl'] = $_SERVER['PHP_SELF'];
}
// CREATING THE FIELDS ARRAYS TO SHOW & TABLE (IF JOIN OR OTHER CONDITION EXISTS) & A WHERE CONDITION
$arrTaxDiscountFlds = array('pkTaxDiscountID', 'TaxDiscountType', 'TaxDiscountName', 'TaxDiscountValue', 'TaxDiscountDateAdded', 'TaxDiscountDateModified', 'TaxDiscountStatus');
// GET THE SEARCHING CONDITION ON THE SPECIFIC SEARCHING
$varSearchWhere = $objTaxDiscount->getSearchKeyWhere($_GET);
//applied the paging
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], ADMIN_PAGE_RECORD_SIZE);
$varLimit = $varPageStart . ',' . ADMIN_PAGE_RECORD_SIZE;
$varTaxDiscountClm = 'pkTaxDiscountID';
$varSearchWhr = $varSearchWhere;
$NumberofRows = $objDatabase->getNumRows(TABLE_TAX_DISCOUNTS, $varTaxDiscountClm, $varSearchWhr);
$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, ADMIN_PAGE_RECORD_SIZE);
$arrTaxDiscountList = $objTaxDiscount->getTaxDiscountRecord(TABLE_TAX_DISCOUNTS, $arrTaxDiscountFlds, $varLimit, $varSearchWhr);
?>
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Admin Product Listing</title>
<link href="css/menu.css" rel="stylesheet" type="text/css" />
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">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>
<?php
if ($_GET['categoryID'] != '') {
echo 'Products';
} else {
echo 'Search Result';
