function excelGenerateSheetDetailCertificateWifi($data, $objPHPExcel, $sheetIndex, $generalListCertificateSheetWifiTitles, $WifiCertificateFrequency, $frequency, $indexSheet) { // populateTableHead($objPHPExcel,$sheetIndex,"A2:B2","A2",$generalListCertificateSheetWifiTitles[0]); // populateTableHead($objPHPExcel,$sheetIndex,"D2:E2","D2",$generalListCertificateSheetWifiTitles[1]); // populateTableHead($objPHPExcel,$sheetIndex,"G2:H2","G2",$generalListCertificateSheetWifiTitles[2]); // populateTableHead($objPHPExcel,$sheetIndex,"J2:K2","J2",$generalListCertificateSheetWifiTitles[3]); // populateTableHead($objPHPExcel,$sheetIndex,"M2:N2","M2",$generalListCertificateSheetWifiTitles[4]); $indexArray = array_search($WifiCertificateFrequency, $data); // $data["Pruebas_Wifi"][0]["habitacion"][0]["Habitacion"]["Prueba_Descarga"]["spe"]; // $data["Pruebas_Wifi"][0]["habitacion"][1]["Habitacion"]["Prueba_Descarga"]["spe"]; // $data["Pruebas_Wifi"][0]["habitacion"][2]["Habitacion"]["Prueba_Descarga"]["spe"]; $Prueba_Descarga = getArrayObjectPrueba_Descarga($data[$indexArray]["Habitacion"]["Prueba_Descarga"]); // $generalListCertificateSheetDetailCertificateWifi1Title }
function excelGenerateSheetDetailCertificateWifi($data, $objPHPExcel, $sheetIndex, $generalListCertificateSheetWifiTitles, $WifiCertificateFrequency, $frequency, $indexSheet) { $indexArray = array_search($WifiCertificateFrequency, $data); $Prueba_Descarga = getArrayObjectPrueba_Descarga($data[$indexArray]["Habitacion"]["Prueba_Descarga"]); }
if (isset($valor["Extensores"]) && count($valor["Extensores"]) > 0) { foreach ($valor["Extensores"] as $indice => $val) { $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);