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