public function __construct() { parent::__construct(); $covenantModel = new CovenantModel(); $covenantData = $covenantModel->getAllCovenant(); $examinationModel = new ExaminationModel(); $examinationData = $examinationModel->fetchAll(); $this->_cdexamination = new Zend_Form_Element_Select('cdexamination'); $this->_cdexamination->setAttrib("id", "pricing_cdexamination"); $this->_cdexamination->setLabel("Exame"); $this->_cdexamination->setDecorators($this->_decoratorsDefault); $this->_cdexamination->setRequired(false); $this->_cdexamination->setRegisterInArrayValidator(false); $this->_cdexamination->addMultiOption("", 'Selecione um convênio'); $this->_nrdeadline = new Zend_Form_Element_Text('nrdeadline'); $this->_nrdeadline->setAttrib("id", "pricing_nrdeadline"); $this->_nrdeadline->setAttrib("size", "15"); $this->_nrdeadline->setLabel("Prazo Novo Exame (Mês)"); $this->_nrdeadline->setDecorators($this->_decoratorsDefault); $this->_nrdeadline->setRequired(false); $this->_cdcovenant = new Zend_Form_Element_Select('cdcovenant'); $this->_cdcovenant->setAttrib("id", "pricing_cdcovenant"); $this->_cdcovenant->setLabel("Convênio"); $this->_cdcovenant->setDecorators($this->_decoratorsDefault); $this->_cdcovenant->setRequired(false); $this->_cdcovenant->setRegisterInArrayValidator(false); $this->_cdcovenant->addMultiOption("Selecione", '000 - Selecione'); foreach ($covenantData as $covenant) { $this->_cdcovenant->addMultiOption($covenant->cdcovenant, $covenant->idcovenant . ' - ' . $covenant->nmcovenant); } $this->_vlexamination = new Zend_Form_Element_Text('vlexamination'); $this->_vlexamination->setAttrib("id", "pricing_vlexamination"); $this->_vlexamination->setAttrib("maxlength", "22"); $this->_vlexamination->setAttrib("size", "10"); $this->_vlexamination->setLabel("Valor"); $this->_vlexamination->setDecorators($this->_decoratorsDefault); $this->_vlexamination->setRequired(false); $this->_vlch = new Zend_Form_Element_Hidden('vlch'); $this->_vlch->setAttrib("id", "pricing_vlch"); $this->_fgbasevalexamination = new Zend_Form_Element_Select('fgbasevalexamination'); $this->_fgbasevalexamination->setAttrib("id", "pricing_basevalexamination"); $this->_fgbasevalexamination->setLabel("Un. Valor"); $this->_fgbasevalexamination->addMultiOptions(array("1" => "CH", "2" => "R\$")); $this->_fgbasevalexamination->setDecorators($this->_decoratorsDefault); $this->_fgbasevalexamination->setRequired(false); $this->_fgauthrequired = new Zend_Form_Element_Checkbox('fgauthrequired'); $this->_fgauthrequired->setAttrib("id", "pricing_fgauthrequired"); $this->_fgauthrequired->setAttrib("value", "1"); $this->_fgauthrequired->setLabel("Solic. Autorização"); $this->_fgauthrequired->setDecorators($this->_decoratorsDefault); $this->_submitservice = new Zend_Form_Element_Button('submitservice'); $this->_submitservice->setLabel("Adicionar"); $this->_submitservice->setAttrib("id", "pricing_submitservice"); $this->_submitservice->setAttrib("onClick", "save_covenantpricing();"); }
private function getFormData($cdrequest = "0") { /* Usado para a edição de uma requisição * Remover quando criar a tela de controle de requisição * Maikon.Deletar * if($cdrequest > 0) { $requestModel = new RequestModel(); $requestData = $requestModel->fetchRow($requestModel->getRequestByCdRequest($cdrequest)); $this->view->cdrequest = $requestData->cdrequest; $this->view->cdclient = $requestData->cdclient; $this->view->cdcovenant = $requestData->cdcovenant; $this->view->cdforward = $requestData->cdforward; $this->view->idcovenantcard = $requestData->idcovenantcard; $this->view->fgpriority = $requestData->fgpriority; //$this->view->fgcollection = $requestData->fgcollection; // Completar aqui com as novas colunas da tabela 'request' // Tratar variável de data vinda do banco para colocar no formulário $dtrequestdb = $requestData->dtrequest; $date = new Zend_Date($dtrequestdb, 'YYYY-MM-dd HH:mm:ss'); $dtrequest = $date->toString('dd-MM-YYYY'); $hrrequest = $date->toString('HH:mm:ss'); $this->view->dtrequest = $dtrequest; $this->view->hrrequest = $hrrequest; //die("feshow, cdrequest: " . $cdrequest .", cdclient: ". $requestData->cdclient .", dtbirth: ". $requestData->dtbirth .", nrage: ". $this->view->nrage); } * * * public function getPatientSituationCdRequest($cdrequest) { /////// $select = $this->select() ->from("request") ->join("client", "request.cdclient = client.cdclient") //faz a união das tabelas ->where("client.cdclient = ?", $cdrequest) //apresenta os parametros ->setIntegrityCheck(false); echo $select;die; return $select; } */ // Busca todos os Clientes/Pacientes, Ativos e Inativos. $clientModel = new ClientModel(); $this->view->clientData = $clientModel->fetchAll(null, array('client.cdclient', 'client.nmclient')); // Busca todas as empresas, Ativas e Inativas. $companyModel = new CompanyModel(); $this->view->companyData = $companyModel->fetchAll(null, 'company.nmcompany'); // Busca apenas Exames Ativos(fgactive = 1) $examinationModel = new ExaminationModel(); $this->view->examinationData = $examinationModel->fetchAll('examination.fgactive = 1', 'examination.nmexamination'); }
public function selectedpricingAction() { $this->_helper->layout->disableLayout(); $covenantModel = new CovenantpricingModel(); $examinationModel = new ExaminationModel(); $cdcovenant = $this->_request->getParam('cdcovenant'); $examinationDados = $covenantModel->fetchAll($covenantModel->getCovenantExamination($cdcovenant)); $examinationDadosNN = $examinationModel->fetchAll($examinationModel->getCovenantExaminationNN($cdcovenant)); $opt = ''; $i = 0; $response = new stdClass(); if ($examinationDadosNN->count() > 0) { foreach ($examinationDadosNN as $examination) { $opt .= "<option value='" . $examination['cdexamination'] . "'>" . $examination['nmexamination'] . "</option>"; } foreach ($examinationDados as $row) { if ($row['fgauthrequired'] == '2') { $fg = '0'; } else { $fg = '1'; } $response->rows[$i]['cell'] = array($row['cdcovenant'], $row['cdexamination'], $row['idcovenant'] . " - " . $row['nmcovenant'], $row['nmexamination'], $row['vlexamination'], $row['vlchdefault'], $row['fgbasevalexamination'], $row['nrdeadline'], $fg); $i++; $response->chvalue = $row['vlchvalue']; } $response->options = $opt; $result = json_encode($response); print_r($result); return $result; } else { $response = new stdClass(); $response->options = "empty"; $response->rows = "empty"; $result = json_encode($response); print_r($result); return $result; } }
public function getexaminationcovenantAction() { $cdcovenant = $this->_request->getParam('cdcovenant'); $examinationModel = new ExaminationModel(); $examinationcovenant = $examinationModel->getAExamination($cdcovenant); $responce = new stdClass(); $index = 0; foreach ($examinationcovenant as $row) { $responce->rows[$index]['cdexamination'] = $row->cdexamination; $responce->rows[$index]['nmexamination'] = $row->nmexamination; $index++; } $this->view->examinationData = $responce; }
public function savepartialexaminationAction() { $values = $this->_request->getParams(); $form = $values['form']; $form = json_decode($form); $mapattrib = $this->_request->getParam('fgmapattrib'); $array = array(); $modelExamination = new ExaminationModel(); $columns = $modelExamination->info(Zend_Db_Table_Abstract::COLS); $this->_model->getAdapter()->beginTransaction(); try { foreach ($form 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; } } } $array["cdrevision"] = 1; // Mostragem dos atributos no mapa if (isset($mapattrib)) { if ($mapattrib) { $array['fgmapattrib'] = 1; } else { $array['fgmapattrib'] = 2; } } if (empty($array) || $array["idexamination"] == '' || $array["nmexamination"] == '') { throw new Exception('Dados Incorretos. Confira seus dados e Tente Novamente.'); } else { $modelExamination->insert($array); $lastcdexamination = $modelExamination->getAdapter()->lastInsertId(); $this->_model->getAdapter()->commit(); $this->view->msginclude = array(0, 'Os Dados do Exame foram gravados com sucesso!', $lastcdexamination); } } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $this->view->msginclude = array(1, 'Erro: ' . $e->getMessage()); } }