<?php
require_once 'Framework/Modele.php';

class Reseausoins extends Modele 
{
    public function getReseausoins() 
	{
		$codeSociete = $_SESSION['codeSociete'];
		
		$sql = 'SELECT A.* FROM reseausoins A WHERE (A.codeSociete=?) AND (typeSysteme != "1") ORDER BY A.libelle;';
		
        $resultat = $this->executerRequete($sql, array($codeSociete));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
    public function getReseausoin($id) 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT A.id, A.codeSociete, A.codeReseau, A.libelleEng as libelle, descritpionReseau 
			FROM reseausoins A WHERE (A.codeSociete=?) AND (A.id=?)';
		}
		else
		{
			$sql = 'SELECT A.id, A.codeSociete, A.codeReseau, A.libelle, descritpionReseau 
			FROM reseausoins A WHERE (A.codeSociete=?) AND (A.id=?)';
		}

        $reseausoin = $this->executerRequete($sql, array($_SESSION['codeSociete'], $id));
		
		return $reseausoin->fetch(PDO::FETCH_ASSOC);
    }
    public function getNombreReseausoins()
    {
        $sql = 'select count(*) as nbReseausoin FROM reseausoins A WHERE (A.codeSociete=?)';
        $resultat = $this->executerRequete($sql, array($_SESSION['codeSociete']));
        $ligne = $resultat->fetch(PDO::FETCH_ASSOC);
        return $ligne['nbReseausoin'];
    }	

    public function ajouter($codeSociete, $codeReseau, $libelle, $descritpionReseau) {
		$sql = 'INSERT INTO reseausoins (codeSociete, codeReseau, libelle, descritpionReseau) VALUES (?, ?, ?, ?)';
        $this->executerRequete($sql, array($codeSociete, $codeReseau, $libelle, $descritpionReseau));
    }	
	
    public function modifier($id, $codeReseau, $libelle, $descritpionReseau) {
		$sql = 'UPDATE reseausoins SET codeReseau=?, libelle=?, descritpionReseau=? where (id=?)';
        $this->executerRequete($sql, array($codeReseau, $libelle, $descritpionReseau, $id));
    }	

    public function supprimer($id) 
	{
		$user = $_SESSION['login'];
		
		$sql = 'CALL sp_supprimer_reseau_soins(?, ?);';

        $this->executerRequete($sql, array($id, $user));
    }		
	
    public function existeligne($codeReseau) {
        $sql = 'select id FROM reseausoins WHERE (codeSociete=?) and (codeReseau=?)';
        $resultat = $this->executerRequete($sql, array($_SESSION['codeSociete'],$codeReseau));
		return ($resultat->rowCount() > 0);
    }
	
    public function getListe() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeReseau as `code`, libelleEng as libelle FROM reseausoins WHERE (codeSociete=?) 
			AND (typeSysteme != "1") AND (actif = "1") order by libelle';
		}
		else
		{
			$sql = 'SELECT codeReseau as `code`, libelle FROM reseausoins WHERE (codeSociete=?) 
			AND (typeSysteme != "1") AND (actif = "1") order by libelle';
		}

		$liste = $this->executerRequete($sql,array($_SESSION['codeSociete']));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	
	
     public function creerreseau($codeReseau, $libelle, $tm)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];
		
		$sql = 'call sp_creer_reseau(?, ?, ?, ?, ?)';
		
		$this->executerRequete($sql, array($codeSociete, $codeReseau, $libelle, $tm, $user));
    }
	
    public function getunreseau($idReseau)
	{
		$sql = 'select A.id as idReseau, A.* from reseausoins A where (id=?)';
		
		$resultat = $this->executerRequete($sql, array($idReseau));
		
		return $resultat->fetch(PDO::FETCH_ASSOC);
    }
	
    public function enregistrermodif($idReseau, $libelle, $tm)
	{
		$user = $_SESSION['login'];
		
		$sql = 'call sp_modifier_reseau(?, ?, ?, ?)';
		
		$this->executerRequete($sql, array($idReseau, $libelle, $tm, $user));
    }


    public function getreseausnonaccessibles($codeProduit)
	{
		$codeSociete 	= $_SESSION['codeSociete'];

		$sql = 'CALL sp_get_reseaus_non_accessibles_produit(?, ?);';
				
		$resultat = $this->executerRequete($sql, array($codeSociete, $codeProduit));		
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
    public function getreseausaccessibles($codeProduit)
	{
		$codeSociete 	= $_SESSION['codeSociete'];

		$sql = 'CALL sp_get_reseaus_accessibles_produit(?, ?);';
				
		$resultat = $this->executerRequete($sql, array($codeSociete, $codeProduit));		
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function ajouterunreseauproduit($codeProduit, $codeReseau)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];

		$sql = 'call sp_r_ajouter_reseau_produit(?, ?, ?, ?)';
		
		$this->executerRequete($sql, array($codeSociete, $codeProduit, $codeReseau, $user));
    }	
	
	public function retirerunreseauproduit($codeProduit, $codeReseau)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];

		$sql = 'call sp_r_retirer_reseau_produit(?, ?, ?, ?)';
		
		$this->executerRequete($sql, array($codeSociete, $codeProduit, $codeReseau, $user));
    }	
	
	public function retirertousreseauproduit($codeProduit)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];

		$sql = 'call sp_r_retirer_tous_reseau_produit(?, ?, ?)';
		
		$this->executerRequete($sql, array($codeSociete, $codeProduit, $user));
    }	

	
	public function ajoutertousreseauproduit($codeProduit)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];

		$sql = 'call sp_r_ajouter_tous_reseau_produit(?, ?, ?)';
		
		$this->executerRequete($sql, array($codeSociete, $codeProduit, $user));
    }	

	public function majtm($codeProduit, $codeReseau, $tm)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];

		$sql = 'call sp_r_maj_tm_reseau_produit(?, ?, ?, ?, ?)';
		
		$this->executerRequete($sql, array($codeSociete, $codeProduit, $codeReseau, $tm, $user));
    }	
}