$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++) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $generalListCertificateModalTable2Title[$i - 25])->setCellValue('B' . $i, $generalListCertificateModalTable2Content[$i - 25]);
}
/* END-SPEEDTEST CPE CABLEADO */
/* START-HABITACIONES */
for ($i = 3; $i < count($Locaciones) + 3; $i++) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D' . $i, $Locaciones[$i - 3]);
$dispositive = "Dispositivo";
break;
default:
$dispositive = "Dispositive";
break;
}
$i = populateTableCellsWithoutSubtitle($objPHPExcel, $i + 2, $dispositive, $Sniffer, 0, PHPExcel_Cell::stringFromColumnIndex($x), PHPExcel_Cell::stringFromColumnIndex($x + 1));
// prueba speedtest
$Prueba_ST = getArrayObjectPrueba_ST($val["Pruebas_Wifi"][0]);
$start = PHPExcel_Cell::stringFromColumnIndex($x) . ($i + 1);
$end = PHPExcel_Cell::stringFromColumnIndex($x + 1) . ($i + 1);
$merge = $start . ":" . $end;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells($merge);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($x, $i + 1, $generalListCertificateTitles[7]);
$objPHPExcel->getActiveSheet()->getStyle($start)->applyFromArray(getPropertiesHeaderText());
$i = populateTableCells($objPHPExcel, $i + 2, $generalListCertificateModalTable6Title, $Prueba_ST, 0, PHPExcel_Cell::stringFromColumnIndex($x), PHPExcel_Cell::stringFromColumnIndex($x + 1));
if (isset($value["Habitacion"]["Redes_Visibles"])) {
// redes visibles
$Redes_Visibles = getArrayObjectRedes_Visibles($val["Pruebas_Wifi"][0]);
$start = PHPExcel_Cell::stringFromColumnIndex($x) . ($i + 1);
$end = PHPExcel_Cell::stringFromColumnIndex($x + 1) . ($i + 1);
$merge = $start . ":" . $end;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells($merge);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($x, $i + 1, $generalListCertificateTitles[8]);
$objPHPExcel->getActiveSheet()->getStyle($start)->applyFromArray(getPropertiesHeaderText());
$i = populateTableCellsWithoutSubtitle($objPHPExcel, $i + 2, "SSID", $Redes_Visibles, 0, PHPExcel_Cell::stringFromColumnIndex($x), PHPExcel_Cell::stringFromColumnIndex($x + 1));
}
}
}
}
// $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $z, $c, true)->getStyle()->applyFromArray($styleArray);