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