<?php
require_once '././Framework/Modele.php';
class TbBeneficiairequittancesociete extends Modele {
	
    // public function getListe($numeroQuittance) {
	public function recapbenaficiairequittance($idQuittance) {		
		$sql = 'SELECT SUM(CASE WHEN (B.codeLienParente="A") THEN "1" ELSE "0" END) AS nbAdherent,
		SUM(CASE WHEN (B.codeLienParente!="A") THEN "1" ELSE "0" END) AS nbBeneficiaire,
		COUNT(B.codeLienParente) AS nbAssure
		FROM beneficiairequittance A
		JOIN beneficiaire B ON (B.codeSociete=A.codeSociete) AND (B.id=A.idBeneficiaire)
		WHERE (A.idQuittance=?)';

        $quittance = $this->executerRequete($sql, array($idQuittance));
        return $quittance->fetch(PDO::FETCH_ASSOC);
    }
}