<?php
require_once 'Framework/Controleurrequete.php'; // OK
require_once 'Modele/Statistique.php';

class ControleurAjaxstatsmaladiefichetechniquevingtpdf extends Controleur 
{
    private $detailsp;

    public function __construct() {
		$this->detailsp = new Statistique();
    }
	
    public function index() 
	{
		$codeGcAssureur = $this->requete->getParametreFormulaire("codeGcAssureur");
		$idPolice = $this->requete->getParametreFormulaire("idPolice");
		$debutStat = $this->requete->getParametreDate("debutStat");		
		$finStat = $this->requete->getParametreDate("finStat");		
	
		$_SESSION['debutStat'] = $debutStat;
		$_SESSION['finStat'] = $finStat;
        
		
		$p_datedebut="";
		$p_datefin="";
		$p_debutStat = $_SESSION['debutStat'];
		$p_finStat =$_SESSION['finStat'];
		
	
		$p_garant = $codeGcAssureur;
		if ($p_garant=="AUC"){
			$p_garant = null;	
		}
		//highlight_string("<?php\n\$datas =\n" . var_export($p_garant, true) . ";\n>");
		//die();
		$p_id = $idPolice;
		if ($p_id==""){
			$p_id = null;	
		}
		$idCollege= "";
		$p_id_clients="";
		$p_id_clients=null;
		$p_id_college=null;
        $p_code="";
        $p_code='QTM';
		$p_taux = "";
		$p_taux = '18';
		
     	$recapemissionscompagniesgarants  = $this->detailsp->getrecapemissionscompagniegarant($p_garant, $p_id_clients, $p_id,$p_debutStat,$p_finStat,$p_code,$p_taux );
	   
		$pdf = new FPDF_Protection();
		$pdf->SetAuthor('EBENE SOLUTIONS INFORMATIQUES');
		$userPassword  = '';
		$ownerPassword = null;
		$pdf->SetProtection(['print'], $userPassword, $ownerPassword);

	   $pdf->AliasNbPages();
	   $pdf->AddPage('L');

	   $pdf->SetMargins(10, 10, 10) ;
	   $pdf->Image($_SESSION['lienLogo'],140,3,15);
	   $pdf->SetFont('Arial','B',7);
	   
	   $pdf->Cell(0,5,'',0,1,'L',false);
	   $pdf->SetY(10);
	   $pdf->SetFont('Arial','',7);
	   $pdf->Cell(0,5,convertirc(_('Edition du').': '.heureCouranteLang($_SESSION['lang'])),0,1,'R',false);
	   
	   $pdf->Ln(8);
	   
	   $pdf->SetFont('Arial','B',13);
	
	   $pdf->SetFillColor(182,216,242); 
	   $pdf->Cell(0,10,convertirc(_('RECAPITULATIF DES EMISSIONS COMPAGNIES DE L\'ANNEE').' '.date("Y", strtotime($p_debutStat))),1,0,'C',true);
	   $pdf->Ln(15);
	   $p_garant = 0;
	   $garantold = 0;

	   $TOTALPrimeNetteg=
	   $TOTALPrimeTtcg=
	   $TOTALAccessoireGarantg=
	   $TOTALAccessoireIntermediaireg=
	   $TOTALAccessoireGestiong=
	   $TOTALTaxeErengistrementg=
	   $TOTALPrimeTtcg=
	   $TOTALCommissionGestiong=
	   $TOTALFraisCarteg=
	   $Accessoirge=
	   $TOTALAccessoireg=  0;
	   foreach($recapemissionscompagniesgarants as $recapemissionscompagniesgarant){
	  
	   $p_garant =$recapemissionscompagniesgarant['codeG'];
	     
	   $recapemissionscompagnies  = $this->detailsp->getrecapemissionscompagnie($p_garant, $p_id_clients, $p_id,$p_debutStat,$p_finStat,$p_code,$p_taux);
	
		
		
	   $pdf->Ln(5);
	   $pdf->SetFont('Arial', 'BUI', 11);
	   $pdf->Cell(35, 8, convertirc(_('COMPAGNIE').': '), 0, 0, 'L', false);
	   $pdf->SetFont('Arial', 'BU', 11);
	   $pdf->Cell(15, 8, convertirc(_($recapemissionscompagniesgarant['codeG'])), 0, 0, 'R', false);
	   $pdf->Cell(0, 8, convertirc(' '.$recapemissionscompagniesgarant['Garant']), 0, 1, 'L', false);
	
	   $pdf->Ln(5);
	   
	   $hl=4;
	   $pdf->SetFont('Arial','B',8);
	   $pdf->Cell(30,$hl,convertirc(_('Période')),'LTR',0,'C',true);
	   $pdf->Cell(25,$hl,convertirc(_("Prime Nette(HT)")),'TLR',0,'C',true);
	   $pdf->Cell(25,$hl,convertirc(_("Accessoires")),'TLR',0,'C',true);
	   $pdf->Cell(25,$hl,convertirc(_("Accessoires")),'TLR',0,'C',true);
       $pdf->Cell(25,$hl,convertirc(_("Accessoires")),'TLR',0,'C',true);
       $pdf->Cell(25,$hl,convertirc(_("Total")),'TLR',0,'C',true);
       $pdf->Cell(30,$hl,convertirc(_("Taxe")),'TLR',0,'C',true);
       $pdf->Cell(30,$hl,convertirc(_("Prime")),'TLR',0,'C',true);
       $pdf->Cell(30,$hl,convertirc(_("Montant")),'TLR',0,'C',true);
       $pdf->Cell(30,$hl,convertirc(_("TVA sur honoraires")),'TLR',1,'C',true);

       
	   $pdf->SetFont('Arial','B',8);
	   $pdf->Cell(30,4,convertirc(_('')),'LBR',0,'C',true);
	   $pdf->Cell(25,4,convertirc(_("")),'BLR',0,'C',true);
	   $pdf->Cell(25,4,convertirc(_("Compagnie")),'BLR',0,'C',true);
	   $pdf->Cell(25,4,convertirc(_("courtier")),'BLR',0,'C',true);
       $pdf->Cell(25,4,convertirc(_("Gestionn.")),'BLR',0,'C',true);
       $pdf->Cell(25,4,convertirc(_("accessoires")),'BLR',0,'C',true);
       $pdf->Cell(30,4,convertirc(_("enregistrement")),'BLR',0,'C',true);
       $pdf->Cell(30,4,convertirc(_("totale(TTC)")),'BLR',0,'C',true);
       $pdf->Cell(30,4,convertirc(_("honoraires")),'BLR',0,'C',true);
       $pdf->Cell(30,4,convertirc(_("+ Acc Gestionnaire")),'BLR',1,'C',true);
		$TOTALPrimeNette=
		$TOTALPrimeTtc=
		$TOTALAccessoireGarant=
		$TOTALAccessoireIntermediaire=
		$TOTALAccessoireGestion=
		$TOTALTaxeErengistrement=
		$TOTALPrimeTtc=
		$TOTALCommissionGestion=
		$TOTALFraisCarte =
		$Accessoire=
		$TOTALAccessoire =  0;
		
		foreach($recapemissionscompagnies as $recapemissionscompagnie){
		
	   $hl=6;
	   $Accessoire = $recapemissionscompagnie['AccessoireGarant'] + $recapemissionscompagnie['AccessoireIntermediaire'] +$recapemissionscompagnie['AccessoireGestion'];
       $pdf->SetFont('Arial','',8);
	   $pdf->SetFillColor(182,216,242);
	   $pdf->Cell(30,$hl,convertirc(_($recapemissionscompagnie['Periode'])),1,0,'L',false);
	   $pdf->Cell(25,$hl,convertirc(format_N($recapemissionscompagnie['PrimeNette'])),1,0,'R',false);
	   $pdf->Cell(25,$hl,convertirc(format_N($recapemissionscompagnie['AccessoireGarant'])),1,0,'R',false);
	   $pdf->Cell(25,$hl,convertirc(format_N($recapemissionscompagnie['AccessoireIntermediaire'])),1,0,'R',false);
       $pdf->Cell(25,$hl,convertirc(format_N($recapemissionscompagnie['AccessoireGestion'])),1,0,'R',false);
       $pdf->Cell(25,$hl,convertirc(format_N( $Accessoire)),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($recapemissionscompagnie['TaxeErengistrement'])),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($recapemissionscompagnie['PrimeTtc'])),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($recapemissionscompagnie['CommissionGestion'])),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($recapemissionscompagnie['FraisCarte'])),1,1,'R',false);

	   $TOTALPrimeNette= $TOTALPrimeNette +$recapemissionscompagnie['PrimeNette'];
		$TOTALAccessoireGarant =$TOTALAccessoireGarant + $recapemissionscompagnie['AccessoireGarant'];
		$TOTALAccessoireIntermediaire =$TOTALAccessoireIntermediaire + $recapemissionscompagnie['AccessoireIntermediaire'];
		$TOTALAccessoireGestion=$TOTALAccessoireGestion + $recapemissionscompagnie['AccessoireGestion'];
		$TOTALAccessoire = $TOTALAccessoire +  $Accessoire;
		$TOTALTaxeErengistrement =$TOTALTaxeErengistrement + $recapemissionscompagnie['TaxeErengistrement'];
		$TOTALPrimeTtc = $TOTALPrimeTtc + $recapemissionscompagnie['PrimeTtc'];
		$TOTALCommissionGestion =$TOTALCommissionGestion + $recapemissionscompagnie['CommissionGestion'];
		$TOTALFraisCarte = $TOTALFraisCarte + $recapemissionscompagnie['FraisCarte'];
		
		$garantold = $recapemissionscompagnie['Garant'];
	
		}
		
	   $pdf->SetFont('Arial','B',8);
	   $pdf->SetFillColor(182,216,242);
	   $pdf->SetTextColor(75,0,130); 
	   $pdf->Cell(30,$hl,convertirc(_('TOTAL GARANT')),1,0,'L',false);
	   $pdf->SetFillColor(182,216,242);
	   $pdf->Cell(25,$hl,convertirc(format_N($TOTALPrimeNette)),1,0,'R',false);
	   $pdf->Cell(25,$hl,convertirc(format_N($TOTALAccessoireGarant)),1,0,'R',false);
	   $pdf->Cell(25,$hl,convertirc(format_N($TOTALAccessoireIntermediaire)),1,0,'R',false);
       $pdf->Cell(25,$hl,convertirc(format_N($TOTALAccessoireGestion)),1,0,'R',false);
       $pdf->Cell(25,$hl,convertirc(format_N($TOTALAccessoire)),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($TOTALTaxeErengistrement)),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($TOTALPrimeTtc)),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($TOTALCommissionGestion)),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($TOTALFraisCarte)),1,1,'R',false);
	   $pdf->SetTextColor(0,0,0); 
	   
	   $TOTALPrimeNetteg= $TOTALPrimeNetteg +$TOTALPrimeNette;
	   $TOTALAccessoireGarantg =$TOTALAccessoireGarantg + $TOTALAccessoireGarant;
	   $TOTALAccessoireIntermediaireg =$TOTALAccessoireIntermediaireg + $TOTALAccessoireIntermediaire;
	   $TOTALAccessoireGestiong=$TOTALAccessoireGestiong + $TOTALAccessoireGestion;
	   $TOTALAccessoireg = $TOTALAccessoireg +  $TOTALAccessoire;
	   $TOTALTaxeErengistrementg =$TOTALTaxeErengistrementg + $TOTALTaxeErengistrement;
	   $TOTALPrimeTtcg = $TOTALPrimeTtcg + $TOTALPrimeTtc;
	   $TOTALCommissionGestiong =$TOTALCommissionGestiong + $TOTALCommissionGestion;
	   $TOTALFraisCarteg = $TOTALFraisCarteg + $TOTALFraisCarte;
	   
	}
	
	   $hl=4;
	   $pdf->Ln(5);
	   $pdf->SetFont('Arial','B',8);
	   $pdf->SetTextColor(220,20,60); 
	   $pdf->SetFillColor(182,216,242);
	   $pdf->Cell(30,$hl,convertirc(_('TOTAL GENERAL')),1,0,'C',false);
	   $pdf->SetFillColor(182,216,242);
	   $pdf->Cell(25,$hl,convertirc(format_N($TOTALPrimeNetteg)),1,0,'R',false);
	   $pdf->Cell(25,$hl,convertirc(format_N($TOTALAccessoireGarantg)),1,0,'R',false);
	   $pdf->Cell(25,$hl,convertirc(format_N($TOTALAccessoireIntermediaireg)),1,0,'R',false);
       $pdf->Cell(25,$hl,convertirc(format_N($TOTALAccessoireGestiong)),1,0,'R',false);
       $pdf->Cell(25,$hl,convertirc(format_N($TOTALAccessoireg)),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($TOTALTaxeErengistrementg)),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($TOTALPrimeTtcg)),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($TOTALCommissionGestiong)),1,0,'R',false);
       $pdf->Cell(30,$hl,convertirc(format_N($TOTALFraisCarteg)),1,1,'R',false);
	  
	   $fichier="Temp/TMP_CUMUL_FT20_RECAP_DES_EMISSIONS"."_".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 FT20_RECAP_DES_EMISSIONS").' </a> ';
	   $t_html .=' </div ';
	   echo $t_html;
   }
}