97 lines
2.9 KiB
PHP
Executable File
97 lines
2.9 KiB
PHP
Executable File
<?php
|
|
require_once 'Framework/Modele.php';
|
|
|
|
class Examen extends Modele {
|
|
|
|
public function getexamen($numeroFeuilleMaladie)
|
|
{
|
|
$sql = "SELECT a.*,
|
|
fn__souscripteur_police(a.idPolice) AS nomClient,
|
|
CONCAT(b.`nom`,' ',b.`prenoms`) AS adherent,
|
|
CONCAT(c.`nomBeneficiaire`,' ',c.`prenomsBeneficiaire`) AS beneficiaire,
|
|
c.ticketModerateur,
|
|
c.`telephonePortable`,
|
|
CONCAT(d.`nom`, ' ',d.`prenoms`) AS medecinPrescription,
|
|
p.libelle AS prestataire
|
|
FROM `p_examen` a
|
|
JOIN adherent b ON (b.id = a.idAdherent)
|
|
JOIN beneficiaire c ON (c.id = a.idBeneficiaire)
|
|
JOIN `p_medecin` d ON (d.`codeMedecin`= a.`codeMedecin`)
|
|
JOIN prestataire p ON (p.codePrestataire = a.codePrestataire)
|
|
WHERE a.`numeroFeuilleMaladie`= ?;";
|
|
|
|
$examen = $this->executerRequete($sql, array($numeroFeuilleMaladie));
|
|
|
|
return $examen->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getdetailexamenfeuille($numeroFeuilleMaladie)
|
|
{
|
|
if (isset($_SESSION['lang']) && $_SESSION['lang']=="en_US")
|
|
{
|
|
$sql = "SELECT
|
|
A.*,
|
|
B.libelleEng AS libelleActe,
|
|
C.libelleEng AS libelleFamilleActe
|
|
FROM p_detailexamen A
|
|
JOIN p_acte B ON (B.codeActe=A.codeActe)
|
|
JOIN p_familleacte C ON (C.codeFamilleActe=B.codeFamilleActe)
|
|
WHERE A.numeroFeuilleMaladie=?
|
|
ORDER BY B.libelle;";
|
|
}
|
|
else
|
|
{
|
|
$sql = "SELECT
|
|
A.*,
|
|
B.libelle AS libelleActe,
|
|
C.libelle AS libelleFamilleActe
|
|
FROM p_detailexamen A
|
|
JOIN p_acte B ON (B.codeActe=A.codeActe)
|
|
JOIN p_familleacte C ON (C.codeFamilleActe=B.codeFamilleActe)
|
|
WHERE A.numeroFeuilleMaladie=?
|
|
ORDER BY B.libelle;";
|
|
}
|
|
|
|
$resultat = $this->executerRequete($sql, array($numeroFeuilleMaladie));
|
|
|
|
return $resultat->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getdetailexamenfeuille_total($numeroFeuilleMaladie)
|
|
{
|
|
$sql = 'SELECT
|
|
IFNULL(SUM(fraisReelBase),"0") AS fraisReelBase_total,
|
|
IFNULL(SUM(fraisReel),"0") AS fraisReel_total,
|
|
IFNULL(SUM(montantTm),"0") AS montantTm_total,
|
|
IFNULL(SUM(montantArembourser),"0") AS montantArembourser_total,
|
|
IFNULL(SUM(depassement),"0") AS depassement_total
|
|
FROM p_detailexamen
|
|
WHERE numeroFeuilleMaladie = ?;';
|
|
|
|
$resultat = $this->executerRequete($sql, array($numeroFeuilleMaladie));
|
|
|
|
return $resultat->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function majquantite($idExamen, $quantite, $tm)
|
|
{
|
|
|
|
$sql = 'call sp_p_maj_quantite_examen(?, ?, ?)';
|
|
|
|
$this->executerRequete($sql, array($idExamen, $quantite, $tm));
|
|
}
|
|
|
|
public function supprimerexamen($idExamen)
|
|
{
|
|
$sql = 'call sp_p_supprimer_prescription_examen(?)';
|
|
|
|
$this->executerRequete($sql, array($idExamen));
|
|
}
|
|
|
|
public function updateexamen ($numeroFeuilleMaladie){
|
|
|
|
$sql = 'call sp_p_update_prescription_examen(?);';
|
|
|
|
$this->executerRequete($sql, array($numeroFeuilleMaladie));
|
|
}
|
|
} |