$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);
