public static function exists(int $id)
{
$statement = StaticRepo::getConnexion()->prepare("SELECT * FROM coordonnees WHERE ID = :id");
$ret = $statement->exec(array(':id' => $id));
$tab = $ret->fetch();
return isset($tab['ID']) && $tab['ID'] != null;
}
public function testCheckParam()
{
$this->assertTrue(StaticRepo::checkParam("Bonjour", 'String20'));
$this->assertFalse(StaticRepo::checkParam("Bonjour", 'String5'));
$this->assertTrue(StaticRepo::checkParam("M", 'Civilite'));
$this->assertTrue(StaticRepo::checkParam("F", 'Civilite'));
$this->assertFalse(StaticRepo::checkParam("P", 'Civilite'));
$this->assertTrue(StaticRepo::checkParam(100, 'Integer'));
$this->assertTrue(StaticRepo::checkParam(0, 'Integer'));
$this->assertFalse(StaticRepo::checkParam(4294967296, 'Integer'));
$this->assertTrue(StaticRepo::checkParam(100, 'TinyInteger'));
$this->assertTrue(StaticRepo::checkParam(0, 'TinyInteger'));
$this->assertFalse(StaticRepo::checkParam(256, 'TinyInteger'));
$this->assertTrue(StaticRepo::checkParam(100, 'SmallInteger'));
$this->assertTrue(StaticRepo::checkParam(0, 'SmallInteger'));
$this->assertFalse(StaticRepo::checkParam(65536, 'SmallInteger'));
$this->assertTrue(StaticRepo::checkParam(100, 'BigInteger'));
$this->assertTrue(StaticRepo::checkParam(0, 'BigInteger'));
$this->assertFalse(StaticRepo::checkParam(1.84467440737E+19, 'BigInteger'));
$this->assertTrue(StaticRepo::checkParam('19/11/1996', 'Date'));
$this->assertFalse(StaticRepo::checkParam('15/1551', 'Date'));
$this->assertFalse(StaticRepo::checkParam('15/1f/5451', 'Date'));
$this->assertTrue(StaticRepo::checkParam('19:30', 'Heure'));
$this->assertFalse(StaticRepo::checkParam('af:65', 'Heure'));
$this->assertFalse(StaticRepo::checkParam('15451', 'Heure'));
$this->assertFalse(StaticRepo::checkParam('lololo', 'lolololo'));
}
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 add($id, $name, $screen_name, $image_url)
{
if (!self::authorExists($id)) {
$query = StaticRepo::getConnexion()->prepare('INSERT INTO Author VALUES (:id, :name, :screen_name, :image_url)');
$query->execute([':id' => $id, ':name' => $name, ':screen_name' => $screen_name, ':image_url' => $image_url]);
}
}
public static function linkToTweet($tweet_id, $hashtag)
{
// Ajout du lien entre un hashtag et un tweet
$hashtag_id = self::getOrCreate($hashtag);
$query = StaticRepo::getConnexion()->prepare('INSERT INTO contenir VALUES (:tweet_id, :hashtag_id)');
$query->execute([':tweet_id' => $tweet_id, ':hashtag_id' => $hashtag_id]);
}
public static function getOrCreate($longitude, $latitude, $region, $pays, $ville)
{
$query = StaticRepo::getConnexion()->prepare('SELECT id FROM Coordonnees
WHERE longitude = :longitude AND latitude = :latitude');
$query->execute([':longitude' => $longitude, ':latitude' => $latitude]);
$coordonnee = $query->fetch();
// Si il existe on le retourne
if ($coordonnee != false) {
return $coordonnee['id'];
}
// Sinon on insert un nouvel hashtag
return self::add($longitude, $latitude, $region, $pays, $ville);
}
public function update($params)
{
// si params ok
if (StaticRepo::checkParam($params['id_consultation'], 'Numeric') && StaticRepo::checkParam($params['jour'], 'Date') && StaticRepo::checkParam($params['heure'], 'Heure') && StaticRepo::checkParam($params['Duree'], 'Heure')) {
$params['date'] = DateTime::createFromFormat('d/m/Y H:i', $params['jour'] . ' ' . $params['heure']);
$params['dureeTime'] = $params['Duree'] . ':00';
// var_dump($params['dureeTime']);
if (RDVRepo::updateDateTime($params['id_consultation'], $params['date']->format('Y-m-d H:i:00'), $params['dureeTime']) !== FALSE) {
$_status = 'success';
$_title = 'Modification effectuée!';
$_message = 'La consultation du ' . $params['date']->format('d/m/Y') . ' à ' . $params['heure'] . ' a bien été mise à jour.';
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
Response::quickResponse(200, json_encode(['status' => $_status, 'title' => $_title, 'message' => $_message]));
} else {
$response = new Response();
$response->setHeader('Location', 'http://' . $_SERVER['HTTP_HOST'] . '/Consultations.php?status=' . $_status . '&title=' . $_title . '&message=' . $_message);
$response->send();
}
} else {
$_status = 'error';
$_title = 'Erreur lors de la modifiction!';
$_message = 'La consultation n\'a pas pu être modifiée!';
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
Response::quickResponse(200, json_encode(['status' => $_status, 'title' => $_title, 'message' => $_message]));
} else {
$response = new Response();
$response->setHeader('Location', 'http://' . $_SERVER['HTTP_HOST'] . '/Consultations.php?status=' . $_status . '&title=' . $_title . '&message=' . $_message);
$response->send();
}
}
} else {
$_status = 'error';
$_title = 'Erreur de paramètre!';
$_message = 'Date Incorrecte!';
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
Response::quickResponse(200, json_encode(['status' => $_status, 'title' => $_title, 'message' => $_message]));
} else {
$response = new Response();
$response->setHeader('Location', 'http://' . $_SERVER['HTTP_HOST'] . '/Consultations.php?status=' . $_status . '&title=' . $_title . '&message=' . $_message);
$response->send();
}
}
}
public function add($params)
{
if (StaticRepo::checkParam($params['date_naissance'], 'Date')) {
$params['num_secu'] = str_replace(' ', '', $params['num_secu']);
$params['date_naissance'] = DateTime::createFromFormat('d/m/Y', $params['date_naissance']);
if (PatientRepo::add($params['civilite'], strtolower($params['prenom']), strtolower($params['nom']), $params['adresse'], $params['adresse2'], $params['ville'], $params['code_postal'], $params['date_naissance']->format('Y-m-d'), $params['lieu_naissance'], $params['num_secu'], $params['medecin_traitant']) !== FALSE) {
$_status = 'success';
$_title = 'Création effectuée!';
$_message = 'Le patient <strong>' . $params['prenom'] . ' ' . $params['nom'] . '</strong> a bien été créé.';
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
Response::quickResponse(200, json_encode(['status' => $_status, 'title' => $_title, 'message' => $_message]));
} else {
$response = new Response();
$response->setHeader('Location', 'http://' . $_SERVER['HTTP_HOST'] . '/Patients.php?status=' . $_status . '&title=' . $_title . '&message=' . $_message);
$response->send();
}
} else {
$_status = 'error';
$_title = 'Erreur de création!';
$_message = 'Certains champs étaient incorrects. Réessayez!';
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
Response::quickResponse(200, json_encode(['status' => $_status, 'title' => $_title, 'message' => $_message]));
} else {
$response = new Response();
$response->setHeader('Location', 'http://' . $_SERVER['HTTP_HOST'] . '/Patients.php?status=' . $_status . '&title=' . $_title . '&message=' . $_message);
$response->send();
}
}
} else {
$_status = 'error';
$_title = 'Erreur de création!';
$_message = 'Le format de la date est incorrect. Réessayez!';
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
Response::quickResponse(200, json_encode(['status' => $_status, 'title' => $_title, 'message' => $_message]));
} else {
$response = new Response();
$response->setHeader('Location', 'http://' . $_SERVER['HTTP_HOST'] . '/Patients.php?status=' . $_status . '&title=' . $_title . '&message=' . $_message);
$response->send();
}
}
}
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());
}
<?php
/**
* Created by PhpStorm.
* User: seekdasky
* Date: 03/12/15
* Time: 11:52
*/
require_once 'autoloader.php';
$jsonP = json_decode(file_get_contents('Docs/PatientExemple.json'), true);
$jsonM = json_decode(file_get_contents('Docs/MedecinExemple.json'), true);
$jsonR = json_decode(file_get_contents('Docs/RDVExemple.json'), true);
var_dump(StaticRepo::testConnexion());
$repo = new PatientRepo();
$repoM = new MedecinRepo();
foreach ($jsonM as $patient) {
$repoM->add($patient['Civilite'], $patient['Prenom'], $patient['Nom']);
}
foreach ($jsonP as $patient) {
$repo->add($patient['Civilite'], $patient['Prenom'], $patient['Nom'], $patient['Adresse'], NULL, $patient['Ville'], $patient['CodePostal'], $patient['DateNaissance'], $patient['LieuNaissance'], $patient['NumSecuriteSociale'], $patient['MedecinTraitant']);
}
foreach ($jsonR as $rdv) {
RDVRepo::add($rdv['DateRDV'], $rdv['Duree'], $rdv['Patient_Id'], $rdv['Medecin_Id']);
}
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 static function update($id, $nom, $prenom)
{
$req = StaticRepo::getConnexion()->prepare("UPDATE Medecin SET Nom = :nom, Prenom = :prenom WHERE Id = :id");
return $req->execute([':nom' => strtoupper($nom), ':prenom' => $prenom, ':id' => $id]);
}
private static function add($id, $lien, $contenu, $nbfav, $nbRT, $localisation, $langue, $auteur, $date)
{
$query = StaticRepo::getConnexion()->prepare('INSERT INTO `tweet`(`ID`, `LIEN`, `CONTENU`, `NB_FAVORIS`, `NB_RT`, `LOCALISATION`, `LANGUE`, `AUTHOR`, `POIDS`, `DATE`)
VALUES (:id, :lien, :contenu, :nbfav, :nbRT, :localisation, :langue, :auteur, :poids, :date)');
$query->execute([':id' => $id, ':lien' => $lien, ':contenu' => $contenu, ':nbfav' => $nbfav, ':nbRT' => $nbRT, ':localisation' => $localisation, ':langue' => $langue, ':auteur' => $auteur, 'poids' => 0, 'date' => $date]);
}
public static function add($id, $name, $screen_name, $image_url)
{
$query = StaticRepo::getConnexion()->prepare('INSERT INTO Author VALUES (:id, :name, :screen_name, :image_url)');
$query->execute([':id' => $id, ':name' => $name, ':screen_name' => $screen_name, ':image_url' => $image_url]);
return StaticRepo::getConnexion()->lastInsertId();
}
public function update($params)
{
if (StaticRepo::checkParam($params['Id'], 'Numeric') && StaticRepo::checkParam($params['Prenom'], 'String45') && StaticRepo::checkParam($params['Nom'], 'String45')) {
// si la modification réussit
if (MedecinRepo::update($params['Id'], $params['Nom'], $params['Prenom'])) {
$_status = 'success';
$_title = 'Médecin modifié!';
$_message = 'Le médecin <strong>' . $params['Prenom'] . ' ' . strtoupper($params['Nom']) . '</strong> a bien été modifié! ';
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
Response::quickResponse(200, json_encode(['status' => $_status, 'title' => $_title, 'message' => $_message]));
} else {
$response = new Response();
$response->setHeader('Location', 'http://' . $_SERVER['HTTP_HOST'] . '/Medecins.php?status=' . $_status . '&title=' . $_title . '&message=' . $_message);
$response->send();
}
} else {
$_status = 'error';
$_title = 'Erreur de modification!';
$_message = 'La modification a échoué. Réessayez!';
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
Response::quickResponse(200, json_encode(['status' => $_status, 'title' => $_title, 'message' => $_message]));
} else {
$response = new Response();
$response->setHeader('Location', 'http://' . $_SERVER['HTTP_HOST'] . '/Medecins.php?status=' . $_status . '&title=' . $_title . '&message=' . $_message);
$response->send();
}
}
// erreur de params
} else {
$_status = 'error';
$_title = 'Erreur de paramètres!';
$_message = 'Un des champs est incorrect. Réessayez!';
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
Response::quickResponse(200, json_encode(['status' => $_status, 'title' => $_title, 'message' => $_message]));
} else {
$response = new Response();
$response->setHeader('Location', 'http://' . $_SERVER['HTTP_HOST'] . '/Medecins.php?status=' . $_status . '&title=' . $_title . '&message=' . $_message);
$response->send();
}
}
}
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());
}
