public function dadoscovenantAction() { $cdclient = $_GET["cdclient"]; $this->_helper->layout->disableLayout(); $page = $this->_request->getParam("page", 1); $limit = $this->_request->getParam("rows"); $sidx = $this->_request->getParam("sidx", 1); $sord = $this->_request->getParam("sord"); $clientcovenantModel = new ClientcovenantModel(); $clientcovenantData = $clientcovenantModel->fetchAll(); $count = count($clientcovenantData); if ($count > 0 && $limit > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $clientcovenantData = $clientcovenantModel->fetchAll($clientcovenantModel->getClientCovenantsByCdClientDados($cdclient, $sidx, $sord, $limit, $page)); $responce = new stdClass(); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i = 0; foreach ($clientcovenantData as $row) { if (isset($row->dtreference) && $row->dtreference != '0000-00-00 00:00:00') { $date = new Zend_Date($row->dtreference, 'YYYY-MM-dd HH:mm:ss'); $date = $date->toString('dd-MM-YYYY'); } else { $date = ''; } switch ($row->fgactive) { case 1: $fgstatus = 1; break; case 2: $fgstatus = 0; break; } $responce->rows[$i]['cdclient'] = $row->cdclient; $responce->rows[$i]['cell'] = array($row->cdcovenant, $row->nmcovenant, $row->idcovenantcard, $row->nmcardholder, $date, $fgstatus); $i++; } $this->view->dadoscovenant = $responce; }