<?php

require_once 'Framework/Modele.php';

class Statistique extends Modele {

	public function initstat($dateAnalyse) 
	{
		$user 				= $_SESSION['login'];
		$idSaisie 			= $_SESSION['idSaisie'];
		
		$sql = 'call sp_init_stat(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($dateAnalyse, $user, $idSaisie));
		
		if ($resultat->rowCount() == 0)
		{
			 return "0";
		} else
		{
			$ligne = $resultat->fetch(PDO::FETCH_ASSOC);
			
			$_SESSION['idEntetestat_C'] = $ligne['idEntetestat'];
			$idEntetestat = $_SESSION['idEntetestat_C'];
			
			// return $idEntetestat;
		}	 
    }	
	
	public function getParametreStat()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'SELECT * FROM s_entetestat_temp where (id=?);';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetch(PDO::FETCH_ASSOC);
    }	

    public function getListe() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeEtat as `code`, nomEtatEng as libelle FROM etatstatistiques order by ordre;';
		}
		else
		{
			$sql = 'SELECT codeEtat as `code`, nomEtat as libelle FROM etatstatistiques order by ordre;';
		}
		
		$liste = $this->executerRequete($sql);

        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	
	
    public function getListeArchive() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeEtat as `code`, nomEtatEng as libelle FROM etatstatistiques where (archive="1") order by ordre;';
		}
		else
		{
			$sql = 'SELECT codeEtat as `code`, nomEtat as libelle FROM etatstatistiques where (archive="1") order by ordre;';
		}
		
		$liste = $this->executerRequete($sql);

        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	
	
    public function getListeNonArchive() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeEtat as `code`, nomEtatEng as libelle FROM etatstatistiques where (archive!="1") order by ordre;';
		}
		else
		{
			$sql = 'SELECT codeEtat as `code`, nomEtat as libelle FROM etatstatistiques where (archive!="1") order by ordre;';
		}
		
		$liste = $this->executerRequete($sql);

        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	

	
	public function etatcumulprestataire($debutStat, $finStat)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_cumul_prestataire(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $debutStat, $finStat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatcumulprestatairetotal($debutStat, $finStat)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_cumul_prestataire_total(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $debutStat, $finStat));
		
		return $resultat->fetch(PDO::FETCH_ASSOC);
    }	

	public function etatcumulprestataireexport($debutStat, $finStat)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_cumul_prestataire_export(?, ?, ?)';

		$resultat = $this->executerRequete($sql, array($idEntetestat, $debutStat, $finStat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
//

	public function etatcumultypeprestataire($debutStat, $finStat)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_cumul_type_prestataire(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $debutStat, $finStat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatcumultypeprestataireexport($debutStat, $finStat)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_cumul_type_prestataire_export(?, ?, ?)';

		$resultat = $this->executerRequete($sql, array($idEntetestat, $debutStat, $finStat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatdetailfactureeexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_detail_facture_export(?)';

		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	// cumul par mois
	public function etatcumulprestatairemois($debutStat, $finStat)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_cumul_prestataire_mois(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $debutStat, $finStat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatcumulprestatairemoistotal($debutStat, $finStat)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		// $sql = 'call sp_s_cumul_prestataire_mois_total(?, ?, ?)';
		$sql = 'call sp_s_cumul_prestataire_mois_total()';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $debutStat, $finStat));
		
		return $resultat->fetch(PDO::FETCH_ASSOC);
    }	

	public function etatcumulprestatairmoiseexport($debutStat, $finStat)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_cumul_prestataire_mois_export(?, ?, ?)';

		$resultat = $this->executerRequete($sql, array($idEntetestat, $debutStat, $finStat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatrapportspexo()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_exo(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	
	public function etatrapportspexoexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_exo_export(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatrapportsp()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	
	public function etatrapportspexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_export(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatdetailfactureprestataireexport($codePrestataire)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];

		$debutStat	= $_SESSION['debutStat'];
		$finStat 	= $_SESSION['finStat'];
		
		$sql = 'call sp_s_detail_facture_prestataire_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $codePrestataire, $debutStat, $finStat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatdetailfactureprestatairemoisexport($codePrestataire, $mois)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];

		$debutStat	= $_SESSION['debutStat'];
		$finStat 	= $_SESSION['finStat'];

		$sql = 'call sp_s_detail_facture_prestataire_mois_export(?, ?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $codePrestataire, $mois, $debutStat, $finStat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatdetailfacturetypeprestataireexport($codeReseau)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];

		$debutStat	= $_SESSION['debutStat'];
		$finStat 	= $_SESSION['finStat'];

		$sql = 'call sp_s_detail_facture_type_prestataire_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $codeReseau, $debutStat, $finStat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatrapportsppolcat()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_pol_cat(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function etatrapportsppolcatexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_pol_cat_export(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatrapportspcat()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_cat(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function etatrapportspcatexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_cat_export(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	// ETAT DG
	public function etatrapportsppolcatdet($codeProduit)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		$codeProduit = contruireParamLike($codeProduit);
		
		$sql = 'call sp_s_rapportsp_pol_cat_det(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $codeProduit));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function etatrapportsppolcatdetexport($codeProduit)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		$codeProduit = contruireParamLike($codeProduit);
		
		$sql = 'call sp_s_rapportsp_pol_cat_det_export(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $codeProduit));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	// Etat 10
	public function etatrapportspcatdet()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_cat_det(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function etatrapportspcatdetexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_cat_det_export(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	// Polices non renouvellées
	
	public function etatpolnonren()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_polices_non_renouvellees(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function etatpolnonrenexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_polices_non_renouvellees_export(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function detailrapportsp($idPolice)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_police_adherent(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function detailrapportsppdfentete($idPolice)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_police_adherent_pdf_entete(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $dateAnalyse));
		
		return $resultat->fetch(PDO::FETCH_ASSOC);
    }	
	
	public function detailrapportsppdf($idPolice)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_police_adherent_pdf(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function detailrapportspfacture($idPolice)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_police_facture(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function detailrapportspfacturepdf($idPolice)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_police_facture_pdf(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $dateAnalyse));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function detailrapportspgarantiepdf($idPolice)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_police_garantie_pdf(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function detailrapportspgarantie($idPolice)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_police_garantie(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	
	public function listepolicerapportspmail()
	{
		$sql = 'call sp_s_liste_police_rapportsp_mail()';
		
		$resultat = $this->executerRequete($sql);
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function etatrapportspadheleve()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_adheleve(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	public function detailrapportspadhpdfentete($idAdherent)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_adherent_pdf_entete(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idAdherent, $dateAnalyse));
		
		return $resultat->fetch(PDO::FETCH_ASSOC);
    }	

	public function detailrapportspadhfacturepdf($idAdherent)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_adherent_facture_pdf(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idAdherent, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function detailrapportspgarantieadhpdf($idAdherent)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_adherent_garantie_pdf(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idAdherent, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function detailrapportspfactureadh($idAdherent)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_adherent_facture(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idAdherent, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function detailrapportspgarantieadh($idAdherent)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_adherent_garantie(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idAdherent, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatrapportspadheleveexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_adheleve_export(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
    public function getListeEtatProd() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeEtat as `code`, nomEtatEng as libelle FROM etatproduction order by ordre;';
		}
		else
		{
			$sql = 'SELECT codeEtat as `code`, nomEtat as libelle FROM etatproduction order by ordre;';
		}
		
		$liste = $this->executerRequete($sql);

        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	

    public function getListeEtatSin() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeEtat as `code`, nomEtatEng as libelle FROM etatsinistre order by ordre;';
		}
		else
		{
			$sql = 'SELECT codeEtat as `code`, nomEtat as libelle FROM etatsinistre order by ordre;';
		}
		
		$liste = $this->executerRequete($sql);

        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatprodparclient($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_production_globale_par_client(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatprodparclientexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];

		if (est_anglophone())
		{
			$sql = 'call sp_pr_production_globale_par_client_export_eng(?, ?, ?)';
		}
		else
		{
			$sql = 'call sp_pr_production_globale_par_client_export(?, ?, ?)';
		}
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatprodparmois($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_production_globale_par_mois(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatprodparmoisexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_production_globale_par_mois_export(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatprodparemission($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_production_par_emission(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatprodparemissionexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		if (est_anglophone())
		{
			$sql = 'call sp_pr_production_par_emission_export_eng(?, ?, ?)';
		}
		else
		{
			$sql = 'call sp_pr_production_par_emission_export(?, ?, ?)';
		}
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
    public function getListeEtatSynthese() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeEtat as `code`, nomEtatEng as libelle FROM etatsynthese order by ordre;';
		}
		else
		{
			$sql = 'SELECT codeEtat as `code`, nomEtat as libelle FROM etatsynthese order by ordre;';
		}
		
		$liste = $this->executerRequete($sql);
		
        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	// Etatssyntheses
	public function etatevolspmois($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_synth_mois(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatevolspmoisexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_synth_mois_export(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	// 27/08/2018
	public function etatevolspmoisacqu($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_synth_mois_acqu(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatevolspmoisacquexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_synth_mois_acqu_export(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	// 31/03/2019 => Rapport SP par police dans un meme exercice
	public function etatrapportspexercice()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_exercice(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	
	public function etatrapportspexerciceexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_exercice_export(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function detailrapportspfactureexercicepdf($idPolice, $debutSinistre, $finSinistre)
	{
		$sql = 'call sp_rapport_sp_police_facture_exercice_pdf(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $debutSinistre, $finSinistre));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function detailrapportspfactureexercice($idPolice, $debutSinistre, $finSinistre)
	{
		$sql = 'call sp_rapport_sp_police_facture_exercice(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $debutSinistre, $finSinistre));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatprodsituationclients($dateAnalyse)
	{
		$codeSociete = $_SESSION['codeSociete'];
		
		$sql = 'call sp_pr_production_situation_clients(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($codeSociete, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatprodsituationclientsexport($dateAnalyse)
	{
		$codeSociete = $_SESSION['codeSociete'];
		
		if (est_anglophone())
		{
			$sql = 'call sp_pr_production_situation_clients_export_eng(?, ?)';
		}
		else
		{
			$sql = 'call sp_pr_production_situation_clients_export(?, ?)';
		}
		
		$resultat = $this->executerRequete($sql, array($codeSociete, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
    public function etatpaiementprestationcumul($debut, $fin) 
	{
		$sql = 'call sp_sin_paiementprestationcumul(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debut, $fin));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
    public function etatpaiementprestationcumulexport($debut, $fin) 
	{
		$sql = 'call sp_sin_paiementprestationcumul_export(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debut, $fin));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	// 
	
    public function etatpaiementprestationdet($debut, $fin) 
	{
		$sql = 'call sp_sin_paiementprestationdet(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debut, $fin));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
    public function etatpaiementprestationdetexport($debut, $fin) 
	{
		$sql = 'call sp_sin_paiementprestationdet_export(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debut, $fin));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }

	public function etatfactparclient($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_facturation_globale_par_client(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatfactparclientexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		if (est_anglophone())
		{
			$sql = 'call sp_pr_facturation_globale_par_client_export_eng(?, ?, ?)';
		}
		else
		{
			$sql = 'call sp_pr_facturation_globale_par_client_export(?, ?, ?)';
		}
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatfactparmois($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_facturation_globale_par_mois(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatfactparmoisexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_facturation_globale_par_mois_export(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatfactparemission($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_facturation_par_emission(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatfactparemissionexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		if (est_anglophone())
		{
			$sql = 'call sp_pr_facturation_par_emission_export_eng(?, ?, ?)';
		}
		else
		{
			$sql = 'call sp_pr_facturation_par_emission_export(?, ?, ?)';
		}
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	// etatprod_encaissement
	public function etatencparclient($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_encaissement_globale_par_client(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatencparclientexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		if (est_anglophone())
		{
			$sql = 'call sp_pr_encaissement_globale_par_client_export_eng(?, ?, ?)';
		}
		else
		{
			$sql = 'call sp_pr_encaissement_globale_par_client_export(?, ?, ?)';
		}
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatencparmois($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_encaissement_globale_par_mois(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatencparmoisexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_encaissement_globale_par_mois_export(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatbordereauenc($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_bordereau_encaisssements(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function eetatbordereauencexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		if (est_anglophone())
		{
			$sql = 'call sp_pr_bordereau_encaisssements_export_eng(?, ?, ?)';
		}
		else
		{
			$sql = 'call sp_pr_bordereau_encaisssements_export(?, ?, ?)';
		}
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

    public function getListeRequeteRecherche() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeEtat as `code`, nomEtatEng as libelle FROM etatrecherche order by ordre;';
		}
		else
		{
			$sql = 'SELECT codeEtat as `code`, nomEtat as libelle FROM etatrecherche order by ordre;';
		}
		
		$liste = $this->executerRequete($sql);

        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function detailrapportspanomalies($idPolice)
	{
		$dateAnalyse = $_SESSION['dateAnalyse'];

		$sql = 'call sp_rapport_sp_police_garantie_anomalie(?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $dateAnalyse));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatprodparmoiseclate($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_production_globale_par_mois_eclate(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatprodparmoiseclateexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_production_globale_par_mois_eclate_export(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	// 24/01/2020
	public function etatprodparmoiseclateclient($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_production_globale_par_mois_eclate_client(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatprodparmoiseclateclientexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_production_globale_par_mois_eclate_client_export(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatmoycategmedprestataire($debutStat, $finStat)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_moy_categ_med_prestataire(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $debutStat, $finStat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatmoycategmedprestataireexport($debutStat, $finStat)
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_moy_categ_med_prestataire_export(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat, $debutStat, $finStat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

    public function getListeEtatFamiliale() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeEtat as `code`, nomEtatEng as libelle FROM etatassurancefamiliale order by ordre;';
		}
		else
		{
			$sql = 'SELECT codeEtat as `code`, nomEtat as libelle FROM etatassurancefamiliale order by ordre;';
		}
		
		$liste = $this->executerRequete($sql);

        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	

	// Début Entrée Familiale
	public function statfamilialeentreedetail($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_detail(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreedetailexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_detail_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function entetestatfamiliale($idPolice)
	{
		$sql = 'call sp_entete_stat_familiale(?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice));
		
		return $resultat->fetch(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpfam($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_fam(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpfamexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_fam_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpcomech($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_com_ech(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpcomechexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_com_ech_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpcom($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_com(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpcomexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_com_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpperech($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_per_ech(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpperechexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_per_ech_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function statfamilialeentreegrpper($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_per(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpperexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_per_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpexeech($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_exe_ech(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpexeechexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_exe_ech_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function statfamilialeentreegrpexe($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_exe(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpexeexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_exe_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpech($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_ech(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialeentreegrpechexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_entree_grp_ech_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	// Fin Entree familiale
	


	// Début sortie Familiale
	public function statfamilialesortiedetail($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_detail(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiedetailexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_detail_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpfam($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_fam(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpfamexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_fam_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpcomech($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_com_ech(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpcomechexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_com_ech_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpcom($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_com(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpcomexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_com_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpperech($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_per_ech(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpperechexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_per_ech_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function statfamilialesortiegrpper($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_per(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpperexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_per_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpexeech($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_exe_ech(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpexeechexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_exe_ech_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function statfamilialesortiegrpexe($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_exe(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpexeexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_exe_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpech($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_ech(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function statfamilialesortiegrpechexport($idPolice, $codeApporteur, $debutPeriode, $finPeriode)
	{
		$sql = 'call sp_stat_familiale_sortie_grp_ech_export(?, ?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($idPolice, $codeApporteur, $debutPeriode, $finPeriode));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	// Fin sortie Familiale
	
	// 2/11/2020
    public function getListeEnteteEtatFamiliale() 
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeEnteteEtat AS `code`, libelleEng AS libelle FROM etatassurancefamiliale ORDER BY ordre;';
		}
		else
		{
			$sql = 'SELECT codeEnteteEtat AS `code`, libelle FROM enteteetatassurancefamiliale ORDER BY ordre;';
		}
		
		$liste = $this->executerRequete($sql);

        return $liste->fetchAll(PDO::FETCH_ASSOC);
    }	
	
    public function getListeEtatFamilialeFiltre($codeEnteteEtat)
	{
		if (est_anglophone())
		{
			$sql = 'SELECT codeEtat as `code`, nomEtatEng as libelle FROM etatassurancefamiliale where codeEnteteEtat = ? order by ordre;';
		}
		else
		{
			$sql = 'SELECT codeEtat as `code`, nomEtat as libelle FROM etatassurancefamiliale where codeEnteteEtat = ? order by ordre;';
		}
		
		$resultat = $this->executerRequete($sql, array($codeEnteteEtat));

		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatrapportspcatgp()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_cat_gp(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }


	public function etatrapportspcatgpexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_cat_gp_export(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	


	public function etatrapportspcatgpdet()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_cat_gp_det(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }

	public function etatrapportspcatgpdetexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_cat_gp_det_export(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	// 07/01/2024 => Rapport SP par police dans un meme exercice par cat"gorie
	public function etatrapportspexercicecat()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_exercice_cat_gp(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }
	
	
	public function etatrapportspexercicecatexport()
	{
		$idEntetestat = $_SESSION['idEntetestat_C'];
		
		$sql = 'call sp_s_rapportsp_exercice_cat_gp_export(?)';
		
		$resultat = $this->executerRequete($sql, array($idEntetestat));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	
	
	public function etatprodagences($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_production_agences(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

	public function etatprodagencesexport($debutPeriode, $finPeriode)
	{
		$user 	= $_SESSION['login'];
		
		$sql = 'call sp_pr_production_agences_export(?, ?, ?)';
		
		$resultat = $this->executerRequete($sql, array($debutPeriode, $finPeriode, $user));
		
		return $resultat->fetchAll(PDO::FETCH_ASSOC);
    }	

}