$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); // $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true); // $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); // $objPHPExcel->getActiveSheet()->getColumnDimension(0)->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex($sheetIndex)->getStyle("D3:D10")->applyFromArray(getPropertiesLateralLeftText()); $Sniffer = getArrayObjectSniffer($data["Extensores"][$i - $x]["Pruebas_Wifi"][0]["Habitacion"]["Sniffer"]); populateTableHead($objPHPExcel, $sheetIndex, "G2:H2", "G2", $generalListCertificateSheetWifiTitles[2]); for ($i1 = 3; $i1 < count($Sniffer) + 3; $i1++) { $objPHPExcel->setActiveSheetIndex($sheetIndex)->setCellValue("G" . $i1, "Dispositivo")->setCellValue("H" . $i1, $Sniffer[$i1 - 3]); } $objPHPExcel->setActiveSheetIndex($sheetIndex)->getStyle("G3:G" . ($i1 - 1))->applyFromArray(getPropertiesLateralLeftText()); $objPHPExcel->setActiveSheetIndex($sheetIndex)->getColumnDimension('G')->setAutoSize(true); $Prueba_ST = getArrayObjectPrueba_ST($data["Extensores"][$i - $x]["Pruebas_Wifi"][0]["Habitacion"]["Prueba_ST"]); populateTableHead($objPHPExcel, $sheetIndex, "J2:K2", "J2", $generalListCertificateSheetWifiTitles[3]); for ($i1 = 3; $i1 < count($Prueba_ST) + 3; $i1++) { $objPHPExcel->setActiveSheetIndex($sheetIndex)->setCellValue("J" . $i1, $generalListCertificateSheetDetailCertificateWifi5Title[$i1 - 3])->setCellValue("K" . $i1, $Prueba_ST[$i1 - 3]); } $objPHPExcel->setActiveSheetIndex($sheetIndex)->getStyle("J3:J6")->applyFromArray(getPropertiesLateralLeftText()); $objPHPExcel->setActiveSheetIndex($sheetIndex)->getColumnDimension('J')->setAutoSize(true); $Redes_Visibles = getArrayObjectRedes_Visibles($data["Extensores"][$i - $x]["Pruebas_Wifi"][0]["Habitacion"]["Redes_Visibles"]); populateTableHead($objPHPExcel, $sheetIndex, "M2:N2", "M2", $generalListCertificateSheetWifiTitles[4]); for ($i1 = 3; $i1 < count($Redes_Visibles) + 3; $i1++) { $objPHPExcel->setActiveSheetIndex($sheetIndex)->setCellValue("M" . $i1, "SSID")->setCellValue("N" . $i1, $Redes_Visibles[$i1 - 3]); } $objPHPExcel->setActiveSheetIndex($sheetIndex)->getStyle("M3:M" . ($i1 - 1))->applyFromArray(getPropertiesLateralLeftText()); $objPHPExcel->setActiveSheetIndex($sheetIndex)->getColumnDimension('N')->setAutoSize(true); $Datos_Prueba = getArrayObjectDatos_Prueba($data["Extensores"][$i - $x]["Pruebas_Wifi"][0]["Habitacion"]); populateTableHead($objPHPExcel, $sheetIndex, "P2:Q2", "P2", $generalListCertificateSheetWifiTitles[5]); for ($i1 = 3; $i1 < count($Datos_Prueba) + 3; $i1++) { $objPHPExcel->setActiveSheetIndex($sheetIndex)->setCellValue("P" . $i1, $generalListCertificateSheetDetailCertificateWifi7Title[$i1 - 3])->setCellValue("Q" . $i1, $Datos_Prueba[$i1 - 3]); } $objPHPExcel->setActiveSheetIndex($sheetIndex)->getStyle("P3:P6")->applyFromArray(getPropertiesLateralLeftText()); $objPHPExcel->setActiveSheetIndex($sheetIndex)->getColumnDimension('P')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
$positionColumn = $positionColumn - 1; $positionColumn = PHPExcel_Cell::stringFromColumnIndex($positionColumn); $objPHPExcel->setActiveSheetIndex(0)->setCellValue($positionColumn . $rowTitle, $generalListCertificateTitles[$language][9] . $Extensores[0] . $generalListCertificateTitles[$language][10] . $Extensores[3]); $positionColumn = PHPExcel_Cell::columnIndexFromString($positionColumn); $positionColumn = $positionColumn; $positionColumn = PHPExcel_Cell::stringFromColumnIndex($positionColumn); $positionColumn = generateCertificateGeneralData($objPHPExcel, $positionColumn, $rowTitle, $Extensores, $generalListCertificateModalTable7Title); if (isset($val["Pruebas_Wifi"]) && count($val["Pruebas_Wifi"]) > 0) { foreach ($val["Pruebas_Wifi"] as $ind => $valeur) { //echo $valeur["Habitacion"]["Frecuencia"]; $InformationTest = getArrayObjectInformationTest($valeur); $Prueba_Descarga = getArrayObjectPrueba_Descarga($valeur); $Prueba_Ping = getArrayObjectPrueba_Ping($valeur); $Sniffer = getArrayObjectSniffer($valeur); $Prueba_ST = getArrayObjectPrueba_ST($valeur); $Redes_Visibles = getArrayObjectRedes_Visibles($valeur); // informacion de prueba $positionColumn = PHPExcel_Cell::columnIndexFromString($positionColumn); $positionColumn = $positionColumn - 1; $positionColumn = PHPExcel_Cell::stringFromColumnIndex($positionColumn); $objPHPExcel->setActiveSheetIndex(0)->setCellValue($positionColumn . $rowTitle, $generalListCertificateTitles[$language][11]); $positionColumn = PHPExcel_Cell::columnIndexFromString($positionColumn); $positionColumn = $positionColumn; $positionColumn = PHPExcel_Cell::stringFromColumnIndex($positionColumn); $positionColumn = generateCertificateGeneralData($objPHPExcel, $positionColumn, $rowTitle, $InformationTest, $generalListCertificateModalTable8Title); // prueba de descarga $positionColumn = PHPExcel_Cell::columnIndexFromString($positionColumn); $positionColumn = $positionColumn - 1; $positionColumn = PHPExcel_Cell::stringFromColumnIndex($positionColumn); $objPHPExcel->setActiveSheetIndex(0)->setCellValue($positionColumn . $rowTitle, $generalListCertificateTitles[$language][4]); $positionColumn = PHPExcel_Cell::columnIndexFromString($positionColumn);