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