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