98 lines
3.0 KiB
PHP
Executable File
98 lines
3.0 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
|
|
class Motifecxlusionprestation extends Modele {
|
|
|
|
public function getListe()
|
|
{
|
|
if (est_anglophone())
|
|
{
|
|
$sql = 'SELECT codeMotifExclusion AS `code`, libelleEng AS libelle FROM p_motifecxlusionprestation ORDER BY 2;';
|
|
}
|
|
else
|
|
{
|
|
$sql = 'SELECT codeMotifExclusion AS `code`, libelle FROM p_motifecxlusionprestation ORDER BY 2;';
|
|
}
|
|
|
|
$liste = $this->executerRequete($sql);
|
|
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getMotifDecomptes($idFacture,$numeroDecompte)
|
|
{
|
|
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idReglement = $_SESSION['idReglement_C'];
|
|
$numeroDecompte = $_SESSION['numeroDecompte_C'];
|
|
$codePrestataire = $_SESSION['codePrestataire_C'];
|
|
|
|
$sql = 'call sp_p_get_motif_decompte(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idFacture,$numeroDecompte));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getMotifDecomptesObs($numeroDecompte)
|
|
{
|
|
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$idReglement = $_SESSION['idReglement_C'];
|
|
$numeroDecompte = $_SESSION['numeroDecompte_C'];
|
|
$codePrestataire = $_SESSION['codePrestataire_C'];
|
|
|
|
$sql = 'call sp_p_get_motif_decompte_obs( ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($numeroDecompte));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function majobservations($idFacture, $codeMotifRejet,$numeroLotDecompte,$motifManuel)
|
|
{
|
|
$idReglement = $_SESSION['idReglement_C'];
|
|
$numeroDecompte = $_SESSION['numeroDecompte_C'];
|
|
$codePrestataire = $_SESSION['codePrestataire_C'];
|
|
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$usersaisie = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_maj_observations_facture_decompte(?, ?,?,?,?,?,?)';
|
|
|
|
$this->executerRequete($sql, array($idFacture, $idReglement,$usersaisie ,$codeMotifRejet,$numeroLotDecompte,$numeroDecompte,$motifManuel));
|
|
}
|
|
|
|
public function majobservationsobs( $codeMotifRejet,$numeroLotDecompte,$numeroDecompte,$motifManuel)
|
|
{
|
|
$idReglement = $_SESSION['idReglement_C'];
|
|
$numeroDecompte = $_SESSION['numeroDecompte_C'];
|
|
$codePrestataire = $_SESSION['codePrestataire_C'];
|
|
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$usersaisie = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_r_maj_observations_facture_decompte_obs( ?,?,?,?,?,?)';
|
|
|
|
$this->executerRequete($sql, array( $idReglement,$usersaisie ,$codeMotifRejet,$numeroLotDecompte,$numeroDecompte,$motifManuel));
|
|
}
|
|
|
|
public function supprimermotifDecompte($idMotifDecompte) {
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_p_supprimer_motif_decompte(?, ?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($idMotifDecompte, $user));
|
|
}
|
|
|
|
|
|
public function getListeMotifDecompte($numeroDecompte)
|
|
{
|
|
$sql = 'call sp_r_get_detail_decompte_motif(?)';
|
|
|
|
$resultat = $this->executerRequete($sql, array($numeroDecompte));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
} |