production/Controleur/ControleurAjaxdetailrapportmail.php
2025-12-02 11:29:44 +00:00

211 lines
6.4 KiB
PHP
Executable File

<?php
require_once 'Framework/Controleurrequete.php'; // OK
require_once 'Modele/Statistique.php';
class ControleurAjaxdetailrapportmail extends Controleur
{
private $detailsp;
private $mail_C;
public function __construct() {
$this->detailsp = new Statistique();
require_once 'Framework/Ebenegmail.php';
$this->mail_C = $mail;
}
public function index()
{
$dateAnalyse = $_SESSION['dateAnalyse'];
$idPolice = $this->requete->getParametreFormulaire("idPolice");
$email = $this->requete->getParametreFormulaire("emailRapport");
$entete = $this->detailsp->detailrapportsppdfentete($idPolice);
$detailsps = $this->detailsp->detailrapportsppdf($idPolice);
$pdf = new FPDF_Protection();
$pdf->SetAuthor('EBENE SOLUTIONS INFORMATIQUES');
$userPassword = '';
$ownerPassword = null;
$pdf->SetProtection(['print'], $userPassword, $ownerPassword);
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetMargins(15, 15, 15) ;
$pdf->Image($_SESSION['lienLogo'],94,3,18);
$pdf->Ln(10);
$pdf->SetFont('Arial','BU',10);
// $pdf->AliasNbPages();
$pdf->Cell(0,6,convertirc(_("RAPPORT SINISTRE A PRIME DETAIL PAR FAMILLE")),0,1,'C',false);
$pdf->Ln(2);
$pdf->SetFont('Arial','B',7);
$pdf->Cell(0,5,convertirc(_('Garant').' : '.$entete['garant']),0,1,'L',false);
$pdf->Cell(0,5,convertirc(_('Souscripteur').' : '.$entete['souscripteur']),0,1,'L',false);
$pdf->Cell(0,5,convertirc(_('Police').' No : '.$entete['numeroPolice'].' / '.$entete['libellePolice']),0,1,'L',false);
$pdf->Cell(0,5,convertirc(_('Période couverte').' : '.dateLang($entete['dateEffetPolice'], $_SESSION['lang']).' '._('au').' '.dateLang($entete['dateFinPolice'], $_SESSION['lang'])),0,1,'L',false);
$pdf->Cell(0,5,convertirc(_('Date Analyse').' : '.dateLang($entete['dateAnalyse'], $_SESSION['lang'])),0,0,'L',false);
$pdf->Cell(0,5,'Edition : '.heureCouranteLang($_SESSION['lang']),0,1,'R',false);
$pdf->Ln(2);
$hl=5;
$pdf->Cell(15,$hl,convertirc(_('Matricule')),"1",0,'C');
$pdf->Cell(60,$hl,convertirc(_('Adhérent')),"1",0,'C');
$pdf->Cell(15,$hl,convertirc(_('Date Effet')),"1",0,'C');
$pdf->Cell(10,$hl,convertirc(_('Jours')),"1",0,'C');
$pdf->Cell(20,$hl,convertirc(_('Prime An')),"1",0,'C');
$pdf->Cell(20,$hl,convertirc(_('Prime Acquise')),"1",0,'C');
$pdf->Cell(20,$hl,convertirc(_('Sinistres')),"1",0,'C');
$pdf->Cell(20,$hl,convertirc("Ratio"),"1",1,'C');
$pdf->SetFont('Arial','I',7);
foreach ($detailsps as $detailsp)
{
$pdf->Cell(15,$hl,convertirc($detailsp['numeroAdherent']),"1",0,'C');
$pdf->Cell(60,$hl,convertirc($detailsp['adherent']),"1",0,'L');
$pdf->Cell(15,$hl,convertirc($detailsp['dateEffetAdherent']),"1",0,'C');
$pdf->Cell(10,$hl,convertirc($detailsp['duree_acq']),"1",0,'C');
$pdf->Cell(20,$hl,format_N($detailsp['primeAnnuelle']),"1",0,'C');
$pdf->Cell(20,$hl,format_N($detailsp['primeAcquise']),"1",0,'C');
$pdf->Cell(20,$hl,format_N($detailsp['sinistres']),"1",0,'C');
$pdf->Cell(10,$hl,convertirc($detailsp['rapportSp']),"1",0,'C');
$pdf->Cell(10,$hl,convertirc($detailsp['rapportSpAn']),"1",1,'C');
}
$pdf->SetFont('Arial','BI',7);
$pdf->Cell(100,$hl,convertirc("TOTAL"),"1",0,'C');
$pdf->Cell(20,$hl,format_N($detailsp['primeAnnuelleTotal']),"1",0,'C');
$pdf->Cell(20,$hl,format_N($detailsp['primeAcquiseTotal']),"1",0,'C');
$pdf->Cell(20,$hl,format_N($detailsp['sinistresTotal']),"1",0,'C');
$pdf->Cell(10,$hl,convertirc($detailsp['rapportSpTotal']),"1",0,'C');
$pdf->Cell(10,$hl,convertirc($detailsp['rapportSpTotalAn']),"1",1,'C');
$pdf->Ln(20);
$pdf->SetFont('Arial','BI', $tp);
if (est_anglophone())
{
$pdf->Cell(0,$ht,convertirc("Done at " . $_SESSION['villeSociete'].", on ".dateCouranteLang($_SESSION['lang'])),0,1,'C',false);
}
else
{
$pdf->Cell(0,$ht,convertirc("Fait à " . $_SESSION['villeSociete'].", le ".dateCouranteLang($_SESSION['lang'])),0,1,'C',false);
}
$pdf->Ln(10);
$pdf->SetFont('Arial','BU', $tp);
$pdf->Cell(0,$ht,convertirc(_("Le Souscripteur")),0,0,'L',false);
$pdf->Cell(0,$ht,convertirc(_("Le Gestionnaire")),0,0,'R',false);
// DEBUT ENVOI DU MAIL AVEC PIECE JOINTE
$mail_C = $this->mail_C;
$mail_C->ClearAllRecipients();
$mail_C->clearAttachments();
$addr = explode(';', $email);
foreach ($addr as $ad)
{
if(tester_une_adresse_email($ad))
{
$mail_C->AddAddress(trim($ad) );
}
}
if (est_anglophone())
{
$fichier="Temp/SUMMARY_END_".$dateAnalyse."_".uniqid().".pdf";
$pdf->Output($fichier,"F");
$obejt = "SUMMARY END : ".$dateAnalyse;
$body = convertirc("Dear Customer,");
$body .= "<br/> <br/>";
$body .= convertirc("Hope this email find you well,");
$body .= "<br/> <br/>";
$body .= convertirc("Attached file is claims report of your staff from starting date up to ".$dateAnalyse).'.';
$body .= "<br/> <br/>";
$body .= convertirc("You can share those informations with every one and if any more clarification do not hesitate to contact us for more details.");
$body .= "<br/> <br/>";
$body .= convertirc("Kind Regards.");
$altbody = "SEE ATTACHMENT";
}
else
{
$fichier="Temp/RAPPORT_SP_".$dateAnalyse."_".uniqid().".pdf";
$pdf->Output($fichier,"F");
$obejt = "RAPPORT AU : ".$dateAnalyse;
$body = convertirc("Cher Client,");
$body .= "<br/> <br/>";
$body .= convertirc("Nous vous prions de trouver en pièce jointe votre rapport de consommations par famille à la date du ".$dateAnalyse).'.';
$body .= "<br/> <br/>";
$body .= convertirc("Vous pouvez partager ces informations avec tout le monde et si vous avez besoin de précisions,");
$body .= "<br/> <br/>";
$body .= convertirc("N'hésitez pas à nous contacter pour plus de détails.");
$body .= "<br/> <br/>";
$body .= convertirc("Cordialement!");
$altbody = "VOIR PIECE JOINTE";
}
$obejt = convertirc($obejt);
$pj = $fichier;
$mail_C->Subject = $obejt;
$mail_C->AltBody = $altbody;
$mail_C->Body=$body;
$mail_C->addAttachment($pj);
if (!$mail_C->send())
{
// echo "Erreur mail : " . $mail_C->ErrorInfo;
}
else
{
// echo "Message envoyé!";
}
// FIN ENVOI DU MAIL AVEC PIECE JOINTE
// supprimons le fichier
unlink ($pj);
}
}