<?php
require_once 'Framework/Modele.php';
class Tabbanques extends Modele{
	
	public function getlisterbanques(){
		$sql = "SELECT *
				FROM banque
				WHERE (codeSociete =?)
				ORDER BY 1;";
		
		$resultat = $this->executerRequete($sql, array($_SESSION['codeSociete']));
        return $resultat->fetchAll(PDO::FETCH_ASSOC);
	}

	public function getbanques($id){
		$sql = "SELECT *
				FROM banque 
				WHERE (id = ? and codeSociete =?);";
		
		$resultat = $this->executerRequete($sql, array($id,$_SESSION['codeSociete']));
        return $resultat->fetch(PDO::FETCH_ASSOC);
	}
	
	public function existeligne($codeBanque) {
        $sql = 'select id FROM banque WHERE (codeBanque=?)';
        $resultat = $this->executerRequete($sql, array($codeBanque));
		return ($resultat->rowCount() > 0);
    }

	public function ajouterbanques($libelle,$codeSwift,$banqueSociete,$numeroCompteCpt,$numeroCompteBancaire){
        
        $codeSociete = $_SESSION['codeSociete'];

        
		/*$sql ='INSERT INTO banque(codeSociete, codeBanque, libelle, codeSwift, banqueSociete, numeroCompteCpt, numeroCompteBancaire) 
			VALUES (?,?,?,?,?,?,?);';*/
		
		$sql =' CALL sp_ajouter_banques (?,?,?,?,?,?);';

		$this->executerRequete($sql, array($codeSociete,$libelle,$codeSwift,$banqueSociete,$numeroCompteCpt,$numeroCompteBancaire));
		
	}
	
	public function modifierbanques($libelle,$codeSwift,$banqueSociete,$numeroCompteCpt,$numeroCompteBancaire,$id){
		
		$codeSociete = $_SESSION['codeSociete'];


		$sql = 'UPDATE banque 
				SET    libelle=?,codeSwift=?,banqueSociete=?,
					   numeroCompteCpt=?,numeroCompteBancaire=?
				WHERE (id = ? AND codeSociete = ?);';
		
		$this->executerRequete($sql, array($libelle,$codeSwift,$banqueSociete,$numeroCompteCpt,$numeroCompteBancaire,$id,$codeSociete));
	}
	

	public function supprimerbanques($id){
		$codeSociete = $_SESSION['codeSociete'];

		$sql = 'DELETE  
				FROM banque 
				WHERE (id = ? AND codeSociete = ?);';
		
		$this->executerRequete($sql, array($id,$codeSociete));
	}
	///////////////////////////////////////////////////////
	
	public function selectionnerune($id){
		$codeSociete = $_SESSION['codeSociete'];

		$sql = "UPDATE banque 
				SET choix='1'
				WHERE (id = ? AND codeSociete = ?);";
		
		$this->executerRequete($sql, array($id,$codeSociete));
	}
	
	public function deselectionnerune($id){
		$codeSociete = $_SESSION['codeSociete'];

		$sql = "UPDATE banque 
				SET choix='0'
				WHERE (id = ? AND codeSociete = ?);";
		
		$this->executerRequete($sql, array($id,$codeSociete));
	}

	public function selectionnertoutes(){
		$codeSociete = $_SESSION['codeSociete'];

		$sql = "UPDATE banque 
				SET choix='1'
				WHERE (codeSociete = ?);";
		
		$this->executerRequete($sql, array($codeSociete));
	}
	
	public function deselectionnertoutes(){
		$codeSociete = $_SESSION['codeSociete'];

		$sql = "UPDATE banque 
				SET choix='0'
				WHERE (codeSociete = ?);";
		
		$this->executerRequete($sql, array($codeSociete));
	}
	
	public function existeSelection() {
        $sql = 'select id FROM banque WHERE (codeSociete=? AND choix="1")';
        $resultat = $this->executerRequete($sql, array($_SESSION['codeSociete']));
		return ($resultat->rowCount() > 0);
    }
	
	public function getid($id){
		$sql = "SELECT *
				FROM banque 
				WHERE (id = ?);";
		
		$resultat = $this->executerRequete($sql, array($id));
        return $resultat->fetch(PDO::FETCH_ASSOC);
	}
	
	public function supprimertoutes(){
		$codeSociete = $_SESSION['codeSociete'];

		$sql = 'DELETE  
				FROM banque 
				WHERE (codeSociete = ?);';
		
		$this->executerRequete($sql, array($codeSociete));
	}
	
	public function supprimerchoix(){
		$codeSociete = $_SESSION['codeSociete'];

		$sql = "DELETE  
				FROM banque 
				WHERE (codeSociete = ? AND choix='1');";
		
		$this->executerRequete($sql, array($codeSociete));
	}
}