public function modalsamplesaveAction()
{
$var = $this->_request->getParams();
$requestModel = new RequestModel();
$cdrequest = $this->_request->getParam("code");
$array = array();
$requestModel->getAdapter()->beginTransaction();
try {
if (isset($cdrequest) && $cdrequest != null) {
$array['code'] = $cdrequest;
} else {
$array['code'] = null;
}
$datamodalGrid = $requestModel->fetchAll($requestModel->getDataRequestGridSample($array['code']));
$page = $this->_request->getParam("page", 1);
$limit = $this->_request->getParam("rows");
$count = count($datamodalGrid);
$responce = new stdClass();
/* Manipulação de dados para a grid */
$index = 0;
foreach ($datamodalGrid as $row) {
$date = new Zend_Date($row['dtcollection'], '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');
// $responce->rows[$index]['id'] = $row->request;
$responce->rows[$index]['cell'] = array($row->dtcollection, $row->dtresult, $row->fgstatus, $row->nmbarcodesample, $row->idmaterial, $row->nmexamination);
}
$this->view->modalsamplesave = $responce;
// print_r($responce);
} catch (Exception $e) {
$requestModel->getAdapter()->rollback();
echo $e->getMessage();
}
}
public function savepartialtreatmentAction()
{
$values = $this->_request->getParams();
// Converte Data/Hora para formato do BD
$values['dtrequest'] = new Zend_Date($values['dtrequest'], 'dd-MM-YYYY HH:mm:ss');
$values['dtrequest'] = $values['dtrequest']->toString('YYYY-MM-dd HH:mm:ss');
// Salva como Requisição inativa
// (A requisição só estará ativa após salvar os "Exames" e "Medicamentos" clicando no botão "Salvar" da window)
$values['fgactive'] = 2;
$array = array();
$requestModel = new RequestModel();
$columns = $requestModel->info(Zend_Db_Table_Abstract::COLS);
$requestModel->getAdapter()->beginTransaction();
try {
foreach ($values as $id => $value) {
if (isset($value) && $value != '' && $value != '0' && in_array($id, $columns)) {
$array[$id] = addslashes($value);
} else {
if (in_array($id, $columns)) {
$array[$id] = null;
}
}
}
if (empty($array)) {
throw new Exception('Dados Incorretos. Confira seus dados e Tente Novamente.');
} else {
$requestModel->insert($array);
$lastcdrequest = $requestModel->getAdapter()->lastInsertId();
$requestModel->getAdapter()->commit();
$this->view->savepartialtreatment = array($lastcdrequest);
}
} catch (Exception $e) {
$this->_model->getAdapter()->rollBack();
}
}
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();
}
}
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();
}
}
public function searchAction()
{
//funcao para realizar busca ao BD
$var = $this->_request->getParams();
//Passando os parâmetros para vetores... através do método Request
$patientsituationModel = new RequestModel();
// <- Instanciando a classe Request
$cdpatient = $this->_request->getParam("cdpacient");
// passando o valor dos parâmetros para as variaveis
$requisicion = $this->_request->getParam("requisicion");
$cdagemin = $this->_request->getParam("nrminage");
$cdagemax = $this->_request->getParam("nrmaxage");
$fgvip = $this->_request->getParam("vip");
$maladireta = $this->_request->getParam("maladireta");
$amostra = $this->_request->getParam("amostra");
$urgente = $this->_request->getParam("urgente");
$convenio = $this->_request->getParam("convenio");
$historicexamination = $this->_request->getParam("historicexamination");
$cdclientrequest = $this->_request->getParam("cdclientrequest");
$cdexamination = $this->_request->getParam("cdexamination");
////O metodo FetchAll, faz a consulta ao banco de dados(RequestModel) buscando todos os valores da classe instanciada
// print_r($_POST);die;
//O metodo beginTransaction inicia uma transaçao com o banco de dados
$array = array();
$patientsituationModel->getAdapter()->beginTransaction();
try {
if (isset($cdpatient) && $cdpatient != '') {
$array['cdpacient'] = $cdpatient;
} else {
$array['cdpacient'] = '';
}
if (isset($requisicion) && $requisicion != '') {
$array['requisicion'] = $requisicion;
} else {
$array['requisicion'] = '';
}
if (isset($amostra) && $amostra != '') {
$array['amostra'] = $amostra;
} else {
$array['amostra'] = '';
}
if (isset($urgente) && $urgente != '') {
$array['urgente'] = $urgente;
} else {
$array['urgente'] = '';
}
if (isset($fgvip) && $fgvip != '') {
$array['vip'] = $fgvip;
} else {
$array['vip'] = '';
}
if (isset($maladireta) && $maladireta != '') {
$array['maladireta'] = $maladireta;
} else {
$array['maladireta'] = '';
}
if (isset($cdagemax) && $cdagemax != '') {
$array['nrmaxage'] = $cdagemax;
} else {
$array['nrmaxage'] = '';
}
if (isset($cdagemin) && $cdagemin != '') {
$array['nrminage'] = $cdagemin;
} else {
$array['nrminage'] = '';
}
if (isset($convenio) && $convenio != '') {
$array['convenio'] = $convenio;
} else {
$array['convenio'] = '';
}
if (isset($historicexamination) && $historicexamination != '') {
$array['historicexamination'] = $historicexamination;
} else {
$array['historicexamination'] = '';
}
if (isset($cdclientrequest) && $cdclientrequest != '') {
$array['cdclientrequest'] = $cdclientrequest;
} else {
$array['cdclientrequest'] = '';
}
if (isset($cdexamination) && $cdexamination != '') {
$array['cdexamination'] = $cdexamination;
} else {
$array['cdexamination'] = '';
}
/*$dadospatient = $patientsituationModel->fetchAll($patientsituationModel->getPatientSituationCdRequest($array['cdpacient'], $array['requisicion'],
$array['amostra'], $array['vip'], $array['maladireta'], $array['urgente'], $array['convenio'], $array['historicexamination']));
$dadosnmrequest = $patientsituationModel->fetchAll($patientsituationModel->getPatientSituationNmRequest($array['cdclientrequest']));*/
$dadosnmexamination = $patientsituationModel->fetchAll($patientsituationModel->getNmexaminationTotal($array['cdexamination']));
print_r($dadosnmexamination);
die;
} catch (Exception $e) {
/* O método rollBack()faz o oposto: ele descarta as alterações feitas durante sua transação. As mudanças são efetivamente desfeitas, e o estado dos dados retorna a como
ele era antes de você começar sua transação. Entretanto, descartar sua transação não tem efeito sobre mudanças feitas por outras transações rodando concorrentemente. */
$patientsituationModel->getAdapter()->rollback();
echo $e->getMessage();
}
/* $index = 0;
foreach ($dados as $l) {
$responce->rows[$index]['cdexamination'] = $row->cdexamination;
$responce->rows[$index]['cell'] = array(
$row->cdseqexamination,
$row->nmsynonymous,
$row->cdexamination,
$row->nmexamination
//$row->cdsupply
//$row->nmsupply
//$row->dtcollect
//$row->dtresult
/*foreach($dados as $linha){
echo " {
nmclient:".$linha['nmclient'].",
idade:".$linha['age'].",
cdclientrequest:".$linha['cdclientrequest'].",
cdexamination:".$linha['cdexamination'].",
cdcovenante:".$linha['cdcovenant'].",
vip:".$linha['vip'].",
}";
}
//enviar para index o resultado da consulta*/
}
public function searchAction()
{
$var = $this->_request->getParams();
// var_dump($var); die;
//PESQUISA POR PACIENTE
$cdpatient = null;
$nrsample = null;
$cdrequest = null;
$sector = null;
$startdate = null;
$enddate = null;
//PESQUISA POR MAPA
$sector2 = null;
$cdmap = null;
$homepage = null;
$lastpage = null;
$dtfirstmaps = null;
$dtendmaps = null;
$page = $this->_request->getParam("page", 1);
$limit = $this->_request->getParam("rows");
$sidx = $this->_request->getParam("sidx", 1);
$sord = $this->_request->getParam("sord");
//Pesquisa por Paciente
$requestModel = new RequestModel();
// <- Instanciando a classe Request
$cdpatient = $this->_request->getParam("cdpatient");
// passando o valor dos parâmetros para as variaveis
$nrsample = $this->_request->getParam("nrsample");
$cdrequest = $this->_request->getParam("cdrequest");
$sector = $this->_request->getParam("sector");
if ($sector == 'Nenhuma opção selecionada') {
$sector = null;
}
$startdate = $this->_request->getParam("startdate");
$enddate = $this->_request->getParam("enddate");
//PESQUISA POR MAPA
$sector2 = $this->_request->getParam("sector2");
if ($sector2 == 'Nenhuma opção selecionada') {
$sector2 = null;
}
$cdmap = $this->_request->getParam("cdmap");
$homepage = $this->_request->getParam("homepage");
$lastpage = $this->_request->getParam("lastpage");
$dtfirstmaps = $this->_request->getParam("dtfirstmaps");
$dtendmaps = $this->_request->getParam("dtendmaps");
$array = array();
$requestModel->getAdapter()->beginTransaction();
try {
//PESQUISA POR PACIENTE
if (isset($cdpatient) && $cdpatient != null) {
$array['cdpatient'] = $cdpatient;
} else {
$array['cdpatient'] = null;
}
if (isset($cdrequest) && $cdrequest != null) {
$array['cdrequest'] = $cdrequest;
} else {
$array['cdrequest'] = null;
}
if (isset($nrsample) && $nrsample != null) {
$array['nrsample'] = $nrsample;
} else {
$array['nrsample'] = null;
}
if (isset($sector) && $sector != null) {
$array['sector'] = $sector;
} else {
$array['sector'] = null;
}
if (isset($startdate) && $startdate != null) {
$startdate = new Zend_Date($startdate, 'YYYY-MM-dd HH:mm:ss');
$array['startdate'] = $startdate->toString('YYYY-MM-dd HH:mm:ss');
} else {
$array['startdate'] = null;
}
if (isset($enddate) && $enddate != null) {
$enddate = new Zend_Date($enddate, 'YYYY-MM-dd HH:mm:ss');
$array['enddate'] = $enddate->toString('YYYY-MM-dd HH:mm:ss');
} else {
$array['enddate'] = null;
}
//PESQUISA POR MAPA DE TRABALHO
if (isset($sector2) && $sector2 != null) {
$array['sector2'] = $sector2;
} else {
$array['sector2'] = null;
}
if (isset($cdmap) && $cdmap != null) {
$array['cdmap'] = $cdmap;
} else {
$array['cdmap'] = null;
}
if (isset($homepage) && $homepage != null) {
$array['homepage'] = $homepage;
} else {
$array['homepage'] = null;
}
if (isset($lastpage) && $lastpage != null) {
$array['lastpage'] = $lastpage;
} else {
$array['lastpage'] = null;
}
if (isset($dtfirstmaps) && $dtfirstmaps != null) {
$dtfirstmaps = new Zend_Date($dtfirstmaps, 'YYYY-MM-dd HH:mm:ss');
$array['dtfirstmaps'] = $dtfirstmaps->toString('YYYY-MM-dd HH:mm:ss');
} else {
$array['dtfirstmaps'] = null;
}
if (isset($dtendmaps) && $dtendmaps != null) {
$dtendmaps = new Zend_Date($dtendmaps, 'YYYY-MM-dd HH:mm:ss');
$array['dtendmaps'] = $dtendmaps->toString('YYYY-MM-dd HH:mm:ss');
} else {
$array['dtendmaps'] = null;
}
// $array['cdpatient'], $array['cdrequest'], $array['nrsample'], $array['sector'], $array['startdate'], $array['enddate'], $array['sector2'], $array['cdplug'], $array['homepage'], $array['lastpage'], $array['dtfirstmaps'], $array['dtendmaps']
if ($array['cdpatient'] == null && $array['cdrequest'] == null && $array['nrsample'] == null && $array['sector'] == null && $array['startdate'] == null && $array['enddate'] == null && $array['sector2'] == null && $array['cdmap'] == null && $array['homepage'] == null && $array['lastpage'] == null && $array['dtfirstmaps'] == null && $array['dtendmaps'] == null) {
$dados = null;
$count = count($dados);
} else {
$dados = $requestModel->fetchAll($requestModel->getRequestsData($array, array(3)));
$count = count($dados);
$array['rows'] = $this->_request->getParam('rows');
$array['page'] = $this->_request->getParam('page');
$array['sidx'] = $this->_request->getParam('sidx');
$array['sord'] = $this->_request->getParam('sord');
$dados = $requestModel->fetchAll($requestModel->getRequestsData($array, array(3)));
}
if ($count > 0 && $limit > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$response = new stdClass();
$response->page = $page;
$response->total = $total_pages;
$response->records = $count;
$index = 0;
foreach ($dados as $row) {
switch ($row->fgstatus) {
case '1':
$fgcollection = "Coletado";
break;
case '2':
$fgcollection = "Faltante";
break;
case '3':
$fgcollection = "Em Mapa";
break;
case '4':
$fgcollection = "Lançada";
break;
case '5':
$fgcollection = "Conferida";
break;
}
$response->rows[$index]['cell'] = array($row['nmbarcodesample'], $fgcollection, $row['nmexamination'], $row['nmmaterial'], $row['nmclient'], $row['nmdepartment'], $row['cdrequest'], $row['cddepartment']);
$index++;
}
$this->view->dados = $response;
} catch (Exception $e) {
$requestModel->getAdapter()->rollback();
echo $e->getMessage();
}
}
