1221 lines
40 KiB
PHP
Executable File
1221 lines
40 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
class Adherent extends Modele {
|
|
|
|
public function getAdherentSimple($idAdherent) {
|
|
$sql = 'CALL sp_get_Adherent_Simple(?);';
|
|
|
|
$adherent = $this->executerRequete($sql, array($idAdherent));
|
|
return $adherent->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getAllAderents() {
|
|
$sql = 'select * from adherent';
|
|
$adherent = $this->executerRequete($sql);
|
|
// return $adherent->fetch(PDO::FETCH_ASSOC);
|
|
return $adherent->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
|
|
public function getAdherents($noadherentsearch=null, $noPiecesearch=null, $emailsearch=null,
|
|
$nomsearch=null, $prenomsearch=null, $telsearch=null) {
|
|
|
|
$noadherentsearch = contruireParamLike($noadherentsearch);
|
|
$noPiecesearch = contruireParamLike($noPiecesearch);
|
|
$emailsearch = contruireParamLike($emailsearch);
|
|
$nomsearch = contruireParamLike($nomsearch);
|
|
$prenomsearch = contruireParamLike($prenomsearch);
|
|
$telsearch = contruireParamLike($telsearch);
|
|
|
|
$sql = 'CALL sp_get_Adherents(?,?,?,?,?,?);';
|
|
|
|
$adherent = $this->executerRequete($sql, array($_SESSION['codeSociete'], $noadherentsearch, $noPiecesearch, $emailsearch,$nomsearch, $prenomsearch, $telsearch));
|
|
|
|
return $adherent->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getAdherent($numeroAdherent) {
|
|
$sql = 'CALL sp_get_Adherent(?,?);';
|
|
|
|
$adherent = $this->executerRequete($sql, array($_SESSION['codeSociete'], $numeroAdherent));
|
|
return $adherent;
|
|
}
|
|
|
|
public function getAdherentId($idAdherent) {
|
|
$sql = 'call sp_get_adherent_id(?);';
|
|
$adherent = $this->executerRequete($sql, array($idAdherent));
|
|
return $adherent->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getAdherentIdConso($idAdherent)
|
|
{
|
|
$sql = 'call sp_get_adherent_id_conso(?);';
|
|
$adherent = $this->executerRequete($sql, array($idAdherent));
|
|
return $adherent->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getNombreAdherents()
|
|
{
|
|
$sql = 'CALL sp_get_Nombre_Adherents(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete']));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $ligne['nbAdherents'];
|
|
}
|
|
|
|
public function getIdAdherent($numeroAdherent) {
|
|
|
|
$sql = 'CALL sp_get_Id_Adherent(?,?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'], $numeroAdherent));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $ligne['id'];
|
|
}
|
|
|
|
public function getContexteAdherentId($idAdherent) {
|
|
|
|
$sql = 'call sp_get_contexte_adherent_id(?);';
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
// $context = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$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['idAdherent_C'] = $context['idAdherent'];
|
|
$_SESSION['numeroAdherent_C'] = $context['numeroAdherent'];
|
|
$_SESSION['nomAdherent_C'] = $context['nomAdherent'];
|
|
$_SESSION['adherent_C'] = $context['adherent'];
|
|
$_SESSION['codeProduit_C'] = $context['codeProduit'];
|
|
$_SESSION['idCollege_C'] = $context['idCollege'];
|
|
$_SESSION['rachatTmAdh_C'] = $context['rachatTm'];
|
|
|
|
$_SESSION['codeEtatAdherent_C'] = $context['codeEtatAdherent'];
|
|
|
|
$_SESSION['email_C'] = $context['email'];
|
|
$_SESSION['telephonePortable_C'] = $context['telephonePortable'];
|
|
|
|
$_SESSION['garantieArchive_C'] = $context['garantieArchive'];
|
|
$_SESSION['exercieReference_C'] = $context['exercieReference'];
|
|
$_SESSION['idEntetecontrat'] = $context['idEntetecontrat'];
|
|
|
|
$_SESSION['codeLocalite'] = $context['codeLocalite'];
|
|
|
|
$_SESSION['dateEffetAdherent_C'] = $context['dateEffetAdherent'];
|
|
|
|
$_SESSION['idBeneficiaire_C'] = "";
|
|
$_SESSION['numeroBeneficiaire_C'] = "";
|
|
$_SESSION['nomBeneficiaire_C'] = "";
|
|
$_SESSION['lienPhoto_C'] = "";
|
|
$_SESSION['beneficiaire_C'] = "";
|
|
$_SESSION['enVigueur_C'] = "";
|
|
|
|
$_SESSION['decede_C'] = "0";
|
|
$_SESSION['dateDeces_C'] = "";
|
|
$_SESSION['fraisFuneraireDemande_C'] = "0";
|
|
$_SESSION['fraisFunerairePaye_C'] = "0";
|
|
|
|
return $context;
|
|
}
|
|
|
|
public function getContexteAdherentIdConso($idAdherent) {
|
|
|
|
$sql = 'call sp_get_contexte_adherent_id_conso(?);';
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
$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['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['rachatTmAdh_C'] = $context['rachatTm'];
|
|
|
|
$_SESSION['codeEtatAdherent_C'] = $context['codeEtatAdherent'];
|
|
|
|
$_SESSION['email_C'] = $context['email'];
|
|
$_SESSION['telephonePortable_C'] = $context['telephonePortable'];
|
|
$_SESSION['exercieReference_C'] = $context['exercieReference'];
|
|
$_SESSION['idEntetecontrat'] = $context['idEntetecontrat'];
|
|
|
|
$_SESSION['codeLocalite'] = $context['codeLocalite'];
|
|
|
|
$_SESSION['idBeneficiaire_C'] = "";
|
|
$_SESSION['numeroBeneficiaire_C'] = "";
|
|
$_SESSION['nomBeneficiaire_C'] = "";
|
|
$_SESSION['lienPhoto_C'] = "";
|
|
$_SESSION['beneficiaire_C'] = "";
|
|
$_SESSION['enVigueur_C'] = "";
|
|
|
|
$_SESSION['decede_C'] = "0";
|
|
$_SESSION['dateDeces_C'] = "";
|
|
$_SESSION['fraisFuneraireDemande_C'] = "0";
|
|
$_SESSION['fraisFunerairePaye_C'] = "0";
|
|
|
|
return $context;
|
|
}
|
|
|
|
public function existeligne($numeroAdherent) {
|
|
|
|
$sql = 'CALL sp_existe_ligne(?,?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'],$numeroAdherent));
|
|
return ($resultat->rowCount() > 0);
|
|
}
|
|
|
|
public function getDenierNumeroAdherent()
|
|
{
|
|
$sql = 'CALL sp_get_Denier_Numero_Adherent(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete']));
|
|
|
|
if ($resultat->rowCount() == 0)
|
|
{
|
|
$sql = 'INSERT INTO numerotationadherent (codeSociete, racineNoAdherent, dernierNumeroAdherent) values (?,?,?)';
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $_SESSION['racineNoAdherent'], "1"));
|
|
return "0";
|
|
} else
|
|
{
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $ligne['dernierNumeroAdherent'];
|
|
}
|
|
}
|
|
|
|
public function setDenierNumeroAdherent($numeroAdherent)
|
|
{
|
|
$sql = 'CALL sp_set_Denier_Numero_Adherent(?,?);';
|
|
$this->executerRequete($sql, array($numeroAdherent, $_SESSION['codeSociete']));
|
|
}
|
|
|
|
public function ajouter($idCollege, $numeroAdherent, $nom, $prenoms, $codeNaturePiece, $numeroPiece, $sexe,
|
|
$dateNaissance, $codeGroupeSanguin, $codeSituationFamille, $nombreEnfants, $adresseGeo, $adressePostale,
|
|
$codePays, $telephonFixe, $telephonePortable, $email, $dateEntree, $dateCre, $user, $idAvenant)
|
|
{
|
|
//$dernierNumeroBeneficiaire = '1';
|
|
|
|
$sql = 'CALL sp_ajouter_adherent(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'],$numeroAdherent, $nom, $prenoms, $codeNaturePiece, $numeroPiece, $sexe,
|
|
$dateNaissance, $codeGroupeSanguin, $codeSituationFamille, $nombreEnfants, $adresseGeo, $adressePostale,
|
|
$codePays, $telephonFixe, $telephonePortable, $email, $dateEntree, $dateCre, $user, $idAvenant, $idCollege))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['dernierId'];
|
|
}
|
|
|
|
public function getIdBeneficiaireAdherent($idAdherent)
|
|
{
|
|
$sql = 'CALL sp_get_Id_Beneficiaire_Adherent(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['id'];
|
|
}
|
|
|
|
public function modifier($id, $nom, $prenoms, $codeNaturePiece, $numeroPiece, $sexe, $dateNaissance, $codeGroupeSanguin,
|
|
$codeSituationFamille, $nombreEnfants, $adresseGeo, $adressePostale, $codePays, $telephonFixe, $telephonePortable, $email,
|
|
$codeLocalite, $numeroCmu, $numeroMatricule, $codeTarifActe, $dateSouscription, $vip, $seuilRdAdherent, $ancienNumeroAssure,
|
|
$numeroBs, $codeTypeRemboursement, $prefixePaiementMobile, $mobilePaiement)
|
|
{
|
|
$sql = 'CALL sp_modifier_adherent(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);';
|
|
|
|
$this->executerRequete($sql, array($nom, $prenoms, $codeNaturePiece, $numeroPiece, $sexe, $dateNaissance, $codeGroupeSanguin,
|
|
$codeSituationFamille, $nombreEnfants, $adresseGeo, $adressePostale, $codePays, $telephonFixe, $telephonePortable, $email, $codeLocalite,
|
|
$numeroCmu, $numeroMatricule, $numeroMatricule, $codeTarifActe, $dateSouscription, $vip, $id, $seuilRdAdherent, $ancienNumeroAssure,
|
|
$numeroBs, $codeTypeRemboursement, $prefixePaiementMobile, $mobilePaiement));
|
|
|
|
$idBeneficiaire = $this->getIdBeneficiaireAdherent($id);
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_update_beneficiaire_principal(?);';
|
|
|
|
$this->executerRequete($sql, array($id));
|
|
|
|
$sql = 'CALL sp_modifier_beneficiaireprime(?, ?);';
|
|
$this->executerRequete($sql, array($idBeneficiaire, $user));
|
|
}
|
|
|
|
public function supprimer($idAdherent)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_supprimer_adherent(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $user));
|
|
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$this->getNbassure($idPolice);
|
|
}
|
|
|
|
public function formaterNumeroAdherent($racineNoAdherent,$numeroAdherent)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
|
|
$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 getAdherentsSimple($idPolice)
|
|
{
|
|
$sql = 'CALL sp_get_Adherents_Simple(?,?)';
|
|
|
|
$adherents = $this->executerRequete($sql, array($_SESSION['codeSociete'], $idPolice));
|
|
return $adherents;
|
|
}
|
|
|
|
public function getNbassure($idPolice) {
|
|
// nb famille et de dépendants
|
|
$sql = 'CALL sp_popoulation_police(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice));
|
|
// $effectif = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$effectif = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
$_SESSION['ndAdh_C'] = $effectif['ndAdh'];
|
|
$_SESSION['ndDep_C'] = $effectif['ndDep'];
|
|
$_SESSION['ndActif_C'] = $effectif['ndActif'];
|
|
}
|
|
|
|
public function getRapportSpAdherent($idAdherent, $dateReference)
|
|
{
|
|
$sql = 'call sp_rapport_sp_adherent(?, ?)';
|
|
|
|
$sppolice = $this->executerRequete($sql, array($idAdherent, $dateReference));
|
|
return $sppolice->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function changeretat($idAdherent, $codeEtatAdherent, $motifEtat, $dateEtat)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$sql = 'call sp_changer_etat_adherent(?, ?, ?, ?, ?)';
|
|
$this->executerRequete($sql, array($idAdherent, $codeEtatAdherent, $motifEtat, $dateEtat, $user));
|
|
}
|
|
|
|
public function initLimiteAdditionnelle($idAdherent)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_init_limite_add_adherent(?, ?)';
|
|
$this->executerRequete($sql, array($idAdherent, $user));
|
|
}
|
|
|
|
public function getGarAddCollege()
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$sql = 'CALL sp_get_GarAddCollege(?);';
|
|
|
|
$garanties = $this->executerRequete($sql, array($user));
|
|
return $garanties;
|
|
}
|
|
|
|
public function majplafondadd($idGarantie, $plafond)
|
|
{
|
|
$sql = 'CALL sp_majplafondadd(?,?)';
|
|
$this->executerRequete($sql, array($plafond, $idGarantie));
|
|
}
|
|
|
|
public function changerlimite($idAdherent)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_changer_limite_adherent(?, ?)';
|
|
$this->executerRequete($sql, array($idAdherent, $user));
|
|
}
|
|
|
|
public function recalculersoldefamille()
|
|
{
|
|
$idAdherent = $_SESSION['idAdherent_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_recalcul_solde_famille(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idAdherent, $user));
|
|
}
|
|
|
|
public function initremplacementadherent($idPolice, $idAdherent, $dateSortie , $dateRemplacement, $user,
|
|
$motifAvenant, $fraisCarte)
|
|
{
|
|
$sql = 'call sp_init_remplacement_adherent(?, ?, ?, ?, ?, ?, ?)';
|
|
$this->executerRequete($sql, array($idPolice, $idAdherent, $dateSortie , $dateRemplacement, $user, $motifAvenant, $fraisCarte));
|
|
}
|
|
|
|
public function getbeneficiairearemplacer()
|
|
{
|
|
$idAdherent = $_SESSION['idAdherent_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_get_beneficiaire_a_remplacer(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $user));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function getadherentremplacanttemp()
|
|
{
|
|
$idAdherent = $_SESSION['idAdherent_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_get_adherent_remplacant_temp(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $user));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function getremplacementadherent_temp()
|
|
{
|
|
$idAdherent = $_SESSION['idAdherent_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_get_remplacementadherent_temp(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $user));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function enregistrerremplacementadherent($nom, $prenoms, $codeNaturePiece, $numeroPiece, $sexe,
|
|
$dateNaissance, $codeGroupeSanguin, $codeSituationFamille, $nombreEnfants, $adresseGeo, $adressePostale,
|
|
$codePays, $telephonFixe, $telephonePortable, $email, $fraisCarte)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
$idAdherent = $_SESSION['idAdherent_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_enregistrer_remplacement_adherent(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $idAdherent, $user, $nom, $prenoms, $codeNaturePiece, $numeroPiece,
|
|
$sexe, $dateNaissance, $codeGroupeSanguin, $codeSituationFamille, $nombreEnfants, $adresseGeo, $adressePostale,
|
|
$codePays, $telephonFixe, $telephonePortable, $email, $fraisCarte));
|
|
}
|
|
|
|
public function getremplacementadherent($idAdherent)
|
|
{
|
|
$sql = 'call sp_get_remplacementadherent_id_remplace(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getgarantieremplacementadherent($idAdherent)
|
|
{
|
|
$sql = 'call sp_get_garantieremplacementadherent(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getbeneficiaireremplacementadherent($idRemplacementadherent)
|
|
{
|
|
$sql = 'call sp_get_beneficiairerremplacementadherent(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idRemplacementadherent));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getAdherentIdRempl($idAdherent)
|
|
{
|
|
$sql = 'call sp_get_adherent_id_rempl(?);';
|
|
$adherent = $this->executerRequete($sql, array($idAdherent));
|
|
return $adherent->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getlisteassuresexo($idPolice)
|
|
{
|
|
$sql = 'call sp_liste_assures_exo(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function reinitpaswd($idAdherent)
|
|
{
|
|
$sql = 'call sp_r_reinit_utilisateur_adh(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $idAdherent));
|
|
}
|
|
|
|
public function desactiver($idAdherent)
|
|
{
|
|
$sql = 'call sp_r_desactiver_utilisateur_adh(?)';
|
|
|
|
$this->executerRequete($sql, array($idAdherent));
|
|
}
|
|
|
|
public function activer($idAdherent)
|
|
{
|
|
$sql = 'call sp_r_activer_utilisateur_adh(?)';
|
|
|
|
$this->executerRequete($sql, array($idAdherent));
|
|
}
|
|
|
|
public function ajouteradherent($idPolice, $idCollege, $nom, $prenoms, $codeNaturePiece, $numeroPiece,
|
|
$sexe, $dateNaissance, $codeGroupeSanguin, $codeSituationFamille, $nombreEnfants, $adresseGeo, $adressePostale,
|
|
$codePays, $codeVille, $telephonFixe, $telephonePortable, $email, $dateEntree, $user, $idAvenant, $codeLocalite, $numeroCmu,
|
|
$numeroMatricule, $codeTarifActe, $dateSouscription, $vip, $seuilRdAdherent, $numeroBs, $ancienNumeroAssure, $beneficiaireReglement,
|
|
$codeLienBeneficiaire, $codeModePaiement, $enVigueur, $telephoneMobile, $rib, $codeTypeRemboursement, $prefixePaiementMobile, $mobilePaiement)
|
|
{
|
|
$sql = 'call sp_enregistrer_nouvel_adherent(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $idCollege, $nom, $prenoms, $codeNaturePiece, $numeroPiece, $sexe,
|
|
$dateNaissance, $codeGroupeSanguin, $codeSituationFamille, $nombreEnfants, $adresseGeo, $adressePostale, $codePays, $codeVille,
|
|
$telephonFixe, $telephonePortable, $email, $dateEntree, $user, $idAvenant, $codeLocalite, $numeroCmu, $numeroMatricule, $codeTarifActe,
|
|
$dateSouscription, $vip, $seuilRdAdherent, $numeroBs, $ancienNumeroAssure, $beneficiaireReglement, $codeLienBeneficiaire, $codeModePaiement,
|
|
$enVigueur, $telephoneMobile, $rib, $codeTypeRemboursement, $prefixePaiementMobile, $mobilePaiement));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$dernierIdAdherent = $ligne['dernierIdAdherent'];
|
|
return $dernierIdAdherent;
|
|
}
|
|
|
|
public function getlisteexo($idAdherent)
|
|
{
|
|
$sql = 'call sp_get_exercices_adherent(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getadherentlocalitein($codeLocalite)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
|
|
$sql = 'call sp_r_get_adherent_localite_in(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $codeLocalite));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getadherentlocaliteout($codeLocalite)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
|
|
$sql = 'call sp_r_get_adherent_localite_out(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $codeLocalite));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function ajouteradherentlocalitetous($codeLocalite)
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
|
|
$sql = 'call sp_r_ajouter_adherent_localite_tous(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $codeLocalite));
|
|
}
|
|
|
|
public function ajouterunadherentlocalite($idAherent, $codeLocalite)
|
|
{
|
|
$sql = 'call sp_r_ajouter_un_adherent_localite(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idAherent, $codeLocalite));
|
|
}
|
|
|
|
public function getadherentlocaliteexport()
|
|
{
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
|
|
$sql = 'call sp_r_get_adherent_localite_export(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getlisteentetecontrat($idAdherent)
|
|
{
|
|
$sql = 'call sp_get_entete_contrat_adherent(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
return $resultat->fetchAll(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);
|
|
}
|
|
|
|
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 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 getlisteadherentsBascules($codeGcAssureur, $codeProduit, $idPoliceBascule, $idCollege)
|
|
{
|
|
$sql = 'CALL sp_get_liste_adherents_Bascules(?,?,?,?);';
|
|
|
|
//var_dump($codeGcAssureur, $codeProduit, $idPoliceBascule, $idCollege);
|
|
//die();
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeGcAssureur, $codeProduit, $idPoliceBascule, $idCollege));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function ajouterAdherentBascules($codeGcAssureur, $codeProduit, $idPolice, $idCollege, $idOption, $numeroAdherent, $dateEffet)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_adherent_bascule(?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
//var_dump($codeGcAssureur, $codeProduit, $idPolice, $idCollege, $idOption, $numeroAdherent, $dateEffet, $user);
|
|
//die();
|
|
|
|
$this->executerRequete($sql, array($codeGcAssureur, $codeProduit, $idPolice, $idCollege, $idOption, $dateEffet, $numeroAdherent, $user));
|
|
|
|
}
|
|
|
|
|
|
public function ajouterTousAdherentBascules($codeGcAssureur, $codeProduit, $idPoliceBascule, $idCollege, $idOption, $dateEffet, $idCollegePolice)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$idPolice = $_SESSION['idPolice_C'];
|
|
|
|
|
|
if ($idCollegePolice > "0") {
|
|
$sql = 'call sp_ajouter_tousadherents_college_bascule(?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
/*
|
|
var_dump($codeGcAssureur, $codeProduit, $idPoliceBascule, $idCollege, $idOption, $dateEffet, $user, $idPolice, $idCollegePolice);
|
|
die();
|
|
*/
|
|
$this->executerRequete($sql, array($codeGcAssureur, $codeProduit, $idPoliceBascule, $idCollege, $idOption, $dateEffet, $user, $idPolice, $idCollegePolice));
|
|
|
|
}else{
|
|
$sql = 'call sp_ajouter_tousadherents_bascule(?, ?, ?, ?, ?, ?, ?, ?);';
|
|
/*
|
|
var_dump($codeGcAssureur, $codeProduit, $idPoliceBascule, $idCollege, $idOption, $dateEffet, $user, $idPolice);
|
|
die();
|
|
*/
|
|
$this->executerRequete($sql, array($codeGcAssureur, $codeProduit, $idPoliceBascule, $idCollege, $idOption, $dateEffet, $user, $idPolice));
|
|
}
|
|
}
|
|
|
|
public function getlisteassuresabasculer($idPolice)
|
|
{
|
|
$sql = 'call sp_liste_assures_a_basuler(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getlisteassurescollegeabasculer($idPolice, $idCollegePolice)
|
|
{
|
|
$sql = 'call sp_liste_assures_college_a_basuler(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $idCollegePolice));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function retirerAdherentBascules($numeroAdherent)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_adherent_bascule(?, ?);';
|
|
|
|
|
|
$this->executerRequete($sql, array($numeroAdherent, $user));
|
|
|
|
}
|
|
|
|
public function retirerTousAdherentBascules($codeGcAssureur, $codeProduit, $idPoliceBascule, $idCollege)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_tousadherents_bascule(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeGcAssureur, $codeProduit, $idPoliceBascule, $idCollege, $user));
|
|
|
|
}
|
|
|
|
// 23-01-2023
|
|
|
|
public function getlisteassuresparcollege($idPolice, $idCollegePolice)
|
|
{
|
|
$sql = 'call sp_liste_assures_par_college(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $idCollegePolice));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
//30-03-2023
|
|
public function getListeLimiteAdherent($idAdherent)
|
|
{
|
|
$sql = 'call sp_liste_limiteadherent_newversion(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
|
|
}
|
|
|
|
public function majPlafondAdherent($idLimite, $plafond, $motif)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql ="CALL sp_majplafondadherent(?, ?, ?, ?);";
|
|
|
|
$this->executerRequete($sql, array($idLimite, $plafond, $motif, $user));
|
|
|
|
}
|
|
|
|
//15-05-2023
|
|
public function getConsosAdherent($idAdherent)
|
|
{
|
|
$datePrestation = date('Y-m-d');
|
|
|
|
$sql = 'call sp_consos_adherent_newversion(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $datePrestation));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
|
|
public function getConsosTotalAdherent($idAdherent)
|
|
{
|
|
$datePrestation = date('Y-m-d');
|
|
|
|
$sql = 'call sp_consos_total_adherent_newversion(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $datePrestation));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
//25-05-2023
|
|
public function getadherentvide() {
|
|
$sql = 'call sp_adherent_vide();';
|
|
$resultat = $this->executerRequete($sql);
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function trouverAdherent($numero)
|
|
{
|
|
$numero = contruireParamLikeDebut($numero);
|
|
|
|
$sql = 'call sp_get_adherent_newversion(?)';
|
|
|
|
/*var_dump($codeTarifActe, $codePrestataire, $idAdherent, $delaiCarenceBeneficiaire, $anciennete, $libelle, $numeroFeuilleMaladie);
|
|
die();*/
|
|
$resultat = $this->executerRequete($sql, array($numero));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function trouverAdherentId($idAdherent)
|
|
{
|
|
|
|
$sql = 'call sp_get_adherent_id_newversion(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
//27-05-2023
|
|
public function getVerifieExistance($nom, $prenoms, $sexe, $dateNaissance, $idCollege)
|
|
{
|
|
$sql = 'SELECT fn_verifier_existance_adherent(?, ?, ?, ?, ?) AS existe;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($nom, $prenoms, $sexe, $dateNaissance, $idCollege))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['existe'];
|
|
|
|
}
|
|
|
|
//16-06-2023
|
|
public function getTmadherent()
|
|
{
|
|
$sql = 'CALL sp_gettmadherent();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function insererTmadherent($idAdherent, $dateEffet, $tm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmadherent(?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $dateEffet, $tm, $user));
|
|
|
|
}
|
|
|
|
public function getMaxDateEffetTmAdherent($idAdherent){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmadherent(?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
|
|
}
|
|
|
|
public function supprimerTmadherent($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmadherent(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
}
|
|
|
|
//20-06-2023
|
|
public function insererTmadherentacte($idAdherent, $dateEffet, $tm, $codeActe, $codeGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmadherent_acte(?, ?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $dateEffet, $tm, $user, $codeActe, $codeGarantie));
|
|
|
|
}
|
|
|
|
public function getTmadherentacte()
|
|
{
|
|
$sql = 'CALL sp_gettmadherent_acte();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
//
|
|
public function getMaxDateEffetTmAdherentacte($idAdherent, $codeActe, $codeGarantie){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmadherentacte(?, ?, ?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $codeActe, $codeGarantie))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
}
|
|
|
|
//21-06-2023
|
|
public function supprimerTmadherentacte($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmadherentacte(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
}
|
|
|
|
public function getTmadherentacteprestataire()
|
|
{
|
|
$sql = 'CALL sp_gettmadherent_acte_prestataire();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getMaxDateEffetTmAdherentacteprestataire($idAdherent, $codeActe, $codePrestataire, $codeGarantie){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmadherentacteprestataire(?, ?, ?, ?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $codeActe, $codePrestataire, $codeGarantie))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
|
|
}
|
|
|
|
public function insererTmadherentacteprestataire($idAdherent, $dateEffet, $tm, $codeActe, $codePrestataire, $codeGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmadherent_acte_prestataire(?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $dateEffet, $tm, $user, $codeActe, $codePrestataire, $codeGarantie));
|
|
|
|
}
|
|
|
|
public function supprimerTmadherentacteprestataire($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmadherentacteprestataire(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
|
|
}
|
|
|
|
//26-06-2023
|
|
public function getTmadherentgarantie()
|
|
{
|
|
$sql = 'CALL sp_gettmadherent_garantie();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getgarantie()
|
|
{
|
|
$sql = 'SELECT codeGarantie AS `code`,
|
|
libelle
|
|
FROM garantie;';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function insererTmadherentgarantie($idAdherent, $dateEffet, $tm, $codeGarantie)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmadherent_garantie(?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $dateEffet, $tm, $user, $codeGarantie));
|
|
|
|
}
|
|
|
|
public function getMaxDateEffetTmAdherentgarantie($idAdherent, $codeGarantie){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmadherentgarantie(?, ?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $codeGarantie))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
|
|
}
|
|
|
|
public function supprimerTmadherentgarantie($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmadherentgarantie(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
}
|
|
|
|
public function getTmadherentgarantieprestataire()
|
|
{
|
|
$sql = 'CALL sp_gettmadherent_garantie_prestataire();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function insererTmadherentgarantieprestataire($idAdherent, $dateEffet, $tm, $codeGarantie, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmadherent_garantie_prestataire(?, ?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $dateEffet, $tm, $user, $codeGarantie, $codePrestataire));
|
|
|
|
}
|
|
|
|
public function getMaxDateEffetTmAdherentgarantieprestataire($idAdherent, $codeGarantie, $codePrestataire){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmadherentgarantieprestataire(?, ?, ?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $codeGarantie, $codePrestataire))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
|
|
}
|
|
|
|
public function supprimerTmadherentgarantieprestataire($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmadherentgarantieprestataire(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
|
|
}
|
|
|
|
//
|
|
public function getTmadherentprestataire()
|
|
{
|
|
$sql = 'CALL sp_gettmadherent_prestataire();';
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function insererTmadherentprestataire($idAdherent, $dateEffet, $tm, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserertmadherent_prestataire(?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $dateEffet, $tm, $user, $codePrestataire));
|
|
|
|
}
|
|
|
|
public function getMaxDateEffetTmAdherentprestataire($idAdherent, $codePrestataire){
|
|
|
|
$sql="CALL sp_getmaxdateeffet_tmadherentprestataire(?, ?)";
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent, $codePrestataire))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['maxDateEffetGarantie'];
|
|
|
|
|
|
}
|
|
|
|
public function supprimerTmadherentprestataire($idTm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_tmadherentprestataire(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idTm, $user));
|
|
|
|
}
|
|
|
|
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 getBeneficiairesRemboursement($idAdherent) {
|
|
$sql = 'SELECT A.*, B.libelle AS lienBeneficiaire,
|
|
B.libelleEng AS lienBeneficiaireEng,
|
|
C.libelle AS modepaiement,
|
|
C.libelleEng AS modepaiementEng
|
|
FROM beneficiaireremboursement A
|
|
JOIN p_lienbeneficiaire B ON (A.codeLienBeneficiaire = B.codeLienBeneficiaire)
|
|
JOIN p_modepaiement C ON (A.codeModePaiement = C.codeModePaiement)
|
|
WHERE A.idAdherent=? ORDER BY A.id desc;';
|
|
|
|
$adherent = $this->executerRequete($sql, array($idAdherent));
|
|
return $adherent->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function ajouterbeneficiaireremboursement($idAdherent,$beneficiaireReglement,
|
|
$codeLienBeneficiaire,$codeModePaiement,$enVigueur,$telephoneMobile,$rib)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_ajouter_beneficiaire_remboursement(?,?,?,?,?,?,?,?,?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete,$idAdherent,$beneficiaireReglement,
|
|
$codeLienBeneficiaire,$codeModePaiement,$enVigueur,$telephoneMobile,$rib,$user));
|
|
|
|
}
|
|
|
|
|
|
public function getBeneficiaireRemboursementId($idData)
|
|
{
|
|
$sql = 'SELECT * FROM beneficiaireremboursement WHERE (id=?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idData));
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function enregistrerbeneficiaireremboursement($idData,$idAdherent,$beneficiaireReglement,
|
|
$codeLienBeneficiaire,$codeModePaiement,$enVigueur,$telephoneMobile,$rib)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_enregistrer_beneficiaire_remboursement(?,?,?,?,?,?,?,?,?,?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete,$idAdherent,$beneficiaireReglement,
|
|
$codeLienBeneficiaire,$codeModePaiement,$enVigueur,$telephoneMobile,$rib,$user,$idData));
|
|
|
|
}
|
|
|
|
public function getMandantaireRemboursement($idAdherent) {
|
|
|
|
$sql = 'CALL sp_afficher_beneficiaire_remboursement_direct(?);';
|
|
|
|
$adherent = $this->executerRequete($sql, array($idAdherent));
|
|
return $adherent->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getagemaxlienparente($idCollege, $codeLienParente)
|
|
{
|
|
$sql = 'select fn_age_max_lien_parente(?, ?) as ageMax;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idCollege, $codeLienParente));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['ageMax'];
|
|
}
|
|
|
|
public function getcollegeavenantfacturation($idPolice)
|
|
{
|
|
$sql = 'SELECT fn_college_avenant_facturation(?) AS idCollege;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['idCollege'];
|
|
}
|
|
|
|
|
|
public function getdateeffetpolice($idPolice)
|
|
{
|
|
$sql = 'SELECT fn_date_effet_police(?) AS dateEffet;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['dateEffet'];
|
|
}
|
|
|
|
public function initavenantfacturationadherent_temp($idCollege,$dateEntree,$user,$prorata)
|
|
{
|
|
$sql = 'CALL sp_init_adherent(?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idCollege,$dateEntree,$user,$prorata));
|
|
|
|
}
|
|
|
|
public function ajouteradherentfacturation($idPolice, $idCollege, $nom, $prenoms, $codeNaturePiece, $numeroPiece,
|
|
$sexe, $dateNaissance, $codeGroupeSanguin, $codeSituationFamille, $nombreEnfants, $adresseGeo, $adressePostale,
|
|
$codePays, $codeVille, $telephonFixe, $telephonePortable, $email, $dateEntree, $user, $idAvenant, $codeLocalite, $numeroCmu,
|
|
$numeroMatricule, $codeTarifActe, $dateSouscription, $vip, $seuilRdAdherent, $numeroBs, $ancienNumeroAssure, $beneficiaireReglement,
|
|
$codeLienBeneficiaire, $codeModePaiement, $enVigueur, $telephoneMobile, $rib, $codeTypeRemboursement)
|
|
{
|
|
$sql = 'call sp_ajouter_adherent_facturation(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $idCollege, $nom, $prenoms, $codeNaturePiece, $numeroPiece, $sexe,
|
|
$dateNaissance, $codeGroupeSanguin, $codeSituationFamille, $nombreEnfants, $adresseGeo, $adressePostale, $codePays, $codeVille,
|
|
$telephonFixe, $telephonePortable, $email, $dateEntree, $user, $idAvenant, $codeLocalite, $numeroCmu, $numeroMatricule, $codeTarifActe,
|
|
$dateSouscription, $vip, $seuilRdAdherent, $numeroBs, $ancienNumeroAssure, $beneficiaireReglement, $codeLienBeneficiaire, $codeModePaiement,
|
|
$enVigueur, $telephoneMobile, $rib, $codeTypeRemboursement));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
$dernierIdAdherent = $ligne['dernierIdAdherent'];
|
|
return $dernierIdAdherent;
|
|
}
|
|
|
|
public function aBeneficiaireRemboursement($idAdherent)
|
|
{
|
|
$sql = 'select fn_a_beneficiaire_remboursement(?) as aBen;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['aBen'];
|
|
}
|
|
|
|
public function addBeneficiaireRembAuto($idAdherent)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_ajouter_beneficiaire_remboursement_auto(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idAdherent, $user));
|
|
}
|
|
|
|
public function getPrestationsmensuelles($idAdherent){
|
|
|
|
if (isset($_SESSION['lang']) && $_SESSION['lang']=="en_US"){
|
|
$sql = 'call prestations_mensuelles_famille_eng(?)';
|
|
}else{
|
|
$sql = 'call prestations_mensuelles_famille(?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getPrestationsLiensParente($idAdherent){
|
|
|
|
if (isset($_SESSION['lang']) && $_SESSION['lang']=="en_US"){
|
|
|
|
$sql = 'call prestations_lienparente_famille_eng(?)';
|
|
}else{
|
|
$sql = 'call prestations_lienparente_famille(?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($idAdherent));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
} |