1154 lines
32 KiB
PHP
Executable File
1154 lines
32 KiB
PHP
Executable File
<?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);
|
|
}
|
|
} |