<?php
require_once 'Framework/Controleurrequete.php'; // OK
require_once 'Modele/Statistique.php';
require_once 'Modele/Police.php';
require_once 'Modele/Collegepolice.php';
require_once $_SESSION['dossierSociete'].'/Tarifs/Modele/Police_sodciete.php';


class ControleurAjaxstatsmaladiefichetechniqueadherentpdf extends Controleur 
{
    private $detailsp;
	private $college;
	private $police;
	private $police_societe;

    public function __construct() {
		$this->detailsp = new Statistique();
		$this->college = new Collegepolice();
		$this->police = new Police();
		$this->police_societe = new Police_sodciete();

    }
	
    public function index() 
	{
    }

	function statsadherent($idPolice,$idCollege,$codeGcAssureur,$Chargement,$p_datedebut,$p_datefin,$depenses,$chargeravantapres,$famille,$numeroAdherent ){
	
		$p_datedebut = $p_datedebut;
		$p_datefin =$_SESSION['p_datefin'];
		$p_garant = $codeGcAssureur;
		$p_id = $entete['idPolice'] ;
		$p_limite = $_SESSION['depenses'];
		$p_id_college = $idCollege;
		$p_id_clients = null;
		$p_apporteur = null;
		$infocollege = $this->college->getCollegepoliceId($idCollege);

		$tableaudajustements = $this->detailsp->gettableauAjustementGarant($codeGcAssureur);


		$infosDuGarant     = $this->police_societe->getInfosGarant($codeGcAssureur);
		
		$pdf = new FPDF_Protection();
		$pdf->SetAuthor('EBENE SOLUTIONS INFORMATIQUES');
		$userPassword  = '';
		$ownerPassword = null;
		$pdf->SetProtection(['print'], $userPassword, $ownerPassword);

		$pdf->AliasNbPages();
		
		$pdf->AddPage(); // debut page de garde

		$pdf->SetMargins(10, 10, 10) ;
		$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit1.jpg', 0, 0, 210);


		$pdf->SetY(75);

		$pdf->SetFont('Helvetica', 'B', 36);
		$pdf->SetTextColor( 37, 36, 97 );
		$pdf->Cell(0, 6, convertirc(_('STATISTIQUES MALADIE')), 0, 1, 'C', false);


		$pdf->SetY(240);

		$pdf->SetFont('Times', 'BI', 13);
		$pdf->SetTextColor( 0, 0, 0 );
		$pdf->Cell(0, 6, convertirc(_('PÉRIODE CONSIDÉRÉE').': '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'C', false);
		$pdf->Ln(10);	 
		$pdf->SetTextColor( 37, 36, 97 );

		if ($p_id!=null){

			$pdf->SetFont('Helvetica', 'BI', 12);
			$pdf->Cell(75, 5, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(22, 5, convertirc(_('GARANT').':')), 0, 0, 'L', false);
			$pdf->MultiCell(115, 5, convertirc(_($entete['garant'])), 0, 'L');
			$pdf->Ln(2);	 
			$pdf->Cell(75, 5, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(38, 5, convertirc(_('SOUSCRIPTEUR').':'), 0, 0, 'L', false);
			$pdf->MultiCell(115, 5, convertirc(_($entete['souscripteur'])), 0, 'L');
			$pdf->Ln(2);
			$pdf->Cell(75, 5, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(21, 5, convertirc(_('POLICE').':'), 0, 0, 'L', false);
			$pdf->MultiCell(115, 5, convertirc(_($entete['libellePolice'])), 0, 'L');
		}else{
			$pdf->SetFont('Times', 'BI', 16);
			$pdf->Cell(100, 5, convertirc(_('GARANT').':'), 0, 0, 'L', false);
			$pdf->SetFont('Times', 'BI', 14);

			$pdf->MultiCell(115, 5, convertirc(_($infosDuGarant['libelle'])), 0, 'L' );
			$pdf->Ln(40);
		}
		
		$pdf->AddPage(); // SOMMAIRE

		$pdf->SetMargins(10, 10, 10) ;
		$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit2.jpg', 0, 0, 210); 

				
		$pdf->Ln(10);

		$pdf->SetTextColor(255, 255, 255); 
		$pdf->SetFont('Arial', 'B', 24);
		$pdf->Cell(34,12,convertirc(''),0,0,'C',false);		
		$pdf->Cell(100,12,convertirc(_("SOMMAIRE")),0,0,'C',false);		

		$pdf->Ln(20);
		$pdf->SetFont('Helvetica', 'B', 9);
		$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
		$pdf->Cell(34,0,convertirc(_("DONNÉES ÉLEMENTAIRES")),0,0,'L',false);	
		$pdf->Cell(140,0,convertirc(''),0,0,'L',false);		
		
		$pdf->Ln(8);
		$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
		$pdf->Cell(34,0,convertirc(_("MOUVEMENTS D'EFFECTIFS PAR COLLEGE")),0,0,'L',false);	
		$pdf->Cell(140,0,convertirc(''),0,0,'L',false);	
				
		$pdf->Ln(8);
		$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
		$pdf->Cell(34,0,convertirc(_("DÉPENSES PAR FAMILLES ET PAR COLLEGE")),0,0,'L',false);	
		$pdf->Cell(140,0,convertirc(''),0,0,'L',false);	
		
		$pdf->Ln(8);
		$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
		$pdf->Cell(34,0,convertirc(_("RÉCAPITULATIF DES DÉPENSES PAR STATUT DE BÉNÉFICIAIRES")),0,0,'L',false);	
		$pdf->Cell(140,0,convertirc(''),0,0,'L',false);	
		
		$pdf->Ln(8);
		$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
		$pdf->Cell(34,0,convertirc(_("ÉVOLUTION MENSUELLE DES DÉPENSES")),0,0,'L',false);	
		$pdf->Cell(140,0,convertirc(''),0,0,'L',false);	
		
		$pdf->Ln(8);
		$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
		$pdf->Cell(34,0,convertirc(_("RÉCAPITULATIF DES DÉPENSES PAR FAMILLE D’ACTES MÉDICAUX")),0,0,'L',false);	
		$pdf->Cell(140,0,convertirc(''),0,1,'L',false);	

		$pdf->Ln(8);
		$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
		$pdf->Cell(36,0,convertirc(_("COMPARATIF DES DÉPENSES DES ANNÉES N-1 ET N")),0,0,'L',false);	
		$pdf->Cell(140,0,convertirc(''),0,1,'L',false);	

		$pdf->Ln(8);
		$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
		$pdf->Cell(36,0,convertirc(_("DÉPENSES PAR FAMILLE D’ACTES ET PAR PRESTATAIRES")),0,0,'L',false);	
		$pdf->Cell(140,0,convertirc(''),0,0,'L',false);	
			
		$pdf->AddPage(); // 

		$pdf->Cell(0,8,convertirc(_("FICHE DE SUIVI")),0,1,'C',TRUE);	
		
		$pdf->Ln(8);
		$h=5;
		$pdf->SetTextColor(0, 0, 0); 
		$pdf->SetFont('Times', 'BI', 9);
		$pdf->Cell(75,$h,convertirc(_("PERIODE")),1,0,'L',false);
		$pdf->Cell(115,$h,convertirc(dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])),1,1,'L',false);

		$beneficiaires = $this->detailsp->getficheSuivie1($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$agemoyens = $this->detailsp->getficheSuivie2($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$tranchesages = $this->detailsp->getficheSuivie3($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$topactes = $this->detailsp->getficheSuivie4($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$topprestataires = $this->detailsp->getficheSuivie5($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$topaffections = $this->detailsp->getficheSuivie6($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$sinistrialites = $this->detailsp->getficheSuivie7($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin,$Chargement,$chargeravantapres);

		$nombreBeneficiaire = 0;
		
		foreach($beneficiaires  as $key=>$beneficiaire){
			if($key == 0){
				$nombreTraiteA= $beneficiaire['Nombretraite'];
				$DepensesA= $beneficiaire['Depenses'];
				$taux_DepenseA= $beneficiaire['Taux_Depense'];
				$coutMoyenA= $beneficiaire['CoutMoyen'];
			}elseif($key == 1){
				$nombreTraiteC= $beneficiaire['Nombretraite'];
				$DepensesC= $beneficiaire['Depenses'];
				$taux_DepenseC= $beneficiaire['Taux_Depense'];
				$coutMoyenC=30;
				//$beneficiaire['CoutMoyen'];
			}
			elseif($key == 2){
				$nombreTraiteE= $beneficiaire['Nombretraite'];
				$DepensesE= $beneficiaire['Depenses'];
				$taux_DepenseE= $beneficiaire['Taux_Depense'];
				$coutMoyenE= $beneficiaire['CoutMoyen'];
			}
			

			$nombreBeneficiaire = $nombreBeneficiaire+ $beneficiaire['Nombre'];
		}
		
		$coutMoyens = max(array($coutMoyenA,$coutMoyenC,$coutMoyenE));
		
		if( $coutMoyens=$coutMoyenA){
			$libelle = _("Adhérent(e)s");
		}elseif( $coutMoyens== $coutMoyenC){
			$libelle = _("Conjoint(e)s");
		}
		elseif( $coutMoyens == $coutMoyenE){
			$libelle = _("Enfants");
		}

		foreach($agemoyens  as $key=>$agemoyen){
			if($key == 0){
				$Age_MoyenA= $agemoyen['Age_Moyen'];
			}elseif($key == 1){
				$Age_MoyenC= $agemoyen['Age_Moyen'];
			}
			elseif($key == 2){
				$Age_MoyenE= $agemoyen['Age_Moyen'];
			}
		}
		
		foreach($tranchesages  as $key=>$tranchesage){
			if($key == 0){
				$Depenses1= $tranchesage['Depense_Tranche'];
				$taux_Depense1= $tranchesage['Taux_Depense'];
				$coutMoyen1= $beneficiaire['CoutMoyen'];

			}elseif($key == 1){
				$Depenses2= $tranchesage['Depense_Tranche'];
				$taux_Depense2= $tranchesage['Taux_Depense'];
				$coutMoyen2= $beneficiaire['CoutMoyen'];			
			}
			elseif($key == 2){
				$Depenses3= $tranchesage['Depense_Tranche'];
				$taux_Depense3= $tranchesage['Taux_Depense'];
				$coutMoyen3= $beneficiaire['CoutMoyen'];
			}
			elseif($key == 3){
				$Depenses4= $tranchesage['Depense_Tranche'];
				$taux_Depense4= $tranchesage['Taux_Depense'];
				$coutMoyen4= $beneficiaire['CoutMoyen'];
			}
			elseif($key == 4){
				$Depenses4= $tranchesage['Depense_Tranche'];
				$taux_Depense4= $tranchesage['Taux_Depense'];
				$coutMoyen4= $beneficiaire['CoutMoyen'];
			}
		}
				
		$pdf->Cell(75,$h,convertirc(_("BENEFICIAIRES")),1,0,'L',false);
		$pdf->Cell(115,$h,convertirc(format_N($nombreBeneficiaire)),1,1,'L',false);

		$pdf->Cell(75,$h,convertirc(''),"LTR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Adhérent(e)s")." : ".format_N($nombreTraiteA)),"LTR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(_("BENEFICIAIRES TRAITES")),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Conjoint(e)s")." : ".format_N($nombreTraiteC)),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LBR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Enfants")." : ".format_N($nombreTraiteE)),"LBR",1,'L',false);

		$pdf->Cell(75,$h,convertirc(''),"LTR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Adhérent(e)s")." : ".format_N($Age_MoyenA)." "._("ans")),"LTR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(_("AGE MOYEN DE LA POPULATION")),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Conjoint(e)s")." : ".format_N($Age_MoyenC)." "._("ans")),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LBR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Enfants")." : ".format_N($Age_MoyenE)." "._("ans")),"LBR",1,'L',false);

		$pdf->Cell(75,$h,convertirc(''),"LTR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Adhérent(e)s")." : ".format_N($DepensesA)." ".$_SESSION['devise_C']." "._("soit")." ".$taux_DepenseA." %")),"LTR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(_("SINISTRIALITE PAR STATUT DE BENEFICIAIRE")),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Conjoint(e)s")." : ".format_N($DepensesC)." ".$_SESSION['devise_C']." "._("soit")." ".$taux_DepenseC." %")),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Enfants")." : ".format_N($DepensesE)." ".$_SESSION['devise_C']." "._("soit")." ".$taux_DepenseE." %")),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("On observe un coût moyen plus élevé chez les")." ".$libelle." ".format_N($coutMoyens)." ".$_SESSION['devise_C'])),"LR",1,'L',false);
		
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(''),"LR",1,'L',false);
			
				
		$key=0;
		foreach($topactes  as $key=>$topacte){
			if($key == 0){
				$pdf->Cell(75,$h,convertirc(_("TOP DES ACTES")),"LTR",0,'L',false);
				$pdf->Cell(115,$h,convertirc($topacte['libelle']." : "." ".format_N($topacte['MontantRembourse'])." ".$_SESSION['devise_C']." "._("soit")." ".$topacte['Taux']." %"),"LTR",1,'L',false);
			}else{
				$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
				$pdf->Cell(115,$h,convertirc($topacte['libelle']." : "." ".format_N($topacte['MontantRembourse'])." ".$_SESSION['devise_C']." "._("soit")." ".$topacte['Taux']." %"),"LR",1,'L',false);
			}

		}
				
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(''),"LR",1,'L',false);
		
		foreach($topprestataires  as $key=>$topprestataire){
			if($key == 0){
				$pdf->Cell(75,$h,convertirc(_("TOP DES PRESTATAIRES")),"LTR",0,'L',false);
			$pdf->Cell(115,$h,convertirc($topprestataire['Prestataire']." :"." ".format_N($topprestataire['montantApayer'])." ".$_SESSION['devise_C']),"LTR",1,'L',false);
			}else{
				$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
				$pdf->Cell(115,$h,convertirc($topprestataire['Prestataire'].": "." ".format_N($topprestataire['montantApayer'])." ".$_SESSION['devise_C']),"LR",1,'L',false);
			}
	
		}
				
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(''),"LR",1,'L',false);
		foreach($topaffections  as $key=>$topaffection){
			if($key == 0){
				$pdf->Cell(75,$h,convertirc(_("TOP DES AFFECTIONS")),"LTR",0,'L',false);
				$pdf->Cell(115,$h,convertirc($topaffection['affection']." : "." ".format_N($topaffection['apresDecompte'])." ".$_SESSION['devise_C']." "._("soit")." ".$topaffection['Taux']." %"),"LTR",1,'L',false);
			}else{
				$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
				$pdf->Cell(115,$h,convertirc($topaffection['affection']."  : "." ".format_N($topaffection['apresDecompte'])." ".$_SESSION['devise_C']." "._("soit")." ".$topaffection['Taux']." %"),"LR",1,'L',false);
			}
	
		}
			
		$pdf->Cell(75,$h,convertirc(''),"LTR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(''),"LTR",1,'L',false);
		
		$pdf->Cell(75,$h,convertirc(_("SINISTRIALITÉ")),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("PROVISION MOYENNE")." : ".format_N($sinistrialites['PROVISION'])." ".$_SESSION['devise_C']),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("SINISTRIALITÉ MOYENNE")." : ".format_N($sinistrialites['SINISTRES'])." ".$_SESSION['devise_C']),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("ÉCART")." : ".format_N($sinistrialites['ECART'])." ".$_SESSION['devise_C']),"LR",1,'L',false);

		// tableau d'ajustement 
	
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(''),"LR",1,'L',false);
		

		foreach($tableaudajustements  as $key=>$tableaudajustement){
			if($tableaudajustement['codeGcAssureur'] ==$entete['codeGcAssureur'] ){
				$ajustement = $tableaudajustement['tauxAjustement']>=0.00 ? 'majoration' : 'minoration';
		
				if($tableaudajustement['spMin']<= $sinistrialites['RAPPRSP'] && $tableaudajustement['spMax']>= $sinistrialites['RAPPRSP'] ){
					$pdf->SetFont('Times', 'BI', 11);
					$pdf->SetTextColor(255, 0, 0);
					$conclusion =  $ajustement=="majoration" ? _("La tendance est ascendante par conséquent la police sera majorée au renouvelement.") : _("La tendance est constante par conséquent la police ne sera pas majorée au renouvelement.") ;

				}else{
					$pdf->SetFont('Times', 'BI', 9);
					$pdf->SetTextColor(0, 0, 0);
				}
				
				if($key == 0){
					$pdf->Cell(75,$h,convertirc(_("Tableau d'ajustement")),"LTR",0,'L',false);
					$pdf->Cell(115,$h,convertirc(_("de")." ".$tableaudajustement['spMin']." "._("à")." ".$tableaudajustement['spMax'].$ajustement.$tableaudajustement['tauxAjustement'] )),"LTR",1,'L',false);
				}else{
					$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
					$pdf->Cell(115,$h,convertirc(_("de")." ".$tableaudajustement['spMin']." "._("à")." ".$tableaudajustement['spMax'].$ajustement.$tableaudajustement['tauxAjustement'] )),"LR",1,'L',false);
				}
			}
		}
		
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(''),"LR",1,'L',false);
				
		$pdf->Cell(190,$h,convertirc(_($conclusion)),"LBR",1,'L',false);
		$pdf->AddPage(); // DEBUT FT1

		$statutsfts = $this->detailsp->donneelementaire_rp($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);

		$primeSinistrefts = $this->detailsp->donneelementaire_rp2_1($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin,$Chargement,$chargeravantapres );
  

		$pdf->SetMargins(10, 10, 10) ;
		$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit3.jpg', 0, 0, 210); 
		$pdf->SetY(40);
		$pdf->SetFont('Helvetica', 'B', 18);
		$pdf->SetTextColor( 65, 185, 80 );
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(50, 6, convertirc(_('DONNÉES ÉLÉMENTAIRES')), 0, 1, 'L', false);
	
		$pdf->Ln(8);
		$pdf->SetFont('Helvetica', 'B', 11);
		$pdf->SetTextColor(0);
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
		$pdf->Ln(8);

		if ($p_id!=null){
		  $pdf->SetFont('Helvetica', 'B', 11);
		  $pdf->Cell(10, 6, convertirc(''), 0, 0, 'L', false);
		  $pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
		  $pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);
	
		  $pdf->Cell(10, 6, convertirc(''), 0, 0, 'L', false);
		  $pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
		  $pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);
	
		  //$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
		  $pdf->Cell(10, 6, convertirc(''), 0, 0, 'L', false);
		  $pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
		  $pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);
	
		  $pdf->Cell(10, 6, convertirc(''), 0, 0, 'L', false);
		  $pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
		  $pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
		  //   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
		}else{
		  $pdf->Ln(10);
		  $pdf->SetFont('Helvetica', 'BUI', 11);
		  $pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		  $pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
		  $pdf->SetFont('Helvetica', 'BI', 11);
		  $pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
		}
		$pdf->SetX(15);
		$pdf->SetFont('Helvetica', 'BI', 11);
		$pdf->Cell(35, 6, convertirc(_('POPULATION')), 0, 0, 'L', false);
		$pdf->Cell(0, 6, convertirc(_(' : cf Tableau ci-dessous : ' )), 0, 1, 'L', false);
		//  $pdf->Cell(0, 6, convertirc(_("POPULATION").' : cf Tableau ci-dessous : '), 0, 1, 'L', false);
		  
		$pdf->Ln(10);

		$hl=6;
		$pdf->SetX(12);
		$pdf->SetFont('Arial', 'B', 8);
		$pdf->SetFillColor(143, 206, 143);
		$pdf->Cell(35, $hl, convertirc(_('Statut bénéficiaire')), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_("Nombre d'assurés sur la période")), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_("Bénéficiaires traités sur la période")), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_("% Bénéficiaires traités sur la période")), 1, 1, 'C', true);
		
		$pdf->SetFont('Arial', '', 9);

		$total_assure = 0;
		$total_traite = 0;
		$total_taux = 0;

		foreach ($statutsfts as $statutsf) {
			$pdf->SetX(12);
			$pdf->Cell(35, $hl, convertirc($statutsf['libelle']), 1, 0, 'L', false);
			$pdf->Cell(50, $hl, convertirc(format_N($statutsf['Nombre'])), 1, 0, 'C', false);
			$pdf->Cell(50, $hl, convertirc(format_N($statutsf['Nombretraite'])), 1, 0, 'C', false);
			$pdf->Cell(50, $hl, convertirc($statutsf['Taux_EffTraite']." %"), 1, 1, 'C', false);
			
			$total_assure = $total_assure + $statutsf['Nombre'];
			$total_traite = $total_traite + $statutsf['Nombretraite'];
			$total_taux   = $total_taux + $statutsf['Taux_EffTraite'];
		}
		$hl=8;
		$pdf->SetFont('Arial', 'B', 9);
		$pdf->SetFillColor(143, 206, 143);
		$pdf->SetX(12);
		$pdf->Cell(35, $hl, convertirc(_('TOTAL')), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_(format_N($total_assure))), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_(format_N($total_traite))), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_(format_N($total_taux)." %")), 1, 1, 'C', true);


		$pdf->Ln(15);

		$tp = 11;

		$ht = 6;

		
		$pdf->SetFont('Arial', 'BI', $tp);
		$pdf->SetTextColor( 65, 185, 80 );
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(190, $ht, convertirc("PRIMES ET SINISTRALITÉ DE LA POLICE "), 0, 1, 'C', false);
		$pdf->SetTextColor( 0, 0, 0 );
		foreach ($primeSinistrefts as $primeSinistreft) {

		}
		$pdf->SetFont('Helvetica', 'B', 11);

		$pdf->Ln(5);
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(100, $ht, convertirc(_("RAPPEL PRIME NETTE TOTALE :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['PRIMETOTALE']), 0, 1, 'L', false);
		
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(100, $ht, convertirc(_("PRIME NETTE DE LA PÉRIODE :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['PRIMENETTE']), 0, 1, 'L', false);
		
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(100, $ht, convertirc(_("CHARGEMENT DE LA PÉRIODE :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['CHARGEMENT']), 0, 1, 'L', false);
		
		$pdf->Ln(5);
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(100, $ht, convertirc(_("PROVISION POUR SINISTRE DE LA PÉRIODE :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['PROVISION']), 0, 1, 'L', false);
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(100, $ht, convertirc(_("SINISTRE DE LA PÉRIODE :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['SINISTRES']), 0, 1, 'L', false);
		
		$pdf->Ln(10);
		
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(120, $ht, convertirc(_("RÉSULTATS TECHNIQUES DE LA PÉRIODE (Rapport Sinistres/Primes) :")), 0, 1, 'L', false);
		if($chargeravantapres =="AVANT"){
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(125, $ht, convertirc(_("RAPPORT (SINISTRES/PRIME NETTE DE LA PÉRIODE) NET :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, number_format($primeSinistreft['RAPPRSP'], 2, '.', ','), 0, 1, 'L', false);
		
		}else{
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(110, $ht, convertirc(_("RAPPORT (SINISTRES/PROVISION) NET :")), 0, 0, 'L', false);
		  $pdf->Cell(40, $ht, number_format($primeSinistreft['RAPPRSP'], 2, '.', ','), 0, 1, 'L', false);
	  
		}
  
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(125, $ht, convertirc(_("EXCEDENT (ou DEFICIT (-)) :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['ECART']), 0, 1, 'L', false);

		$pdf->AddPage('L'); // debut MOUVEMENTS D'EFFECTIFS PAR COLLEGE 
			
			$p_factures  	= $this->detailsp->mouvementeffectifcollege($p_garant, $p_id_clients, $p_id,  $p_id_college,$p_apporteur, $p_datedebut,  $p_datefin,$p_limite );
			$pdf->SetMargins(10, 10, 10) ;
			$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit7.jpg', 0, 0, 297); 
			$pdf->SetY(15);
			$pdf->SetFont('Helvetica', 'B', 18);
			$pdf->SetTextColor( 65, 185, 80 );
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->MultiCell(150, 8, convertirc(_("MOUVEMENTS D'EFFECTIFS PAR COLLEGE")), 0, 'L' );

			$pdf->Ln(8);
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->SetTextColor(0);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
			$pdf->Ln(10);

			if ($p_id!=null){

				$pdf->SetFont('Helvetica', 'B', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);
		
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);
		
				//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);
		
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
				//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
			}else{
				$pdf->Ln(10);
				$pdf->SetFont('Helvetica', 'BUI', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->SetFont('Helvetica', 'BI', 11);
				$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}
			$pdf->Ln(10);


			$hl=7;
			$pdf->SetFont('Arial','',7);
			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(15,$hl,convertirc(_('idCollege')),1,0,'C',true);
			$pdf->Cell(60,$hl,convertirc(_("College")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Janvier")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Février")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Mars")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Avril")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Mai")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Juin")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Juillet")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Août")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Septembre")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Octobre")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Novembre")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Décembre")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Totaux")),1,1,'C',true);
			$total_JANVIER = 0;
			$total_FEVRIER = 0;
			$total_MARS = 0;
			$total_AVRIL = 0;
			$total_MAI = 0;
			$total_JUIN = 0;
			$total_JUILLET = 0;
			$total_AOUT = 0;
			$total_SEPTEMBRE = 0;
			$total_OCTOBRE = 0;
			$total_NOVEMBRE = 0;
			$total_DECEMBRE = 0;
			$total_TOTAUX = 0;
			
			foreach ($p_factures as $dep)
			{
				$taillelibelleCollege = strlen($dep['libelleCollege']); // compter le nombre de caractere de la chaine
				if($taillelibelleCollege>43) {
					$hl= 4;
					$text = wordwrap($dep['libelleCollege'], 45, "***", false); // insertion de marqueurs ***

					$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); //suppression du dernier espace dans la partie de texte restante
					
					$pdf->Cell(15,$hl,convertirc($dep['idCollege']),"LTR",0,'C',false);
					$pdf->Cell(60,$hl,convertirc($part1),"LTR",0,'L',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['JANVIER'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['FEVRIER'])),"LTR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['MARS'])),"LTR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['AVRIL'])),"LTR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['MAI'])),"LTR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['JUIN'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['JUILLET'])),"LTR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['AOUT'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['SEPTEMBRE'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['OCTOBRE'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['NOVEMBRE'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['DECEMBRE'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['TOTAUX'])),"LTR",1,'C',false);

					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(60,$hl,convertirc($part2),"LBR",0,'L',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",1,'C',false);
					
				}
				else{
					$pdf->Cell(15,$hl,convertirc($dep['idCollege']),1,0,'C',false);
					$pdf->Cell(60,$hl,convertirc($dep['libelleCollege']),1,0,'L',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['JANVIER'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['FEVRIER'])),1,0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['MARS'])),1,0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['AVRIL'])),1,0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['MAI'])),1,0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['JUIN'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['JUILLET'])),1,0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['AOUT'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['SEPTEMBRE'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['OCTOBRE'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['NOVEMBRE'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['DECEMBRE'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['TOTAUX'])),1,1,'C',false);
				}
				
			
				$total_JANVIER = $total_JANVIER + $dep['JANVIER'];
				$total_FEVRIER = $total_FEVRIER + $dep['FEVRIER'];
				$total_MARS = $total_MARS + $dep['MARS'];
				$total_AVRIL = $total_AVRIL + $dep['AVRIL'];
				$total_MAI = $total_MAI + $dep['MAI'];
				$total_JUIN = $total_JUIN + $dep['JUIN'];
				$total_JUILLET = $total_JUILLET + $dep['JUILLET'];
				$total_AOUT = $total_AOUT + $dep['AOUT'];
				$total_SEPTEMBRE = $total_SEPTEMBRE + $dep['SEPTEMBRE'];
				$total_OCTOBRE = $total_OCTOBRE + $dep['OCTOBRE'];
				$total_NOVEMBRE = $total_NOVEMBRE + $dep['NOVEMBRE'];
				$total_DECEMBRE = $total_DECEMBRE + $dep['DECEMBRE'];
				$total_TOTAUX = $total_TOTAUX + $dep['TOTAUX'];
			}	
			$pdf->SetFont('Arial','B',8);
			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(75,$hl,convertirc("TOTAL GENERAL"),"1",0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_JANVIER),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_FEVRIER),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_MARS),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_AVRIL),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_MAI),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_JUIN),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_JUILLET),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_AOUT),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_SEPTEMBRE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_OCTOBRE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_NOVEMBRE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_DECEMBRE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_TOTAUX),1,1,'C',true);

			
			$pdf->Ln(5);
			
			$pdf->Cell(45,$hl,convertirc(_("Nombre de lignes: ").count($p_factures)),0,0,'L',false);
		$pdf->AddPage(); // debut etat des depenses par college
			
			$p_factures  	= $this->detailsp->get_depense_contrat_college_rp($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin);

		$pdf->SetMargins(10, 10, 10) ;
		$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit5.jpg', 0, 0, 210);
		
		$pdf->SetFont('Arial','B',13);

		$pdf->SetY(40);
		$pdf->SetFont('Helvetica', 'B', 18);
		$pdf->SetTextColor( 65, 185, 80 );
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->MultiCell(145, 8, convertirc(_("DÉPENSES PAR FAMILLES ET PAR COLLEGE")), 0, 'L' );

		$pdf->Ln(8);
		$pdf->SetFont('Helvetica', 'B', 11);
		$pdf->SetTextColor(0);
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
		$pdf->Ln(10);
			if ($p_id!=null){
		
					$pdf->SetFont('Helvetica', 'B', 11);
					$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
					$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
					$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);
			
					$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
					$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
					$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);
			
					//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
					$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
					$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
					$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);
			
					$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
					$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
					$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
					//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
				}else{
					$pdf->Ln(10);
					$pdf->SetFont('Helvetica', 'BUI', 11);
					$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
					$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
					$pdf->SetFont('Helvetica', 'BI', 11);
					$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}
			$pdf->Ln(5);
			

			$hl=7;
			$pdf->SetFont('Arial','B',8);
			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(16,$hl,convertirc(_("Id")),1,0,'C',true);
			$pdf->Cell(94,$hl,convertirc(_("College")),1,0,'C',true);
			$pdf->Cell(30,$hl,convertirc(_("Mt Recl.")),1,0,'C',true);
			$pdf->Cell(30,$hl,convertirc(_("Mt Remb.")),1,0,'C',true);
			$pdf->Cell(20,$hl,convertirc(_("Taux (%)")),1,1,'C',true);
			
			$pdf->SetFont('Arial','',8);

			$total_montantFacture = 0;
			$total_apresDecompte = 0;
			$total_taux = 0;
		foreach ($p_factures as $p_facture){
		

			$total_montantFacture = $total_montantFacture + $p_facture['montantFacture'];
			$total_apresDecompte = $total_apresDecompte + $p_facture['apresDecompte'];
			$total_taux   = $total_taux + $p_facture['Taux'];

		
				$pdf->Cell(16,$hl,convertirc($p_facture['id']),1,0,'C',false);
			$pdf->Cell(94,$hl,convertirc($p_facture['libelleCollege']),1,0,'L',false);
				$pdf->Cell(30,$hl,convertirc(format_N($p_facture['montantFacture'])),1,0,'C',false);
				$pdf->Cell(30,$hl,convertirc(format_N($p_facture['apresDecompte'])),1,0,'C',false);
				$pdf->Cell(20,$hl,convertirc($p_facture['Taux']),1,1,'C',false);
			}
			$pdf->Cell(110,$hl,convertirc("TOTAL GENERAL"),1,0,'L',true);
			$pdf->Cell(30,$hl,convertirc(format_N($total_montantFacture)),1,0,'C',true);
			$pdf->Cell(30,$hl,convertirc(format_N($total_apresDecompte)),1,0,'C',true);
			$pdf->Cell(20,$hl,convertirc(format_N($total_taux)),1,1,'C',true);
		
				
			$pdf->SetFont('Helvetica','B',10);
			$pdf->Cell(45,$hl,convertirc(_(" * Légende :")),0,0,'L',false);

			$pdf->Ln(5);
			$pdf->SetX(16);
			$pdf->Cell(45,$hl,convertirc(_("Mt Recl. = Montant reclamé ")),0,0,'L',false);
			$pdf->Ln(5);
			$pdf->SetX(16);
			$pdf->Cell(45,$hl,convertirc(_("Mt Remb. = Montant  rembousé")),0,0,'L',false);
			$pdf->AddPage(); // debut ft3

			
			$p_factures  	= $this->detailsp->recapdepensesstatutbenef($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin);
			$statutsfts  	= $this->detailsp->recapdepensesstatutbenefdeux($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin);

			$statuts   		= $this->detailsp->listestatutbeneficiaire($idPolice,$p_datedebut,$p_datefin);

			$pdf->SetMargins(10, 10, 10) ;
			$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit3.jpg', 0, 0, 210); 
			$pdf->SetY(30);
			$pdf->SetFont('Helvetica', 'B', 18);
			$pdf->SetTextColor( 65, 185, 80 );
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->MultiCell(145, 8, convertirc(_("RÉCAPITULATIF DES DÉPENSES PAR STATUT DE BÉNEFICIAIRES")), 0, 'L' );

			$pdf->Ln(8);
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->SetTextColor(0);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
			$pdf->Ln(10);

			if ($p_id!=null){
		
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
			$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);

			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
			$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);

			//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
			$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);

			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
			$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
			//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
			}else{
			$pdf->Ln(10);
			$pdf->SetFont('Helvetica', 'BUI', 11);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
			$pdf->SetFont('Helvetica', 'BI', 11);
			$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}

			$pdf->Ln(5);
			$hl=6;
			$pdf->SetX(13);
			$pdf->SetFont('Arial','B',9);
			$pdf->Cell(184,6,convertirc(_('Dépenses par statut de bénéficiaires')),1,1,'C',false);
			$pdf->SetFont('Arial','B',8);
			$pdf->SetFillColor(143,206,143);
			$pdf->SetX(13);
			$pdf->Cell(34,$hl,convertirc(_('Statut bénéficiaire')),1,0,'C',true);
			$pdf->Cell(25,$hl,convertirc(_("Nombre")),1,0,'C',true);
			$pdf->Cell(25,$hl,convertirc(_("Taux effectif")),1,0,'C',true);
			$pdf->Cell(25,$hl,convertirc(_("Age moyen")),1,0,'C',true);
			$pdf->Cell(27,$hl,convertirc(_("Montant")),1,0,'C',true);
			$pdf->Cell(24,$hl,convertirc(_("Taux")),1,0,'C',true);
			$pdf->Cell(24,$hl,convertirc(_("Coût moyen")),1,1,'C',true);
			
			$pdf->SetFont('Arial','',9);
			
			
			$total_Nombre 	= 0;
			$total_Taux_Eff 	= 0;
			$total_Age_Moyen 	= 0;
			$total_Montant 	= 0;
			$total_tauxMontantTraite   	= 0;
			$total_coutMoyenTraite   	= 0;
			
			foreach ($p_factures as $p_facture)
			{
			$pdf->SetX(13);

				$pdf->Cell(34,$hl,convertirc($p_facture['libelle']),1,0,'L',false);
				$pdf->Cell(25,$hl,convertirc(format_N($p_facture['Nombre'])),1,0,'C',false);
				$pdf->Cell(25,$hl,convertirc($p_facture['Taux_Eff']."%"),1,0,'C',false);
				$pdf->Cell(25,$hl,convertirc($p_facture['Age_Moyen']),1,0,'C',false);
				$pdf->Cell(27,$hl,convertirc(format_N($p_facture['Montant'])),1,0,'C',false);
				$pdf->Cell(24,$hl,convertirc($p_facture['Taux_Depense']."%"),1,0,'C',false);
				$pdf->Cell(24,$hl,convertirc(format_N($p_facture['CoutMoyen'])),1,1,'C',false);

				$total_Nombre 	= $total_Nombre + $p_facture['Nombre'];
				$total_Taux_Eff 	= $total_Taux_Eff + $p_facture['Taux_Eff'];
				$total_Age_Moyen 	= $total_Age_Moyen + $p_facture['Age_Moyen'];
				$total_Montant 	= $total_Montant + $p_facture['Montant'];
				$total_tauxMontantTraite   	= $total_tauxMontantTraite + $p_facture['Taux_Depense'];
				$total_coutMoyenTraite   	= $total_coutMoyenTraite + $p_facture['CoutMoyen'];
			}
			$pdf->SetFont('Arial','B',9);
			$pdf->SetX(13);

			$total_Age_Moyen =$total_Age_Moyen /6;
			$pdf->Cell(34,$hl,convertirc("TOTAL GENERAL"),"1",0,'C',true);
			$pdf->Cell(25,$hl,format_N($total_Nombre),1,0,'C',true);
			$pdf->Cell(25,$hl,format_N($total_Taux_Eff)."%",1,0,'C',true);
			$pdf->Cell(25,$hl,format_N($total_Age_Moyen),1,0,'C',true);
			$pdf->Cell(27,$hl,format_N($total_Montant),1,0,'C',true);
			$pdf->Cell(24,$hl,format_N($total_tauxMontantTraite)."%",1,0,'C',true);
			$pdf->Cell(24,$hl,format_N($total_coutMoyenTraite),1,0,'C',true);

			$pdf->SetFont('Arial','B',8);
			$pdf->SetY(160);
			$pdf->Cell(10,8,(''),0,0);
			$pdf->Cell(80,8,convertirc(_('Récapitulatif dépenses par statut bénéficiaire (%)')),1,0,'C',false);
			$pdf->Cell(10,8,(''),0,0);
			$pdf->Cell(80,8,convertirc(_('Récapitulatif des bénéficiaires traités par statut (%)')),1,1,'C',false);
			$pdf->Ln(5);

			$pdf->Rect(20,168, 80, 52, 'D');
			$pdf->Rect(110, 168, 80, 52, 'D');
			// DEBUT GRAPH
			$valeur0=0;
			$valeur1=0;
			$valeur2=0;
			$valeur3=0;
			$valeur4=0;
			$valeur5=0;
			$value=0;
			$v=0;
			$valeurs=array();

			foreach($p_factures as $key => $value){
				array_push($valeurs,$value['Taux_Depense']);
			}
			
			foreach($valeurs as $key =>$valeur){	
			if ($key == 0) {
				$valeur0 = $valeur;
				
			}
			if ($key == 1) {
				$valeur1 = $valeur;
				
			}
			if ($key == 2) {
				$valeur2 = $valeur;
				
			}
			if ($key == 3) {
				$valeur3 = $valeur;
				
			}
			if ($key == 4) {
				$valeur4 = $valeur;
				
			}
			if ($key == 5) {
				$valeur5 = $valeur;
				
			}

			$data=Array(
				'A'=>[
					'color'=>[255,0,0],
					'value'=>$valeur0],
				'C'=>[
					'color'=>[255,255,0],
					'value'=>$valeur1],
				'E'=>[
					'color'=>[50,0,255],
					'value'=>$valeur2],
				'O'=>[
					'color'=>[255,0,255],
					'value'=>$valeur3],
				'F'=>[
					'color'=>[0,255,0],
					'value'=>$valeur4],
				'D'=>[
					'color'=>[0,0,0],
					'value'=>$valeur5]
				);
			}	
				//pie and legend properties
				$pieX=40;
				$pieY=195;
				$r=14;//radius
				$legendX=65;
				$legendY=185;

				//get total data summary
				$dataSum=0;
				foreach($data as $item){
					$dataSum+=$item['value'];
				}

				//get scale unit for each degree
				$degUnit=360/$dataSum;

				//variable to store current angle
				$currentAngle=0;
				//store current legend Y position
				$currentLegendY=$legendY;

				$pdf->SetFont('Arial','',8);

				//simplify the code by drawing both pie and legend in one loop
				foreach($data as $index=>$item){
					//draw the pie
					//slice size
					$deg=$degUnit*$item['value'];
					//set color
					$pdf->SetFillColor($item['color'][0],$item['color'][1],$item['color'][2]);
					//remove border
					$pdf->SetDrawColor($item['color'][0],$item['color'][1],$item['color'][2]);
					//draw the slice
					$pdf->Sector($pieX,$pieY,$r,$currentAngle,$currentAngle+$deg);
					//add slice angle to currentAngle var
					$currentAngle+=$deg;
					
					//draw the legend	
					$pdf->SetFont('Arial','',8);
				//	$pdf->SetXY($chartX,$chartY);
					$pdf->Rect($legendX,$currentLegendY,4,4,'DF');
					$pdf->SetXY($legendX + 6,$currentLegendY);
					foreach($valeurs as $key =>$valeur){	
						if ($key == 0) {
							$v0 = $valeur;
							
						}
						if ($key == 1) {
							$v1 = $valeur;
							
						}
						if ($key == 2) {
							$v2 = $valeur;
							
						}
						if ($key == 3) {
							$v3 = $valeur;
							
						}
						if ($key == 4) {
							$v4 = $valeur;
							
						}
						if ($key == 5) {
							$v5 = $valeur;
							
						}
					}
					$pdf->Cell(20,5,convertirc(_($index)),0,0);
					if ($index == 'A') {
						$pdf->Cell(10,5,convertirc(_($v0)),0,0);
					}
					if ($index == 'C') {
						$pdf->Cell(10,5,convertirc(_($v1)),0,0);
					}
					if ($index == 'E') {
						$pdf->Cell(10,5,convertirc(_($v2)),0,0);
					}
					if ($index == 'O') {
						$pdf->Cell(10,5,convertirc(_('0')),0,0);
					}
					if ($index == 'F') {
						$pdf->Cell(10,5,convertirc(_($v4)),0,0);
					}
					if ($index == 'D') {
						$pdf->Cell(10,5,convertirc(_($v5)),0,0);
					}
					$currentLegendY+=5;
				}


			$valeur0=0;
			$valeur1=0;
			$valeur2=0;
			$valeur3=0;
			$valeur4=0;
			$valeur5=0;
			$value=0;
			$v=0;
			$valeurs=array();
			foreach($statutsfts as $key => $value){
				array_push($valeurs,$value['Taux_Eff']);
			}
			
			foreach($valeurs as $key =>$valeur){	
			if ($key == 0) {
				$valeur0 = $valeur;
				
			}
			if ($key == 1) {
				$valeur1 = $valeur;
				
			}
			if ($key == 2) {
				$valeur2 = $valeur;
				
			}
			if ($key == 3) {
				$valeur3 = $valeur;
				
			}
			if ($key == 4) {
				$valeur4 = $valeur;
				
			}
			if ($key == 5) {
				$valeur5 = $valeur;
				
			}

			$data=Array(
				'A'=>[
					'color'=>[255,0,0],
					'value'=>$valeur0],
				'C'=>[
					'color'=>[255,255,0],
					'value'=>$valeur1],
				'E'=>[
					'color'=>[50,0,255],
					'value'=>$valeur2],
				'O'=>[
					'color'=>[255,0,255],
					'value'=>$valeur3],
				'F'=>[
					'color'=>[0,255,0],
					'value'=>$valeur4],
				'D'=>[
					'color'=>[0,0,0],
					'value'=>$valeur5]
				);
			}	
				//pie and legend properties
				$pieX=130;
				$pieY=195;
				$r=14;//radius
				$legendX=155;
				$legendY=185;

				//get total data summary
				$dataSum=0;
				foreach($data as $item){
					$dataSum+=$item['value'];
				}

				//get scale unit for each degree
				$degUnit=360/$dataSum;

				//variable to store current angle
				$currentAngle=0;
				//store current legend Y position
				$currentLegendY=$legendY;

				$pdf->SetFont('Arial','',8);

				//simplify the code by drawing both pie and legend in one loop
				foreach($data as $index=>$item){
					//draw the pie
					//slice size
					$deg=$degUnit*$item['value'];
					//set color
					$pdf->SetFillColor($item['color'][0],$item['color'][1],$item['color'][2]);
					//remove border
					$pdf->SetDrawColor($item['color'][0],$item['color'][1],$item['color'][2]);
					//draw the slice
					$pdf->Sector($pieX,$pieY,$r,$currentAngle,$currentAngle+$deg);
					//add slice angle to currentAngle var
					$currentAngle+=$deg;
					
					//draw the legend	
					$pdf->SetFont('Arial','',8);
				//	$pdf->SetXY($chartX,$chartY);
					$pdf->Rect($legendX,$currentLegendY,4,4,'DF');
					$pdf->SetXY($legendX + 6,$currentLegendY);
					foreach($valeurs as $key =>$valeur){	
						if ($key == 0) {
							$v0 = $valeur;
							
						}
						if ($key == 1) {
							$v1 = $valeur;
							
						}
						if ($key == 2) {
							$v2 = $valeur;
							
						}
						if ($key == 3) {
							$v3 = $valeur;
							
						}
						if ($key == 4) {
							$v4 = $valeur;
							
						}
						if ($key == 5) {
							$v5 = $valeur;
							
						}
					}
					$pdf->Cell(20,5,convertirc(_($index)),0,0);
					if ($index == 'A') {
						$pdf->Cell(10,5,convertirc(_($v0)),0,0);
					}
					if ($index == 'C') {
						$pdf->Cell(10,5,convertirc(_($v1)),0,0);
					}
					if ($index == 'E') {
						$pdf->Cell(10,5,convertirc(_($v2)),0,0);
					}
					if ($index == 'O') {
						$pdf->Cell(10,5,convertirc(_($v3)),0,0);
					}
					if ($index == 'F') {
						$pdf->Cell(10,5,convertirc(_($v4)),0,0);
					}
					if ($index == 'D') {
						$pdf->Cell(10,5,convertirc(_($v5)),0,0);
					}
					$currentLegendY+=5;
				}	


			$pdf->Ln(18);

			$hl=5;
			$pdf->SetX(13);
			$pdf->SetFont('Arial','B',9);
			$pdf->Cell(184,6,convertirc(_('Dépenses des bénéficiaires traités par statut')),1,1,'C',false);
			$pdf->SetFont('Arial','B',8);
			$pdf->SetX(13);
			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(34,$hl,convertirc(_('Statut bénéficiaire')),1,0,'C',true);
			$pdf->Cell(51,$hl,convertirc(_("Nombre de fois traités sur la période")),1,0,'C',true);
			$pdf->Cell(24,$hl,convertirc(_("Taux traités")),1,0,'C',true);
			$pdf->Cell(27,$hl,convertirc(_("Dépenses")),1,0,'C',true);
			$pdf->Cell(24,$hl,convertirc(_("Taux")),1,0,'C',true);
			$pdf->Cell(24,$hl,convertirc(_("Coût moyen")),1,1,'C',true);
			
			$pdf->SetFont('Arial','',9);
			
			
			$total_BenefTraite   	= 0;
			$total_Taux_EffTraite   = 0;
			$total_Depensestraite 	= 0;
			$total_Taux_Depense =0;
			$total_coutMoyenTraite   = 0;
			
			foreach ($statutsfts as $statutsft)
			{
				$pdf->SetX(13);
				$pdf->Cell(34,$hl,convertirc($statutsft['libelle']),1,0,'L',false);
				$pdf->Cell(51,$hl,convertirc(format_N($statutsft['BenefTraite'])),1,0,'C',false);
				$pdf->Cell(24,$hl,convertirc($statutsft['Taux_Eff']."%"),1,0,'C',false);
				$pdf->Cell(27,$hl,convertirc(format_N($statutsft['Depenses'])),1,0,'C',false);
				$pdf->Cell(24,$hl,convertirc($statutsft['Taux_Depense']."%"),1,0,'C',false);
				$pdf->Cell(24,$hl,convertirc(format_N($statutsft['CoutMoyen'])),1,1,'C',false);
				
				
				$total_BenefTraite   	= $total_BenefTraite + $statutsft['BenefTraite'];
				$total_Taux_EffTraite   	= $total_Taux_EffTraite + $statutsft['Taux_Eff'];
				$total_Depensestraite 				= $total_Depensestraite + $statutsft['Depenses'];
				$total_Taux_Depense 				= $total_Taux_Depense+ $statutsft['Taux_Depense'];
				$total_coutMoyenTraite   				= $total_coutMoyenTraite + $statutsft['CoutMoyen'];
			}
			$pdf->SetFont('Arial','B',9);
			$pdf->SetX(13);
			$pdf->Cell(34,$hl,convertirc("TOTAL GÉNERAL"),"1",0,'C',true);
			$pdf->Cell(51,$hl,format_N($total_BenefTraite),1,0,'C',true);
			$pdf->Cell(24,$hl,$total_Taux_EffTraite."%",1,0,'C',true);
			$pdf->Cell(27,$hl,format_N($total_Depensestraite),1,0,'C',true);
			$pdf->Cell(24,$hl,format_N($total_tauxMontantTraite)."%",1,0,'C',true);
			$pdf->Cell(24,$hl,format_N($total_coutMoyenTraite),1,0,'C',true);

		$pdf->AddPage();// debut ft 8

			$p_factures  	= $this->detailsp->etatrecapdepensesparfamilledactesmedicaux($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin);
			$pdf->SetMargins(10, 10, 10) ;
			$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit5.jpg', 0, 0, 210); 
			$pdf->SetY(15);
			$pdf->SetFont('Helvetica', 'B', 18);
			$pdf->SetTextColor( 65, 185, 80 );
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->MultiCell(150, 8, convertirc(_("RÉCAPITULATIF DES DÉPENSES PAR FAMILLE D'ACTES")), 0, 'L' );

			$pdf->Ln(8);
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->SetTextColor(0);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
			$pdf->Ln(10);

			if ($p_id!=null){

				$pdf->SetFont('Helvetica', 'B', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);

				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);

				//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);

				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
				//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
			}else{
				$pdf->Ln(10);
				$pdf->SetFont('Helvetica', 'BUI', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->SetFont('Helvetica', 'BI', 11);
				$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}
			$pdf->Ln(10);

			$hl=6;
			$pdf->SetFont('Arial', 'B', 8);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(15, $hl, convertirc(_('Code')), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(80, $hl, convertirc(_("Libellé")), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(20, $hl, convertirc(_("Quantité")), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(30, $hl, convertirc(_("Montant Remboursé")), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(25, $hl, convertirc(_("Coût Moyen")), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(20, $hl, convertirc(_("Taux")), 1, 1, 'C', true);
			$pdf->SetFont('Arial', '', 9);

			$total_assure = 0;
			$total_coutmoyen =0;
			$total_quantite =0;
			$total_montantrembourse  =0;
			$total_traite = 0;
			$total_taux = 0;

			foreach ($p_factures as $p_facture) {
				$pdf->Cell(15, $hl, convertirc($p_facture['codeGarantie']), 1, 0, 'L', false);
				$pdf->Cell(80, $hl, convertirc($p_facture['libelle']), 1, 0, 'L', false);
				$pdf->Cell(20, $hl, convertirc(format_N($p_facture['Quantite'])), 1, 0, 'C', false);
				$pdf->Cell(30, $hl, convertirc(format_N($p_facture['MontantRembourse'])), 1, 0, 'R', false);
				$pdf->Cell(25, $hl, convertirc(format_N($p_facture['Coutmoyen'])), 1, 0, 'R', false);
				$pdf->Cell(20, $hl, convertirc($p_facture['Taux']), 1, 1, 'C', false);
				
				$total_coutmoyen = $total_coutmoyen + $p_facture['Coutmoyen'];
				$total_quantite = $total_quantite + $p_facture['Quantite'];
				$total_montantrembourse = $total_montantrembourse + $p_facture['MontantRembourse'];
				$total_taux   = $total_taux + $p_facture['Taux'];
			}
			$hl=8;
			$pdf->SetFont('Arial', 'B', 9);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(95, $hl, convertirc(_('TOTAL')), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(20, $hl, convertirc(_(format_N($total_quantite))), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(30, $hl, convertirc(_(format_N($total_montantrembourse))), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(25, $hl, convertirc(_(format_N($total_coutmoyen))), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(20, $hl, convertirc(_(convertirc('100 %'))), 1, 1, 'C', true);


			$chartX=15;
			$chartY=175;

			//dimension
			$chartWidth=180;
			$chartHeight=100;

			//padding
			$chartTopPadding=12;
			$chartLeftPadding=20;
			$chartBottomPadding=10;
			$chartRightPadding=5;

			//chart box
			$chartBoxX=$chartX+$chartLeftPadding;
			$chartBoxY=$chartY+$chartTopPadding;
			$chartBoxWidth=$chartWidth-$chartLeftPadding-$chartRightPadding;
			$chartBoxHeight=$chartHeight-$chartBottomPadding-$chartTopPadding;

			//bar width
			$barWidth=8;
			$valeur0=0;
			$valeur1=0;
			$valeur2=0;
			$valeur3=0;
			$valeur4=0;
			$valeur5=0;
			$valeur6=0;
			$valeur7=0;
			$valeur8=0;
			$valeur9=0;
			$valeur10=0;

			$value=0;
			$v=0;
			$valeurs=array();
			foreach($p_factures as $p_factures['codeGarantie'] => $value)
			{

				array_push($valeurs,$value['Taux']);
				foreach($valeurs as $key =>$valeur)
				{	
				if ($value['codeGarantie'] == 'AUX') {
					$valeur1 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'BIO') {
					$valeur2 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'CON') {
					$valeur3 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'DEN') {
					$valeur4 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'EXA') {
					$valeur5 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'HOS') {
					$valeur6 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'IMA') {
					$valeur7 =  $value['Taux'];
				}
				if ($value['codeGarantie'] == 'MAT') {
					$valeur8 =  $value['Taux'];
				}
				if ($value['codeGarantie'] == 'OPT') {
					$valeur9 = $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'PHA') {
					$valeur10 =  $value['Taux'];	
				}
				$data=Array(
					'AUX'=>[
						'color'=>[255,0,0],
						'value'=>$valeur1],
					'BIO'=>[
						'color'=>[255,255,0],
						'value'=>$valeur2],
					'CON'=>[
						'color'=>[50,0,255],
						'value'=>$valeur3],
					'DEN'=>[
						'color'=>[255,0,255],
						'value'=>$valeur4],
					'EXA'=>[
						'color'=>[0,255,0],
						'value'=>$valeur5],
					'HOS'=>[
						'color'=>[200,255,100],
						'value'=>$valeur6],
					'IMA'=>[
						'color'=>[121,248,248],
						'value'=>$valeur7],
					'MAT'=>[
						'color'=>[121,210,180],
						'value'=>$valeur8],
					'OPT'=>[
						'color'=>[221,248,248],
						'value'=>$valeur9],
					'PHA'=>[
						'color'=>[0,100,108],
						'value'=>$valeur10]	
					);
				}			
			}
			$dataMax=0;
			foreach($data as $item){
				if($item['value']>$dataMax)
				$dataMax=$item['value'];
			}
			//data step
			if($dataMax>200 and $dataMax<600){
				
				$dataStep=20;
			}
			if($dataMax<200){
				$dataStep=10;
			}
			if($dataMax>1000){
				
				$dataStep=100;
			}		
			//set font, line width and color
			$pdf->SetFont('Arial','',8);
			$pdf->SetLineWidth(0.1);
			$pdf->SetDrawColor(0);	
			//chart boundary
			$pdf->Rect($chartX,$chartY,$chartWidth,$chartHeight);	
			//vertical axis line
			$pdf->Line(
				$chartBoxX ,
				$chartBoxY , 
				$chartBoxX , 
				($chartBoxY+$chartBoxHeight)
				);
			//horizontal axis line
			$pdf->Line(
				$chartBoxX-2 , 
				($chartBoxY+$chartBoxHeight) , 
				$chartBoxX+($chartBoxWidth) , 
				($chartBoxY+$chartBoxHeight)
				);		
			///vertical axis
			//calculate chart's y axis scale unit
			$yAxisUnits=$chartBoxHeight/$dataMax;		
			//draw the vertical (y) axis labels
			for($i=0 ; $i<=$dataMax ; $i+=$dataStep){
				//y position
				$yAxisPos=$chartBoxY+($yAxisUnits*$i);
				//draw y axis line
				$pdf->Line(
					$chartBoxX-2 ,
					$yAxisPos ,
					$chartBoxX ,
					$yAxisPos
				);
				//set cell position for y axis labels
				$pdf->SetXY($chartBoxX-$chartLeftPadding , $yAxisPos-2);
				//$pdf->Cell($chartLeftPadding-4 , 5 , $dataMax-$i , 1);---------------
				$pdf->Cell($chartLeftPadding-4 , 5 , $dataMax-$i, 0 , 0 , 'R');
			}	
			///horizontal axis
			//set cells position
			$pdf->SetXY($chartBoxX , $chartBoxY+$chartBoxHeight);		
			//cell's width
			$xLabelWidth=$chartBoxWidth / count($data);		
			//$pdf->Cell($xLabelWidth , 5 , $itemName , 1 , 0 , 'C');-------------
			//loop horizontal axis and draw the bar
			$barXPos=0;
			foreach($data as $itemName=>$item){
				//print the label
				//$pdf->Cell($xLabelWidth , 5 , $itemName , 1 , 0 , 'C');--------------
				$pdf->Cell($xLabelWidth , 5 , $itemName , 0 , 0 , 'C');
				
				///drawing the bar
				//bar color
				$pdf->SetFillColor($item['color'][0],$item['color'][1],$item['color'][2]);
				//bar height
				$barHeight=$yAxisUnits*$item['value'];
				//bar x position
				$barX=($xLabelWidth/2)+($xLabelWidth*$barXPos);
				$barX=$barX-($barWidth/2);
				$barX=$barX+$chartBoxX;
				//bar y position
				$barY=$chartBoxHeight-$barHeight;
				$barY=$barY+$chartBoxY;
				//draw the bar
				$pdf->Rect($barX,$barY,$barWidth,$barHeight,'DF');
				//increase x position (next series)
				$barXPos++;
			}	
			//axis labels
			$pdf->SetFont('Arial','B',9);
			$pdf->SetXY($chartX,$chartY);
			$pdf->Cell(30,10,"Taux",0);
			$pdf->SetXY(($chartWidth/2)-50+$chartX,$chartY+$chartHeight-($chartBottomPadding/2));
			$pdf->Cell(100,5,convertirc(_("Récapitulatif des dépenses par famille d'acte")),0,0,'C');
			$pdf->AddPage();// debut fiche 11
			$depensesFamillesA  = $this->detailsp->etatcomparatifdesdepensesA($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin, $p_limite);
			$depensesFamillesB  = $this->detailsp->etatcomparatifdesdepensesB($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin, $p_limite);

			$pdf->SetMargins(10, 10, 10) ;
			$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit5.jpg', 0, 0, 210); 
			$pdf->SetY(10);
			$pdf->SetFont('Helvetica', 'B', 18);
			$pdf->SetTextColor( 65, 185, 80 );
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->MultiCell(150, 8, convertirc(_("COMPARATIF DES DÉPENSES DES ANNÉE N-1 ET N")), 0, 'L' );

			$pdf->Ln(8);
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->SetTextColor(0);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
			$pdf->Ln(9);

			if ($p_id!=null){

				$pdf->SetFont('Helvetica', 'B', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);

				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);

				//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);

				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
				//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
			}else{
				$pdf->Ln(10);
				$pdf->SetFont('Helvetica', 'BUI', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->SetFont('Helvetica', 'BI', 11);
				$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}
			$pdf->Ln(2);

			$hl=7;
			$pdf->SetFont('Arial','BU',10);
			$annee = date("Y", strtotime($p_datefin));
			$precannee = $annee -1;
			$pdf->Cell(95,$hl,convertirc(_('Etat des dépenses de l\'année n-1')),1,0,'C',FALSE);
			$pdf->Cell(95,$hl,convertirc(_('Etat des dépenses de l\'année n')),1,1,'C',FALSE);
			$pdf->SetFillColor(255,250,205);
			$pdf->SetFont('Arial','B',6);
			$pdf->Cell(44,$hl,convertirc(_('Famille d\'actes')),1,0,'C',true);
			$pdf->Cell(13,$hl,convertirc(_("Nombre")),1,0,'C',true);
			$pdf->Cell(14,$hl,convertirc(_("Montant net	")),1,0,'C',true);
			$pdf->Cell(13,$hl,convertirc(_("Coût moyen")),1,0,'C',true);
			$pdf->Cell(10,$hl,convertirc(_("Taux %")),1,0,'C',true);

			$pdf->SetX(106);
			$pdf->SetFillColor(0,100,108);
			$pdf->SetTextColor(255,255,255);

			$pdf->Cell(44,$hl,convertirc(_('Famille d\'actes')),1,0,'C',true);
			$pdf->Cell(13,$hl,convertirc(_("Nombre")),1,0,'C',true);
			$pdf->Cell(14,$hl,convertirc(_("Montant net	")),1,0,'C',true);
			$pdf->Cell(13,$hl,convertirc(_("Coût moyen")),1,0,'C',true);
			$pdf->Cell(10,$hl,convertirc(_("Taux %")),1,1,'C',true);
			$pdf->SetTextColor(0,0,0);

			$pdf->SetFont('Arial','',6);

			$total_popActive = 0;
			$total_popTraite = 0;
			
			$total_quantite		= 0;
			$total_taux =0;
			$total_montantReclame = 0;
			$total_montantNonRembourse = 0;
			$total_montantRembourse = 0;
			$total_coutMoyen = 0;
			$total_popActiveA = 0;
			$total_popTraiteA = 0;
			$total_montantReclameA = 0;
			$total_montantNonRembourseA = 0;
			$total_montantRembourseA = 0;
			$total_coutMoyenA = 0;
			$total_tauxA =0;
			$total_quantiteA = 0;

			foreach ($depensesFamillesA as $depA)
			{


				$pdf->Cell(44,$hl,convertirc($depA['libelle']),1,0,'L',false);
				$pdf->Cell(13,$hl,convertirc($depA['Quantite']),1,0,'C',false);
				$pdf->Cell(14,$hl,convertirc(format_N($depA['MontantRembourse'])),1,0,'C',false);
				$pdf->Cell(13,$hl,convertirc(format_N($depA['Coutmoyen'])),1,0,'C',false);
				$pdf->Cell(10,$hl,convertirc(($depA['Taux'])),1,1,'C',false);


				$total_quantiteA			= $total_quantiteA + $depA['Quantite'];
				$total_montantRembourseA 	= $total_montantRembourseA + $depA['MontantRembourse'];
				$total_coutMoyenA 			= $total_montantRembourseA / $total_quantiteA;
				$total_tauxA 	= $total_tauxA + $depA['Taux'];
				
			}	
			$pdf->SetFont('Arial','B',6);
			$pdf->SetFillColor(255,250,205);

			$pdf->Cell(44,$hl,convertirc("TOTAL GENERAL"),"1",0,'C',true);
			$pdf->Cell(13,$hl,format_N($total_quantiteA),1,0,'C',true);
			$pdf->Cell(14,$hl,format_N($total_montantRembourseA),1,0,'C',true);
			$pdf->Cell(13,$hl,format_N($total_coutMoyenA),1,0,'C',true);
			$pdf->Cell(10,$hl,format_N(100),1,0,'C',true);
			$pdf->SetY(89);
			if ($p_id!=null){
				$pdf->SetY(89);
				}else{
					$pdf->SetY(65);
				}
			foreach ($depensesFamillesB as $dep)
			{
				
					$pdf->SetX(106);

				$pdf->Cell(44,$hl,convertirc($dep['libelle']),1,0,'L',false);
				$pdf->Cell(13,$hl,convertirc($dep['Quantite']),1,0,'C',false);
				$pdf->Cell(14,$hl,convertirc(format_N($dep['MontantRembourse'])),1,0,'C',false);
				$pdf->Cell(13,$hl,convertirc(format_N($dep['Coutmoyen'])),1,0,'C',false);
				$pdf->Cell(10,$hl,convertirc($dep['Taux']),1,1,'C',false);


				$total_quantite			= $total_quantite + $dep['Quantite'];
				$total_montantRembourse 	= $total_montantRembourse + $dep['MontantRembourse'];
				$total_coutMoyen 			= $total_montantRembourse / $total_quantite;
				$total_taux 	= $total_taux + $dep['Taux'];
					
			}

			$pdf->SetX(106);
			$pdf->SetFont('Arial','B',6);
			$pdf->SetFillColor(0,100,108);
			$pdf->SetTextColor(255,255,255);
			$pdf->Cell(44,$hl,convertirc("TOTAL GENERAL"),"1",0,'C',true);
			$pdf->Cell(13,$hl,format_N($total_quantite),1,0,'C',true);
			$pdf->Cell(14,$hl,format_N($total_montantRembourse),1,0,'C',true);
			$pdf->Cell(13,$hl,format_N($total_coutMoyen),1,0,'C',true);
			$pdf->Cell(10,$hl,format_N(100),1,1,'C',true);	
			$pdf->SetTextColor(0,0,0);

			$pdf->SetFont('Arial','BU',10);

			$pdf->SetY(175);
			$pdf->SetX(50);
			$pdf->Cell(120,8,convertirc(_('Comparaison des dépenses de l\'année n-1  et l\'année n ')),1,1,'C',false);


			$chartX=15;
			$chartY=175;

			//dimension
			$chartWidth=180;
			$chartHeight=100;

			//padding
			$chartTopPadding=12;
			$chartLeftPadding=20;
			$chartBottomPadding=10;
			$chartRightPadding=5;

			//chart box
			$chartBoxX=$chartX+$chartLeftPadding;
			$chartBoxY=$chartY+$chartTopPadding;
			$chartBoxWidth=$chartWidth-$chartLeftPadding-$chartRightPadding;
			$chartBoxHeight=$chartHeight-$chartBottomPadding-$chartTopPadding;

			//bar width
			$barWidth=5;
			$barWidth1=5;
			$valeur0=0;
			$valeur1=0;
			$valeur2=0;
			$valeur3=0;
			$valeur4=0;
			$valeur5=0;
			$valeur6=0;
			$valeur7=0;
			$valeur8=0;
			$valeur9=0;
			$value=0;
			$v=0;
			$valeur0A=0;
			$valeur1A=0;
			$valeur2A=0;
			$valeur3A=0;
			$valeur4A=0;
			$valeur5A=0;
			$valeur6A=0;
			$valeur7A=0;
			$valeur8A=0;
			$valeur9A=0;

			$value1=0;
			$v=0;
			$valeurs=array();
			$valeurs1=array();
			foreach($depensesFamillesA as $depensesFamillesA['codeGarantie'] => $value1)
			{
				array_push($valeurs1,$value1['Taux']);

				foreach($valeurs1 as $key =>$valeurA)
				{	
				

				if ($value1['codeGarantie'] == 'AUX') {
					$valeur1A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'BIO') {
					$valeur2A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'CON') {
					$valeur3A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'DEN') {
					$valeur4A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'EXA') {
					$valeur5A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'HOS') {
					$valeur6A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'IMA') {
					$valeur7A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'MAT') {
					$valeur8A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'OPT') {
					$valeur9A = $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'PHA') {
					$valeur10A =  $value1['Taux'];
					
				}
				$data1=Array(
					'AUX'=>[
						'color'=>[255,250,205],
						'value'=>$valeur1A],
					'BIO'=>[
						'color'=>[255,250,205],
						'value'=>$valeur2A],
					'CON'=>[
						'color'=>[255,250,205],
						'value'=>$valeur3A],
					'DEN'=>[
						'color'=>[255,250,205],
						'value'=>$valeur4A],
					'EXA'=>[
						'color'=>[255,250,205],
						'value'=>$valeur5A],
					'HOS'=>[
						'color'=>[255,250,205],
						'value'=>$valeur6A],
					'IMA'=>[
						'color'=>[255,250,205],
						'value'=>$valeur7A],
					'MAT'=>[
						'color'=>[255,250,205],
						'value'=>$valeur8A],
					'OPT'=>[
						'color'=>[255,250,205],
						'value'=>$valeur9A],
					'PHA'=>[
						'color'=>[255,250,205],
						'value'=>$valeur10A]	
					);
				}	
			}
			foreach($depensesFamillesB as $depensesFamillesB['codeGarantie'] => $value)
			{
				array_push($valeurs,$value['Taux']);

				foreach($valeurs as $key =>$valeur)
				{	
				

				if ($value['codeGarantie'] == 'AUX') {
					$valeur1 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'BIO') {
					$valeur2 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'CON') {
					$valeur3 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'DEN') {
					$valeur4 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'EXA') {
					$valeur5 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'HOS') {
					$valeur6 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'IMA') {
					$valeur7 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'MAT') {
					$valeur8 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'OPT') {
					$valeur9 = $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'PHA') {
					$valeur10 =  $value['Taux'];
					
				}
				$data=Array(
					'AUX'=>[
						'color'=>[0,100,108],
						'value'=>$valeur1],
					'BIO'=>[
						'color'=>[0,100,108],
						'value'=>$valeur2],
					'CON'=>[
						'color'=>[0,100,108],
						'value'=>$valeur3],
					'DEN'=>[
						'color'=>[0,100,108],
						'value'=>$valeur4],
					'EXA'=>[
						'color'=>[0,100,108],
						'value'=>$valeur5],
					'HOS'=>[
						'color'=>[0,100,108],
						'value'=>$valeur6],
					'IMA'=>[
						'color'=>[0,100,108],
						'value'=>$valeur7],
					'MAT'=>[
						'color'=>[0,100,108],
						'value'=>$valeur8],
					'OPT'=>[
						'color'=>[0,100,108],
						'value'=>$valeur9],
					'PHA'=>[
						'color'=>[0,100,108],
						'value'=>$valeur10]	
					);
				}	
			}

			//$dataMax
			$dataMax1=0;
			foreach($data1 as $item1)
			{
				if($item1['value']>$dataMax1)
				$dataMax1=$item1['value'];
			}
			//data step
			if($dataMax1>200 and $dataMax1<600)
			{
				
				$dataStep1=20;
			}
			if($dataMax1<200){
				$dataStep1=10;
			}
			if($dataMax1>1000){
				
				$dataStep1=100;
			}
			$dataMax=0;
			foreach($data as $item)
			{
				if($item['value']>$dataMax)
				$dataMax=$item['value'];
			}
			//data step
			if($dataMax>200 and $dataMax<600)
			{
				
				$dataStep=20;
			}
			if($dataMax<200){
				$dataStep=10;
			}
			if($dataMax>1000){
				
				$dataStep=100;
			}
			//set font, line width and color
			$pdf->SetFont('Arial','',8);
			$pdf->SetLineWidth(0.1);
			$pdf->SetDrawColor(0);

			//chart boundary
			$pdf->Rect($chartX,$chartY,$chartWidth,$chartHeight);

			//vertical axis line
			$pdf->Line(
				$chartBoxX ,
				$chartBoxY , 
				$chartBoxX , 
				($chartBoxY+$chartBoxHeight)
				);
			//horizontal axis line
			$pdf->Line(
				$chartBoxX-2 , 
				($chartBoxY+$chartBoxHeight) , 
				$chartBoxX+($chartBoxWidth) , 
				($chartBoxY+$chartBoxHeight)
				);

			///vertical axis
			//calculate chart's y axis scale unit
			$yAxisUnits=$chartBoxHeight/$dataMax;
			$yAxisUnits1=$chartBoxHeight/$dataMax1;
			//draw the vertical (y) axis labels
			for($i=0 ; $i<=$dataMax1 ; $i+=$dataStep1)
			{
				//y position
				$yAxisPos1=$chartBoxY+($yAxisUnits1*$i);
				//draw y axis line
				$pdf->Line(
					$chartBoxX-2 ,
					$yAxisPos1 ,
					$chartBoxX ,
					$yAxisPos1
				);
				//set cell position for y axis labels
				$pdf->SetTextColor(255,250,205);
				$pdf->SetXY($chartBoxX-$chartLeftPadding , $yAxisPos1-2);
				//$pdf->Cell($chartLeftPadding-4 , 5 , $dataMax-$i , 1);---------------
				$pdf->Cell($chartLeftPadding-4 , 5 , $dataMax1-$i, 0 , 0 , 'L');
			}
			for($i=0 ; $i<=$dataMax ; $i+=$dataStep)
			{
				//y position
				$yAxisPos=$chartBoxY+($yAxisUnits*$i);
				//draw y axis line
				$pdf->Line(
					$chartBoxX-2 ,
					$yAxisPos ,
					$chartBoxX ,
					$yAxisPos
				);
				//set cell position for y axis labels
				$pdf->SetXY($chartBoxX-$chartLeftPadding , $yAxisPos-2);
				//$pdf->Cell($chartLeftPadding-4 , 5 , $dataMax-$i , 1);---------------
				$pdf->SetTextColor(0,100,108);
				$pdf->Cell($chartLeftPadding-2 , 5 , $dataMax-$i, 0 , 0 , 'R');
				$pdf->SetTextColor(0);

			}

			///horizontal axis
			//set cells position
			$pdf->SetXY($chartBoxX , $chartBoxY+$chartBoxHeight);

			//cell's width
			$xLabelWidth=$chartBoxWidth / count($data);

			//$pdf->Cell($xLabelWidth , 5 , $itemName , 1 , 0 , 'C');-------------
			//loop horizontal axis and draw the bar
			$barXPos1=0;
			foreach($data1 as $itemName1=>$item1)
			{
				//print the label
				//$pdf->Cell($xLabelWidth , 5 , $itemName , 1 , 0 , 'C');--------------
				//$pdf->Cell($xLabelWidth , 5 , $itemName , 0 , 0 , 'C');
				
				///drawing the bar
				//bar color
				$pdf->SetFillColor($item1['color'][0],$item1['color'][1],$item1['color'][2]);
				//bar height
				$barHeight=$yAxisUnits1*$item1['value'];
				//bar x position
				$barX1=($xLabelWidth/2)+($xLabelWidth*$barXPos1);
				$barX1=$barX1-($barWidth/2);
				$barX1=$barX1+$chartBoxX;
				//bar y position
				$barY1=$chartBoxHeight-$barHeight;
				$barY1=$barY1+$chartBoxY;
				//draw the bar
				$pdf->Rect($barX1,$barY1,$barWidth,$barHeight,'DF');
				//increase x position (next series)
				$barXPos1++;
			}
			$barXPos=0;
			//highlight_string("<?php\n\$datas =\n" . var_export($data1  , true) . ";\n>");
			foreach($data as $itemName=>$item)
			{
				//print the label
				//$pdf->Cell($xLabelWidth , 5 , $itemName , 1 , 0 , 'C');--------------
				$pdf->Cell($xLabelWidth , 5 , $itemName , 0 , 0 , 'C');
				
				///drawing the bar
				//bar color
				$pdf->SetFillColor($item['color'][0],$item['color'][1],$item['color'][2]);
				//bar height
				$barHeight=$yAxisUnits*$item['value'];
				//bar x position
				$barX=($xLabelWidth/2)+($xLabelWidth*$barXPos);
				$barX=$barX-($barWidth/2);
				$barX=$barX+$chartBoxX+5;
				//bar y position
				$barY=$chartBoxHeight-$barHeight;
				$barY=$barY+$chartBoxY;
				//draw the bar
				$pdf->Rect($barX,$barY,$barWidth,$barHeight,'DF');
				//increase x position (next series)
				$barXPos++;
			}
			//axis labels
			$pdf->SetFont('Arial','B',9);
			$pdf->SetXY($chartX,$chartY);
			$pdf->Cell(30,10,"Taux",0);
			$pdf->SetXY(($chartWidth/2)-50+$chartX,$chartY+$chartHeight-($chartBottomPadding/2));
			$pdf->SetXY(($chartWidth/2)-50+$chartX,$chartY+$chartHeight-($chartBottomPadding/2));

		$pdf->AddPage('L'); //DEBUT FT 13
			$p_factures  	= $this->detailsp->depensesparfamilledactesetparprestataires($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut, $p_datefin,$p_limite);
			$pdf->SetMargins(10, 10, 10) ;
			$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit4.jpg', 0, 0, 297); 
			$pdf->SetY(15);
			$pdf->SetFont('Helvetica', 'B', 18);
			$pdf->SetTextColor( 65, 185, 80 );
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->MultiCell(150, 8, convertirc(_("DÉPENSES PAR FAMILLE D'ACTES ET PAR PRESTATAIRES")), 0, 'L' );

			$pdf->Ln(8);
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->SetTextColor(0);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
			$pdf->Ln(10);

			if ($p_id!=null){

				$pdf->SetFont('Helvetica', 'B', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);
		
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);
		
				//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);
		
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
				//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
			}else{
				$pdf->Ln(10);
				$pdf->SetFont('Helvetica', 'BUI', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->SetFont('Helvetica', 'BI', 11);
				$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}
			$pdf->Ln(10);

			
			$pdf->Ln(4);
			$pdf->SetX(65);
			$pdf->Cell(170,6,convertirc(_('DÉPENSES SUPERIEURES A').' : '.format_N($depenses).' '.$_SESSION['devise_C']),1,1,'C',false);

			$pdf->Ln(2);
			$hl=7;
			$pdf->SetFont('Arial','B',6);

			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(62,$hl,convertirc(_("Prestataire")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_('Consultation')),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Imagerie")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Biologie")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Dentisterie")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Optique")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Hospitalisation")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Pharmacie")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Maternité")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("# Autres.")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("# Aux Med.")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Assistance")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("# Trans Med.")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("# Bilan.")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Totaux")),1,1,'C',true);

			$total_CONSULTATION = 
			$total_IMAGERIE =
			$total_BIOLOGIE = 
			$total_DENTISTERIE = 
			$total_OPTIQUE = 
			$total_HOSPITALISATION = 
			$total_PHARMACIE = 
			$total_MATERNITE = 
			$total_AUTRES_EXAMENS = 
			$total_AUXILIAIRES_MEDICAUX =
			$total_ASSISTANCE =
			$total_TRANSPORT_MEDICALISE = 
			$total_BILAN_DE_SANTE = 
			$total_TOTAUX = 0;
			$pdf->SetFont('Arial','',6);
			foreach ($p_factures as $dep)
			{
				$pdf->Cell(62,$hl,convertirc(substr($dep['Prestataire'],1,47)),1,0,'L',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['CONSULTATION'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['IMAGERIE'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['BIOLOGIE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['DENTISTERIE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['OPTIQUE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['HOSPITALISATION'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['PHARMACIE'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['MATERNITE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['AUTRES EXAMENS'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['AUXILIAIRES MEDICAUX'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['ASSISTANCE'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['TRANSPORT MEDICALISE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['BILAN DE SANTE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['TOTAUX'])),1,1,'C',false);

				$total_CONSULTATION = $total_CONSULTATION + $dep['CONSULTATION'];
				$total_IMAGERIE = $total_IMAGERIE + $dep['IMAGERIE'];
				$total_BIOLOGIE = $total_BIOLOGIE + $dep['BIOLOGIE'];
				$total_DENTISTERIE = $total_DENTISTERIE + $dep['DENTISTERIE'];
				$total_OPTIQUE = $total_OPTIQUE + $dep['OPTIQUE'];
				$total_HOSPITALISATION = $total_HOSPITALISATION + $dep['HOSPITALISATION'];
				$total_PHARMACIE = $total_PHARMACIE + $dep['PHARMACIE'];
				$total_MATERNITE = $total_MATERNITE + $dep['MATERNITE'];
				$total_AUTRES_EXAMENS = $total_AUTRES_EXAMENS + $dep['AUTRES EXAMENS'];
				$total_AUXILIAIRES_MEDICAUX = $total_AUXILIAIRES_MEDICAUX + $dep['AUXILIAIRES MEDICAUX'];
				$total_ASSISTANCE = $total_ASSISTANCE + $dep['ASSISTANCE'];
				$total_TRANSPORT_MEDICALISE = $total_TRANSPORT_MEDICALISE + $dep['TRANSPORT MEDICALISE'];
				$total_BILAN_DE_SANTE = $total_BILAN_DE_SANTE + $dep['BILAN DE SANTE'];
				$total_TOTAUX = $total_TOTAUX + $dep['TOTAUX'];
			}	
			$pdf->SetFont('Arial','B',8);
			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(62,$hl,convertirc("TOTAL GENERAL"),"1",0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_CONSULTATION),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_IMAGERIE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_BIOLOGIE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_DENTISTERIE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_OPTIQUE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_HOSPITALISATION),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_PHARMACIE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_MATERNITE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_AUTRES_EXAMENS),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_AUXILIAIRES_MEDICAUX),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_ASSISTANCE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_TRANSPORT_MEDICALISE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_BILAN_DE_SANTE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_TOTAUX),1,1,'C',true);

			$pdf->Cell(45,$hl,convertirc(_("Légende")),0,0,'L',false);
			$pdf->Ln(8);
			$pdf->Cell(45,$hl,convertirc(_("Autres. = Autres Examens")),0,0,'L',false);
			$pdf->Ln(5);
			$pdf->Cell(45,$hl,convertirc(_("Aux Med. = Auxiliaire Médicaux")),0,0,'L',false);
			$pdf->Ln(5);
			$pdf->Cell(45,$hl,convertirc(_("Trans Med. = Transport Medicalisé")),0,0,'L',false);
			$pdf->Ln(5);
			$pdf->Cell(45,$hl,convertirc(_("Bilan. = Bilan de santé")),0,0,'L',false);
			$pdf->Ln(2);

		$pdf->AddPage();

		$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit9.jpg', 0, 0, 210); 

		$fichier="Temp/TMP_KIT_STATISTIQUES_FAMILLE"."_".$famille.".pdf";
		if(is_file($fichier)){
			$fichier="Temp/TMP_KIT_STATISTIQUES_FAMILLE"."_".$famille."_".uniqid().".pdf";
		}
		$pdf->Output($fichier,"F");	
		return($fichier);
	}

	function statsparticulier($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin,$depenses,$chargeravantapres ){
	

		$entete = $this->detailsp->detailrapportspperiodepdfentete_new($p_id, $p_datedebut,	$p_datefin);

		$infocollege = $this->college->getCollegepoliceId($idCollege);

		$tableaudajustements = $this->detailsp->gettableauAjustementGarant($codeGcAssureur);


		$infosDuGarant     = $this->police_societe->getInfosGarant($codeGcAssureur);
			
	
		$pdf = new FPDF1();
		$pdf->AliasNbPages();
		
		$pdf->AddPage(); // debut page de garde

				$pdf->SetMargins(10, 10, 10) ;
				$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit1.jpg', 0, 0, 210);


				$pdf->SetY(75);

				$pdf->SetFont('Helvetica', 'B', 36);
				$pdf->SetTextColor( 37, 36, 97 );
				$pdf->Cell(0, 6, convertirc(_('STATISTIQUES MALADIE')), 0, 1, 'C', false);


				$pdf->SetY(240);

				$pdf->SetFont('Times', 'BI', 13);
				$pdf->SetTextColor( 0, 0, 0 );
				$pdf->Cell(0, 6, convertirc(_('PÉRIODE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'C', false);
				$pdf->Ln(10);	 
				$pdf->SetTextColor( 37, 36, 97 );

				if ($p_id!=null){

				$pdf->SetFont('Helvetica', 'BI', 12);
				$pdf->Cell(75, 5, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(22, 5, convertirc(_('GARANT :')), 0, 0, 'L', false);
				$pdf->MultiCell(115, 5, convertirc(_($entete['garant'])), 0, 'L');
				$pdf->Ln(2);	 
				$pdf->Cell(75, 5, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(38, 5, convertirc(_('SOUSCRIPTEUR :')), 0, 0, 'L', false);
				$pdf->MultiCell(115, 5, convertirc(_($entete['souscripteur'])), 0, 'L');
				$pdf->Ln(2);
				$pdf->Cell(75, 5, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(21, 5, convertirc(_('POLICE :')), 0, 0, 'L', false);
				$pdf->MultiCell(115, 5, convertirc(_($entete['libellePolice'])), 0, 'L');
				}else{

				$pdf->SetFont('Times', 'BI', 16);
				$pdf->Cell(100, 5, convertirc(_('GARANT :')), 0, 0, 'L', false);
				$pdf->SetFont('Times', 'BI', 14);

				$pdf->MultiCell(115, 5, convertirc(_($infosDuGarant['libelle'])), 0, 'L' );
				$pdf->Ln(40);
				}
		$pdf->AddPage(); // SOMMAIRE

				$pdf->SetMargins(10, 10, 10) ;
				$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit2.jpg', 0, 0, 210); 

				
				$pdf->Ln(10);

				$pdf->SetTextColor(255, 255, 255); 
				$pdf->SetFont('Arial', 'B', 24);
				$pdf->Cell(34,12,convertirc(''),0,0,'C',false);		
				$pdf->Cell(100,12,convertirc(_("SOMMAIRE")),0,0,'C',false);		

				$pdf->Ln(20);
				$pdf->SetFont('Helvetica', 'B', 9);
				$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
				$pdf->Cell(34,0,convertirc(_("DONNÉES ÉLEMENTAIRES")),0,0,'L',false);	
				$pdf->Cell(140,0,convertirc(''),0,0,'L',false);		
				
				$pdf->Ln(8);
				$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
				$pdf->Cell(34,0,convertirc(_("MOUVEMENTS D'EFFECTIFS PAR COLLEGE")),0,0,'L',false);	
				$pdf->Cell(140,0,convertirc(''),0,0,'L',false);	
				
				$pdf->Ln(8);
				$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
				$pdf->Cell(34,0,convertirc(_("DÉPENSES PAR FAMILLES ET PAR COLLEGE")),0,0,'L',false);	
				$pdf->Cell(140,0,convertirc(''),0,0,'L',false);	
				
				$pdf->Ln(8);
				$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
				$pdf->Cell(34,0,convertirc(_("RÉCAPITULATIF DES DÉPENSES PAR STATUT DE BÉNÉFICIAIRES")),0,0,'L',false);	
				$pdf->Cell(140,0,convertirc(''),0,0,'L',false);	
				
				$pdf->Ln(8);
				$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
				$pdf->Cell(34,0,convertirc(_("ÉVOLUTION MENSUELLE DES DÉPENSES")),0,0,'L',false);	
				$pdf->Cell(140,0,convertirc(''),0,0,'L',false);	
				
				$pdf->Ln(8);
				$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
				$pdf->Cell(34,0,convertirc(_("RÉCAPITULATIF DES DÉPENSES PAR FAMILLE D’ACTES MÉDICAUX")),0,0,'L',false);	
				$pdf->Cell(140,0,convertirc(''),0,1,'L',false);	

				$pdf->Ln(8);
				$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
				$pdf->Cell(36,0,convertirc(_("COMPARATIF DES DÉPENSES DES ANNÉES N-1 ET N")),0,0,'L',false);	
				$pdf->Cell(140,0,convertirc(''),0,1,'L',false);	

				$pdf->Ln(8);
				$pdf->Cell(10,0,convertirc(''),0,0,'C',false);		
				$pdf->Cell(36,0,convertirc(_("DÉPENSES PAR FAMILLE D’ACTES ET PAR PRESTATAIRES")),0,0,'L',false);	
				$pdf->Cell(140,0,convertirc(''),0,0,'L',false);	
			
		$pdf->AddPage(); // 

		$pdf->Cell(0,8,convertirc(_("FICHE DE SUIVI")),0,1,'C',TRUE);	
		  
		$pdf->Ln(8);
		$h=5;
		$pdf->SetTextColor(0, 0, 0); 
		$pdf->SetFont('Times', 'BI', 9);
		$pdf->Cell(75,$h,convertirc(_("PERIODE")),1,0,'L',false);
		$pdf->Cell(115,$h,convertirc(dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])),1,1,'L',false);

		$beneficiaires = $this->detailsp->getficheSuivie1($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$agemoyens = $this->detailsp->getficheSuivie2($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$tranchesages = $this->detailsp->getficheSuivie3($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$topactes = $this->detailsp->getficheSuivie4($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$topprestataires = $this->detailsp->getficheSuivie5($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$topaffections = $this->detailsp->getficheSuivie6($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);
		$sinistrialites = $this->detailsp->getficheSuivie7($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin,$Chargement,$chargeravantapres);
		
		$nombreBeneficiaire = 0;
	
		  foreach($beneficiaires  as $keybenf=>$beneficiaire){
			if($keybenf == 0){
				$nombreTraiteA= $beneficiaire['Nombretraite'];
				$DepensesA= $beneficiaire['Depenses'];
				$taux_DepenseA= $beneficiaire['Taux_Depense'];
				$coutMoyenA= $beneficiaire['CoutMoyen'];
			}elseif($keybenf == 1){
				$nombreTraiteC= $beneficiaire['Nombretraite'];
				$DepensesC= $beneficiaire['Depenses'];
				$taux_DepenseC= $beneficiaire['Taux_Depense'];
				$coutMoyenC= $beneficiaire['CoutMoyen'];
			}
			elseif($keybenf == 2){
				$nombreTraiteE= $beneficiaire['Nombretraite'];
				$DepensesE= $beneficiaire['Depenses'];
				$taux_DepenseE= $beneficiaire['Taux_Depense'];
				$coutMoyenE= $beneficiaire['CoutMoyen'];
			}
			$nombreBeneficiaire = $nombreBeneficiaire+ $beneficiaire['Nombre'];
		  }
		  $coutMoyens = max(array($coutMoyenA,$coutMoyenC,$coutMoyenE));
		    if( $coutMoyens=$coutMoyenA){
			$libelle = "Adhérent(e)s";
			}elseif( $coutMoyens== $coutMoyenC){
				$libelle = "Conjoint(e)s";
			}
			elseif( $coutMoyens == $coutMoyenE){
				$libelle = "Enfants";
			}

		  foreach($agemoyens  as $keyage=>$agemoyen){
			if($keyage == 0){
				$Age_MoyenA= $agemoyen['Age_Moyen'];
			}elseif($keyage == 1){
				$Age_MoyenC= $agemoyen['Age_Moyen'];
			}
			elseif($keyage == 3){
				$Age_MoyenE= $agemoyen['Age_Moyen'];
			}
		  }
		  foreach($tranchesages  as $keytranche=>$tranchesage){
			if($keytranche == 0){
				$Depenses1= $tranchesage['Depense_Tranche'];
				$taux_Depense1= $tranchesage['Taux_Depense'];
				$coutMoyen1= $beneficiaire['CoutMoyen'];

			}elseif($keytranche == 1){
				$Depenses2= $tranchesage['Depense_Tranche'];
				$taux_Depense2= $tranchesage['Taux_Depense'];
				$coutMoyen2= $beneficiaire['CoutMoyen'];			
			}
			elseif($keytranche == 2){
				$Depenses3= $tranchesage['Depense_Tranche'];
				$taux_Depense3= $tranchesage['Taux_Depense'];
				$coutMoyen3= $beneficiaire['CoutMoyen'];
			}
			elseif($keytranche == 3){
				$Depenses4= $tranchesage['Depense_Tranche'];
				$taux_Depense4= $tranchesage['Taux_Depense'];
				$coutMoyen4= $beneficiaire['CoutMoyen'];
			}
			elseif($keytranche == 4){
				$Depenses4= $tranchesage['Depense_Tranche'];
				$taux_Depense4= $tranchesage['Taux_Depense'];
				$coutMoyen4= $beneficiaire['CoutMoyen'];
			}
		  }
		 
		$pdf->Cell(75,$h,convertirc(_("BENEFICIAIRES")),1,0,'L',false);
		$pdf->Cell(115,$h,convertirc(format_N($nombreBeneficiaire)),1,1,'L',false);

		$pdf->Cell(75,$h,convertirc(''),"LTR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Adhérent(e)s : ".format_N($nombreTraiteA))),"LTR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(_("BENEFICIAIRES TRAITES")),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Conjoint(e)s : ".format_N($nombreTraiteC))),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LBR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Enfants : ".format_N($nombreTraiteE))),"LBR",1,'L',false);

		$pdf->Cell(75,$h,convertirc(''),"LTR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Adhérent(e)s : ".format_N($Age_MoyenA)." ans")),"LTR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(_("AGE MOYEN DE LA POPULATION")),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Conjoint(e)s : ".format_N($Age_MoyenC)." ans")),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LBR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Enfants : ".format_N($Age_MoyenE)." ans")),"LBR",1,'L',false);

		$pdf->Cell(75,$h,convertirc(''),"LTR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Adhérent(e)s : ".format_N($DepensesA)." ".$_SESSION['devise_C']." soit ".$taux_DepenseA." %")),"LTR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(_("SINISTRIALITE PAR STATUT DE BENEFICIAIRE")),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Conjoint(e)s : ".format_N($DepensesC)." ".$_SESSION['devise_C']." soit ".$taux_DepenseC." %")),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("Enfants : ".format_N($DepensesE)." ".$_SESSION['devise_C']." soit ".$taux_DepenseE." %")),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("On observe un coût moyen plus élevé chez les ".$libelle." ".format_N($coutMoyens)." ".$_SESSION['devise_C'])),"LR",1,'L',false);
		
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(''),"LR",1,'L',false);
		
		$keytop=0;
		foreach($topactes  as $keytop=>$topacte){
			if($keytop == 0){
				$pdf->Cell(75,$h,convertirc(_("TOP DES ACTES")),"LTR",0,'L',false);
				$pdf->Cell(115,$h,convertirc(_($topacte['libelle']." : "." ".format_N($topacte['MontantRembourse'])." ".$_SESSION['devise_C']." soit ".$topacte['Taux']." %")),"LTR",1,'L',false);
			}else{
				$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
				$pdf->Cell(115,$h,convertirc(_($topacte['libelle']." : "." ".format_N($topacte['MontantRembourse'])." ".$_SESSION['devise_C']." soit ".$topacte['Taux']." %")),"LR",1,'L',false);
			}

			}
		
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(''),"LR",1,'L',false);
		  foreach($topprestataires  as $keytop1=>$topprestataire){
			if($keytop1 == 0){
				$pdf->Cell(75,$h,convertirc(_("TOP DES PRESTATAIRES")),"LTR",0,'L',false);
			$pdf->Cell(115,$h,convertirc(_($topprestataire['Prestataire']." :"." ".format_N($topprestataire['montantApayer'])." ".$_SESSION['devise_C'])),"LTR",1,'L',false);
			}else{
				$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
				$pdf->Cell(115,$h,convertirc(_($topprestataire['Prestataire'].": "." ".format_N($topprestataire['montantApayer'])." ".$_SESSION['devise_C'])),"LR",1,'L',false);
			}
	
		  }
		
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(''),"LR",1,'L',false);
		  foreach($topaffections  as $keytop2=>$topaffection){
			if($keytop2 == 0){
				$pdf->Cell(75,$h,convertirc(_("TOP DES AFFECTIONS")),"LTR",0,'L',false);
				$pdf->Cell(115,$h,convertirc(_($topaffection['affection']." : "." ".format_N($topaffection['apresDecompte'])." ".$_SESSION['devise_C']." soit ".$topaffection['Taux']." %")),"LTR",1,'L',false);
			}else{
				$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
				$pdf->Cell(115,$h,convertirc(_($topaffection['affection']."  : "." ".format_N($topaffection['apresDecompte'])." ".$_SESSION['devise_C']." soit ".$topaffection['Taux']." %")),"LR",1,'L',false);
			}
	
		  }
		  $pdf->Cell(75,$h,convertirc(''),"LTR",0,'L',false);
		  $pdf->Cell(115,$h,convertirc(''),"LTR",1,'L',false);
		
		$pdf->Cell(75,$h,convertirc(_("SINISTRIALITÉ")),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("PROVISION MOYENNE : ".format_N($sinistrialites['PROVISION'])." ".$_SESSION['devise_C'])),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("SINISTRIALITÉ MOYENNE : ".format_N($sinistrialites['SINISTRES'])." ".$_SESSION['devise_C'])),"LR",1,'L',false);
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(_("ÉCART : ".format_N($sinistrialites['ECART'])." ".$_SESSION['devise_C'])),"LR",1,'L',false);


		// tableau d'ajustement 
	
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(''),"LR",1,'L',false);
		

		foreach($tableaudajustements  as $keytop3=>$tableaudajustement){
			if($tableaudajustement['codeGcAssureur'] ==$entete['codeGcAssureur'] ){
				$ajustement = $tableaudajustement['tauxAjustement']>0.00 ? '  Majoration  ' : '  Minoration  ';
				
				if($tableaudajustement['spMin']<= $sinistrialites['RAPPRSP'] && $tableaudajustement['spMax']>= $sinistrialites['RAPPRSP'] ){
					$pdf->SetFont('Times', 'BI', 11);
					$pdf->SetTextColor(255, 0, 0);
					$conclusion =  $ajustement=="  Majoration  " ? "La tendance est ascendante par conséquent la police sera majorée au renouvelement." : "La tendance est constante par conséquent la police ne sera pas majorée au renouvelement." ;

				}else{
					$pdf->SetFont('Times', 'BI', 9);
					$pdf->SetTextColor(0, 0, 0);
				}
				
				if($keytop3 == 0){
					$pdf->Cell(75,$h,convertirc(_("Tableau d'ajustement")),"LTR",0,'L',false);
					$pdf->Cell(115,$h,convertirc(_( "de ".$tableaudajustement['spMin']." à ".$tableaudajustement['spMax'].$ajustement.$tableaudajustement['tauxAjustement'] )),"LTR",1,'L',false);
				}else{
					$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
					$pdf->Cell(115,$h,convertirc(_("de ".$tableaudajustement['spMin']." à ".$tableaudajustement['spMax'].$ajustement.$tableaudajustement['tauxAjustement'] )),"LR",1,'L',false);
				}
			}
		}
		$pdf->Cell(75,$h,convertirc(''),"LR",0,'L',false);
		$pdf->Cell(115,$h,convertirc(''),"LR",1,'L',false);
		
		$pdf->Cell(190,$h,convertirc(_($conclusion)),"LBR",1,'L',false);


		$pdf->AddPage(); // DEBUT FT1

		$statutsfts = $this->detailsp->donneelementaire_rp($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin);

		$primeSinistrefts = $this->detailsp->donneelementaire_rp2_1($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin,$Chargement,$chargeravantapres );
  

		$pdf->SetMargins(10, 10, 10) ;
		$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit3.jpg', 0, 0, 210); 
		$pdf->SetY(40);
		$pdf->SetFont('Helvetica', 'B', 18);
		$pdf->SetTextColor( 65, 185, 80 );
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(50, 6, convertirc(_('DONNÉES ÉLÉMENTAIRES')), 0, 1, 'L', false);
	
		$pdf->Ln(8);
		$pdf->SetFont('Helvetica', 'B', 11);
		$pdf->SetTextColor(0);
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
		$pdf->Ln(8);

		if ($p_id!=null){

		  $pdf->SetFont('Helvetica', 'B', 11);
		  $pdf->Cell(10, 6, convertirc(''), 0, 0, 'L', false);
		  $pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
		  $pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);
	
		  $pdf->Cell(10, 6, convertirc(''), 0, 0, 'L', false);
		  $pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
		  $pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);
	
		  //$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
		  $pdf->Cell(10, 6, convertirc(''), 0, 0, 'L', false);
		  $pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
		  $pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);
	
		  $pdf->Cell(10, 6, convertirc(''), 0, 0, 'L', false);
		  $pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
		  $pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
		  //   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
		}else{
		  $pdf->Ln(10);
		  $pdf->SetFont('Helvetica', 'BUI', 11);
		  $pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		  $pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
		  $pdf->SetFont('Helvetica', 'BI', 11);
		  $pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
		}
		$pdf->SetX(15);
		$pdf->SetFont('Helvetica', 'BI', 11);
		$pdf->Cell(35, 6, convertirc(_('POPULATION')), 0, 0, 'L', false);
		$pdf->Cell(0, 6, convertirc(_(' : cf Tableau ci-dessous : ' )), 0, 1, 'L', false);
		//  $pdf->Cell(0, 6, convertirc(_("POPULATION").' : cf Tableau ci-dessous : '), 0, 1, 'L', false);
		  
		$pdf->Ln(10);

		$hl=6;
		$pdf->SetX(12);
		$pdf->SetFont('Arial', 'B', 8);
		$pdf->SetFillColor(143, 206, 143);
		$pdf->Cell(35, $hl, convertirc(_('Statut bénéficiaire')), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_("Nombre d'assurés sur la période")), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_("Bénéficiaires traités sur la période")), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_("% Bénéficiaires traités sur la période")), 1, 1, 'C', true);
		
		$pdf->SetFont('Arial', '', 9);

		$total_assure = 0;
		$total_traite = 0;
		$total_taux = 0;

		foreach ($statutsfts as $statutsf) {
			$pdf->SetX(12);
			$pdf->Cell(35, $hl, convertirc($statutsf['libelle']), 1, 0, 'L', false);
			$pdf->Cell(50, $hl, convertirc(format_N($statutsf['Nombre'])), 1, 0, 'C', false);
			$pdf->Cell(50, $hl, convertirc(format_N($statutsf['Nombretraite'])), 1, 0, 'C', false);
			$pdf->Cell(50, $hl, convertirc($statutsf['Taux_EffTraite']." %"), 1, 1, 'C', false);
			
			$total_assure = $total_assure + $statutsf['Nombre'];
			$total_traite = $total_traite + $statutsf['Nombretraite'];
			$total_taux   = $total_taux + $statutsf['Taux_EffTraite'];
		}
		$hl=8;
		$pdf->SetFont('Arial', 'B', 9);
		$pdf->SetFillColor(143, 206, 143);
		$pdf->SetX(12);
		$pdf->Cell(35, $hl, convertirc(_('TOTAL')), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_(format_N($total_assure))), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_(format_N($total_traite))), 1, 0, 'C', true);
		$pdf->Cell(50, $hl, convertirc(_(format_N($total_taux)." %")), 1, 1, 'C', true);

	   
		$pdf->Ln(15);

		$tp = 11;

		$ht = 6;

		
		$pdf->SetFont('Arial', 'BI', $tp);
		$pdf->SetTextColor( 65, 185, 80 );
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(190, $ht, convertirc("PRIMES ET SINISTRALITÉ DE LA POLICE "), 0, 1, 'C', false);
		$pdf->SetTextColor( 0, 0, 0 );
		foreach ($primeSinistrefts as $primeSinistreft) {

		}
		$pdf->SetFont('Helvetica', 'B', 11);

		$pdf->Ln(5);
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(100, $ht, convertirc(_("RAPPEL PRIME NETTE TOTALE :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['PRIMETOTALE']), 0, 1, 'L', false);
		
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(100, $ht, convertirc(_("PRIME NETTE DE LA PÉRIODE :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['PRIMENETTE']), 0, 1, 'L', false);
		
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(100, $ht, convertirc(_("CHARGEMENT DE LA PÉRIODE :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['CHARGEMENT']), 0, 1, 'L', false);
		
		$pdf->Ln(5);
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(100, $ht, convertirc(_("PROVISION POUR SINISTRE DE LA PÉRIODE :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['PROVISION']), 0, 1, 'L', false);
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(100, $ht, convertirc(_("SINISTRE DE LA PÉRIODE :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['SINISTRES']), 0, 1, 'L', false);
		
		$pdf->Ln(10);
		
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(120, $ht, convertirc(_("RÉSULTATS TECHNIQUES DE LA PÉRIODE (Rapport Sinistres/Primes) :")), 0, 1, 'L', false);
		if($chargeravantapres =="AVANT"){
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(125, $ht, convertirc(_("RAPPORT (SINISTRES/PRIME NETTE DE LA PÉRIODE) NET :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, number_format($primeSinistreft['RAPPRSP'], 2, '.', ','), 0, 1, 'L', false);
		
		}else{
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(110, $ht, convertirc(_("RAPPORT (SINISTRES/PROVISION) NET :")), 0, 0, 'L', false);
		  $pdf->Cell(40, $ht, number_format($primeSinistreft['RAPPRSP'], 2, '.', ','), 0, 1, 'L', false);
	  
		}
  
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(125, $ht, convertirc(_("EXCEDENT (ou DEFICIT (-)) :")), 0, 0, 'L', false);
		$pdf->Cell(40, $ht, format_N($primeSinistreft['ECART']), 0, 1, 'L', false);

		$pdf->AddPage('L'); // debut MOUVEMENTS D'EFFECTIFS PAR COLLEGE 
			
			$p_factures  	= $this->detailsp->mouvementeffectifcollege($p_garant, $p_id_clients, $p_id,  $p_id_college,$p_apporteur, $p_datedebut,  $p_datefin,$p_limite );
			$pdf->SetMargins(10, 10, 10) ;
			$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit7.jpg', 0, 0, 297); 
			$pdf->SetY(15);
			$pdf->SetFont('Helvetica', 'B', 18);
			$pdf->SetTextColor( 65, 185, 80 );
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->MultiCell(150, 8, convertirc(_("MOUVEMENTS D'EFFECTIFS PAR COLLEGE")), 0, 'L' );

			$pdf->Ln(8);
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->SetTextColor(0);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
			$pdf->Ln(10);

			if ($p_id!=null){

				$pdf->SetFont('Helvetica', 'B', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);
		
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);
		
				//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);
		
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
				//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
			}else{
				$pdf->Ln(10);
				$pdf->SetFont('Helvetica', 'BUI', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->SetFont('Helvetica', 'BI', 11);
				$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}
			$pdf->Ln(10);


			$hl=7;
			$pdf->SetFont('Arial','',7);
			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(15,$hl,convertirc(_('idCollege')),1,0,'C',true);
			$pdf->Cell(60,$hl,convertirc(_("College")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Janvier")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Février")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Mars")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Avril")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Mai")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Juin")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Juillet")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Août")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Septembre")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Octobre")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Novembre")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Décembre")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Totaux")),1,1,'C',true);
			$total_JANVIER = 0;
			$total_FEVRIER = 0;
			$total_MARS = 0;
			$total_AVRIL = 0;
			$total_MAI = 0;
			$total_JUIN = 0;
			$total_JUILLET = 0;
			$total_AOUT = 0;
			$total_SEPTEMBRE = 0;
			$total_OCTOBRE = 0;
			$total_NOVEMBRE = 0;
			$total_DECEMBRE = 0;
			$total_TOTAUX = 0;
			
			foreach ($p_factures as $dep)
			{
				$taillelibelleCollege = strlen($dep['libelleCollege']); // compter le nombre de caractere de la chaine
				if($taillelibelleCollege>43) {
					$hl= 4;
					$text = wordwrap($dep['libelleCollege'], 45, "***", false); // insertion de marqueurs ***

					$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); //suppression du dernier espace dans la partie de texte restante
					
					$pdf->Cell(15,$hl,convertirc($dep['idCollege']),"LTR",0,'C',false);
					$pdf->Cell(60,$hl,convertirc($part1),"LTR",0,'L',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['JANVIER'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['FEVRIER'])),"LTR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['MARS'])),"LTR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['AVRIL'])),"LTR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['MAI'])),"LTR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['JUIN'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['JUILLET'])),"LTR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['AOUT'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['SEPTEMBRE'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['OCTOBRE'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['NOVEMBRE'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['DECEMBRE'])),"LTR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['TOTAUX'])),"LTR",1,'C',false);

					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(60,$hl,convertirc($part2),"LBR",0,'L',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(15,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",0,'C',false);
					$pdf->Cell(16,$hl,convertirc(""),"LBR",1,'C',false);
					
				}
				else{
					$pdf->Cell(15,$hl,convertirc($dep['idCollege']),1,0,'C',false);
					$pdf->Cell(60,$hl,convertirc($dep['libelleCollege']),1,0,'L',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['JANVIER'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['FEVRIER'])),1,0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['MARS'])),1,0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['AVRIL'])),1,0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['MAI'])),1,0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['JUIN'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['JUILLET'])),1,0,'C',false);
					$pdf->Cell(15,$hl,convertirc(format_N($dep['AOUT'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['SEPTEMBRE'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['OCTOBRE'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['NOVEMBRE'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['DECEMBRE'])),1,0,'C',false);
					$pdf->Cell(16,$hl,convertirc(format_N($dep['TOTAUX'])),1,1,'C',false);
				}
				
			
				$total_JANVIER = $total_JANVIER + $dep['JANVIER'];
				$total_FEVRIER = $total_FEVRIER + $dep['FEVRIER'];
				$total_MARS = $total_MARS + $dep['MARS'];
				$total_AVRIL = $total_AVRIL + $dep['AVRIL'];
				$total_MAI = $total_MAI + $dep['MAI'];
				$total_JUIN = $total_JUIN + $dep['JUIN'];
				$total_JUILLET = $total_JUILLET + $dep['JUILLET'];
				$total_AOUT = $total_AOUT + $dep['AOUT'];
				$total_SEPTEMBRE = $total_SEPTEMBRE + $dep['SEPTEMBRE'];
				$total_OCTOBRE = $total_OCTOBRE + $dep['OCTOBRE'];
				$total_NOVEMBRE = $total_NOVEMBRE + $dep['NOVEMBRE'];
				$total_DECEMBRE = $total_DECEMBRE + $dep['DECEMBRE'];
				$total_TOTAUX = $total_TOTAUX + $dep['TOTAUX'];
			}	
			$pdf->SetFont('Arial','B',8);
			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(75,$hl,convertirc("TOTAL GENERAL"),"1",0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_JANVIER),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_FEVRIER),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_MARS),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_AVRIL),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_MAI),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_JUIN),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_JUILLET),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_AOUT),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_SEPTEMBRE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_OCTOBRE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_NOVEMBRE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_DECEMBRE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_TOTAUX),1,1,'C',true);

			
			$pdf->Ln(5);
			
			$pdf->Cell(45,$hl,convertirc(_("Nombre de lignes: ").count($p_factures)),0,0,'L',false);
		$pdf->AddPage(); // debut etat des depenses par college
			
			$p_factures  	= $this->detailsp->get_depense_contrat_college_rp($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin);

		$pdf->SetMargins(10, 10, 10) ;
		$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit5.jpg', 0, 0, 210);
		
		$pdf->SetFont('Arial','B',13);

		$pdf->SetY(40);
		$pdf->SetFont('Helvetica', 'B', 18);
		$pdf->SetTextColor( 65, 185, 80 );
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->MultiCell(145, 8, convertirc(_("DÉPENSES PAR FAMILLES ET PAR COLLEGE")), 0, 'L' );

		$pdf->Ln(8);
		$pdf->SetFont('Helvetica', 'B', 11);
		$pdf->SetTextColor(0);
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
		$pdf->Ln(10);
			if ($p_id!=null){
		
					$pdf->SetFont('Helvetica', 'B', 11);
					$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
					$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
					$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);
			
					$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
					$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
					$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);
			
					//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
					$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
					$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
					$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);
			
					$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
					$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
					$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
					//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
				}else{
					$pdf->Ln(10);
					$pdf->SetFont('Helvetica', 'BUI', 11);
					$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
					$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
					$pdf->SetFont('Helvetica', 'BI', 11);
					$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}
			$pdf->Ln(5);
			

			$hl=7;
			$pdf->SetFont('Arial','B',8);
			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(16,$hl,convertirc(_("Id")),1,0,'C',true);
			$pdf->Cell(94,$hl,convertirc(_("College")),1,0,'C',true);
			$pdf->Cell(30,$hl,convertirc(_("Mt Recl.")),1,0,'C',true);
			$pdf->Cell(30,$hl,convertirc(_("Mt Remb.")),1,0,'C',true);
			$pdf->Cell(20,$hl,convertirc(_("Taux (%)")),1,1,'C',true);
			
			$pdf->SetFont('Arial','',8);

			$total_montantFacture = 0;
			$total_apresDecompte = 0;
			$total_taux = 0;
		foreach ($p_factures as $p_facture){
		

			$total_montantFacture = $total_montantFacture + $p_facture['montantFacture'];
			$total_apresDecompte = $total_apresDecompte + $p_facture['apresDecompte'];
			$total_taux   = $total_taux + $p_facture['Taux'];

		
				$pdf->Cell(16,$hl,convertirc($p_facture['id']),1,0,'C',false);
			$pdf->Cell(94,$hl,convertirc($p_facture['libelleCollege']),1,0,'L',false);
				$pdf->Cell(30,$hl,convertirc(format_N($p_facture['montantFacture'])),1,0,'C',false);
				$pdf->Cell(30,$hl,convertirc(format_N($p_facture['apresDecompte'])),1,0,'C',false);
				$pdf->Cell(20,$hl,convertirc($p_facture['Taux']),1,1,'C',false);
			}
			$pdf->Cell(110,$hl,convertirc("TOTAL GENERAL"),1,0,'L',true);
			$pdf->Cell(30,$hl,convertirc(format_N($total_montantFacture)),1,0,'C',true);
			$pdf->Cell(30,$hl,convertirc(format_N($total_apresDecompte)),1,0,'C',true);
			$pdf->Cell(20,$hl,convertirc(format_N($total_taux)),1,1,'C',true);
		
				
			$pdf->SetFont('Helvetica','B',10);
			$pdf->Cell(45,$hl,convertirc(_(" * Légende :")),0,0,'L',false);

			$pdf->Ln(5);
			$pdf->SetX(16);
			$pdf->Cell(45,$hl,convertirc(_("Mt Recl. = Montant reclamé ")),0,0,'L',false);
			$pdf->Ln(5);
			$pdf->SetX(16);
			$pdf->Cell(45,$hl,convertirc(_("Mt Remb. = Montant  rembousé")),0,0,'L',false);
			$pdf->AddPage(); // debut ft3

			
			$p_factures  	= $this->detailsp->recapdepensesstatutbenef($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin);
			$statutsfts  	= $this->detailsp->recapdepensesstatutbenefdeux($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin);

			$statuts   		= $this->detailsp->listestatutbeneficiaire($idPolice,$p_datedebut,$p_datefin);

			$pdf->SetMargins(10, 10, 10) ;
			$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit3.jpg', 0, 0, 210); 
			$pdf->SetY(30);
			$pdf->SetFont('Helvetica', 'B', 18);
			$pdf->SetTextColor( 65, 185, 80 );
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->MultiCell(145, 8, convertirc(_("RÉCAPITULATIF DES DÉPENSES PAR STATUT DE BÉNEFICIAIRES")), 0, 'L' );

			$pdf->Ln(8);
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->SetTextColor(0);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
			$pdf->Ln(10);

			if ($p_id!=null){
		
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
			$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);

			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
			$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);

			//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
			$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);

			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
			$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
			//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
			}else{
			$pdf->Ln(10);
			$pdf->SetFont('Helvetica', 'BUI', 11);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
			$pdf->SetFont('Helvetica', 'BI', 11);
			$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}

			$pdf->Ln(5);
			$hl=6;
			$pdf->SetX(13);
			$pdf->SetFont('Arial','B',9);
			$pdf->Cell(184,6,convertirc(_('Dépenses par statut de bénéficiaires')),1,1,'C',false);
			$pdf->SetFont('Arial','B',8);
			$pdf->SetFillColor(143,206,143);
			$pdf->SetX(13);
			$pdf->Cell(34,$hl,convertirc(_('Statut bénéficiaire')),1,0,'C',true);
			$pdf->Cell(25,$hl,convertirc(_("Nombre")),1,0,'C',true);
			$pdf->Cell(25,$hl,convertirc(_("Taux effectif")),1,0,'C',true);
			$pdf->Cell(25,$hl,convertirc(_("Age moyen")),1,0,'C',true);
			$pdf->Cell(27,$hl,convertirc(_("Montant")),1,0,'C',true);
			$pdf->Cell(24,$hl,convertirc(_("Taux")),1,0,'C',true);
			$pdf->Cell(24,$hl,convertirc(_("Coût moyen")),1,1,'C',true);
			
			$pdf->SetFont('Arial','',9);
			
			
			$total_Nombre 	= 0;
			$total_Taux_Eff 	= 0;
			$total_Age_Moyen 	= 0;
			$total_Montant 	= 0;
			$total_tauxMontantTraite   	= 0;
			$total_coutMoyenTraite   	= 0;
			
			foreach ($p_factures as $p_facture)
			{
			$pdf->SetX(13);

				$pdf->Cell(34,$hl,convertirc($p_facture['libelle']),1,0,'L',false);
				$pdf->Cell(25,$hl,convertirc(format_N($p_facture['Nombre'])),1,0,'C',false);
				$pdf->Cell(25,$hl,convertirc($p_facture['Taux_Eff']."%"),1,0,'C',false);
				$pdf->Cell(25,$hl,convertirc($p_facture['Age_Moyen']),1,0,'C',false);
				$pdf->Cell(27,$hl,convertirc(format_N($p_facture['Montant'])),1,0,'C',false);
				$pdf->Cell(24,$hl,convertirc($p_facture['Taux_Depense']."%"),1,0,'C',false);
				$pdf->Cell(24,$hl,convertirc(format_N($p_facture['CoutMoyen'])),1,1,'C',false);

				$total_Nombre 	= $total_Nombre + $p_facture['Nombre'];
				$total_Taux_Eff 	= $total_Taux_Eff + $p_facture['Taux_Eff'];
				$total_Age_Moyen 	= $total_Age_Moyen + $p_facture['Age_Moyen'];
				$total_Montant 	= $total_Montant + $p_facture['Montant'];
				$total_tauxMontantTraite   	= $total_tauxMontantTraite + $p_facture['Taux_Depense'];
				$total_coutMoyenTraite   	= $total_coutMoyenTraite + $p_facture['CoutMoyen'];
			}
			$pdf->SetFont('Arial','B',9);
			$pdf->SetX(13);

			$total_Age_Moyen =$total_Age_Moyen /6;
			$pdf->Cell(34,$hl,convertirc("TOTAL GENERAL"),"1",0,'C',true);
			$pdf->Cell(25,$hl,format_N($total_Nombre),1,0,'C',true);
			$pdf->Cell(25,$hl,format_N($total_Taux_Eff)."%",1,0,'C',true);
			$pdf->Cell(25,$hl,format_N($total_Age_Moyen),1,0,'C',true);
			$pdf->Cell(27,$hl,format_N($total_Montant),1,0,'C',true);
			$pdf->Cell(24,$hl,format_N($total_tauxMontantTraite)."%",1,0,'C',true);
			$pdf->Cell(24,$hl,format_N($total_coutMoyenTraite),1,0,'C',true);

			$pdf->SetFont('Arial','B',8);
			$pdf->SetY(160);
			$pdf->Cell(10,8,(''),0,0);
			$pdf->Cell(80,8,convertirc(_('Récapitulatif dépenses par statut bénéficiaire (%)')),1,0,'C',false);
			$pdf->Cell(10,8,(''),0,0);
			$pdf->Cell(80,8,convertirc(_('Récapitulatif des bénéficiaires traités par statut (%)')),1,1,'C',false);
			$pdf->Ln(5);

			$pdf->Rect(20,168, 80, 52, 'D');
			$pdf->Rect(110, 168, 80, 52, 'D');
			// DEBUT GRAPH
			$valeur0=0;
			$valeur1=0;
			$valeur2=0;
			$valeur3=0;
			$valeur4=0;
			$valeur5=0;
			$value=0;
			$v=0;
			$valeurs=array();

			foreach($p_factures as $key => $value){
				array_push($valeurs,$value['Taux_Depense']);
			}
			
			foreach($valeurs as $key =>$valeur){	
			if ($key == 0) {
				$valeur0 = $valeur;
				
			}
			if ($key == 1) {
				$valeur1 = $valeur;
				
			}
			if ($key == 2) {
				$valeur2 = $valeur;
				
			}
			if ($key == 3) {
				$valeur3 = $valeur;
				
			}
			if ($key == 4) {
				$valeur4 = $valeur;
				
			}
			if ($key == 5) {
				$valeur5 = $valeur;
				
			}

			$data=Array(
				'A'=>[
					'color'=>[255,0,0],
					'value'=>$valeur0],
				'C'=>[
					'color'=>[255,255,0],
					'value'=>$valeur1],
				'E'=>[
					'color'=>[50,0,255],
					'value'=>$valeur2],
				'O'=>[
					'color'=>[255,0,255],
					'value'=>$valeur3],
				'F'=>[
					'color'=>[0,255,0],
					'value'=>$valeur4],
				'D'=>[
					'color'=>[0,0,0],
					'value'=>$valeur5]
				);
			}	
				//pie and legend properties
				$pieX=40;
				$pieY=195;
				$r=14;//radius
				$legendX=65;
				$legendY=185;

				//get total data summary
				$dataSum=0;
				foreach($data as $item){
					$dataSum+=$item['value'];
				}

				//get scale unit for each degree
				$degUnit=360/$dataSum;

				//variable to store current angle
				$currentAngle=0;
				//store current legend Y position
				$currentLegendY=$legendY;

				$pdf->SetFont('Arial','',8);

				//simplify the code by drawing both pie and legend in one loop
				foreach($data as $index=>$item){
					//draw the pie
					//slice size
					$deg=$degUnit*$item['value'];
					//set color
					$pdf->SetFillColor($item['color'][0],$item['color'][1],$item['color'][2]);
					//remove border
					$pdf->SetDrawColor($item['color'][0],$item['color'][1],$item['color'][2]);
					//draw the slice
					$pdf->Sector($pieX,$pieY,$r,$currentAngle,$currentAngle+$deg);
					//add slice angle to currentAngle var
					$currentAngle+=$deg;
					
					//draw the legend	
					$pdf->SetFont('Arial','',8);
				//	$pdf->SetXY($chartX,$chartY);
					$pdf->Rect($legendX,$currentLegendY,4,4,'DF');
					$pdf->SetXY($legendX + 6,$currentLegendY);
					foreach($valeurs as $key =>$valeur){	
						if ($key == 0) {
							$v0 = $valeur;
							
						}
						if ($key == 1) {
							$v1 = $valeur;
							
						}
						if ($key == 2) {
							$v2 = $valeur;
							
						}
						if ($key == 3) {
							$v3 = $valeur;
							
						}
						if ($key == 4) {
							$v4 = $valeur;
							
						}
						if ($key == 5) {
							$v5 = $valeur;
							
						}
					}
					$pdf->Cell(20,5,convertirc(_($index)),0,0);
					if ($index == 'A') {
						$pdf->Cell(10,5,convertirc(_($v0)),0,0);
					}
					if ($index == 'C') {
						$pdf->Cell(10,5,convertirc(_($v1)),0,0);
					}
					if ($index == 'E') {
						$pdf->Cell(10,5,convertirc(_($v2)),0,0);
					}
					if ($index == 'O') {
						$pdf->Cell(10,5,convertirc(_('0')),0,0);
					}
					if ($index == 'F') {
						$pdf->Cell(10,5,convertirc(_($v4)),0,0);
					}
					if ($index == 'D') {
						$pdf->Cell(10,5,convertirc(_($v5)),0,0);
					}
					$currentLegendY+=5;
				}


			$valeur0=0;
			$valeur1=0;
			$valeur2=0;
			$valeur3=0;
			$valeur4=0;
			$valeur5=0;
			$value=0;
			$v=0;
			$valeurs=array();
			foreach($statutsfts as $key => $value){
				array_push($valeurs,$value['Taux_Eff']);
			}
			
			foreach($valeurs as $key =>$valeur){	
			if ($key == 0) {
				$valeur0 = $valeur;
				
			}
			if ($key == 1) {
				$valeur1 = $valeur;
				
			}
			if ($key == 2) {
				$valeur2 = $valeur;
				
			}
			if ($key == 3) {
				$valeur3 = $valeur;
				
			}
			if ($key == 4) {
				$valeur4 = $valeur;
				
			}
			if ($key == 5) {
				$valeur5 = $valeur;
				
			}

			$data=Array(
				'A'=>[
					'color'=>[255,0,0],
					'value'=>$valeur0],
				'C'=>[
					'color'=>[255,255,0],
					'value'=>$valeur1],
				'E'=>[
					'color'=>[50,0,255],
					'value'=>$valeur2],
				'O'=>[
					'color'=>[255,0,255],
					'value'=>$valeur3],
				'F'=>[
					'color'=>[0,255,0],
					'value'=>$valeur4],
				'D'=>[
					'color'=>[0,0,0],
					'value'=>$valeur5]
				);
			}	
				//pie and legend properties
				$pieX=130;
				$pieY=195;
				$r=14;//radius
				$legendX=155;
				$legendY=185;

				//get total data summary
				$dataSum=0;
				foreach($data as $item){
					$dataSum+=$item['value'];
				}

				//get scale unit for each degree
				$degUnit=360/$dataSum;

				//variable to store current angle
				$currentAngle=0;
				//store current legend Y position
				$currentLegendY=$legendY;

				$pdf->SetFont('Arial','',8);

				//simplify the code by drawing both pie and legend in one loop
				foreach($data as $index=>$item){
					//draw the pie
					//slice size
					$deg=$degUnit*$item['value'];
					//set color
					$pdf->SetFillColor($item['color'][0],$item['color'][1],$item['color'][2]);
					//remove border
					$pdf->SetDrawColor($item['color'][0],$item['color'][1],$item['color'][2]);
					//draw the slice
					$pdf->Sector($pieX,$pieY,$r,$currentAngle,$currentAngle+$deg);
					//add slice angle to currentAngle var
					$currentAngle+=$deg;
					
					//draw the legend	
					$pdf->SetFont('Arial','',8);
				//	$pdf->SetXY($chartX,$chartY);
					$pdf->Rect($legendX,$currentLegendY,4,4,'DF');
					$pdf->SetXY($legendX + 6,$currentLegendY);
					foreach($valeurs as $key =>$valeur){	
						if ($key == 0) {
							$v0 = $valeur;
							
						}
						if ($key == 1) {
							$v1 = $valeur;
							
						}
						if ($key == 2) {
							$v2 = $valeur;
							
						}
						if ($key == 3) {
							$v3 = $valeur;
							
						}
						if ($key == 4) {
							$v4 = $valeur;
							
						}
						if ($key == 5) {
							$v5 = $valeur;
							
						}
					}
					$pdf->Cell(20,5,convertirc(_($index)),0,0);
					if ($index == 'A') {
						$pdf->Cell(10,5,convertirc(_($v0)),0,0);
					}
					if ($index == 'C') {
						$pdf->Cell(10,5,convertirc(_($v1)),0,0);
					}
					if ($index == 'E') {
						$pdf->Cell(10,5,convertirc(_($v2)),0,0);
					}
					if ($index == 'O') {
						$pdf->Cell(10,5,convertirc(_($v3)),0,0);
					}
					if ($index == 'F') {
						$pdf->Cell(10,5,convertirc(_($v4)),0,0);
					}
					if ($index == 'D') {
						$pdf->Cell(10,5,convertirc(_($v5)),0,0);
					}
					$currentLegendY+=5;
				}	


			$pdf->Ln(18);

			$hl=5;
			$pdf->SetX(13);
			$pdf->SetFont('Arial','B',9);
			$pdf->Cell(184,6,convertirc(_('Dépenses des bénéficiaires traités par statut')),1,1,'C',false);
			$pdf->SetFont('Arial','B',8);
			$pdf->SetX(13);
			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(34,$hl,convertirc(_('Statut bénéficiaire')),1,0,'C',true);
			$pdf->Cell(51,$hl,convertirc(_("Nombre de fois traités sur la période")),1,0,'C',true);
			$pdf->Cell(24,$hl,convertirc(_("Taux traités")),1,0,'C',true);
			$pdf->Cell(27,$hl,convertirc(_("Dépenses")),1,0,'C',true);
			$pdf->Cell(24,$hl,convertirc(_("Taux")),1,0,'C',true);
			$pdf->Cell(24,$hl,convertirc(_("Coût moyen")),1,1,'C',true);
			
			$pdf->SetFont('Arial','',9);
			
			
			$total_BenefTraite   	= 0;
			$total_Taux_EffTraite   = 0;
			$total_Depensestraite 	= 0;
			$total_Taux_Depense =0;
			$total_coutMoyenTraite   = 0;
			
			foreach ($statutsfts as $statutsft)
			{
				$pdf->SetX(13);
				$pdf->Cell(34,$hl,convertirc($statutsft['libelle']),1,0,'L',false);
				$pdf->Cell(51,$hl,convertirc(format_N($statutsft['BenefTraite'])),1,0,'C',false);
				$pdf->Cell(24,$hl,convertirc($statutsft['Taux_Eff']."%"),1,0,'C',false);
				$pdf->Cell(27,$hl,convertirc(format_N($statutsft['Depenses'])),1,0,'C',false);
				$pdf->Cell(24,$hl,convertirc($statutsft['Taux_Depense']."%"),1,0,'C',false);
				$pdf->Cell(24,$hl,convertirc(format_N($statutsft['CoutMoyen'])),1,1,'C',false);
				
				
				$total_BenefTraite   	= $total_BenefTraite + $statutsft['BenefTraite'];
				$total_Taux_EffTraite   	= $total_Taux_EffTraite + $statutsft['Taux_Eff'];
				$total_Depensestraite 				= $total_Depensestraite + $statutsft['Depenses'];
				$total_Taux_Depense 				= $total_Taux_Depense+ $statutsft['Taux_Depense'];
				$total_coutMoyenTraite   				= $total_coutMoyenTraite + $statutsft['CoutMoyen'];
			}
			$pdf->SetFont('Arial','B',9);
			$pdf->SetX(13);
			$pdf->Cell(34,$hl,convertirc("TOTAL GÉNERAL"),"1",0,'C',true);
			$pdf->Cell(51,$hl,format_N($total_BenefTraite),1,0,'C',true);
			$pdf->Cell(24,$hl,$total_Taux_EffTraite."%",1,0,'C',true);
			$pdf->Cell(27,$hl,format_N($total_Depensestraite),1,0,'C',true);
			$pdf->Cell(24,$hl,format_N($total_tauxMontantTraite)."%",1,0,'C',true);
			$pdf->Cell(24,$hl,format_N($total_coutMoyenTraite),1,0,'C',true);

		$pdf->AddPage();// debut ft 8

			$p_factures  	= $this->detailsp->etatrecapdepensesparfamilledactesmedicaux($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin);
			$pdf->SetMargins(10, 10, 10) ;
			$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit5.jpg', 0, 0, 210); 
			$pdf->SetY(15);
			$pdf->SetFont('Helvetica', 'B', 18);
			$pdf->SetTextColor( 65, 185, 80 );
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->MultiCell(150, 8, convertirc(_("RÉCAPITULATIF DES DÉPENSES PAR FAMILLE D'ACTES")), 0, 'L' );

			$pdf->Ln(8);
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->SetTextColor(0);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
			$pdf->Ln(10);

			if ($p_id!=null){

				$pdf->SetFont('Helvetica', 'B', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);

				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);

				//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);

				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
				//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
			}else{
				$pdf->Ln(10);
				$pdf->SetFont('Helvetica', 'BUI', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->SetFont('Helvetica', 'BI', 11);
				$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}
			$pdf->Ln(10);

			$hl=6;
			$pdf->SetFont('Arial', 'B', 8);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(15, $hl, convertirc(_('Code')), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(80, $hl, convertirc(_("Libellé")), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(20, $hl, convertirc(_("Quantité")), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(30, $hl, convertirc(_("Montant Remboursé")), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(25, $hl, convertirc(_("Coût Moyen")), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(20, $hl, convertirc(_("Taux")), 1, 1, 'C', true);
			$pdf->SetFont('Arial', '', 9);

			$total_assure = 0;
			$total_coutmoyen =0;
			$total_quantite =0;
			$total_montantrembourse  =0;
			$total_traite = 0;
			$total_taux = 0;

			foreach ($p_factures as $p_facture) {
				$pdf->Cell(15, $hl, convertirc($p_facture['codeGarantie']), 1, 0, 'L', false);
				$pdf->Cell(80, $hl, convertirc($p_facture['libelle']), 1, 0, 'L', false);
				$pdf->Cell(20, $hl, convertirc(format_N($p_facture['Quantite'])), 1, 0, 'C', false);
				$pdf->Cell(30, $hl, convertirc(format_N($p_facture['MontantRembourse'])), 1, 0, 'R', false);
				$pdf->Cell(25, $hl, convertirc(format_N($p_facture['Coutmoyen'])), 1, 0, 'R', false);
				$pdf->Cell(20, $hl, convertirc($p_facture['Taux']), 1, 1, 'C', false);
				
				$total_coutmoyen = $total_coutmoyen + $p_facture['Coutmoyen'];
				$total_quantite = $total_quantite + $p_facture['Quantite'];
				$total_montantrembourse = $total_montantrembourse + $p_facture['MontantRembourse'];
				$total_taux   = $total_taux + $p_facture['Taux'];
			}
			$hl=8;
			$pdf->SetFont('Arial', 'B', 9);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(95, $hl, convertirc(_('TOTAL')), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(20, $hl, convertirc(_(format_N($total_quantite))), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(30, $hl, convertirc(_(format_N($total_montantrembourse))), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(25, $hl, convertirc(_(format_N($total_coutmoyen))), 1, 0, 'C', true);
			$pdf->SetFillColor(143, 206, 143);
			$pdf->Cell(20, $hl, convertirc(_(convertirc('100 %'))), 1, 1, 'C', true);


			$chartX=15;
			$chartY=175;

			//dimension
			$chartWidth=180;
			$chartHeight=100;

			//padding
			$chartTopPadding=12;
			$chartLeftPadding=20;
			$chartBottomPadding=10;
			$chartRightPadding=5;

			//chart box
			$chartBoxX=$chartX+$chartLeftPadding;
			$chartBoxY=$chartY+$chartTopPadding;
			$chartBoxWidth=$chartWidth-$chartLeftPadding-$chartRightPadding;
			$chartBoxHeight=$chartHeight-$chartBottomPadding-$chartTopPadding;

			//bar width
			$barWidth=8;
			$valeur0=0;
			$valeur1=0;
			$valeur2=0;
			$valeur3=0;
			$valeur4=0;
			$valeur5=0;
			$valeur6=0;
			$valeur7=0;
			$valeur8=0;
			$valeur9=0;
			$valeur10=0;

			$value=0;
			$v=0;
			$valeurs=array();
			foreach($p_factures as $p_factures['codeGarantie'] => $value)
			{

				array_push($valeurs,$value['Taux']);
				foreach($valeurs as $key =>$valeur)
				{	
				if ($value['codeGarantie'] == 'AUX') {
					$valeur1 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'BIO') {
					$valeur2 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'CON') {
					$valeur3 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'DEN') {
					$valeur4 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'EXA') {
					$valeur5 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'HOS') {
					$valeur6 =  $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'IMA') {
					$valeur7 =  $value['Taux'];
				}
				if ($value['codeGarantie'] == 'MAT') {
					$valeur8 =  $value['Taux'];
				}
				if ($value['codeGarantie'] == 'OPT') {
					$valeur9 = $value['Taux'];	
				}
				if ($value['codeGarantie'] == 'PHA') {
					$valeur10 =  $value['Taux'];	
				}
				$data=Array(
					'AUX'=>[
						'color'=>[255,0,0],
						'value'=>$valeur1],
					'BIO'=>[
						'color'=>[255,255,0],
						'value'=>$valeur2],
					'CON'=>[
						'color'=>[50,0,255],
						'value'=>$valeur3],
					'DEN'=>[
						'color'=>[255,0,255],
						'value'=>$valeur4],
					'EXA'=>[
						'color'=>[0,255,0],
						'value'=>$valeur5],
					'HOS'=>[
						'color'=>[200,255,100],
						'value'=>$valeur6],
					'IMA'=>[
						'color'=>[121,248,248],
						'value'=>$valeur7],
					'MAT'=>[
						'color'=>[121,210,180],
						'value'=>$valeur8],
					'OPT'=>[
						'color'=>[221,248,248],
						'value'=>$valeur9],
					'PHA'=>[
						'color'=>[0,100,108],
						'value'=>$valeur10]	
					);
				}			
			}
			$dataMax=0;
			foreach($data as $item){
				if($item['value']>$dataMax)
				$dataMax=$item['value'];
			}
			//data step
			if($dataMax>200 and $dataMax<600){
				
				$dataStep=20;
			}
			if($dataMax<200){
				$dataStep=10;
			}
			if($dataMax>1000){
				
				$dataStep=100;
			}		
			//set font, line width and color
			$pdf->SetFont('Arial','',8);
			$pdf->SetLineWidth(0.1);
			$pdf->SetDrawColor(0);	
			//chart boundary
			$pdf->Rect($chartX,$chartY,$chartWidth,$chartHeight);	
			//vertical axis line
			$pdf->Line(
				$chartBoxX ,
				$chartBoxY , 
				$chartBoxX , 
				($chartBoxY+$chartBoxHeight)
				);
			//horizontal axis line
			$pdf->Line(
				$chartBoxX-2 , 
				($chartBoxY+$chartBoxHeight) , 
				$chartBoxX+($chartBoxWidth) , 
				($chartBoxY+$chartBoxHeight)
				);		
			///vertical axis
			//calculate chart's y axis scale unit
			$yAxisUnits=$chartBoxHeight/$dataMax;		
			//draw the vertical (y) axis labels
			for($i=0 ; $i<=$dataMax ; $i+=$dataStep){
				//y position
				$yAxisPos=$chartBoxY+($yAxisUnits*$i);
				//draw y axis line
				$pdf->Line(
					$chartBoxX-2 ,
					$yAxisPos ,
					$chartBoxX ,
					$yAxisPos
				);
				//set cell position for y axis labels
				$pdf->SetXY($chartBoxX-$chartLeftPadding , $yAxisPos-2);
				//$pdf->Cell($chartLeftPadding-4 , 5 , $dataMax-$i , 1);---------------
				$pdf->Cell($chartLeftPadding-4 , 5 , $dataMax-$i, 0 , 0 , 'R');
			}	
			///horizontal axis
			//set cells position
			$pdf->SetXY($chartBoxX , $chartBoxY+$chartBoxHeight);		
			//cell's width
			$xLabelWidth=$chartBoxWidth / count($data);		
			//$pdf->Cell($xLabelWidth , 5 , $itemName , 1 , 0 , 'C');-------------
			//loop horizontal axis and draw the bar
			$barXPos=0;
			foreach($data as $itemName=>$item){
				//print the label
				//$pdf->Cell($xLabelWidth , 5 , $itemName , 1 , 0 , 'C');--------------
				$pdf->Cell($xLabelWidth , 5 , $itemName , 0 , 0 , 'C');
				
				///drawing the bar
				//bar color
				$pdf->SetFillColor($item['color'][0],$item['color'][1],$item['color'][2]);
				//bar height
				$barHeight=$yAxisUnits*$item['value'];
				//bar x position
				$barX=($xLabelWidth/2)+($xLabelWidth*$barXPos);
				$barX=$barX-($barWidth/2);
				$barX=$barX+$chartBoxX;
				//bar y position
				$barY=$chartBoxHeight-$barHeight;
				$barY=$barY+$chartBoxY;
				//draw the bar
				$pdf->Rect($barX,$barY,$barWidth,$barHeight,'DF');
				//increase x position (next series)
				$barXPos++;
			}	
			//axis labels
			$pdf->SetFont('Arial','B',9);
			$pdf->SetXY($chartX,$chartY);
			$pdf->Cell(30,10,"Taux",0);
			$pdf->SetXY(($chartWidth/2)-50+$chartX,$chartY+$chartHeight-($chartBottomPadding/2));
			$pdf->Cell(100,5,convertirc(_("Récapitulatif des dépenses par famille d'acte")),0,0,'C');
			$pdf->AddPage();// debut fiche 11
			$depensesFamillesA  = $this->detailsp->etatcomparatifdesdepensesA($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin, $p_limite);
			$depensesFamillesB  = $this->detailsp->etatcomparatifdesdepensesB($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin, $p_limite);

			$pdf->SetMargins(10, 10, 10) ;
			$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit5.jpg', 0, 0, 210); 
			$pdf->SetY(10);
			$pdf->SetFont('Helvetica', 'B', 18);
			$pdf->SetTextColor( 65, 185, 80 );
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->MultiCell(150, 8, convertirc(_("COMPARATIF DES DÉPENSES DES ANNÉE N-1 ET N")), 0, 'L' );

			$pdf->Ln(8);
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->SetTextColor(0);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
			$pdf->Ln(9);

			if ($p_id!=null){

				$pdf->SetFont('Helvetica', 'B', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);

				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);

				//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);

				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
				//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
			}else{
				$pdf->Ln(10);
				$pdf->SetFont('Helvetica', 'BUI', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->SetFont('Helvetica', 'BI', 11);
				$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}
			$pdf->Ln(2);

			$hl=7;
			$pdf->SetFont('Arial','BU',10);
			$annee = date("Y", strtotime($p_datefin));
			$precannee = $annee -1;
			$pdf->Cell(95,$hl,convertirc(_('Etat des dépenses de l\'année n-1')),1,0,'C',FALSE);
			$pdf->Cell(95,$hl,convertirc(_('Etat des dépenses de l\'année n')),1,1,'C',FALSE);
			$pdf->SetFillColor(255,250,205);
			$pdf->SetFont('Arial','B',6);
			$pdf->Cell(44,$hl,convertirc(_('Famille d\'actes')),1,0,'C',true);
			$pdf->Cell(13,$hl,convertirc(_("Nombre")),1,0,'C',true);
			$pdf->Cell(14,$hl,convertirc(_("Montant net	")),1,0,'C',true);
			$pdf->Cell(13,$hl,convertirc(_("Coût moyen")),1,0,'C',true);
			$pdf->Cell(10,$hl,convertirc(_("Taux %")),1,0,'C',true);

			$pdf->SetX(106);
			$pdf->SetFillColor(0,100,108);
			$pdf->SetTextColor(255,255,255);

			$pdf->Cell(44,$hl,convertirc(_('Famille d\'actes')),1,0,'C',true);
			$pdf->Cell(13,$hl,convertirc(_("Nombre")),1,0,'C',true);
			$pdf->Cell(14,$hl,convertirc(_("Montant net	")),1,0,'C',true);
			$pdf->Cell(13,$hl,convertirc(_("Coût moyen")),1,0,'C',true);
			$pdf->Cell(10,$hl,convertirc(_("Taux %")),1,1,'C',true);
			$pdf->SetTextColor(0,0,0);

			$pdf->SetFont('Arial','',6);

			$total_popActive = 0;
			$total_popTraite = 0;
			
			$total_quantite		= 0;
			$total_taux =0;
			$total_montantReclame = 0;
			$total_montantNonRembourse = 0;
			$total_montantRembourse = 0;
			$total_coutMoyen = 0;
			$total_popActiveA = 0;
			$total_popTraiteA = 0;
			$total_montantReclameA = 0;
			$total_montantNonRembourseA = 0;
			$total_montantRembourseA = 0;
			$total_coutMoyenA = 0;
			$total_tauxA =0;
			$total_quantiteA = 0;

			foreach ($depensesFamillesA as $depA)
			{


				$pdf->Cell(44,$hl,convertirc($depA['libelle']),1,0,'L',false);
				$pdf->Cell(13,$hl,convertirc($depA['Quantite']),1,0,'C',false);
				$pdf->Cell(14,$hl,convertirc(format_N($depA['MontantRembourse'])),1,0,'C',false);
				$pdf->Cell(13,$hl,convertirc(format_N($depA['Coutmoyen'])),1,0,'C',false);
				$pdf->Cell(10,$hl,convertirc(($depA['Taux'])),1,1,'C',false);


				$total_quantiteA			= $total_quantiteA + $depA['Quantite'];
				$total_montantRembourseA 	= $total_montantRembourseA + $depA['MontantRembourse'];
				$total_coutMoyenA 			= $total_montantRembourseA / $total_quantiteA;
				$total_tauxA 	= $total_tauxA + $depA['Taux'];
				
			}	
			$pdf->SetFont('Arial','B',6);
			$pdf->SetFillColor(255,250,205);

			$pdf->Cell(44,$hl,convertirc("TOTAL GENERAL"),"1",0,'C',true);
			$pdf->Cell(13,$hl,format_N($total_quantiteA),1,0,'C',true);
			$pdf->Cell(14,$hl,format_N($total_montantRembourseA),1,0,'C',true);
			$pdf->Cell(13,$hl,format_N($total_coutMoyenA),1,0,'C',true);
			$pdf->Cell(10,$hl,format_N(100),1,0,'C',true);
			$pdf->SetY(89);
			if ($p_id!=null){
				$pdf->SetY(89);
				}else{
					$pdf->SetY(65);
				}
			foreach ($depensesFamillesB as $dep)
			{
				
					$pdf->SetX(106);

				$pdf->Cell(44,$hl,convertirc($dep['libelle']),1,0,'L',false);
				$pdf->Cell(13,$hl,convertirc($dep['Quantite']),1,0,'C',false);
				$pdf->Cell(14,$hl,convertirc(format_N($dep['MontantRembourse'])),1,0,'C',false);
				$pdf->Cell(13,$hl,convertirc(format_N($dep['Coutmoyen'])),1,0,'C',false);
				$pdf->Cell(10,$hl,convertirc($dep['Taux']),1,1,'C',false);


				$total_quantite			= $total_quantite + $dep['Quantite'];
				$total_montantRembourse 	= $total_montantRembourse + $dep['MontantRembourse'];
				$total_coutMoyen 			= $total_montantRembourse / $total_quantite;
				$total_taux 	= $total_taux + $dep['Taux'];
					
			}

			$pdf->SetX(106);
			$pdf->SetFont('Arial','B',6);
			$pdf->SetFillColor(0,100,108);
			$pdf->SetTextColor(255,255,255);
			$pdf->Cell(44,$hl,convertirc("TOTAL GENERAL"),"1",0,'C',true);
			$pdf->Cell(13,$hl,format_N($total_quantite),1,0,'C',true);
			$pdf->Cell(14,$hl,format_N($total_montantRembourse),1,0,'C',true);
			$pdf->Cell(13,$hl,format_N($total_coutMoyen),1,0,'C',true);
			$pdf->Cell(10,$hl,format_N(100),1,1,'C',true);	
			$pdf->SetTextColor(0,0,0);

			$pdf->SetFont('Arial','BU',10);

			$pdf->SetY(175);
			$pdf->SetX(50);
			$pdf->Cell(120,8,convertirc(_('Comparaison des dépenses de l\'année n-1  et l\'année n ')),1,1,'C',false);


			$chartX=15;
			$chartY=175;

			//dimension
			$chartWidth=180;
			$chartHeight=100;

			//padding
			$chartTopPadding=12;
			$chartLeftPadding=20;
			$chartBottomPadding=10;
			$chartRightPadding=5;

			//chart box
			$chartBoxX=$chartX+$chartLeftPadding;
			$chartBoxY=$chartY+$chartTopPadding;
			$chartBoxWidth=$chartWidth-$chartLeftPadding-$chartRightPadding;
			$chartBoxHeight=$chartHeight-$chartBottomPadding-$chartTopPadding;

			//bar width
			$barWidth=5;
			$barWidth1=5;
			$valeur0=0;
			$valeur1=0;
			$valeur2=0;
			$valeur3=0;
			$valeur4=0;
			$valeur5=0;
			$valeur6=0;
			$valeur7=0;
			$valeur8=0;
			$valeur9=0;
			$value=0;
			$v=0;
			$valeur0A=0;
			$valeur1A=0;
			$valeur2A=0;
			$valeur3A=0;
			$valeur4A=0;
			$valeur5A=0;
			$valeur6A=0;
			$valeur7A=0;
			$valeur8A=0;
			$valeur9A=0;

			$value1=0;
			$v=0;
			$valeurs=array();
			$valeurs1=array();
			foreach($depensesFamillesA as $depensesFamillesA['codeGarantie'] => $value1)
			{
				array_push($valeurs1,$value1['Taux']);

				foreach($valeurs1 as $key =>$valeurA)
				{	
				

				if ($value1['codeGarantie'] == 'AUX') {
					$valeur1A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'BIO') {
					$valeur2A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'CON') {
					$valeur3A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'DEN') {
					$valeur4A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'EXA') {
					$valeur5A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'HOS') {
					$valeur6A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'IMA') {
					$valeur7A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'MAT') {
					$valeur8A =  $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'OPT') {
					$valeur9A = $value1['Taux'];
					
				}
				if ($value1['codeGarantie'] == 'PHA') {
					$valeur10A =  $value1['Taux'];
					
				}
				$data1=Array(
					'AUX'=>[
						'color'=>[255,250,205],
						'value'=>$valeur1A],
					'BIO'=>[
						'color'=>[255,250,205],
						'value'=>$valeur2A],
					'CON'=>[
						'color'=>[255,250,205],
						'value'=>$valeur3A],
					'DEN'=>[
						'color'=>[255,250,205],
						'value'=>$valeur4A],
					'EXA'=>[
						'color'=>[255,250,205],
						'value'=>$valeur5A],
					'HOS'=>[
						'color'=>[255,250,205],
						'value'=>$valeur6A],
					'IMA'=>[
						'color'=>[255,250,205],
						'value'=>$valeur7A],
					'MAT'=>[
						'color'=>[255,250,205],
						'value'=>$valeur8A],
					'OPT'=>[
						'color'=>[255,250,205],
						'value'=>$valeur9A],
					'PHA'=>[
						'color'=>[255,250,205],
						'value'=>$valeur10A]	
					);
				}	
			}
			foreach($depensesFamillesB as $depensesFamillesB['codeGarantie'] => $value)
			{
				array_push($valeurs,$value['Taux']);

				foreach($valeurs as $key =>$valeur)
				{	
				

				if ($value['codeGarantie'] == 'AUX') {
					$valeur1 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'BIO') {
					$valeur2 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'CON') {
					$valeur3 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'DEN') {
					$valeur4 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'EXA') {
					$valeur5 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'HOS') {
					$valeur6 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'IMA') {
					$valeur7 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'MAT') {
					$valeur8 =  $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'OPT') {
					$valeur9 = $value['Taux'];
					
				}
				if ($value['codeGarantie'] == 'PHA') {
					$valeur10 =  $value['Taux'];
					
				}
				$data=Array(
					'AUX'=>[
						'color'=>[0,100,108],
						'value'=>$valeur1],
					'BIO'=>[
						'color'=>[0,100,108],
						'value'=>$valeur2],
					'CON'=>[
						'color'=>[0,100,108],
						'value'=>$valeur3],
					'DEN'=>[
						'color'=>[0,100,108],
						'value'=>$valeur4],
					'EXA'=>[
						'color'=>[0,100,108],
						'value'=>$valeur5],
					'HOS'=>[
						'color'=>[0,100,108],
						'value'=>$valeur6],
					'IMA'=>[
						'color'=>[0,100,108],
						'value'=>$valeur7],
					'MAT'=>[
						'color'=>[0,100,108],
						'value'=>$valeur8],
					'OPT'=>[
						'color'=>[0,100,108],
						'value'=>$valeur9],
					'PHA'=>[
						'color'=>[0,100,108],
						'value'=>$valeur10]	
					);
				}	
			}

			//$dataMax
			$dataMax1=0;
			foreach($data1 as $item1)
			{
				if($item1['value']>$dataMax1)
				$dataMax1=$item1['value'];
			}
			//data step
			if($dataMax1>200 and $dataMax1<600)
			{
				
				$dataStep1=20;
			}
			if($dataMax1<200){
				$dataStep1=10;
			}
			if($dataMax1>1000){
				
				$dataStep1=100;
			}
			$dataMax=0;
			foreach($data as $item)
			{
				if($item['value']>$dataMax)
				$dataMax=$item['value'];
			}
			//data step
			if($dataMax>200 and $dataMax<600)
			{
				
				$dataStep=20;
			}
			if($dataMax<200){
				$dataStep=10;
			}
			if($dataMax>1000){
				
				$dataStep=100;
			}
			//set font, line width and color
			$pdf->SetFont('Arial','',8);
			$pdf->SetLineWidth(0.1);
			$pdf->SetDrawColor(0);

			//chart boundary
			$pdf->Rect($chartX,$chartY,$chartWidth,$chartHeight);

			//vertical axis line
			$pdf->Line(
				$chartBoxX ,
				$chartBoxY , 
				$chartBoxX , 
				($chartBoxY+$chartBoxHeight)
				);
			//horizontal axis line
			$pdf->Line(
				$chartBoxX-2 , 
				($chartBoxY+$chartBoxHeight) , 
				$chartBoxX+($chartBoxWidth) , 
				($chartBoxY+$chartBoxHeight)
				);

			///vertical axis
			//calculate chart's y axis scale unit
			$yAxisUnits=$chartBoxHeight/$dataMax;
			$yAxisUnits1=$chartBoxHeight/$dataMax1;
			//draw the vertical (y) axis labels
			for($i=0 ; $i<=$dataMax1 ; $i+=$dataStep1)
			{
				//y position
				$yAxisPos1=$chartBoxY+($yAxisUnits1*$i);
				//draw y axis line
				$pdf->Line(
					$chartBoxX-2 ,
					$yAxisPos1 ,
					$chartBoxX ,
					$yAxisPos1
				);
				//set cell position for y axis labels
				$pdf->SetTextColor(255,250,205);
				$pdf->SetXY($chartBoxX-$chartLeftPadding , $yAxisPos1-2);
				//$pdf->Cell($chartLeftPadding-4 , 5 , $dataMax-$i , 1);---------------
				$pdf->Cell($chartLeftPadding-4 , 5 , $dataMax1-$i, 0 , 0 , 'L');
			}
			for($i=0 ; $i<=$dataMax ; $i+=$dataStep)
			{
				//y position
				$yAxisPos=$chartBoxY+($yAxisUnits*$i);
				//draw y axis line
				$pdf->Line(
					$chartBoxX-2 ,
					$yAxisPos ,
					$chartBoxX ,
					$yAxisPos
				);
				//set cell position for y axis labels
				$pdf->SetXY($chartBoxX-$chartLeftPadding , $yAxisPos-2);
				//$pdf->Cell($chartLeftPadding-4 , 5 , $dataMax-$i , 1);---------------
				$pdf->SetTextColor(0,100,108);
				$pdf->Cell($chartLeftPadding-2 , 5 , $dataMax-$i, 0 , 0 , 'R');
				$pdf->SetTextColor(0);

			}

			///horizontal axis
			//set cells position
			$pdf->SetXY($chartBoxX , $chartBoxY+$chartBoxHeight);

			//cell's width
			$xLabelWidth=$chartBoxWidth / count($data);

			//$pdf->Cell($xLabelWidth , 5 , $itemName , 1 , 0 , 'C');-------------
			//loop horizontal axis and draw the bar
			$barXPos1=0;
			foreach($data1 as $itemName1=>$item1)
			{
				//print the label
				//$pdf->Cell($xLabelWidth , 5 , $itemName , 1 , 0 , 'C');--------------
				//$pdf->Cell($xLabelWidth , 5 , $itemName , 0 , 0 , 'C');
				
				///drawing the bar
				//bar color
				$pdf->SetFillColor($item1['color'][0],$item1['color'][1],$item1['color'][2]);
				//bar height
				$barHeight=$yAxisUnits1*$item1['value'];
				//bar x position
				$barX1=($xLabelWidth/2)+($xLabelWidth*$barXPos1);
				$barX1=$barX1-($barWidth/2);
				$barX1=$barX1+$chartBoxX;
				//bar y position
				$barY1=$chartBoxHeight-$barHeight;
				$barY1=$barY1+$chartBoxY;
				//draw the bar
				$pdf->Rect($barX1,$barY1,$barWidth,$barHeight,'DF');
				//increase x position (next series)
				$barXPos1++;
			}
			$barXPos=0;
			//highlight_string("<?php\n\$datas =\n" . var_export($data1  , true) . ";\n>");
			foreach($data as $itemName=>$item)
			{
				//print the label
				//$pdf->Cell($xLabelWidth , 5 , $itemName , 1 , 0 , 'C');--------------
				$pdf->Cell($xLabelWidth , 5 , $itemName , 0 , 0 , 'C');
				
				///drawing the bar
				//bar color
				$pdf->SetFillColor($item['color'][0],$item['color'][1],$item['color'][2]);
				//bar height
				$barHeight=$yAxisUnits*$item['value'];
				//bar x position
				$barX=($xLabelWidth/2)+($xLabelWidth*$barXPos);
				$barX=$barX-($barWidth/2);
				$barX=$barX+$chartBoxX+5;
				//bar y position
				$barY=$chartBoxHeight-$barHeight;
				$barY=$barY+$chartBoxY;
				//draw the bar
				$pdf->Rect($barX,$barY,$barWidth,$barHeight,'DF');
				//increase x position (next series)
				$barXPos++;
			}
			//axis labels
			$pdf->SetFont('Arial','B',9);
			$pdf->SetXY($chartX,$chartY);
			$pdf->Cell(30,10,"Taux",0);
			$pdf->SetXY(($chartWidth/2)-50+$chartX,$chartY+$chartHeight-($chartBottomPadding/2));
			$pdf->SetXY(($chartWidth/2)-50+$chartX,$chartY+$chartHeight-($chartBottomPadding/2));

		$pdf->AddPage('L'); //DEBUT FT 13
			$p_factures  	= $this->detailsp->depensesparfamilledactesetparprestataires($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut, $p_datefin,$p_limite);
			$pdf->SetMargins(10, 10, 10) ;
			$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit4.jpg', 0, 0, 297); 
			$pdf->SetY(15);
			$pdf->SetFont('Helvetica', 'B', 18);
			$pdf->SetTextColor( 65, 185, 80 );
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->MultiCell(150, 8, convertirc(_("DÉPENSES PAR FAMILLE D'ACTES ET PAR PRESTATAIRES")), 0, 'L' );

			$pdf->Ln(8);
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->SetTextColor(0);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang'])), 0, 1, 'L', false);
			$pdf->Ln(10);

			if ($p_id!=null){

				$pdf->SetFont('Helvetica', 'B', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);
		
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);
		
				//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 1, 'L', false);
		
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
				$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
				//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
			}else{
				$pdf->Ln(10);
				$pdf->SetFont('Helvetica', 'BUI', 11);
				$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
				$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
				$pdf->SetFont('Helvetica', 'BI', 11);
				$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
			}
			$pdf->Ln(10);

			
			$pdf->Ln(4);
			$pdf->SetX(65);
			$pdf->Cell(170,6,convertirc(_('DÉPENSES SUPERIEURES A').' : '.format_N($depenses).' '.$_SESSION['devise_C']),1,1,'C',false);

			$pdf->Ln(2);
			$hl=7;
			$pdf->SetFont('Arial','B',6);

			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(62,$hl,convertirc(_("Prestataire")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_('Consultation')),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Imagerie")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Biologie")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Dentisterie")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Optique")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Hospitalisation")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Pharmacie")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Maternité")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("# Autres.")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("# Aux Med.")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("Assistance")),1,0,'C',true);
			$pdf->Cell(16,$hl,convertirc(_("# Trans Med.")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("# Bilan.")),1,0,'C',true);
			$pdf->Cell(15,$hl,convertirc(_("Totaux")),1,1,'C',true);

			$total_CONSULTATION = 
			$total_IMAGERIE =
			$total_BIOLOGIE = 
			$total_DENTISTERIE = 
			$total_OPTIQUE = 
			$total_HOSPITALISATION = 
			$total_PHARMACIE = 
			$total_MATERNITE = 
			$total_AUTRES_EXAMENS = 
			$total_AUXILIAIRES_MEDICAUX =
			$total_ASSISTANCE =
			$total_TRANSPORT_MEDICALISE = 
			$total_BILAN_DE_SANTE = 
			$total_TOTAUX = 0;
			$pdf->SetFont('Arial','',6);
			foreach ($p_factures as $dep)
			{
				$pdf->Cell(62,$hl,convertirc(substr($dep['Prestataire'],1,47)),1,0,'L',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['CONSULTATION'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['IMAGERIE'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['BIOLOGIE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['DENTISTERIE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['OPTIQUE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['HOSPITALISATION'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['PHARMACIE'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['MATERNITE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['AUTRES EXAMENS'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['AUXILIAIRES MEDICAUX'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['ASSISTANCE'])),1,0,'C',false);
				$pdf->Cell(16,$hl,convertirc(format_N($dep['TRANSPORT MEDICALISE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['BILAN DE SANTE'])),1,0,'C',false);
				$pdf->Cell(15,$hl,convertirc(format_N($dep['TOTAUX'])),1,1,'C',false);

				$total_CONSULTATION = $total_CONSULTATION + $dep['CONSULTATION'];
				$total_IMAGERIE = $total_IMAGERIE + $dep['IMAGERIE'];
				$total_BIOLOGIE = $total_BIOLOGIE + $dep['BIOLOGIE'];
				$total_DENTISTERIE = $total_DENTISTERIE + $dep['DENTISTERIE'];
				$total_OPTIQUE = $total_OPTIQUE + $dep['OPTIQUE'];
				$total_HOSPITALISATION = $total_HOSPITALISATION + $dep['HOSPITALISATION'];
				$total_PHARMACIE = $total_PHARMACIE + $dep['PHARMACIE'];
				$total_MATERNITE = $total_MATERNITE + $dep['MATERNITE'];
				$total_AUTRES_EXAMENS = $total_AUTRES_EXAMENS + $dep['AUTRES EXAMENS'];
				$total_AUXILIAIRES_MEDICAUX = $total_AUXILIAIRES_MEDICAUX + $dep['AUXILIAIRES MEDICAUX'];
				$total_ASSISTANCE = $total_ASSISTANCE + $dep['ASSISTANCE'];
				$total_TRANSPORT_MEDICALISE = $total_TRANSPORT_MEDICALISE + $dep['TRANSPORT MEDICALISE'];
				$total_BILAN_DE_SANTE = $total_BILAN_DE_SANTE + $dep['BILAN DE SANTE'];
				$total_TOTAUX = $total_TOTAUX + $dep['TOTAUX'];
			}	
			$pdf->SetFont('Arial','B',8);
			$pdf->SetFillColor(143,206,143);
			$pdf->Cell(62,$hl,convertirc("TOTAL GENERAL"),"1",0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_CONSULTATION),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_IMAGERIE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_BIOLOGIE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_DENTISTERIE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_OPTIQUE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_HOSPITALISATION),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_PHARMACIE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_MATERNITE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_AUTRES_EXAMENS),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_AUXILIAIRES_MEDICAUX),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_ASSISTANCE),1,0,'C',true);
			$pdf->Cell(16,$hl,format_N($total_TRANSPORT_MEDICALISE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_BILAN_DE_SANTE),1,0,'C',true);
			$pdf->Cell(15,$hl,format_N($total_TOTAUX),1,1,'C',true);

			$pdf->Cell(45,$hl,convertirc(_("Légende")),0,0,'L',false);
			$pdf->Ln(8);
			$pdf->Cell(45,$hl,convertirc(_("Autres. = Autres Examens")),0,0,'L',false);
			$pdf->Ln(5);
			$pdf->Cell(45,$hl,convertirc(_("Aux Med. = Auxiliaire Médicaux")),0,0,'L',false);
			$pdf->Ln(5);
			$pdf->Cell(45,$hl,convertirc(_("Trans Med. = Transport Medicalisé")),0,0,'L',false);
			$pdf->Ln(5);
			$pdf->Cell(45,$hl,convertirc(_("Bilan. = Bilan de santé")),0,0,'L',false);
			$pdf->Ln(2);

		
		$pdf->AddPage('L');
//
		$p_factures  	= $this->detailsp->evolutiondepfamilleAct($p_garant, $p_id_clients, $p_id,  $p_id_college, $p_datedebut,  $p_datefin,$p_limite );
		$pdf->SetMargins(10, 10, 10) ;
		$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit4.jpg', 0, 0, 297); 
		$pdf->SetY(15);
		$pdf->SetFont('Helvetica', 'B', 18);
		$pdf->SetTextColor( 65, 185, 80 );
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->MultiCell(150, 8, convertirc(_("ÉVOLUTION MENSUELLE DES DÉPENSES PAR FAMILLE D'ACTES")), 0, 'L' );
	
		$pdf->Ln(8);
		$pdf->SetFont('Helvetica', 'B', 11);
		$pdf->SetTextColor(0);
		$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
		$pdf->Cell(50, 6, convertirc(_('PÉRIODE COMPTABLE CONSIDÉRÉE').' : '.dateLang($debutStat, $_SESSION['lang']).' '._('AU').' '.dateLang($finStat, $_SESSION['lang'])), 0, 1, 'L', false);
		$pdf->Ln(10);
	
		if ($p_id!=null){
	
			$pdf->SetFont('Helvetica', 'B', 11);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
			$pdf->Cell(0, 6, convertirc(_(' : '.$entete['garant'])), 0, 1, 'L', false);
	  
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('SOUSCRIPTEUR')), 0, 0, 'L', false);
			$pdf->Cell(0, 6, convertirc(_(' : '.$entete['souscripteur'])), 0, 1, 'L', false);
	  
			//$pdf->Cell(0, 8, convertirc(_('SOUSCRIPTEUR').'  : '.$entete['souscripteur']), 0, 1, 'L', false);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('POLICE No')), 0, 0, 'L', false);
			$pdf->MultiCell(115, 6, convertirc(_(' : '.$entete['numeroPolice'].' / '.$entete['libellePolice'])), 0, 'L');
	  
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('COURTIER')), 0, 0, 'L', false);
			$pdf->Cell(0, 6, convertirc(_(' : '.$entete['courtier'])), 0, 1, 'L', false);
			//   $pdf->Cell(0, 6, convertirc(_('COURTIER').' : '.$entete['courtier']), 0, 1, 'L', false);
		}else{
			$pdf->Ln(10);
			$pdf->SetFont('Helvetica', 'BUI', 11);
			$pdf->Cell(5, 6, convertirc(''), 0, 0, 'L', false);
			$pdf->Cell(35, 6, convertirc(_('GARANT')), 0, 0, 'L', false);
			$pdf->SetFont('Helvetica', 'BI', 11);
			$pdf->Cell(0, 6, convertirc(_(' : '.$p_garant)), 0, 1, 'L', false);
		}
		$pdf->Ln(4);
		$pdf->SetX(65);
		$pdf->Cell(170,6,convertirc(_('DÉPENSES SUPÉRIEURES À').' : '.format_N($depenses).' '.$_SESSION['devise_C']),1,1,'C',false);
		
		
		$pdf->Ln(8);
		$hl=7;
		$pdf->SetFont('Arial','B',7);
		$pdf->SetFillColor(143,206,143);
		$pdf->Cell(15,$hl,convertirc(_('Code')),1,0,'C',true);
		$pdf->Cell(60,$hl,convertirc(_("Garantie")),1,0,'C',true);
		$pdf->Cell(16,$hl,convertirc(_("Janvier")),1,0,'C',true);
		$pdf->Cell(16,$hl,convertirc(_("Février")),1,0,'C',true);
		$pdf->Cell(15,$hl,convertirc(_("Mars")),1,0,'C',true);
		$pdf->Cell(15,$hl,convertirc(_("Avril")),1,0,'C',true);
		$pdf->Cell(15,$hl,convertirc(_("Mai")),1,0,'C',true);
		$pdf->Cell(15,$hl,convertirc(_("Juin")),1,0,'C',true);
		$pdf->Cell(16,$hl,convertirc(_("Juillet")),1,0,'C',true);
		$pdf->Cell(15,$hl,convertirc(_("Août")),1,0,'C',true);
		$pdf->Cell(16,$hl,convertirc(_("Septembre")),1,0,'C',true);
		$pdf->Cell(16,$hl,convertirc(_("Octobre")),1,0,'C',true);
		$pdf->Cell(16,$hl,convertirc(_("Novembre")),1,0,'C',true);
		$pdf->Cell(16,$hl,convertirc(_("Décembre")),1,0,'C',true);
		$pdf->Cell(16,$hl,convertirc(_("Totaux")),1,1,'C',true);
		$total_JANVIER = 0;
		$total_FEVRIER = 0;
		$total_MARS = 0;
		$total_AVRIL = 0;
		$total_MAI = 0;
		$total_JUIN = 0;
		$total_JUILLET = 0;
		$total_AOUT = 0;
		$total_SEPTEMBRE = 0;
		$total_OCTOBRE = 0;
		$total_NOVEMBRE = 0;
		$total_DECEMBRE = 0;
		$total_TOTAUX = 0;
		$pdf->SetFont('Arial','',7);
		foreach ($p_factures as $dep)
		{
			$pdf->Cell(15,$hl,convertirc($dep['codeGarantie']),1,0,'C',false);
			$pdf->Cell(60,$hl,convertirc($dep['libelle']),1,0,'L',false);
			$pdf->Cell(16,$hl,convertirc(format_N($dep['JANVIER'])),1,0,'C',false);
			$pdf->Cell(16,$hl,convertirc(format_N($dep['FEVRIER'])),1,0,'C',false);
			$pdf->Cell(15,$hl,convertirc(format_N($dep['MARS'])),1,0,'C',false);
			$pdf->Cell(15,$hl,convertirc(format_N($dep['AVRIL'])),1,0,'C',false);
			$pdf->Cell(15,$hl,convertirc(format_N($dep['MAI'])),1,0,'C',false);
			$pdf->Cell(15,$hl,convertirc(format_N($dep['JUIN'])),1,0,'C',false);
			$pdf->Cell(16,$hl,convertirc(format_N($dep['JUILLET'])),1,0,'C',false);
			$pdf->Cell(15,$hl,convertirc(format_N($dep['AOUT'])),1,0,'C',false);
			$pdf->Cell(16,$hl,convertirc(format_N($dep['SEPTEMBRE'])),1,0,'C',false);
			$pdf->Cell(16,$hl,convertirc(format_N($dep['OCTOBRE'])),1,0,'C',false);
			$pdf->Cell(16,$hl,convertirc(format_N($dep['NOVEMBRE'])),1,0,'C',false);
			$pdf->Cell(16,$hl,convertirc(format_N($dep['DECEMBRE'])),1,0,'C',false);
			$pdf->Cell(16,$hl,convertirc(format_N($dep['TOTAUX'])),1,1,'C',false);
		   
			$total_JANVIER = $total_JANVIER + $dep['JANVIER'];
			$total_FEVRIER = $total_FEVRIER + $dep['FEVRIER'];
			$total_MARS = $total_MARS + $dep['MARS'];
			$total_AVRIL = $total_AVRIL + $dep['AVRIL'];
			$total_MAI = $total_MAI + $dep['MAI'];
			$total_JUIN = $total_JUIN + $dep['JUIN'];
			$total_JUILLET = $total_JUILLET + $dep['JUILLET'];
			$total_AOUT = $total_AOUT + $dep['AOUT'];
			$total_SEPTEMBRE = $total_SEPTEMBRE + $dep['SEPTEMBRE'];
			$total_OCTOBRE = $total_OCTOBRE + $dep['OCTOBRE'];
			$total_NOVEMBRE = $total_NOVEMBRE + $dep['NOVEMBRE'];
			$total_DECEMBRE = $total_DECEMBRE + $dep['DECEMBRE'];
			$total_TOTAUX = $total_TOTAUX + $dep['TOTAUX'];
		}	
		$pdf->SetFont('Arial','B',8);
		$pdf->SetFillColor(143,206,143);
		$pdf->Cell(75,$hl,convertirc("TOTAL GENERAL"),"1",0,'C',true);
		$pdf->Cell(16,$hl,format_N($total_JANVIER),1,0,'C',true);
		$pdf->Cell(16,$hl,format_N($total_FEVRIER),1,0,'C',true);
		$pdf->Cell(15,$hl,format_N($total_MARS),1,0,'C',true);
		$pdf->Cell(15,$hl,format_N($total_AVRIL),1,0,'C',true);
		$pdf->Cell(15,$hl,format_N($total_MAI),1,0,'C',true);
		$pdf->Cell(15,$hl,format_N($total_JUIN),1,0,'C',true);
		$pdf->Cell(16,$hl,format_N($total_JUILLET),1,0,'C',true);
		$pdf->Cell(15,$hl,format_N($total_AOUT),1,0,'C',true);
		$pdf->Cell(16,$hl,format_N($total_SEPTEMBRE),1,0,'C',true);
		$pdf->Cell(16,$hl,format_N($total_OCTOBRE),1,0,'C',true);
		$pdf->Cell(16,$hl,format_N($total_NOVEMBRE),1,0,'C',true);
		$pdf->Cell(16,$hl,format_N($total_DECEMBRE),1,0,'C',true);
		$pdf->Cell(16,$hl,format_N($total_TOTAUX),1,1,'C',true);
	
		$pdf->AddPage();

		$pdf->Image($_SESSION['dossierSociete'].'/Tarifs/Img/newkit9.jpg', 0, 0, 210); 

		$caractere = array(" ","/");
		$nomdedossier =str_replace($caractere,"_",$entete['libellePolice']);
	
		$telephonePortable = (!empty($entete['telephonePortable']) && strlen($entete['telephonePortable']) >= 10) 
		? $entete['telephonePortable'] 
		: '2250152706497';
	
		$fichier="Temp/TMP_KIT_STATISTIQUES_FAMILLE"."_".$nomdedossier.".pdf";
	
		if(is_file($fichier)){
			$fichier="Temp/TMP_KIT_STATISTIQUES_FAMILLE"."_".$nomdedossier."_".uniqid().".pdf";
		}
		$pdf->Output($fichier,"F");	
		
		if(is_file($fichier)){
			$fichierpdf="https://gestionnaire.vitalis-ci.com/Temp/TMP_KIT_STATISTIQUES_FAMILLE"."_".$nomdedossier.".pdf";
			$caption ="Cher Assuré(e),veuillez trouver ci-joint les statistiques de votre police.";
			$filename = "KIT_STATISTIQUES".dateLang($p_datedebut, $_SESSION['lang']).' '._('AU').' '.dateLang($p_datefin, $_SESSION['lang']).'.pdf';
			$params=array(
				'token' => '5ujfcrqcc9qykwdq',
				'to' => $telephonePortable,
				'filename' => $filename,
				'document' => $fichierpdf,
				'caption' =>  $caption,
				'priority' => '',
				'referenceId' => '',
				'nocache' => '',
				'msgId' => '',
				'mentions' => ''
				);
				$curl = curl_init();
				curl_setopt_array($curl, array(
				  CURLOPT_URL => "https://api.ultramsg.com/instance72717/messages/document",
				  CURLOPT_RETURNTRANSFER => true,
				  CURLOPT_ENCODING => "",
				  CURLOPT_MAXREDIRS => 10,
				  CURLOPT_TIMEOUT => 30,
				  CURLOPT_SSL_VERIFYHOST => 0,
				  CURLOPT_SSL_VERIFYPEER => 0,
				  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
				  CURLOPT_CUSTOMREQUEST => "POST",
				  CURLOPT_POSTFIELDS => http_build_query($params),
				  CURLOPT_HTTPHEADER => array(
					"content-type: application/x-www-form-urlencoded"
				  ),
				));
				
				$response = curl_exec($curl);
				$err = curl_error($curl);
				
				curl_close($curl);

				if ($err) {
					echo "cURL Error #:" . $err;
				  } else {
					echo $response;
				  }
		}
		return($fichier);
	}

}