219 lines
8.8 KiB
PHP
Executable File
219 lines
8.8 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Controleurrequete.php'; // OK
|
|
require_once 'Modele/Reglement.php';
|
|
|
|
class ControleurAjaximprimerecartdecompte extends Controleurrequete
|
|
{
|
|
private $reglement;
|
|
|
|
public function __construct()
|
|
{
|
|
$this->reglement = new Reglement();
|
|
}
|
|
|
|
public function index()
|
|
{
|
|
$idReglement = $_SESSION['idReglement_C'];
|
|
$reglement = $this->reglement->getreglement($idReglement);
|
|
$recapecartdecompte = $this->reglement->getrecapecartdecompte($idReglement);
|
|
$ecartfactures = $this->reglement->getecartsdecompte("1");
|
|
$ecartnonsaisis = $this->reglement->getecartsdecompte("0");
|
|
|
|
$pdf = new FPDF_Protection();
|
|
$pdf->SetAuthor('EBENE SOLUTIONS INFORMATIQUES');
|
|
$userPassword = '';
|
|
$ownerPassword = null;
|
|
$pdf->SetProtection(['print'], $userPassword, $ownerPassword);
|
|
|
|
$pdf->AliasNbPages();
|
|
$pdf->AddPage();
|
|
|
|
// $_SESSION['nomSociete']
|
|
|
|
$ht=6;
|
|
|
|
$lg1=35;
|
|
$lg2=75;
|
|
$lg3=40;
|
|
$lg4=40;
|
|
|
|
$pdf->SetMargins(10, 10, 10) ;
|
|
|
|
$pdf->SetFont('Arial','BI', 10);
|
|
|
|
$pdf->Cell(0,$ht,convertirc($_SESSION['nomSociete']),0,1,'C',false);
|
|
|
|
$pdf->Ln(5);
|
|
|
|
$pdf->SetFont('Arial','BIU', 10);
|
|
|
|
$pdf->Cell(0,$ht,convertirc(_("DECOMPTE DE REGLEMENT")),0,1,'C',false);
|
|
|
|
$pdf->Ln(5);
|
|
|
|
$pdf->SetFont('Arial','', 8);
|
|
|
|
$pdf->Cell($lg1,$ht,convertirc(_("PRESTATAIRE")),0,0,'L',false);
|
|
$pdf->Cell($lg2,$ht,convertirc(" : ".$reglement['prestataire']),0,0,'L',false);
|
|
|
|
$pdf->Cell($lg3,$ht,convertirc(_("MONTANT FACTURE")),0,0,'L',false);
|
|
$pdf->Cell($lg4,$ht,convertirc(" : ".format_N($reglement['montantPrestataire'])." ".$_SESSION['devise_C']),0,1,'L',false);
|
|
|
|
$pdf->Cell($lg1,$ht,convertirc(_("PERIODE")),0,0,'L',false);
|
|
if (est_anglophone())
|
|
{
|
|
$pdf->Cell($lg2,$ht,convertirc(" : ".$reglement['periodeEng']),0,0,'L',false);
|
|
}
|
|
else
|
|
{
|
|
$pdf->Cell($lg2,$ht,convertirc(" : ".$reglement['periode']),0,0,'L',false);
|
|
}
|
|
|
|
$pdf->Cell($lg3,$ht,convertirc(_("No Lot")),0,0,'L',false);
|
|
$pdf->Cell($lg4,$ht,convertirc(" : ".$reglement['numeroLotDecompte']),0,1,'L',false);
|
|
|
|
|
|
$pdf->Cell($lg1,$ht,convertirc(_("MONTANT A PAYER")),0,0,'L',false);
|
|
$pdf->Cell($lg2,$ht,convertirc(" : ".format_N($reglement['montantApayer'])." ".$_SESSION['devise_C']),0,0,'L',false);
|
|
|
|
$pdf->Cell($lg3,$ht,convertirc(_("MONTANT PAYE")),0,0,'L',false);
|
|
$pdf->Cell($lg4,$ht,convertirc(" : ".format_N($reglement['montantPaye'])." ".$_SESSION['devise_C']),0,1,'L',false);
|
|
|
|
|
|
$pdf->Cell($lg1,$ht,convertirc(_("DATE DE REGLEMENT")),0,0,'L',false);
|
|
$pdf->Cell($lg2,$ht,convertirc(" : ".dateLang($reglement['dateReglement'])),0,1,'L',false);
|
|
|
|
//
|
|
$pdf->Cell($lg1,$ht,convertirc(_("EN NOTRE FAVEUR")),0,0,'L',false);
|
|
$pdf->Cell($lg2,$ht,convertirc(" : ".format_N($recapecartdecompte['montantEcartTotalEnFavAss'])." ".$_SESSION['devise_C']),0,0,'L',false);
|
|
|
|
$pdf->Cell($lg3,$ht,convertirc(_("EN SA FAVEUR")),0,0,'L',false);
|
|
$pdf->Cell($lg4,$ht,convertirc(" : ".format_N($recapecartdecompte['montantEcartTotalEnFavPrest'])." ".$_SESSION['devise_C']),0,1,'L',false);
|
|
|
|
// $pdf->Ln(5);
|
|
|
|
$pdf->SetFont('Arial','BIU', 10);
|
|
|
|
$pdf->Cell(0,$ht,convertirc(_("RAISONS DES DISCORDANCES")),0,1,'C',false);
|
|
|
|
// $pdf->SetFont('Arial','B', 8);
|
|
$pdf->SetFont('Arial','', 8);
|
|
|
|
$pdf->Cell(85,$ht,convertirc(_("Différences entre décompte et réclamation prestataire")),1,0,'C',false);
|
|
$pdf->Cell(20,$ht,convertirc(_("Nb Factures")),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,convertirc(_("Montants Prestataire")),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,convertirc(_("Montants Assureur")),1,0,'C',false);
|
|
$pdf->Cell(25,$ht,convertirc(_("Différences")),1,1,'C',false);
|
|
|
|
// $pdf->SetFont('Arial','', 8);
|
|
|
|
$pdf->Cell(85,$ht,convertirc(_("Décompte Système")),1,0,'C',false);
|
|
$pdf->Cell(20,$ht,format_N($reglement['ndFacture']),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,format_N($reglement['montantPrestataire']),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,format_N($reglement['montantApayer']),1,0,'C',false);
|
|
$pdf->Cell(25,$ht,format_N($reglement['montantRedresse']),1,1,'C',false);
|
|
|
|
$pdf->Cell(85,$ht,convertirc(_("Total Différences")),1,0,'C',false);
|
|
$pdf->Cell(20,$ht,format_N($recapecartdecompte['nbTotal']),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,format_N($recapecartdecompte['montantPrestataireTotal']),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,format_N($recapecartdecompte['montantAssureurTotal']),1,0,'C',false);
|
|
$pdf->Cell(25,$ht,format_N($recapecartdecompte['montantEcartTotal']),1,1,'C',false);
|
|
|
|
$pdf->Cell(85,$ht,convertirc(_("Différences sur factures saisies dans le système")),1,0,'C',false);
|
|
$pdf->Cell(20,$ht,format_N($recapecartdecompte['nbTotalFacture']),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,format_N($recapecartdecompte['montantPrestataireTotalFacture']),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,format_N($recapecartdecompte['montantAssureurTotalFacture']),1,0,'C',false);
|
|
$pdf->Cell(25,$ht,format_N($recapecartdecompte['montantEcartTotalFacture']),1,1,'C',false);
|
|
|
|
$pdf->Cell(85,$ht,convertirc(_("Différences sur factures hors système")),1,0,'C',false);
|
|
$pdf->Cell(20,$ht,format_N($recapecartdecompte['nbTotalNonsaisi']),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,format_N($recapecartdecompte['montantPrestataireTotalNonsaisi']),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,format_N($recapecartdecompte['montantAssureurTotalNonsaisi']),1,0,'C',false);
|
|
$pdf->Cell(25,$ht,format_N($recapecartdecompte['montantEcartTotalNonsaisi']),1,1,'C',false);
|
|
|
|
$pdf->Cell(85,$ht,convertirc(_("En faveur du prestataire")),1,0,'C',false);
|
|
$pdf->Cell(20,$ht,format_N($recapecartdecompte['nbTotalEnFavPrest']),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,format_N($recapecartdecompte['montantEcartTotalEnFavPrest']),1,1,'C',false);
|
|
|
|
$pdf->Cell(85,$ht,convertirc(_("En faveur de l'assureur")),1,0,'C',false);
|
|
$pdf->Cell(20,$ht,format_N($recapecartdecompte['nbTotalEnFavAss']),1,0,'C',false);
|
|
$pdf->Cell(30,$ht,format_N($recapecartdecompte['montantEcartTotalEnFavAss']),1,1,'C',false);
|
|
|
|
$pdf->Ln(5);
|
|
|
|
$pdf->SetFont('Arial','BIU', 10);
|
|
$pdf->Cell(0,$ht,convertirc(_("DETAILS SAISIES DANS LE SYSTEME")),0,1,'C',false);
|
|
$pdf->SetFont('Arial','BI', 6);
|
|
|
|
$pdf->Cell(15,$ht,convertirc("Date"),1,0,'C',false);
|
|
$pdf->Cell(50,$ht,convertirc(_("Bénéficiaire")),1,0,'C',false);
|
|
$pdf->Cell(15,$ht,convertirc(_("Prestataire")),1,0,'C',false);
|
|
$pdf->Cell(15,$ht,convertirc(_("Assureur")),1,0,'C',false);
|
|
$pdf->Cell(15,$ht,convertirc(_("Différence")),1,0,'C',false);
|
|
$pdf->Cell(20,$ht,convertirc(_("Sens")),1,0,'C',false);
|
|
$pdf->Cell(60,$ht,convertirc("Observations"),1,1,'C',false);
|
|
|
|
$pdf->SetFont('Arial','', 6);
|
|
|
|
foreach ($ecartfactures as $facture)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$libelleEcart = $facture['libelleEcartEng'];
|
|
}
|
|
else
|
|
{
|
|
$libelleEcart = $facture['libelleEcart'];
|
|
}
|
|
$pdf->Cell(15,$ht,dateLang($facture['dateFacture']),1,0,'C',false);
|
|
$pdf->Cell(50,$ht,convertirc($facture['numeroBeneficiaire']." ".$facture['beneficiaire']),1,0,'L',false);
|
|
$pdf->Cell(15,$ht,format_N($facture['montantPrestataire']),1,0,'C',false);
|
|
$pdf->Cell(15,$ht,format_N($facture['montantAssureur']),1,0,'C',false);
|
|
$pdf->Cell(15,$ht,format_N($facture['montantEcart']),1,0,'C',false);
|
|
$pdf->Cell(20,$ht,convertirc($libelleEcart),1,0,'C',false);
|
|
$pdf->Cell(60,$ht,convertirc($facture['observations']),1,1,'C',false);
|
|
}
|
|
|
|
// HOSRS SYSTEME
|
|
$pdf->Ln(5);
|
|
|
|
$pdf->SetFont('Arial','BIU', 10);
|
|
$pdf->Cell(0,$ht,convertirc(_("NON SAISIES DANS LE SYSTEME")),0,1,'C',false);
|
|
$pdf->SetFont('Arial','BI', 6);
|
|
|
|
$pdf->Cell(20,$ht,convertirc("Date"),1,0,'C',false);
|
|
$pdf->Cell(60,$ht,convertirc(_("Bénéficiaire")),1,0,'C',false);
|
|
$pdf->Cell(20,$ht,convertirc(_("Montant")),1,0,'C',false);
|
|
$pdf->Cell(25,$ht,convertirc(_("Sens")),1,0,'C',false);
|
|
$pdf->Cell(65,$ht,convertirc("Observations"),1,1,'C',false);
|
|
|
|
$pdf->SetFont('Arial','', 6);
|
|
|
|
foreach ($ecartnonsaisis as $facture)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$libelleEcart = $facture['libelleEcartEng'];
|
|
}
|
|
else
|
|
{
|
|
$libelleEcart = $facture['libelleEcart'];
|
|
}
|
|
$pdf->Cell(20,$ht,dateLang($facture['dateFacture']),1,0,'C',false);
|
|
$pdf->Cell(60,$ht,convertirc($facture['numeroBeneficiaire']." ".$facture['beneficiaire']),1,0,'L',false);
|
|
$pdf->Cell(20,$ht,format_N($facture['montantPrestataire']),1,0,'C',false);
|
|
$pdf->Cell(25,$ht,convertirc($libelleEcart),1,0,'C',false);
|
|
$pdf->Cell(65,$ht,convertirc($facture['observations']),1,1,'C',false);
|
|
}
|
|
|
|
$fichier="Temp/TMP_differecnes_decompte"."_".uniqid().".pdf";
|
|
$pdf->Output($fichier,"F");
|
|
|
|
$t_html =' <div id ="div_export_ecart_decompte" class="alert alert-info"> ';
|
|
$t_html .=' <a style="font-size:15pt;" href="'.$fichier.'" target="_blank" > '._("TELECHARGER").' </a> ';
|
|
$t_html .=' </div ';
|
|
echo $t_html;
|
|
|
|
exit();
|
|
}
|
|
} |