public function executeIndex(sfWebRequest $request) { $this->user = $this->getUser()->getTemposUser(); $this->forward404Unless($this->user, 'Only users can access this page.'); $this->step = sfConfig::get('app_max_messages_on_messagelist'); $this->getUser()->syncParameters($this, 'message', 'index', array('offset', 'limit', 'sort_column', 'sort_direction'), $request); if (is_null($this->sort_column)) { $this->sort_column = 'created_at'; $this->sort_direction = 'down'; } if (is_null($this->offset)) { $this->offset = 0; } if (is_null($this->limit) || $this->limit <= 0) { $this->limit = $this->step; } $c = MessagePeer::getUserCriteria($this->user->getId()); $cb = clone $c; SortCriteria::addSortCriteria($c, $this->sort_column, MessagePeer::getSortAliases(), $this->sort_direction); $c->setOffset($this->offset); if ($this->limit >= 0) { $c->setLimit($this->limit); } $this->message_list = MessagePeer::doSelect($c); $this->count = MessagePeer::doCount($cb); $this->unread_count = MessagePeer::doCountUserUnreadMessages($this->user->getId()); if ($this->offset < 0 || $this->offset >= $this->count && $this->count > 0) { $this->forward404('Invalid offset/count values.'); } }
/** * Returns the number of related Message objects. * * @param Criteria $criteria * @param boolean $distinct * @param PropelPDO $con * @return int Count of related Message objects. * @throws PropelException */ public function countMessagesRelatedByOwnerId(Criteria $criteria = null, $distinct = false, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(UserPeer::DATABASE_NAME); } else { $criteria = clone $criteria; } if ($distinct) { $criteria->setDistinct(); } $count = null; if ($this->collMessagesRelatedByOwnerId === null) { if ($this->isNew()) { $count = 0; } else { $criteria->add(MessagePeer::OWNER_ID, $this->id); $count = MessagePeer::doCount($criteria, $con); } } else { // criteria has no effect for a new object if (!$this->isNew()) { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return count of the collection. $criteria->add(MessagePeer::OWNER_ID, $this->id); if (!isset($this->lastMessageRelatedByOwnerIdCriteria) || !$this->lastMessageRelatedByOwnerIdCriteria->equals($criteria)) { $count = MessagePeer::doCount($criteria, $con); } else { $count = count($this->collMessagesRelatedByOwnerId); } } else { $count = count($this->collMessagesRelatedByOwnerId); } } return $count; }
public function countMessagesRelatedByRecipientId($criteria = null, $distinct = false, $con = null) { include_once 'lib/model/om/BaseMessagePeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } $criteria->add(MessagePeer::RECIPIENT_ID, $this->getId()); return MessagePeer::doCount($criteria, $distinct, $con); }
/** * Returns the number of related Messages. * * @param Criteria $criteria * @param boolean $distinct * @param Connection $con * @throws PropelException */ public function countMessages($criteria = null, $distinct = false, $con = null) { // include the Peer class include_once 'src/model/whiteboard/om/BaseMessagePeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } $criteria->add(MessagePeer::PRODUCTION_ID, $this->getProductionId()); return MessagePeer::doCount($criteria, $distinct, $con); }