public function listgroupsAction() { $options = $this->getFrontController()->getParam('bootstrap')->getApplication()->getOptions(); $model = new BranchGroup(); $select = $model->select(); $request = $this->getRequest(); $page = $request->getParam('page', 1); $sort = $request->getParam('sort', 'branch_group_name'); $order = $request->getParam('order', 'asc'); $select->order($sort . ' ' . $order); $paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select)); $paginator->setCurrentPageNumber($page); $this->view->paginator = $paginator; $this->view->headers = array('branch_group_name', 'description'); }
public function getGroupsForBranch($id) { $branchgroup = new BranchGroup(); $select = $branchgroup->select()->from('branch_group')->join('branch_branch_group', 'branch_group.id= branch_branch_group.id_branch_group', array())->where('branch_branch_group.id_branch = ?', $id)->where('branch_group.ghost = false and branch_branch_group.ghost = false')->order(array('branch_group.created_at', 'branch_group.id'))->setIntegrityCheck(false); return $select; }