<?php require_once '../common/config/config.inc.php'; require_once SOURCE_ROOT . 'classes/class.client.php'; require_once SOURCE_ROOT . 'classes/class.paging.php'; require_once SOURCE_ROOT . 'classes/class.sort.php'; 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;