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