/** * Generate new workbook 'DC_Statistics_<timestamp>.xlsx' * * @param array $DProps * @param PHPExcel $objPHPExcel * @param string $thisDate */ function writeExcelReport(&$DProps, $objPHPExcel, $thisDate) { ReportStats::get()->report('Info', 'User: '******'Doc']['User'] . ' Version: ' . $DProps['Doc']['version']); // Crude status reporting $config = new Config(); $config->Config(); addColumnIndices($DProps); // Generate new workbook 'DC_Statistics_<timestamp>.xlsx' setDocumentProperties($objPHPExcel, $thisDate, $config->ParameterArray['OrgName'], $DProps); list($DCStats, $Rack_Inv, $limitedUser) = writeDCInventory($DProps, $objPHPExcel, $thisDate); ReportStats::get()->report('Info', 'DC Inventory'); if (!$limitedUser) { writeDCStatsSummary($DProps, $objPHPExcel, $DCStats, $thisDate); ReportStats::get()->report('Info', 'DC Stats'); } writeRackInventory($DProps, $objPHPExcel, $Rack_Inv, $thisDate); ReportStats::get()->report('Info', 'Rack Inventory'); writeFrontPage($DProps, $config, $objPHPExcel, $thisDate); ReportStats::get()->report('Info', 'Front Page'); JobQueue::updateStatus(session_id(), "Preparing to transmit file"); }