public function getAllMessagesByDate($time)
{
include $_SERVER["DOCUMENT_ROOT"] . "/modele/bdd/connect.php";
$req = $bdd->prepare("SELECT * FROM message WHERE id_message IN " . "(SELECT id_message FROM canalMessage WHERE canalMessage.id_canal=:id_canal) AND date > :time");
$req->execute(array(":id_canal" => $this->_canal->getID(), ":time" => $time));
$messages = array();
while ($messageFetch = $req->fetch()) {
$messages[] = MessageSQL::setData($messageFetch);
}
return $messages;
}
/**
*
* @param type $canal
*/
public static function getMessageByCanal($canal)
{
include $_SERVER["DOCUMENT_ROOT"] . "/modele/bdd/connect.php";
$sql = "SELECT * FROM message WHERE id_message IN (SELECT id_message FROM canalMessage WHERE id_canal=:id)";
$req = $bdd->prepare($sql);
$req->execute(array(":id" => $canal->getID()));
$messages = array();
while ($messageFetch = $req->fetch()) {
$messages[] = MessageSQL::setData($messageFetch);
}
return $messages;
}
public function save()
{
$messageSQL = new MessageSQL($this);
$messageSQL->save();
}
public static function getUsersByCanal($user)
{
include $_SERVER["DOCUMENT_ROOT"] . "/modele/bdd/connect.php";
$sql = "SELECT * FROM user WHERE id_user IN (SELECT id_user FROM canalUser WHERE id_user=:id)";
$req = $bdd->prepare($sql);
$req->execute(array(":id" => $user->getID()));
while ($userFetch = $req->fetch()) {
$users[] = MessageSQL::setData($userFetch);
}
return $users;
}
