<?php
require_once 'Framework/Modele.php';

class Lienparente extends Modele {
	
    public function getListe() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeLienParente as `code`, libelleEng as libelle FROM lienparente order by ordre, libelle';
		}
		else
		{
			$sql = 'SELECT codeLienParente as `code`, libelle FROM lienparente order by ordre, libelle';
		}
		
		$liste = $this->executerRequete($sql);

        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
    public function getListeConsultation() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeLienParente as `code`, libelleEng as libelle FROM lienparente order by ordre, libelle';
		}
		else
		{
			$sql = 'SELECT codeLienParente as `code`, libelle FROM lienparente order by ordre, libelle';
		}

		$liste = $this->executerRequete($sql);

        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
    public function getListeSubstitut() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeLienParente as `code`, libelleEng as libelle FROM liensubstitut order by ordre, libelle';
		}
		else
		{
			$sql = 'SELECT codeLienParente as `code`, libelle FROM liensubstitut order by ordre, libelle';
		}
		
		$liste = $this->executerRequete($sql);
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
    public function getListeDependant() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeLienParente AS `code`, libelleEng as libelle FROM lienparente 
					WHERE codeLienParente!="A" AND enVigueur ="1"
					ORDER BY ordre, libelle;';
		}
		else
		{
			$sql = 'SELECT codeLienParente AS `code`, libelle FROM lienparente 
					WHERE codeLienParente!="A" AND enVigueur ="1"
					ORDER BY ordre, libelle;';
		}
		
		$liste = $this->executerRequete($sql);

		return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
    public function getListeAdherent() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeLienParente AS `code`, libelleEng as libelle FROM lienparente WHERE codeLienParente="A" ORDER BY ordre, libelle';
		}
		else
		{
			$sql = 'SELECT codeLienParente AS `code`, libelle FROM lienparente WHERE codeLienParente="A" ORDER BY ordre, libelle';
		}

		$liste = $this->executerRequete($sql);
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function getLienparente() 
	{
		$sql = 'SELECT * FROM lienparente 
				WHERE codeSociete = ? 
				ORDER BY ordre, libelle;';
		
		$liste = $this->executerRequete($sql, array($_SESSION['codeSociete']));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function getUnLienparente($idLien)
	{
		$sql = 'SELECT * FROM lienparente 
				WHERE id = ?;';
		
		$liste = $this->executerRequete($sql, array($idLien));
		
        return $liste->fetch(PDO::FETCH_ASSOC);
		
	}
	
	public function historiserLienParente($idLien, $enVigueur)
	{
		$user = $_SESSION['login'];
		
		$sql = 'call sp_historisation_lienparente(?, ?, ?)';
		
		$this->executerRequete($sql, array($idLien, $enVigueur, $user));
    }	
}