$merge = $start . ":" . $end;
$objPHPExcel->setActiveSheetIndex(0)->mergeCells($merge);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($x, $i + 1, $generalListCertificateTitles[4]);
$objPHPExcel->getActiveSheet()->getStyle($start)->applyFromArray(getPropertiesHeaderText());
$i = populateTableCells($objPHPExcel, $i + 2, $generalListCertificateModalTable4Title, $Prueba_Descarga, 0, PHPExcel_Cell::stringFromColumnIndex($x), PHPExcel_Cell::stringFromColumnIndex($x + 1));
// prueba de ping
$Prueba_Ping = getArrayObjectPrueba_Ping($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[5]);
$objPHPExcel->getActiveSheet()->getStyle($start)->applyFromArray(getPropertiesHeaderText());
$i = populateTableCells($objPHPExcel, $i + 2, $generalListCertificateModalTable5Title, $Prueba_Ping, 0, PHPExcel_Cell::stringFromColumnIndex($x), PHPExcel_Cell::stringFromColumnIndex($x + 1));
// sniffer
$Sniffer = getArrayObjectSniffer($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[6]);
$objPHPExcel->getActiveSheet()->getStyle($start)->applyFromArray(getPropertiesHeaderText());
$dispositive = "Dispositivo";
// traduccion lenguaje
switch ($_POST["language"]) {
case 'en':
$dispositive = "Dispositive";
break;
case 'pt_BR':
$dispositive = "Dispositivo";
break;
$objPHPExcel->getActiveSheet()->getCell('I' . $i)->getHyperlink()->setUrl("sheet://'" . $nameSheet . "'!A1");
$objPHPExcel->getActiveSheet()->getCell('J' . $i)->getHyperlink()->setUrl("sheet://'" . $nameSheet . "'!A1");
$objPHPExcel->getActiveSheet()->getCell('K' . $i)->getHyperlink()->setUrl("sheet://'" . $nameSheet . "'!A1");
$Prueba_Descarga = getArrayObjectPrueba_Descarga($data["Extensores"][$i - $x]["Pruebas_Wifi"][0]["Habitacion"]["Prueba_Descarga"]);
populateTableHead($objPHPExcel, $sheetIndex, "A2:B2", "A2", $generalListCertificateSheetWifiTitles[0]);
for ($i1 = 3; $i1 < count($Prueba_Descarga) + 3; $i1++) {
$objPHPExcel->setActiveSheetIndex($sheetIndex)->setCellValue("A" . $i1, $generalListCertificateSheetDetailCertificateWifi2Table1Title[$i1 - 3])->setCellValue("B" . $i1, $Prueba_Descarga[$i1 - 3]);
}
$objPHPExcel->setActiveSheetIndex($sheetIndex)->getStyle("A3:A11")->applyFromArray(getPropertiesLateralLeftText());
$Prueba_Ping = getArrayObjectPrueba_Ping($data["Extensores"][$i - $x]["Pruebas_Wifi"][0]["Habitacion"]["Prueba_Ping"]);
populateTableHead($objPHPExcel, $sheetIndex, "D2:E2", "D2", $generalListCertificateSheetWifiTitles[1]);
for ($i1 = 3; $i1 < count($Prueba_Ping) + 3; $i1++) {
$objPHPExcel->setActiveSheetIndex($sheetIndex)->setCellValue("D" . $i1, $generalListCertificateSheetDetailCertificateWifi3Title[$i1 - 3])->setCellValue("E" . $i1, $Prueba_Ping[$i1 - 3]);
}
$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]);
$Extensores = getArrayObjectExtensores($val);
$positionColumn = PHPExcel_Cell::columnIndexFromString($positionColumn);
$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);