<?php
session_start(); 
$ruta = '../../';
require_once("../clases/covensol_fop_c_formulacion.php");
$objfop=new covensol_fop_c_formulacion($propiedades);
//$objscc->cargar_seguridad("SCC","covensol_scc_d_movimiento.php");
/* PHPExcel */
require_once ($ruta.'shared/PHPExcel/Classes/PHPExcel.php');

$fecha_actual = date("d/m/Y");

if(!$_GET['anopresup'] or !$_GET['estcla'] or !$_GET['codestpro1'] or !$_GET['denestpro1']){

		print "<script language=JavaScript>";
		echo "alert('ERROR: Faltan datos para generar el reporte');";
		print "close();";		
		print "</script>";
		exit();
}

if($_GET['tiporep']=='fases' and (!$_GET['codplangob'] or !$_GET['anopresup'] or !$_GET['estcla'] or !$_GET['codestpro1'] or !$_GET['denestpro1'] or !$_GET['nroh'])){

		print "<script language=JavaScript>";
		echo "alert('ERROR: Faltan datos para generar el reporte de fase');";
		print "close();";		
		print "</script>";
		exit();
}

$param = $_GET;	
$param['criterio']='por_codigo';

// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator($_SESSION["la_logusr"])
							 ->setLastModifiedBy($_SESSION["la_logusr"])
							 ->setTitle("RESUMEN DE CUENTAS")
							 ->setSubject("RESUMEN DE CUENTAS")
							 ->setDescription("RESUMEN DE CUENTAS DEL POA");


$datosenc = $objfop->FormatLonCodEstPro($param);
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setTitle('RESUMEN DE CUENTAS');

$objRichText = new PHPExcel_RichText();

$ancho['B']=30;
$ancho['G']=70;
$i=2;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$i, 'AÑO:');
$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$i,$datosenc['anopresup']);
$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getFont()->setBold(false);
$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth($ancho['B']);
$i++;

if($param['denhist']){
		$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$i, 'FASE:');
		$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
		$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
		
		$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$i,'('.$param['abvrhist'].') - '.$param['denhist']);
		$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getFont()->setBold(false);
		$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
		$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
		$i++;
}

if($datosenc['codestpro1']){
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$i, 'Estructura (ep1):');
	$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getFont()->setBold(true);
	$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
	$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
	
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$i,$datosenc['codestpro1'].' - '.utf8_encode($datosenc['denestpro1']));
	$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getFont()->setBold(false);
	$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
	$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth($ancho['B']);
	$i++;
}

if($datosenc['codestpro2']){
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$i, 'Estructura (ep2):');
	$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getFont()->setBold(true);
	$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
	$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
	
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$i,$datosenc['codestpro2'].' - '.utf8_encode($datosenc['denestpro2']));
	$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getFont()->setBold(false);
	$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
	$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth($ancho['B']);
	$i++;
}

if($datosenc['codestpro3']){
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$i, 'Estructura (ep3):');
	$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getFont()->setBold(true);
	$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
	$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
	
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$i,$datosenc['codestpro3'].' - '.utf8_encode($datosenc['denestpro3']));
	$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getFont()->setBold(false);
	$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
	$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth($ancho['B']);
	$i++;
}

$i++;

$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getFill()->getStartColor()->setARGB('FFCCCCCC');
$objPHPExcel->getActiveSheet()->getStyle('A'.$i.':'.'S'.$i)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFCCCCCC');


//$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getFont()->getColor()->setARGB("FFFFFF66");
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$i, 'ACTIVIDAD');
$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$i, 'UNIDAD');
$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth($ancho['B']);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C'.$i, 'META');
$objPHPExcel->getActiveSheet()->getStyle('C'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D'.$i, 'ESTADO');
$objPHPExcel->getActiveSheet()->getStyle('D'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E'.$i, 'CIUDAD');
$objPHPExcel->getActiveSheet()->getStyle('E'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F'.$i, 'CUENTA');
$objPHPExcel->getActiveSheet()->getStyle('F'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);


$objPHPExcel->setActiveSheetIndex(0)->setCellValue('G'.$i, 'DENOMINACIÓN');
$objPHPExcel->getActiveSheet()->getStyle('G'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('G'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth($ancho['G']);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('H'.$i, 'REC. PROP.');
$objPHPExcel->getActiveSheet()->getStyle('H'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('H'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('I'.$i, 'OTROS REC.');
$objPHPExcel->getActiveSheet()->getStyle('I'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('I'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('J'.$i, 'SUBTOT');
$objPHPExcel->getActiveSheet()->getStyle('J'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('J'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);


$objPHPExcel->setActiveSheetIndex(0)->setCellValue('K'.$i, 'DIST. FISIC. I');
$objPHPExcel->getActiveSheet()->getStyle('K'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('K'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('L'.$i, 'DIST. FISIC. II');
$objPHPExcel->getActiveSheet()->getStyle('L'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('L'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('M'.$i, 'DIST. FISIC. III');
$objPHPExcel->getActiveSheet()->getStyle('M'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('M'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('N'.$i, 'DIST. FISIC. IV');
$objPHPExcel->getActiveSheet()->getStyle('N'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('N'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setAutoSize(true);


$objPHPExcel->setActiveSheetIndex(0)->setCellValue('O'.$i, 'DIST. FINAN. I');
$objPHPExcel->getActiveSheet()->getStyle('O'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('O'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('P'.$i, 'DIST. FINAN. II');
$objPHPExcel->getActiveSheet()->getStyle('P'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('P'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('Q'.$i, 'DIST. FINAN. III');
$objPHPExcel->getActiveSheet()->getStyle('Q'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('Q'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('R'.$i, 'DIST. FINAN. IV');
$objPHPExcel->getActiveSheet()->getStyle('R'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('R'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setAutoSize(true);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('S'.$i, 'SUB. TOT. DIST.');
$objPHPExcel->getActiveSheet()->getStyle('S'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('S'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setAutoSize(true);
$i++;

if($param['tiporep']=='fases'){$resp = $objfop->ConsultaDtEp3Fases($param);}
else{$resp = $objfop->ConsultaDtEp3($param);}

foreach($resp['rs'] as $datos){
	
	$datos['subtot'] = $datos['monrecprop'] + $datos['monotrorec'];
					
	$total += $datos['subtot'];
	$subtotrecprop += $datos['monrecprop'];
	$subtototrorec += $datos['monotrorec'];
	
	
	$total1 += $datos['pfn_t1'];
	$total2 += $datos['pfn_t2'];
	$total3 += $datos['pfn_t3'];
	$total4 += $datos['pfn_t4'];
	$totaldist += ($datos['pfn_t1']+$datos['pfn_t2']+$datos['pfn_t3']+$datos['pfn_t4']);
	
	$datos['feciniact']=$objfop->io_conexiones->formatea_fecha_normal($datos['feciniact']);
	$datos['fecfinact']=$objfop->io_conexiones->formatea_fecha_normal($datos['fecfinact']);
	
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$i, utf8_encode($datos['actividad']));    
	$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
	
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$i, $datos['desunimed']);
	$objPHPExcel->getActiveSheet()->getStyle('B'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
	
	$objPHPExcel->getActiveSheet()->getStyle('C'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C'.$i, $datos['meta']);
	
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D'.$i, $datos['desest']);
	$objPHPExcel->getActiveSheet()->getStyle('D'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
	
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E'.$i, $datos['desciu']);
	$objPHPExcel->getActiveSheet()->getStyle('E'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
		
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F'.$i, $datos['spg_cuenta']);
	$objPHPExcel->getActiveSheet()->getStyle('F'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
	
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('G'.$i, $datos['denominacion']);
	$objPHPExcel->getActiveSheet()->getStyle('G'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
	
	$objPHPExcel->getActiveSheet()->getStyle('H'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('H'.$i, $datos['monrecprop']);
	
	$objPHPExcel->getActiveSheet()->getStyle('I'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('I'.$i, $datos['monotrorec']);
	
	$objPHPExcel->getActiveSheet()->getStyle('J'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('J'.$i, $datos['subtot']);
	
	
	$objPHPExcel->getActiveSheet()->getStyle('K'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('K'.$i, $datos['pfs_t1']);
	
	$objPHPExcel->getActiveSheet()->getStyle('L'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('L'.$i, $datos['pfs_t2']);
	
	$objPHPExcel->getActiveSheet()->getStyle('M'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('M'.$i, $datos['pfs_t3']);
	
	$objPHPExcel->getActiveSheet()->getStyle('N'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('N'.$i, $datos['pfs_t4']);
	
	
	$objPHPExcel->getActiveSheet()->getStyle('O'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('O'.$i, $datos['pfn_t1']);
	
	$objPHPExcel->getActiveSheet()->getStyle('P'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('P'.$i, $datos['pfn_t2']);
	
	$objPHPExcel->getActiveSheet()->getStyle('Q'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('Q'.$i, $datos['pfn_t3']);
	
	$objPHPExcel->getActiveSheet()->getStyle('R'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('R'.$i, $datos['pfn_t4']);
	
	$objPHPExcel->getActiveSheet()->getStyle('S'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
	$objPHPExcel->setActiveSheetIndex(0)->setCellValue('S'.$i, ($datos['pfn_t1']+$datos['pfn_t2']+$datos['pfn_t3']+$datos['pfn_t4']));
	
	$i++;
}

$objPHPExcel->getActiveSheet()->getStyle('A'.$i)->getFill()->getStartColor()->setARGB('FFCCCCCC');
$objPHPExcel->getActiveSheet()->getStyle('H'.$i.':'.'S'.$i)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFCCCCCC');


$objPHPExcel->setActiveSheetIndex(0)->setCellValue('G'.$i, "TOTALES:");
$objPHPExcel->getActiveSheet()->getStyle('G'.$i)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('G'.$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);

$objPHPExcel->getActiveSheet()->getStyle('H'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle('H'.$i)->getFont()->setBold(true);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('H'.$i, $subtotrecprop);

$objPHPExcel->getActiveSheet()->getStyle('I'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle('I'.$i)->getFont()->setBold(true);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('I'.$i, $subtototrorec);

$objPHPExcel->getActiveSheet()->getStyle('J'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle('J'.$i)->getFont()->setBold(true);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('J'.$i, $total);


$objPHPExcel->getActiveSheet()->getStyle('O'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle('O'.$i)->getFont()->setBold(true);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('O'.$i, $total1);

$objPHPExcel->getActiveSheet()->getStyle('P'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle('P'.$i)->getFont()->setBold(true);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('P'.$i, $total2);

$objPHPExcel->getActiveSheet()->getStyle('Q'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle('Q'.$i)->getFont()->setBold(true);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('Q'.$i, $total3);

$objPHPExcel->getActiveSheet()->getStyle('R'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle('R'.$i)->getFont()->setBold(true);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('R'.$i, $total4);

$objPHPExcel->getActiveSheet()->getStyle('S'.$i)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle('S'.$i)->getFont()->setBold(true);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('S'.$i, $totaldist);

// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="resumen_partidas_'.date('d_m_Y').'.xls"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit();