254 lines
12 KiB
PHP
Executable File
254 lines
12 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Controleurrequete.php';
|
|
require_once 'Modele/Statistique.php';
|
|
|
|
class ControleurAjaxstatsmaladiefichetechniquevingtdeuxpdf 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");
|
|
$Chargement = $this->requete->getParametreFormulaire("Chargement");
|
|
|
|
$_SESSION['debutStat'] = $debutStat;
|
|
$_SESSION['finStat'] = $finStat;
|
|
$p_datedebut = $_SESSION['debutStat'];
|
|
$p_datefin = $_SESSION['finStat'];
|
|
|
|
|
|
$p_garant = $codeGcAssureur;
|
|
if ($p_garant == "AUC") {
|
|
$p_garant = null;
|
|
}
|
|
$p_id = $idPolice;
|
|
if ($p_id == "") {
|
|
$p_id = null;
|
|
}
|
|
$idCollege = "";
|
|
$p_id_clients = null;
|
|
$p_id_college = null;
|
|
$p_code = 'QTM';
|
|
$p_taux = '18';
|
|
|
|
$recapresultattechniquesgarants = $this->detailsp->getrecapresultattechniquesgarants($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin, $p_code);
|
|
|
|
$TOTALmontantnbre_policeG =
|
|
$TOTALmontantApayerTotalG =
|
|
$TOTALprimeAnalyseTotalG =
|
|
$TOTALprimeAnnuelleTotalG = 0;
|
|
$TOTALrapportSpTotalG = 0.00;
|
|
$TOTALajustementSpG = 0.00;
|
|
|
|
// Création du PDF et ajout de la première page IMMÉDIATEMENT
|
|
$pdf = new FPDF_Protection();
|
|
$pdf->SetAuthor('EBENE SOLUTIONS INFORMATIQUES');
|
|
$userPassword = '';
|
|
$ownerPassword = null;
|
|
$pdf->SetProtection(['print'], $userPassword, $ownerPassword);
|
|
|
|
$pdf->AliasNbPages();
|
|
$pdf->AddPage(); // ← AJOUT CRITIQUE ICI
|
|
|
|
$pdf->SetMargins(10, 10, 10);
|
|
|
|
// Vérifier si des données existent
|
|
if (empty($recapresultattechniquesgarants)) {
|
|
$pdf->SetFont('Arial', 'B', 12);
|
|
$pdf->Cell(0, 10, convertirc(_('Aucune donnée disponible pour la période sélectionnée')), 0, 1, 'C');
|
|
$this->outputPDF($pdf);
|
|
return;
|
|
}
|
|
|
|
foreach ($recapresultattechniquesgarants as $recapresultattechniquesgarant) {
|
|
$p_garant = $recapresultattechniquesgarant['codeGcAssureur'];
|
|
|
|
// Vérifier si on dépasse la hauteur de page
|
|
if ($pdf->GetY() > 250) {
|
|
$pdf->AddPage();
|
|
}
|
|
|
|
$resultattechniques = $this->detailsp->getrecapresultattechniques($p_garant, $p_id_clients, $p_id, $p_id_college, $p_datedebut, $p_datefin, $p_code, $Chargement);
|
|
|
|
if ($pdf->PageNo() == 1 || $pdf->GetY() < 30) {
|
|
$pdf->Image($_SESSION['lienLogo'], 94, 3, 15);
|
|
$pdf->SetFont('Arial', 'B', 7);
|
|
|
|
$pdf->Cell(0, 5, '', 0, 1, 'L', false);
|
|
$pdf->SetY(10);
|
|
$pdf->SetFont('Arial', '', 7);
|
|
$pdf->Cell(0, 5, convertirc(_('Edition du').': '.heureCouranteLang($_SESSION['lang'])), 0, 1, 'R', false);
|
|
|
|
$pdf->Ln(2);
|
|
|
|
$pdf->SetFont('Arial', 'B', 13);
|
|
$pdf->SetFillColor(144, 238, 144);
|
|
$pdf->Cell(0, 8, convertirc(_("RECAPITULATIF DES EMISSIONS PAR COMPAGNIE ET PAR COURTIER")), 1, 0, 'C', true);
|
|
|
|
$pdf->Ln(10);
|
|
$pdf->SetFont('Arial', 'B', 11);
|
|
$pdf->SetTextColor(0);
|
|
$pdf->Ln(8);
|
|
$pdf->Cell(0, 5, convertirc(_('PERIODE CONSIDEREE').': '.dateLang($debutStat, $_SESSION['lang']).' '._('AU').' '.dateLang($finStat, $_SESSION['lang'])), 0, 1, 'C', false);
|
|
}
|
|
|
|
$pdf->Ln(8);
|
|
$pdf->SetFont('Arial', 'BUI', 11);
|
|
$pdf->Cell(35, 8, convertirc(_('COMPAGNIE')), 0, 0, 'L', false);
|
|
$pdf->SetFont('Arial', 'BI', 11);
|
|
$pdf->Cell(0, 8, convertirc(': '.$recapresultattechniquesgarant['GARANT']), 0, 1, 'L', false);
|
|
|
|
$pdf->Ln(5);
|
|
|
|
$hl = 7;
|
|
$pdf->SetFont('Arial', 'B', 8);
|
|
$pdf->SetFillColor(144, 238, 144);
|
|
$pdf->Cell(73, $hl, convertirc(_('Courtier')), 1, 0, 'C', true);
|
|
$pdf->SetFillColor(144, 238, 144);
|
|
$pdf->Cell(15, $hl, convertirc(_("Nbr Police")), 1, 0, 'C', true);
|
|
$pdf->SetFillColor(144, 238, 144);
|
|
$pdf->Cell(53, $hl, convertirc(_("Sinistres")), 1, 0, 'C', true);
|
|
$pdf->SetFillColor(144, 238, 144);
|
|
$pdf->Cell(40, $hl, convertirc(_("Primes totales annuelles")), 1, 0, 'C', true);
|
|
$pdf->SetFillColor(144, 238, 144);
|
|
$pdf->Cell(12, $hl, convertirc(_("R/SP (%)")), 1, 1, 'C', true);
|
|
|
|
$hl = 5;
|
|
$pdf->SetFont('Arial', 'B', 8);
|
|
$pdf->Cell(88, $hl, convertirc('-'), 1, 0, 'C', false);
|
|
$pdf->Cell(17, $hl, convertirc(_("Tardifs")), 1, 0, 'C', false);
|
|
$pdf->Cell(18, $hl, convertirc(_("Courant")), 1, 0, 'C', false);
|
|
$pdf->Cell(18, $hl, convertirc(_("Total")), 1, 0, 'C', false);
|
|
$pdf->Cell(20, $hl, convertirc(_("Période")), 1, 0, 'C', false);
|
|
$pdf->Cell(20, $hl, convertirc(_("Totales")), 1, 0, 'C', false);
|
|
$pdf->Cell(12, $hl, convertirc("-"), 1, 1, 'C', false);
|
|
$pdf->SetFont('Arial', '', 8);
|
|
|
|
$TOTALmontantnbre_police =
|
|
$TOTALmontantApayerTotal =
|
|
$TOTALprimeAnalyseTotal =
|
|
$TOTALprimeAnnuelleTotal = 0;
|
|
$TOTALrapportSpTotal = 0.00;
|
|
$TOTALajustementSp = 0.00;
|
|
|
|
foreach ($resultattechniques as $resultattechnique) {
|
|
// Vérifier l'espace avant d'ajouter une nouvelle ligne
|
|
if ($pdf->GetY() > 270) {
|
|
$pdf->AddPage();
|
|
// Réafficher les en-têtes de colonnes sur la nouvelle page
|
|
$this->drawTableHeaders($pdf);
|
|
}
|
|
|
|
$hl = 7;
|
|
$pdf->SetFont('Arial', '', 7);
|
|
$pdf->Cell(73, $hl, convertirc(_($resultattechnique['courtier'])), 1, 0, 'L', false);
|
|
$pdf->Cell(15, $hl, convertirc(_($resultattechnique['nbre_police'])), 1, 0, 'R', false);
|
|
$pdf->Cell(17, $hl, convertirc(''), 1, 0, 'C', false);
|
|
$pdf->Cell(18, $hl, convertirc(format_N($resultattechnique['sinistresAnalyse'])), 1, 0, 'R', false);
|
|
$pdf->Cell(18, $hl, convertirc(format_N($resultattechnique['sinistresAnalyse'])), 1, 0, 'R', false);
|
|
$pdf->Cell(20, $hl, convertirc(format_N($resultattechnique['primeAnalyseGarant'])), 1, 0, 'R', false);
|
|
$pdf->Cell(20, $hl, convertirc(format_N($resultattechnique['primeAnnuelle'])), 1, 0, 'R', false);
|
|
$pdf->Cell(12, $hl, convertirc(_($resultattechnique['rapportApp'])), 1, 1, 'C', false);
|
|
|
|
$TOTALmontantnbre_police = $TOTALmontantnbre_police + $resultattechnique['nbre_police'];
|
|
$TOTALmontantApayerTotal = $TOTALmontantApayerTotal + $resultattechnique['sinistresAnalyse'];
|
|
$TOTALprimeAnalyseTotal = $TOTALprimeAnalyseTotal + $resultattechnique['primeAnalyseGarant'];
|
|
$TOTALprimeAnnuelleTotal = $TOTALprimeAnnuelleTotal + $resultattechnique['primeAnnuelle'];
|
|
$TOTALajustementSp = $TOTALajustementSp + $resultattechnique['ajustementSp'];
|
|
}
|
|
|
|
$TOTALrapportSpTotal = $resultattechnique['rspAnalyse'];
|
|
|
|
$pdf->SetFont('Arial', 'B', 8);
|
|
$pdf->SetTextColor(75, 0, 130);
|
|
$pdf->Cell(73, $hl, convertirc(_('TOTAL').' '.$resultattechnique['codeGcAssureur']), 1, 0, 'L', false);
|
|
$pdf->Cell(15, $hl, convertirc(_($TOTALmontantnbre_police)), 1, 0, 'R', false);
|
|
$pdf->Cell(17, $hl, convertirc(''), 1, 0, 'C', false);
|
|
$pdf->Cell(18, $hl, convertirc(format_N($resultattechnique['sinistresAnnuelle'])), 1, 0, 'R', false);
|
|
$pdf->Cell(18, $hl, convertirc(format_N($resultattechnique['sinistresAnnuelle'])), 1, 0, 'R', false);
|
|
$pdf->Cell(20, $hl, convertirc(format_N($TOTALprimeAnalyseTotal)), 1, 0, 'R', false);
|
|
$pdf->Cell(20, $hl, convertirc(format_N($TOTALprimeAnnuelleTotal)), 1, 0, 'R', false);
|
|
$pdf->Cell(12, $hl, convertirc($TOTALrapportSpTotal), 1, 1, 'C', false);
|
|
|
|
$TOTALmontantnbre_policeG = $TOTALmontantnbre_policeG + $TOTALmontantnbre_police;
|
|
$TOTALmontantApayerTotalG = $TOTALmontantApayerTotalG + $resultattechnique['sinistresAnnuelle'];
|
|
$TOTALprimeAnalyseTotalG = $TOTALprimeAnalyseTotalG + $TOTALprimeAnalyseTotal;
|
|
$TOTALprimeAnnuelleTotalG = $TOTALprimeAnnuelleTotalG + $TOTALprimeAnnuelleTotal;
|
|
$TOTALajustementSpG = $TOTALajustementSpG + $TOTALajustementSp;
|
|
$pdf->SetTextColor(0, 0, 0);
|
|
|
|
$pdf->Ln(5);
|
|
$TOTALrapportSpTotalG = $resultattechnique['rspAnalyse'];
|
|
}
|
|
|
|
// Total général
|
|
if ($pdf->GetY() > 270) {
|
|
$pdf->AddPage();
|
|
}
|
|
|
|
$hl = 4;
|
|
$pdf->SetFont('Arial', 'B', 8);
|
|
$pdf->SetTextColor(255, 0, 0);
|
|
$pdf->Cell(73, $hl, convertirc(_('TOTAL GENERAL')), 1, 0, 'L', false);
|
|
$pdf->Cell(15, $hl, convertirc(_($TOTALmontantnbre_policeG)), 1, 0, 'C', false);
|
|
$pdf->Cell(17, $hl, convertirc(''), 1, 0, 'C', false);
|
|
$pdf->Cell(18, $hl, convertirc(format_N($TOTALmontantApayerTotalG)), 1, 0, 'C', false);
|
|
$pdf->Cell(18, $hl, convertirc(format_N($TOTALmontantApayerTotalG)), 1, 0, 'C', false);
|
|
$pdf->Cell(20, $hl, convertirc(format_N($TOTALprimeAnalyseTotalG)), 1, 0, 'C', false);
|
|
$pdf->Cell(20, $hl, convertirc(format_N($TOTALprimeAnnuelleTotalG)), 1, 0, 'C', false);
|
|
$pdf->Cell(12, $hl, convertirc($TOTALrapportSpTotalG), 1, 1, 'C', false);
|
|
|
|
$pdf->SetFont('Arial', '', 8);
|
|
$pdf->SetTextColor(0, 0, 0);
|
|
$pdf->Ln(8);
|
|
|
|
$pdf->Cell(45, $hl, convertirc(_("# R/SP (%). = Rapport Sinitre Total / Prime Totale période")), 0, 0, 'L', false);
|
|
|
|
$this->outputPDF($pdf);
|
|
}
|
|
|
|
/**
|
|
* Fonction pour dessiner les en-têtes du tableau (réutilisable sur les nouvelles pages)
|
|
*/
|
|
private function drawTableHeaders($pdf) {
|
|
$hl = 7;
|
|
$pdf->SetFont('Arial', 'B', 8);
|
|
$pdf->SetFillColor(144, 238, 144);
|
|
$pdf->Cell(73, $hl, convertirc(_('Courtier')), 1, 0, 'C', true);
|
|
$pdf->Cell(15, $hl, convertirc(_("Nbr Police")), 1, 0, 'C', true);
|
|
$pdf->Cell(53, $hl, convertirc(_("Sinistres")), 1, 0, 'C', true);
|
|
$pdf->Cell(40, $hl, convertirc(_("Primes totales annuelles")), 1, 0, 'C', true);
|
|
$pdf->Cell(12, $hl, convertirc(_("R/SP (%)")), 1, 1, 'C', true);
|
|
|
|
$hl = 5;
|
|
$pdf->SetFont('Arial', 'B', 8);
|
|
$pdf->Cell(88, $hl, convertirc('-'), 1, 0, 'C', false);
|
|
$pdf->Cell(17, $hl, convertirc(_("Tardifs")), 1, 0, 'C', false);
|
|
$pdf->Cell(18, $hl, convertirc(_("Courant")), 1, 0, 'C', false);
|
|
$pdf->Cell(18, $hl, convertirc(_("Total")), 1, 0, 'C', false);
|
|
$pdf->Cell(20, $hl, convertirc(_("Période")), 1, 0, 'C', false);
|
|
$pdf->Cell(20, $hl, convertirc(_("Totales")), 1, 0, 'C', false);
|
|
$pdf->Cell(12, $hl, convertirc("-"), 1, 1, 'C', false);
|
|
$pdf->SetFont('Arial', '', 8);
|
|
}
|
|
|
|
/**
|
|
* Fonction pour générer et afficher le PDF
|
|
*/
|
|
private function outputPDF($pdf) {
|
|
$fichier = "Temp/TMP_CUMUL_FT22_RECAPITULATIF_DES_EMISSIONS_PAR_COMPAGNIE"."_".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 FT22_RECAPITULATIF_DES_EMISSIONS_PAR_COMPAGNIE").'</a>';
|
|
$t_html .= '</div>';
|
|
echo $t_html;
|
|
}
|
|
} |