<?php
require_once "./includes/initialize.php";
if (isset($_POST['submit'])) {
$bdm = bdm::find();
$date = date('y-m-d', strtotime($_POST['date1']));
$date1 = date('y-m-d', strtotime($_POST['date2']));
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Europe/London');
if (PHP_SAPI == 'cli') {
die('This example should only be run from a Web Browser');
}
/** Include PHPExcel */
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
$i = 2;
$col_index = array('E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', 'BDM NAME')->setCellValue('B1', 'ZONE')->setCellValue('C1', 'ASM NAME')->setCellValue('D1', 'ZSM NAME');
if (!empty($bdm)) {
foreach ($bdm as $bdms) {
$total = ho::list_rx($date, $date1, $bdms->bdm_id);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $bdms->bdm_name)->setCellValue('B' . $i, $bdms->zone)->setCellValue('C' . $i, $bdms->asm_name)->setCellValue('D' . $i, $bdms->zsm_name);
$j = 0;
foreach ($total as $value) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($col_index[$j] . '1', $value->mydate)->setCellValue($col_index[$j] . $i, $value->rx_count);
$j++;
}
