<?php
require_once 'Modele.php';

class Derogation extends Modele {
	
    public function getInfos($codeDerogation)
    {
		$sql = 'select libelle, libelleEng from p_derogation where (codeDerogation=?)';
        $resultat = $this->executerRequete($sql, array($codeDerogation));
        return $resultat->fetch(PDO::FETCH_ASSOC);
    }

	public function getinfosDerogation($idDemandederogation)
	{
		$sql = 'call sp_get_infos_derogation(?)';
		
		$resultat = $this->executerRequete($sql, array($idDemandederogation));
		
		return $resultat->fetch(PDO::FETCH_ASSOC);
    }	
	
}