public function searchAction()
{
$var = $this->_request->getParams();
$controlbillingModel = new RequestModel();
// <- Instanciando a classe Request
$cdcovenant = $this->_request->getParam("cdcovenant");
$nmcolectionplace = $this->_request->getParam("nmcolectionplace");
$nmdepartament = $this->_request->getParam("nmdepartament");
$fgstatus = $this->_request->getParam("fgstatus");
$nmpacient = $this->_request->getParam("nmpacient");
$responsible = $this->_request->getParam("responsible");
$dtbegindate = $this->_request->getParam("dtbegindate");
$dtenddate = $this->_request->getParam("dtenddate");
$timebeginhour = $this->_request->getParam("timebeginhour");
$timeendhour = $this->_request->getParam("timeendhour");
$nrlot = $this->_request->getParam("nrlot");
$dtmaturity = $this->_request->getParam("dtmaturity");
$array = array();
$controlbillingModel->getAdapter()->beginTransaction();
try {
if (isset($cdcovenant) && $cdcovenant != '') {
$array['cdcovenant'] = $cdcovenant;
} else {
$array['cdcovenant'] = '';
}
if (isset($nmcolectionplace) && $nmcolectionplace != '') {
$array['nmcolectionplace'] = $nmcolectionplace;
} else {
$array['nmcolectionplace'] = '';
}
if (isset($nmdepartament) && $nmdepartament != '') {
$array['nmdepartament'] = $nmdepartament;
} else {
$array['nmdepartament'] = '';
}
if (isset($fgstatus) && $fgstatus != '') {
$array['fgstatus'] = $fgstatus;
} else {
$array['fgstatus'] = '';
}
if (isset($nmpacient) && $nmpacient != '') {
$array['nmpacient'] = $nmpacient;
} else {
$array['nmpacient'] = '';
}
if (isset($responsible) && $responsible != '') {
$array['responsible'] = $responsible;
} else {
$array['responsible'] = '';
}
if (isset($dtbegindate) && $dtbegindate != '') {
$array['dtbegindate'] = $dtbegindate;
} else {
$array['dtbegindate'] = '';
}
if (isset($dtenddate) && $dtenddate != '') {
$array['dtenddate'] = $dtenddate;
} else {
$array['dtenddate'] = '';
}
if (isset($timebeginhour) && $timebeginhour != '') {
$array['timebeginhour'] = $timebeginhour;
} else {
$array['timebeginhour'] = '';
}
if (isset($timeendhour) && $timeendhour != '') {
$array['timeendhour'] = $timeendhour;
} else {
$array['timeendhour'] = '';
}
if (isset($nrlot) && $nrlot != '') {
$array['nrlot'] = $nrlot;
} else {
$array['nrlot'] = '';
}
if (isset($dtmaturity) && $dtmaturity != '') {
$array['dtmaturity'] = $dtmaturity;
} else {
$array['dtmaturity'] = '';
}
$dados = $controlbillingModel->fetchAll($controlbillingModel->getControlbillingRequest($array['cdcovenant'], $array['dtbegindate'], $array['dtenddate'], $array['timebeginhour'], $array['timeendhour']));
print_r($dados);
$dadoscontrol = $controlbillingModel->fetchAll($controlbillingModel->getBillingdadosRequest($array['nmpacient']));
} catch (Exception $e) {
$controlbillingModel->getAdapter()->rollback();
echo $e->getMessage();
}
}