934 lines
31 KiB
PHP
Executable File
934 lines
31 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
|
|
class Ententeprealable extends Modele {
|
|
|
|
public function getEntenteprealablesFeuilleMaladie($numeroFeuilleMaladie)
|
|
{
|
|
$sql = 'call sp_p_get_ententeprealable_feuillemaladie(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($numeroFeuilleMaladie));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEntenteprealables($codePrestataire, $codeReponseEntentePrealable, $debut, $fin)
|
|
{
|
|
$codePrestataire = contruireParamLike($codePrestataire);
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_get_ententeprealables_eng(?, ?, ?, ?)';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_get_ententeprealables(?, ?, ?, ?)';
|
|
}
|
|
|
|
//var_dump($codePrestataire, $codeReponseEntentePrealable, $debut, $fin);
|
|
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $codeReponseEntentePrealable, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getActesExclus($codePrestataire, $codeReponseAutorisation, $debut, $fin)
|
|
{
|
|
$codePrestataire = contruireParamLike($codePrestataire);
|
|
$codeReponseAutorisation = contruireParamLike($codeReponseAutorisation);
|
|
|
|
$sql = 'call sp_get_actes_exclus(?, ?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $codeReponseAutorisation, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEntenteprealableId($idDemandeententeprealable)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_get_ententeprealable_id_simple_eng(?)';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_get_ententeprealable_id_simple(?)';
|
|
}
|
|
|
|
|
|
$resultat = $this->executerRequete($sql, array($idDemandeententeprealable));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getActeExcluId($idDemandeautorisation)
|
|
{
|
|
$sql = 'call sp_get_acte_exclu_id_simple(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idDemandeautorisation));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function enregistrerrefusententeprealable($idDemandeententeprealable, $motifReel, $motifRefusAssure)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_refuser_ententeprealable(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $motifRefusAssure, $user));
|
|
}
|
|
|
|
public function enregistreraccordententeprealable_kine($idDemandeententeprealable, $motifReel, $quantiteModifiee)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_accepter_ententeprealable_kine(?, ?, ?, ?)';
|
|
|
|
//var_dump($idDemandeententeprealable, $motifReel, $user, $quantiteModifiee);die();
|
|
|
|
$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $user, $quantiteModifiee));
|
|
}
|
|
|
|
// ajouter par roger modifier le 28-10-2022 par sorel
|
|
public function enregistreraccordententeprealable_Hospit($idDemandeententeprealable, $motifReel, $quantiteModifieeHospit)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
//$sql = 'call sp_accepter_ententeprealable_hospit(?, ?, ?, ?)';
|
|
|
|
$sql = 'call sp_accepter_ententeprealable_hospitalisation_newversion(?, ?, ?, ?, ?)';
|
|
|
|
//var_dump($idDemandeententeprealable, $motifReel, $user, $quantiteModifieeHospit, $idSaisie); die();
|
|
|
|
$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $user, $quantiteModifieeHospit, $idSaisie));
|
|
}
|
|
|
|
public function enregistreraccordententeprealable($idDemandeententeprealable, $motifReel)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_accepter_ententeprealable(?, ?, ?)';
|
|
|
|
//var_dump($idDemandeententeprealable, $motifReel, $user);
|
|
//die();
|
|
|
|
$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $user));
|
|
}
|
|
|
|
public function getententeprealablesbenficiaire($idBeneficiaire, $d1, $d2)
|
|
{
|
|
$sql = 'call sp_get_ententeprealables_beneficiaire(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $d1, $d2));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getacteexclusbenficiaire($idBeneficiaire, $d1, $d2)
|
|
{
|
|
$sql = 'call sp_get_autorisations_beneficiaire(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire, $d1, $d2));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function enregistrerrefusacteexclu($idDemandeautorisation, $motifReel, $motifRefusAssure)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_refuser_autorisation(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDemandeautorisation, $motifReel, $motifRefusAssure, $user));
|
|
}
|
|
|
|
public function enregistreraccordacteexclu($idDemandeautorisation, $motifReel, $valeurActe)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_accepter_autorisation(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDemandeautorisation, $motifReel, $user, $valeurActe));
|
|
}
|
|
|
|
public function requetesententeprealable($codePrestataire, $dateDemande1, $dateDemande2, $numeroAdherent, $numeroBeneficiaire,
|
|
$numeroEntentePrealable1, $numeroEntentePrealable2, $codeReponseEntentePrealable, $adherent, $beneficiaire, $libelleActe, $libelleFamilleActe)
|
|
{
|
|
$codePrestataire = contruireParamLike($codePrestataire);
|
|
$numeroAdherent = contruireParamLike($numeroAdherent);
|
|
$numeroBeneficiaire = contruireParamLike($numeroBeneficiaire);
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
$adherent = contruireParamLike($adherent);
|
|
$beneficiaire = contruireParamLike($beneficiaire);
|
|
$libelleActe = contruireParamLike($libelleActe);
|
|
$libelleFamilleActe = contruireParamLike($libelleFamilleActe);
|
|
|
|
$sql = 'call sp_requetes_ententeprealable(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $dateDemande1, $dateDemande2, $numeroAdherent, $numeroBeneficiaire,
|
|
$numeroEntentePrealable1, $numeroEntentePrealable2, $codeReponseEntentePrealable, $adherent, $beneficiaire, $libelleActe, $libelleFamilleActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function requetesententeprealabletotal($codePrestataire, $dateDemande1, $dateDemande2, $numeroAdherent, $numeroBeneficiaire,
|
|
$numeroEntentePrealable1, $numeroEntentePrealable2, $codeReponseEntentePrealable, $adherent, $beneficiaire, $libelleActe, $libelleFamilleActe)
|
|
{
|
|
$codePrestataire = contruireParamLike($codePrestataire);
|
|
$numeroAdherent = contruireParamLike($numeroAdherent);
|
|
$numeroBeneficiaire = contruireParamLike($numeroBeneficiaire);
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
$adherent = contruireParamLike($adherent);
|
|
$beneficiaire = contruireParamLike($beneficiaire);
|
|
$libelleActe = contruireParamLike($libelleActe);
|
|
$libelleFamilleActe = contruireParamLike($libelleFamilleActe);
|
|
|
|
$sql = 'call sp_requetes_ententeprealable_total(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $dateDemande1, $dateDemande2, $numeroAdherent, $numeroBeneficiaire,
|
|
$numeroEntentePrealable1, $numeroEntentePrealable2, $codeReponseEntentePrealable, $adherent, $beneficiaire, $libelleActe, $libelleFamilleActe));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function requetesententeprealableexport($codePrestataire, $dateDemande1, $dateDemande2, $numeroAdherent, $numeroBeneficiaire,
|
|
$numeroEntentePrealable1, $numeroEntentePrealable2, $codeReponseEntentePrealable, $adherent, $beneficiaire, $libelleActe, $libelleFamilleActe)
|
|
{
|
|
$codePrestataire = contruireParamLike($codePrestataire);
|
|
$numeroAdherent = contruireParamLike($numeroAdherent);
|
|
$numeroBeneficiaire = contruireParamLike($numeroBeneficiaire);
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
$adherent = contruireParamLike($adherent);
|
|
$beneficiaire = contruireParamLike($beneficiaire);
|
|
$libelleActe = contruireParamLike($libelleActe);
|
|
$libelleFamilleActe = contruireParamLike($libelleFamilleActe);
|
|
|
|
$sql = 'call sp_requetes_ententeprealable_export(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $dateDemande1, $dateDemande2, $numeroAdherent, $numeroBeneficiaire,
|
|
$numeroEntentePrealable1, $numeroEntentePrealable2, $codeReponseEntentePrealable, $adherent, $beneficiaire, $libelleActe, $libelleFamilleActe));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEntenteprealablespha($codeReponseEntentePrealable, $debut, $fin)
|
|
{
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_get_ententeprealables_pha_eng(?, ?, ?)';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_get_ententeprealables_pha(?, ?, ?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeReponseEntentePrealable, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEntenteprealablephaId($idDemandeententeprealable)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_get_ententeprealable_pha_id_simple_eng(?)';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_get_ententeprealable_pha_id_simple(?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($idDemandeententeprealable));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function enregistreraccordententeprealablepha($idDemandeententeprealable, $motifReel, $prixAccorde, $quantiteAccorde)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_accepter_ententeprealable_pha(?, ?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $prixAccorde, $quantiteAccorde, $user));
|
|
}
|
|
|
|
public function enregistrerrefusententeprealablepha($idDemandeententeprealable, $motifReel, $motifRefusAssure)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_refuser_ententeprealable_pha(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $motifRefusAssure, $user));
|
|
}
|
|
|
|
public function requetesententeprealablepha($codePrestataire, $dateDemande1, $dateDemande2, $codeReponseEntentePrealable)
|
|
{
|
|
$codePrestataire = contruireParamLike($codePrestataire);
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
|
|
$sql = 'call sp_requetes_ententeprealable_pha(?, ?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $dateDemande1, $dateDemande2, $codeReponseEntentePrealable));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function requetesententeprealablephaexport($codePrestataire, $dateDemande1, $dateDemande2, $codeReponseEntentePrealable)
|
|
{
|
|
$codePrestataire = contruireParamLike($codePrestataire);
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
|
|
$sql = 'call sp_requetes_ententeprealable_pha_export(?, ?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $dateDemande1, $dateDemande2, $codeReponseEntentePrealable));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEntenteprealablesopt($codeReponseEntentePrealable, $debut, $fin)
|
|
{
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_get_ententeprealables_opt_eng(?, ?, ?)';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_get_ententeprealables_opt(?, ?, ?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeReponseEntentePrealable, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEntenteprealableoptId($idDemandeententeprealable)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_get_ententeprealable_opt_id_simple_eng(?)';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_get_ententeprealable_opt_id_simple(?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($idDemandeententeprealable));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
//
|
|
//public function enregistreraccordententeprealableopt($idDemandeententeprealable, $motifReel, $prixAccorde)
|
|
public function enregistreraccordententeprealableopt($idDemandeententeprealable, $motifReel)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_accepter_ententeprealable_opt(?, ?, ?)';
|
|
|
|
//$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $prixAccorde, $user));
|
|
$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $user));
|
|
}
|
|
|
|
public function enregistrerrefusententeprealableopt($idDemandeententeprealable, $motifReel, $motifRefusAssure)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_refuser_ententeprealable_opt(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $motifRefusAssure, $user));
|
|
}
|
|
|
|
// Ententeprealablesmont
|
|
|
|
public function getEntenteprealablesmont($codeReponseEntentePrealable, $debut, $fin)
|
|
{
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_get_ententeprealables_mont_eng(?, ?, ?)';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_get_ententeprealables_mont(?, ?, ?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeReponseEntentePrealable, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEntenteprealablemontId($idDemandeententeprealable)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_get_ententeprealable_mont_id_simple_eng(?)';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_get_ententeprealable_mont_id_simple(?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($idDemandeententeprealable));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
//
|
|
public function enregistreraccordententeprealablemont($idDemandeententeprealable, $motifReel, $prixAccorde)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_accepter_ententeprealable_mont(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $prixAccorde, $user));
|
|
}
|
|
|
|
public function enregistrerrefusententeprealablemont($idDemandeententeprealable, $motifReel, $motifRefusAssure)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_refuser_ententeprealable_mont(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $motifRefusAssure, $user));
|
|
}
|
|
|
|
public function getdernieresfacturesoptiques($idBeneficiaire)
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'call sp_get_derniereres_factures_optique_eng(?)';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'call sp_get_derniereres_factures_optique(?)';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($idBeneficiaire));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
// 31/05/2021
|
|
public function getApprobationSubstitutionpha($codeReponseEntentePrealable, $debut, $fin)
|
|
{
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
|
|
|
|
$sql = 'call sp_get_approbationsubstitution_pha(?, ?, ?)';
|
|
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeReponseEntentePrealable, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
// 01/06/2021
|
|
public function getApprobationSubstitutionphaId($idDemandesubstitution)
|
|
{
|
|
|
|
$sql = 'call sp_get_approbationsubstitution_pha_id_simple(?)';
|
|
|
|
|
|
$resultat = $this->executerRequete($sql, array($idDemandesubstitution));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function enregistrerapprobationsubstitutionpha($idDemandesubstitution, $motifReel)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_accepter_substitution_pha(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDemandesubstitution, $motifReel, $user));
|
|
}
|
|
|
|
// 02/06/2021
|
|
public function enregistrerrefussubstitutionpha($idDemandesubstitution, $motifReel, $motifRefusAssure)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_refuser_substitution_pha(?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idDemandesubstitution, $motifReel, $motifRefusAssure, $user));
|
|
}
|
|
|
|
public function getEntenteprealablesdent($codeReponseEntentePrealable, $debut, $fin)
|
|
{
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
|
|
|
|
$sql = 'call sp_get_ententeprealables_dent(?, ?, ?)';
|
|
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeReponseEntentePrealable, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEntenteprealableshospi($codeReponseEntentePrealable, $debut, $fin)
|
|
{
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
|
|
|
|
$sql = 'call sp_get_ententeprealables_hospi(?, ?, ?)';
|
|
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeReponseEntentePrealable, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function accepterrefusertouslesmedicaments($numeroFeuilleMaladie, $motifReel, $motifRefusAssure, $motifRefusPrestataire, $refuser, $accepter)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
|
|
$sql = 'call sp_accepter_refuser_tous_les_medicaments_ententeprealable(?, ?, ?, ?, ?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($numeroFeuilleMaladie, $motifReel, $motifRefusAssure, $motifRefusPrestataire, $refuser, $accepter, $user));
|
|
}
|
|
|
|
public function accepterrefusertouslesexamens($numeroFeuilleMaladie, $motifReel, $motifRefusAssure,$motifRefusPrestataire,$refuser,$accepter)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_accepter_refuser_tous_les_examens_ententeprealable(?, ?, ?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($numeroFeuilleMaladie, $motifReel, $motifRefusAssure, $motifRefusPrestataire, $refuser, $accepter, $user));
|
|
}
|
|
|
|
public function getEntenteprealablesproformahospi($demandeTraite, $debut, $fin)
|
|
{
|
|
$demandeTraite = contruireParamLike($demandeTraite);
|
|
|
|
$sql = 'call sp_get_ententeprealables_proformahospi(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($demandeTraite, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEnteteEntenteprealables($codePrestataire, $demandeTraite, $debut, $fin)
|
|
{
|
|
$codePrestataire = contruireParamLike($codePrestataire);
|
|
$demandeTraite = contruireParamLike($demandeTraite);
|
|
|
|
$sql = 'call sp_get_entete_ententeprealables_act_exam(?, ?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $demandeTraite, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function initTraitementEntentePrealable($idEnteteEntentePrealable)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_init_traitement_entente_prealable(?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user));
|
|
|
|
}
|
|
|
|
|
|
public function getEnteteEntenteprealableTemp($idEnteteEntentePrealable)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_get_entete_entente_prealable_temp(?,?,?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function getEntenteprealableTemp($idEnteteEntentePrealable)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_get_entente_prealable_temp(?,?,?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function traitementprovisoire($idExamen, $codeReponseProvisoire)
|
|
{
|
|
$sql = 'call sp_p_accepter_entente_prealable_temp(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idExamen, $codeReponseProvisoire));
|
|
|
|
}
|
|
|
|
public function traitementprovisoiretous($codeReponseProvisoire, $idEnteteEntentePrealable)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_accepter_entente_prealable_temp_tous(?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user, $codeReponseProvisoire));
|
|
|
|
}
|
|
|
|
public function getEnteteEntenteprealableType($codePrestataire, $codeTypeEntentePrealable, $demandeTraite, $debut, $fin)
|
|
{
|
|
$codePrestataire = contruireParamLike($codePrestataire);
|
|
$demandeTraite = contruireParamLike($demandeTraite);
|
|
|
|
$sql = 'call sp_get_entete_ententeprealables(?, ?, ?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codePrestataire, $codeTypeEntentePrealable, $demandeTraite, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function validerententeprealable($observations, $motifRefusAssure)
|
|
{
|
|
$idEnteteEntentePrealable = $_SESSION['idEnteteEntentePrealable'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_valider_traitement_entente_prealable(?, ?, ?, ?, ?);';
|
|
|
|
//var_dump($idEnteteEntentePrealable, $idSaisie, $user, $observations, $motifRefusAssure); die();
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user, $observations, $motifRefusAssure));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function majobservationactexam($observations)
|
|
{
|
|
$idEnteteEntentePrealable = $_SESSION['idEnteteEntentePrealable'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_maj_observations_entente_prealable(?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user, $observations));
|
|
}
|
|
|
|
public function majmotifrefusactexam($motifRefusAssure)
|
|
{
|
|
$idEnteteEntentePrealable = $_SESSION['idEnteteEntentePrealable'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_maj_motif_entente_prealable(?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user, $motifRefusAssure));
|
|
}
|
|
|
|
public function majdemandeententeprealabltemp($idEnteteEntentePrealable)
|
|
{
|
|
$sql = 'call sp_p_maj_demandeententeprealable_temp(?);';
|
|
|
|
$this->executerRequete($sql, array($idEnteteEntentePrealable));
|
|
}
|
|
|
|
public function initTraitementEntentePrealableMedicament($idEnteteEntentePrealable)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_init_traitement_entente_prealable_pha(?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user));
|
|
|
|
}
|
|
|
|
public function getEntenteprealableTempPha($idEnteteEntentePrealable)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
|
|
$sql = 'call sp_p_get_entente_prealable_pha_temp(?,?,?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function traitementprovisoirepha($idMedicament, $codeReponseProvisoire)
|
|
{
|
|
$sql = 'call sp_p_accepter_entente_prealable_pha_temp(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idMedicament, $codeReponseProvisoire));
|
|
|
|
}
|
|
|
|
public function traitementprovisoiretouspha($codeReponseProvisoire, $idEnteteEntentePrealable)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_accepter_entente_prealable_pha_temp_tous(?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user, $codeReponseProvisoire));
|
|
|
|
}
|
|
|
|
public function majquantiteprovisoire($idExamen, $quantite)
|
|
{
|
|
$idEnteteEntentePrealable = $_SESSION['idEnteteEntentePrealable'];
|
|
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
//var_dump($idEnteteEntentePrealable, $idExamen, $idSaisie, $user, $quantite);
|
|
|
|
$sql = 'call sp_p_majquantiteprovisoire_temp(?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idExamen, $idSaisie, $user, $quantite));
|
|
|
|
}
|
|
|
|
public function majquantiteprovisoire_pha($idMedicament, $quantite)
|
|
{
|
|
$sql = 'call sp_p_majquantiteprovisoirepha_temp(?, ?);';
|
|
|
|
|
|
$resultat = $this->executerRequete($sql, array($idMedicament, $quantite));
|
|
|
|
}
|
|
|
|
public function getEntenteprealablessea($codeReponseEntentePrealable, $debut, $fin)
|
|
{
|
|
$codeReponseEntentePrealable = contruireParamLike($codeReponseEntentePrealable);
|
|
|
|
|
|
$sql = 'call sp_get_ententeprealables_sea(?, ?, ?)';
|
|
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeReponseEntentePrealable, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function initTraitementEntentePrealableOptique($idEnteteEntentePrealable)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_init_traitement_entente_prealable_opt(?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user));
|
|
|
|
}
|
|
|
|
public function getEntenteprealableTempOpt($idEnteteEntentePrealable)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
|
|
$sql = 'call sp_p_get_entente_prealable_opt_temp(?,?,?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function traitementprovisoireopt($idMedicament, $codeReponseProvisoire)
|
|
{
|
|
$sql = 'call sp_p_accepter_entente_prealable_opt_temp(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idMedicament, $codeReponseProvisoire));
|
|
|
|
}
|
|
|
|
public function traitementprovisoiretousopt($codeReponseProvisoire, $idEnteteEntentePrealable)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_accepter_entente_prealable_opt_temp_tous(?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idEnteteEntentePrealable, $idSaisie, $user, $codeReponseProvisoire));
|
|
|
|
}
|
|
|
|
public function getprescription($numeroFeuilleMaladie)
|
|
{
|
|
$sql = 'call sp_get_prescription_feuillemaladie(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($numeroFeuilleMaladie));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function getdetailprescription($numeroFeuilleMaladie)
|
|
{
|
|
$sql = 'call sp_get_detailprescription_feuillemaladie(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($numeroFeuilleMaladie));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function getNumeroBonPrescrit($codeTypeEntentePrealable, $numeroFeuilleMaladie)
|
|
{
|
|
$sql = 'SELECT fn_numero_bon_prescrit(?, ?) AS numeroBon;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeTypeEntentePrealable, $numeroFeuilleMaladie))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['numeroBon'];
|
|
}
|
|
|
|
//public function getEnteteEntenteprealablesProformaHospit($codePrestataire, $demandeTraite, $debut, $fin)
|
|
public function getEnteteEntenteprealablesProformaHospit($demandeTraite, $debut, $fin)
|
|
{
|
|
//$codePrestataire = contruireParamLike($codePrestataire);
|
|
$demandeTraite = contruireParamLike($demandeTraite);
|
|
|
|
//$sql = 'call sp_get_entete_ententeprealables_proforma_hospit(?, ?, ?, ?)';
|
|
$sql = 'call sp_get_entete_ententeprealables_proforma_hospit(?, ?, ?)';
|
|
|
|
//$resultat = $this->executerRequete($sql, array($codePrestataire, $demandeTraite, $debut, $fin));
|
|
$resultat = $this->executerRequete($sql, array($demandeTraite, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getRenouvellementMedicament($demandeTraite, $debut, $fin)
|
|
{
|
|
$demandeTraite = contruireParamLike($demandeTraite);
|
|
|
|
$sql = 'call sp_get_entete_renouvellement_medicament(?, ?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($demandeTraite, $debut, $fin));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
public function initTraitementRenouvellementMedicament($idPrescription)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
// $sql = 'call sp_p_init_traitement_entente_prealable_pha(?, ?, ?);';
|
|
$sql = 'call sp_p_init_traitement_renouvellement_medicament(?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPrescription, $idSaisie, $user));
|
|
|
|
}
|
|
|
|
public function getEnteteRenouvellementMedicamentTemp($idPrescription)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_get_entete_renouvellement_medicament_temp(?,?,?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPrescription, $idSaisie, $user));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getRenouvellementMedicamentTemp($idPrescription)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
|
|
$sql = 'call sp_p_get_renouvellement_medicament_temp(?,?,?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPrescription, $idSaisie, $user));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function majquantiteprovisoire_renouv($idMedicament, $quantite)
|
|
{
|
|
$sql = 'call sp_p_majquantiteprovisoirepha_temp(?, ?);';
|
|
|
|
|
|
$resultat = $this->executerRequete($sql, array($idMedicament, $quantite));
|
|
|
|
}
|
|
|
|
public function majdureetraitement_renouv($idMedicament, $dureeTraitement)
|
|
{
|
|
$sql = 'call sp_p_maj_duree_traitement_renouv_temp(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idMedicament, $dureeTraitement));
|
|
}
|
|
|
|
public function traitementprovisoiretousrenmedic($codeReponseProvisoire, $idPrescription)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
/*
|
|
var_dump
|
|
(
|
|
array
|
|
(
|
|
"idEnteteEntentePrealable" => $idEnteteEntentePrealable,
|
|
"idSaisie" => $idSaisie,
|
|
"user" => $user,
|
|
"idPrescription" => $idPrescription
|
|
)
|
|
);
|
|
exit();
|
|
|
|
*/
|
|
|
|
$sql = 'call sp_p_accepter_entente_prealable_ren_medic_temp_tous(?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPrescription, $idSaisie, $user, $codeReponseProvisoire));
|
|
}
|
|
|
|
public function traitementprovisoirerenmedic($idMedicament, $codeReponseProvisoire)
|
|
{
|
|
$sql = 'call sp_p_accepter_renouvellement_medicament_temp(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idMedicament, $codeReponseProvisoire));
|
|
|
|
}
|
|
|
|
public function validerrenouvellementmedicament($observations, $motifRefusAssure)
|
|
{
|
|
$idPrescription = $_SESSION['idPrescription'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_valider_traitement_renouvellement_medicament(?, ?, ?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idPrescription, $idSaisie, $user, $observations, $motifRefusAssure));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function enregistreraffection($numeroFeuilleMaladie, $codeAffection)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_enregistrer_affection(?, ?, ?)';
|
|
|
|
|
|
$this->executerRequete($sql, array($numeroFeuilleMaladie, $codeAffection, $user));
|
|
}
|
|
|
|
} |