public function executeViewProfile() { $username = $this->getRequestParameter('username'); $this->user = sfGuardUserPeer::retrieveByUsername($username); $c = new Criteria(); $c->add(SnippetPeer::USER_ID, $this->user->getId()); $c->add(SnippetPeer::DRAFT, false); $this->snippet_count = SnippetPeer::doCount($c); $this->pager = new sfPropelPager('Snippet', sfConfig::get('app_pager', 10)); $this->pager->setCriteria($c); $this->pager->setPage($this->getRequestParameter('page', 1)); $this->pager->init(); }
public static function countUserSnippets($user_id) { $c = new Criteria(); $c->add(SnippetPeer::USER_ID, $user_id); return SnippetPeer::doCount($c); }