public function executeIndex(sfWebRequest $request) { $this->step = sfConfig::get('app_max_activities_on_activitylist'); $this->getUser()->syncParameters($this, 'activity', 'index', array('offset', 'limit', 'sort_column', 'sort_direction'), $request); if (is_null($this->sort_column)) { $this->sort_column = 'name'; $this->sort_direction = 'up'; } if (is_null($this->offset)) { $this->offset = 0; } if (is_null($this->limit) || $this->limit <= 0) { $this->limit = $this->step; } $c = new Criteria(); SortCriteria::addSortCriteria($c, $this->sort_column, ActivityPeer::getSortAliases(), $this->sort_direction); $c->setOffset($this->offset); if ($this->limit >= 0) { $c->setLimit($this->limit); } $this->activity_list = ActivityPeer::doSelect($c); $this->count = ActivityPeer::doCount(new Criteria()); if ($this->offset < 0 || $this->offset >= $this->count && $this->count > 0) { $this->forward404(); } }
public function getActivities() { $c = new Criteria(); $c->addJoin(ActivityPeer::ID, ActivityHasFeaturePeer::ACTIVITY_ID); $c->add(ActivityHasFeaturePeer::FEATURE_ID, $this->getId(), Criteria::EQUAL); $c->addAscendingOrderByColumn(ActivityPeer::NAME); return ActivityPeer::doSelect($c); }
public function executeAjaxIndex(sfWebRequest $request) { $exclude_ids = $this->getUser()->getAttribute('hidden_activity', array(), 'person'); $c = new Criteria(); $c->add(ActivityPeer::ID, $exclude_ids, Criteria::NOT_IN); $c->addDescendingOrderByColumn(ActivityPeer::CREATED_AT); $c->setLimit(sfConfig::get('app_max_recent_activity', 10)); $this->activities = ActivityPeer::doSelect($c); }
public function getActivities($c = null) { if ($c == null && !is_null($this->activities)) { return $this->activities; } else { $c = ActivityPeer::getUsergroupActivityCriteria($this->getId(), $c); $c->addAscendingOrderByColumn(ActivityPeer::NAME); $result = ActivityPeer::doSelect($c); if ($c == null) { $this->activities = $result; } return $result; } }
/** * Retrieve multiple objects by pkey. * * @param array $pks List of primary keys * @param PropelPDO $con the connection to use * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function retrieveByPKs($pks, PropelPDO $con = null) { if ($con === null) { $con = Propel::getConnection(ActivityPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(ActivityPeer::DATABASE_NAME); $criteria->add(ActivityPeer::ID, $pks, Criteria::IN); $objs = ActivityPeer::doSelect($criteria, $con); } return $objs; }
public function getActiveSubscriptionsActivities() { $c = SubscriptionPeer::getActiveCriteria(); $c->addAnd(SubscriptionPeer::CARD_ID, $this->getId(), Criteria::EQUAL); $c->addJoin(SubscriptionPeer::ACTIVITY_ID, ActivityPeer::ID); $c->addGroupByColumn(ActivityPeer::ID); $c->addAscendingOrderByColumn(ActivityPeer::NAME); return ActivityPeer::doSelect($c); }