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 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 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 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 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 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());
}
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 __construct()
{
$this->connexion = StaticRepo::getConnexion();
}
public static function getAll()
{
$req = StaticRepo::getConnexion()->query('SELECT * FROM Patient ORDER BY nom, prenom ASC');
return StaticRepo::delNumeric($req->fetchAll());
}
public function testGetConnexion()
{
$this->assertTrue(StaticRepo::getConnexion() instanceof PDO);
}
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]);
}
