public function dadosforwardAction() { $cdclient = $_GET["cdcliente"]; $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"); $forwardModel = new ForwardModel(); $forwardData = $forwardModel->fetchAll(); $count = count($forwardData); if ($count > 0 && $limit > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $forwardData = $forwardModel->fetchAll($forwardModel->getForwardByClient($cdclient, $sidx, $sord, $limit, $page)); $responce = new stdClass(); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i = 0; foreach ($forwardData as $row) { $responce->rows[$i]['cdclient'] = $row->cdclient; $responce->rows[$i]['cell'] = array($row->nmforward, substr($row->dtrequest, 8, 2) . '/' . substr($row->dtrequest, 5, 2) . '/' . substr($row->dtrequest, 0, 4)); $i++; } $this->view->dadosforward = $responce; }
public function dadosindexAction() { $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"); $forwardModel = new ForwardModel(); $forward = $forwardModel->fetchAll(); $count = count($forward); if ($count > 0 && $limit > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $forward = $forwardModel->fetchAll(null, "{$sidx} {$sord}", $limit, $page * $limit - $limit); $responce = new stdClass(); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i = 0; foreach ($forward as $rows) { switch ($rows->fgactive) { case '1': $fgactive = 'Ativo'; break; case '2': $fgactive = 'Inativo'; break; } switch ($rows->fgcovenantrestriction) { case '1': $fgcovenantrestriction = '1'; break; case '2': $fgcovenantrestriction = '2'; break; } $responce->rows[$i]['cell'] = array($rows->cdforward, $rows->nmforward, $rows->nmmail, $rows->idmaincrm, $rows->idmaincrmstate, $rows->idalternativecrm, $rows->idalternativecrmstate, $rows->idcnes, $rows->nrcellphone, $rows->nrphone, $rows->nmstreet, $rows->nrnumber, $rows->nmneighborhood, $rows->idcity, $rows->idstate, $rows->idcep, $fgcovenantrestriction, $fgactive); $i++; } // print_r($responce); die; $this->view->dados = $responce; }
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'); }