public function isReservationExists(AnnouncementReservation $reservation)
{
//echo 'SELECT * FROM '.$this->table().' WHERE ('.$this->table().'.DATE >= \'' . $reservation->getDate() . '\' AND DATE_END <= \'' . $reservation->getDateEnd() . '\' AND STATE_ID != ' . PaiementStates::CANCELED . ')';
//die;
$q = $this->dao->prepare('SELECT * FROM ' . $this->table() . ' WHERE (' . $this->table() . '.DATE >= \'' . $reservation->getDate() . '\' AND DATE_END <= \'' . $reservation->getDateEnd() . '\' AND STATE_ID != ' . PaiementStates::CANCELED . ' AND ANNOUNCEMENT_ID = ' . $reservation->getAnnouncementId() . ')');
$q->execute();
$announcementReservation = array();
while ($data = $q->fetch(PDO::FETCH_ASSOC)) {
$announcementReservation[] = new AnnouncementReservation($data);
}
return count($announcementReservation);
}
