$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setAutoSize(true);
}
$sheetIndex++;
} else {
// echo "no tengo prueba wifi";
}
// $sheetIndex++;
}
} else {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F' . ($i + 2), $generalListCertificateModalTable5Title[0])->setCellValue('G' . ($i + 2), $generalListCertificateModalTable5Title[1])->setCellValue('H' . ($i + 2), $generalListCertificateModalTable5Title[2])->setCellValue('I' . ($i + 2), $generalListCertificateModalTable5Title[3])->setCellValue('J' . ($i + 2), $generalListCertificateModalTable5Title[4])->setCellValue('K' . ($i + 2), $generalListCertificateModalTable5Title[5]);
$objPHPExcel->getActiveSheet()->getStyle("F" . ($i + 2) . ":K" . ($i + 2))->applyFromArray(getPropertiesLateralLeftText());
populateTableHead($objPHPExcel, 0, "F" . ($i + 1) . ":K" . ($i + 1), "F" . ($i + 1), $generalListCertificateTitles[5]);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells("F" . ($i + 3) . ":K" . ($i + 3));
switch ($_POST["language"]) {
case 'es':
$generalListCertificateMessageNotExtender = "Por el momento no hay instalación de algún extensor en este certificado";
break;
case 'en':
$generalListCertificateMessageNotExtender = "Currently no extender is specified for this certificate.";
break;
case 'pt_BR':
$generalListCertificateMessageNotExtender = "No momento não há nenhuma instalação de qualquer extender neste certificado";
break;
default:
$generalListCertificateMessageNotExtender = "Currently no extender is specified for this certificate.";
break;
$generalListCertificateModalTable4Title = array("Spe", "Avg", "Tim", "Siz", "Tlo", "Tco", "Tpr", "Tst", "Url");
$generalListCertificateModalTable5Title = array("Avg", "Max", "Min", "Jit", "Los", "Rec", "Snd", "Url");
$generalListCertificateModalTable6Title = array("Int Desc.", "Int Carr.", "Nac Desc.", "Nac Carr.");
$generalListCertificateModalTable7Title = array("Tipo", "Modelo", "Mac", "Localização", "Loc. Aceita", "Estado");
break;
default:
$generalListCertificateModalTable1Title = array("Visit type", "Created cert. date", "Technical id", "Email client", "Service plan", "CPE type", "CPE model", "CPE mac", "Housing type", "CPE location", "Accept location proposal", "Observation", "Wifi own", "Certificate state", "Active cert. date", "Receptor name", "Relationship", "Floor", "Technical order");
$generalListCertificateModalTable3Title = array("Location", "Nat up.", "Nat down.", "Int up.", "Int down.", "Signal");
$generalListCertificateModalTable4Title = array("Spe", "Avg", "Tim", "Siz", "Tlo", "Tco", "Tpr", "Tst", "Url");
$generalListCertificateModalTable5Title = array("Avg", "Max", "Min", "Jit", "Los", "Rec", "Snd", "Url");
$generalListCertificateModalTable6Title = array("Int down.", "Int up.", "Nat down.", "Nat up.");
$generalListCertificateModalTable7Title = array("Type", "Model", "Mac", "Location", "Loc accept", "Status");
break;
}
$i = populateTableCells($objPHPExcel, 3, $generalListCertificateModalTable1Title, $generalListCertificateModalTable1Content, 0, PHPExcel_Cell::stringFromColumnIndex($x), PHPExcel_Cell::stringFromColumnIndex($x + 1));
$objPHPExcel->getActiveSheet()->getStyle(PHPExcel_Cell::stringFromColumnIndex($x) . "3:" . PHPExcel_Cell::stringFromColumnIndex($x) . ($i - 1))->applyFromArray(getPropertiesLateralLeftText());
if (count($value["Pruebas_ST"]) > 0) {
$Pruebas_ST = getArrayObjectPruebas_ST($value["Pruebas_ST"][0]);
$generalListCertificateModalTable2Title = array("Ubicación cpe", "Nacional subida", "Nacional descarga", "Internacional subida", "Internacional descarga");
// traduccion lenguaje
switch ($_POST["language"]) {
case 'en':
$generalListCertificateModalTable2Title = array("CPE location", "National upload", "National download", "International upload", "International download");
break;
case 'pt_BR':
$generalListCertificateModalTable2Title = array("Localização CPE", "Nac Carr.", "Nac Desc.", "Int Carr.", "Int Desc.");
break;
default:
$generalListCertificateModalTable2Title = array("CPE location", "National upload", "National download", "International upload", "International download");
break;
}
