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';