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