<?php
require_once 'Framework/Modele.php';

class Mouvementassure extends Modele {
	
    public function getMouvementassure($ajoutClient, $codeSensMouvement, $valide, $debut, $fin)
	{
		$codeSensMouvement	= contruireParamLike($codeSensMouvement);
		$ajoutClient	= contruireParamLike($ajoutClient);
		$valide	= contruireParamLike($valide);
	
		$sql = 'call sp_get_mouvementassures(?, ?, ?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($_SESSION['idPolice_C'], $ajoutClient, $codeSensMouvement, $valide, $debut, $fin));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }

	
    public function getapercumouvementassures($debut, $fin)
	{
		$sql = 'call sp_get_apercu_mouvementassures(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debut, $fin));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }

    public function getMouvementassureRh($codeSensMouvement, $valide, $debut, $fin)
	{
		$codeSensMouvement	= contruireParamLike($codeSensMouvement);
		$valide	= contruireParamLike($valide);
	
		$sql = 'call sp_get_mouvementassures_rh(?, ?, ?, ?, ?)';
		
		// var_dump(array($_SESSION['idPolice_C'], $codeSensMouvement, $valide, $debut, $fin));
		// exit();

		$resultat = $this->executerRequete($sql, array($_SESSION['idPolice_C'], $codeSensMouvement, $valide, $debut, $fin));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }

    public function getMouvementassureRhValider($codeSensMouvement, $debut, $fin)
	{
		$codeSensMouvement	= contruireParamLike($codeSensMouvement);
		$user 				= $_SESSION['login'];
		$idPolice 			= $_SESSION['idPolice_C'];

		$sql = 'call sp_get_mouvementassures_rh_valider(?, ?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeSensMouvement, $debut, $fin, $user));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }

	// $user = $_SESSION['login'];
    public function initMouvementassureRhValider()
	{
		$user 		= $_SESSION['login'];
		$idPolice 	= $_SESSION['idPolice_C'];

		$sql = 'call sp_init_mouvementassures_rh_valider(?, ?)';
		
		$this->executerRequete($sql, array($idPolice, $user));
    }

	public function selectionner_mouvement_rh_tout($codeSensMouvement, $debut, $fin, $choix)
	{
		$codeSensMouvement	= contruireParamLike($codeSensMouvement);

		$user 		= $_SESSION['login'];
		$idPolice 	= $_SESSION['idPolice_C'];

		/*
		var_dump
		(
			array(
				"idPolice" 				=> $idPolice,
				"user" 					=> $user,
				"codeSensMouvement" 	=> $codeSensMouvement,
				"debut" 				=> $debut,
				"fin" 					=> $fin,
				"choix" 				=> $choix,
			)
		);
		exit();
		*/

		$sql = 'call sp_r_selectionner_mouvement_rh_tout(?, ?, ?, ?, ?, ?)';
		
		$this->executerRequete($sql, array($idPolice, $codeSensMouvement, $debut, $fin, $user, $choix));
    }	

	public function selectionner_mouvements_rh($idMvtTemp, $choix)
	{
		$sql = 'call sp_r_selectionner_mouvements_rh(?, ?)';
		$this->executerRequete($sql, array($idMvtTemp, $choix));
    }	
	

	public function valider_mouvements_rh()
	{
		$user 		= $_SESSION['login'];
		$idPolice 	= $_SESSION['idPolice_C'];

		$sql = 'call sp_r_valider_mouvements_rh(?, ?)';
		
		$this->executerRequete($sql, array($idPolice, $user));
    }	

}