/**
 * Write sheet 'DC Inventory <timestamp>'
 *
 * @param array $DProps
 * @param PHPExcel $objPHPExcel
 * @param string $thisDate
 * @return (array|array|boolean)[] DC statistics and rack inventory
 */
function writeDCInventory($DProps, $objPHPExcel, $thisDate)
{
    global $sessID;
    $wsKind = 'DC Inventory';
    $worksheet = $objPHPExcel->getActiveSheet();
    $objPHPExcel->setActiveSheetIndex(0);
    JobQueue::updateStatus($sessID, __("Computing DC Inventory"));
    setWorksheetProperties($worksheet, $wsKind, $DProps, $thisDate);
    writeWSHeader($worksheet, $wsKind, $DProps[$wsKind]);
    ReportStats::get()->report('Info', $wsKind . ' - Header set');
    list($DCStats, $invData, $Rack_Inv, $limitedUser) = computeSheetBodyDCInventory($DProps);
    ReportStats::get()->report('Info', $wsKind . ' - computed body');
    JobQueue::updateStatus($sessID, __("Writing Inventory to Spreadsheet"));
    JobQueue::updatePercentage($sessID, 50);
    writeDCInvContent($worksheet, $DProps[$wsKind], $invData);
    ReportStats::get()->report('Info', $wsKind . ' - write body');
    JobQueue::updateStatus($sessID, __("Formatting Spreadsheet"));
    formatWSColumns($worksheet, $DProps[$wsKind]['Columns']);
    $worksheet->setAutoFilter($worksheet->calculateWorksheetDimension());
    return array($DCStats, $Rack_Inv, $limitedUser);
}
Esempio n. 2
0
/**
 * Write sheet 'DC Inventory <timestamp>'
 *
 * @param array $DProps
 * @param PHPExcel $objPHPExcel
 * @param string $thisDate
 * @return (array|array|boolean)[] DC statistics and rack inventory
 */
function writeDCInventory($DProps, $objPHPExcel, $thisDate)
{
    $wsKind = 'DC Inventory';
    $worksheet = $objPHPExcel->getActiveSheet();
    $objPHPExcel->setActiveSheetIndex(0);
    setWorksheetProperties($worksheet, $wsKind, $DProps, $thisDate);
    writeWSHeader($worksheet, $wsKind, $DProps[$wsKind]);
    ReportStats::get()->report('Info', $wsKind . ' - Header set');
    list($DCStats, $invData, $Rack_Inv, $limitedUser) = computeSheetBodyDCInventory($DProps);
    ReportStats::get()->report('Info', $wsKind . ' - computed body');
    writeDCInvContent($worksheet, $DProps[$wsKind], $invData);
    ReportStats::get()->report('Info', $wsKind . ' - write body');
    formatWSColumns($worksheet, $DProps[$wsKind]['Columns']);
    $worksheet->setAutoFilter($worksheet->calculateWorksheetDimension());
    return array($DCStats, $Rack_Inv, $limitedUser);
}