<?php
require_once 'Framework/Controleurrequete.php'; // OK
require_once 'Modele/Statistique.php';

class ControleurAjaxstatsmaladiefichetechniquevingtunpdf extends Controleur 
{
    private $detailsp;

    public function __construct() {
		$this->detailsp = new Statistique();
    }
	
    public function index() 
	{
		$codeGcAssureur = $this->requete->getParametreFormulaire("codeGcAssureur");
		$p_typeDate = $this->requete->getParametreFormulaire("typeDate");
		$chargeravantapres = $this->requete->getParametreFormulaire("chargeravantapres");
		$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;
		$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';
	
        $cumulapporteurdetailemissionscompagnies  = $this->detailsp->cumulapporteurdetailemissionscompagnies($p_garant, $p_id_clients, $p_id,$p_debutStat,$p_finStat,$p_code,$p_taux,$p_typeDate  );
		$cumulsouscripteurdetailemissionscompagnies  = $this->detailsp->cumulsouscripteurdetailemissionscompagnies($p_garant, $p_id_clients, $p_id,$p_debutStat,$p_finStat,$p_code,$p_taux,$p_typeDate  );
		//highlight_string("<?php\n\$datas =\n" . var_export($cumulsouscripteurdetailemissionscompagnies, true) . ";\n>");

		//die();
		$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'],10,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(2);
		
		$pdf->SetFont('Arial','B',13);
		
		$pdf->SetFillColor(144, 238, 144); 
		$pdf->Cell(0,8,convertirc(_('PRIMES EMISSIONS PAR COURTIER ET PAR GARANT')),1,0,'C',true);

		//highlight_string("<?php\n\$datas =\n" . var_export($cumulsouscripteurdetailemissionscompagnies, true) . ";\n>");
		//die();		
		
		$pdf->Ln(10);
		$pdf->SetFont('Arial', 'B', 11);
		$pdf->SetTextColor(0);
		$pdf->Ln(8);
		foreach ($cumulsouscripteurdetailemissionscompagnies as $cumulsouscripteurdetailemissionscompagnie ) {
			$pdf->SetFont('Arial', 'BUI', 11);
			$pdf->Cell(35, 8, convertirc(_('COMPAGNIE').': '), 0, 0, 'L', false);
			$pdf->SetFont('Arial', 'BI', 11);
			$pdf->Cell(0, 8, convertirc($cumulsouscripteurdetailemissionscompagnie['Garant']), 0, 1, 'L', false);
		}

		$TOTALPrimeNette=0;
		$TOTALPrimeHt=0;
		$TOTALAccessoireGarant=0;
		$TOTALAccessoireIntermediaire=0;
		$TOTALAccessoireGestion=0;
		$TOTALTaxeErengistrement=0;
		$TOTALPrimeTtc=0;
		$TOTALCommissionIntermediaire=0;
		$TOTALCommissionGestion =0;
		$apporteurold ='';
		
	   	foreach ($cumulsouscripteurdetailemissionscompagnies as $cumulsouscripteurdetailemissionscompagnie ) {
			
			$p_id_clients =$cumulsouscripteurdetailemissionscompagnie['idSouscripteur'];

			$cumulpolicedetailemissionscompagnies  = $this->detailsp->cumulpolicedetailemissionscompagnies($p_id_clients ,$p_debutStat,$p_finStat,$p_code,$p_taux,$p_typeDate );
			
			$apporteurnew=  $cumulsouscripteurdetailemissionscompagnie['Apporteur'];
			
			if($apporteurold!=$apporteurnew){
				//$pdf->Ln(5);
				$pdf->SetTextColor(	0, 0, 0); 
				$pdf->SetFont('Arial', 'BUI', 10);
				$pdf->Cell(35, 8, convertirc(_('COURTIER').': '), 0, 0, 'L', false);
				$pdf->SetFont('Arial', 'BI', 10);
				$pdf->Cell(0, 8, convertirc($cumulsouscripteurdetailemissionscompagnie['Apporteur']), 0, 1, 'L', false);
			}	
			$pdf->SetTextColor(210,105,30); 
			$pdf->SetFont('Arial', 'BUI', 10);
			$pdf->Cell(35, 8, convertirc(_('SOUSCRIPTEUR').': '), 0, 0, 'L', false);
			$pdf->SetFont('Arial', 'BI', 10);
			$pdf->Cell(0, 8, convertirc($cumulsouscripteurdetailemissionscompagnie['Souscripteur']), 0, 1, 'L', false);
			$pdf->SetFont('Arial', 'BUI', 10);
			$text = "";
			$numeropoliceold=0;
			foreach($cumulpolicedetailemissionscompagnies as $cumulpolicedetailemissionscompagnie)
			{
				$text = $cumulpolicedetailemissionscompagnie['motifAvenant'];
				$tcut = explode("-", $text); // on créé un tableau à partir des marqueurs ***
				$part1 = $tcut[0]; // la partie à mettre en exergue
				$part2 = '';
				for($i=1; $i<count($tcut); $i++) {
					$part2 .= $tcut[$i].' ';
				}
				$part2 = trim($part2);
				//if($numeropoliceold!=$cumulpolicedetailemissionscompagnie['numeroPolice']){
				$pdf->SetTextColor(	65, 105, 225); 
				$pdf->Cell(35, 8, convertirc(_('POLICE No').': '), 0, 0, 'L', false);
				$pdf->SetFont('Arial', 'BI', 10);
				$pdf->Cell(0, 8, convertirc($cumulpolicedetailemissionscompagnie['numeroPolice'].' / '.$cumulpolicedetailemissionscompagnie['libellePolice'].' - '.	$part2), 0, 1, 'L', false);
				$pdf->SetTextColor(	0, 0, 0); 
				$pdf->Ln(2);
				$pdf->Cell(0,0,convertirc(''),1,1,'C',false);
			
				$hl=4;
				$pdf->SetFont('Arial','B',7);
				$pdf->SetFillColor(144, 238, 144);
				$pdf->Cell(10,$hl,convertirc(_('Année')),'LTR',0,'C',true);
				$pdf->Cell(8,$hl,convertirc(_('Mois')),'LTR',0,'C',true);
				$pdf->Cell(18,$hl,convertirc(_('Quittance')),'LTR',0,'C',true);
				$pdf->Cell(15,$hl,convertirc(_('Date')),'LTR',0,'C',true);
				$pdf->Cell(32,$hl,convertirc(_('Période')),'LTR',0,'C',true);
				$pdf->Cell(17,$hl,convertirc(_('Honoraire(%)')),'LTR',0,'C',true);
				$pdf->Cell(20,$hl,convertirc(_("Prime")),'TLR',0,'C',true);
				$pdf->Cell(20,$hl,convertirc(_("Total prime")),'TLR',0,'C',true);
				$pdf->Cell(20,$hl,convertirc(''),'TL',0,'C',true);
				$pdf->Cell(20,$hl,convertirc(_("coût d'acte")),'T',0,'C',true);
				$pdf->Cell(20,$hl,convertirc(''),'TR',0,'C',true);
				$pdf->Cell(20,$hl,convertirc(_("Taxe")),'TLR',0,'C',true);
				$pdf->Cell(20,$hl,convertirc(_("Prime")),'TLR',0,'C',true);
				$pdf->Cell(20,$hl,convertirc(_("Commission")),'TLR',0,'C',true);
				$pdf->Cell(20,$hl,convertirc(_("Honoraires")),'TLR',1,'C',true);

		
				$pdf->SetFont('Arial','B',7);
				$pdf->SetFillColor(144, 238, 144);
				$pdf->Cell(10,4,convertirc(''),'BLR ',0,'C',true);
				$pdf->Cell(8,4,convertirc(''),'BLR',0,'C',true);
				$pdf->Cell(18,4,convertirc(''),'BLR',0,'C',true);
				$pdf->Cell(15,4,convertirc(_('Emission')),'BLR',0,'C',true);
				$pdf->Cell(32,4,convertirc(''),'BLR',0,'C',true);
				$pdf->Cell(17,$hl,convertirc(''),'BLR',0,'C',true);
				$pdf->Cell(20,4,convertirc(_("(Nette)")),'BLR',0,'C',true);
				$pdf->Cell(20,4,convertirc(_("Nette Annuelle")),'BLR',0,'C',true);
				$pdf->Cell(20,4,convertirc(_("Compagnie")),'BLTR',0,'C',true);
				$pdf->Cell(20,4,convertirc(_("courtier")),'BLTR',0,'C',true);
				$pdf->Cell(20,4,convertirc(_("Gestionn.")),'BLTR',0,'C',true);
				$pdf->Cell(20,4,convertirc(_("enregistrement")),'BLR',0,'C',true);
				$pdf->Cell(20,4,convertirc(_("totale")),'BLR',0,'C',true);
				$pdf->Cell(20,4,convertirc(_("Apporteur")),'BLR',0,'C',true);
				$pdf->Cell(20,4,convertirc(_("Gestionnaire")),'BLR',1,'C',true);

					//}
				$hl=6;
				
				//highlight_string("<?php\n\$datas =\n" . var_export($cumulpolicedetailemissionscompagnie, true) . ";\n>");

				$pdf->SetFont('Arial','',7);
				$pdf->SetFillColor(144, 238, 144);
				$pdf->Cell(10,$hl,convertirc(_($cumulpolicedetailemissionscompagnie['Annee'])),1,0,'C',false);
				$pdf->Cell(8,$hl,convertirc(_($cumulpolicedetailemissionscompagnie['Mois'])),1,0,'C',false);
				$pdf->Cell(18,$hl,convertirc(_($cumulpolicedetailemissionscompagnie['numeroQuittance'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(_(dateLang($cumulpolicedetailemissionscompagnie['dateEmissionEmission'], $_SESSION['lang']))),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(_(dateLang($cumulpolicedetailemissionscompagnie['dateEmissionQuittance'], $_SESSION['lang']))),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(_(dateLang($cumulpolicedetailemissionscompagnie['dateFin'], $_SESSION['lang']))),1,0,'C',false);
				$pdf->Cell(17,$hl,convertirc(_($cumulpolicedetailemissionscompagnie['tauxHonoraires'])),'1',0,'C',false);
				$pdf->Cell(20,$hl,convertirc(format_N($cumulpolicedetailemissionscompagnie['PrimeNette'])),1,0,'C',false);
				$pdf->Cell(20,$hl,convertirc(format_N($cumulpolicedetailemissionscompagnie['PrimeHt'])),1,0,'C',false);
				$pdf->Cell(20,$hl,convertirc(format_N($cumulpolicedetailemissionscompagnie['AccessoireGarant'])),1,0,'C',false);
				$pdf->Cell(20,$hl,convertirc(format_N($cumulpolicedetailemissionscompagnie['AccessoireIntermediaire'])),1,0,'C',false);
				$pdf->Cell(20,$hl,convertirc(format_N($cumulpolicedetailemissionscompagnie['AccessoireGestion'])),1,0,'C',false);
				$pdf->Cell(20,$hl,convertirc(format_N($cumulpolicedetailemissionscompagnie['TaxeErengistrement'])),1,0,'C',false);
				$pdf->Cell(20,$hl,convertirc(format_N($cumulpolicedetailemissionscompagnie['PrimeTtc'])),1,0,'C',false);
				$pdf->Cell(20,$hl,convertirc(format_N($cumulpolicedetailemissionscompagnie['CommissionIntermediaire'])),1,0,'C',false);
				$pdf->Cell(20,$hl,convertirc(format_N($cumulpolicedetailemissionscompagnie['CommissionGestion'])),1,1,'C',false);

				$numeropoliceold=$cumulpolicedetailemissionscompagnie['numeroPolice'];
			}
		
			$pdf->SetFont('Arial','B',8);
			$pdf->SetTextColor(65, 105, 225);
			$pdf->Cell(100,$hl,convertirc(_('TOTAL POLICE :'.$cumulsouscripteurdetailemissionscompagnie['numeroPolice'])),1,0,'L',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['PrimeNette'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['PrimeHt'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['AccessoireGarant'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['AccessoireIntermediaire'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['AccessoireGestion'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['TaxeErengistrement'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['PrimeTtc'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['CommissionIntermediaire'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['CommissionGestion'])),1,1,'C',false);
			
			$pdf->SetFont('Arial','B',8);
			$pdf->SetTextColor(210,105,30); 
			$pdf->Cell(100,$hl,convertirc(_('TOTAL SOUSCRIPTEUR')),1,0,'L',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['PrimeNette'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['PrimeHt'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['AccessoireGarant'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['AccessoireIntermediaire'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['AccessoireGestion'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['TaxeErengistrement'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['PrimeTtc'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['CommissionIntermediaire'])),1,0,'C',false);
			$pdf->Cell(20,$hl,convertirc(format_N($cumulsouscripteurdetailemissionscompagnie['CommissionGestion'])),1,1,'C',false);
			
			$pdf->Ln(5);
			$pdf->Cell(0,0,convertirc(_()),1,1,'C',false);

		
			$apporteurold = $cumulsouscripteurdetailemissionscompagnie['Apporteur'];

			$TOTALPrimeNette =  $TOTALPrimeNette + $cumulsouscripteurdetailemissionscompagnie['PrimeNette'];
			$TOTALPrimeHt = $TOTALPrimeHt + $cumulsouscripteurdetailemissionscompagnie['PrimeHt'];
			$TOTALAccessoireGarant = $TOTALAccessoireGarant + $cumulsouscripteurdetailemissionscompagnie['AccessoireGarant'];
			$TOTALAccessoireIntermediaire = $TOTALAccessoireIntermediaire + $cumulsouscripteurdetailemissionscompagnie['AccessoireIntermediaire'];
			$TOTALAccessoireGestion = $TOTALAccessoireGestion  + $cumulsouscripteurdetailemissionscompagnie['AccessoireGestion'];
			$TOTALTaxeErengistrement = $TOTALTaxeErengistrement + $cumulsouscripteurdetailemissionscompagnie['TaxeErengistrement'];
			$TOTALPrimeTtc = $TOTALPrimeTtc + $cumulsouscripteurdetailemissionscompagnie['PrimeTtc'];
			$TOTALCommissionIntermediaire = $TOTALCommissionIntermediaire + $cumulsouscripteurdetailemissionscompagnie['CommissionIntermediaire'];
			$TOTALCommissionGestion = $TOTALCommissionGestion + $cumulsouscripteurdetailemissionscompagnie['CommissionGestion'];

		}
	   	
	   $hl=4;
	   $pdf->Ln(5);
	   $pdf->SetFont('Arial','B',8);
	   $pdf->SetTextColor(250, 0, 0);
	   $pdf->Cell(92,$hl,convertirc(_('TOTAL GENERALE')),1,0,'L',false);
       $pdf->Cell(20,$hl,convertirc(format_N($TOTALPrimeNette)),1,0,'C',false);
       $pdf->Cell(20,$hl,convertirc(format_N($TOTALPrimeHt)),1,0,'C',false);
       $pdf->Cell(20,$hl,convertirc(format_N($TOTALAccessoireGarant)),1,0,'C',false);
       $pdf->Cell(20,$hl,convertirc(format_N($TOTALAccessoireIntermediaire)),1,0,'C',false);
       $pdf->Cell(20,$hl,convertirc(format_N($TOTALAccessoireGestion)),1,0,'C',false);
	   $pdf->Cell(20,$hl,convertirc(format_N($TOTALTaxeErengistrement)),1,0,'C',false);
	   $pdf->Cell(20,$hl,convertirc(format_N($TOTALPrimeTtc)),1,0,'C',false);
	   $pdf->Cell(20,$hl,convertirc(format_N($TOTALCommissionIntermediaire)),1,0,'C',false);
       $pdf->Cell(20,$hl,convertirc(format_N($TOTALCommissionGestion)),1,1,'C',false);
	

	   $fichier="Temp/TMP_CUMUL_FT21_RECAP_DES_EMISSIONS_PAR_COURTIER"."_".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 FT21_RECAP_DES_EMISSIONS_PAR_COURTIER").' </a> ';
	   $t_html .=' </div ';
	   echo $t_html;
   }
}