public function executeIndex(sfWebRequest $request) { if ($request->hasParameter('projects_id')) { $this->forward404Unless($this->projects = Doctrine_Core::getTable('Projects')->createQuery()->addWhere('id=?', $request->getParameter('projects_id'))->fetchOne(), sprintf('Object projects does not exist (%s).', $request->getParameter('projects_id'))); $this->checkProjectsAccess($this->projects); $this->checkDiscussionsAccess('view', false, $this->projects); } else { $this->checkDiscussionsAccess('view'); } if (!$this->getUser()->hasAttribute('discussions_filter' . $this->get_pid($request))) { $this->getUser()->setAttribute('discussions_filter' . $this->get_pid($request), Discussions::getDefaultFilter($request, $this->getUser())); } $this->filter_by = $this->getUser()->getAttribute('discussions_filter' . $this->get_pid($request)); if ($fb = $request->getParameter('filter_by')) { $this->filter_by[key($fb)] = current($fb); $this->getUser()->setAttribute('discussions_filter' . $this->get_pid($request), $this->filter_by); $this->redirect('discussions/index' . $this->add_pid($request)); } if ($request->hasParameter('remove_filter')) { unset($this->filter_by[$request->getParameter('remove_filter')]); $this->getUser()->setAttribute('discussions_filter' . $this->get_pid($request), $this->filter_by); $this->redirect('discussions/index' . $this->add_pid($request)); } if ($set_order = $request->getParameter('set_order')) { $this->getUser()->setAttribute('discussions_listing_order' . $this->get_pid($request), $set_order); $this->redirect('discussions/index' . $this->add_pid($request)); } app::setPageTitle('Discussions', $this->getResponse()); }
public function executeIndex(sfWebRequest $request) { $this->forward404Unless($this->projects = Doctrine_Core::getTable('Projects')->createQuery()->addWhere('id=?', $request->getParameter('projects_id'))->fetchOne(), sprintf('Object projects does not exist (%s).', $request->getParameter('projects_id'))); $this->forward404Unless($this->discussions = Doctrine_Core::getTable('Discussions')->createQuery()->addWhere('id=?', $request->getParameter('discussions_id'))->addWhere('projects_id=?', $request->getParameter('projects_id'))->fetchOne(), sprintf('Object discussions does not exist (%s).', $request->getParameter('discussions_id'))); $this->checkProjectsAccess($this->projects); $this->checkDiscussionsAccess('view', $this->discussions, $this->projects); if (!$this->getUser()->hasAttribute('discussions_filter' . $request->getParameter('projects_id'))) { $this->getUser()->setAttribute('discussions_filter' . $request->getParameter('projects_id'), Discussions::getDefaultFilter($request, $this->getUser())); } $this->discussions_comments = Doctrine_Core::getTable('DiscussionsComments')->createQuery('dc')->leftJoin('dc.Users u')->addWhere('discussions_id=?', $request->getParameter('discussions_id'))->orderBy('created_at desc')->fetchArray(); $this->more_actions = $this->getMoreActions($request); app::setPageTitle(t::__('Discussion') . ' | ' . $this->discussions->getName(), $this->getResponse()); }