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