public function executeList(sfWebRequest $request) { $url = 'talk/list?page={%page_number}'; $query = Doctrine::getTable('Talk')->getTagQuery(); $this->curSection = Doctrine::getTable('TalkSection')->find(array($request->getParameter('section'))); if ($this->curSection) { $this->curSection->modifyQuery($query); $url .= '§ion=' . $this->curSection->getId(); if ($this->curSection->getNode()->isLeaf() && !$this->getUser()->isAnonymous()) { $this->form = new TalkForm(); $this->form->setDefault('talk_section_id', $this->curSection->getId()); } } $this->pager = htPagerLayout::create($query, $url, $request->getParameter("page", 1)); }
public function executeList(sfWebRequest $request) { $this->pager = htPagerLayout::create(Doctrine::getTable('Inbox')->getInboxQuery($this->getUser()->getProfile()), 'inbox/list?page={%page_number}', $request->getParameter('page', 1)); $this->csrf = CSRF::getToken(); }
public function executeListPaid(sfWebRequest $request) { $this->pager = htPagerLayout::create(Doctrine::getTable('Location')->getVisibleLocationsQuery($this->getUser())->leftJoin('l.CreatedBy u')->leftJoin('u.User')->leftJoin('l.CommentLocation')->leftJoin('l.VoteLocation')->leftJoin('l.Profit p')->leftJoin('p.ProfitDetail pd')->addWhere('l.is_free = 0'), '@location_free?page={%page_number}', $request->getParameter('page', 1)); }
public function executeList(sfWebRequest $request) { $this->pager = htPagerLayout::create(Doctrine::getTable('sfGuardUserProfile')->createQuery('p')->leftJoin('p.User ')->leftJoin('p.VoteProfile')->orderBy('p.created_at ASC'), '@people?page={%page_number}', $request->getParameter('page', 1)); $this->csrf = CSRF::getToken(); $this->friends = !$this->getUser()->isAnonymous() ? $this->getUser()->getProfile()->getFriends() : null; }
private function getLocationPager(sfWebRequest $request, sfDoctrineRecord $part, $partUrl) { return htPagerLayout::create(Doctrine::getTable('Location')->getVisibleLocationsQuery($this->getUser())->leftJoin('l.Address a')->leftJoin('a.' . $part->getTable()->getComponentName() . ' part')->leftJoin('l.CreatedBy p')->leftJoin('l.VoteLocation v')->leftJoin('l.CommentLocation c')->leftJoin('l.Profit pr')->leftJoin('pr.ProfitDetail pd')->leftJoin('pd.Fish')->andWhere('part.id = ?', $part->getId()), 'address/' . $partUrl . '?id=' . $part->getId() . '&page={%page_number}', $request->getParameter('page', 1)); }
public function executeArchive(sfWebRequest $request) { $this->pager = htPagerLayout::create(Doctrine::getTable('FishEvent')->createQuery('f')->leftJoin('f.Location')->leftJoin('f.VoteFishEvent v')->leftJoin('f.CommentFishEvent c')->leftJoin('f.CreatedBy p')->leftJoin('p.User')->where('f.date < ?', array(date('Y-m-d', time())))->orderBy('f.date ASC'), 'event/list?page={%page_number}', $request->getParameter('page', 1)); }
private function getList($request, $url, $query) { $this->pager = htPagerLayout::create($query, $url, $request->getParameter('page', 1)); }