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