/** * @param $start * @param $end * @return array */ public function fetchBetween($start, $end) { $query = $this->getAdapter()->select()->from(["e" => $this->getTableName()], ["*", new \Zend_Db_Expr("UNIX_TIMESTAMP(start)*1000 AS start"), new \Zend_Db_Expr("UNIX_TIMESTAMP(start)*1000 AS end")])->joinLeft(["g" => $this->_dbprefix . "events_guests"], "g.eventid=e.id AND g.userid=" . $this->getAdapter()->quote($_SESSION['user']->userid), ["guestid", "status"])->joinLeft(["u" => $this->_dbprefix . "users"], "e.userid = u.userid", ["username", "name"])->joinLeft(["pi" => $this->_dbprefix . "gallery_images"], "pi.id = u.profileImage AND e.type = 'birthday'", "filename AS pimg")->where("e.start BETWEEN " . $this->getAdapter()->quote($start) . " AND " . $this->getAdapter()->quote($end))->where("e.type = 'event' OR (e.type = 'birthday' AND e.userid IN (" . FriendQuery::getFriendListQuery("=2") . "))")->where("(g.guestid IS NULL AND e.type = 'birthday') OR (g.guestid IS NOT NULL AND e.type = 'event')"); return $this->getAdapter()->fetchAll($query); }
/** * */ public function __construct() { parent::__construct(); $this->friendslistQuery = FriendQuery::getFriendListQuery(); $this->eventslistQuery = EventsQuery::getEventsListQuery(); }