120 lines
3.4 KiB
PHP
Executable File
120 lines
3.4 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modelecentral.php';
|
|
class Abonnementcentral extends Modelecentral {
|
|
|
|
public function getFacturesGestionnaireSaas($codeSociete, $codeExercice)
|
|
{
|
|
$sql = 'call sp_filtrer_facture_gestionnaire_consultation(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $codeExercice));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getTotalFacturesGestionnaireSaas($codeSociete, $codeExercice)
|
|
{
|
|
$sql = 'call sp_total_facture_gestionnaire_consultation(?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $codeExercice));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function initFacturesGestionnaireImpayees($codeSociete)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_init_factures_gestionnaire_impayees(?, ?, ?);';
|
|
|
|
//var_dump($codeSociete, $user, $idSaisie); die();
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $user, $idSaisie));
|
|
}
|
|
|
|
public function getFacturesGestionnaireImpayeesSaas($codeSociete)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_afficher_factures_gestionnaire_impayees(?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $user, $idSaisie));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getTotalFacturesGestionnaireImpayeesSaas($codeSociete)
|
|
{
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_get_total_factures_gestionnaire_impayees(?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete, $user, $idSaisie));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function majtoutesimpayees($choix)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = "CALL sp_selection_facture_saas_tous(?, ?, ?);";
|
|
|
|
$this->executerRequete($sql, array($user, $idSaisie, $choix));
|
|
}
|
|
|
|
public function getNbreFacturesSelectionnees()
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = 'SELECT fn_nombre_factures_selectionnees(?, ?) AS nbreFacture;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['nbreFacture'];
|
|
|
|
}
|
|
|
|
public function getChoixToutesFactures()
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = 'SELECT fn_choix_toutes_factures_impayees(?, ?) AS choixToutes;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($user, $idSaisie))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $resultat['choixToutes'];
|
|
|
|
}
|
|
|
|
public function selectionfactureimpayee($id,$choix){
|
|
$sql = "CALL sp_selection_facture_saas(?, ?);";
|
|
$this->executerRequete($sql, array($id,$choix));
|
|
}
|
|
|
|
public function getTauxChange($codeSociete){
|
|
|
|
$sql = "CALL sp_get_taux_change(?);";
|
|
|
|
$resultat = $this->executerRequete($sql, array($codeSociete));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function majfacturespayees($codeSociete)
|
|
{
|
|
$user = $_SESSION['login'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
|
|
$sql = 'CALL sp_maj_factures_payees_saas(?, ?, ?);';
|
|
|
|
//var_dump(array($codeSociete, $user, $idSaisie)); //die();
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $user, $idSaisie));
|
|
}
|
|
} |