<?php
require_once 'Framework/Modele.php';

class Familleacte extends Modele {
	
    public function getListe($codeTypePrestation) 
	{
		$codeTarifActe 		= $_SESSION['p_codeTarifActe_C'];
		$actesHarmonises 	= $_SESSION['p_actesHarmonises'];

		if( isset($actesHarmonises) && ($actesHarmonises=="1") )
		{
			if (isset($_SESSION['p_lang']) && $_SESSION['p_lang']=="en_US")
			{
				$sql = 'CALL sp_p_liste_famille_actes_harmonises_eng(?);';
			}
			else
			{
				$sql = 'CALL sp_p_liste_famille_actes_harmonises(?);';
			}
			
			$liste = $this->executerRequete($sql, array($codeTypePrestation));
			
			return $liste->fetchAll(PDO::FETCH_ASSOC);
		}
		else
		{
			if (isset($_SESSION['p_lang']) && $_SESSION['p_lang']=="en_US")
			{
				$sql = 'CALL sp_p_liste_famille_actes_eng(?, ?);';
			}
			else
			{
				$sql = 'CALL sp_p_liste_famille_actes(?, ?);';
			}

			$liste = $this->executerRequete($sql, array($codeTarifActe, $codeTypePrestation));
			
			return $liste->fetchAll(PDO::FETCH_ASSOC);
		}
    }
	
    public function getListeComplet() 
	{
		$codeTarifActe 			= $_SESSION['p_codeTarifActe_C'];
		$actesHarmonises 		= $_SESSION['p_actesHarmonises'];
		$hospitalisation 		= $_SESSION['p_hospitalisation_C'];
		
		if( isset($actesHarmonises) && ($actesHarmonises=="1") )
		{
			if (isset($_SESSION['p_lang']) && $_SESSION['p_lang']=="en_US")
			{
				$sql = 'CALL sp_p_liste_actes_examens_harmonises_eng(?);';
			}
			else
			{
				$sql = 'CALL sp_p_liste_actes_examens_harmonises(?);';
			}
			
			$liste = $this->executerRequete($sql, array($hospitalisation));
			
			return $liste->fetchAll(PDO::FETCH_ASSOC);
		}
		else
		{
			if (isset($_SESSION['p_lang']) && $_SESSION['p_lang']=="en_US")
			{
				$sql = 'CALL sp_p_liste_actes_examens_eng(?, ?)';
			}
			else
			{
				$sql = 'CALL sp_p_liste_actes_examens(?, ?)';
			}

			$liste = $this->executerRequete($sql, array($codeTarifActe, $hospitalisation));
			
			return $liste->fetchAll(PDO::FETCH_ASSOC);
		}
    }
}