376 lines
12 KiB
PHP
Executable File
376 lines
12 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
|
|
class Reseausoins extends Modele
|
|
{
|
|
public function getReseausoins()
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'SELECT A.* FROM reseausoins A WHERE (A.codeSociete=?) AND (typeSysteme != "1") ORDER BY A.libelle;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
public function getReseausoin($id)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'SELECT A.id, A.codeSociete, A.codeReseau, A.libelleEng as libelle, descritpionReseau, tm
|
|
FROM reseausoins A WHERE (A.codeSociete=?) AND (A.id=?)';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'SELECT A.id, A.codeSociete, A.codeReseau, A.libelle, descritpionReseau, tm
|
|
FROM reseausoins A WHERE (A.codeSociete=?) AND (A.id=?)';
|
|
}
|
|
|
|
$reseausoin = $this->executerRequete($sql, array($_SESSION['codeSociete'], $id));
|
|
|
|
return $reseausoin->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
public function getNombreReseausoins()
|
|
{
|
|
$sql = 'select count(*) as nbReseausoin FROM reseausoins A WHERE (A.codeSociete=?)';
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete']));
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
return $ligne['nbReseausoin'];
|
|
}
|
|
|
|
public function ajouter($codeSociete, $codeReseau, $libelle, $descritpionReseau) {
|
|
$sql = 'INSERT INTO reseausoins (codeSociete, codeReseau, libelle, descritpionReseau) VALUES (?, ?, ?, ?)';
|
|
$this->executerRequete($sql, array($codeSociete, $codeReseau, $libelle, $descritpionReseau));
|
|
}
|
|
|
|
public function modifier($id, $codeReseau, $libelle, $descritpionReseau) {
|
|
$sql = 'UPDATE reseausoins SET codeReseau=?, libelle=?, descritpionReseau=? where (id=?)';
|
|
$this->executerRequete($sql, array($codeReseau, $libelle, $descritpionReseau, $id));
|
|
}
|
|
|
|
public function supprimer($id)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_supprimer_reseau_soins(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($id, $user));
|
|
}
|
|
|
|
public function existeligne($codeReseau) {
|
|
$sql = 'select id FROM reseausoins WHERE (codeSociete=?) and (codeReseau=?)';
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'],$codeReseau));
|
|
return ($resultat->rowCount() > 0);
|
|
}
|
|
|
|
public function getListe()
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'SELECT codeReseau as `code`, libelleEng as libelle FROM reseausoins WHERE (codeSociete=?)
|
|
AND (typeSysteme != "1") AND (actif = "1") order by libelle';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'SELECT codeReseau as `code`, libelle FROM reseausoins WHERE (codeSociete=?)
|
|
AND (typeSysteme != "1") AND (actif = "1") order by libelle';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql,array($_SESSION['codeSociete']));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getReseauProduit($codeProduit)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'SELECT a.codeReseau AS `code`, b.libelleEng as libelle
|
|
FROM produitreseau a
|
|
JOIN reseausoins b
|
|
ON (b.codeSociete = a.codeSociete)
|
|
AND (b.codeReseau = a.codeReseau)
|
|
WHERE (a.codeSociete= ?)
|
|
AND (a.codeProduit = ?)
|
|
AND (b.typeSysteme != "1")
|
|
AND (b.actif = "1") ORDER BY b.libelle';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'SELECT a.codeReseau AS `code`, b.libelle
|
|
FROM produitreseau a
|
|
JOIN reseausoins b
|
|
ON (b.codeSociete = a.codeSociete)
|
|
AND (b.codeReseau = a.codeReseau)
|
|
WHERE (a.codeSociete= ?)
|
|
AND (a.codeProduit = ?)
|
|
AND (b.typeSysteme != "1")
|
|
AND (b.actif = "1") ORDER BY b.libelle';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql,array($_SESSION['codeSociete'],$codeProduit));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
//
|
|
public function creerreseau($codeReseau, $libelle, $tm)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$codeReseau = "";
|
|
|
|
$sql = 'call sp_creer_reseau(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $libelle, $tm, $user));
|
|
}
|
|
|
|
public function enregistrermodif($idReseau, $libelle, $tm)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_modifier_reseau(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idReseau, $libelle, $tm, $user));
|
|
}
|
|
|
|
|
|
public function getreseausnonaccessibles($codeProduit)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'CALL sp_get_reseaus_non_accessibles_produit(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $codeProduit));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getreseausaccessibles($codeProduit)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'CALL sp_get_reseaus_accessibles_produit(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $codeProduit));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function existeligne_detailreseausoins_temp($codeReseau, $codePrestataire) {
|
|
$sql = 'select id FROM detailreseausoins_temp WHERE (codeSociete=?) and (codeReseau=?) and (codePrestataire=?)';
|
|
$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'], $codeReseau, $codePrestataire));
|
|
return ($resultat->rowCount() > 0);
|
|
}
|
|
|
|
public function ajouterun_detailreseausoins_temp($codeReseau,$codePrestataire){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
if($this->existeligne_detailreseausoins_temp($codeReseau, $codePrestataire))
|
|
{
|
|
die();
|
|
}
|
|
|
|
$sql = 'INSERT INTO detailreseausoins_temp (codeSociete,codeReseau,codePrestataire,codeUtilisateur)
|
|
VALUES (?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeReseau, $codePrestataire, $user));
|
|
}
|
|
|
|
public function ajoutertout_detailreseausoins_temp($codeReseau){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$this->retirertout_detailreseausoins_temp($codeReseau);
|
|
|
|
$sql = "CALL sp_r_ajoutertout_detailreseausoins_temp(?, ?, ?);";
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeReseau, $user));
|
|
}
|
|
|
|
public function rattacher_prestataires_reseau(){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$codeReseau = $_SESSION['codeReseau'];
|
|
$user = $_SESSION["login"];
|
|
$idSaisie = $_SESSION["idSaisie"];
|
|
|
|
$sql = 'call sp_r_rattacher_prestataires_reseau(?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeReseau, $user, $idSaisie));
|
|
|
|
}
|
|
|
|
public function retirerun_detailreseausoins_temp($codeReseau,$codePrestataire){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'DELETE FROM detailreseausoins_temp
|
|
WHERE codeSociete=?
|
|
AND codeReseau=?
|
|
AND codePrestataire=?
|
|
AND codeUtilisateur=?';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeReseau, $codePrestataire, $user));
|
|
}
|
|
|
|
public function retirertout_detailreseausoins_temp($codeReseau){
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'DELETE FROM detailreseausoins_temp
|
|
WHERE codeSociete=?
|
|
AND codeReseau=?
|
|
AND codeUtilisateur=?';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeReseau, $user));
|
|
}
|
|
|
|
public function ajouterunreseauproduit($codeProduit, $codeReseau)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_ajouter_reseau_produit(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeProduit, $codeReseau, $user));
|
|
}
|
|
|
|
public function retirerunreseauproduit($codeProduit, $codeReseau)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_retirer_reseau_produit(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeProduit, $codeReseau, $user));
|
|
}
|
|
|
|
public function retirertousreseauproduit($codeProduit)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_retirer_tous_reseau_produit(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeProduit, $user));
|
|
}
|
|
|
|
|
|
public function ajoutertousreseauproduit($codeProduit)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_ajouter_tous_reseau_produit(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeProduit, $user));
|
|
}
|
|
|
|
public function majtm($codeProduit, $codeReseau, $tm)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_maj_tm_reseau_produit(?, ?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeProduit, $codeReseau, $tm, $user));
|
|
}
|
|
|
|
// 15/08/2020 SOREL KONE
|
|
|
|
// Liste des prestataires non-affectés à un reseau de soin
|
|
|
|
public function getPrestatairesReseauNonAffectes($codeReseau)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'CALL sp_get_prestataires_reseau_non_affectes(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $codeReseau));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getPrestatairesReseauAffectes($codeReseau)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'CALL sp_get_prestataires_reseau_affectes(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $codeReseau));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function ajouterUnPrestataireReseau($codePrestataire, $codeReseau)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_ajouter_prestataire_reseau(?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codePrestataire, $codeReseau, $user));
|
|
}
|
|
|
|
public function retirerUnPrestataireReseau($codePrestataire, $codeReseau)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_retirer_prestataire_reseau(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codePrestataire, $codeReseau, $user));
|
|
}
|
|
|
|
public function retirerTousPrestatairesReseau($codeReseau)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_retirer_tous_prestataires_reseau(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeReseau, $user));
|
|
}
|
|
|
|
|
|
public function ajouterTousPrestatairesReseau($codeReseau)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_ajouter_tous_prestataires_reseau(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeReseau, $user));
|
|
}
|
|
|
|
|
|
public function dupliquerreseausoins($codeold, $libelle, $tm)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_dupliquer_reseausoins(?, ?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codeold, $libelle, $tm, $user));
|
|
}
|
|
|
|
public function getPrestatairesReseauPrestataireSoins($idPolice, $idCollege, $numeroAdherent, $numeroBeneficiaire)
|
|
{
|
|
// modifié le 10/04/2024 par KANE
|
|
/*
|
|
$sql = 'CALL sp_rechercher_reseau_soins_lie(?, ?, ?, ?);';
|
|
$resultat = $this->executerRequete($sql, array($idPolice, $idCollege, $numeroAdherent, $numeroBeneficiaire));
|
|
*/
|
|
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'CALL sp_get_detail_reseausoins_college(?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idPolice, $idCollege));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
} |