44 lines
1.4 KiB
PHP
Executable File
44 lines
1.4 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
|
|
class Detailtarifactedec extends Modele {
|
|
|
|
public function geatactesspossiblesselectiondec($codeFamilleActe)
|
|
{
|
|
$idAdherent = $_SESSION['idAdherent_C'];
|
|
$idFacture = $_SESSION['idFacture_C'];
|
|
$idSaisie = $_SESSION['idSaisie'];
|
|
$user = $_SESSION['login'];
|
|
$codeTarifActe = $_SESSION['codeTarifActe_Dec'];
|
|
$codePrestataire = $_SESSION['codePrestataireTarif'];
|
|
|
|
|
|
|
|
$sql = 'call sp_r_recherche_actes_selection_dec(?, ?, ?, ?, ?, ?, ?)';
|
|
|
|
//var_dump($idFacture, $codeTarifActe, $codeFamilleActe, $codePrestataire, $idAdherent, $idSaisie, $user);
|
|
|
|
$resultat = $this->executerRequete($sql, array($idFacture, $codeTarifActe, $codeFamilleActe, $codePrestataire, $idAdherent, $idSaisie, $user));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getactesexamenspossiblesdec($libelle)
|
|
{
|
|
$idFacture = $_SESSION['idFacture_C'];
|
|
|
|
$codePrestataire = $_SESSION['codePrestataireTarif'];
|
|
|
|
$libelle = contruireParamLike($libelle);
|
|
|
|
|
|
$sql = 'call sp_rechercher_actes_examens_possibles_dec_newversion(?, ?, ?)';
|
|
|
|
//var_dump($idFacture, $codePrestataire, $libelle);
|
|
|
|
$resultat = $this->executerRequete($sql, array($idFacture, $codePrestataire, $libelle));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
} |