83 lines
3.0 KiB
PHP
83 lines
3.0 KiB
PHP
<?php
|
|
require_once 'Framework/Controleurrequete.php'; // OK
|
|
require_once 'Modele/Statistique.php';
|
|
|
|
class ControleurAjaxdetailrapportspfactureexercicepdf extends Controleur
|
|
{
|
|
private $detailsp;
|
|
|
|
public function __construct() {
|
|
$this->detailsp = new Statistique();
|
|
}
|
|
|
|
public function index()
|
|
{
|
|
$idPolice = $this->requete->getParametreFormulaire("idPolice");
|
|
$debutSinistre = $this->requete->getParametreFormulaire("debutSinistre");
|
|
$finSinistre = $this->requete->getParametreFormulaire("finSinistre");
|
|
|
|
$entete = $this->detailsp->detailrapportsppdfentete($idPolice);
|
|
|
|
$detailsps = $this->detailsp->detailrapportspfactureexercicepdf($idPolice, $debutSinistre, $finSinistre);
|
|
|
|
|
|
$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 SUR UNE PERIODE')),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(_('Période').' : '.$debutSinistre.' '._('au').' '.$finSinistre),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/TMP_FACTURES_SP_EXERCICE"."_".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").' </a> ';
|
|
$t_html .=' </div ';
|
|
echo $t_html;
|
|
}
|
|
} |