public function getAllReservationsCount($reservation_id = null) { $c = ReservationPeer::getPeriodCriteria(strtotime($this->getStart()), strtotime($this->getStop())); $c->addAnd(ReservationPeer::ACTIVITY_ID, $this->getActivityId(), Criteria::EQUAL); if (!is_null($this->getUserId())) { $c->addAnd(ReservationPeer::USER_ID, $this->getUserId(), Criteria::EQUAL); } if (!is_null($this->getCardId())) { $c->addAnd(ReservationPeer::CARD_ID, $this->getCardId(), Criteria::EQUAL); } if (!is_null($reservation_id)) { $c->addAnd(ReservationPeer::ID, $reservation_id, Criteria::NOT_EQUAL); } $c->clearSelectColumns(); $c->addSelectColumn('SUM(' . ReservationPeer::DURATION . ')'); $stmt = ReservationPeer::doSelectStmt($c); $row = $stmt->fetch(PDO::FETCH_NUM); return $row[0]; }