public static function getRDVStat($medecin) { $req = StaticRepo::getConnexion()->prepare('SELECT count(*) NombreRDV, sum((HOUR(Duree)*60)+MINUTE(Duree)) AS DureeTotale FROM RDV WHERE Medecin_id = :medecin;'); $req->execute(['medecin' => $medecin]); $returned = StaticRepo::delNumeric($req->fetch(), true); return $returned; }
public static function getByMonth($date) { $strDate = date('Y-m-d', $date); // si erreur on retourne un tableau vide if (!StaticRepo::checkParam($strDate, 'Date')) { return []; } $req = StaticRepo::getConnexion()->prepare('SELECT *, ((HOUR(Duree)*60)+MINUTE(Duree)) AS Minute FROM RDV WHERE MONTH(DateRDV) = :month AND YEAR(DateRDV) = :year ORDER BY DateRDV ASC'); $req->execute(['month' => date('m', $date), 'year' => date('Y', $date)]); return StaticRepo::delNumeric($req->fetchAll()); }
public function newPoids($id_motcle, $poids) { $request = $this->connexion->prepare("UPDATE MOT_CLE\n \t\tSET POIDS = :poids\n \t\tWHERE ID = :id_motcle"); $request->execute(array(':id_motcle' => $id_motcle, ':poids' => $poids)); return StaticRepo::delNumeric($request->fetchAll()); }
public static function getAll() { $req = StaticRepo::getConnexion()->query('SELECT * FROM Patient ORDER BY nom, prenom ASC'); return StaticRepo::delNumeric($req->fetchAll()); }
public function testDelNumericTwoDimension() { $array = [0 => [0 => 'kjbk', 'kughk' => 'kjbk', 1 => 'aze', 'azert' => 'aze'], 1 => [0 => 'kjbk', 'kughk' => 'kjbk', 1 => 'aze', 'azert' => 'aza']]; $this->assertEquals(StaticRepo::delNumeric($array), [0 => ['kughk' => 'kjbk', 'azert' => 'aze'], 1 => ['kughk' => 'kjbk', 'azert' => 'aza']]); }
public function selectMessage($id_event) { $request = $this->connexion->prepare("SELECT M.CONTENU, M.DATE \n FROM MESSAGE M, EVENT E \n WHERE E.ID = M.ID_EVENT \n AND E.ID = :id_event"); $request->execute(array(':id_event' => $id_event)); return StaticRepo::delNumeric($request->fetchAll()); }