<?php
require_once 'Framework/Controleurrequete.php'; // OK
require_once 'Modele/Statistique.php';

class ControleurAjaxdetailrapportspfacturemail 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->detailrapportspfacturepdf($idPolice);
		
		$pdf = new FPDF();

		$pdf->AliasNbPages();
		$pdf->AddPage();

		$pdf->SetMargins(15, 15, 15) ;
		$pdf->SetFont('Arial','BU',10);
		
		// $pdf->AliasNbPages();
		$pdf->Cell(0,6,convertirc($entete['nomAssureur']." : "._('DETAIL DES FACTURES')),0,1,'C',false);		

		$pdf->Ln(2);

		$pdf->SetFont('Arial','B',7);

		$pdf->Cell(0,5,convertirc(_('Souscripteur').' : '.$entete['souscripteur']),0,1,'L',false);
		$pdf->Cell(0,5,convertirc(_('No Police').' : '.$entete['numeroPolice']),0,1,'L',false);
		$pdf->Cell(0,5,convertirc('E-mail : '.$email),0,1,'L',false);
		$pdf->Cell(0,5,convertirc(_('Couverture').' : '.$entete['dateEffetPolice'].' '._('au').' '.$entete['dateFinPolice']),0,1,'L',false);
		$pdf->Cell(0,5,convertirc(_('Date Analyse').' : '.$entete['dateAnalyse']),0,0,'L',false);
		$pdf->Cell(0,5,'Edition : '.heureCouranteLang($_SESSION['lang']),0,1,'R',false);

		$pdf->Ln(2);

		$hl=5;

		$pdf->Cell(50,$hl,convertirc(_('Adhérent')),"1",0,'C');
		$pdf->Cell(50,$hl,convertirc(_('Bénéficiaire')),"1",0,'C');
		$pdf->Cell(15,$hl,convertirc("Date"),"1",0,'C');
		$pdf->Cell(40,$hl,convertirc(_('Prestataire')),"1",0,'C');
		$pdf->Cell(15,$hl,convertirc(_('Montant')),"1",0,'C');
		$pdf->Cell(10,$hl,convertirc(_('No Fact')),"1",1,'C');
		
		$pdf->SetFont('Arial','I',6);
		$montantTotal = 0;
		foreach ($detailsps as $detailsp)
		{
			$pdf->Cell(50,$hl,convertirc($detailsp['adherent']),"1",0,'L');
			$pdf->Cell(50,$hl,convertirc($detailsp['beneficiaire']),"1",0,'L');
			$pdf->Cell(15,$hl,convertirc($detailsp['dateFacture']),"1",0,'C');
			$pdf->Cell(40,$hl,convertirc(substr($detailsp['prestataire'], 0, 30)),"1",0,'L');
			$pdf->Cell(15,$hl,format_N($detailsp['montant']),"1",0,'C');
			$pdf->Cell(10,$hl,convertirc($detailsp['facture']),"1",1,'C');
			$montantTotal = $detailsp['montantTotal'];
		}
		$pdf->SetFont('Arial','BI',6);

		$pdf->Cell(155,$hl,convertirc("TOTAL"),"1",0,'C');
		// $pdf->Cell(15,$hl,format_N($detailsp['montantTotal']),"1",0,'C');
		$pdf->Cell(15,$hl,format_N($montantTotal),"1",0,'C');
		$pdf->Cell(10,$hl,"","1",1,'C');
		
		$fichier="Temp/DETAILS_END_KANE".$dateAnalyse."_".uniqid().".pdf";
		$pdf->Output($fichier,"F");	
		
		// DEBUT ENVOI DU MAIL AVEC PIECE JOINTE
		
		$mail_C = $this->mail_C;
		
		$mail_C->ClearAllRecipients();
		$mail_C->clearAttachments();
		
		// pour envoi à moi seul
		// $email = "kanelazeni@gmail.com";
		// fin envoi à moi seul
		
		$addr = explode(';', $email);
		
		foreach ($addr as $ad)
		{
			if(tester_une_adresse_email($ad))
			{
				$mail_C->AddAddress(trim($ad) );
			}
			else
			{
				// echo "Veuillez revoir cette adresse PHP : " . $ad;
				// exit();
			}
		}
		
		// $mail_C->AddCC("lkane@ebene.info");
		
		$obejt = "DETAILS END : ".$dateAnalyse;
		
		$body = "Dear Customer,

Hope this email find you well,

Attached file is claims report of your staff from starting date up to ".$dateAnalyse."

You can share those information with every one and if any more clarification do not hesitate to contact me for more details.

Kind Regards.";
		
		$altbody = "VOIR PIECE JOINTE";

		$pj = $fichier;

		$mail_C->Subject = $obejt;

		$mail_C->AltBody = $altbody;
		$mail_C->Body=$body;		

		$mail_C->addAttachment($pj);

		// var_dump($mail_C);
		// exit();
		
		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);
    }
}