public function listAction() { $model = new WsClientMpk(); $select = $model->select(); $request = $this->getRequest(); $page = $request->getParam('page', 1); $sort = $request->getParam('sort', 'mpk_code'); $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_code', 'ws_client_id'); }
private function checkIfAvaliable($mpk_code) { $branch = new WsClientMpk(); $select = $branch->select()->where('ghost = ?', 'false')->where('mpk_code ilike ?', $mpk_code); $row = $branch->fetchRow($select); if (is_null($row)) { return true; } else { return false; } }