public function searchAction()
{
$var = $this->_request->getParams();
$cdrequest = null;
$cdpacient = null;
$requestModel = new RequestModel();
$cdrequest = $this->_request->getParam("cdrequest");
$cdpacient = $this->_request->getParam("nmpacient");
$array = array();
$requestModel->getAdapter()->beginTransaction();
try {
if (isset($cdrequest) && $cdrequest != null) {
$array['cdrequest'] = $cdrequest;
} else {
$array['cdrequest'] = null;
}
if (isset($cdpacient) && $cdpacient != null) {
$array['nmpacient'] = $cdpacient;
} else {
$array['nmpacient'] = null;
}
if ($array['cdrequest'] == null && $array['nmpacient'] == null) {
$dataRequest = null;
} else {
$dataRequest = $requestModel->fetchAll($requestModel->getDataRequestSample($array['cdrequest'], $array['nmpacient']));
}
$page = $this->_request->getParam("page", 1);
$limit = $this->_request->getParam("rows");
$count = count($dataRequest);
$responce = new stdClass();
/* Manipulação de dados para a grid */
$index = 0;
foreach ($dataRequest as $row) {
if ($row->fgstatus == '1') {
$fgstatus = 'Em Aberto';
} else {
$fgstatus = 'Encerrada';
}
$date = new Zend_Date($row['dtrequest'], 'YYYY-MM-dd HH:mm:ss');
$date = $date->toString('dd-MM-YYYY');
$responce->rows[$index]['cell'] = array($row->cdrequest, $date, $fgstatus);
$index++;
}
$this->view->search = $responce;
} catch (Exception $e) {
$requestModel->getAdapter()->rollback();
echo $e->getMessage();
}
}
public function searchAction()
{
$appraisaldeliveryModel = new RequestModel();
$cdrequest = $this->_request->getParam("cdrequest");
$cdpatient = $this->_request->getParam("cdpatient");
if ($cdrequest == " ") {
$cdrequest = null;
}
$appraisaldeliveryModel->getAdapter()->beginTransaction();
try {
$dataRequest = $appraisaldeliveryModel->fetchAll($appraisaldeliveryModel->getDataRequestSample($cdrequest, $cdpatient));
$response = new stdClass();
/* Manipulação de dados para a grid */
$index = 0;
foreach ($dataRequest as $row) {
switch ($row->fgstatus) {
case 1:
$fgstatus = 'Coletada';
break;
case 2:
$fgstatus = 'Faltante';
break;
case 3:
$fgstatus = 'Em Mapa';
break;
case 4:
$fgstatus = 'Lançada';
break;
case 5:
$fgstatus = 'Conferida';
break;
case 6:
$fgstatus = 'Impressa';
break;
case 7:
$fgstatus = 'Entregue';
break;
}
$date = new Zend_Date($row['dtrequest'], 'YYYY-MM-dd HH:mm:ss');
$date = $date->toString('dd-MM-YYYY');
$dateresult = new Zend_Date($row['dtresult'], 'YYYY-MM-dd HH:mm:ss');
$dateresult = $dateresult->toString('dd-MM-YYYY');
$datecollection = new Zend_Date($row['dtcollection'], 'YYYY-MM-dd HH:mm:ss');
$datecollection = $datecollection->toString('dd-MM-YYYY');
// $response->rows[$index]['id'] = $row->cdrequest;
$response->rows[$index]['cell'] = array($row['cdrequest'], $row['cdexamination'], $row['nmexamination'], $row['idmaterial'], $datecollection, $dateresult, $fgstatus);
$index++;
}
$response = json_encode($response);
print_r($response);
return $response;
} catch (Exception $e) {
$appraisaldeliveryModel->getAdapter()->rollback();
echo $e->getMessage();
}
}
