projet-php/repositories/repos/MedecinRepo.php

95 lines
3.0 KiB
PHP
Raw Permalink Normal View History

<?php
/**
* Created by PhpStorm.
* User: seekdasky
* Date: 02/12/15
* Time: 12:36
*/
class MedecinRepo
{
public static function getById($id){
2015-12-10 09:56:06 +00:00
if(!StaticRepo::checkParam($id, 'Numeric')) return false;
2015-12-10 09:56:06 +00:00
$req = StaticRepo::getConnexion()->prepare('SELECT * FROM Medecin WHERE Id = :id');
$req->execute(['id' => $id]);
return StaticRepo::delNumeric( $req->fetch(), true );
}
public static function add($civilite,$prenom,$nom){
2015-12-10 09:56:06 +00:00
2016-01-03 17:35:41 +00:00
if(!StaticRepo::checkParam($civilite,'Civilite') | !StaticRepo::checkParam($prenom,'String45') | !StaticRepo::checkParam($nom,'String45')) return false;
2015-12-10 09:56:06 +00:00
$req = StaticRepo::getConnexion()->prepare('INSERT INTO Medecin VALUES (DEFAULT,:civilite,:prenom,:nom)');
$result = $req->execute(['civilite' => $civilite,
'nom' => $nom,
'prenom' => $prenom
]);
2015-12-10 10:46:29 +00:00
//PDO renvoie un ID sous forme de char, on transtype
$id = StaticRepo::getConnexion()->lastInsertId();
settype($id, 'integer');
if($result) return $id;
else return false;
}
public static function delete($idMedecin){
2015-12-10 10:46:29 +00:00
if(!StaticRepo::checkParam($idMedecin,'Numeric')) return false;
2015-12-10 10:46:29 +00:00
$req = StaticRepo::getConnexion()->prepare('DELETE FROM Medecin WHERE Id = :id');
return $req->execute(['id' => $idMedecin]);
}
2015-12-17 09:58:06 +00:00
public static function search($nom, $prenom){
2015-12-10 10:46:29 +00:00
2016-01-03 17:35:41 +00:00
if( !StaticRepo::checkParam($prenom,'String45') | !StaticRepo::checkParam($nom,'String45') ) return false;
2015-12-10 10:46:29 +00:00
2015-12-17 09:58:06 +00:00
// on définit les valeurs (peuvent être nulles)
2015-12-22 18:35:35 +00:00
$optPrenom = ( $prenom != 'null' && StaticRepo::checkParam($prenom,'String45') ) ? '%'.$prenom.'%' : '%';
$optNom = ( $nom != 'null' && StaticRepo::checkParam($nom, 'String45') ) ? '%'.$nom.'%' : '%';
2015-12-17 09:58:06 +00:00
$req = StaticRepo::getConnexion()->query("SELECT Id, Civilite, Prenom, Nom
2015-12-17 09:58:06 +00:00
FROM Medecin
WHERE Nom LIKE '".$optNom."'
AND Prenom LIKE '".$optPrenom."'
2015-12-22 18:35:35 +00:00
ORDER BY Nom, Prenom ASC");
2015-12-17 09:58:06 +00:00
return StaticRepo::delNumeric( $req->fetchAll() );
}
public static function getPatients($idMedecin){
if(!StaticRepo::checkParam($idMedecin,'Numeric')) return false;
2015-12-10 09:56:06 +00:00
$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 static function getAll(){
$req = StaticRepo::getConnexion()->query('SELECT * FROM Medecin ORDER BY nom, prenom ASC');
return StaticRepo::delNumeric( $req->fetchAll() );
}
2016-01-03 16:15:44 +00:00
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 ]);
}
}