$generalListCertificateModalTable2Title = array("Localização CPE", "Nac Carr.", "Nac Desc.", "Int Carr.", "Int Desc.");
$generalListCertificateModalTable4Title = array("Localização", "Nac Carr.", "Nac Desc.", "Int Carr.", "Int Desc.", "Sinal");
$generalListCertificateModalTable5Title = array("Tipo", "Modelo", "Mac", "Localização", "Aceitar proposta localização", "Estado");
$generalListCertificateSheetDetailCertificateWifi1Title = array("Nac Carr.", "Nac Desc.", "Int Carr.", "Int Desc.");
$generalListCertificateSheetDetailCertificateWifi2Table1Title = array("Spe", "Avg", "Tim", "Siz", "Tlo", "Tco", "Tpr", "Tst", "URL");
$generalListCertificateSheetDetailCertificateWifi3Title = array("Enviados", "Recebidos", "Perdidos", "Média", "Mínimo", "Máximo", "Jitter", "URL");
$generalListCertificateSheetDetailCertificateWifi4Title = array("N°", "Dispositivo");
$generalListCertificateSheetDetailCertificateWifi5Title = array("Int Desc.", "Int Carr.", "Nac Desc.", "Nac Carr.");
$generalListCertificateSheetDetailCertificateWifi6Title = array("N°", "Ssid");
$generalListCertificateSheetDetailCertificateWifi7Title = array("Ssid", "Segurança", "Canal", "Origem dispositivo");
break;
}
loadExcel();
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
setDocumentProperties($objPHPExcel);
populateTableHead($objPHPExcel, 0, "A2:B2", "A2", $generalListCertificateTitles[0]);
populateTableHead($objPHPExcel, 0, "D2:D2", "D2", $generalListCertificateTitles[2]);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
populateTableHead($objPHPExcel, 0, "F2:K2", "F2", $generalListCertificateTitles[3]);
//populateTableHead($objPHPExcel,"F12:J12","F12",$generalListCertificateTitles[5]);
$i = populateTableCells($objPHPExcel, $generalListCertificateModalTable1Title, $generalListCertificateModalTable1Content, 0, "A", "B");
populateTableHead($objPHPExcel, 0, "A" . ($i + 1) . ":B" . ($i + 1), "A" . ($i + 1), $generalListCertificateTitles[1]);
//$i=populateTableCells($objPHPExcel,$generalListCertificateModalTable2Title,$generalListCertificateModalTable2Content);
//populateTableHead($objPHPExcel,"A".($i+1).":B".($i+1),"A".($i+1),$generalListCertificateTitles[2]);
$objPHPExcel->getActiveSheet()->getStyle("A3:A22")->applyFromArray(getPropertiesLateralLeftText());
$objPHPExcel->getActiveSheet()->getStyle("A25:A29")->applyFromArray(getPropertiesLateralLeftText());
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
/* START-SPEEDTEST CPE CABLEADO */
for ($i = 25; $i < count($generalListCertificateModalTable2Title) + 25; $i++) {
/**
* 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");
}
