public function listassignmentAction()
{
$model = new BranchMpk();
$select = $model->select();
$request = $this->getRequest();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'mpk');
$order = $request->getParam('order', 'asc');
$select->where('ghost = false');
$select->order($sort . ' ' . $order);
$request = $this->getRequest();
$page = $request->getParam('page', 1);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('mpk', 'branch_name', 'created_at', 'created_by');
}
private function checkIfMpkAvaliable($mpk_code)
{
$branch = new BranchMpk();
$select = $branch->select()->where('ghost = ?', 'false')->where('mpk ilike ?', $mpk_code);
$row = $branch->fetchRow($select);
if (is_null($row)) {
return true;
} else {
return false;
}
}
