$objNiches = new Niches();
$objClients = new Clients();
$objPaging = new Paging();
$varPage = $_GET['page'];
if ($varPage == '') {
$varPage = 0;
}
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']);
$varLimit = $varPageStart . ',' . $_SESSION['sessAdminPagingLimit'];
$arrNichesFlds = array('clients.ClientLoginID', 'pkNicheID', 'fkClientID', 'NicheTitle', 'NicheFirstName', 'NicheMiddleName', 'NicheMaidenName', 'NicheLastName', 'NicheStreetAddress', 'NicheCity', 'NicheState', 'NicheZipCode', 'NichePhoneNumber', 'NicheEmailAddress', 'NicheDatePurchase', 'NicheExtra1', 'NicheExtra2', 'NicheAddedDate', 'NicheModifiedDate', 'NicheStatus');
/*$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']);
$varLimit = $varPageStart.','.$_SESSION['sessAdminPagingLimit'];*/
$arrNichesRecord = $objGeneral->getRecord("niches JOIN clients ON niches.fkClientID = clients.pkClientID", $arrNichesFlds, '');
$NumberofRows = count($arrNichesRecord);
$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessAdminPagingLimit']);
$arrNichesList = $objNiches->getNichesList("niches JOIN clients ON niches.fkClientID = clients.pkClientID", $arrNichesFlds, $varLimit, '');
?>
<!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 Niches Listing</title>
<link href="css/menu.css" rel="stylesheet" type="text/css" />
<link href="css/common.css" rel="stylesheet" type="text/css" />
<link href="css/form.css" rel="stylesheet" type="text/css" />
<link href="css/tables.css" rel="stylesheet" type="text/css" />
<!--[if gte IE 5.5]>
<script language="JavaScript" src="js/ie.js" type="text/JavaScript"></script>
<![endif]-->
<script language="javascript" src="js/validate.js" type="text/javascript"></script>
</head>
$objClientLogin = new ClientsLogin();
$objClientLogin->isValidClients();
$objSessionRedirectUrl = new SessionRedirectUrl();
$objNiches = new Niches();
$objPaging = new Paging();
$varClientID = $_SESSION['sessClientID'];
$varWhere = "1 AND fkClientID=" . $varClientID;
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessClientPagingLimit']);
$varLimit = $varPageStart . ',' . $_SESSION['sessClientPagingLimit'];
$arrNichesFlds = array('pkNicheID', 'NicheTitle', 'NicheFirstName', 'NicheCity', 'NicheEmailAddress', 'NicheDatePurchase', 'NicheStatus');
$arrNichesRecord = $objGeneral->getRecord(TABLE_NICHES, $arrNichesFlds, $varWhere);
$arrNichesLocFlds = array('fkNicheID');
$arrNichesLocRecord = $objGeneral->getRecord(TABLE_NICHE_LOCATIONS, $arrNichesLocFlds, '');
$NumberofRows = count($arrNichesRecord);
$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessClientPagingLimit']);
$arrNichesList = $objNiches->getNichesList(TABLE_NICHES, $arrNichesFlds, $varLimit, $varWhere);
$excel = new ExcelWriter("niches_list.xls");
if ($excel == false) {
echo $excel->error;
}
$main_array = array('<b>Niche ID</b>', '<b>Niche Title</b>', '<b>First Name</b>', '<b>City</b>', '<b>Email Address</b>', '<b>Date Purchase</b>', '<b>Status</b>');
$columnTitles = array_values($main_array);
$numColumns = count($columnTitles);
// $row += 2;
// $excel->writeCol('<b>Total Products<b>');
// $excel->writeCol(count($arrproperty_surveyList));
$row++;
$arrSeparator = array_fill(0, 24, ' ');
$excel->writeLine($arrSeparator);
$row++;
$arrSeparator = array_fill(0, 24, ' ');
require_once SOURCE_ROOT . 'classes/class.client.php';
$objClientLogin = new ClientsLogin();
$objClientLogin->isValidClients();
$objSessionRedirectUrl = new SessionRedirectUrl();
$objNiches = new Niches();
$objPaging = new Paging();
$objUrns = new Urns();
$varClientID = $_SESSION['sessClientID'];
$varWhere = "1 AND fkClientID=" . $varClientID;
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessClientPagingLimit']);
$varLimit = $varPageStart . ',' . '5';
$arrNichesFlds = array('pkNicheID', 'fkClientID', 'NicheTitle', 'NicheFirstName', 'NicheLastName', 'NicheCity', 'NicheEmailAddress', 'NicheDatePurchase', 'NicheStatus');
$arrNichesRecord = $objGeneral->getRecord(TABLE_NICHES, $arrNichesFlds, $varWhere);
$NumberofRows = count($arrNichesRecord);
$varClientID = "1 AND fkClientID= " . $varClientID;
$arrNichesList = $objNiches->getNichesList(TABLE_NICHES, $arrNichesFlds, $varLimit, $varClientID);
$arrUrnsFlds = array('pkUrnID', 'fkNicheID', 'fkClientID', 'UrnTitle', 'UrnFirstName', 'UrnLastName', 'Public', 'UrnSuffix', 'UrnAddedDate', 'UrnAddress');
$arrUrnsRecord = $objGeneral->getRecord(TABLE_URNS, $arrUrnsFlds, $varWhere);
$arrUrnsList = $objUrns->getUrnsList(TABLE_URNS, $arrUrnsFlds, $varLimit, $varClientID);
?>
<!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=utf-8" />
<title>Admin Welcome Page</title>
<link href="css/menu.css" rel="stylesheet" type="text/css" />
<link href="css/common.css" rel="stylesheet" type="text/css" />
<link href="css/form.css" rel="stylesheet" type="text/css" />
<link href="css/tables.css" rel="stylesheet" type="text/css" />
<!--[if gte IE 5.5]>
<script language="JavaScript" src="js/ie.js" type="text/JavaScript"></script>
