<?php
require_once 'Framework/Controleurrequete.php'; // OK
require_once 'Modele/Statistique.php';

class ControleurAjaxdetailrapportspfactureadhperiodepdf extends Controleur 
{
    private $detailsp;

    public function __construct() {
		$this->detailsp = new Statistique();
    }
	
    public function index() 
	{
		$sDateDebut = date("Y-m-d", mktime(0,0,0,date("m")-1,1,date("Y")));
		$sDateFin     = date("Y-m-d", mktime(0,0,0,date("m"),0,date("Y")));
		
		//var_dump($sDateFin);
		//die();
		
		$idAdherent = $this->requete->getParametreFormulaire("idAdherent");		
		
		$entete = $this->detailsp->detailrapportspadhperiodepdfentete($idAdherent);
		
		$detailsps = $this->detailsp->detailrapportspadhperiodefacturepdf($idAdherent);
		
		$pdf = new FPDF_Protection();
		$pdf->SetAuthor('EBENE SOLUTIONS INFORMATIQUES');
		$userPassword  = '';
		$ownerPassword = null;
		$pdf->SetProtection(['print'], $userPassword, $ownerPassword);

		$pdf->AliasNbPages();
		$pdf->AddPage();

		$pdf->SetMargins(15, 15, 15);
		
		$pdf->Image($_SESSION['lienLogo'],94,3,18);
		
		$pdf->Ln(10);
		
		$pdf->SetFont('Arial','BU',10);
		
		// $pdf->AliasNbPages();
		
		$pdf->Cell(0,6,convertirc(_('DETAIL DES FACTURES FAMILLE')),0,1,'C',false);		

		$pdf->Ln(2);

		$pdf->SetFont('Arial','B',7);
		
		$pdf->Cell(0,5,convertirc(_('Garant').' : '.$entete['garant']),0,1,'L',false);
		$pdf->Cell(0,5,convertirc(_('Souscripteur').' : '.$entete['souscripteur']),0,1,'L',false);
		$pdf->Cell(0,5,convertirc(_('Police').' No : '.$entete['numeroPolice'].' / '.$entete['libellePolice']),0,1,'L',false);
		$pdf->Cell(0,5,convertirc(_('Adhérent').' Mle : '.$entete['numeroAdherent'].' / '.$entete['adherent']),0,1,'L',false);
		$pdf->Cell(0,5,convertirc(_('Période couverte').' : '.dateLang($entete['dateEffetAdherent'], $_SESSION['lang']).' '._('au').' '.dateLang($entete['dateFinAdherent'], $_SESSION['lang'])),0,1,'L',false);
		$pdf->Cell(0,5,convertirc(_('Période Analyse').' : '.dateLang($_SESSION['debutStat'], $_SESSION['lang']).' '._('au').' '.dateLang($_SESSION['finStat'], $_SESSION['lang'])),0,1,'L',false);
		$pdf->Cell(0,5,'Edition : '.heureCouranteLang($_SESSION['lang']),0,1,'R',false);

		$pdf->Ln(2);

		$hl=5;
		
		$pdf->Cell(15,$hl,convertirc(_('Matricule')),"1",0,'C');
		$pdf->Cell(65,$hl,convertirc(_('Bénéficiaire')),"1",0,'C');
		$pdf->Cell(15,$hl,convertirc("Date"),"1",0,'C');
		$pdf->Cell(55,$hl,convertirc(_('Prestataire')),"1",0,'C');
		$pdf->Cell(15,$hl,convertirc(_('Montant')),"1",0,'C');
		$pdf->Cell(15,$hl,convertirc(_('No Fact')),"1",1,'C');
		
		$pdf->SetFont('Arial','I',6);
		foreach ($detailsps as $detailsp)
		{
			$pdf->Cell(15,$hl,convertirc($detailsp['numeroBeneficiaire']),"1",0,'L');
			$pdf->Cell(65,$hl,convertirc($detailsp['beneficiaire']),"1",0,'L');
			$pdf->Cell(15,$hl,convertirc(dateLang($detailsp['dateFacture'], $_SESSION['lang'])),"1",0,'C');
			$pdf->Cell(55,$hl,convertirc($detailsp['prestataire']),"1",0,'L');
			$pdf->Cell(15,$hl,format_N($detailsp['montant']),"1",0,'C');
			$pdf->Cell(15,$hl,convertirc($detailsp['facture']),"1",1,'C');
		}
		$pdf->SetFont('Arial','BI',6);

		$pdf->Cell(150,$hl,convertirc("TOTAL"),"1",0,'C');
		$pdf->Cell(15,$hl,format_N($detailsp['montantTotal']),"1",0,'C');
		$pdf->Cell(15,$hl,"","1",1,'C');
		
		$pdf->Ln(5);

		$pdf->SetFont('Arial','BI', $tp);

		if (est_anglophone())
		{
			$pdf->Cell(0,$ht,convertirc("Done at " . $_SESSION['villeSociete'].", on ".dateCouranteLang($_SESSION['lang'])),0,1,'C',false);
		}
		else
		{
			$pdf->Cell(0,$ht,convertirc("Fait à " . $_SESSION['villeSociete'].", le ".dateCouranteLang($_SESSION['lang'])),0,1,'C',false);
		}

		$pdf->Ln(10);
		
		$pdf->SetFont('Arial','BU', $tp);
		
		$pdf->Cell(0,$ht,convertirc(_("L'Assuré")),0,1,'C',false);

		$pdf->Cell(0,$ht,convertirc(_("Le Souscripteur")),0,0,'L',false);
		
		
		

		$pdf->Cell(0,$ht,convertirc(_("Le Gestionnaire")),0,0,'R',false);
		
		$fichier="Temp/TMP_DETAIL_FACTURES_FAM"."_".uniqid().".pdf";
		$pdf->Output($fichier,"F");	

		$t_html =' <div id ="div_export_b" class="alert alert-info"> ';
		$t_html .=' <a style="font-size:15pt;"	href="'.$fichier.'" target="_blank" > '._("TELECHARGER").' </a> ';
		$t_html .=' </div ';
		echo $t_html;
    }
}