private function getFormData($cdrequest = "0") { $gslabSession = Zend_Session::namespaceGet('Gslab_Session'); /* 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); } */ // Busca todos os Clientes/Pacientes, Ativos e Inativos. $clientModel = new ClientModel(); $this->view->clientData = $clientModel->fetchAll(null, 'client.nmclient'); // Busca os Guichês ativos e relacionados ao posto de coleta . $cashdeskModel = new CashdeskModel(); $cdcompany = $gslabSession['user']->cdcompany; $this->view->cashdeskData = $cashdeskModel->fetchAll("cashdesk.cdcompany = {$cdcompany} AND cashdesk.fgactive = 1", 'cashdesk.nmcashdesk'); // Busca todas as empresas, Ativas e Inativas. $companyModel = new CompanyModel(); $this->view->companyData = $companyModel->fetchAll('company.cdcompany = ' . $gslabSession['user']->cdcompany . ' OR company.cdcompanyparent = ' . $gslabSession['user']->cdcompany, 'company.nmcompany'); // Busca todos os médicos que enviaram o paciente $forwardModel = new ForwardModel(); $this->view->forwardData = $forwardModel->fetchAll(null, 'forward.nmforward'); // Busca apenas Exames Ativos(fgactive = 1) $opernatureModel = new OpernatureModel(); $this->view->opernature = $opernatureModel->fetchAll(); // Busca apenas suprimentos Ativos(fgactive = 1) $supplyModel = new SupplyModel(); $this->view->supplyData = $supplyModel->fetchAll('supply.fgactive = 1', 'supply.nmsupply'); // Busca todos os Logradouros. $addressTypeModel = new AddresstypeModel(); $this->view->addressTypeData = $addressTypeModel->getAllAddressType(); $medicinesModel = new MedicineModel(); $this->view->medicineData = $medicinesModel->fetchAll("cdsupply IS NOT NULL", 'medicine.nmmedicine'); $cashdeskModel = new CashdeskModel(); $this->view->cashdeskData = $cashdeskModel->fetchAll(null, 'cashdesk.nmcashdesk'); }
public function dadosAction() { $this->_helper->layout->disableLayout(); $page = $this->_request->getParam("page", 1); $limit = $this->_request->getParam("rows"); $sidx = $this->_request->getParam("sidx", 1); $sord = $this->_request->getParam("sord"); $array = $this->_request->getParams(); $clientModel = new ClientModel(); $covenantModel = new CovenantModel(); $opernatureModel = new OpernatureModel(); $supplierModel = new SupplierModel(); $total_pages = 0; if (isset($array['secondperiod']) && $array['secondperiod'] != '') { $array['secondperiod'] = new Zend_Date($array['secondperiod'], 'dd-MM-YYYY HH:mm:ss'); $array['secondperiod'] = $array['secondperiod']->toString('YYYY-MM-dd HH:mm:ss'); } if (isset($array['firstperiod']) && $array['firstperiod'] != '') { $array['firstperiod'] = new Zend_Date($array['firstperiod'], 'dd-MM-YYYY HH:mm:ss'); $array['firstperiod'] = $array['firstperiod']->toString('YYYY-MM-dd HH:mm:ss'); } $accountentryData = $this->_model->fetchAll($this->_model->getAccountGridParams($array, $sidx, $sord, $limit, $page)); $count = count($accountentryData); if ($page > $total_pages) { $page = $total_pages; } else { $total_pages = 0; } $responce = new stdClass(); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i = 0; foreach ($accountentryData as $rows) { $favored = ''; $nmopernature = ''; $fgaccountcheck = ''; $fgaccountentrytype = ''; switch ($rows->fgaccountentrytype) { case '1': $fgaccountentrytype = 'À Pagar'; break; case '2': $fgaccountentrytype = 'À Receber'; break; } switch ($rows->fgactive) { case '2': $fgactive = 'Inativo'; break; case '1': $fgactive = 'Ativo'; break; } switch ($rows->fgaccountcheck) { case '0': $fgaccountcheck = 'Pendente'; break; case '1': $fgaccountcheck = 'Baixa Realizada'; break; } if ($rows->fgclienttype == 'a') { if ($rows->cdclient != null && $rows->cdclient != '') { $clientData = $clientModel->fetchRow('cdclient = ' . $rows->cdclient); $favored = $clientData['nmclient']; } } elseif ($rows->fgclienttype == 'b') { if ($rows->cdclient != null && $rows->cdclient != '') { $clientData = $covenantModel->fetchRow('cdcovenant = ' . $rows->cdclient); $favored = $clientData['nmcovenant']; } } if ($rows->fgaccountcheck != null && $rows->fgaccountcheck != '0') { if ($rows->cdopernature != '') { $opernatureData = $opernatureModel->fetchRow('cdopernature = ' . $rows->cdopernature); $nmopernature = $opernatureData['nmopernature']; } } if ($rows->cdsupplier != '' && $rows->cdsupplier != null) { $supplierData = $supplierModel->fetchRow('cdsupplier = ' . $rows->cdsupplier); $favored = $supplierData['nmsupplier']; } $responce->rows[$i]['cdaccountentry'] = $rows->cdaccountentry; $responce->rows[$i]['cell'] = array($rows->nraccountentry, $fgaccountentrytype, $favored, $fgaccountcheck, $fgactive, $nmopernature, $rows->cdaccountentry); $i++; } $this->view->dados = $responce; }