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