<?php
require_once 'Framework/Modele.php';
class Tabacteconsultation extends Modele{
	
	public function getlisteracteconsultation(){
		$sql = "SELECT A.*, B.libelle AS acte, B.libelleEng AS acteEng,
				C.libelleTypeConsulattion AS typeConsulation, C.libelleEng AS typeConsulationEng,
				D.libelle AS specialite, D.libelleEng AS specialiteEng
				FROM p_acteconsultation A
				JOIN p_acte B ON (B.codeActe = A.codeActe)
				JOIN p_typeconsultation C ON (C.codetypeConsultation = A.codetypeConsultation)
				LEFT JOIN p_specialite D ON (A.codeSpecialite = D.codeSpecialite)
				ORDER BY B.libelle;";
		
		$resultat = $this->executerRequete($sql);
        return $resultat->fetchAll(PDO::FETCH_ASSOC);
	}

	public function getacteconsultation($id){
		$sql = "SELECT *
				FROM p_acteconsultation 
				WHERE (id = ?);";
		
		$resultat = $this->executerRequete($sql, array($id));
        return $resultat->fetch(PDO::FETCH_ASSOC);
	}
	

	public function ajouteracteconsultation($codeActe, $codeTypeConsultation, $codeSpecialite,
	$visibleEnConsultation, $nuitFerie) {
		
	$codeSociete = $_SESSION['codeSociete'];
	$user = $_SESSION['login']; 
		
    $sql = 'INSERT INTO p_acteconsultation(codeActe, codeTypeConsultation, codeSpecialite, visibleEnConsultation,
			nuitFerie, codeUtilisateur, codeSociete) 
            VALUES (?, ?, ?, ?, ?, ?, ?);';

    $this->executerRequete($sql, array($codeActe, $codeTypeConsultation, $codeSpecialite, $visibleEnConsultation, $nuitFerie, 
	$user, $codeSociete));
}

	
	public function modifieracteconsultation($codeTypeConsultation, $codeSpecialite, $visibleEnConsultation, $nuitFerie, $id){
		$user = $_SESSION['login'];
		
		$sql = 'UPDATE 	p_acteconsultation 
				SET    	codeTypeConsultation = ?, 
						codeSpecialite = ?,
						visibleEnConsultation = ?,
						nuitFerie = ?,
						codeUtilisateur = ?
				WHERE (id = ?);';
		
		$this->executerRequete($sql, array($codeTypeConsultation, $codeSpecialite, $visibleEnConsultation, $nuitFerie, $user,$id));
	}
	

	public function supprimeracteconsultation($id){
		$sql = 'DELETE FROM p_acteconsultation 
				WHERE (id = ?);';
		
		$this->executerRequete($sql, array($id));
	}
	
	///////////////////////////////////////////////////////
	
	public function selectionnerune($id){
		$sql = "UPDATE p_acteconsultation 
				SET choix='1' WHERE (id = ?);";
		
		$this->executerRequete($sql, array($id));
	}
	
	public function deselectionnerune($id){
		$sql = "UPDATE p_acteconsultation 
				SET choix='0' WHERE (id = ?);";
		
		$this->executerRequete($sql, array($id));
	}

	public function selectionnertoutes(){
		$sql = "UPDATE p_acteconsultation 
				SET choix='1';";
		
		$this->executerRequete($sql);
	}
	
	public function deselectionnertoutes(){

		$sql = "UPDATE p_acteconsultation 
				SET choix='0';";
		
		$this->executerRequete($sql);
	}
	
	public function existeSelection() {
        $sql = 'select id FROM p_acteconsultation WHERE (choix="1")';
        $resultat = $this->executerRequete($sql);
		return ($resultat->rowCount() > 0);
    }
	
	public function getid($id){
		$sql = "SELECT * FROM p_acteconsultation 
				WHERE (id = ?);";
		
		$resultat = $this->executerRequete($sql, array($id));
        return $resultat->fetch(PDO::FETCH_ASSOC);
	}
	
	public function supprimertoutes(){
		$sql = 'DELETE FROM p_acteconsultation;';
		
		$this->executerRequete($sql);
	}
	
	public function supprimerchoix(){
		$sql = "DELETE FROM p_acteconsultation 
				WHERE (choix='1');";
		
		$this->executerRequete($sql);
	}
	
	public function getlisteactes()
	{
		if (est_anglophone()){
			$sql = "SELECT B.codeActe AS `code`, B.libelleEng AS libelle
					FROM p_acte B 	
					WHERE (B.codeTypePrestation='CONS')	
					-- AND (B.codeFamilleActe IN ('FA001','A000'))
					AND B.codeActe NOT IN (SELECT codeActe FROM p_acteconsultation)
					ORDER BY B.libelleEng;";
		}else{
			$sql = "SELECT B.codeActe AS `code`, B.libelle
					FROM p_acte B 	
					WHERE (B.codeTypePrestation='CONS')	
					-- AND (B.codeFamilleActe IN ('FA001','A000'))
					AND B.codeActe NOT IN (SELECT codeActe FROM p_acteconsultation)
					ORDER BY B.libelle;";
		}
		$resultat = $this->executerRequete($sql);
		
        return $resultat->fetchAll(PDO::FETCH_ASSOC);
		
	}
	
	
	public function getlistetypeconsultation()
	{
		if (est_anglophone()){
			$sql = "SELECT codetypeConsultation AS `code`, libelleEng AS libelle
					FROM p_typeconsultation ORDER BY libelleEng;";
		}else{
			$sql = "SELECT codetypeConsultation AS `code`, libelle
					FROM p_typeconsultation ORDER BY libelle;";
		}
				
		$resultat = $this->executerRequete($sql);
		
        return $resultat->fetchAll(PDO::FETCH_ASSOC);
	}
	
	
	public function getlisteactesmodifier()
	{
		if (est_anglophone()){
			$sql = "SELECT B.codeActe AS `code`, B.libelleEng AS libelle
					FROM p_acte B 	
					WHERE (B.codeTypePrestation='CONS')	
					AND (B.codeFamilleActe IN ('FA001','A000'))
					ORDER BY B.libelleEng;";
		}else{
			$sql = "SELECT B.codeActe AS `code`, B.libelle
					FROM p_acte B 	
					WHERE (B.codeTypePrestation='CONS')	
					AND (B.codeFamilleActe IN ('FA001','A000'))
					ORDER BY B.libelle;";
		}
			
		$resultat = $this->executerRequete($sql);
		
        return $resultat->fetchAll(PDO::FETCH_ASSOC);
		
	}
	
	public function getlistespecialite()
	{
		if (est_anglophone()){
			$sql = "SELECT codeSpecialite AS `code`, libelleEng AS libelle
					FROM p_specialite ORDER BY libelleEng;";
		}else{
			$sql = "SELECT codeSpecialite AS `code`, libelle
					FROM p_specialite ORDER BY libelle;";
		}
				
		$resultat = $this->executerRequete($sql);
		
        return $resultat->fetchAll(PDO::FETCH_ASSOC);
	}

}