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