92 lines
2.7 KiB
PHP
Executable File
92 lines
2.7 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
|
|
class Remboursement extends Modele {
|
|
public function getBeneficaire($idDemandeRemboursement)
|
|
{
|
|
$sql = 'Call sp_get_beneficiaire_remboursement(?)';
|
|
|
|
$liste = $this->executerRequete($sql,array($idDemandeRemboursement));
|
|
return $liste->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getCodeLienParente($numeroBeneficiaire)
|
|
{
|
|
$sql = "SELECT fn_code_lienparente(?) AS codeLienParente;";
|
|
|
|
$resultat = $this->executerRequete($sql, array($numeroBeneficiaire));
|
|
|
|
$lien = $resultat->fetch(PDO::FETCH_ASSOC);
|
|
|
|
return $lien['codeLienParente'];
|
|
|
|
}
|
|
|
|
public function getLienParenteBeneficaire($numeroBeneficiaire)
|
|
{
|
|
$sql = 'Call sp_afficher_lienparente_beneficiaire(?)';
|
|
|
|
$liste = $this->executerRequete($sql,array($numeroBeneficiaire));
|
|
|
|
return $liste->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
|
|
|
|
public function getDemandeRemboursement($idDemandeRemboursement)
|
|
{
|
|
$sql = 'Call sp_a_demande_remboursement(?)';
|
|
|
|
$liste = $this->executerRequete($sql,array($idDemandeRemboursement));
|
|
|
|
return $liste->fetch(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function enregistrerdemande($numeroBeneficiaire, $commentaires)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
|
|
$sql = 'Call sp_a_enregistrer_demande_remboursement(?, ?, ?);';
|
|
|
|
$liste = $this->executerRequete($sql,array($codeSociete, $numeroBeneficiaire, $commentaires))->fetch(PDO::FETCH_ASSOC);
|
|
|
|
|
|
$_SESSION['idDemandeRemboursement'] = $liste['idDemandeRemboursement'];
|
|
}
|
|
|
|
public function getDemandesRemboursement($d1, $d2, $codeEtatDemandeRemboursement)
|
|
{
|
|
$codeEtatDemandeRemboursement = contruireParamLike($codeEtatDemandeRemboursement);
|
|
|
|
$sql = 'call sp_get_historique_demande_remboursement(?, ?, ?);';
|
|
|
|
$resultat = $this->executerRequete($sql, array($d1, $d2, $codeEtatDemandeRemboursement));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getEtatRemboursement()
|
|
{
|
|
if (est_anglophone()){
|
|
$sql = 'call sp_a_get_etat_remboursement_eng()';
|
|
}else{
|
|
$sql = 'call sp_a_get_etat_remboursement()';
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql);
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
}
|
|
|
|
public function majreponse($idDemandeRemboursement, $codeEtatDemandeRemboursement, $motifReponseDemandeRemboursement)
|
|
{
|
|
$codeSociete = $_SESSION['codeSociete'];
|
|
$user = $_SESSION['login'];
|
|
|
|
$sql = 'call sp_maj_reponse_demande_remboursement(?, ?, ?, ?, ?);';
|
|
|
|
$this->executerRequete($sql, array($codeSociete, $idDemandeRemboursement, $codeEtatDemandeRemboursement, $motifReponseDemandeRemboursement, $user));
|
|
}
|
|
} |