/**
* 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");
}
