require_once SOURCE_ROOT . '/classes/class.adminlogin.php';
require_once SOURCE_ROOT . '/classes/excelwriter.php';
$objAdminLogin = new AdminLogin();
$objAdminLogin->isValidAdmin();
$objSessionRedirectUrl = new SessionRedirectUrl();
$objClients = new Clients();
$objPaging = new Paging();
//$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']);
//$varLimit = $varPageStart.','.$_SESSION['sessAdminPagingLimit'];
$arrUsersFlds = array('pkClientID', 'ClientLoginID', 'ClientFirstName', 'ClientLastName', 'ClientPassword', 'ClientOrganizationName', 'ClientStreetAddress', 'ClientCity', 'ClientState', 'ClientZipCode', 'ClientPhoneNumber', 'ClientOrganizationType', 'ClientAddedDate', 'ClientModifiedDate', 'ClientApprovalStatus');
//$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']);
//$varLimit = $varPageStart.','.$_SESSION['sessAdminPagingLimit'];
//$arrUsersRecord = $objGeneral->getRecord(TABLE_CLIENTS, $arrUsersFlds, '');
//$NumberofRows = count($arrUsersRecord);
//$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessAdminPagingLimit']);
$arrUsersList = $objClients->getUsersList(TABLE_CLIENTS, $arrUsersFlds, $varLimit, '');
//print_r($arrproperty_surveyList);die;
$excel = new ExcelWriter("client_list.xls");
if ($excel == false) {
echo $excel->error;
}
$main_array = array("<b>Client ID</b>", "<b>E-mail ID</b>", "<b>First Name</b>", "<b>Last Name</b>", "<b>Password</b>", "<b>Organization Name</b>", "<b>Street Address</b>", "<b>City</b>", "<b>State</b>", "<b>Zip</b>", "<b>Phone</b>", "<b>Organization Type</b>", "<b>Date Added</b>", "<b>Date Modified</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++;
$objClients = new Clients();
$objPaging = new Paging();
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']);
$varLimit = $varPageStart . ',' . $_SESSION['sessAdminPagingLimit'];
$arrUsersFlds = array('pkClientID', 'ClientLoginID', 'ClientPassword', 'ClientOrganizationName', 'ClientStreetAddress', 'ClientCity', 'ClientState', 'ClientZipCode', 'ClientPhoneNumber', 'ClientEmailAddress', 'ClientOrganizationType', 'ClientAddedDate', 'ClientModifiedDate', 'ClientApprovalStatus');
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']);
$varLimit = $varPageStart . ',' . $_SESSION['sessAdminPagingLimit'];
if ($_GET['status']) {
$varWhere = 'ClientApprovalStatus = \'' . $_GET['status'] . '\'';
} else {
$varWhere = '';
}
$arrUsersRecord = $objGeneral->getRecord(TABLE_CLIENTS, $arrUsersFlds, $varWhere);
$NumberofRows = count($arrUsersRecord);
$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessAdminPagingLimit']);
$arrUsersList = $objClients->getUsersList(TABLE_CLIENTS, $arrUsersFlds, '', $varWhere);
$varStrContent = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Client 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" />
</head>
<body>
<form>
<fieldset style="border:2px solid #ccc;">
<legend>Client list</legend>
