function reporte($idNaviera)
{
global $db, $db2, $workbook, $sesIdUsuario, $hoy;
// HTTP headers
HeaderingExcel('recap.xls');
// Creating the first worksheet
$worksheet1 =& $workbook->add_worksheet('Hoja1');
$fntTit =& $workbook->add_format();
$fntTit->set_size(12);
$fntTit->set_bold();
$fntTit->set_color('#E0D196');
// Font Black Normal
$fntFit =& $workbook->add_format();
$fntFit->set_size(10);
$fntBlk =& $workbook->add_format();
$fntBlk->set_size(10);
$fntBlk->set_color('black');
$fntBlk->set_bold();
$fntEnc =& $workbook->add_format();
$fntEnc->set_size(10);
$fntEnc->set_color('black');
$fntEnc->set_bold();
$fntEnc->set_align('center');
$fntEnc->set_fg_color('silver');
$fntEnc->set_pattern();
$usuario = getValueTable("usuario", "USUARIO", "id_usuario", $sesIdUsuario);
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNaviera);
// Encabezado
$worksheet1->write_string(0, 0, "TRANSPORTES MALEJA S.A. DE C.V.", $fntTit);
$worksheet1->write_string(2, 0, "Reporte : Recapitulación", $fntFit);
$worksheet1->write_string(3, 0, "Fecha : {$hoy} ", $fntFit);
$worksheet1->write_string(4, 0, "Naviera : {$naviera} ", $fntFit);
$worksheet1->write_string(2, 4, "Modulo : Inventario ", $fntFit);
$worksheet1->write_string(3, 4, "Elaboro: {$usuario} ", $fntFit);
// Sub-Encabezado
$worksheet1->set_column(0, 10, 15);
// ----------------------------------------------------------
// EL TREBOL
// ----------------------------------------------------------
$worksheet1->write_string(6, 0, ".:: El Trébol ::.", $fntEnc);
$worksheet1->write_string(7, 0, "Total", $fntEnc);
$worksheet1->write_string(7, 1, "Dañados", $fntEnc);
$worksheet1->write_string(7, 2, "A", $fntEnc);
$worksheet1->write_string(7, 3, "B", $fntEnc);
$worksheet1->write_string(7, 4, "C", $fntEnc);
$worksheet1->write_string(7, 5, "D", $fntEnc);
$worksheet1->write_string(7, 6, "FG", $fntEnc);
$worksheet1->write_string(7, 7, "GC", $fntEnc);
$worksheet1->write_string(8, 0, "20' DC", $fntEnc);
$worksheet1->write_string(9, 0, "40' DC", $fntEnc);
$worksheet1->write_string(10, 0, "40' HC", $fntEnc);
// 20 DC
$dc20DM = getCountConte('trebol', $idNaviera, '20DC', 'DM');
$worksheet1->write_number(8, 1, $dc20DM, $fntFit);
$dc20A = getCountConte('trebol', $idNaviera, '20DC', 'A');
$worksheet1->write_number(8, 2, $dc20A, $fntFit);
$dc20B = getCountConte('trebol', $idNaviera, '20DC', 'B');
$worksheet1->write_number(8, 3, $dc20B, $fntFit);
$dc20C = getCountConte('trebol', $idNaviera, '20DC', 'C');
$worksheet1->write_number(8, 4, $dc20C, $fntFit);
$dc20D = getCountConte('trebol', $idNaviera, '20DC', 'D');
$worksheet1->write_number(8, 5, $dc20D, $fntFit);
$dc20FG = getCountConte('trebol', $idNaviera, '20DC', 'FG');
$worksheet1->write_number(8, 6, $dc20FG, $fntFit);
$dc20GC = getCountConte('trebol', $idNaviera, '20DC', 'GC');
$worksheet1->write_number(8, 7, $dc20GC, $fntFit);
// 40 DC
$dc40DM = getCountConte('trebol', $idNaviera, '40DC', 'DM');
$worksheet1->write_number(9, 1, $dc40DM, $fntFit);
$dc40A = getCountConte('trebol', $idNaviera, '40DC', 'A');
$worksheet1->write_number(9, 2, $dc40A, $fntFit);
$dc40B = getCountConte('trebol', $idNaviera, '40DC', 'B');
$worksheet1->write_number(9, 3, $dc40B, $fntFit);
$dc40C = getCountConte('trebol', $idNaviera, '40DC', 'C');
$worksheet1->write_number(9, 4, $dc40C, $fntFit);
$dc40D = getCountConte('trebol', $idNaviera, '40DC', 'D');
$worksheet1->write_number(9, 5, $dc40D, $fntFit);
$dc40FG = getCountConte('trebol', $idNaviera, '40DC', 'FG');
$worksheet1->write_number(9, 6, $dc40FG, $fntFit);
$dc40GC = getCountConte('trebol', $idNaviera, '40DC', 'GC');
$worksheet1->write_number(9, 7, $dc40GC, $fntFit);
// 40 HC
$dc40HCDM = getCountConte('trebol', $idNaviera, '40HC', 'DM');
$worksheet1->write_number(10, 1, $dc40HCDM, $fntFit);
$dc40HCA = getCountConte('trebol', $idNaviera, '40HC', 'A');
$worksheet1->write_number(10, 2, $dc40HCA, $fntFit);
$dc40HCB = getCountConte('trebol', $idNaviera, '40HC', 'B');
$worksheet1->write_number(10, 3, $dc40HCB, $fntFit);
$dc40HCC = getCountConte('trebol', $idNaviera, '40HC', 'C');
$worksheet1->write_number(10, 4, $dc40HCC, $fntFit);
$dc40HCD = getCountConte('trebol', $idNaviera, '40HC', 'D');
$worksheet1->write_number(10, 5, $dc40HCD, $fntFit);
$dc40HCFG = getCountConte('trebol', $idNaviera, '40HC', 'FG');
$worksheet1->write_number(10, 6, $dc40HCFG, $fntFit);
$dc40HCGC = getCountConte('trebol', $idNaviera, '40HC', 'GC');
$worksheet1->write_number(10, 7, $dc40HCGC, $fntFit);
// ----------------------------------------------------------
// EL PINO
// ----------------------------------------------------------
$worksheet1->write_string(13, 0, ".:: El Pino ::.", $fntEnc);
$worksheet1->write_string(14, 0, "Total", $fntEnc);
$worksheet1->write_string(14, 1, "Dañados", $fntEnc);
$worksheet1->write_string(14, 2, "A", $fntEnc);
$worksheet1->write_string(14, 3, "B", $fntEnc);
$worksheet1->write_string(14, 4, "C", $fntEnc);
$worksheet1->write_string(14, 5, "D", $fntEnc);
$worksheet1->write_string(14, 6, "FG", $fntEnc);
$worksheet1->write_string(14, 7, "GC", $fntEnc);
$worksheet1->write_string(15, 0, "20' DC", $fntEnc);
$worksheet1->write_string(16, 0, "40' DC", $fntEnc);
$worksheet1->write_string(17, 0, "40' HC", $fntEnc);
// 20 DC
$dc20DM = getCountConte('pino', $idNaviera, '20DC', 'DM');
$worksheet1->write_number(15, 1, $dc20DM, $fntFit);
$dc20A = getCountConte('pino', $idNaviera, '20DC', 'A');
$worksheet1->write_number(15, 2, $dc20A, $fntFit);
$dc20B = getCountConte('pino', $idNaviera, '20DC', 'B');
$worksheet1->write_number(15, 3, $dc20B, $fntFit);
$dc20C = getCountConte('pino', $idNaviera, '20DC', 'C');
$worksheet1->write_number(15, 4, $dc20C, $fntFit);
$dc20D = getCountConte('pino', $idNaviera, '20DC', 'D');
$worksheet1->write_number(15, 5, $dc20D, $fntFit);
$dc20FG = getCountConte('pino', $idNaviera, '20DC', 'FG');
$worksheet1->write_number(15, 6, $dc20FG, $fntFit);
$dc20GC = getCountConte('pino', $idNaviera, '20DC', 'GC');
$worksheet1->write_number(15, 7, $dc20GC, $fntFit);
// 40 DC
$dc40DM = getCountConte('pino', $idNaviera, '40DC', 'DM');
$worksheet1->write_number(16, 1, $dc40DM, $fntFit);
$dc40A = getCountConte('pino', $idNaviera, '40DC', 'A');
$worksheet1->write_number(16, 2, $dc40A, $fntFit);
$dc40B = getCountConte('pino', $idNaviera, '40DC', 'B');
$worksheet1->write_number(16, 3, $dc40B, $fntFit);
$dc40C = getCountConte('pino', $idNaviera, '40DC', 'C');
$worksheet1->write_number(16, 4, $dc40C, $fntFit);
$dc40D = getCountConte('pino', $idNaviera, '40DC', 'D');
$worksheet1->write_number(16, 5, $dc40D, $fntFit);
$dc40FG = getCountConte('pino', $idNaviera, '40DC', 'FG');
$worksheet1->write_number(16, 6, $dc40FG, $fntFit);
$dc40GC = getCountConte('pino', $idNaviera, '40DC', 'GC');
$worksheet1->write_number(16, 7, $dc40GC, $fntFit);
// 40 HC
$dc40HCDM = getCountConte('pino', $idNaviera, '40HC', 'DM');
$worksheet1->write_number(17, 1, $dc40HCDM, $fntFit);
$dc40HCA = getCountConte('pino', $idNaviera, '40HC', 'A');
$worksheet1->write_number(17, 2, $dc40HCA, $fntFit);
$dc40HCB = getCountConte('pino', $idNaviera, '40HC', 'B');
$worksheet1->write_number(17, 3, $dc40HCB, $fntFit);
$dc40HCC = getCountConte('pino', $idNaviera, '40HC', 'C');
$worksheet1->write_number(17, 4, $dc40HCC, $fntFit);
$dc40HCD = getCountConte('pino', $idNaviera, '40HC', 'D');
$worksheet1->write_number(17, 5, $dc40HCD, $fntFit);
$dc40HCFG = getCountConte('pino', $idNaviera, '40HC', 'FG');
$worksheet1->write_number(17, 6, $dc40HCFG, $fntFit);
$dc40HCGC = getCountConte('pino', $idNaviera, '40HC', 'GC');
$worksheet1->write_number(17, 7, $dc40HCGC, $fntFit);
// ----------------------------------------------------------
// EL ARBOL
// ----------------------------------------------------------
$worksheet1->write_string(20, 0, ".:: El Arbol ::.", $fntEnc);
$worksheet1->write_string(21, 0, "Total", $fntEnc);
$worksheet1->write_string(21, 1, "Dañados", $fntEnc);
$worksheet1->write_string(21, 2, "A", $fntEnc);
$worksheet1->write_string(21, 3, "B", $fntEnc);
$worksheet1->write_string(21, 4, "C", $fntEnc);
$worksheet1->write_string(21, 5, "D", $fntEnc);
$worksheet1->write_string(21, 6, "FG", $fntEnc);
$worksheet1->write_string(21, 7, "GC", $fntEnc);
$worksheet1->write_string(22, 0, "20' DC", $fntEnc);
$worksheet1->write_string(23, 0, "40' DC", $fntEnc);
$worksheet1->write_string(24, 0, "40' HC", $fntEnc);
// 20 DC
$dc20DM = getCountConte('arbol', $idNaviera, '20DC', 'DM');
$worksheet1->write_number(22, 1, $dc20DM, $fntFit);
$dc20A = getCountConte('arbol', $idNaviera, '20DC', 'A');
$worksheet1->write_number(22, 2, $dc20A, $fntFit);
$dc20B = getCountConte('arbol', $idNaviera, '20DC', 'B');
$worksheet1->write_number(22, 3, $dc20B, $fntFit);
$dc20C = getCountConte('arbol', $idNaviera, '20DC', 'C');
$worksheet1->write_number(22, 4, $dc20C, $fntFit);
$dc20D = getCountConte('arbol', $idNaviera, '20DC', 'D');
$worksheet1->write_number(22, 5, $dc20D, $fntFit);
$dc20FG = getCountConte('arbol', $idNaviera, '20DC', 'FG');
$worksheet1->write_number(22, 6, $dc20FG, $fntFit);
$dc20GC = getCountConte('arbol', $idNaviera, '20DC', 'GC');
$worksheet1->write_number(22, 7, $dc20GC, $fntFit);
// 40 DC
$dc40DM = getCountConte('arbol', $idNaviera, '40DC', 'DM');
$worksheet1->write_number(23, 1, $dc40DM, $fntFit);
$dc40A = getCountConte('arbol', $idNaviera, '40DC', 'A');
$worksheet1->write_number(23, 2, $dc40A, $fntFit);
$dc40B = getCountConte('arbol', $idNaviera, '40DC', 'B');
$worksheet1->write_number(23, 3, $dc40B, $fntFit);
$dc40C = getCountConte('arbol', $idNaviera, '40DC', 'C');
$worksheet1->write_number(23, 4, $dc40C, $fntFit);
$dc40D = getCountConte('arbol', $idNaviera, '40DC', 'D');
$worksheet1->write_number(23, 5, $dc40D, $fntFit);
$dc40FG = getCountConte('arbol', $idNaviera, '40DC', 'FG');
$worksheet1->write_number(23, 6, $dc40FG, $fntFit);
$dc40GC = getCountConte('arbol', $idNaviera, '40DC', 'GC');
$worksheet1->write_number(23, 7, $dc40GC, $fntFit);
// 40 HC
$dc40HCDM = getCountConte('arbol', $idNaviera, '40HC', 'DM');
$worksheet1->write_number(24, 1, $dc40HCDM, $fntFit);
$dc40HCA = getCountConte('arbol', $idNaviera, '40HC', 'A');
$worksheet1->write_number(24, 2, $dc40HCA, $fntFit);
$dc40HCB = getCountConte('arbol', $idNaviera, '40HC', 'B');
$worksheet1->write_number(24, 3, $dc40HCB, $fntFit);
$dc40HCC = getCountConte('arbol', $idNaviera, '40HC', 'C');
$worksheet1->write_number(24, 4, $dc40HCC, $fntFit);
$dc40HCD = getCountConte('arbol', $idNaviera, '40HC', 'D');
$worksheet1->write_number(24, 5, $dc40HCD, $fntFit);
$dc40HCFG = getCountConte('arbol', $idNaviera, '40HC', 'FG');
$worksheet1->write_number(24, 6, $dc40HCFG, $fntFit);
$dc40HCGC = getCountConte('arbol', $idNaviera, '40HC', 'GC');
$worksheet1->write_number(24, 7, $dc40HCGC, $fntFit);
$workbook->close();
}
function reporte($idNaviera)
{
global $db, $db2, $workbook, $sesIdUsuario, $hoy;
$sesIdOficina = $_SESSION['sesIdOficina'];
$oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina);
$oficina = strtoupper($oficina);
// HTTP headers
HeaderingExcel('recap.xls');
// Creating the first worksheet
$worksheet1 =& $workbook->add_worksheet('Hoja1');
$fntTit =& $workbook->add_format();
$fntTit->set_size(12);
$fntTit->set_bold();
$fntTit->set_color('#E0D196');
// Font Black Normal
$fntFit =& $workbook->add_format();
$fntFit->set_size(10);
$fntBlk =& $workbook->add_format();
$fntBlk->set_size(10);
$fntBlk->set_color('black');
$fntBlk->set_bold();
$fntEnc =& $workbook->add_format();
$fntEnc->set_size(10);
$fntEnc->set_color('black');
$fntEnc->set_bold();
$fntEnc->set_align('center');
$fntEnc->set_fg_color('silver');
$fntEnc->set_pattern();
$usuario = getValueTable("usuario", "USUARIO", "id_usuario", $sesIdUsuario);
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNaviera);
// Encabezado
$worksheet1->write_string(0, 0, "MODULO DE PATIO", $fntTit);
$worksheet1->write_string(2, 0, "Reporte : Recapitulación - {$oficina} ", $fntFit);
$worksheet1->write_string(3, 0, "Fecha : {$hoy} ", $fntFit);
$worksheet1->write_string(4, 0, "Naviera : {$naviera} ", $fntFit);
$worksheet1->write_string(2, 4, "Modulo : Inventario ", $fntFit);
$worksheet1->write_string(3, 4, "Elaboro: {$usuario} // ", $fntFit);
// Sub-Encabezado
$worksheet1->set_column(0, 10, 15);
// ----------------------------------------------------------
// OFICINA X
// ----------------------------------------------------------
$worksheet1->write_string(6, 0, ".:: {$oficina} ::.", $fntEnc);
$worksheet1->write_string(7, 0, "Total", $fntEnc);
$worksheet1->write_string(7, 1, "Dañados", $fntEnc);
$worksheet1->write_string(7, 2, "A", $fntEnc);
$worksheet1->write_string(7, 3, "B", $fntEnc);
$worksheet1->write_string(7, 4, "C", $fntEnc);
$worksheet1->write_string(7, 5, "D", $fntEnc);
$worksheet1->write_string(7, 6, "FG", $fntEnc);
$worksheet1->write_string(7, 7, "GC", $fntEnc);
$worksheet1->write_string(8, 0, "20' DC", $fntEnc);
$worksheet1->write_string(9, 0, "40' DC", $fntEnc);
$worksheet1->write_string(10, 0, "40' HC", $fntEnc);
// 20 DC
$dc20DM = getCountConte($sesIdOficina, $idNaviera, '20DC', 'DM');
$worksheet1->write_number(8, 1, $dc20DM, $fntFit);
$dc20A = getCountConte($sesIdOficina, $idNaviera, '20DC', 'A');
$worksheet1->write_number(8, 2, $dc20A, $fntFit);
$dc20B = getCountConte($sesIdOficina, $idNaviera, '20DC', 'B');
$worksheet1->write_number(8, 3, $dc20B, $fntFit);
$dc20C = getCountConte($sesIdOficina, $idNaviera, '20DC', 'C');
$worksheet1->write_number(8, 4, $dc20C, $fntFit);
$dc20D = getCountConte($sesIdOficina, $idNaviera, '20DC', 'D');
$worksheet1->write_number(8, 5, $dc20D, $fntFit);
$dc20FG = getCountConte($sesIdOficina, $idNaviera, '20DC', 'FG');
$worksheet1->write_number(8, 6, $dc20FG, $fntFit);
$dc20GC = getCountConte($sesIdOficina, $idNaviera, '20DC', 'GC');
$worksheet1->write_number(8, 7, $dc20GC, $fntFit);
// 40 DC
$dc40DM = getCountConte($sesIdOficina, $idNaviera, '40DC', 'DM');
$worksheet1->write_number(9, 1, $dc40DM, $fntFit);
$dc40A = getCountConte($sesIdOficina, $idNaviera, '40DC', 'A');
$worksheet1->write_number(9, 2, $dc40A, $fntFit);
$dc40B = getCountConte($sesIdOficina, $idNaviera, '40DC', 'B');
$worksheet1->write_number(9, 3, $dc40B, $fntFit);
$dc40C = getCountConte($sesIdOficina, $idNaviera, '40DC', 'C');
$worksheet1->write_number(9, 4, $dc40C, $fntFit);
$dc40D = getCountConte($sesIdOficina, $idNaviera, '40DC', 'D');
$worksheet1->write_number(9, 5, $dc40D, $fntFit);
$dc40FG = getCountConte($sesIdOficina, $idNaviera, '40DC', 'FG');
$worksheet1->write_number(9, 6, $dc40FG, $fntFit);
$dc40GC = getCountConte($sesIdOficina, $idNaviera, '40DC', 'GC');
$worksheet1->write_number(9, 7, $dc40GC, $fntFit);
// 40 HC
$dc40HCDM = getCountConte($sesIdOficina, $idNaviera, '40HC', 'DM');
$worksheet1->write_number(10, 1, $dc40HCDM, $fntFit);
$dc40HCA = getCountConte($sesIdOficina, $idNaviera, '40HC', 'A');
$worksheet1->write_number(10, 2, $dc40HCA, $fntFit);
$dc40HCB = getCountConte($sesIdOficina, $idNaviera, '40HC', 'B');
$worksheet1->write_number(10, 3, $dc40HCB, $fntFit);
$dc40HCC = getCountConte($sesIdOficina, $idNaviera, '40HC', 'C');
$worksheet1->write_number(10, 4, $dc40HCC, $fntFit);
$dc40HCD = getCountConte($sesIdOficina, $idNaviera, '40HC', 'D');
$worksheet1->write_number(10, 5, $dc40HCD, $fntFit);
$dc40HCFG = getCountConte($sesIdOficina, $idNaviera, '40HC', 'FG');
$worksheet1->write_number(10, 6, $dc40HCFG, $fntFit);
$dc40HCGC = getCountConte($sesIdOficina, $idNaviera, '40HC', 'GC');
$worksheet1->write_number(10, 7, $dc40HCGC, $fntFit);
$workbook->close();
}
function reporteNewExcel($idNav = "")
{
global $db;
$naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNav);
$hoy = date("Y-m-d");
// Incluir la libreria PHPExcel
require '../include/PHPExcel/PHPExcel.php';
// Reservar memoria en servidor PHP
// Si el archivo final tiene 5Mb, reservar 500Mb
// Por cada operación, phpExcel mapea en memoria la imagen del archivo y esto satura la mamoria
ini_set("memory_limit", "512M");
// Create a new PHPExcel object
$objPHPExcel = new PHPExcel();
$objPHPExcel->getActiveSheet()->setTitle('Hoja 1');
$objPHPExcel->getDefaultStyle()->getFont()->setName('Arial');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(8);
// Estilos Arreglo
$styleEnc = array('font' => array('bold' => true), 'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER), 'borders' => array('top' => array('style' => PHPExcel_Style_Border::BORDER_THIN)), 'fill' => array('type' => PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR, 'rotation' => 90, 'startcolor' => array('argb' => 'FFA0A0A0'), 'endcolor' => array('argb' => 'FFFFFFFF')));
$styleSombra = array('font' => array('bold' => true), 'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT), 'borders' => array('top' => array('style' => PHPExcel_Style_Border::BORDER_THIN)), 'fill' => array('type' => PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR, 'rotation' => 90, 'startcolor' => array('argb' => '80E9E07A'), 'endcolor' => array('argb' => 'FFFFFFFF')));
$styleTitulo = array('font' => array('bold' => true, 'size' => 14), 'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT));
$styleSubtitulo = array('font' => array('bold' => true, 'size' => 10), 'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT));
// ----------- -----------------
// HOJA 2
$workSheet2 = new PHPExcel_Worksheet($objPHPExcel, 'Hoja2');
$objPHPExcel->addSheet($workSheet2, 1);
$workSheet2->getDefaultStyle()->getFont()->setSize(8);
$workSheet2->getDefaultStyle()->getFont()->setName('Arial');
// Se aplica estilo al encabezado
$objPHPExcel->getActiveSheet()->getStyle('A5:H5')->applyFromArray($styleEnc);
$objPHPExcel->getActiveSheet()->getStyle('A6')->applyFromArray($styleEnc);
$objPHPExcel->getActiveSheet()->getStyle('A7')->applyFromArray($styleEnc);
$objPHPExcel->getActiveSheet()->getStyle('A8')->applyFromArray($styleEnc);
// Encabezados
$headings = array('TIpo', 'Damage', 'A', 'B', 'C', 'D', 'FG', 'GC');
// Escribe los encabezados
$row = 5;
$col = 'A';
foreach ($headings as $heading) {
$objPHPExcel->getActiveSheet()->setCellValue($col . $row, $heading);
$col++;
}
// AutoFiltro
//$objPHPExcel->getActiveSheet()->setAutoFilter('A5:H5');
// Auto Ajuste de Ancho en Columna
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(13);
// Freeze pane so that the heading line won't scroll
//$objPHPExcel->getActiveSheet()->freezePane('A6');
// Titulo
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'ANAKOSTA, S.A. de C.V.')->getStyle('A1')->applyFromArray($styleTitulo);
// SUBTitulo
if ($naviera != '') {
$naviera = "[ {$naviera} ]";
}
if ($idNav == "-") {
$naviera = "[ Todo ]";
}
$objPHPExcel->getActiveSheet()->setCellValue('A2', "Report Recap {$naviera} ")->getStyle('A2')->applyFromArray($styleSubtitulo);
$objPHPExcel->getActiveSheet()->setCellValue('A3', "Fecha: {$hoy} ")->getStyle('A3')->applyFromArray($styleSubtitulo);
$objPHPExcel->getActiveSheet()->setCellValue('A6', '20-DC')->getStyle('A6');
$objPHPExcel->getActiveSheet()->setCellValue('A7', '40-DC')->getStyle('A7');
$objPHPExcel->getActiveSheet()->setCellValue('A8', '40-HC')->getStyle('A8');
// 20 DC
$dc20DM = getCountConte($idNav, '20DC', 'DM');
$dc20A = getCountConte($idNav, '20DC', 'A');
$dc20B = getCountConte($idNav, '20DC', 'B');
$dc20C = getCountConte($idNav, '20DC', 'C');
$dc20D = getCountConte($idNav, '20DC', 'D');
$dc20FG = getCountConte($idNav, '20DC', 'FG');
$dc20GC = getCountConte($idNav, '20DC', 'GC');
// 40DC
$dc40DM = getCountConte($idNav, '40DC', 'DM');
$dc40A = getCountConte($idNav, '40DC', 'A');
$dc40B = getCountConte($idNav, '40DC', 'B');
$dc40C = getCountConte($idNav, '40DC', 'C');
$dc40D = getCountConte($idNav, '40DC', 'D');
$dc40FG = getCountConte($idNav, '40DC', 'FG');
$dc40GC = getCountConte($idNav, '40DC', 'GC');
// 40HC
$dc40HCDM = getCountConte($idNav, '40HC', 'DM');
$dc40HCA = getCountConte($idNav, '40HC', 'A');
$dc40HCB = getCountConte($idNav, '40HC', 'B');
$dc40HCC = getCountConte($idNav, '40HC', 'C');
$dc40HCD = getCountConte($idNav, '40HC', 'D');
$dc40HCFG = getCountConte($idNav, '40HC', 'FG');
$dc40HCGC = getCountConte($idNav, '40HC', 'GC');
$objPHPExcel->getActiveSheet()->setCellValue('B6', $dc20DM)->setCellValue('C6', $dc20A)->setCellValue('D6', $dc20B)->setCellValue('E6', $dc20C)->setCellValue('F6', $dc20D)->setCellValue('G6', $dc20FG)->setCellValue('H6', $dc20GC);
// 40DC
$objPHPExcel->getActiveSheet()->setCellValue('B7', $dc40DM)->setCellValue('C7', $dc40A)->setCellValue('D7', $dc40B)->setCellValue('E7', $dc40C)->setCellValue('F7', $dc40D)->setCellValue('G7', $dc40FG)->setCellValue('H7', $dc40GC);
// 40HC
$objPHPExcel->getActiveSheet()->setCellValue('B8', $dc40HCDM)->setCellValue('C8', $dc40HCA)->setCellValue('D8', $dc40HCB)->setCellValue('E8', $dc40HCC)->setCellValue('F8', $dc40HCD)->setCellValue('G8', $dc40HCFG)->setCellValue('H8', $dc40HCGC);
// Se modifican los encabezados del HTTP para indicar que se envia un archivo de Excel2007.
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition:attachment;filename="reporteRecap.xlsx"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;
}
