production/Modele/Ententeprealable_new.php

<?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(?, ?, ?, ?)';
		}
		
		$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_quantitemodifiee($idDemandeententeprealable, $motifReel, $quantiteModifiee)
	{
		$user = $_SESSION['login'];
		
		$sql = 'call sp_accepter_ententeprealable_quantitemodifiee(?, ?, ?, ?)';
		
		$this->executerRequete($sql, array($idDemandeententeprealable, $motifReel, $user, $quantiteModifiee));
    }	
	
	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 getBaremePlafondAdherent($idAdherent, $idBeneficiaire)
	{
		$sql = 'call sp_p_afficher_baremeplafonne_adherent(?, ?);';

		$resultat = $this->executerRequete($sql, array($idAdherent, $idBeneficiaire));
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
}