public function covenantbillingdataAction() { // FUNÇÃO QUE REALIZA A PESQUISA / FILTROS $cdcovenant = $this->_request->getParam('cdcovenant'); $cdcompanyparent = $this->_request->getParam('cdcompanyparent'); $dtstart = $this->_request->getParam('dtstart'); $dtend = $this->_request->getParam('dtend'); if (isset($dtstart) && $dtstart != '') { $dtstart = new Zend_Date($dtstart, 'dd-MM-YYYY HH:mm:ss'); $dtstart = $dtstart->toString('YYYY-MM-dd HH:mm:ss'); } if (isset($dtend) && $dtend != '') { $dtend = new Zend_Date($dtend, 'dd-MM-YYYY HH:mm:ss'); $dtend = $dtend->toString('YYYY-MM-dd HH:mm:ss'); } $responce = 0; $convenantModel = new CovenantModel(); $clientModel = new ClientModel(); $requestModel = new RequestModel(); $covenantbillingData = $requestModel->fetchAll($requestModel->getRequestsUnbilled($cdcovenant, $cdcompanyparent, $dtstart, $dtend)); $responce = new stdClass(); if (count($covenantbillingData) > 0) { $i = 0; foreach ($covenantbillingData as $rows) { $nmclient = ''; $cdclient = ''; $nmconvenant = ''; $cdcovenant = ''; $rows['dtrequest'] = new Zend_Date($rows['dtrequest'], 'YYYY-MM-dd HH:mm:ss'); $rows['dtrequest'] = $rows['dtrequest']->toString('dd/MM/yyyy'); if ($rows['cdclient'] != null) { $clientData = $clientModel->fetchRow('cdclient=' . $rows['cdclient']); $nmclient = $clientData['nmclient']; $cdclient = $clientData['cdclient']; } if ($rows['cdcovenant'] != null) { $convenantData = $convenantModel->fetchRow('cdcovenant=' . $rows['cdcovenant']); $nmconvenant = $convenantData->nmcovenant; $cdcovenant = $convenantData['cdcovenant']; } $responce->rows[$i]['cdrequest'] = $rows['cdrequest']; $responce->rows[$i]['cell'] = array($rows['cdrequest'], $rows['dtrequest'], $nmclient, $nmconvenant, $rows['nrguide'], $cdclient, $cdcovenant); $i++; } $this->view->covenantbillingdata = $responce; } else { $this->view->covenantbillingdata = 'vazio'; } }