18 lines
724 B
PHP
18 lines
724 B
PHP
<?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);
|
|
}
|
|
}
|