<?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));
	}
}