<?php
require_once 'Framework/Modele.php';

class Facturegarant extends Modele {

	public function getListe() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeTypeFacturationGarant as `code`, libelleEng as libelle FROM typefacturationgarant;';
		}
		else
		{
			$sql = 'SELECT codeTypeFacturationGarant as `code`, libelle FROM typefacturationgarant;';
		}

		$liste = $this->executerRequete($sql);
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function getTypeFactureGarant($codeGcAssureur)
	{
		$sql = 'CALL sp_get_typefacturationgarant(?);';
		
		$facture = $this->executerRequete($sql, array($codeGcAssureur));
		
		$ligne = $facture->fetchAll(PDO::FETCH_ASSOC);
		
		return $ligne;
    }	
	
	public function initierfacturegarant($codeGcAssureur, $codeTypeFacturationGarant,
	$codePeriodicite, $codeExercice, $dateFacture)
	{
		$codeSociete = $_SESSION['codeSociete'];
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		/*
		var_dump($codeSociete, $codeGcAssureur, $codeTypeFacturationGarant, 
		$codeExercice, $codePeriodicite, $dateFacture, $user, $idSaisie);
		*/
	
		
		$sql = 'CALL sp_init_facturation_garant(?, ?, ?, ?, ?, ?, ?, ?);';
		
		$this->executerRequete($sql, array($codeSociete, $codeGcAssureur, $codeTypeFacturationGarant, $codeExercice, $codePeriodicite, $dateFacture, $user, $idSaisie));
	}
	
	public function getEnteteFactureGarant()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_get_entete_facturation_garant_temp(?, ?);';
		
		$facture = $this->executerRequete($sql, array($user, $idSaisie));
		
		$ligne = $facture->fetch(PDO::FETCH_ASSOC);
		
		return $ligne;
	}
	
	public function getPeriodicitePrevue($codeGcAssureur, $codeNatureFacturationGarant)
	{
		$sql = 'SELECT fn_periodicite_facturation_garant_nature(?, ?) AS codePeriodicite;';
		
		$resultat = $this->executerRequete($sql, array($codeGcAssureur, $codeNatureFacturationGarant))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['codePeriodicite'];
	}
	
	public function majCautionGarant($codeGcAssureur)
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_maj_caution_garant_temp(?, ?, ?);';
		
		$this->executerRequete($sql, array($codeGcAssureur, $user, $idSaisie));
		
	}
	
	public function majmontantht($montantHt)
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_maj_ht_garant_temp(?, ?, ?);';
		
		$this->executerRequete($sql, array($user, $idSaisie,$montantHt));
		
	}
	
	public function genererfacturecaution()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_enregistrer_facture_garant_caution(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		$_SESSION['idGroupeFacturegarant_F'] = $resultat['idGroupeFacturegarant'];
	}
	
	public function majSinistresGarant($codeGcAssureur)
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_maj_sinistres_garant_temp(?, ?, ?);';
		
		$this->executerRequete($sql, array($codeGcAssureur, $user, $idSaisie));
	}
	
	public function majHonorairePrimesGarant($codeGcAssureur)
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_maj_honoraireprimes_garant_temp(?, ?, ?);';
		
		$this->executerRequete($sql, array($codeGcAssureur, $user, $idSaisie));
	}
	
	public function getListeAvenants()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_lister_avenants_a_facturer_garant(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie));
		
		$lignes = $resultat->fetchAll(PDO::FETCH_ASSOC);
		
		return $lignes;
    }	
	
	public function majaccessoirehonoraireprime($idAvenant, $accessoire)
	{
		
		$sql = 'CALL sp_maj_accessoire_facture_garant(?, ?);';
		
		$this->executerRequete($sql, array($idAvenant, $accessoire));
	}
	
	
	public function genererfacturehonoraireprime()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_enregistrer_facture_garant_honoraire_prime(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		$_SESSION['idEntetefacturegarant_F'] = $resultat['idEntetefacturegarant'];
		
	}
	
	public function getListePolices()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_lister_police_sin_a_facturer_garant(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie));
		
		$lignes = $resultat->fetchAll(PDO::FETCH_ASSOC);
		
		return $lignes;
    }
	
	public function getListeColleges()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_lister_college_sin_a_facturer_garant(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie));
		
		$lignes = $resultat->fetchAll(PDO::FETCH_ASSOC);
		
		return $lignes;
    }
	
	public function genererfacturesinitresgarant()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_enregistrer_facture_garant_sinistre(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		$_SESSION['idEntetefacturegarant_F'] = $resultat['idEntetefacturegarant'];
		
	}
	
	
	public function majHonaireSinistresGarant($codeGcAssureur)
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_maj_honoraires_sinistres_garant_temp(?, ?, ?);';
		
		$this->executerRequete($sql, array($codeGcAssureur, $user, $idSaisie));
	}
	
	public function genererfacturehonorairesinistre()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_enregistrer_facture_garant_honoraires_sinistre(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		$_SESSION['idEntetefacturegarant_F'] = $resultat['idEntetefacturegarant'];
		
	}
	
	/*
	public function initFiltreFactureGarant() 
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_init_filtre_facture_garant(?, ?, ?);";
		
		$this->executerRequete($sql, array($codeSociete,$user,$idSaisie));
      
    }
	*/
	
	public function initFiltreFactureGarant() 
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_init_filtre_groupe_facture_garant(?, ?, ?);";
		
		$this->executerRequete($sql, array($codeSociete,$user,$idSaisie));
      
    }
	
	public function getFactureGarant() 
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_filtregarant_temp(?, ?);";
		
		$liste = $this->executerRequete($sql, array($user,$idSaisie));
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function getTypeFactureGarantTemp() 
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_filtretypefacturationgarant_temp(?, ?);";
		
		$liste = $this->executerRequete($sql, array($user, $idSaisie));
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function selectionnerGarant($id,$choix){
		$sql = "CALL sp_selection_filtre_factures_garant(?, ?);";
		$this->executerRequete($sql, array($id,$choix));
	}
	
	public function selectionnertypefacture($id,$choix){
		$sql = "CALL sp_selection_filtre_type_facture_garant(?, ?);";
		$this->executerRequete($sql, array($id,$choix));
	}
	
	public function majtousgarants($choix)
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_selection_filtre_factures_garant_tous(?, ?, ?);";
		
		$this->executerRequete($sql, array($user, $idSaisie,$choix));
	}
	
	
	public function getChoixTousGarants()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_choix_tous_garants(?, ?) AS choixTousGarant;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['choixTousGarant'];
		
	}
	
	public function getNbreGarantsSelection()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_nombre_garants_selectionne(?, ?) AS nbreGarant;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['nbreGarant'];
		
	}
	
	public function majtoustypesfacture($choix)
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_selection_filtre_type_facture_garant_tous(?, ?, ?);";
		
		$this->executerRequete($sql, array($user, $idSaisie,$choix));
	}
	
	public function getChoixTousTypesFacture()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_choix_tous_types_facture(?, ?) AS choixTousTypesFacture;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['choixTousTypesFacture'];
		
	}
	
	public function getNbreTypesFactureSelection()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_nombre_types_facture_selectionne(?, ?) AS nbreGarant;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['nbreGarant'];
		
	}
	
	public function getMoisFinFacture($codeMoisDebut)
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_fin_periode_facturation_garant(?, ?, ?);';
		
		$resultat = $this->executerRequete($sql, array($codeMoisDebut, $user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['codeMoisFin'];
		
	}
	
	//
	public function filtrerfacturegarants($debut, $fin)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		//$sql = 'CALL sp_filtrer_facture_garant_consultation(?, ?, ?, ?, ?);';
		$sql = 'CALL sp_filtrer_groupe_facture_garant_consultation(?, ?, ?, ?, ?);';
		
		$this->executerRequete($sql, array($codeSociete, $debut, $fin, $user, $idSaisie));
	}
	
	
	public function getListeFacture()
	{
		
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		//$sql = 'CALL sp_get_facture_garant_consultation(?, ?);';
		
		$sql = 'CALL sp_get_groupe_facture_garant_consultation(?, ?);';
		
		
		$liste = $this->executerRequete($sql, array($user, $idSaisie));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
		
	}
	
	public function majHonoraireForfaitaireGarant($codeGcAssureur)
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_maj_caution_garant_temp(?, ?, ?);';
		
		$this->executerRequete($sql, array($codeGcAssureur, $user, $idSaisie));
		
	}
	
	public function getListeAssiettesFactureGarant($codeTypeFacturationGarant)
	{
		/*
		$sql = 'CALL sp_get_assiettefacturationgarant(?)';
		$liste = $this->executerRequete($sql, array($codeTypeFacturationGarant));
		*/
		$sql = 'CALL sp_liste_assiettefacturationgarant()';		
		$liste = $this->executerRequete($sql);

        return $liste->fetchAll(PDO::FETCH_ASSOC);
	}
	
	public function getListeAssiettesFactureGarantTous()
	{
		$sql = 'CALL sp_liste_assiettefacturationgarant()';		
		$liste = $this->executerRequete($sql);
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
	}
	
	public function majHonaireForfaitaireGarant($codeGcAssureur, $codeAssietteFacturationGarant)
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_maj_forfait_honoraire_garant_temp(?, ?, ?, ?);';
		
		$this->executerRequete($sql, array($codeGcAssureur, $codeAssietteFacturationGarant, $user, $idSaisie));
		
	}
	
	//
	public function genererfacturehonoraireforfaitaire()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_enregistrer_facture_garant_honoraire_forfait(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		$_SESSION['idEntetefacturegarant_F'] = $resultat['idEntetefacturegarant'];
		
	}
	
	public function majAppelFondGarant($codeGcAssureur, $codeAssietteFacturationGarant)
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_maj_appel_fond_garant_temp(?, ?, ?, ?);';
		
		$this->executerRequete($sql, array($codeGcAssureur, $codeAssietteFacturationGarant, $user, $idSaisie));
		
	}
	
	public function genererfactureappelfond()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_enregistrer_facture_garant_appel_fond(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		$_SESSION['idEntetefacturegarant_F'] = $resultat['idEntetefacturegarant'];
		
	}
	
	public function majAppelCotisationGarant($codeGcAssureur, $codeAssietteFacturationGarant)
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_maj_appel_cotisation_garant_temp(?, ?, ?, ?);';
		
		$this->executerRequete($sql, array($codeGcAssureur, $codeAssietteFacturationGarant, $user, $idSaisie));
		
	}
	
	public function genererfactureappelcotisationgarant()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_enregistrer_facture_garant_appel_cotisation(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		$_SESSION['idEntetefacturegarant_F'] = $resultat['idEntetefacturegarant'];
		
	}
	
	public function majHonoraireBudgetGarant($codeGcAssureur, $codeAssietteFacturationGarant)
	{	
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_maj_honoraire_budget_garant_temp(?, ?, ?, ?);';
		
		$this->executerRequete($sql, array($codeGcAssureur, $codeAssietteFacturationGarant, $user, $idSaisie));
	}
	
	public function genererfacturehonorairebudgetgarant()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_enregistrer_facture_garant_honoraire_budget(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		$_SESSION['idEntetefacturegarant_F'] = $resultat['idEntetefacturegarant'];
		
	}
	
	public function getChoixTouTesFactures()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_choix_toues_factures_edition(?, ?) AS choixToutesFactures;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['choixToutesFactures'];
		
	}
	
	
	public function getChoixTousGroupeFactures()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_choix_tous_groupes_factures_edition(?, ?) AS choixToutesFactures;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['choixToutesFactures'];
		
	}
	

	public function majtoutesfacturesedition($choix)
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_selection_edition_facture_garant_tous(?, ?, ?);";
		
		$this->executerRequete($sql, array($user, $idSaisie,$choix));
	}
	
	public function selectionnerunefactureedition($id, $choix){
		
		$sql = "CALL sp_selection_edition_groupe_facture_garant(?, ?);";
		
		$this->executerRequete($sql, array($id,$choix));
	}
	
	public function getNbreFactureSelection()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_nombre_facture_garant_selectionne(?, ?) AS nbFactureSelection;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['nbFactureSelection'];
		
	}
	
	public function getNbreGroupeFactureSelection()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_nombre_groupe_facture_garant_selectionne(?, ?) AS nbFactureSelection;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['nbFactureSelection'];
		
	}
	
	public function getTypeConvention($codeTypeFacturationGarant) 
	{
		
		$sql = 'CALL sp_get_convetionfacturationgarant(?);';
		
		$liste = $this->executerRequete($sql, array($codeTypeFacturationGarant));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function getFactureGarantID($idEntetefacturegarant)
	{
		$sql = 'CALL sp_get_entete_facturation_garant_id(?);';
		
		$facture = $this->executerRequete($sql, array($idEntetefacturegarant));
		
        return $facture->fetch(PDO::FETCH_ASSOC);
		
	}
	
	public function getPolicesFactureGarant($idEntetefacturegarant)
	{
		
		$sql = 'CALL sp_get_detail_facturation_garant_police(?);';
		
		$liste = $this->executerRequete($sql, array($idEntetefacturegarant));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function getCollegesFactureGarant($idEntetefacturegarant)
	{
		
		$sql = 'CALL sp_get_detail_facturation_garant_college(?);';
		
		$liste = $this->executerRequete($sql, array($idEntetefacturegarant));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function getFactureGarantNumero($numeroFacture)
	{
		$sql = 'CALL sp_get_entete_facturation_garant_no_facture(?);';
		
		$facture = $this->executerRequete($sql, array($numeroFacture));
		
        return $facture->fetch(PDO::FETCH_ASSOC);
		
	}
	

	public function filtrerfacturegarantsencaissement($debut, $fin, $encaisse)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		$encaisse 		= contruireParamLike($encaisse);
		
		$sql = 'CALL sp_filtrer_facture_garant_encaissement(?, ?, ?, ?, ?, ?);';
		
		$this->executerRequete($sql, array($codeSociete, $debut, $fin, $encaisse, $user, $idSaisie));
		
	}
	
	public function initFiltreFactureGarantEncaissement() 
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_init_filtre_facture_garant_encaissement(?, ?, ?);";
		
		$this->executerRequete($sql, array($codeSociete,$user,$idSaisie));
      
    }
	
	public function getFacturesimpayees($codeGcAssureur, $idEncaissementGarant_temp)
	{
		$sql = 'CALL sp_get_factures_garant_impayees(?, ?);';
		
		$liste = $this->executerRequete($sql, array($codeGcAssureur, $idEncaissementGarant_temp));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
	}
	
	public function getTotalFactureImpayee($codeGcAssureur)
	{
		$sql = 'CALL sp_get_total_factures_garant_impayees(?);';
		
		$totalfacture = $this->executerRequete($sql, array($codeGcAssureur));
		
        return $totalfacture->fetch(PDO::FETCH_ASSOC);
		
	}
	
	public function getNomGarant($codeGcAssureur)
	{
		$sql = 'SELECT libelle FROM gc_assureur
				WHERE codeGcAssureur=?;';
		
		$resultat = $this->executerRequete($sql, array($codeGcAssureur))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['libelle'];
	}
		
	public function solderfacture($idFacture)
	{
		$idEncaissementGarant_temp = $_SESSION['idEncaissementGarant_temp'];
		
		$sql = 'CALL sp_solder_facture_garant(?, ?);';
        
		$this->executerRequete($sql, array($idFacture, $idEncaissementGarant_temp));
    }

	public function ajouteracomptefacture($idFacture, $montantAcpte)
	{
		$idEncaissementGarant_temp = $_SESSION['idEncaissementGarant_temp'];
		
		$sql = 'CALL sp_ajouter_acompte_facture_garant(?, ?, ?);';
        
		$this->executerRequete($sql, array($idEncaissementGarant_temp, $idFacture, $montantAcpte));

	}
	

	public function filtrerencaissementsgarant($debut, $fin)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		
		$sql = 'CALL sp_filtrer_encaissement_garant(?, ?, ?, ?, ?);';
		
		var_dump($codeSociete, $debut, $fin, $user, $idSaisie);
		
		$this->executerRequete($sql, array($codeSociete, $debut, $fin, $user, $idSaisie));
		
	}
	
	public function getListeEncaissements()
	{
		
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_get_encaissement_garant_consultation(?, ?);';
		
		$liste = $this->executerRequete($sql, array($user, $idSaisie));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
		
	}
	
	public function getChoixTousEncaisses()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_choix_tous_encaisses_edition(?, ?) AS choixTousEncaisses;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['choixTousEncaisses'];
		
	}
	
	public function getNbEncaisseSelection()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_nombre_encaisse_selection(?, ?) AS nbEncaisseSelection;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['nbEncaisseSelection'];
		
	}
	
	public function selectionnerunencaissement($id, $choix){
		$sql = "CALL sp_selection_edition_encaissement_garant(?, ?);";
		$this->executerRequete($sql, array($id,$choix));
	}
	
	
	public function majtousencaissegarant($choix)
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_selection_edition_encaissement_garant_tous(?, ?, ?);";
		
		$this->executerRequete($sql, array($user, $idSaisie,$choix));
	}
	
	public function getTypeGarant($codeGcAssureur)
	{
		$sql = 'SELECT fn_type_garant(?) AS typeGarant;';
		
		$resultat = $this->executerRequete($sql, array($codeGcAssureur))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['typeGarant'];
	}
	
	public function facturegarantexport()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_get_facture_garant_export(?, ?);';
		
		$liste = $this->executerRequete($sql, array($user, $idSaisie));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
		
	}
	
	public function encaissementgarantexport()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_get_encaissement_garant_export(?, ?);';
		
		$liste = $this->executerRequete($sql, array($user, $idSaisie));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
		
	}
	
	public function getEnteteFactureGarantID($idEntetefacturegarant)
	{
	
		$sql = 'CALL sp_get_entete_facturation_garant_id(?);';
		
		$facture = $this->executerRequete($sql, array($idEntetefacturegarant));
		
		$ligne = $facture->fetch(PDO::FETCH_ASSOC);
		
		return $ligne;
	}
	
	
	public function getListeNatureFacture()
	{
		if (est_anglophone())
		{
			$sql = 'CALL sp_get_naturefacturationgarant_eng();';
		}
		else
		{
			$sql = 'CALL sp_get_naturefacturationgarant();';
		}
		
		$liste = $this->executerRequete($sql);
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
		
    }	
	
	public function initiergroupefacturegarant($codeGcAssureur, $codeNatureFacturationGarant,
	$codePeriodicite, $codeExercice, $dateFacture)
	{
		$codeSociete = $_SESSION['codeSociete'];
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		
		$sql = 'CALL sp_init_groupe_facture_garant(?, ?, ?, ?, ?, ?, ?, ?);';
		
		
		$this->executerRequete($sql, array($codeSociete, $codeGcAssureur, $codeNatureFacturationGarant, $codeExercice, $codePeriodicite, $dateFacture, $user, $idSaisie));
		
		
	}
	
	public function getGroupeFactureGarant()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_get_groupe_facturation_garant_temp(?, ?);';
		
		$facture = $this->executerRequete($sql, array($user, $idSaisie));
		
		$ligne = $facture->fetch(PDO::FETCH_ASSOC);
		
		return $ligne;
	}
	
	public function getTypeFactureGarantNature($codeNatureFacturationGarant)
	{
		$sql = 'CALL sp_get_typefacture_garant_nature(?);';
		
		$facture = $this->executerRequete($sql, array($codeNatureFacturationGarant));
		
		$ligne = $facture->fetchAll(PDO::FETCH_ASSOC);
		
		return $ligne;
    }	

	public function getGroupeFactureGarantID($idGroupeFacturegarant)
	{
		$sql = 'CALL sp_get_groupe_facturation_garant_id(?);';
		
		$facture = $this->executerRequete($sql, array($idGroupeFacturegarant));
		
        return $facture->fetch(PDO::FETCH_ASSOC);
	}
	
	public function getEntetesFacturesGarant($idGroupeFacturegarant)
	{
		
		$sql = 'CALL sp_get_entetes_facturation_garant_id(?);';
		
		$liste = $this->executerRequete($sql, array($idGroupeFacturegarant));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function getEnteteFactures()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_get_entete_facturation_garant_temp(?, ?);';
		
		$facture = $this->executerRequete($sql, array($user, $idSaisie));
		
		$ligne = $facture->fetchAll(PDO::FETCH_ASSOC);
		
		return $ligne;
	}
	
	public function genererfactureperiodique()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_enregistrer_facture_garant_periodique(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		$_SESSION['idGroupeFacturegarant_F'] = $resultat['idGroupeFacturegarant'];
	}
	
	public function getEnteteFactureGarantID_temp($idEntetefacturegarant)
	{
	
		$sql = 'CALL sp_get_entete_facturation_garant_id_temp(?);';
		
		$facture = $this->executerRequete($sql, array($idEntetefacturegarant));
		
		$ligne = $facture->fetch(PDO::FETCH_ASSOC);
		
		return $ligne;
	}
	
	/*
	
	sp_lister_police_sin_a_facturer_garant => sp_lister_police_facture_garant_temp_id
sp_lister_college_sin_a_facturer_garant => sp_lister_college_facture_garant_temp_id
sp_lister_avenants_a_facturer_garant => sp_lister_avenants_facture_garant_temp_id
	*/
	
	public function getListeAvenantsID_temp($idEntetefacturegarant)
	{
		$sql = 'CALL sp_lister_avenants_facture_garant_temp_id(?);';
		
		$resultat = $this->executerRequete($sql, array($idEntetefacturegarant));
		
		$lignes = $resultat->fetchAll(PDO::FETCH_ASSOC);
		
		return $lignes;
    }
	
	public function getListePolicesID_temp($idEntetefacturegarant)
	{
		$sql = 'CALL sp_lister_police_facture_garant_temp_id(?);';
		
		$resultat = $this->executerRequete($sql, array($idEntetefacturegarant));
		
		$lignes = $resultat->fetchAll(PDO::FETCH_ASSOC);
		
		return $lignes;
    }
	
	public function getListeCollegesID_temp($idEntetefacturegarant)
	{
		$sql = 'CALL sp_lister_college_facture_garant_temp_id(?);';
		
		$resultat = $this->executerRequete($sql, array($idEntetefacturegarant));
		
		$lignes = $resultat->fetchAll(PDO::FETCH_ASSOC);
		
		return $lignes;
    }
	
	public function getNatureFactureGarantTemp() 
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_filtrenaturefacturationgarant_temp(?, ?);";
		
		$liste = $this->executerRequete($sql, array($user, $idSaisie));
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function getNbreNatureFactureSelection()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_nombre_natures_facture_selectionne(?, ?) AS nbreGarant;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['nbreGarant'];
		
	}
	
	public function getChoixToutesNaturesFacture()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'SELECT fn_choix_tous_natures_facture(?, ?) AS choixTousTypesFacture;';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		return $resultat['choixTousTypesFacture'];
		
	}
	
	public function majtoutesnaturesfacture($choix)
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_selection_filtre_nature_facture_garant_tous(?, ?, ?);";
		
		$this->executerRequete($sql, array($user, $idSaisie,$choix));
	}
	
	public function getTypeListeFactureGarantTemp() 
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_filtrenaturefacturationgarant_temp(?, ?);";
		
		$liste = $this->executerRequete($sql, array($user, $idSaisie));
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function selectionnernaturefacture($id,$choix){
		$sql = "CALL sp_selection_filtre_nature_facture_garant(?, ?);";
		$this->executerRequete($sql, array($id,$choix));
	}
	
	public function filtrergroupefacturegarants($debut, $fin)
	{
		$codeSociete 	= $_SESSION['codeSociete'];
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_filtrer_groupe_facture_garant_consultation(?, ?, ?, ?, ?);';
		
		$this->executerRequete($sql, array($codeSociete, $debut, $fin, $user, $idSaisie));
	}
	
	public function majtoutesgroupefacturesedition($choix)
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = "CALL sp_selection_edition_groupe_facture_garant_tous(?, ?, ?);";
		
		$this->executerRequete($sql, array($user, $idSaisie,$choix));
	}
	
	public function groupefacturegarantexport()
	{
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_get_groupe_facture_garant_export(?, ?);';
		
		$liste = $this->executerRequete($sql, array($user, $idSaisie));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
		
	}
	
	public function getListeFactureGarantEncaissement()
	{
		
		$user 			= $_SESSION['login'];
		$idSaisie 		= $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_get_facture_garant_consultation(?, ?);';
			
		$liste = $this->executerRequete($sql, array($user, $idSaisie));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
		
	}
	
	public function selectionnerunefactureeditionencaissement($id, $choix){
		
		$sql = "CALL sp_selection_edition_facture_garant(?, ?);";
		
		$this->executerRequete($sql, array($id,$choix));
	}
	
	public function getDetailDeficitGarant()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_get_detail_facturation_deficit_garant_temp(?, ?);';
		
		$facture = $this->executerRequete($sql, array($user, $idSaisie));
		
		$ligne = $facture->fetchAll(PDO::FETCH_ASSOC);
		
		return $ligne;
	}
	
	public function genererfacturedeficit()
	{
		$user 		 = $_SESSION['login'];
		$idSaisie	 = $_SESSION['idSaisie'];
		
		$sql = 'CALL sp_enregistrer_facture_garant_deficit(?, ?);';
		
		$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
		
		$_SESSION['idGroupeFacturegarant_F'] = $resultat['idGroupeFacturegarant'];
	}
	
	public function getDetailFactureDeficitGarant($idEntetefacturegarant)
	{
		
		$sql = 'CALL sp_get_detail_facturation_deficit_garant(?);';
		
		$liste = $this->executerRequete($sql, array($idEntetefacturegarant));
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }
}