<?php
require_once 'Framework/Modele.php';
class Trancheage extends Modele{
	
	public function getListeGarant() 
	{
		$sql = 'SELECT codeGcAssureur AS `code`, libelle FROM gc_assureur 
				WHERE codeSociete= ? AND actif = 1 ORDER BY libelle';
		$resultat = $this->executerRequete($sql,array($_SESSION['codeSociete']));
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }

   public function gettypetrancheage($codeGcAssureur)
   {
		if (est_anglophone())
		{
			$sql = "SELECT codeEnteteTrancheAge AS `code`, 
					libelleEng AS libelle 
					FROM entetetrancheage WHERE codeSociete=?
					AND codeGcAssureur=? ORDER BY 2;";
		}
		else
		{
			$sql = "SELECT codeEnteteTrancheAge AS `code`, 
					libelle FROM entetetrancheage 
					WHERE codeSociete=? AND codeGcAssureur=? ORDER BY 2;";
		}

		$liste = $this->executerRequete($sql,array($_SESSION['codeSociete'], $codeGcAssureur));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function geterentetestrancheage($codeGcAssureur){
		$codeSociete 	= $_SESSION['codeSociete'];

		if (est_anglophone())
		{
			$sql = 'CALL sp_get_entetes_tranches_ages_eng(?, ?);';
		}
		else
		{
			$sql = 'CALL sp_get_entetes_tranches_ages(?, ?);';
		}

		$resultat = $this->executerRequete($sql, array($codeSociete, $codeGcAssureur));		
		
        return $resultat->fetchAll(PDO::FETCH_ASSOC);

 	}

	public function getlisterentetetrancheage(){
		$sql = "SELECT A.*, B.libelle as garant
				FROM entetetrancheage A
				JOIN gc_assureur B ON (B.codeSociete = A.codeSociete
				and B.codeGcAssureur = A.codeGcAssureur)
				WHERE (A.codeSociete =?)
				ORDER BY 1;";
		
		$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete']));
        return $resultat->fetchAll(PDO::FETCH_ASSOC);
	}

	public function getentetetrancheage($id){
		$sql = "SELECT *
				FROM entetetrancheage 
				WHERE (id = ? and codeSociete =?);";
		
		$resultat = $this->executerRequete($sql, array($id, $_SESSION['codeSociete']));
        return $resultat->fetch(PDO::FETCH_ASSOC);
	}

	

	public function ajouterentetetrancheage($codeGcAssureur,$codeEnteteTrancheAge,$libelle,$libelleEng){
        
        $codeSociete = $_SESSION['codeSociete'];
		

        $sql ='CALL sp_ajouter_entetetrancheage(?, ?, ?, ?, ?);';

		$this->executerRequete($sql, array($codeSociete,$codeGcAssureur,$codeEnteteTrancheAge,$libelle,$libelleEng));
        
	}
	
	public function modifierentetetrancheage($codeGcAssureur,$codeEnteteTrancheAge,$libelle,$libelleEng,$id){
		
		$codeSociete = $_SESSION['codeSociete'];
		
		$sql = 'UPDATE entetetrancheage 
				SET    codeGcAssureur=?,libelle=?,libelleEng=?
				WHERE (id = ? AND codeSociete = ?);';
		
		$this->executerRequete($sql, array($codeGcAssureur,$libelle,$libelleEng,$id,$codeSociete));
	}

    public function gettranchesage($codeEnteteTrancheAge)
	{
		$codeSociete 	= $_SESSION['codeSociete'];

		$sql = 'CALL sp_get_tranches_ages(?, ?);';
				
		$resultat = $this->executerRequete($sql, array($codeSociete, $codeEnteteTrancheAge));		
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }

	public function supprimertranchesage($idTrancheage)
	{
		$user = $_SESSION['login'];

		$sql = 'call sp_supprimer_tranche_age(?, ?)';
		
		$this->executerRequete($sql, array($idTrancheage, $user));
    }	
	
	public function viderentetetrancheage($codeEnteteTrancheAge)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];

		$sql = 'call sp_vider_entete_tranche_age(?, ?, ?)';
		
		$this->executerRequete($sql, array($codeSociete, $codeEnteteTrancheAge, $user));
    }	
	
	public function ajouterunetrancheage($codeEnteteTrancheAge, $ageMax)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];

		$sql = 'call sp_ajouter_une_tranche_age(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($codeSociete, $codeEnteteTrancheAge, $ageMax, $user));

		// return $resultat->fetchAll(PDO::FETCH_ASSOC);
		return $resultat->fetch(PDO::FETCH_ASSOC);
		
    }	
}