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); }