2674 lines
86 KiB
PHP
Executable File
2674 lines
86 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
|
|
class Beneficiaire extends Modele {
|
|
|
|
public function getBeneficiaireVide() {
|
|
|
|
viderContexte();
|
|
|
|
$sql = 'call sp_r_recherche_beneficiaire_vide();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat ->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
// return $beneficiaire;
|
|
}
|
|
|
|
public function getBeneficiaires($nomBeneficiaire, $prenomsBeneficiaire, $telephonePortable, $email)
|
|
{
|
|
$nomBeneficiaire = contruireParamLike($nomBeneficiaire);
|
|
$prenomsBeneficiaire = contruireParamLike($prenomsBeneficiaire);
|
|
$telephonePortable = contruireParamLike($telephonePortable);
|
|
$email = contruireParamLike($email);
|
|
|
|
$sql = 'call sp_get_beneficiaires(?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'], $nomBeneficiaire, $prenomsBeneficiaire, $telephonePortable, $email));
|
|
|
|
return $resultat ->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function getBeneficiairesAdh($numeroAdherent) {
|
|
$sql = 'call sp_r_recherche_beneficiaire_no_adh(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'], $numeroAdherent));
|
|
return $resultat ->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
// return $beneficiaires;
|
|
}
|
|
|
|
public function getBeneficiaire($numeroBeneficiaire)
|
|
{
|
|
|
|
$sql = 'call sp_r_recherche_beneficiaire_no(?, ?);';
|
|
|
|
$resultat= $this->executerRequete($sql, array($_SESSION['codeSociete'], $numeroBeneficiaire));
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
// return $beneficiaire;
|
|
}
|
|
|
|
public function getBeneficiaireId($idBeneficiaire)
|
|
{
|
|
$sql = 'call sp_get_beneficiaire_id(?);';
|
|
$beneficiaire = $this->executerRequete($sql, array($idBeneficiaire));
|
|
return $beneficiaire->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function getPrimeBeneficiaire($idBeneficiaire)
|
|
{
|
|
$sql = 'call sp_get_prime_beneficiaire(?);';
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire));
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getNombreBeneficiaires()
|
|
{
|
|
$sql = 'select count(*) as nbBeneficiaires FROM adherent A WHERE (A.codeSociete=?)';
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete']));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $ligne['nbBeneficiaires'];
|
|
}
|
|
|
|
public function getIdBeneficiaire($numeroBeneficiaire) {
|
|
$sql = 'SELECT id FROM beneficiaire WHERE (codeSociete=?) AND (numeroBeneficiaire=?)';
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'], $numeroBeneficiaire));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $ligne['id'];
|
|
}
|
|
|
|
public function getIdPremierBeneficiaire($idAdherent) {
|
|
$sql = 'SELECT id FROM beneficiaire WHERE (idAdherent=?)';
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $ligne['id'];
|
|
}
|
|
|
|
public function getContexteBeneficiaireId($id)
|
|
{
|
|
|
|
$sql = 'call sp_r_get_beneficiaire_id(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($id));
|
|
$context = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$_SESSION['idClient_C'] = $context['idClient'];
|
|
$_SESSION['numeroClient_C'] = $context['numeroClient'];
|
|
$_SESSION['nomClient_C'] = $context['nomClient'];
|
|
$_SESSION['codeLangueClient'] = $context['codeLangueClient'];
|
|
$_SESSION['codeLangueAdherent'] = $context['codeLangueAdherent'];
|
|
|
|
$_SESSION['idPolice_C'] = $context['idPolice'];
|
|
$_SESSION['numeroPolice_C'] = $context['numeroPolice'];
|
|
|
|
$_SESSION['codeGcAssureur_C'] = $context['codeGcAssureur'];
|
|
$_SESSION['nomGcAssureur_C'] = $context['garant'];
|
|
|
|
$_SESSION['idAdherent_C'] = $context['idAdherent'];
|
|
$_SESSION['numeroAdherent_C'] = $context['numeroAdherent'];
|
|
$_SESSION['nomAdherent_C'] = $context['nomAdherent'];
|
|
$_SESSION['idCollege_C'] = $context['idCollege'];
|
|
|
|
$_SESSION['idBeneficiaire_C'] = $context['idBeneficiaire'];
|
|
$_SESSION['numeroBeneficiaire_C'] = $context['numeroBeneficiaire'];
|
|
$_SESSION['nomBeneficiaire_C'] = $context['nomBeneficiaire'];
|
|
$_SESSION['email_C'] = $context['email'];
|
|
$_SESSION['telephonePortable_C'] = $context['telephonePortable'];
|
|
$_SESSION['lienPhoto_C'] = $context['lienPhoto'];
|
|
$_SESSION['codeLienParente_C'] = $context['codeLienParente'];
|
|
|
|
$_SESSION['codeEtatBeneficiaire_C'] = $context['codeEtatBeneficiaire'];
|
|
$_SESSION['codeEtatAdherent_C'] = $context['codeEtatAdherent'];
|
|
$_SESSION['exercieReference_C'] = $context['exercieReference'];
|
|
$_SESSION['idEntetecontrat'] = $context['idEntetecontrat'];
|
|
|
|
$_SESSION['codeLocalite'] = $context['codeLocalite'];
|
|
|
|
$_SESSION['dateEffetInitialPolice_C'] = $context['dateEffetInitialPolice'];
|
|
$_SESSION['dateAvenantPolice_C'] = $context['dateAvenantPolice'];
|
|
|
|
///////////////////////////////////////////////////////////////
|
|
$_SESSION['dateEntreeBeneficiaire_C'] = $context['dateEntreeBeneficiaire'];
|
|
$_SESSION['dateEffetPolice_C'] = $context['dateEffetPolice'];
|
|
|
|
|
|
////////////////////////////////////////////////////////////////////
|
|
$_SESSION['baseTarification_C'] = $context['baseTarification'];
|
|
|
|
// $_SESSION['etatbeneficiaire_C'] = $context['etatbeneficiaire'];
|
|
if (est_anglophone())
|
|
{
|
|
$_SESSION['etatbeneficiaire_C'] = $context['etatbeneficiaireEng'];
|
|
}
|
|
else
|
|
{
|
|
$_SESSION['etatbeneficiaire_C'] = $context['etatbeneficiaire'];
|
|
}
|
|
|
|
$_SESSION['adherent_C'] = $context['nomAdherent'];
|
|
$_SESSION['beneficiaire_C'] = $context['nomBeneficiaire'];
|
|
$_SESSION['enVigueur_C'] = $context['enVigueur'];
|
|
|
|
$_SESSION['decede_C'] = $context['decede'];
|
|
$_SESSION['dateDeces_C'] = $context['dateDeces'];
|
|
$_SESSION['fraisFuneraireDemande_C'] = $context['fraisFuneraireDemande'];
|
|
$_SESSION['fraisFunerairePaye_C'] = $context['fraisFunerairePaye'];
|
|
|
|
$_SESSION['dateEcheancePolice_C'] = $context['dateEcheancePolice'];
|
|
|
|
$_SESSION['garantieArchive_C'] = $context['garantieArchive'];
|
|
|
|
$_SESSION['faceRegistered_C'] = $context['faceRegistered'];
|
|
|
|
$_SESSION['nomPolice_C'] = $context['libellePolice'];
|
|
$_SESSION['nomCollege_C'] = $context['libelleCollege'];
|
|
|
|
$photo = "";
|
|
$_SESSION['photoAssureCrypte'] = "";
|
|
|
|
// vérifier que la photo du bénéficiaire existe
|
|
if ($_SESSION['lienPhoto_C']>" ")
|
|
{
|
|
$photo = $_SESSION['lienPhotoFace'].$_SESSION['lienPhoto_C'];
|
|
if(!file_exists($photo))
|
|
{
|
|
$_SESSION['lienPhoto_C'] = "";
|
|
}
|
|
else
|
|
{
|
|
$_SESSION['photoAssureCrypte'] = decryptImage($photo);
|
|
}
|
|
}
|
|
}
|
|
|
|
public function getContexteBeneficiaireAssure($id) {
|
|
$sql = 'SELECT A.idAdherent, A.numeroAdherent, B.telephonePortable,
|
|
concat(B.prenomsAdherent," ",B.nomAdherent) as nomAdherent,
|
|
A.id as idBeneficiaire, A.numeroBeneficiaire, B.email, A.lienPhoto,
|
|
concat(A.prenomsBeneficiaire," ",A.nomBeneficiaire) as nomBeneficiaire, codeLienParente, Cl.garantieArchive
|
|
FROM beneficiaire A
|
|
JOIN adherent B ON (B.id=A.idAdherent)
|
|
left join college Cl on (Cl.id=A.idCollege)
|
|
WHERE (A.idAdherent=?) AND(A.id=?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['idAdherent_C'], $id));
|
|
|
|
if ($resultat->rowCount()==0)
|
|
{
|
|
$sql = 'SELECT A.idAdherent, A.numeroAdherent, B.telephonePortable,
|
|
concat(B.prenomsAdheren," ",B.nomAdherent) as nomAdherent, A.enVigueur,
|
|
A.id as idBeneficiaire, A.numeroBeneficiaire, B.email, A.lienPhoto,
|
|
concat(A.prenomsBeneficiaire," ",A.nomBeneficiaire) as nomBeneficiaire, codeLienParente,
|
|
A.decede, A.dateDeces, A.fraisFuneraireDemande, A.fraisFunerairePaye, Cl.garantieArchive
|
|
FROM beneficiaire A
|
|
JOIN adherent B ON (B.id=A.idAdherent)
|
|
left join college Cl on (Cl.id=A.idCollege)
|
|
WHERE (A.idAdherent=?)
|
|
AND (A.codeLienParente="A")';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['idAdherent_C']));
|
|
}
|
|
$context = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$_SESSION['idBeneficiaire_C'] = $context['idBeneficiaire'];
|
|
$_SESSION['numeroBeneficiaire_C'] = $context['numeroBeneficiaire'];
|
|
$_SESSION['nomBeneficiaire_C'] = $context['nomBeneficiaire'];
|
|
$_SESSION['email_C'] = $context['email'];
|
|
$_SESSION['telephonePortable_C'] = $context['telephonePortable'];
|
|
$_SESSION['lienPhoto_C'] = $context['lienPhoto'];
|
|
$_SESSION['codeLienParente_C'] = $context['codeLienParente'];
|
|
$_SESSION['beneficiaire_C'] = $context['nomBeneficiaire'];
|
|
$_SESSION['enVigueur_C'] = $context['enVigueur'];
|
|
|
|
$_SESSION['decede_C'] = $context['decede'];
|
|
$_SESSION['dateDeces_C'] = $context['dateDeces'];
|
|
$_SESSION['fraisFuneraireDemande_C'] = $context['fraisFuneraireDemande'];
|
|
$_SESSION['fraisFunerairePaye_C'] = $context['fraisFunerairePaye'];
|
|
$_SESSION['garantieArchive_C'] = $context['garantieArchive'];
|
|
|
|
// vérifier que la photo du bénéficiaire existe
|
|
if ($_SESSION['lienPhoto_C']>" ")
|
|
{
|
|
if(!file_exists($_SESSION['dossierSociete'].'/Photos/'.$_SESSION['lienPhoto_C']))
|
|
{
|
|
$_SESSION['lienPhoto_C'] = "";
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
public function getContexteAdherentId($id) {
|
|
$sql = 'SELECT A.id AS idAdherent, A.numeroAdherent, A.nom AS nomAdherent, A.prenoms AS prenomsAdherent,
|
|
CONCAT(A.nom," ",A.prenoms) AS nomCompletAdherent, telephonePortable, email,
|
|
codeProduit, idCollege, fn_exercice_adherent(A.id, A.dateEffet) AS exercieReference,
|
|
fn_id_entetecontrat_police(A.idPolice, A.dateEffet) AS idEntetecontrat
|
|
FROM adherent A WHERE (A.codeSociete=?) AND (A.id=?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'], $id));
|
|
$context = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$_SESSION['idAdherent_C'] = $context['idAdherent'];
|
|
$_SESSION['numeroAdherent_C'] = $context['numeroAdherent'];
|
|
$_SESSION['nomAdherent_C'] = $context['nomAdherent'];
|
|
$_SESSION['codeProduit_C'] = $context['codeProduit'];
|
|
$_SESSION['idCollege_C'] = $context['idCollege'];
|
|
|
|
$_SESSION['adherent_C'] = $context['nomCompletAdherent'];
|
|
$_SESSION['exercieReference_C'] = $context['exercieReference'];
|
|
$_SESSION['idEntetecontrat'] = $context['idEntetecontrat'];
|
|
}
|
|
|
|
public function existeligne($numeroAdherent) {
|
|
$sql = 'select id FROM adherent WHERE (codeSociete=?) and (numeroAdherent=?)';
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'],$numeroAdherent));
|
|
return ($resultat->rowCount() > 0);
|
|
}
|
|
|
|
public function ajouter($idAdherent, $numeroBeneficiaire, $nomBeneficiaire, $prenomsBeneficiaire, $codeLienParente,
|
|
$codeNaturePiece, $numeroPiece, $sexe, $codeGroupeSanguin, $dateNaissance, $telephonePortable, $dateEntree, $dateCre,
|
|
$user, $idAvenant, $fraisCarte, $numeroCmu, $numeroMatricule, $prorata, $codeTarifActe, $dateSouscription, $vip,
|
|
$seuilRdBeneficiaire, $numeroBs, $ancienNumeroAssure, $conserverAncienNumeroAssure, $codeTypeRemboursement)
|
|
{
|
|
$sql = 'CALL sp_ajouter_beneficiaire(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idAdherent, $numeroBeneficiaire, $nomBeneficiaire, $prenomsBeneficiaire, $codeLienParente,
|
|
$codeNaturePiece, $numeroPiece, $sexe, $codeGroupeSanguin, $dateNaissance, $telephonePortable, $dateEntree, $dateCre, $user,
|
|
$idAvenant, $fraisCarte, $numeroCmu, $numeroMatricule, $prorata, $codeTarifActe, $dateSouscription, $vip, $seuilRdBeneficiaire,
|
|
$numeroBs, $ancienNumeroAssure, $conserverAncienNumeroAssure, $codeTypeRemboursement));
|
|
|
|
$sql = 'SELECT MAX(id) AS dernierIdBeneficiaire FROM beneficiaire WHERE idAdherent=?';
|
|
$resultat = $this->executerRequete($sql,array($idAdherent))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$dernierId = $resultat['dernierIdBeneficiaire'];
|
|
|
|
|
|
$sql = 'CALL sp_ajouter_beneficiaireprime(?);';
|
|
$this->executerRequete($sql, array($dernierId));
|
|
|
|
$sql = 'delete from beneficiaire_temp where (`user`=?)';
|
|
$this->executerRequete($sql, array($user));
|
|
|
|
// On va cumuler plafond frais funéraire et complément frais funéraire
|
|
$sql = 'call sp_maj_plafond_funeraire(?);';
|
|
$this->executerRequete($sql, array($idAdherent));
|
|
//
|
|
|
|
return $dernierId;
|
|
}
|
|
|
|
public function modifier($nomBeneficiaire, $prenomsBeneficiaire, $codeLienParente, $codeNaturePiece, $numeroPiece,
|
|
$sexe, $codeGroupeSanguin, $dateNaissance, $telephonePortable, $dateEntree, $primeFamille, $primeBeneficiaire, $numeroCmu,
|
|
$numeroMatricule, $codeTarifActe, $dateSouscription, $vip, $seuilRdBeneficiaire, $numeroBs, $codeTypeRemboursement, $id)
|
|
{
|
|
|
|
$sql = 'CALL sp_modifier_beneficiaire(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);';
|
|
|
|
$this->executerRequete($sql, array($nomBeneficiaire, $prenomsBeneficiaire, $codeLienParente, $codeNaturePiece, $numeroPiece,
|
|
$sexe, $codeGroupeSanguin, $dateNaissance, $telephonePortable, $dateEntree, $primeFamille, $primeBeneficiaire, $numeroCmu,
|
|
$numeroMatricule, $codeTarifActe, $dateSouscription, $vip, $seuilRdBeneficiaire, $numeroBs, $codeTypeRemboursement, $id));
|
|
|
|
$user = $_SESSION['login'];
|
|
$sql = 'CALL sp_modifier_beneficiaireprime(?, ?);';
|
|
$this->executerRequete($sql, array($id, $user));
|
|
}
|
|
|
|
public function supprimer($idBeneficiaire) {
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_supprimer_beneficiaire(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $user));
|
|
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$this->getNbassure($idPolice);
|
|
}
|
|
|
|
public function supprimerempreinte($motif)
|
|
{
|
|
$idBeneficiaire = $_SESSION['idBeneficiaire_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_supprimer_empreinte(?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idBeneficiaire, $user, $motif));
|
|
}
|
|
|
|
public function formaterNumeroAdherent($racineNoAdherent,$numeroAdherent)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
/*
|
|
$numeroAdherent = "000000".$numeroAdherent;
|
|
$numeroAdherent = substr($numeroAdherent, -7);
|
|
$numeroAdherent = $racineNoAdherent.$numeroAdherent;
|
|
return $numeroAdherent;
|
|
*/
|
|
|
|
$sql = 'call sp_formater_numero_adherent(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice));
|
|
|
|
$adh = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$numeroAdherent = $adh['numeroAdherent'];
|
|
|
|
return $numeroAdherent;
|
|
|
|
}
|
|
|
|
public function ajouterAdherent($idAdherent)
|
|
{
|
|
|
|
$sql = 'call sp_enregistrer_premier_beneficiaire(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$dernierIdBeneficiaire = $ligne['dernierIdBeneficiaire'];
|
|
return $dernierIdBeneficiaire;
|
|
}
|
|
|
|
public function getBeneficiairesId($id)
|
|
{
|
|
$sql = 'call sp_get_beneficiaires_adherent(?, ?);';
|
|
|
|
$beneficiaires = $this->executerRequete($sql, array($_SESSION['codeSociete'], $id));
|
|
|
|
return $beneficiaires->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getBeneficiairesAfacturer($idPolice)
|
|
{
|
|
$sql = 'call sp_beneficiaires_a_facturer(?)';
|
|
|
|
$beneficiaires = $this->executerRequete($sql, array($idPolice));
|
|
|
|
return $beneficiaires->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getTotalAfacturer($idPolice)
|
|
{
|
|
$sql = 'call sp_total_beneficiaires_a_facturer(?)';
|
|
|
|
$totaafacturer = $this->executerRequete($sql, array($idPolice));
|
|
|
|
return $totaafacturer->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getNbAfacturer($idPolice) {
|
|
$sql = 'select count(*) as nb FROM beneficiaire A WHERE (A.idPolice=?)
|
|
AND (A.codeEtatFacturation ="9") AND (A.primeTtc!=0)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $ligne['nb'];
|
|
}
|
|
|
|
public function selectionfacturation($idBeneficiairePrime, $choix)
|
|
{
|
|
// $sql = 'update beneficiaire set codeEtatFacturation=? WHERE (id=?)';
|
|
|
|
$sql = 'call sp_select_un_beneficiaire_a_facturer(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idBeneficiairePrime, $choix));
|
|
|
|
}
|
|
|
|
public function selectionnertout($idPolice, $choix)
|
|
{
|
|
$sql = 'call sp_select_beneficiaire_a_facturer(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $choix));
|
|
}
|
|
|
|
public function majEtatFacturation($idPolice, $numeroEmission, $idEmission)
|
|
{
|
|
/*
|
|
$sql = 'INSERT INTO beneficiairequittance (codeSociete, idEmission, numeroEmission, idBeneficiaire,
|
|
numeroBeneficiaire, primeNette, commission, primeHt, taxe, fraisCarte, primeTtc, idPolice)
|
|
|
|
SELECT codeSociete, ? AS idEmission, ? AS numeroEmission, id AS idBeneficiaire, numeroBeneficiaire,
|
|
primeNette, commission, primeHt, taxe, fraisCarte, primeTtc, A.idPolice
|
|
FROM beneficiaire A WHERE (A.codeSociete=?) AND (A.idPolice=?)
|
|
AND (A.codeEtatFacturation ="9") AND (A.primeTtc!=0)';
|
|
|
|
$this->executerRequete($sql, array($idEmission, $numeroEmission, $_SESSION['codeSociete'], $idPolice));
|
|
|
|
$sql = 'update beneficiaire set codeEtatFacturation="1" WHERE (codeSociete=?) AND (idPolice=?)
|
|
AND (codeEtatFacturation="9") AND (primeTtc!=0)';
|
|
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $idPolice));
|
|
*/
|
|
|
|
$sql = 'call sp_maj_etat_facturation(?, ?, ?);';
|
|
$this->executerRequete($sql, array($idPolice, $numeroEmission, $idEmission));
|
|
}
|
|
|
|
public function getDenierNumeroBeneficiaire($idAdherent)
|
|
{
|
|
$sql = 'select dernierNumeroBeneficiaire from adherent WHERE (id=?)';
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $ligne['dernierNumeroBeneficiaire'];
|
|
}
|
|
|
|
public function setDenierNumeroBeneficiaire($idAdherent, $dernierNumeroBeneficiaire)
|
|
{
|
|
$sql = 'update adherent set dernierNumeroBeneficiaire=? WHERE (id=?)';
|
|
$this->executerRequete($sql, array($dernierNumeroBeneficiaire, $idAdherent));
|
|
}
|
|
|
|
|
|
public function changerPhoto($id, $nomImage)
|
|
{
|
|
$sql = 'update beneficiaire set lienPhoto=? WHERE (id=?)';
|
|
$this->executerRequete($sql, array($nomImage, $id));
|
|
}
|
|
|
|
public function getListeAssure() {
|
|
$numeroAdherent = $_SESSION['numeroAdherent_C'];
|
|
$sql = 'SELECT numeroBeneficiaire as `code`, prenomsBeneficiaire AS libelle
|
|
FROM beneficiaire WHERE numeroAdherent=? ORDER BY 2';
|
|
|
|
$liste = $this->executerRequete($sql, array($numeroAdherent));
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function Rqlisteassure($numeroBeneficiaire1, $numeroBeneficiaire2, $nomBeneficiaire,
|
|
$prenomsBeneficiaire, $date1, $date2, $date3, $date4)
|
|
{
|
|
$nomBeneficiaire = contruireParamLike($nomBeneficiaire);
|
|
$prenomsBeneficiaire = contruireParamLike($prenomsBeneficiaire);
|
|
|
|
If($numeroBeneficiaire1=="0")
|
|
{
|
|
$numeroBeneficiaire1="";
|
|
}
|
|
|
|
$sql = 'SELECT B.nomAdherent, B.prenomsAdherent, B.numeroAdherent, B.numeroPolice,
|
|
B.policeAssistance, A.numeroBeneficiaire, A.prenomsBeneficiaire, A.nomBeneficiaire,
|
|
A.codeLienParente, A.codeSexe,
|
|
DATE_FORMAT(A.dateNaissance, "%d/%m/%Y") AS dateNaissance_fr,
|
|
fn_age(A.dateNaissance) as age,
|
|
DATE_FORMAT(A.dateEntree, "%d/%m/%Y") AS dateEntree_fr,
|
|
DATE_FORMAT(A.dateSortie, "%d/%m/%Y") AS dateSortie_fr
|
|
FROM beneficiaire A
|
|
JOIN adherent B ON (B.id=A.idAdherent)
|
|
WHERE (A.numeroBeneficiaire BETWEEN ? AND ?)
|
|
AND (A.nomBeneficiaire LIKE ?) AND (A.prenomsBeneficiaire LIKE ?)
|
|
AND (A.dateNaissance BETWEEN ? AND ?) AND (A.dateEntree BETWEEN ? AND ?)
|
|
ORDER BY B.nomAdherent, B.prenomsAdherent, A.codeLienParente,
|
|
A.prenomsBeneficiaire, A.nomBeneficiaire';
|
|
|
|
$liste = $this->executerRequete($sql, array($numeroBeneficiaire1, $numeroBeneficiaire2, $nomBeneficiaire,
|
|
$prenomsBeneficiaire, $date1, $date2, $date3, $date4));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function imposerprime($idAdherent, $idBeneficiaire, $primeNette, $commission, $commissionAutre, $primeHt, $accessoire,
|
|
$taxe, $fraisCarte, $primeTtc, $primeNetteStat)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_imposer_prime_beneficiaire(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idAdherent, $idBeneficiaire, $primeNette, $commission, $commissionAutre, $accessoire, $primeHt,
|
|
$taxe, $fraisCarte, $primeTtc, $primeNetteStat, $user));
|
|
}
|
|
|
|
public function getTotalBeneficiairesId($idAdherent) {
|
|
$sql = 'select IFNULL(sum(primeNette),"0") as primeNette, IFNULL(sum(commission),"0") as commission,
|
|
IFNULL(sum(primeHt),"0") as primeHt, IFNULL(sum(taxe),"0") as taxe,
|
|
IFNULL(sum(fraisCarte),"0") as fraisCarte, IFNULL(sum(primeTtc),"0") as primeTtc
|
|
FROM beneficiaire A WHERE (idAdherent=?) and (A.supprime!="1")';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
// return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getNbassure($idPolice) {
|
|
// nb famille et de dépendants
|
|
$sql = 'select
|
|
ifnull(sum(case when codeLienParente="A" then "1" else "0" end), "0") as ndAdh,
|
|
ifnull(SUM(case when codeLienParente="A" then "0" else "1" end), "0") as ndDep,
|
|
ifnull(SUM(case when codeEtatBeneficiaire="V" then "1" else "0" end), "0") as ndActif
|
|
from beneficiaire where (codeSociete=?) AND (idPolice=?) and (supprime!="1")';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'], $idPolice));
|
|
$effectif = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$_SESSION['ndAdh_C'] = $effectif['ndAdh'];
|
|
$_SESSION['ndDep_C'] = $effectif['ndDep'];
|
|
$_SESSION['ndActif_C'] = $effectif['ndActif'];
|
|
}
|
|
|
|
public function getBeneficiairesAexporter($idPolice, $dateAnalyse)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_export_assure_eng(?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_export_assure(?, ?);';
|
|
}
|
|
|
|
$beneficiaires = $this->executerRequete($sql, array($idPolice, $dateAnalyse));
|
|
|
|
return $beneficiaires->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getBeneficiairesAexporterSansFormat($idPolice, $dateAnalyse)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_export_assure_sans_format_eng(?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_export_assure_sans_format(?, ?);';
|
|
}
|
|
|
|
$beneficiaires = $this->executerRequete($sql, array($idPolice, $dateAnalyse));
|
|
return $beneficiaires->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getBeneficiairesAimprimer($idPolice, $dateAnalyse)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_imprimer_assure_eng(?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_imprimer_assure(?, ?);';
|
|
}
|
|
|
|
$beneficiaires = $this->executerRequete($sql, array($idPolice, $dateAnalyse));
|
|
|
|
return $beneficiaires->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEnteteBeneficiairesAimprimer($idPolice)
|
|
{
|
|
$sql = 'call sp_entete_liste_assure(?);';
|
|
|
|
$entete = $this->executerRequete($sql, array($idPolice));
|
|
return $entete->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEnteteBeneficiairesAimprimerold($idPolice, $dateAnalyse)
|
|
{
|
|
$sql = 'call sp_police_enteteNews_rp(?,?);';
|
|
|
|
$entete_old = $this->executerRequete($sql, array($idPolice, $dateAnalyse));
|
|
return $entete_old->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function changeretat($idbeneficiaire, $codeEtatbeneficiaire, $motifEtat, $dateEtat, $codeEtatBeneficiaireOld)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$sql = 'call sp_changer_etat_beneficiaire(?, ?, ?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idbeneficiaire, $codeEtatbeneficiaire, $motifEtat, $dateEtat, $user, $codeEtatBeneficiaireOld));
|
|
}
|
|
|
|
public function majdatesortie($idbeneficiaire, $dateSortie, $motifSortie)
|
|
{
|
|
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_maj_date_sortie(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idbeneficiaire, $user, $dateSortie, $motifSortie));
|
|
}
|
|
|
|
public function getBeneficiairesActifs($dateAnalyse)
|
|
{
|
|
$sql = 'call sp_assures_actifs(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($dateAnalyse));
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function getBeneficiairesActifsExport($dateAnalyse)
|
|
{
|
|
$sql = 'call sp_assures_actifs_export(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($dateAnalyse));
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getempreintesupprimers()
|
|
{
|
|
$idBeneficiaire = $_SESSION['idBeneficiaire_C'];
|
|
|
|
$sql = 'call sp_empreintes_supprimees(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function gethistoempreintesupprimers($debut, $fin)
|
|
{
|
|
$sql = 'call sp_histo_suppression_empreintes(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getModeleAssures()
|
|
{
|
|
$sql = 'CALL sp_export_modele_assure();';
|
|
|
|
$beneficiaires = $this->executerRequete($sql);
|
|
|
|
return $beneficiaires->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function initIinsererLigneModeleAssure()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_init_inserer_ligne_modele_assure(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $user));
|
|
}
|
|
|
|
public function insererLigneModeleAssure($idAvenant, $categorie, $numeroAdherent, $noFamille, $nom, $prenoms, $codeLienParente,
|
|
$codeNaturePiece, $numeroPiece, $sexe, $codeGroupeSanguin, $dateNaissance, $telephonePortable, $numeroMatricule, $numeroCmu,
|
|
$dateSouscription, $numeroBs, $ancienNumeroAssure, $conserverAncienNumeroAssure, $ancienNumeroAdherent, $codeTypeRemboursement,
|
|
$email, $codeLangue, $prefixePaiementMobile, $mobilePaiement)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_inserer_ligne_modele_assure(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
/*
|
|
var_dump
|
|
(
|
|
array
|
|
(
|
|
"prefixePaiementMobile" => $prefixePaiementMobile,
|
|
"mobilePaiement" => $mobilePaiement,
|
|
)
|
|
);
|
|
exit();
|
|
*/
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAvenant, $user, $idSaisie, $categorie, $numeroAdherent, $noFamille, $nom, $prenoms, $codeLienParente,
|
|
$codeNaturePiece, $numeroPiece, $sexe, $codeGroupeSanguin, $dateNaissance, $telephonePortable, $numeroMatricule, $numeroCmu, $dateSouscription, $numeroBs,
|
|
$ancienNumeroAssure, $conserverAncienNumeroAssure, $ancienNumeroAdherent, $codeTypeRemboursement, $email, $codeLangue, $prefixePaiementMobile, $mobilePaiement));
|
|
}
|
|
|
|
|
|
public function getListeAssuresImportes()
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
|
|
$sql = 'CALL sp_afficher_lignes_importees(?, ?);';
|
|
|
|
$beneficiaires = $this->executerRequete($sql, array($idPolice, $user));
|
|
|
|
return $beneficiaires->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function gererIncorporationSurFamExistante()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_gerer_incorporation_sur_fam_existante(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $user));
|
|
}
|
|
|
|
|
|
public function calculerprimeimportee()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_calculer_prime_importee(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $user));
|
|
}
|
|
|
|
public function enregistrerparamimportassure($nomOrigine, $nouveau_fichier, $taille)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
//$cheminFichier = $_SESSION['dossierGed'].$nouveau_fichier;
|
|
$cheminFichier = $nouveau_fichier;
|
|
|
|
$sql = 'call sp_r_enregistrer_param_import_assure(?, ?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $codeSociete, $nomOrigine, $cheminFichier, $taille, $user));
|
|
}
|
|
|
|
public function getFichierImport()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_afficher_fichier_import(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $user));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
|
|
public function exclureligneimportee($idBeneficiairemodel, $exclure)
|
|
{
|
|
$sql = 'call sp_r_exclure_ligne_importee(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idBeneficiairemodel, $exclure));
|
|
}
|
|
|
|
public function getListeAdherentImportes($idCollege)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_afficher_adherents_importees(?, ?, ?)';
|
|
|
|
$beneficiaires = $this->executerRequete($sql, array($idPolice, $user, $idCollege));
|
|
|
|
return $beneficiaires->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getListeAdherentImportesCollege($idCollege)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_afficher_adherents_importees_college(?, ?, ?)';
|
|
|
|
$beneficiaires = $this->executerRequete($sql, array($idPolice, $user, $idCollege));
|
|
|
|
|
|
return $beneficiaires->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function ajouterunadherentaucollege($idBeneficiairemodel, $idCollege)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_ajouter_adherent_importee_college(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($user, $idBeneficiairemodel, $idCollege));
|
|
}
|
|
|
|
|
|
public function retirerunadherentaucollege($idBeneficiairemodel)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_retirer_adherent_importee_college(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($user, $idBeneficiairemodel));
|
|
}
|
|
|
|
public function getnbadhimpsanscollege()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'SELECT fn_nb_adh_imp_sans_college(?, ?) AS nb_adh;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $user));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['nb_adh'];
|
|
}
|
|
|
|
public function incorpoerassuresimportes()
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
|
|
$sql = 'call sp_incorporer_assures_importes(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $user));
|
|
}
|
|
|
|
public function ajoutertousadherentaucollege($idCollege)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_ajouter_tous_adherent_importee_college(?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $user, $idCollege));
|
|
}
|
|
|
|
public function ajoutersanscollegeadherentaucollege($idCollege)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_ajouter_adherent_sans_college_importee_college(?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $user, $idCollege));
|
|
}
|
|
|
|
// retirertousadherentaucollege
|
|
public function retirertousadherentaucollege($idCollege)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_retirer_tous_adherent_importee_college(?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $user, $idCollege));
|
|
}
|
|
|
|
public function majetape()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idAvenant = $_SESSION['idAvenantImport'];
|
|
|
|
$sql = 'CALL sp_r_maj_etape_3_import_assure(?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $idAvenant, $user));
|
|
}
|
|
|
|
public function getadhimpfamillesansadherent()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_adh_imp_famille_sans_adherent(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $user));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['noFamille'];
|
|
}
|
|
|
|
public function getadhimpfamilleplusieursadherent()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_adh_imp_famille_plusieurs_adherent(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $user));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['noFamille'];
|
|
}
|
|
|
|
public function getadhimpfamilleexistantsansadherent()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_adh_imp_famille_existant_sans_adherent(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $user));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['noFamille'];
|
|
}
|
|
|
|
public function getBeneficiairesNonFature($idPolice)
|
|
{
|
|
$sql = 'call sp_beneficiaires_non_factures(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function afficherfacturationpolice($debut, $fin, $idAvenant)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = 'call sp_afficher_facturation_police(?, ?, ?, ?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $user, $idSaisie, $debut, $fin, $idAvenant));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function afficherDetailFacturationPrime()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = 'call sp_afficher_facturation_police_prime(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $user, $idSaisie));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function initfacturationpolice()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = 'CALL sp_init_facturation_police(?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $user, $idSaisie));
|
|
}
|
|
|
|
public function selectionnertoutlignesafacturer($choix, $debut, $fin, $idAvenant)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
//var_dump('idPolice='.$idPolice.', user='.$user.', idSaisie'.$idSaisie.', ave='.$idAvenant);
|
|
//die();
|
|
|
|
$sql = 'call sp_select_tous_beneficiaire_a_facturer(?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $user, $idSaisie, $debut, $fin, $choix, $idAvenant));
|
|
}
|
|
|
|
public function selectionnertoutlignesafacturerprime($choix)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
//var_dump('idPolice='.$idPolice.', user='.$user.', idSaisie'.$idSaisie.', ave='.$idAvenant);
|
|
//die();
|
|
|
|
$sql = 'call sp_select_tous_beneficiaire_a_facturer_prime(?, ?, ?, ?);';
|
|
$arr = array($idPolice, $user, $idSaisie,$choix);
|
|
// var_dump($arr);
|
|
$this->executerRequete($sql, $arr);
|
|
}
|
|
|
|
public function selectionnerunelignesafacturer($idBeneficiairePrimeTemp, $choix, $debut, $fin, $idAvenant)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = 'call sp_select_un_beneficiaire_a_facturer(?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $user, $idSaisie, $debut, $fin, $idBeneficiairePrimeTemp, $choix, $idAvenant));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function affichertotalfacturationpolice($debut, $fin, $idAvenant)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = 'call sp_recap_beneficiaire_a_facturer(?, ?, ?, ?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $user, $idSaisie, $debut, $fin, $idAvenant));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function affichertotalfacturationpoliceprime()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = 'call sp_recap_beneficiaire_a_facturer_prime(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $user, $idSaisie));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function initecheancierfacturation($debut, $fin, $idAvenant)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = 'call sp_init_echeancier_facturation(?, ?, ?, ?, ?, ?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idPolice, $user, $idSaisie, $debut, $fin, $_SESSION['lang'], $idAvenant));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['idEmission_temp'];
|
|
}
|
|
|
|
public function initecheancierfacturationprime()
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$sql = 'call sp_init_echeancier_facturation_prime(?, ?, ?, ?, ?)';
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idPolice, $user, $idSaisie, $_SESSION['lang']));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $ligne['idEmission_temp'];
|
|
}
|
|
|
|
public function majaccessoiresfacturation($fraisCarte, $debut, $fin)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
|
|
$sql = 'call sp_maj_accessoires_facturation(?, ?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $user, $idSaisie, $debut, $fin, $fraisCarte));
|
|
}
|
|
|
|
public function majprimesfacturation($idCollege, $old_primeNette, $nv_primeNette, $debut, $fin)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = 'call sp_maj_primes_facturation(?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $user, $idSaisie, $debut, $fin, $idCollege, $old_primeNette, $nv_primeNette));
|
|
}
|
|
|
|
public function gethistoenrollementempreinte($debut, $fin)
|
|
{
|
|
$sql = 'call sp_histo_enrollement_empreinte(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getentetecontrat($idEntetecontrat)
|
|
{
|
|
$sql = 'SELECT * FROM entetecontrat WHERE id=? limit 1;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEntetecontrat));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getlisteentetecontratadherent($idAdherent)
|
|
{
|
|
$sql = 'call sp_get_entete_contrat_adherent(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getlisteentetecontratbeneficiaire($idBeneficiaire)
|
|
{
|
|
$sql = 'call sp_get_entete_contrat_beneficiaire(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
// Modifs marc 23/05/2022
|
|
public function getnombrefamilleperiode($idPolice, $debut, $fin){
|
|
|
|
$sql = 'SELECT numeroAdherent, COUNT(A.numeroAdherent) AS nbfamille
|
|
FROM beneficiaire A
|
|
WHERE A.idPolice=?
|
|
AND A.dateEntree BETWEEN ? AND ?
|
|
AND A.sorti !="1"
|
|
GROUP BY A.numeroAdherent';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getnombreAssureCollegeperiode($idPolice, $debut, $fin){
|
|
|
|
$sql = 'SELECT idCollege, COUNT(idCollege) AS nbassure
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND dateEntree BETWEEN ? AND ?
|
|
AND sorti !="1"
|
|
GROUP BY idCollege';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
public function getnombreAssureperiode($idPolice, $debut, $fin){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND dateEntree BETWEEN ? AND ?
|
|
AND codeLienParente = 'A'
|
|
AND sorti !='1'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $debut, $fin))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND dateEntree BETWEEN ? AND ?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'A'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND dateEntree BETWEEN ? AND ?
|
|
AND sorti !='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $debut, $fin, $idPolice, $debut, $fin))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
public function getnombreGeniteurperiode($idPolice, $debut, $fin){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND dateEntree BETWEEN ? AND ?
|
|
AND codeLienParente = 'F'
|
|
AND sorti !='1'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $debut, $fin))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=? AND dateEntree BETWEEN ? AND ?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'F'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=? AND dateEntree BETWEEN ? AND ?
|
|
AND sorti !='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $debut, $fin, $idPolice, $debut, $fin))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
public function getnombreAutreParentperiode($idPolice, $debut, $fin){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=? AND dateEntree BETWEEN ? AND ?
|
|
AND codeLienParente = 'O'
|
|
AND sorti !='1'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $debut, $fin))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=? AND dateEntree BETWEEN ? AND ?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'O'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=? AND dateEntree BETWEEN ? AND ?
|
|
AND sorti ='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $debut, $fin, $idPolice, $debut, $fin))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
public function getnombreConjointperiode($idPolice, $debut, $fin){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=? AND dateEntree BETWEEN ? AND ?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'C'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $debut, $fin))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=? AND dateEntree BETWEEN ? AND ?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'C'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=? AND dateEntree BETWEEN ? AND ?
|
|
AND sorti !='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $debut, $fin, $idPolice, $debut, $fin))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
public function getnombrefamilleDate($idPolice,$dateAnalyse){
|
|
|
|
$sql = 'SELECT A.numeroAdherent, COUNT(A.numeroAdherent) AS nbfamille
|
|
FROM beneficiaire A
|
|
JOIN adherent B ON (B.id=A.idAdherent)
|
|
JOIN police C ON (C.id=A.idPolice)
|
|
INNER JOIN avenant v ON ((v.id=A.idAvenant) AND (v.idPolice=A.idPolice))
|
|
WHERE A.idPolice=?
|
|
AND v.dateEffet<=?
|
|
AND CASE WHEN A.sorti = "1" THEN A.dateSortie >= ? ELSE A.dateSortie IS NULL END
|
|
GROUP BY A.numeroAdherent';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$dateAnalyse,$dateAnalyse));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
public function getnombreAssureDate($idPolice,$dateAnalyse){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND codeLienParente = 'A'
|
|
AND sorti !='1' AND dateEntree <= ?
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$dateAnalyse))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1' AND dateEntree <= ?
|
|
AND codeLienParente = 'A'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=? AND dateEntree <= ?
|
|
AND sorti !='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$dateAnalyse,$idPolice,$dateAnalyse))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
public function getnombreAssureCollegeDate($idPolice,$dateAnalyse){
|
|
|
|
$sql = 'SELECT idCollege, COUNT(idCollege) AS nbassure
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !="1" AND dateEntree <= ?
|
|
GROUP BY idCollege';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$dateAnalyse));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
public function getnombreGeniteurDate($idPolice,$dateAnalyse){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND codeLienParente = 'F'
|
|
AND sorti !='1' AND dateEntree <= ?
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$dateAnalyse))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1' AND dateEntree <= ?
|
|
AND codeLienParente = 'F'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=? AND dateEntree <= ?
|
|
AND sorti !='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$dateAnalyse,$idPolice,$dateAnalyse))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
public function getnombreAutreParentDate($idPolice,$dateAnalyse){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND codeLienParente = 'O'
|
|
AND sorti !='1' AND dateEntree <= ?
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$dateAnalyse))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1' AND dateEntree <= ?
|
|
AND codeLienParente = 'O'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=? AND dateEntree <= ?
|
|
AND sorti ='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$dateAnalyse,$idPolice,$dateAnalyse))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
public function getnombreConjointDate($idPolice,$dateAnalyse){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'C' AND dateEntree <= ?
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$dateAnalyse))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1' AND dateEntree <= ?
|
|
AND codeLienParente = 'C'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1' AND dateEntree <= ?;";
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$dateAnalyse,$idPolice,$dateAnalyse))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
////////
|
|
public function getnombrefamille($idPolice){
|
|
|
|
$sql = 'SELECT numeroAdherent, COUNT(A.numeroAdherent) AS nbfamille
|
|
FROM beneficiaire A
|
|
WHERE A.idPolice=?
|
|
AND sorti !="1"
|
|
GROUP BY A.numeroAdherent';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getnombrefamilleRetrait($idPolice, $debutSortie, $finSortie , $typeetat){
|
|
|
|
$sql = 'SELECT numeroAdherent, COUNT(A.numeroAdherent) AS nbfamille
|
|
FROM beneficiaire A
|
|
WHERE A.idPolice=?
|
|
AND sorti ="1"
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
GROUP BY A.numeroAdherent';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$typeetat,$typeetat));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getnombreAssureCollege($idPolice){
|
|
|
|
$sql = 'SELECT idCollege, COUNT(idCollege) AS nbassure
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !="1"
|
|
GROUP BY idCollege';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getnombreAssureCollegeRetrait($idPolice, $debutSortie, $finSortie , $typeetat){
|
|
|
|
$sql = 'SELECT idCollege, COUNT(idCollege) AS nbassure
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti ="1"
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
GROUP BY idCollege';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$typeetat,$typeetat));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getnombreAssure($idPolice){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND codeLienParente = 'A'
|
|
AND sorti !='1'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'A'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
public function getnombreAssureRetrait($idPolice, $debutSortie, $finSortie , $typeetat){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND codeLienParente = 'A'
|
|
AND sorti ='1'
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$typeetat,$typeetat))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti ='1'
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
AND codeLienParente = 'A'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
AND sorti ='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$typeetat,$typeetat, $idPolice, $typeetat,$typeetat))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
public function getnombreGeniteur($idPolice){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND codeLienParente = 'F'
|
|
AND sorti !='1'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'F'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
public function getnombreGeniteurRetrait($idPolice, $debutSortie, $finSortie , $typeetat){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND codeLienParente = 'F'
|
|
AND sorti ='1'
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$typeetat,$typeetat))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti ='1'
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
AND codeLienParente = 'F'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
AND sorti ='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$typeetat,$typeetat, $idPolice, $typeetat,$typeetat))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
public function getnombreAutreParent($idPolice){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND codeLienParente = 'O'
|
|
AND sorti !='1'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'O'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti ='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
public function getnombreAutreParentRetrait($idPolice, $debutSortie, $finSortie , $typeetat){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND codeLienParente = 'O'
|
|
AND sorti ='1'
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$typeetat,$typeetat))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti ='1'
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
|
|
AND codeLienParente = 'O'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
AND sorti ='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice,$typeetat,$typeetat, $idPolice, $typeetat,$typeetat))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
|
|
public function getnombreConjoint($idPolice){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'C'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'C'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
public function getnombreConjointRetrait($idPolice, $debutSortie, $finSortie , $typeetat){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti ='1'
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
AND codeLienParente = 'C'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $typeetat, $typeetat))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti ='1'
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
AND codeLienParente = 'C'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND (CASE WHEN ? IS NULL THEN codeEtatBeneficiaire IS NOT NULL ELSE codeEtatBeneficiaire=? END)
|
|
AND sorti ='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $typeetat, $typeetat, $idPolice, $typeetat, $typeetat))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
public function getnombreAutreConjoint($idPolice){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'D'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'D'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
|
|
public function getnombreEnfant($idPolice){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'E'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND codeLienParente = 'E'
|
|
AND sorti !='1'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
|
|
public function getnombreEnfantSup($idPolice){
|
|
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'X'
|
|
GROUP BY idCollege";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
if(count($resultat) > 0 ){
|
|
return $resultat;
|
|
}else{
|
|
$sql = "SELECT idCollege, COUNT(codeLienParente) AS nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1'
|
|
AND codeLienParente = 'X'
|
|
GROUP BY idCollege
|
|
UNION
|
|
SELECT idCollege, 0 as nbre
|
|
FROM beneficiaire
|
|
WHERE idPolice=?
|
|
AND sorti !='1';";
|
|
$resultat = $this->executerRequete($sql, array($idPolice))->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat;
|
|
}
|
|
}
|
|
|
|
// 18/05/2021
|
|
|
|
public function getBeneficiairesAimprimerperiode($idPolice, $debut, $fin)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_imprimer_assure_periode_eng(?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_imprimer_assure_periode(?, ?, ?);';
|
|
}
|
|
|
|
$beneficiaires = $this->executerRequete($sql, array($idPolice, $debut, $fin));
|
|
|
|
return $beneficiaires->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getBeneficiairesAimprimerRetrait($idPolice, $debut, $fin, $typeetat)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_imprimer_assure_retrait_eng(?, ?,?,?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_imprimer_assure_retrait(?, ?, ?,?);';
|
|
}
|
|
|
|
$beneficiaires = $this->executerRequete($sql, array($idPolice, $debut, $fin, $typeetat));
|
|
|
|
return $beneficiaires->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function controlerplafondbeneficiaireannuel($idBeneficiaire)
|
|
{
|
|
$sql = 'select fn_control_plafond_beneficiaire_courant(?) as controlerPlafondBeneficiaire;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$_SESSION['controlerPlafondBeneficiaire'] = $ligne['controlerPlafondBeneficiaire'];
|
|
|
|
$idAdherent = $_SESSION['idAdherent_C'];
|
|
|
|
$this->controlerplafondadherentannuel($idAdherent);
|
|
}
|
|
|
|
public function controlerplafondadherentannuel($idAdherent)
|
|
{
|
|
$sql = 'select fn_control_plafond_adherent_courant(?) as controlerPlafondAdherent;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$_SESSION['controlerPlafondAdherent'] = $ligne['controlerPlafondAdherent'];
|
|
}
|
|
|
|
public function getCodeGarantPolice($idPolice)
|
|
{
|
|
$sql = 'SELECT codeGcAssureur FROM police WHERE id=?;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['codeGcAssureur'];
|
|
|
|
}
|
|
|
|
public function getInfosGarant($codeGcAssureur)
|
|
{
|
|
$sql = 'SELECT libelle,typeGarant FROM gc_assureur WHERE codeGcAssureur=?;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeGcAssureur));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function getBeneficiaireNumeroId($numeroBeneficiaire)
|
|
{
|
|
|
|
$sql = 'SELECT id as idBeneficiaire,idPolice, idAdherent
|
|
FROM beneficiaire WHERE (codeSociete=?)
|
|
AND numeroBeneficiaire = ?;';
|
|
|
|
$beneficiaire = $this->executerRequete($sql, array($_SESSION['codeSociete'], $numeroBeneficiaire));
|
|
return $beneficiaire->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getSituationCollege($idBeneficiaire)
|
|
{
|
|
$date = date('Y-m-d');
|
|
$sql = 'call sp_situation_beneficiaire_annuel_newversion(?, ?);';
|
|
$college = $this->executerRequete($sql, array($idBeneficiaire, $date));
|
|
return $college->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getSituationPolice($idBeneficiaire)
|
|
{
|
|
$date = date('Y-m-d');
|
|
|
|
//var_dump($idBeneficiaire, $date);
|
|
|
|
$sql = 'call sp_situation_beneficiaire_famille_newversion(?,?);';
|
|
$police = $this->executerRequete($sql, array($idBeneficiaire, $date));
|
|
return $police->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getBaseTarificationBeneficiaire($idBeneficiaire)
|
|
{
|
|
$sql = 'SELECT fn_base_tarification_beneficiaire(?) AS baseTarification';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['baseTarification'];
|
|
|
|
}
|
|
public function getnouveaunumerobeneficiaire($numeroBeneficiaire,$user)
|
|
{
|
|
$sql = 'CALL sp_carte_perdue_rp(?,?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($numeroBeneficiaire,$user));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
public function getnumerobeneficiairesperdu($numeroBeneficiaire)
|
|
{
|
|
//$_SESSION['codeSociete'], à ajouter comme parametre
|
|
|
|
$sql = 'SELECT numeroBeneficiaireOld AS ancien,
|
|
numeroBeneficiaire AS nouveau
|
|
FROM `carteperdue` WHERE numeroBeneficiaireOld = ?;';
|
|
|
|
$beneficiaire = $this->executerRequete($sql, array($numeroBeneficiaire));
|
|
return $beneficiaire->fetch(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
//31-03-2023
|
|
public function getListeLimitebeneficiaire($idBeneficiaire)
|
|
{
|
|
//var_dump($idBeneficiaire); die();
|
|
$sql = 'call sp_liste_limitebeneficiaire_newversion(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
|
|
}
|
|
|
|
public function majPlafondBeneficiaire($idLimite, $plafond, $motif)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql ="CALL sp_majplafondbeneficiaire(?, ?, ?, ?);";
|
|
|
|
$this->executerRequete($sql, array($idLimite, $plafond, $motif, $user));
|
|
|
|
}
|
|
|
|
//15-05-2023
|
|
public function getConsosBeneficiaire($idBeneficiaire)
|
|
{
|
|
$datePrestation = date('Y-m-d');
|
|
|
|
$sql = 'call sp_consos_beneficiaire_newversion(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $datePrestation));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
|
|
public function getConsosTotalBeneficiaire($idBeneficiaire)
|
|
{
|
|
$datePrestation = date('Y-m-d');
|
|
|
|
$sql = 'call sp_consos_total_beneficiaire_newversion(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $datePrestation));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
//26-05-2023
|
|
public function trouverBeneficiaire($numero)
|
|
{
|
|
$numero = contruireParamLikeDebut($numero);
|
|
|
|
$sql = 'call sp_get_beneficiaire_newversion(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($numero));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function trouverBeneficiaireId($idBeneficiaire)
|
|
{
|
|
$sql = 'call sp_get_beneficiaire_id_newversion(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
//27-05-2023
|
|
public function getVerifieExistance($nom, $prenoms, $sexe, $codeLienParente, $dateNaissance, $idAdherent)
|
|
{
|
|
$sql = 'SELECT fn_verifier_existance_beneficiaire(?, ?, ?, ?, ?, ?) AS existe;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($nom, $prenoms, $codeLienParente, $sexe, $dateNaissance, $idAdherent))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['existe'];
|
|
|
|
}
|
|
|
|
//05-07-2023
|
|
public function getTmbeneficiaire()
|
|
{
|
|
$sql = 'CALL sp_gettmbeneficiaire();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
//06-07-2023
|
|
public function getMaxDateEffetTmBeneficiaire($idBeneficiaire){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmbeneficiaire(?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
}
|
|
|
|
public function insererTmbeneficiaire($idBeneficiaire, $dateEffet, $tm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmbeneficiaire(?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $dateEffet, $tm, $user));
|
|
|
|
}
|
|
|
|
public function supprimerTmbeneficiaire($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmbeneficiaire(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
}
|
|
|
|
public function getTmbeneficiaireacte()
|
|
{
|
|
$sql = 'CALL sp_gettmbeneficiaire_acte();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getMaxDateEffetTmBeneficiaireacte($idBeneficiaire, $codeActe, $codeGarantie){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmbeneficiaireacte(?, ?, ?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $codeActe, $codeGarantie))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
}
|
|
|
|
public function insererTmbeneficiaireacte($idBeneficiaire, $dateEffet, $tm, $codeActe, $codeGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmbeneficiaire_acte(?, ?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $dateEffet, $tm, $user, $codeActe, $codeGarantie));
|
|
|
|
}
|
|
|
|
public function supprimerTmbeneficiaireacte($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmbeneficiaireacte(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
}
|
|
|
|
public function getTmbeneficiaireacteprestataire()
|
|
{
|
|
$sql = 'CALL sp_gettmbeneficiaire_acte_prestataire();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getMaxDateEffetTmBeneficiaireacteprestataire($idBeneficiaire, $codeActe, $codePrestataire, $codeGarantie){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmbeneficiaireacteprestataire(?, ?, ?, ?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $codeActe, $codePrestataire, $codeGarantie))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
}
|
|
|
|
public function insererTmbeneficiaireacteprestataire($idBeneficiaire, $dateEffet, $tm, $codeActe, $codePrestataire, $codeGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmbeneficiaire_acte_prestataire(?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $dateEffet, $tm, $user, $codeActe, $codePrestataire, $codeGarantie));
|
|
|
|
}
|
|
|
|
public function supprimerTmbeneficiaireacteprestataire($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmbeneficiaireacteprestataire(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
|
|
}
|
|
|
|
//07-07-2023
|
|
public function getgarantie()
|
|
{
|
|
$sql = 'SELECT codeGarantie AS `code`,
|
|
libelle
|
|
FROM garantie;';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getTmbeneficiairegarantie()
|
|
{
|
|
$sql = 'CALL sp_gettmbeneficiaire_garantie();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getMaxDateEffetTmBeneficiairegarantie($idBeneficiaire, $codeGarantie){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmbeneficiairegarantie(?, ?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $codeGarantie))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
}
|
|
|
|
public function insererTmbeneficiairegarantie($idBeneficiaire, $dateEffet, $tm, $codeGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmbeneficiaire_garantie(?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $dateEffet, $tm, $user, $codeGarantie));
|
|
|
|
}
|
|
|
|
public function supprimerTmbeneficiairegarantie($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmbeneficiairegarantie(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
}
|
|
|
|
public function getTmbeneficiairegarantieprestataire()
|
|
{
|
|
$sql = 'CALL sp_gettmbeneficiaire_garantie_prestataire();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getMaxDateEffetTmBeneficiairegarantieprestataire($idBeneficiaire, $codeGarantie, $codePrestataire){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmbeneficiairegarantieprestataire(?, ?, ?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $codeGarantie, $codePrestataire))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
}
|
|
|
|
public function insererTmbeneficiairegarantieprestataire($idBeneficiaire, $dateEffet, $tm, $codeGarantie, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmbeneficiaire_garantieprestataire(?, ?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $dateEffet, $tm, $user, $codeGarantie, $codePrestataire));
|
|
|
|
}
|
|
|
|
public function supprimerTmbeneficiairegarantieprestataire($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmbeneficiairegarantieprestataire(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
}
|
|
|
|
public function getTmbeneficiaireprestataire()
|
|
{
|
|
$sql = 'CALL sp_gettmbeneficiaire_prestataire();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getMaxDateEffetTmBeneficiaireprestataire($idBeneficiaire, $codePrestataire){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmbeneficiaireprestataire(?, ?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $codePrestataire))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
}
|
|
|
|
public function insererTmbeneficiaireprestataire($idBeneficiaire, $dateEffet, $tm, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmbeneficiaire_prestataire(?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $dateEffet, $tm, $user, $codePrestataire));
|
|
|
|
}
|
|
|
|
public function supprimerTmbeneficiaireprestataire($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmbeneficiaireprestataire(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
}
|
|
|
|
//Biometrie
|
|
public function getlogreconnaissancefaciale($debut, $fin)
|
|
{
|
|
$sql = 'call sp_get_log_reconnaissance_faciale(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function getlogreconnaissancefacialeexport($debut, $fin)
|
|
{
|
|
$sql = 'call sp_get_log_reconnaissance_faciale_export(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function re_init()
|
|
{
|
|
$_SESSION['idBeneficiaire_C'] = "";
|
|
$_SESSION['Patient_C'] = "";
|
|
$_SESSION['beneficiaire_C'] = "";
|
|
$_SESSION['adherent_C'] = "";
|
|
$_SESSION['user_id_C'] = "";
|
|
$_SESSION['finger_id_C'] = "";
|
|
$_SESSION['faceRegistered_C'] = "";
|
|
}
|
|
|
|
public function getpatientlike($numeroBeneficiaire, $nomsearch)
|
|
{
|
|
$nomsearch = contruireParamLike($nomsearch);
|
|
$numeroBeneficiaire = contruireParamLike($numeroBeneficiaire);
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
|
|
$sql = 'call sp_r_patients_like(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $numeroBeneficiaire, $nomsearch));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getpatientlikevide()
|
|
{
|
|
$sql = 'call sp_r_patients_vide()';
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getlogreregisterface($debut, $fin)
|
|
{
|
|
$sql = 'call sp_get_log_register_face(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function getlogreregisterfaceexport($debut, $fin)
|
|
{
|
|
$sql = 'call sp_get_log_register_face_export(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getlogreremoveface($debut, $fin)
|
|
{
|
|
$sql = 'call sp_get_log_remove_face(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function getlogreremovefaceexport($debut, $fin)
|
|
{
|
|
$sql = 'call sp_get_log_remove_face_export(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function registerface($numeroBeneficiaire)
|
|
{
|
|
$codePrestataire = "";
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_register_face(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($numeroBeneficiaire, $codePrestataire, $user));
|
|
}
|
|
|
|
public function unregisterface($numeroBeneficiaire, $motif)
|
|
{
|
|
$codePrestataire = "";
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_remove_face(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($numeroBeneficiaire, $codePrestataire, $user, $motif));
|
|
}
|
|
|
|
//
|
|
public function init_reconnaitrelaface()
|
|
{
|
|
$codePrestataire = "";
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_init_reconnaitrelaface(?, ?);';
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $user));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$_SESSION['idLogapiface'] = $ligne['idLogapiface'];
|
|
}
|
|
|
|
public function succes_reconnaitrelaface($username, $resultat)
|
|
{
|
|
$idLogapiface = $_SESSION['idLogapiface'];
|
|
|
|
$sql = 'call sp_succes_reconnaitrelaface(?, ?, ?);';
|
|
$this->executerRequete($sql, array($idLogapiface, $username, $resultat));
|
|
}
|
|
|
|
|
|
public function echec_reconnaitrelaface($resultat)
|
|
{
|
|
$idLogapiface = $_SESSION['idLogapiface'];
|
|
|
|
$sql = 'call sp_echec_reconnaitrelaface(?, ?);';
|
|
$this->executerRequete($sql, array($idLogapiface, $resultat));
|
|
}
|
|
|
|
public function init_enregisterlaface()
|
|
{
|
|
$codePrestataire = "";
|
|
$user = $_SESSION['login'];
|
|
$username = $_SESSION['numeroBeneficiaire_C'];
|
|
|
|
$sql = 'call sp_init_enregisterlaface(?, ?, ?);';
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $user, $username));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$_SESSION['idLogapiface'] = $ligne['idLogapiface'];
|
|
}
|
|
|
|
public function init_supprimerlaface()
|
|
{
|
|
$codePrestataire = "";
|
|
$user = $_SESSION['login'];
|
|
$username = $_SESSION['numeroBeneficiaire_C'];
|
|
|
|
$sql = 'call sp_init_supprimerlaface(?, ?, ?);';
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $user, $username));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$_SESSION['idLogapiface'] = $ligne['idLogapiface'];
|
|
}
|
|
|
|
public function init_confirmerlaface($del)
|
|
{
|
|
$codePrestataire = "";
|
|
$user = $_SESSION['login'];
|
|
$username = $_SESSION['numeroBeneficiaire_C'];
|
|
|
|
$sql = 'call sp_init_confirmerlaface(?, ?, ?, ?);';
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $user, $username, $del));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$_SESSION['idLogapiface'] = $ligne['idLogapiface'];
|
|
}
|
|
|
|
public function supprimerface($motif)
|
|
{
|
|
$idBeneficiaire = $_SESSION['idBeneficiaire_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_supprimer_face(?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idBeneficiaire, $user, $motif));
|
|
}
|
|
|
|
public function getfacesupprimers()
|
|
{
|
|
$idBeneficiaire = $_SESSION['idBeneficiaire_C'];
|
|
|
|
$sql = 'call sp_faces_supprimees(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getModeBiometrie() {
|
|
$sql = 'CALL sp_get_mode_biometrie(?);';
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete']));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$_SESSION['codeModeBiometrie'] = $ligne['codeModeBiometrie'];
|
|
|
|
$codeModeBiometrie = $_SESSION['codeModeBiometrie'];
|
|
if($codeModeBiometrie=='1' or $codeModeBiometrie=='3'){
|
|
$_SESSION['fingerActif'] = '1';
|
|
}
|
|
else{
|
|
$_SESSION['fingerActif'] = '0';
|
|
}
|
|
|
|
if($codeModeBiometrie=='2' or $codeModeBiometrie=='3'){
|
|
$_SESSION['faceActif'] = '1';
|
|
}
|
|
else{
|
|
$_SESSION['faceActif'] = '0';
|
|
}
|
|
}
|
|
|
|
public function init_traiterlaface($codeActionFace)
|
|
{
|
|
$codePrestataire = '';
|
|
$user = $_SESSION['login'];
|
|
$username = $_SESSION['numeroBeneficiaire_C'];
|
|
|
|
$sql = 'call sp_init_traiterlaface(?, ?, ?, ?);';
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $user, $username, $codeActionFace));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$_SESSION['idLogapiface'] = $ligne['idLogapiface'];
|
|
}
|
|
|
|
public function resultat_traitement_face($username, $success, $message)
|
|
{
|
|
$idLogapiface = $_SESSION['idLogapiface'];
|
|
|
|
$sql = 'CALL sp_resultat_traitement_face(?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idLogapiface, $username, $success, $message));
|
|
}
|
|
|
|
public function supprimerPhoto($id)
|
|
{
|
|
$sql = 'update beneficiaire set lienPhoto="", faceRegistered="0" WHERE (id=?)';
|
|
$this->executerRequete($sql, array($id));
|
|
}
|
|
|
|
public function gethistofacesupprimees($debut, $fin)
|
|
{
|
|
$sql = 'call sp_histo_suppression_faces(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function gethistoenrollementface($debut, $fin)
|
|
{
|
|
$sql = 'call sp_histo_enrollement_face(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getgarantiehospit($codeGarantie)
|
|
{
|
|
$sql = 'SELECT codeGarantie AS `code`,
|
|
libelle
|
|
FROM garantie
|
|
WHERE codeGarantie=?;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeGarantie));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function existeAncienNumeroAssure($ancienNumeroAssure) {
|
|
|
|
$sql = 'CALL sp_existe_ancien_numero_assure(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'], $ancienNumeroAssure));
|
|
|
|
return ($resultat->rowCount());
|
|
}
|
|
|
|
|
|
public function majdateeffetFichierImport($dateEffet)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_maj_fichier_import(?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $dateEffet, $user));
|
|
|
|
}
|
|
|
|
|
|
public function ajouterbeneficiairefacturation($idAdherent)
|
|
{
|
|
|
|
$sql = 'call sp_enregistrer_beneficiaire_facturation(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$dernierIdBeneficiaire = $ligne['dernierIdBeneficiaire'];
|
|
return $dernierIdBeneficiaire;
|
|
}
|
|
|
|
public function getIdAdherent($numeroAdherent)
|
|
{
|
|
$sql = 'SELECT fn_id_Adherent_rp(?) AS idAdherent;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($numeroAdherent));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['idAdherent'];
|
|
}
|
|
|
|
public function getPrestationsmensuelles($idBeneficiaire){
|
|
|
|
if (isset($_SESSION['lang']) && $_SESSION['lang']=="en_US"){
|
|
$sql = 'call prestations_mensuelles_beneficiaire_eng(?)';
|
|
}else{
|
|
$sql = 'call prestations_mensuelles_beneficiaire(?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getMatriculeBeneficiaire($idBeneficiaire)
|
|
{
|
|
$sql = 'SELECT numeroBeneficiaire FROM beneficiaire WHERE id=?';
|
|
$resultat = $this->executerRequete($sql,array($idBeneficiaire))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['numeroBeneficiaire'];
|
|
}
|
|
|
|
public function controlenopieceglobal($numeroPiece)
|
|
{
|
|
$sql = 'CALL sp_controle_no_piece_global(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($numeroPiece));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function prestationPossible($idBeneficiaire)
|
|
{
|
|
$sql = 'select fn_beneficiaire_prestation_possible(?) as prestationPossible';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $ligne['prestationPossible'];
|
|
}
|
|
|
|
public function getIdPoliceBeneficiaire($idBeneficiaire)
|
|
{
|
|
$sql = 'SELECT idPolice from beneficiaire where id=? limit 1;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['idPolice'];
|
|
}
|
|
|
|
} |