public function executeIndex(sfWebRequest $request) { $dpu = new sfDoctrinePagerUtil('Client', 10); $sort = $dpu->getSort($request); $clients = Doctrine_Query::create()->from('Client c, c.User u')->orderBy('c.' . $sort); $fields = array('id' => array('Client')); $pagerOptions = array('query' => $clients, 'request' => $request, 'fields' => $fields); $this->pager = $dpu->getPager($pagerOptions); }
public function executeIndex(sfWebRequest $request) { $dpu = new sfDoctrinePagerUtil('Staff', 10); $sort = $dpu->getSort($request); $staff = Doctrine_Query::create()->from('Staff s, s.User u')->orderBy('s.' . $sort); $fields = array('id' => array('Employee', 'staff', null), 'title' => array('Title', 'staff', 'getTitle')); $pagerOptions = array('query' => $staff, 'request' => $request, 'fields' => $fields); $this->pager = $dpu->getPager($pagerOptions); }