<?php
require_once '././Framework/Modele.php';
class TbQuittancesociete extends Modele {

    public function quittanceAimprimer($idQuittance) {
		$sql = 'SELECT A.numeroQuittance, A.codeTypeAvenant, B.libelle AS typeavenant, numeroPolice,
		A.codeTypeOperation, C.libelle AS typeoperation, A.numeroAvenant, A.dateEffet, A.dateEcheance, 
		A.dateEmission, A.primeNette, A.primeHt, A.taxe, A.fraisCarte, A.primeTtc, A.commission, A.encaisse, 
		(A.primeTtc-A.encaisse) AS solde, CONCAT(CL.prenoms," ",CL.nom) AS nomClient, CL.boitepostale
		FROM quittance A
		JOIN clients CL ON (CL.id=A.idClient)
		LEFT JOIN typeavenant B ON (B.codeTypeAvenant=A.codeTypeAvenant)
		LEFT JOIN typeoperation C ON  (C.codeTypeOperation=A.codeTypeOperation)
		WHERE A.id=?';

        $quittance = $this->executerRequete($sql, array($idQuittance));
        if ($quittance->rowCount() > 0)
            return $quittance->fetch(PDO::FETCH_ASSOC);
			//return $quittance->fetchAll(PDO::FETCH_ASSOC); (si plusieurs lignes)
        else
            throw new Exception("Aucun quittance ne correspond au id '$idQuittance'");
    }
}