ebene/production
3
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
production/Controleur/ControleurAjaxstatsmaladiefichetechniquevingtpdf.php
KANE LAZENI 0a60b58952 first commit
2025-12-02 11:29:44 +00:00

229 lines
10 KiB
PHP
Executable File
Raw Permalink Blame History

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