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 getPatients($idMedecin) { if (!StaticRepo::checkParam($idMedecin, 'Numeric')) { return false; } $req = StaticRepo::getConnexion()->prepare('SELECT Patient.* FROM Patient,Medecin WHERE Medecin.Id = :id AND Medecin.Id = Patient.MedecinTraitant'); $req->execute(['id' => $idMedecin]); return StaticRepo::delNumeric($req->fetchAll()); }
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 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 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 static function search($nom, $prenom) { if (!StaticRepo::checkParam($prenom, 'String45') | !StaticRepo::checkParam($nom, 'String45')) { return false; } // on définit les valeurs (peuvent être nulles) $optPrenom = $prenom != 'null' && StaticRepo::checkParam($prenom, 'String45') ? '%' . $prenom . '%' : '%'; $optNom = $nom != 'null' && StaticRepo::checkParam($nom, 'String45') ? '%' . $nom . '%' : '%'; $req = StaticRepo::getConnexion()->query("SELECT Id, Civilite, Nom, Prenom, DATE_FORMAT(DateNaissance, '%d/%m/%Y') as DateNaissance, NumSecuriteSociale\n FROM Patient\n WHERE Nom LIKE '" . $optNom . "'\n AND Prenom LIKE '" . $optPrenom . "'\n ORDER BY Nom, Prenom ASC"); return StaticRepo::delNumeric($req->fetchAll()); }