<?php 
require_once "../../common/include/ambiente.inc";
require_once '../../common/include/PhpExcel/PHPExcel.php';

$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Kronos Srl")
							->setLastModifiedBy("AMD ")
	->setTitle("Soci AMD")
->setSubject("Soci AMD")
->setDescription("Soci AMD")
->setKeywords("Soci AMD")
 ->setCategory("result file");




$objPHPExcel->getActiveSheet()->setTitle('Situazione quote soci');
$sheet = $objPHPExcel->getActiveSheet();



$text_searc=  $_POST['text_searc'];
$regione  = $_POST['regione'];
$alfabeto  = $_POST['alfabeto'];
$morosita_soci=$_POST['morosita_soci'];
$contenitore = $GLOBALS['array_alfabeto'];
$tot = 0;


$funzioni= new K_funzioni();
$trace = new K_trace($prof_trace,"XLS REPORT QUOTE");

$trace->trace(2,"start");
$trace->trace(5,"XLS REPORT QUOTE");
include "../query/q_quote_sel.php";
$anno =(isset($risultato_quota_attuale_sel['anno']))?$risultato_quota_attuale_sel['anno']:"0000";

include "../query/q_report_quote_ric.php";
$numero_risultati=$risultato_report_quote_ric['num_righe'];

$trace->trace(5,"Ho  risultati=".$numero_risultati);
$trace->trace(5,"XLS LISTA REPORT QUOTE::inizia il pdf ");

$titleText= "Situazione dei Soci al :".date("d-m-Y");

$selezione="";
$morosi=0;
$morosita=0;
$piccoli=0;
$saldo_piccoli=0;
$medi=0;
$saldo_medi=0;
$grandi=0;
$saldo_grandi=0;

if ($regione != "- - - Scegli - - -")
	{$titleText.="- Regione: ".$funzioni->deseleziona_regione($regione);

}
else {
	$titleText.=" Regione: Tutte";


}
$sheet->getColumnDimension('A')->setWidth(25);
$sheet->getColumnDimension('B')->setWidth(15);
$sheet->getColumnDimension('C')->setWidth(15);
$sheet->getColumnDimension('D')->setWidth(30);
$sheet->getColumnDimension('E')->setWidth(10);
$sheet->getColumnDimension('F')->setWidth(30);
$sheet->getColumnDimension('G')->setWidth(10);
$sheet->getColumnDimension('H')->setWidth(30);
$sheet->getColumnDimension('I')->setWidth(10);
$sheet->getColumnDimension('j')->setWidth(30);
$sheet->getColumnDimension('k')->setWidth(15);
$sheet->getColumnDimension('L')->setWidth(20);
$sheet->getColumnDimension('M')->setWidth(15);
$sheet->getColumnDimension('N')->setWidth(15);
$sheet->getColumnDimension('O')->setWidth(15);

$sheet->mergeCells('A1:Q1');
$sheet->setCellValue('A1',$titleText);
$sheet->getDefaultRowDimension()->setRowHeight(30);

$style_titolo = array(                  
                'fill' => array(
                'type' => PHPExcel_Style_Fill::FILL_SOLID,      
				'alignment'=>'center'
                ),
                'font' => array(
				'name' =>'Helvetica',
                'bold' => true,
				'size'=>13,
				'color'=>array('rgb'=>'0e1066'),
                )
                );

$sheet->getStyle('A1:D1')->applyFromArray( $style_titolo );

//$titleFormat->setBottom(2);
//$titleFormat->setBottomColor('navy');
//$titleFormat->setAlign('merge');
//riservo le celle successive per il titolo

/*

//setto la larghezza per le prime 4 colonne
$sheet->setColumn(0,2,15);
$sheet->setColumn(3,3,30);
$sheet->setColumn(5,5,15);
$sheet->setColumn(7,9,15);
//intestazione
*/
$style_header = array(                  
                'fill' => array(
                'type' => PHPExcel_Style_Fill::FILL_SOLID,
                'color' => array('rgb'=>'0e1066'),
                ),
                'font' => array(
				'name' =>'Arial',
                'bold' => true,
				'size'=>13,
				'color'=>array('rgb'=>'FFFFFF'),
                )
                );



$sheet->getStyle('A2:Z2')->applyFromArray( $style_header );
$sheet->setCellValue('A2','COGNOME');
$sheet->setCellValue('B2','NOME');
$sheet->setCellValue('C2','SALDO');
$sheet->setCellValue('D2','QUOTE NON EVASE');
$sheet->setCellValue('E2','SESSO');
$sheet->setCellValue('F2','INDIRIZZO');
$sheet->setCellValue('G2','CAP');
$sheet->setCellValue('H2','CITTA');
$sheet->setCellValue('I2','PROVINCIA');
$sheet->setCellValue('J2','EMAIL');
$sheet->setCellValue('K2','CELL');
$sheet->setCellValue('L2','CODICE FISCALE');
$sheet->setCellValue('M2','REGIONE');


$default_border = array( 'style' => PHPExcel_Style_Border::BORDER_THIN, 'color' => array('rgb'=>'0e1066') );

$currentRow=3;	
$style_text = array(                  
                'fill' => array(
                'type' => PHPExcel_Style_Fill::FILL_SOLID,      
				'alignment'=>'left'
                ),
                'font' => array(
					'name' =>'Helvetica',
               	 'bold' => true,
					'size'=>10,
					'color'=>array('rgb'=>'0e1066'),
                ),
				'borders' => array( 'bottom' => $default_border,
				 'left' => $default_border,
				  'top' => $default_border,
				   'right' => $default_border, )


                );



	while ( $row = mysql_fetch_array ($risultato_report_quote_ric['valori'])){
if($row['sesso']==0 )
$sesso='M';
else 
$sesso='F';

	$sheet->getStyle('A'.$currentRow.':M'.$currentRow)->applyFromArray( $style_text );
	$sheet->setCellValue('A'.$currentRow,$row['cognome']);
$sheet->setCellValue('B'.$currentRow,$row['nome']);
$sheet->setCellValue('C'.$currentRow,number_format($row['saldo_conto'],2,",","."));
$sheet->setCellValue('D'.$currentRow,$row['annualita_da_pagare']);
$sheet->setCellValue('E'.$currentRow,$sesso);
$sheet->setCellValue('F'.$currentRow,$row['indirizzo']);
$sheet->setCellValue('G'.$currentRow,$row['cap']);
$sheet->setCellValue('H'.$currentRow,$row['citta']);
$sheet->setCellValue('I'.$currentRow,str_replace("'","\'",$row['provincia']));
$sheet->setCellValue('J'.$currentRow,$row['email']);
$sheet->setCellValue('K'.$currentRow,$row['cellulare']);
$sheet->setCellValue('L'.$currentRow,$row['codice_fiscale']);
$sheet->setCellValue('M'.$currentRow,$row['regione']);
	$currentRow++;
	}





// Redirect output to a client's web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="situazione_soci.xls"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
//$objWriter->save("05featuredemo.xls");

$trace->trace(5,"STAMPA xls quote::Dopo aver scritto ");
$trace=0;
$pdf=0;
$funzioni=0;
?>