1111 lines
31 KiB
PHP
Executable File
1111 lines
31 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
|
|
class Detailtarifacte extends Modele {
|
|
|
|
public function getDetailtarifacte($codeTarifActe, $libelleActe)
|
|
{
|
|
$libelleActe = contruireParamLike($libelleActe);
|
|
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_afficher_detailtarifacte_eng(?, ?)';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_afficher_detailtarifacte(?, ?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeTarifActe, $libelleActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function majPrix($idDetail, $prix)
|
|
{
|
|
$sql = 'call sp_maj_prix_tarifacte_temp_new(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $prix));
|
|
}
|
|
|
|
public function majPrixGroupe($idDetail, $prix)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
// $sql = 'call sp_p_maj_tarifacte(?, ?)';
|
|
|
|
$sql = 'call sp_maj_un_acte_du_tarifgroupe(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $prix, $user));
|
|
}
|
|
|
|
public function majPrixPrestataire($idDetail, $prix)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
// $sql = 'call sp_p_maj_tarifacte(?, ?)';
|
|
|
|
$sql = 'call sp_maj_un_acte_du_tarifprestataire(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $prix, $user));
|
|
}
|
|
|
|
|
|
public function majprixnuitferier($idDetail, $prix)
|
|
{
|
|
|
|
$sql = 'call sp_maj_prix_nuit_tarifacte_temp_new(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $prix));
|
|
}
|
|
|
|
public function majprixnuitferiergroupe($idDetail, $prix)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_majprixnuit_un_acte_du_tarifgroupe(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $prix, $user));
|
|
}
|
|
|
|
public function majprixnuitferierprestataire($idDetail, $prix)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
// $sql = 'call sp_p_maj_tarifacte(?, ?)';
|
|
|
|
$sql = 'call sp_majprixnuit_un_acte_du_tarifprestataire(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $prix, $user));
|
|
}
|
|
|
|
|
|
public function getactesout($codeTarifActe, $codeFamilleActe)
|
|
{
|
|
$actesHarmonises = $_SESSION['actesHarmonises'];
|
|
|
|
//var_dump($actesHarmonises);
|
|
|
|
if( isset($actesHarmonises) && ($actesHarmonises=="1") )
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_afficher_acte_famille_sans_tarif_harmonise_eng(?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_afficher_acte_famille_sans_tarif_harmonise(?, ?);';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql, array($codeTarifActe, $codeFamilleActe));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
else
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_afficher_acte_famille_sans_tarif_eng(?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_afficher_acte_famille_sans_tarif(?, ?);';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql, array($codeTarifActe, $codeFamilleActe));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
}
|
|
|
|
|
|
public function getactesoutgroupe($codeTarifActe, $codeFamilleActe)
|
|
{
|
|
$actesHarmonises = $_SESSION['actesHarmonises'];
|
|
|
|
if( isset($actesHarmonises) && ($actesHarmonises=="1") )
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_affichergroupe_acte_famille_sans_tarif_harmonise_eng(?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_affichergroupe_acte_famille_sans_tarif_harmonise(?, ?);';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql, array($codeTarifActe, $codeFamilleActe));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
else
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_affichergroupe_acte_famille_sans_tarif_eng(?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_affichergroupe_acte_famille_sans_tarif(?, ?);';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql, array($codeTarifActe, $codeFamilleActe));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
}
|
|
|
|
|
|
public function getactesin($codeTarifActe, $codeFamilleActe, $reinitialiser)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_afficher_detailtarifacte_famille_temp_eng_new(?, ?, ?, ?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_afficher_detailtarifacte_famille_temp_new(?, ?, ?, ?, ?);';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql, array($codeTarifActe, $codeFamilleActe, $user, $idSaisie, $reinitialiser));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getactesingroupe($codeTarifActe, $codeFamilleActe, $codeGroupePrestataire)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_afficher_detailtarifactegroupe_famille_eng(?, ?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_afficher_detailtarifactegroupe_famille(?, ?, ?);';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql, array($codeTarifActe, $codeFamilleActe, $codeGroupePrestataire));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getactesinprestataire($codeTarifActe, $codeFamilleActe, $codePrestataire)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_afficher_detailtarifacteprestataire_famille_eng(?, ?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_afficher_detailtarifacteprestataire_famille(?, ?, ?);';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql, array($codeTarifActe, $codeFamilleActe, $codePrestataire));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function ajoutertousactsautarif($codeTarifActe, $codeFamilleActe)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
$actesHarmonises = $_SESSION['actesHarmonises'];
|
|
|
|
|
|
$sql = 'CALL sp_ajouter_tous_actes_au_tarif_temp_new(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $codeTarifActe, $codeFamilleActe, $user, $idSaisie));
|
|
}
|
|
|
|
public function ajoutertousactsautarifgroupe($codeTarifActe, $codeFamilleActe, $codeGroupePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$actesHarmonises = $_SESSION['actesHarmonises'];
|
|
|
|
|
|
$sql = 'CALL sp_ajouter_tous_actes_au_tarifgroupe(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $codeTarifActe, $codeFamilleActe, $codeGroupePrestataire, $user));
|
|
}
|
|
|
|
public function ajoutertousactsautarifprestataire($codeTarifActe, $codeFamilleActe, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$actesHarmonises = $_SESSION['actesHarmonises'];
|
|
|
|
|
|
$sql = 'CALL sp_ajouter_tous_actes_au_tarifprestataire(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $codeTarifActe, $codeFamilleActe, $codePrestataire, $user));
|
|
}
|
|
|
|
public function retirertousactsautarif($codeTarifActe, $codeFamilleActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_retirer_tous_actes_du_tarif(?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $codeTarifActe, $codeFamilleActe, $user));
|
|
}
|
|
|
|
public function retirertousactsautarifgroupe($codeTarifActe, $codeFamilleActe, $codeGroupePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_retirer_tous_actes_du_tarifgroupe(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $codeTarifActe, $codeFamilleActe, $codeGroupePrestataire, $user));
|
|
}
|
|
|
|
public function retirertousactsautarifprestataire($codeTarifActe, $codeFamilleActe, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_retirer_tous_actes_du_tarifprestataire(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $codeTarifActe, $codeFamilleActe, $codePrestataire, $user));
|
|
}
|
|
|
|
public function ajouterunacteautarif($idActe, $codeTarifActe)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_un_acte_au_tarif_temp_new(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idActe, $codeTarifActe, $user, $idSaisie));
|
|
}
|
|
|
|
|
|
public function ajouterunacteautarifgroupe($idActe, $codeTarifActe, $codeGroupePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_un_acte_au_tarifgroupe(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idActe, $codeTarifActe, $codeGroupePrestataire, $user));
|
|
}
|
|
|
|
|
|
public function ajouterunacteautarifprestataire($idActe, $codeTarifActe, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_un_acte_au_tarifprestataire(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idActe, $codeTarifActe, $codePrestataire, $user));
|
|
}
|
|
|
|
public function retirerunactedutarif($idDetailtarifacte)
|
|
{
|
|
|
|
$sql = 'call sp_retirer_un_acte_du_tarif(?)';
|
|
|
|
$this->executerRequete($sql, array($idDetailtarifacte));
|
|
}
|
|
|
|
|
|
public function retirerunactedutarifgroupe($idDetailtarifacte)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_un_acte_du_tarifgroupe(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetailtarifacte, $user));
|
|
}
|
|
|
|
public function retirerunactedutarifprestataire($idDetailtarifacte)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_un_acte_du_tarifprestataire(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetailtarifacte, $user));
|
|
}
|
|
|
|
public function exportertarifactes($codeTarifActe)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_exporter_tarifacte_actes_eng(?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_exporter_tarifacte_actes(?);';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql, array($codeTarifActe));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getentetetarifacte($codeTarifActe)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'SELECT codeTarifActe, libelleEng AS libelleTarif FROM p_tarifacte WHERE (codeTarifActe=?) LIMIT 1;';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'SELECT codeTarifActe, libelle AS libelleTarif FROM p_tarifacte WHERE (codeTarifActe=?) LIMIT 1;';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeTarifActe));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function exporterlisteactes($codeTarifActe)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_exporter_listes_actes_eng(?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_exporter_listes_actes(?);';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql, array($codeTarifActe));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
// 11/06/2021
|
|
public function getactesinpolice($codeTarifActe, $codeFamilleActe, $idPolice)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_afficher_detailtarifactepolice_famille_eng(?, ?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_afficher_detailtarifactepolice_famille(?, ?, ?);';
|
|
}
|
|
|
|
|
|
$liste = $this->executerRequete($sql, array($codeTarifActe, $codeFamilleActe, $idPolice));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function ajoutertousactsautarifpolice($codeTarifActe, $codeFamilleActe, $idPolice)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$actesHarmonises = $_SESSION['actesHarmonises'];
|
|
|
|
if( isset($actesHarmonises) && ($actesHarmonises=="1") )
|
|
{
|
|
$sql = 'CALL sp_ajouter_tous_actes_au_tarifpolice_harmonise(?, ?, ?, ?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_ajouter_tous_actes_au_tarifpolice(?, ?, ?, ?, ?);';
|
|
}
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $codeTarifActe, $codeFamilleActe, $idPolice, $user));
|
|
}
|
|
|
|
public function retirertousactsautarifpolice($codeTarifActe, $codeFamilleActe, $idPolice)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_retirer_tous_actes_du_tarifpolice(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $codeTarifActe, $codeFamilleActe, $idPolice, $user));
|
|
}
|
|
|
|
public function ajouterunacteautarifpolice($idActe, $codeTarifActe, $idPolice)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_un_acte_au_tarifpolice(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idActe, $codeTarifActe, $idPolice, $user));
|
|
}
|
|
|
|
public function retirerunactedutarifpolice($idDetailtarifacte)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_un_acte_du_tarifpolice(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetailtarifacte, $user));
|
|
}
|
|
|
|
public function majPrixPolice($idDetail, $prix)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
// $sql = 'call sp_p_maj_tarifacte(?, ?)';
|
|
|
|
$sql = 'call sp_maj_un_acte_du_tarifpolice(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $prix, $user));
|
|
}
|
|
|
|
public function majprixnuitferierpolice($idDetail, $prix)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
|
|
// $sql = 'call sp_p_maj_tarifacte(?, ?)';
|
|
|
|
$sql = 'call sp_majprixnuit_un_acte_du_tarifpolice(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $prix, $user));
|
|
}
|
|
|
|
// 20/07/2021
|
|
public function getactesinpoliceprestataire($codeTarifActe, $codeFamilleActe, $idPolice, $codePrestataire)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_afficher_detailtarifactepoliceprestataire_famille_eng(?, ?, ?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_afficher_detailtarifactepoliceprestataire_famille(?, ?, ?, ?);';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql, array($codeTarifActe, $codeFamilleActe, $idPolice, $codePrestataire));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function ajouterunacteautarifpoliceprestataire($idActe, $codeTarifActe, $idPolice, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_un_acte_au_tarifpoliceprestataire(?, ?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idActe, $codeTarifActe, $idPolice, $codePrestataire, $user));
|
|
}
|
|
|
|
public function ajoutertousactsautarifpoliceprestataire($codeTarifActe, $codeFamilleActe, $idPolice, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$actesHarmonises = $_SESSION['actesHarmonises'];
|
|
|
|
if( isset($actesHarmonises) && ($actesHarmonises=="1") )
|
|
{
|
|
$sql = 'CALL sp_ajouter_tous_actes_au_tarifpolice_prestataire_harmonise(?, ?, ?, ?, ?, ?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_ajouter_tous_actes_au_tarifpolice_prestataire(?, ?, ?, ?, ?, ?);';
|
|
}
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $codeTarifActe, $codeFamilleActe, $idPolice, $codePrestataire, $user));
|
|
}
|
|
|
|
public function retirertousactsautarifpoliceprestataire($codeTarifActe, $codeFamilleActe, $idPolice, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_retirer_tous_actes_du_tarifpoliceprestataire(?, ?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $codeTarifActe, $codeFamilleActe, $idPolice, $codePrestataire, $user));
|
|
}
|
|
|
|
public function retirerunactedutarifpoliceprestataire($idDetailtarifacte)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_un_acte_du_tarifpoliceprestataire(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetailtarifacte, $user));
|
|
}
|
|
|
|
public function majPrixPolicePrestataire($idDetail, $prix)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
// $sql = 'call sp_p_maj_tarifacte(?, ?)';
|
|
|
|
$sql = 'call sp_maj_un_acte_du_tarifpoliceprestataire(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $prix, $user));
|
|
}
|
|
|
|
public function majprixnuitferierpoliceprestataire($idDetail, $prix)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
// $sql = 'call sp_p_maj_tarifacte(?, ?)';
|
|
|
|
$sql = 'call sp_majprixnuit_un_acte_du_tarifpoliceprestataire(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $prix, $user));
|
|
}
|
|
|
|
public function majtauxappliquepoliceprestataire($idActe, $tauxApplique)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
// $sql = 'call sp_p_maj_tarifacte(?, ?)';
|
|
|
|
$sql = 'call sp_majtauxapplique_un_acte_du_tarifpoliceprestataire(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idActe, $tauxApplique, $user));
|
|
|
|
}
|
|
|
|
//09-05-2023
|
|
public function getactesexamenvide() {
|
|
$sql = 'call sp_p_actes_examen_vide()';
|
|
$resultat = $this->executerRequete($sql);
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getexamenspossibleshospitalisation($libelle)
|
|
{
|
|
$libelle = contruireParamLike($libelle);
|
|
|
|
$sql = 'call sp_actesbareme_hospitalisation_newversion(?)';
|
|
|
|
/*var_dump($codeTarifActe, $codePrestataire, $idAdherent, $delaiCarenceBeneficiaire, $anciennete, $libelle, $numeroFeuilleMaladie);
|
|
die();*/
|
|
$resultat = $this->executerRequete($sql, array($libelle));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
//20-05-2023
|
|
public function majeffet($idDetail, $dateEffet)
|
|
{
|
|
$sql = 'call sp_maj_dateeffet_tarifacte_temp_new(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetail, $dateEffet));
|
|
}
|
|
|
|
//21-05-2023
|
|
public function validertarif($codeTarifActe)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_valider_detailtarifacte_famille_temp_new(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeTarifActe, $user, $idSaisie));
|
|
}
|
|
|
|
//24-05-2023
|
|
//client
|
|
public function getClientPrestatairesDisponible($idClient, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_tarifclientprestataire_disponible(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idClient, $codeTarifActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function getClientPrestatairesTarifes($idClient, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_tarifclientprestataire_tarifes(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idClient, $codeTarifActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function ajouterTousPrestatairesTarifclient($idClient, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_tous_prestataires_tarifclient(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $idClient, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function ajouterUnPrestataireTarifClient($idClient, $codeTarifActe, $codePrestataire)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_prestataire_tarifclient(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codePrestataire, $idClient, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function retirerTousPrestatairesTarifClient($idClient, $codeTarifActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_tous_prestataires_tarifclient(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idClient, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function retirerUnPrestataireTarifClient($idClient, $codeTarifActe, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_prestataire_tarifclient(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codePrestataire, $idClient, $codeTarifActe, $user));
|
|
}
|
|
|
|
//25-05-2023
|
|
//police
|
|
public function getPolicePrestatairesDisponible($idPolice, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_tarifpoliceprestataire_disponible(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idPolice, $codeTarifActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function getPolicePrestatairesTarifes($idPolice, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_tarifpoliceprestataire_tarifes(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idPolice, $codeTarifActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function ajouterTousPrestatairesTarifPolice($idPolice, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_tous_prestataires_tarifpolice(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $idPolice, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function ajouterUnPrestataireTarifPolice($idPolice, $codeTarifActe, $codePrestataire)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_prestataire_tarifpolice(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codePrestataire, $idPolice, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function retirerTousPrestatairesTarifPolice($idPolice, $codeTarifActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_tous_prestataires_tarifpolice(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idPolice, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function retirerUnPrestataireTarifPolice($idPolice, $codeTarifActe, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_prestataire_tarifpolice(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codePrestataire, $idPolice, $codeTarifActe, $user));
|
|
}
|
|
|
|
//college
|
|
public function getCollegePrestatairesDisponible($idCollege, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_tarifcollegeprestataire_disponible(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idCollege, $codeTarifActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function getCollegePrestatairesTarifes($idCollege, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_tarifcollegeprestataire_tarifes(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idCollege, $codeTarifActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function ajouterTousPrestatairesTarifCollege($idCollege, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_tous_prestataires_tarifcollege(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $idCollege, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function ajouterUnPrestataireTarifCollege($idCollege, $codeTarifActe, $codePrestataire)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_prestataire_tarifcollege(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codePrestataire, $idCollege, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function retirerTousPrestatairesTarifCollege($idCollege, $codeTarifActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_tous_prestataires_tarifcollege(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idCollege, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function retirerUnPrestataireTarifCollege($idCollege, $codeTarifActe, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_prestataire_tarifcollege(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codePrestataire, $idCollege, $codeTarifActe, $user));
|
|
}
|
|
|
|
//26-05-2023
|
|
//adherent
|
|
public function getAdherentPrestatairesDisponible($idAdherent, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_tarifadherentprestataire_disponible(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idAdherent, $codeTarifActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function getAdherentPrestatairesTarifes($idAdherent, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_tarifadherentprestataire_tarifes(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idAdherent, $codeTarifActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function ajouterTousPrestatairesTarifAdherent($idAdherent, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_tous_prestataires_tarifadherent(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $idAdherent, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function ajouterUnPrestataireTarifAdherent($idAdherent, $codeTarifActe, $codePrestataire)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_prestataire_tarifadherent(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codePrestataire, $idAdherent, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function retirerTousPrestatairesTarifAdherent($idAdherent, $codeTarifActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_tous_prestataires_tarifadherent(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idAdherent, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function retirerUnPrestataireTarifAdherent($idAdherent, $codeTarifActe, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_prestataire_tarifadherent(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codePrestataire, $idAdherent, $codeTarifActe, $user));
|
|
}
|
|
|
|
//26-05-2023
|
|
//beneficiaire
|
|
public function getBeneficiairePrestatairesDisponible($idBeneficiaire, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_tarifbeneficiaireprestataire_disponible(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idBeneficiaire, $codeTarifActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function getBeneficiairePrestatairesTarifes($idBeneficiaire, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'call sp_tarifbeneficiaireprestataire_tarifes(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $idBeneficiaire, $codeTarifActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function ajouterTousPrestatairesTarifBeneficiaire($idBeneficiaire, $codeTarifActe)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_tous_prestataires_tarifbeneficiaire(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $idBeneficiaire, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function ajouterUnPrestataireTarifBeneficiaire($idBeneficiaire, $codeTarifActe, $codePrestataire)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_ajouter_prestataire_tarifbeneficiaire(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $codePrestataire, $idBeneficiaire, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function retirerTousPrestatairesTarifBeneficiaire($idBeneficiaire, $codeTarifActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_tous_prestataires_tarifbeneficiaire(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idBeneficiaire, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function retirerUnPrestataireTarifBeneficiaire($idBeneficiaire, $codeTarifActe, $codePrestataire)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_retirer_prestataire_tarifbeneficiaire(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codePrestataire, $idBeneficiaire, $codeTarifActe, $user));
|
|
}
|
|
|
|
public function supprimertarif($idDetailtarifacte)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_supprimer_tarifacte_temp_new(?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDetailtarifacte, $user));
|
|
}
|
|
|
|
//04-06-2023 ajouté par sorel
|
|
public function getsuppr($idDetailtarifacte)
|
|
{
|
|
$sql = 'SELECT fn_get_supprdetailtarif(?) AS suppr;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idDetailtarifacte))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['suppr'];
|
|
}
|
|
|
|
//21-06-2023
|
|
public function getprestatairevide() {
|
|
$sql = 'call sp_prestataire_vide()';
|
|
$resultat = $this->executerRequete($sql);
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getprestataire($libelle)
|
|
{
|
|
$libelle = contruireParamLike($libelle);
|
|
|
|
$sql = 'call sp_prestataire_newversion(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($libelle));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getactesexamenspossiblesproforma($libelle)
|
|
{
|
|
$libelle = contruireParamLike($libelle);
|
|
|
|
$idProforma = $_SESSION['idProforma'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_actes_proforma_hospitalisation(?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($libelle, $idProforma, $idSaisie, $user));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function exporterlistetousactes()
|
|
{
|
|
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'CALL sp_exporter_liste_tous_actes_eng(?);';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'CALL sp_exporter_liste_tous_actes(?);';
|
|
}
|
|
|
|
|
|
$liste = $this->executerRequete($sql, array($_SESSION['codeSociete']));
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function initimport($codeTarifActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_init_param_import_tarif_acte(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($codeTarifActe, $_SESSION['codeSociete'], $user));
|
|
}
|
|
|
|
public function getModeleTarif($codeTarifActe)
|
|
{
|
|
$sql = 'CALL sp_export_modele_tarif_acte(?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeTarifActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function initIinsererLigneModeleTarif($codeTarifActe)
|
|
{
|
|
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_init_inserer_ligne_modele_tarif_acte(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeTarifActe, $user));
|
|
|
|
}
|
|
|
|
public function insererLigneModeleTarif($codeActe, $prix, $prixNuitFerier)
|
|
{
|
|
$codeTarifActe = $_SESSION['codeTarifActe_C'];
|
|
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_inserer_ligne_modele_tarif_acte(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($user, $codeTarifActe, $codeActe, $prix, $prixNuitFerier));
|
|
|
|
}
|
|
|
|
public function majetape($codeTarifActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_r_maj_etape_3_import_tarif_acte(?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeTarifActe, $user));
|
|
|
|
}
|
|
|
|
public function getactesimportes($codeTarifActe, $codeFamilleActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_afficher_lignes_tatif_acte_importees(?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeTarifActe, $codeFamilleActe, $user));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getdoublonimportacte($codeActe) {
|
|
|
|
$codeTarifActe = $_SESSION['codeTarifActe_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_doublon_import(?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeTarifActe, $codeActe, $user));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['nbDoublon'];
|
|
// return ($resultat->rowCount());
|
|
}
|
|
|
|
public function acteimporteexite($codeActe)
|
|
{
|
|
$codeTarifActe = $_SESSION['codeTarifActe_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_acte_manquant_import(?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeTarifActe, $codeActe, $user));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['nbActe'];
|
|
}
|
|
|
|
public function nombreacteimportes()
|
|
{
|
|
$codeTarifActe = $_SESSION['codeTarifActe_C'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'CALL sp_nb_act_importes(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeTarifActe, $user));
|
|
|
|
$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $ligne['nbActeImportes'];
|
|
}
|
|
|
|
public function validerimporttarifacte($codeTarifActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_incorporer_tarif_acte_importes(?, ?, ?)';
|
|
|
|
/*
|
|
var_dump
|
|
(
|
|
array
|
|
(
|
|
"codeSociete" => $_SESSION['codeSociete'],
|
|
"codeTarifActe" => $codeTarifActe,
|
|
"user" => $user,
|
|
)
|
|
);
|
|
exit();
|
|
*/
|
|
|
|
$this->executerRequete($sql, array($_SESSION['codeSociete'], $codeTarifActe, $user));
|
|
}
|
|
|
|
|
|
}
|