🌹🏠🌹？》《》？《》？<?php
include "../include/inicio.php";

//si estoy en la seccion de filtros
if( $_REQUEST['paso'] != 2){

  $titulo = "GENERACION DE INDICADORES A MES/AÑO";
  
  $fmy = new formy("");   
     
  $fmy->name("unico");
  $fmy->caption = $titulo;

  $meses = array( 1 => 'Enero', 2 => 'Febrero', 3 => 'Marzo', 4 => 'Abril', 5 => 'Mayo', 6 => 'Junio', 7 => 'Julio', 8 => 'Agosto', 9 => 'Septiembre', 10 => 'Octubre', 11 => 'Noviembre', 12 => 'Diciembre' );

  $mes_anterior = date('m',strtotime("-1 month"));

  $objeto = new select("mes", $meses, $mes_anterior);  
  $objeto->accesskey("m");
  $objeto->validarRequerido();
  $objeto->label = "&Mes";
  $fmy->agregar( $objeto );

  if($mes_anterior == '12'){
    $anio = date('Y',strtotime("-1 year"));
  }else{
    $anio = date('Y');
  }
  
  $objeto = new text("anio", $anio);  
  $objeto->accesskey("a");
  $objeto->size( 5 );
  $objeto->validarRequerido();
  $objeto->mask("####");
  $objeto->style("text-align:left");
  $objeto->label = "&Anio";
  $fmy->agregar( $objeto );

  $objeto = new button( "continuar", "&Continuar" );
  $objeto->extra("onClick='continua();'");  
  $objeto->clase("input");
  $objeto->ultimaFila = true;
  $fmy->agregar( $objeto );
  
  if($_REQUEST['rebuscar'] == 'rebuscar'){
    $objeto = new button( "volver", "&Volver" );
    $objeto->extra("onClick='cerrarVentana(false)'");
    $objeto->clase("input");
    $fmy->agregar( $objeto );
  }
   
  $smarty->assign( 'formy', $fmy->mostrar() );
  $smarty->assign( 'libFormy', true );
  $smarty->mostrar( 'formyIndicadoresRemitosOrbisFecha.tpl' );

    
}else{

  ini_set('memory_limit', '2048M');
  set_time_limit(0);

  if($_REQUEST['mes'] < 10){
    $mes = "0".$_REQUEST['mes'];
  }else{
    $mes = $_REQUEST['mes'];
  }

  $inicio = "01/".$mes."/".substr($_REQUEST['anio'], '2', '2');
  $fin = mesHasta($_REQUEST['mes'], $_REQUEST['anio'])."/".$mes."/".substr($_REQUEST['anio'], '2', '2');

  $desde = "01/".$mes."/".$_REQUEST['anio'];
  $hasta = mesHasta($_REQUEST['mes'], $_REQUEST['anio'])."/".$mes."/".$_REQUEST['anio']; 

  $sql = "SET ISOLATION TO DIRTY READ";
  $db->ejecutar($sql);
  
  //antes que nada traslado las estructuras de rem_cab_mes, rem_det_mes y rem_obser a nuevas tablas
  //de las que luego leere para que no me las modifiquen durante la ejecucion

  $sql = "SELECT * 
            FROM rem_cab_mes 
           WHERE fecha = '$fin'  
       INTO TEMP nuevo_rem_cab";
  $db->ejecutar($sql);
  $sql = "SELECT * FROM rem_det_mes 
           WHERE fecha = '$fin' 
       INTO TEMP nuevo_rem_det";
  $db->ejecutar($sql);
  $sql = "SELECT * FROM rem_obser WHERE fecha BETWEEN '$inicio' AND '$fin' INTO TEMP nuevo_rem_obser";
  $db->ejecutar($sql);
  
  $fila = 1;
  
  include '../include/phpexcel/PHPExcel.php';
  include 'PHPExcel/IOFactory.php';
  
  
  //$cod_empresa_mails = 15;
  $cod_empresa_mails = $_SESSION['empresa_login'];

  $objPHPExcel = new PHPExcel();
  
  //busco la descripcion de la empresa
  $sql = "SELECT denominacion
            FROM empresa
           WHERE empresa = '$cod_empresa_mails'";
  $empresa = $db->campos($sql, 'denominacion');       

  $objPHPExcel->setActiveSheetIndex(0);
  $objPHPExcel->getActiveSheet()->setTitle('IND. DE GESTION');
  
  // Titulo de la hoja
  $objPHPExcel->getActiveSheet()->mergeCells('B1:S1');
  $objPHPExcel->getActiveSheet()->setCellValue('B'.$fila, "INDICADORES DE GESTION LOGISTICA");
  $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
  				'bold' => true,
          'size' => 36 ) ) );
  
  //busco la descripcion de la empresa
  $sql = "SELECT denominacion
            FROM empresa
           WHERE empresa = '$cod_empresa_mails'";
  $empresa = $db->campos($sql, 'denominacion');       
  
  $objPHPExcel->getActiveSheet()->mergeCells('B3:F3');
  $objPHPExcel->getActiveSheet()->setCellValue('B3', "Cliente: ".$empresa);
  $objPHPExcel->getActiveSheet()->getStyle('B3')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 26 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('B4:D4');
  $objPHPExcel->getActiveSheet()->setCellValue('B4', "Periodo: ".$desde." al ".$hasta);
  $objPHPExcel->getActiveSheet()->getStyle('B4')->applyFromArray(
  		array(
  			'alignment' => array(
  				'right' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
        'font' => array(
          'size' => 14 ) ) );
          
  $objPHPExcel->getActiveSheet()->mergeCells('B7:J7');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 7, "REMITOS PENDIENTES");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'size'  => 24 ) 
      ), 'B7:J7' );

  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 9, "REMITOS");
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 9, "m3");
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 9, "%");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'size'  => 10 ) 
      ), 'F9:J9' );
  
   
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 10, "Suspendidos");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'B10:D10' );
      
  //busco la cantidad de remitos suspendidos
  $sql = "SELECT COUNT(*) AS rem_sus
            FROM nuevo_rem_cab 
           WHERE empresa  = '$cod_empresa_mails' 
             AND ( espera = 'S' or espera_logistica = 'S' )
             AND estado  IN ( 1,2,3,12)";
  $remitos_suspendidos = $db->campos($sql, 'rem_sus');
  
  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab, nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa  = '$cod_empresa_mails' 
             AND ( nuevo_rem_cab.espera = 'S' OR nuevo_rem_cab.espera_logistica = 'S' ) 
             AND nuevo_rem_cab.estado IN ( 1,2,3,12)
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur";
  $vol_m3 = $db->campos($sql, 'm3');
  
   
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 10, $remitos_suspendidos);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 10, number_format( (float)ROUND($vol_m3,2),2,".", ","));
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'F10:J10' );
  
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 11, "Diferidos h/ 10 dias  por ".$empresa);
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'B11:D11' );
      
  //busco la cantidad de remitos diferidos hasta 10 dias
  $sql = "SELECT COUNT(*) AS rem_dif_10
            FROM nuevo_rem_cab 
           WHERE empresa      = '$cod_empresa_mails' 
             AND fecha_difer IS NOT NULL 
             AND fecha_difer <= today + 10
             AND estado  IN ( 1,2,3)";
  $remitos_diferidos_h10 = $db->campos($sql, 'rem_dif_10');
  
  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab, nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa  = '$cod_empresa_mails' 
             AND nuevo_rem_cab.fecha_difer IS NOT NULL 
             AND nuevo_rem_cab.fecha_difer <= today + 10 
             AND nuevo_rem_cab.estado IN ( 1,2,3)
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur";
  $vol_m3_difer10 = $db->campos($sql, 'm3');
  
   
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 11, $remitos_diferidos_h10);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 11, number_format( (float)$vol_m3_difer10,2, ".", ","));
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 11, $porc_suspendidos_cc);
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'F11:J11' );
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 12, "Diferidos + 10 dias  por ".$empresa);
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'B12:D12' );
      
  //busco la cantidad de remitos diferidos > 10 dias
  $sql = "SELECT COUNT(*) AS rem_dif_mas10
            FROM nuevo_rem_cab 
           WHERE empresa      = '$cod_empresa_mails' 
             AND fecha_difer IS NOT NULL 
             AND fecha_difer  >= today + 12
             AND estado  IN ( 1,2,3)";
  $remitos_diferidos_mas10 = $db->campos($sql, 'rem_dif_mas10');
  
  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab, nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa  = '$cod_empresa_mails' 
             AND nuevo_rem_cab.fecha_difer IS NOT NULL 
             AND nuevo_rem_cab.fecha_difer >= today + 12 
             AND nuevo_rem_cab.estado IN ( 1,2,3)
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur";
  $vol_m3_difer_mas10 = $db->campos($sql, 'm3');
  
   
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 12, $remitos_diferidos_mas10);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 12, number_format( (float)$vol_m3_difer_mas10,2, ".", ","));
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 12, $porc_suspendidos_cc);
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'F12:J12' );
  $objPHPExcel->getActiveSheet()->mergeCells('B13:D13');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 13, "Sin stock");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'B13:D13' );
      
  //busco la cantidad de remitos sin stock
  $sql = "SELECT COUNT(*) AS sin_stock
            FROM nuevo_rem_cab 
           WHERE empresa      = '$cod_empresa_mails'
             AND estado IN ('1', '2')";
  $remitos_sin_stock = $db->campos($sql, 'sin_stock');
  
  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab, nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa = '$cod_empresa_mails'  
             AND nuevo_rem_cab.estado IN ('1', '2')
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur";
  $vol_m3_sin_stock = $db->campos($sql, 'm3');
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 13, $remitos_sin_stock);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 13, number_format( (float)$vol_m3_sin_stock,2, ".", ","));
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 13, $porc_suspendidos_cc);
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'F13:J13' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('B14:D14');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 14, "Pendientes");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'B14:D14' );
      
  //busco la cantidad de remitos pendientes
  $sql = "SELECT COUNT(*) AS pendientes
            FROM nuevo_rem_cab 
           WHERE empresa      = '$cod_empresa_mails'
             AND (
                   (nuevo_rem_cab.estado = 2 AND nuevo_rem_cab.fecha_difer IS null)
                   OR
                   (nuevo_rem_cab.estado = 2 AND nuevo_rem_cab.fecha_difer <= today)
                   OR
                   (nuevo_rem_cab.estado = 3 AND fecha_difer IS null AND espera = 'N' AND espera_logistica = 'N')
                   OR
                   (nuevo_rem_cab.estado = 3 AND fecha_difer IS NOT null AND espera = 'N' AND espera_logistica = 'N' AND fecha_difer <= today)
                   OR
                   (nuevo_rem_cab.estado = 12)
                   OR
                   (nuevo_rem_cab.estado = 8)
                 )
             AND espera != 'S' 
             AND espera_logistica != 'S'";
  $remitos_pendientes = $db->campos($sql, 'pendientes');
  
  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab, nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa = '$cod_empresa_mails'  
             AND (
                   (nuevo_rem_cab.estado = 2 AND nuevo_rem_cab.fecha_difer IS null)
                   OR
                   (nuevo_rem_cab.estado = 2 AND nuevo_rem_cab.fecha_difer <= today)
                   OR
                   (nuevo_rem_cab.estado = 3 AND nuevo_rem_cab.fecha_difer IS null AND nuevo_rem_cab.espera = 'N' AND nuevo_rem_cab.espera_logistica = 'N')
                   OR
                   (nuevo_rem_cab.estado = 3 AND nuevo_rem_cab.fecha_difer IS NOT null AND nuevo_rem_cab.espera = 'N' AND nuevo_rem_cab.espera_logistica = 'N' AND nuevo_rem_cab.fecha_difer <= today)
                   OR
                   (nuevo_rem_cab.estado = 12)
                   OR
                   (nuevo_rem_cab.estado = 8)
                 )
             AND nuevo_rem_cab.espera != 'S' 
             AND nuevo_rem_cab.espera_logistica != 'S'
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur";
  $vol_m3_pendientes = $db->campos($sql, 'm3');
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 14, $remitos_pendientes);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 14, number_format( (float)$vol_m3_pendientes,2, ".", ","));
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 14, $porc_suspendidos_cc);
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'F14:J14' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('B15:D15');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 15, "En transito");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'B15:D15' );
      
  //busco la cantidad de remitos en transito
  $sql = "SELECT COUNT(*) AS en_transito
            FROM nuevo_rem_cab 
           WHERE empresa      = '$cod_empresa_mails'
             AND estado       = '6'
             AND fecha_conf_ent IS NULL";
  $remitos_en_transito = $db->campos($sql, 'en_transito');
  
  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab, nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa = '$cod_empresa_mails'  
             AND nuevo_rem_cab.estado  = '6'
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND fecha_conf_ent IS NULL
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur";
  $vol_m3_en_transito = $db->campos($sql, 'm3');
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 15, $remitos_en_transito);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 15, number_format( (float)$vol_m3_en_transito,2, ".", ","));
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 15, $porc_suspendidos_cc);
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF00FFFF' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'F15:J15' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('B16:D16');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 16, "Total de pendientes");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF0099FF' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'B16:D16' );
      
  //hago los totales
  $total_remitos = $remitos_suspendidos + $remitos_suspendidos_cc+ $remitos_diferidos_h10 + $remitos_diferidos_mas10+ $remitos_pendientes + $remitos_sin_stock + $remitos_en_transito; 
  $total_vol_m3  = $vol_m3 + $vol_m3_cc + $vol_m3_difer10 + $vol_m3_difer_mas10 + $vol_m3_sin_stock + $vol_m3_pendientes + $vol_m3_en_transito;
  
  $porc_suspendidos =  ($remitos_suspendidos *100)/ $total_remitos;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 10, number_format( (float)$porc_suspendidos,2, ".", ","));
  $porc_diferidos_h10 =  ($remitos_diferidos_h10 *100)/ $total_remitos;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 11, number_format( (float)$porc_diferidos_h10,2, ".", ","));
  $porc_diferidos_mas10 =  ($remitos_diferidos_mas10 *100)/ $total_remitos;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 12, number_format( (float)$porc_diferidos_mas10,2, ".", ","));
  $porc_sin_stock =  ($remitos_sin_stock *100)/ $total_remitos;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 13, number_format( (float)$porc_sin_stock,2, ".", ","));
  $porc_pendientes =  ($remitos_pendientes *100)/ $total_remitos;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 14, number_format( (float)$porc_pendientes,2, ".", ","));
  $porc_en_transito=  ($remitos_en_transito *100)/ $total_remitos;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 15, number_format( (float)$porc_en_transito,2, ".", ","));
  
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 16, $total_remitos);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 16, number_format( (float)$total_vol_m3,2, ".", ","));
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 16, 100);
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FF0099FF' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'F16:J16' );
  
  
  //REMITOS ENTREGADOS
  
  $objPHPExcel->getActiveSheet()->mergeCells('O5:S5');
  $objPHPExcel->getActiveSheet()->setCellValue('O5', "Fecha: ".date("d/m/Y"));
  $objPHPExcel->getActiveSheet()->getStyle('O5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('M7:S7');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 7, "REMITOS ENTREGADOS");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'size'  => 24 ) 
      ), 'M7:S7' );
      
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 9, "REMITOS");
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 9, "m3");
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, 9, "%");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'size'  => 10 ) 
      ), 'O9:S9' );
  
   
  /*$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 10, "Anticipados");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'M10:M10' );*/
      
  //busco los remitos anticipados
  $sql = "SELECT COUNT(*) AS cantidad 
            FROM empresa, nuevo_rem_cab 
                              LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                                                         AND nuevo_rem_cab.empresa = clientes_emp.empresa) 
                              LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                                                      AND clientes_emp.provincia = localidad.provincia)
                              LEFT JOIN provincia ON (localidad.provincia = provincia.provincia)
           WHERE nuevo_rem_cab.empresa           = '$cod_empresa_mails'
             AND nuevo_rem_cab.empresa           = empresa.empresa
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
  
             AND nuevo_rem_cab.dias_demora_prev < 0";
  $remitos_ant = $db->campos($sql, 'cantidad');

  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab, nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa = '$cod_empresa_mails'  
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
  
             AND nuevo_rem_cab.dias_demora_prev < 0
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur";
  $vol_m3_rem_ant = $db->campos($sql, 'm3');
  //recorro y veo si le tengo que dar bola o no
  /*foreach($datosRemitos as $dato){
    //vamos a calcular los dias habiles
    $habiles = $dato['dias_demora_prev'];
  
    //buscamos los dias de la tabla de tiempos_estandar
    $sql = "SELECT dias
              FROM tiempos_estandar
             WHERE provincia = '$dato[provincia]'
               AND localidad = '$dato[localidad]'";
    $dias_estandar = $db->campos($sql, 'dias') + 1;
      
    $diferencia = $habiles - $dias_estandar;
  
    if($diferencia <= 0){
      //incrementamos la cantidad de remitos en 1
      $remitos_ant++;
      
      //buscamos el volumen de este remito y lo acumulamos
      $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
                FROM nuevo_rem_det 
               WHERE empresa  = '$cod_empresa_mails' 
                 AND numero   = '$dato[numero]'";
      $vol_m3_rem_ant += $db->campos($sql, 'm3');
    }
  }*/
  
  //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 10, $remitos_ant);
  //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 10, number_format( (float)ROUND($vol_m3_rem_ant,2),2,".", ","));
  /*
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'O10:S10' );
    */
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 10, "En termino");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'M10:M10' );
  
  //busco los remitos entregados en termino
  $sql = "SELECT COUNT(*) AS cantidad
            FROM empresa, nuevo_rem_cab 
                              LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                                                         AND nuevo_rem_cab.empresa = clientes_emp.empresa) 
                              LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                                                      AND clientes_emp.provincia = localidad.provincia)
                              LEFT JOIN provincia ON (localidad.provincia = provincia.provincia)
           WHERE nuevo_rem_cab.empresa           = '$cod_empresa_mails'
             AND nuevo_rem_cab.empresa           = empresa.empresa
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
  
             AND nuevo_rem_cab.dias_demora_prev = 0";
  $remitos_en_term = $db->campos($sql, 'cantidad');

  $remitos_en_term += $remitos_ant;

  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab, nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa = '$cod_empresa_mails'  
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
  
             AND nuevo_rem_cab.dias_demora_prev = 0
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur";
  $vol_m3_en_term = $db->campos($sql, 'm3');
                     //die($vol_m3_rem_ant);
  $vol_m3_en_term += $vol_m3_rem_ant;
  //recorro y veo si le tengo que dar bola o no
  /*foreach($datosRemitos as $dato){
    //vamos a calcular los dias habiles
    
    $habiles = $dato['dias_demora_prev'];
  
    //buscamos los dias de la tabla de tiempos_estandar
    $sql = "SELECT dias
              FROM tiempos_estandar
             WHERE provincia = '$dato[provincia]'
               AND localidad = '$dato[localidad]'";
    $dias_estandar = $db->campos($sql, 'dias') + 1;
      
    $diferencia = $habiles - $dias_estandar;
  
    if($diferencia <= 0){
      //incrementamos la cantidad de remitos en 1
      $remitos_en_term++;
      
      //buscamos el volumen de este remito y lo acumulamos
      $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
                FROM nuevo_rem_det 
               WHERE empresa  = '$cod_empresa_mails' 
                 AND numero   = '$dato[numero]'";
      $vol_m3_en_term += $db->campos($sql, 'm3');
  
    }
  }*/
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 10, $remitos_en_term);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 10, number_format( (float)$vol_m3_en_term,2, ".", ","));
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'O10:S10' );


  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 11, "   Con Diferimiento");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'M11:M11' );
  
  //busco los remitos entregados en termino con diferimiento
  $sql = "SELECT COUNT(*) AS cantidad
            FROM empresa, nuevo_rem_cab 
                              LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                                                         AND nuevo_rem_cab.empresa = clientes_emp.empresa) 
                              LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                                                      AND clientes_emp.provincia = localidad.provincia)
                              LEFT JOIN provincia ON (localidad.provincia = provincia.provincia)
           WHERE nuevo_rem_cab.empresa           = '$cod_empresa_mails'
             AND nuevo_rem_cab.empresa           = empresa.empresa
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
  
             AND nuevo_rem_cab.dias_demora_prev <= 0
             AND nuevo_rem_cab.fecha_difer IS NOT NULL";
  $remitos_en_term_con_dif = $db->campos($sql, 'cantidad');

  //$remitos_en_term += $remitos_ant;

  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab, nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa = '$cod_empresa_mails'  
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
  
             AND nuevo_rem_cab.dias_demora_prev <= 0
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur
             AND nuevo_rem_cab.fecha_difer IS NOT NULL";
  $vol_m3_en_term_con_dif = $db->campos($sql, 'm3');
  
  //$vol_m3_en_term += $vol_m3_rem_ant;
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 11, $remitos_en_term_con_dif);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 11, number_format( (float)$vol_m3_en_term_con_dif,2, ".", ","));
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'O11:S11' );

  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 12, "   Sin Diferimiento");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'M12:M12' );
  
  //busco los remitos entregados en termino sin diferimiento
  $sql = "SELECT COUNT(*) AS cantidad
            FROM empresa, nuevo_rem_cab 
                              LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                                                         AND nuevo_rem_cab.empresa = clientes_emp.empresa) 
                              LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                                                      AND clientes_emp.provincia = localidad.provincia)
                              LEFT JOIN provincia ON (localidad.provincia = provincia.provincia)
           WHERE nuevo_rem_cab.empresa           = '$cod_empresa_mails'
             AND nuevo_rem_cab.empresa           = empresa.empresa
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
  
             AND nuevo_rem_cab.dias_demora_prev <= 0
             AND nuevo_rem_cab.fecha_difer IS NULL";
  $remitos_en_term_sin_dif = $db->campos($sql, 'cantidad');

  //$remitos_en_term += $remitos_ant;

  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab, nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa = '$cod_empresa_mails'  
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
             AND nuevo_rem_cab.dias_demora_prev <= 0
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur
             AND nuevo_rem_cab.fecha_difer IS NULL";
  $vol_m3_en_term_sin_dif = $db->campos($sql, 'm3');
  
  //$vol_m3_en_term += $vol_m3_rem_ant;
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 12, $remitos_en_term_sin_dif);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 12, number_format( (float)$vol_m3_en_term_sin_dif,2, ".", ","));
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'O12:S12' );

  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 14, "   48 Hs");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'M14:M14' );
      
  //busco la cantidad de remitos entregados con un dia de demora
  $sql = "SELECT COUNT(*) AS rem_1_dem
            FROM nuevo_rem_cab LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo AND nuevo_rem_cab.empresa = clientes_emp.empresa)  
           WHERE nuevo_rem_cab.empresa  = '$cod_empresa_mails' 
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
             AND nuevo_rem_cab.dias_demora_prev  > 0   
             AND nuevo_rem_cab.dias_demora_prev  <= 2";
  $remitos_1_dem = $db->campos($sql, 'rem_1_dem');
  
  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo AND nuevo_rem_cab.empresa = clientes_emp.empresa), nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa  = '$cod_empresa_mails' 
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                )
             AND nuevo_rem_cab.dias_demora_prev  > 0
             AND nuevo_rem_cab.dias_demora_prev  <= 2
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur";
  $vol_m3_1_dem = $db->campos($sql, 'm3');
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 14, $remitos_1_dem);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 14, number_format( (float)$vol_m3_1_dem,2, ".", ","));
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'O14:S14' );
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 15, "   Mas 48 Hs");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'M15:M15' );
      
  //busco la cantidad de remitos entregados con dos dias de demora
  $sql = "SELECT COUNT(*) AS rem_2_dem
            FROM nuevo_rem_cab LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo AND nuevo_rem_cab.empresa = clientes_emp.empresa)
           WHERE nuevo_rem_cab.empresa  = '$cod_empresa_mails' 
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
             AND dias_demora_prev  > 2";
  $remitos_2_dem = $db->campos($sql, 'rem_2_dem');
  
  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo AND nuevo_rem_cab.empresa = clientes_emp.empresa), nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa  = '$cod_empresa_mails' 
             AND nuevo_rem_cab.dias_demora_prev > 2
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                )
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur";
  $vol_m3_2_dem = $db->campos($sql, 'm3');
  
   
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 15, $remitos_2_dem);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 15, number_format( (float)$vol_m3_2_dem,2, ".", ","));
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'O15:S15' );
      
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 13, "Fuera de Termino");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'M13:M13' );
      
  //busco la cantidad de remitos entregados con mas de dos dias de demora
  $sql = "SELECT COUNT(*) AS rem_mas_2_dem
            FROM nuevo_rem_cab LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo AND nuevo_rem_cab.empresa = clientes_emp.empresa)
           WHERE nuevo_rem_cab.empresa  = '$cod_empresa_mails' 
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
             AND dias_demora_prev  > 2";
  $remitos_mas_2_dem = $remitos_1_dem + $remitos_2_dem;//$db->campos($sql, 'rem_mas_2_dem');
  
  $sql = "SELECT SUM(nuevo_rem_det.volumen) AS m3
            FROM nuevo_rem_cab LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo AND nuevo_rem_cab.empresa = clientes_emp.empresa), nuevo_rem_det 
           WHERE nuevo_rem_cab.empresa  = '$cod_empresa_mails' 
             AND nuevo_rem_cab.dias_demora_prev  > 2
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                )
             AND nuevo_rem_cab.numero  = nuevo_rem_det.numero
             AND nuevo_rem_cab.empresa = nuevo_rem_det.empresa
             AND nuevo_rem_cab.tdoc = nuevo_rem_det.tdoc
             AND nuevo_rem_cab.letra = nuevo_rem_det.letra
             AND nuevo_rem_cab.sucur = nuevo_rem_det.sucur";
  $vol_m3_mas_2_dem = $vol_m3_1_dem + $vol_m3_2_dem;//$db->campos($sql, 'm3');

  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 13, $remitos_mas_2_dem);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 13, number_format( (float)$vol_m3_mas_2_dem,2, ".", ","));
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9966' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'O13:S13' );
  
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 16, "Tot. Rtos. en termino");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9900' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'M16:M16' );
      
  //total de remitos en termino
  $total_en_term = $remitos_en_term;
  $total_m3_en_term = $vol_m3_en_term;
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 16, $total_en_term);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 16, number_format( (float)$total_m3_en_term,2, ".", ","));
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9900' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'O16:S16' );
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 17, "Tot. Rtos. fuera termino");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9900' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'M17:M17' );
      
  //total de remitos fuera de termino
  $total_fuera_term = $remitos_mas_2_dem;//$remitos_1_dem + $remitos_2_dem + $remitos_mas_2_dem;
  $total_m3_fuera_term = $vol_m3_mas_2_dem;//$vol_m3_1_dem +  $vol_m3_2_dem + $vol_m3_mas_2_dem;
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 17, $total_fuera_term);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 17, number_format( (float)$total_m3_fuera_term,2, ".", ","));
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9900' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'O17:S17' );
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 18, "Tot. Rtos. entregados");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9900' ) ),
             'font'      => array( 'size'  => 18 ) 
      ), 'M18:M18' );
      
  //total de remitos entregados
  $total_entregados = $total_en_term + $total_fuera_term ;
  $total_m3_entregados= $total_m3_en_term +  $total_m3_fuera_term;
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 18, $total_entregados);
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 18, number_format( (float)$total_m3_entregados,2, ".", ","));
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, 18, number_format( (float)100,2, ".", ","));
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFF9900' ) ),
             'font'      => array( 'bold' =>true, 
                                   'size' => 10 ) 
      ), 'O18:S18');
  
  $porc_en_term =  ($total_en_term *100)/ $total_entregados;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, 16, number_format( (float)$porc_en_term,2, ".", ","));
  
  $porc_fuera_term =  ($total_fuera_term *100)/ $total_entregados;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, 17, number_format( (float)$porc_fuera_term,2, ".", ","));
  
  $porc_ant =  ($remitos_ant *100)/ $total_entregados;
  //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, 10, number_format( (float)$porc_ant,2, ".", ","));
  
  $porc_en_termino =  ($remitos_en_term *100)/ $total_entregados;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, 10, number_format( (float)$porc_en_termino,2, ".", ","));
  
  $porc_1_dem =  ($remitos_1_dem *100)/ $total_entregados;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, 14, number_format( (float)$porc_1_dem,2, ".", ","));
  
  $porc_2_dem =  ($remitos_2_dem *100)/ $total_entregados;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, 15, number_format( (float)$porc_2_dem,2, ".", ","));
  
  $porc_mas_2_dem =  ($remitos_mas_2_dem *100)/ $total_entregados;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, 13, number_format( (float)$porc_mas_2_dem,2, ".", ","));

  $porc_en_term_con_dif =  ($remitos_en_term_con_dif *100)/ $total_entregados;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, 11, number_format( (float)$porc_en_term_con_dif,2, ".", ","));

  $porc_en_term_sin_dif =  ($remitos_en_term_sin_dif *100)/ $total_entregados;
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, 12, number_format( (float)$porc_en_term_sin_dif,2, ".", ","));

  $objPHPExcel->getActiveSheet()->getColumnDimension("A")->setWidth(5);
  $objPHPExcel->getActiveSheet()->getColumnDimension("B")->setWidth(12);
  $objPHPExcel->getActiveSheet()->getColumnDimension("C")->setWidth(12);
  $objPHPExcel->getActiveSheet()->getColumnDimension("D")->setWidth(30);
  $objPHPExcel->getActiveSheet()->getColumnDimension("E")->setWidth(0.5);
  $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(0.5);
  $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(0.5);
  $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(0.5);
  $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(5);
  $objPHPExcel->getActiveSheet()->getColumnDimension("M")->setWidth(35);
  $objPHPExcel->getActiveSheet()->getColumnDimension("N")->setWidth(0.5);
  $objPHPExcel->getActiveSheet()->getColumnDimension("P")->setWidth(0.5);
  $objPHPExcel->getActiveSheet()->getColumnDimension("R")->setWidth(0.5);
  $objPHPExcel->getActiveSheet()->getColumnDimension("T")->setWidth(0.5);

  //hoja 2
  //unset($objPHPExcel);
  //$objPHPExcel = new PHPExcel();
  //$objPHPExcel->setActiveSheetIndex(0);
  $objPHPExcel->createSheet(1);
  $objPHPExcel->setActiveSheetIndex(1);  
  $objPHPExcel->getActiveSheet()->setTitle('SUSPENDIDOS');
  
  $objPHPExcel->getActiveSheet()->mergeCells('A2:G2');
  $objPHPExcel->getActiveSheet()->setCellValue('A2', "REMITOS SUSPENDIDOS");
  
  $objPHPExcel->getActiveSheet()->mergeCells('A4:F4');
  $objPHPExcel->getActiveSheet()->setCellValue('A4', "Cliente: ".$empresa);
  $objPHPExcel->getActiveSheet()->getStyle('A4')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 26 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A5:E5');
  $objPHPExcel->getActiveSheet()->setCellValue('A5', "Periodo: ".$desde." al ".$hasta);
  $objPHPExcel->getActiveSheet()->getStyle('A5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F5:G5');
  $objPHPExcel->getActiveSheet()->setCellValue('F5', "Fecha: ".date("d/m/Y"));
  $objPHPExcel->getActiveSheet()->getStyle('F5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A7:B7');
  $objPHPExcel->getActiveSheet()->setCellValue('A7', "Numeros");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'A7:B7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('C7:E7');
  $objPHPExcel->getActiveSheet()->setCellValue('C7', "Contenido");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'C7:E7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F7:H7');
  $objPHPExcel->getActiveSheet()->setCellValue('F7', "Datos del Cliente");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'F7:H7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('I7:L7');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 7, 'Fechas');
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'I7:L7' );
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 8, 'Remito');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, 'Facturas');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 8, 'Bultos');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 8, 'Unidades');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 8, 'm3');   
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 8, 'Razon Social');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 8, 'Provincia');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 8, 'Localidad');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 8, 'Documento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 8, 'Ingreso');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, 8, 'Disponib.');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, 8, 'Diferimiento');
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true,
                                  'size'  => 11 ) 
      ),'A8:L8' );
  
  //busco los datos
  $sql = "SELECT nuevo_rem_cab.numero, nuevo_rem_cab.nro_factura, nuevo_rem_cab.bultos, nuevo_rem_cab.unidades, 
                 nuevo_rem_cab.volumen, clientes_emp.raz_soc, provincia.denominacion AS prov, 
                 localidad.denominacion AS loc, nuevo_rem_cab.fecha_doc, nuevo_rem_cab.fecha_ing, 
                 nuevo_rem_cab.fecha_disp, nuevo_rem_cab.fecha_difer
            FROM empresa, nuevo_rem_cab 
                              LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                                                         AND nuevo_rem_cab.empresa = clientes_emp.empresa) 
                              LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                                                      AND clientes_emp.provincia = localidad.provincia)
                              LEFT JOIN provincia ON (localidad.provincia = provincia.provincia)
           WHERE nuevo_rem_cab.empresa        = '$cod_empresa_mails'
             AND nuevo_rem_cab.empresa        = empresa.empresa
             AND ( nuevo_rem_cab.espera = 'S' OR nuevo_rem_cab.espera_logistica = 'S' )
             AND nuevo_rem_cab.estado  IN (1, 2, 3, 12)
        ORDER BY 6, 1, 2";
  $datosRemitos = $db->resultado($sql);

  $fila = 8;
  foreach($datosRemitos as $dato){
    $fila++;
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $fila, $dato['numero']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $fila, $dato['nro_factura']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $fila, $dato['bultos']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $fila, $dato['unidades']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $fila, $dato['volumen']);   
    $cliente = strtr($dato['raz_soc'], "¥", "nN");
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $fila, $cliente);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $fila, $dato['prov']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $fila, $dato['loc']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $fila, ymd_dmy($dato['fecha_doc']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $fila, ymd_dmy($dato['fecha_ing']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $fila, ymd_dmy($dato['fecha_disp']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $fila, ymd_dmy($dato['fecha_difer']));
    
    $objPHPExcel->getActiveSheet()->duplicateStyleArray(
    		array( 'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
               'font'      => array( 'bold' => true,
                                    'size'  => 11 ) 
        ),'A'.$fila.':L'.$fila );
  }
  $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(30);
  $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(20);
  $objPHPExcel->getActiveSheet()->getColumnDimension("H")->setWidth(20);
  $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("J")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(16);
  
  //hoja 3
  $objPHPExcel->createSheet(2);
  $objPHPExcel->setActiveSheetIndex(2);
  //$objPHPExcel->createSheet(1);
  //$objPHPExcel->setActiveSheetIndex(1);  
  $objPHPExcel->getActiveSheet()->setTitle('DIFERIDOS 10 DIAS');
  
  $objPHPExcel->getActiveSheet()->mergeCells('A2:H2');
  $objPHPExcel->getActiveSheet()->setCellValue('A2', "REMITOS DIFERIDOS PARA LOS PROXIMOS 10 DIAS");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array(       			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'font'      => array( 'bold' => true, 'size'  => 28 ) 
      ),'A2:G2' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A4:F4');
  $objPHPExcel->getActiveSheet()->setCellValue('A4', "Cliente: ".$empresa);
  $objPHPExcel->getActiveSheet()->getStyle('A4')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 26 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A5:E5');
  $objPHPExcel->getActiveSheet()->setCellValue('A5', "Periodo: ".$desde." al ".$hasta);
  $objPHPExcel->getActiveSheet()->getStyle('A5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F5:G5');
  $objPHPExcel->getActiveSheet()->setCellValue('F5', "Fecha: ".date("d/m/Y"));
  $objPHPExcel->getActiveSheet()->getStyle('F5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A7:B7');
  $objPHPExcel->getActiveSheet()->setCellValue('A7', "Numeros");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'A7:B7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('C7:E7');
  $objPHPExcel->getActiveSheet()->setCellValue('C7', "Contenido");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'C7:E7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F7:H7');
  $objPHPExcel->getActiveSheet()->setCellValue('F7', "Datos del Cliente");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'F7:H7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('I7:L7');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 7, 'Fechas');
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'I7:L7' );
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 8, 'Remito');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, 'Facturas');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 8, 'Bultos');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 8, 'Unidades');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 8, 'm3');   
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 8, 'Razon Social');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 8, 'Provincia');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 8, 'Localidad');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 8, 'Documento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 8, 'Ingreso');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, 8, 'Disponib.');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, 8, 'Diferimiento');
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true,
                                  'size'  => 11 ) 
      ),'A8:L8' );
  
  
  
  //busco los datos
  $sql = "SELECT nuevo_rem_cab.numero, nuevo_rem_cab.nro_factura, nuevo_rem_cab.bultos, nuevo_rem_cab.unidades, 
                 nuevo_rem_cab.volumen, clientes_emp.raz_soc, provincia.denominacion AS prov, 
                 localidad.denominacion AS loc, nuevo_rem_cab.fecha_doc, nuevo_rem_cab.fecha_ing, 
                 nuevo_rem_cab.fecha_disp, nuevo_rem_cab.fecha_difer
            FROM empresa, nuevo_rem_cab 
                              LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                                                         AND nuevo_rem_cab.empresa = clientes_emp.empresa) 
                              LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                                                      AND clientes_emp.provincia = localidad.provincia)
                              LEFT JOIN provincia ON (localidad.provincia = provincia.provincia) 
           WHERE nuevo_rem_cab.empresa        = '$cod_empresa_mails'
             AND nuevo_rem_cab.empresa        = empresa.empresa
             AND nuevo_rem_cab.fecha_difer IS NOT null
             AND nuevo_rem_cab.fecha_difer <= today + 10
             AND nuevo_rem_cab.estado  IN (1, 2, 3)
        ORDER BY 6, 1, 2";
  $datosRemitos = $db->resultado($sql);
  
  $fila = 8;
  foreach($datosRemitos as $dato){
    $fila++;
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $fila, $dato['numero']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $fila, $dato['nro_factura']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $fila, $dato['bultos']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $fila, $dato['unidades']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $fila, $dato['volumen']);   
    $cliente = strtr($dato['raz_soc'], "¥", "nN");
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $fila, $cliente);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $fila, $dato['prov']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $fila, $dato['loc']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $fila, ymd_dmy($dato['fecha_doc']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $fila, ymd_dmy($dato['fecha_ing']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $fila, ymd_dmy($dato['fecha_disp']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $fila, ymd_dmy($dato['fecha_difer']));
    
    $objPHPExcel->getActiveSheet()->duplicateStyleArray(
    		array( 'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
               'font'      => array( 'bold' => true,
                                    'size'  => 11 ) 
        ),'A'.$fila.':L'.$fila );
  }
  $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(30);
  $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(20);
  $objPHPExcel->getActiveSheet()->getColumnDimension("H")->setWidth(25);
  $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("J")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(16);
  
  //hoja 4
  $objPHPExcel->createSheet(3);
  $objPHPExcel->setActiveSheetIndex(3);
  //$objPHPExcel->createSheet(2);
  //$objPHPExcel->setActiveSheetIndex(2);

  $objPHPExcel->getActiveSheet()->setTitle("DIFER + 10 DIAS");
  
  $objPHPExcel->getActiveSheet()->mergeCells('A2:H2');
  $objPHPExcel->getActiveSheet()->setCellValue('A2', "REMITOS DIFERIDOS POR MAS DE 10 DIAS");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array(       			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'font'      => array( 'bold' => true, 'size'  => 28 ) 
      ),'A2:G2' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A4:F4');
  $objPHPExcel->getActiveSheet()->setCellValue('A4', "Cliente: ".$empresa);
  $objPHPExcel->getActiveSheet()->getStyle('A4')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 26 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A5:E5');
  $objPHPExcel->getActiveSheet()->setCellValue('A5', "Periodo: ".$desde." al ".$hasta);
  $objPHPExcel->getActiveSheet()->getStyle('A5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F5:G5');
  $objPHPExcel->getActiveSheet()->setCellValue('F5', "Fecha: ".date("d/m/Y"));
  $objPHPExcel->getActiveSheet()->getStyle('F5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A7:B7');
  $objPHPExcel->getActiveSheet()->setCellValue('A7', "Numeros");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'A7:B7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('C7:E7');
  $objPHPExcel->getActiveSheet()->setCellValue('C7', "Contenido");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'C7:E7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F7:H7');
  $objPHPExcel->getActiveSheet()->setCellValue('F7', "Datos del Cliente");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'F7:H7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('I7:L7');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 7, 'Fechas');
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'I7:L7' );
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 8, 'Remito');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, 'Facturas');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 8, 'Bultos');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 8, 'Unidades');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 8, 'm3');   
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 8, 'Razon Social');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 8, 'Provincia');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 8, 'Localidad');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 8, 'Documento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 8, 'Ingreso');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, 8, 'Disponib.');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, 8, 'Diferimiento');
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true,
                                  'size'  => 11 ) 
      ),'A8:L8' );
  
  
  
  //busco los datos
  $sql = "SELECT nuevo_rem_cab.numero, nuevo_rem_cab.nro_factura, nuevo_rem_cab.bultos, nuevo_rem_cab.unidades, 
                 nuevo_rem_cab.volumen, clientes_emp.raz_soc, provincia.denominacion AS prov, 
                 localidad.denominacion AS loc, nuevo_rem_cab.fecha_doc, nuevo_rem_cab.fecha_ing, 
                 nuevo_rem_cab.fecha_disp, nuevo_rem_cab.fecha_difer
            FROM empresa, nuevo_rem_cab 
                              LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                                                         AND nuevo_rem_cab.empresa = clientes_emp.empresa) 
                              LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                                                      AND clientes_emp.provincia = localidad.provincia)
                              LEFT JOIN provincia ON (localidad.provincia = provincia.provincia)
           WHERE nuevo_rem_cab.empresa        = '$cod_empresa_mails'
             AND nuevo_rem_cab.empresa        = empresa.empresa
             AND nuevo_rem_cab.fecha_difer IS NOT null
             AND nuevo_rem_cab.fecha_difer >= today + 12
             AND nuevo_rem_cab.estado  IN (1, 2, 3)
        ORDER BY 6, 1, 2";
  $datosRemitos = $db->resultado($sql);
  
  $fila = 8;
  foreach($datosRemitos as $dato){
    $fila++;
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $fila, $dato['numero']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $fila, $dato['nro_factura']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $fila, $dato['bultos']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $fila, $dato['unidades']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $fila, $dato['volumen']);   
    $cliente = strtr($dato['raz_soc'], "¥", "nN");
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $fila, $cliente);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $fila, $dato['prov']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $fila, $dato['loc']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $fila, ymd_dmy($dato['fecha_doc']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $fila, ymd_dmy($dato['fecha_ing']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $fila, ymd_dmy($dato['fecha_disp']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $fila, ymd_dmy($dato['fecha_difer']));
    
    $objPHPExcel->getActiveSheet()->duplicateStyleArray(
    		array( 'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
               'font'      => array( 'bold' => true,
                                    'size'  => 11 ) 
        ),'A'.$fila.':L'.$fila );
  }
  $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(30);
  $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(20);
  $objPHPExcel->getActiveSheet()->getColumnDimension("H")->setWidth(25);
  $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("J")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(16);

  //hoja 5
  $objPHPExcel->createSheet(4);
  $objPHPExcel->setActiveSheetIndex(4);
  //$objPHPExcel->createSheet(3);
  //$objPHPExcel->setActiveSheetIndex(3);

  $objPHPExcel->getActiveSheet()->setTitle('SIN STOCK');
  
  $objPHPExcel->getActiveSheet()->mergeCells('A2:H2');
  $objPHPExcel->getActiveSheet()->setCellValue('A2', "REMITOS SIN STOCK");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array(       			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'font'      => array( 'bold' => true, 'size'  => 28 ) 
      ),'A2:G2' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A4:F4');
  $objPHPExcel->getActiveSheet()->setCellValue('A4', "Cliente: ".$empresa);
  $objPHPExcel->getActiveSheet()->getStyle('A4')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 26 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A5:E5');
  $objPHPExcel->getActiveSheet()->setCellValue('A5', "Periodo: ".$desde." al ".$hasta);
  $objPHPExcel->getActiveSheet()->getStyle('A5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F5:G5');
  $objPHPExcel->getActiveSheet()->setCellValue('F5', "Fecha: ".date("d/m/Y"));
  $objPHPExcel->getActiveSheet()->getStyle('F5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A7:B7');
  $objPHPExcel->getActiveSheet()->setCellValue('A7', "Numeros");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'A7:B7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('C7:E7');
  $objPHPExcel->getActiveSheet()->setCellValue('C7', "Contenido");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'C7:E7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F7:H7');
  $objPHPExcel->getActiveSheet()->setCellValue('F7', "Datos del Cliente");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'F7:H7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('I7:L7');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 7, 'Fechas');
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'I7:L7' );
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 8, 'Remito');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, 'Facturas');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 8, 'Bultos');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 8, 'Unidades');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 8, 'm3');   
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 8, 'Razon Social');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 8, 'Provincia');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 8, 'Localidad');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 8, 'Documento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 8, 'Ingreso');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, 8, 'Disponib.');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, 8, 'Diferimiento');
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true,
                                  'size'  => 11 ) 
      ),'A8:L8' );
  
  
  
  //busco los datos
  $sql = "SELECT nuevo_rem_cab.numero, nuevo_rem_cab.nro_factura, nuevo_rem_cab.bultos, nuevo_rem_cab.unidades, 
                 nuevo_rem_cab.volumen, clientes_emp.raz_soc, provincia.denominacion AS prov, 
                 localidad.denominacion AS loc, nuevo_rem_cab.fecha_doc, nuevo_rem_cab.fecha_ing, 
                 nuevo_rem_cab.fecha_disp, nuevo_rem_cab.fecha_difer
            FROM empresa, nuevo_rem_cab 
                              LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                                                         AND nuevo_rem_cab.empresa = clientes_emp.empresa) 
                              LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                                                      AND clientes_emp.provincia = localidad.provincia)
                              LEFT JOIN provincia ON (localidad.provincia = provincia.provincia)
           WHERE nuevo_rem_cab.empresa        = '$cod_empresa_mails'
             AND nuevo_rem_cab.empresa        = empresa.empresa
             AND nuevo_rem_cab.estado IN ('1', '2')
        ORDER BY 6, 1, 2";
  $datosRemitos = $db->resultado($sql);
  
  $fila = 8;
  foreach($datosRemitos as $dato){
    $fila++;
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $fila, $dato['numero']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $fila, $dato['nro_factura']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $fila, $dato['bultos']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $fila, $dato['unidades']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $fila, $dato['volumen']);   
    $cliente = strtr($dato['raz_soc'], "¥", "nN");
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $fila, $cliente);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $fila, $dato['prov']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $fila, $dato['loc']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $fila, ymd_dmy($dato['fecha_doc']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $fila, ymd_dmy($dato['fecha_ing']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $fila, ymd_dmy($dato['fecha_disp']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $fila, ymd_dmy($dato['fecha_difer']));
    
    $objPHPExcel->getActiveSheet()->duplicateStyleArray(
    		array( 'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
               'font'      => array( 'bold' => true,
                                    'size'  => 11 ) 
        ),'A'.$fila.':L'.$fila );
  }
  $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(30);
  $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(20);
  $objPHPExcel->getActiveSheet()->getColumnDimension("H")->setWidth(25);
  $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("J")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(16);
  
  //hoja 6
  $objPHPExcel->createSheet(5);
  $objPHPExcel->setActiveSheetIndex(5);
  //$objPHPExcel->createSheet(4);
  //$objPHPExcel->setActiveSheetIndex(4);  
  $objPHPExcel->getActiveSheet()->setTitle('PENDIENTES');
  
  $objPHPExcel->getActiveSheet()->mergeCells('A2:H2');
  $objPHPExcel->getActiveSheet()->setCellValue('A2', "REMITOS PENDIENTES");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array(       			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'font'      => array( 'bold' => true, 'size'  => 28 ) 
      ),'A2:G2' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A4:F4');
  $objPHPExcel->getActiveSheet()->setCellValue('A4', "Cliente: ".$empresa);
  $objPHPExcel->getActiveSheet()->getStyle('A4')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 26 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A5:E5');
  $objPHPExcel->getActiveSheet()->setCellValue('A5', "Periodo: ".$desde." al ".$hasta);
  $objPHPExcel->getActiveSheet()->getStyle('A5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F5:G5');
  $objPHPExcel->getActiveSheet()->setCellValue('F5', "Fecha: ".date("d/m/Y"));
  $objPHPExcel->getActiveSheet()->getStyle('F5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A7:B7');
  $objPHPExcel->getActiveSheet()->setCellValue('A7', "Numeros");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'A7:B7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('C7:E7');
  $objPHPExcel->getActiveSheet()->setCellValue('C7', "Contenido");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'C7:E7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F7:H7');
  $objPHPExcel->getActiveSheet()->setCellValue('F7', "Datos del Cliente");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'F7:H7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('I7:O7');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 7, 'Fechas');
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'I7:O7' );
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 8, 'Remito');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, 'Facturas');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 8, 'Bultos');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 8, 'Unidades');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 8, 'm3');   
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 8, 'Razon Social');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 8, 'Provincia');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 8, 'Localidad');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 8, 'Documento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 8, 'Ingreso');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, 8, 'Disponib.');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, 8, 'Diferimiento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 8, 'Ini. Compromiso');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, 8, 'Lib. Comercial');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 8, 'Lib. Logistica');
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true,
                                  'size'  => 11 ) 
      ),'A8:O8' );
  
  
  
  //busco los datos
  $sql = "SELECT nuevo_rem_cab.numero, nuevo_rem_cab.nro_factura, nuevo_rem_cab.bultos, nuevo_rem_cab.unidades, 
                 nuevo_rem_cab.volumen, clientes_emp.raz_soc, provincia.denominacion AS prov, 
                 localidad.denominacion AS loc, nuevo_rem_cab.fecha_doc, nuevo_rem_cab.fecha_ing, 
                 nuevo_rem_cab.fecha_disp, nuevo_rem_cab.fecha_difer,
                 nuevo_rem_cab.fecha_ini_comp, nuevo_rem_cab.fecha_libera,
                 nuevo_rem_cab.fecha_libera_log
            FROM empresa, nuevo_rem_cab 
                              LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                                                         AND nuevo_rem_cab.empresa = clientes_emp.empresa) 
                              LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                                                      AND clientes_emp.provincia = localidad.provincia)
                              LEFT JOIN provincia ON (localidad.provincia = provincia.provincia)
           WHERE nuevo_rem_cab.empresa        = '$cod_empresa_mails'
             AND nuevo_rem_cab.empresa        = empresa.empresa
             AND (
                   (nuevo_rem_cab.estado = 2 AND nuevo_rem_cab.fecha_difer IS null)
                   OR
                   (nuevo_rem_cab.estado = 2 AND nuevo_rem_cab.fecha_difer <= today)
                   OR
                   (nuevo_rem_cab.estado = 3 AND fecha_difer IS null AND espera = 'N' AND espera_logistica = 'N')
                   OR
                   (nuevo_rem_cab.estado = 3 AND fecha_difer IS NOT null AND espera = 'N' AND espera_logistica = 'N' AND fecha_difer <= today)
                   OR
                   (nuevo_rem_cab.estado = 12)
                   OR
                   (nuevo_rem_cab.estado = 8)
                 )
             AND nuevo_rem_cab.espera != 'S'
             AND nuevo_rem_cab.espera_logistica != 'S'
        ORDER BY 6, 1, 2";
  $datosRemitos = $db->resultado($sql);
  
  $fila = 8;

  foreach($datosRemitos as $dato){
    $fila++;
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $fila, $dato['numero']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $fila, $dato['nro_factura']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $fila, $dato['bultos']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $fila, $dato['unidades']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $fila, $dato['volumen']);   
    $cliente = strtr($dato['raz_soc'], "¥", "nN");
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $fila, $cliente);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $fila, $dato['prov']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $fila, $dato['loc']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $fila, ymd_dmy($dato['fecha_doc']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $fila, ymd_dmy($dato['fecha_ing']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $fila, ymd_dmy($dato['fecha_disp']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $fila, ymd_dmy($dato['fecha_difer']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, $fila, ymd_dmy($dato['fecha_ini_comp']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, $fila, ymd_dmy($dato['fecha_libera']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $fila, ymd_dmy($dato['fecha_libera_log']));
    
    $objPHPExcel->getActiveSheet()->duplicateStyleArray(
    		array( 'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
               'font'      => array( 'bold' => true,
                                    'size'  => 11 ) 
        ),'A'.$fila.':O'.$fila );
  }
  $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(30);
  $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(20);
  $objPHPExcel->getActiveSheet()->getColumnDimension("H")->setWidth(25);
  $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("J")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("M")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("N")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("O")->setWidth(16);
  
  //hoja 7                                   
  $objPHPExcel->createSheet(6);
  $objPHPExcel->setActiveSheetIndex(6);  
  $objPHPExcel->getActiveSheet()->setTitle('TRANSITO');
  
  $objPHPExcel->getActiveSheet()->mergeCells('A2:H2');
  $objPHPExcel->getActiveSheet()->setCellValue('A2', "REMITOS EN TRANSITO");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array(       			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'font'      => array( 'bold' => true, 'size'  => 28 ) 
      ),'A2:G2' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A4:F4');
  $objPHPExcel->getActiveSheet()->setCellValue('A4', "Cliente: ".$empresa);
  $objPHPExcel->getActiveSheet()->getStyle('A4')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 26 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A5:E5');
  $objPHPExcel->getActiveSheet()->setCellValue('A5', "Periodo: ".$desde." al ".$hasta);
  $objPHPExcel->getActiveSheet()->getStyle('A5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F5:G5');
  $objPHPExcel->getActiveSheet()->setCellValue('F5', "Fecha: ".date("d/m/Y"));
  $objPHPExcel->getActiveSheet()->getStyle('F5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A7:B7');
  $objPHPExcel->getActiveSheet()->setCellValue('A7', "Numeros");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'A7:B7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('C7:E7');
  $objPHPExcel->getActiveSheet()->setCellValue('C7', "Contenido");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'C7:E7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F7:H7');
  $objPHPExcel->getActiveSheet()->setCellValue('F7', "Datos del Cliente");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'F7:H7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('I7:N7');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 7, 'Fechas');
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'I7:N7' );
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 8, 'Remito');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, 'Facturas');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 8, 'Bultos');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 8, 'Unidades');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 8, 'm3');   
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 8, 'Razon Social');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 8, 'Provincia');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 8, 'Localidad');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 8, 'Documento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 8, 'Ingreso');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, 8, 'Disponib.');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, 8, 'Diferimiento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 8, 'Lib. Comercial');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, 8, 'Lib. Logistica');
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true,
                                  'size'  => 11 ) 
      ),'A8:N8' );
  
  //busco los datos
  $sql = "SELECT nuevo_rem_cab.numero, nuevo_rem_cab.nro_factura, nuevo_rem_cab.bultos, nuevo_rem_cab.unidades, 
                 nuevo_rem_cab.volumen, clientes_emp.raz_soc, provincia.denominacion AS prov, 
                 localidad.denominacion AS loc, nuevo_rem_cab.fecha_doc, nuevo_rem_cab.fecha_ing, 
                 nuevo_rem_cab.fecha_disp, nuevo_rem_cab.fecha_difer,
                 nuevo_rem_cab.fecha_libera, nuevo_rem_cab.fecha_libera_log
            FROM empresa, nuevo_rem_cab 
                              LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                                                         AND nuevo_rem_cab.empresa = clientes_emp.empresa) 
                              LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                                                      AND clientes_emp.provincia = localidad.provincia)
                              LEFT JOIN provincia ON (localidad.provincia = provincia.provincia)
           WHERE nuevo_rem_cab.empresa        = '$cod_empresa_mails'
             AND nuevo_rem_cab.empresa        = empresa.empresa
             AND nuevo_rem_cab.fecha_conf_ent IS NULL
             AND nuevo_rem_cab.estado         = 6
        ORDER BY 6, 1, 2";
  $datosRemitos = $db->resultado($sql);
  
  $fila = 8;
  foreach($datosRemitos as $dato){
    $fila++;
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $fila, $dato['numero']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $fila, $dato['nro_factura']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $fila, $dato['bultos']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $fila, $dato['unidades']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $fila, $dato['volumen']);   
    $cliente = strtr($dato['raz_soc'], "¥", "nN");
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $fila, $cliente);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $fila, $dato['prov']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $fila, $dato['loc']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $fila, ymd_dmy($dato['fecha_doc']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $fila, ymd_dmy($dato['fecha_ing']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $fila, ymd_dmy($dato['fecha_disp']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $fila, ymd_dmy($dato['fecha_difer']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, $fila, ymd_dmy($dato['fecha_libera']));
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, $fila, ymd_dmy($dato['fecha_libera_log']));
    
    $objPHPExcel->getActiveSheet()->duplicateStyleArray(
    		array( 'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
               'font'      => array( 'bold' => true,
                                    'size'  => 11 ) 
        ),'A'.$fila.':N'.$fila );
  }
  $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(30);
  $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(20);
  $objPHPExcel->getActiveSheet()->getColumnDimension("H")->setWidth(25);
  $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("J")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("M")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("N")->setWidth(16);
  
  //hoja 8                                   
  $objPHPExcel->createSheet(7);
  $objPHPExcel->setActiveSheetIndex(7);
  //$objPHPExcel->createSheet(8);
  //$objPHPExcel->setActiveSheetIndex(8);  
  $objPHPExcel->getActiveSheet()->setTitle('EN TERMINO');
  
  $objPHPExcel->getActiveSheet()->mergeCells('A2:H2');
  $objPHPExcel->getActiveSheet()->setCellValue('A2', "REMITOS ENTREGADOS EN TERMINO");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array(       			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'font'      => array( 'bold' => true, 'size'  => 28 ) 
      ),'A2:G2' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A4:F4');
  $objPHPExcel->getActiveSheet()->setCellValue('A4', "Cliente: ".$empresa);
  $objPHPExcel->getActiveSheet()->getStyle('A4')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 26 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A5:E5');
  $objPHPExcel->getActiveSheet()->setCellValue('A5', "Periodo: ".$desde." al ".$hasta);
  $objPHPExcel->getActiveSheet()->getStyle('A5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F5:G5');
  $objPHPExcel->getActiveSheet()->setCellValue('F5', "Fecha: ".date("d/m/Y"));
  $objPHPExcel->getActiveSheet()->getStyle('F5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A7:B7');
  $objPHPExcel->getActiveSheet()->setCellValue('A7', "Numeros");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'A7:B7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('C7:E7');
  $objPHPExcel->getActiveSheet()->setCellValue('C7', "Contenido");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'C7:E7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F7:H7');
  $objPHPExcel->getActiveSheet()->setCellValue('F7', "Datos del Cliente");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'F7:H7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('I7:P7');
  $objPHPExcel->getActiveSheet()->setCellValue('I7', 'Fechas');
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'I7:P7' );
      
  $objPHPExcel->getActiveSheet()->mergeCells('Q7:R7');
  $objPHPExcel->getActiveSheet()->setCellValue('Q7', 'Dias');
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'Q7:R7' );    
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 8, 'Remito');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, 'Facturas');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 8, 'Bultos');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 8, 'Unidades');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 8, 'm3');   
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 8, 'Razon Social');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 8, 'Provincia');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 8, 'Localidad');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 8, 'Documento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 8, 'Ingreso');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, 8, 'Disponib.');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, 8, 'Diferimiento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 8, 'Lib. Comercial');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, 8, 'Lib. Logistica');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 8, 'Certificacion');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(15, 8, 'Entrega');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 8, 'Habiles');
  //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(17, 8, 'Estandar');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(17, 8, 'Diferencia');
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true,
                                  'size'  => 11 ) 
      ),'A8:R8' );
  
  //busco los datos
  $sql = "SELECT nuevo_rem_cab.numero, nuevo_rem_cab.nro_factura, nuevo_rem_cab.bultos, nuevo_rem_cab.unidades, 
                 nuevo_rem_cab.volumen, clientes_emp.raz_soc, provincia.denominacion AS prov, 
                 localidad.denominacion AS loc, nuevo_rem_cab.fecha_doc, nuevo_rem_cab.fecha_ing, 
                 nuevo_rem_cab.fecha_disp, nuevo_rem_cab.fecha_difer,
                 nuevo_rem_cab.fecha_libera, nuevo_rem_cab.fecha_libera_log,
                 nuevo_rem_cab.fecha_certifica, nuevo_rem_cab.fecha_prev_ent,
                 nuevo_rem_cab.fecha_ini_comp, nuevo_rem_cab.fecha_entrega, nuevo_rem_cab.fecha_conf_ent,
                 nuevo_rem_cab.dias_demora_prev, provincia.provincia, localidad.localidad,
                 nuevo_rem_cab.dias_demora
            FROM empresa, nuevo_rem_cab 
                              LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                                                         AND nuevo_rem_cab.empresa = clientes_emp.empresa) 
                              LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                                                      AND clientes_emp.provincia = localidad.provincia)
                              LEFT JOIN provincia ON (localidad.provincia = provincia.provincia)
           WHERE nuevo_rem_cab.empresa           = '$cod_empresa_mails'
             AND nuevo_rem_cab.empresa           = empresa.empresa
             AND(
                 (nuevo_rem_cab.estado   = 11
                  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
                  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
                OR
                 (nuevo_rem_cab.estado   = 6
                  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
                  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
                ) 
  
             AND nuevo_rem_cab.dias_demora_prev <= 0
        ORDER BY 6, 1, 2";
  $datosRemitos = $db->resultado($sql);
  
  $fila = 8;
  foreach($datosRemitos as $dato){

    /*$habiles = $dato['dias_demora'];
  
    //buscamos los dias de la tabla de tiempos_estandar
    $sql = "SELECT dias
              FROM tiempos_estandar
             WHERE provincia = '$dato[provincia]'
               AND localidad = '$dato[localidad]'";
    //if($dato['numero'] == '34644')die($habiles." - ".$sql);
    $dias_estandar = $db->campos($sql, 'dias') + 1;
      
    $diferencia = $habiles - $dias_estandar;
  
    if($diferencia <= 0){*/
      $fila++;
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $fila, $dato['numero']);
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $fila, $dato['nro_factura']);
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $fila, $dato['bultos']);
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $fila, $dato['unidades']);
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $fila, $dato['volumen']);   
      $cliente = strtr($dato['raz_soc'], "¥", "nN");
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $fila, $cliente);
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $fila, $dato['prov']);
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $fila, $dato['loc']);
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $fila, ymd_dmy($dato['fecha_doc']));
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $fila, ymd_dmy($dato['fecha_ing']));
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $fila, ymd_dmy($dato['fecha_disp']));
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $fila, ymd_dmy($dato['fecha_difer']));
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, $fila, ymd_dmy($dato['fecha_libera']));
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, $fila, ymd_dmy($dato['fecha_libera_log']));
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $fila, ymd_dmy($dato['fecha_certifica']));
      if($dato['fecha_entrega']){
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(15, $fila, ymd_dmy($dato['fecha_entrega']));
      }else{
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(15, $fila, ymd_dmy($dato['fecha_conf_ent']));
      }
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, $fila, $habiles);
      //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(17, $fila, $dias_estandar);
      $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(17, $fila, $diferencia);
  
      $objPHPExcel->getActiveSheet()->duplicateStyleArray(
      		array( 'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
                 'font'      => array( 'bold' => true,
                                      'size'  => 11 ) 
          ),'A'.$fila.':R'.$fila );
    //}      
  }
  $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(30);
  $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(20);
  $objPHPExcel->getActiveSheet()->getColumnDimension("H")->setWidth(25);
  $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("J")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("M")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("N")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("O")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("P")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("R")->setWidth(20);
  
  //hoja 9                                   
  $objPHPExcel->createSheet(8);
  $objPHPExcel->setActiveSheetIndex(8);
  //$objPHPExcel->createSheet(9);
  //$objPHPExcel->setActiveSheetIndex(9);  
  $objPHPExcel->getActiveSheet()->setTitle('F. DE TERMINO');
  
  $objPHPExcel->getActiveSheet()->mergeCells('A2:H2');
  $objPHPExcel->getActiveSheet()->setCellValue('A2', "REMITOS ENTREGADOS FUERA DE TERMINO");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array(       			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'font'      => array( 'bold' => true, 'size'  => 28 ) 
      ),'A2:G2' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A4:F4');
  $objPHPExcel->getActiveSheet()->setCellValue('A4', "Cliente: ".$empresa);
  $objPHPExcel->getActiveSheet()->getStyle('A4')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 26 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A5:E5');
  $objPHPExcel->getActiveSheet()->setCellValue('A5', "Periodo: ".$desde." al ".$hasta);
  $objPHPExcel->getActiveSheet()->getStyle('A5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F5:G5');
  $objPHPExcel->getActiveSheet()->setCellValue('F5', "Fecha: ".date("d/m/Y"));
  $objPHPExcel->getActiveSheet()->getStyle('F5')->applyFromArray(
  		array(
  			'alignment' => array(
  				'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
        'font' => array(
          'size' => 14 ) ) );
  
  $objPHPExcel->getActiveSheet()->mergeCells('A7:B7');
  $objPHPExcel->getActiveSheet()->setCellValue('A7', "Numeros");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'A7:B7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('C7:E7');
  $objPHPExcel->getActiveSheet()->setCellValue('C7', "Contenido");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'C7:E7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('F7:H7');
  $objPHPExcel->getActiveSheet()->setCellValue('F7', "Datos del Cliente");
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'F7:H7' );
  
  $objPHPExcel->getActiveSheet()->mergeCells('I7:P7');
  $objPHPExcel->getActiveSheet()->setCellValue('I7', 'Fechas');
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'I7:P7' );
      
  $objPHPExcel->getActiveSheet()->mergeCells('Q7:R7');
  $objPHPExcel->getActiveSheet()->setCellValue('Q7', 'Dias');
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true, 'size'  => 14 ) 
      ),'Q7:R7' );    
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 8, 'Remito');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, 'Facturas');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 8, 'Bultos');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 8, 'Unidades');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 8, 'm3');   
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 8, 'Razon Social');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 8, 'Provincia');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 8, 'Localidad');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 8, 'Documento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, 8, 'Ingreso');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, 8, 'Disponib.');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, 8, 'Diferimiento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, 8, 'Lib. Comercial');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, 8, 'Lib. Logistica');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, 8, 'Certificacion');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(15, 8, 'Entrega');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, 8, 'Habiles');
  //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(17, 8, 'Estandar');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(17, 8, 'Diferencia');
  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true,
                                  'size'  => 11 ) 
      ),'A8:R8' );
  
  //busco los datos
  $sql = "SELECT nuevo_rem_cab.numero, nuevo_rem_cab.nro_factura, nuevo_rem_cab.bultos, nuevo_rem_cab.unidades, 
                 nuevo_rem_cab.volumen, clientes_emp.raz_soc, provincia.denominacion AS prov, 
                 localidad.denominacion AS loc, nuevo_rem_cab.fecha_doc, nuevo_rem_cab.fecha_ing, 
                 nuevo_rem_cab.fecha_disp, nuevo_rem_cab.fecha_difer,
                 nuevo_rem_cab.fecha_libera, nuevo_rem_cab.fecha_libera_log,
                 nuevo_rem_cab.fecha_certifica, nuevo_rem_cab.fecha_prev_ent,
                 nuevo_rem_cab.fecha_ini_comp, nuevo_rem_cab.fecha_entrega, nuevo_rem_cab.fecha_conf_ent,
                 nuevo_rem_cab.dias_demora_prev, provincia.provincia, localidad.localidad,
                 nuevo_rem_cab.dias_demora
  FROM nuevo_rem_cab LEFT JOIN empresa ON (nuevo_rem_cab.empresa = empresa.empresa)
  LEFT JOIN clientes_emp ON (nuevo_rem_cab.codigo_cliente = clientes_emp.codigo
                          AND nuevo_rem_cab.empresa = clientes_emp.empresa)
  LEFT JOIN localidad ON (clientes_emp.localidad = localidad.localidad
                         AND clientes_emp.provincia = localidad.provincia)
  LEFT JOIN provincia ON (provincia.provincia = localidad.provincia) 
  WHERE nuevo_rem_cab.empresa           = '$cod_empresa_mails'
  AND(
  (nuevo_rem_cab.estado   = 11
  AND nuevo_rem_cab.fecha_entrega IS NOT NULL 
  AND nuevo_rem_cab.fecha_entrega BETWEEN '$desde' AND '$hasta')
  OR
  (nuevo_rem_cab.estado   = 6
  AND nuevo_rem_cab.fecha_conf_ent IS NOT NULL 
  AND nuevo_rem_cab.fecha_conf_ent BETWEEN '$desde' AND '$hasta')
  ) 
  AND nuevo_rem_cab.dias_demora_prev  >= 1
  ORDER BY 6, 1, 2";
  $datosRemitos = $db->resultado($sql);
//debug($datosRemitos,1);  
  $fila = 8;
  foreach($datosRemitos as $dato){
  

    //$habiles = $dato['dias_demora_prev'];
    $habiles = $dato['dias_demora'];
  
    //buscamos los dias de la tabla de tiempos_estandar
    $sql = "SELECT dias
              FROM tiempos_estandar
             WHERE provincia = '$dato[provincia]'
               AND localidad = '$dato[localidad]'";
    $dias_estandar = $db->campos($sql, 'dias') + 1;
  
    if($dato['raz_soc']){
      $diferencia = $habiles - $dias_estandar;
    
      //if($diferencia >= 0){
        $fila++;
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $fila, $dato['numero']);
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $fila, $dato['nro_factura']);
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $fila, $dato['bultos']);
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $fila, $dato['unidades']);
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $fila, $dato['volumen']);   
        $cliente = strtr($dato['raz_soc'], "¥", "nN");
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $fila, $cliente);
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $fila, $dato['prov']);
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $fila, $dato['loc']);
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $fila, ymd_dmy($dato['fecha_doc']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $fila, ymd_dmy($dato['fecha_ing']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $fila, ymd_dmy($dato['fecha_disp']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $fila, ymd_dmy($dato['fecha_difer']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, $fila, ymd_dmy($dato['fecha_libera']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, $fila, ymd_dmy($dato['fecha_libera_log']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $fila, ymd_dmy($dato['fecha_certifica']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(15, $fila, ymd_dmy($dato['fecha_entrega']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, $fila, $habiles);
        //$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(17, $fila, $dias_estandar);
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(17, $fila, $diferencia);
        
        $objPHPExcel->getActiveSheet()->duplicateStyleArray(
        		array( 'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
                   'font'      => array( 'bold' => true,
                                        'size'  => 11 ) 
            ),'A'.$fila.':R'.$fila );
      //}
    }       
  }
  $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(30);
  $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(20);
  $objPHPExcel->getActiveSheet()->getColumnDimension("H")->setWidth(25);
  $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("J")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("M")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("N")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("O")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("P")->setWidth(16);
  $objPHPExcel->getActiveSheet()->getColumnDimension("R")->setWidth(20);

  //hoja 10                                   
  $objPHPExcel->createSheet(9);
  $objPHPExcel->setActiveSheetIndex(9);
  $objPHPExcel->getActiveSheet()->setTitle('Glosario');
  
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 1, '1- Fecha Documento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 2, '2- Fecha Ingreso');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 3, '3- Fecha Disponib.');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 4, '4- Fecha Diferimiento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 5, '5- Fecha Inicio de Compromiso');   
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 6, '6- Fecha Liberacion Log.');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 7, '7- Fecha Certificacion');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 8, '8- Dias Habiles');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 9, '9- Dias Estandar');

  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 1, 'Fecha documento impreso');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 2, 'Fecha ingreso a sistema GL');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 3, 'Fecha de reserva de stock');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 4, 'Fecha de diferimiento de entrega');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 5, 'Fecha de inicio de comprimiso de entrega');   
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 6, 'Fecha liberacion de suspension de documento');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 7, 'Fecha despacho del remito');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, 'Dias habiles trascurridos desde la fecha de inicio de compromiso a la fecha de entrega');
  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 9, 'Dias necesarios para entrega mercaderia en Provincia/Localidad');

  
  $objPHPExcel->getActiveSheet()->duplicateStyleArray(
  		array( 'borders'   =>  array( 'left'  => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'right' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                   'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ),
                                  'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ),      			
             'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT ),
             'fill'      => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID,
     	  			                     'startcolor' => array( 'argb' => 'FFFFFF99' ) ),
             'font'      => array( 'bold' => true,
                                  'size'  => 11 ) 
      ),'A1:B9' );
  $objPHPExcel->getActiveSheet()->getColumnDimension("A")->setWidth(30);
  $objPHPExcel->getActiveSheet()->getColumnDimension("B")->setWidth(80);


  $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
  $objWriter->save( __DIR__.'/tmp/'.'indicadoresRemitos'.'.xls' );

  header("Content-type: application/vnd.ms-excel");
  header('Cache-Control: max-age=0');
  header("Content-disposition: attachment; filename=indicadoresRemitos.xls");
  $objWriter->save('php://output');                                          
}
?>