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"); $clientModel = new ClientModel(); $clientModelData = $clientModel->fetchAll($clientModel->getAllClient()); $this->view->clientModelData = $clientModelData; $tabela = new ClientModel(); $agenda = $tabela->fetchAll(); $count = count($agenda); if ($count > 0 && $limit > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } //$agenda = $tabela->fetchAll(null, "$sidx $sord", $limit, ($page*$limit-$limit)); $responce = new stdClass(); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i = 0; foreach ($clientModelData as $row) { $responce->rows[$i]['id'] = $row->cdusergslab; $responce->rows[$i]['cell'] = array($row->nmclient, $row->idcomplement, $row->idcep, $row->nmimages); $i++; } $this->view->dados = $responce; }
public function autoclientsearchAction() { $client = $this->_request->getParam('term'); $clientModel = new ClientModel(); $userData = $clientModel->fetchAll('nmclient LIKE "%' . $client . '%"'); $json = '['; $first = true; foreach ($userData as $row) { if (!$first) { $json .= ','; } else { $first = false; } $json .= '{"id":"' . $row['cdclient'] . '", "value":"' . $row['nmclient'] . '"}'; } $json .= ']'; echo $json; }
public function __construct() { parent::__construct(); $covenantModel = new CovenantModel(); $selectCovenant = $covenantModel->fetchAll(); $company = new CompanyModel(); $selectCompany = $company->fetchAll('cdcompanyparent IS NULL'); $departmentModel = new DepartmentModel(); $selectDepartment = $departmentModel->fetchAll(); $nmcollectionplaceModel = new CompanyModel(); $selectCompany = $nmcollectionplaceModel->fetchAll(); $clientModel = new ClientModel(); $clientData = $clientModel->fetchAll(); $this->_cdcovenant = new Zend_Form_Element_Select('cdcovenant'); $this->_cdcovenant->setAttrib("id", "covenantbilling_cdcovenant"); $this->_cdcovenant->setAttrib("class", "check_multiple_select"); foreach ($selectCovenant as $value) { //$this->_cdcovenant->addMultiOption($value->cdcovenant, $value->nmcovenant); } $this->_cdcovenant->setLabel("Convênio"); $this->_cdcovenant->setDecorators($this->_decoratorsDefault); $this->_cdcovenant->setRegisterInArrayValidator(false); $this->_cdcovenant->setRequired(false); $this->_cdcompanyparent = new Zend_Form_Element_Select('cdcompanyparent'); $this->_cdcompanyparent->setAttrib("id", "controltbilling_cdcompanyparent"); foreach ($selectCompany as $value) { $this->_cdcompanyparent->addMultiOption($value->cdcompany, $value->nmcompany); } $this->_cdcompanyparent->setLabel("Posto de Coleta"); $this->_cdcompanyparent->setDecorators($this->_decoratorsDefault); $this->_cdcompanyparent->setRegisterInArrayValidator(false); $this->_cdcompanyparent->setRequired(false); $this->_cddepartment = new Zend_Form_Element_Select('cddepartment'); $this->_cddepartment->setAttrib("id", "covenantbilling_ceddepartment"); $this->_cddepartment->setAttrib("class", "check_multiple_select"); foreach ($selectDepartment as $value) { $this->_cddepartment->addMultiOption($value->cddepartment, $value->nmdepartment); } $this->_cddepartment->setLabel("Setor"); $this->_cddepartment->setDecorators($this->_decoratorsDefault); $this->_cddepartment->setRegisterInArrayValidator(false); $this->_cddepartment->setRequired(false); $this->_fgstatus = new Zend_Form_Element_Select('fgstatus'); $this->_fgstatus->setAttrib("id", "covenantbilling_fgstatus"); $this->_fgstatus->setMultiOptions(array("0" => "Selecione", "1" => "Ativo", "2" => "Inativo")); $this->_fgstatus->setLabel("Status"); $this->_fgstatus->setDecorators($this->_decoratorsDefault); $this->_fgstatus->setRegisterInArrayValidator(false); $this->_fgstatus->setRequired(false); //$clientData $this->_cdclient = new Zend_Form_Element_Text('cdclient'); $this->_cdclient->setAttrib("id", "covenantbilling_cdclient"); $this->_cdclient->setAttrib("onkeyup", "lookup(this.value);"); $this->_cdclient->setAttrib("onblur", "fill();"); $this->_cdclient->setAttrib("autocomplete", "off"); $this->_cdclient->setAttrib("size", "50"); // foreach ($clientData as $value) { // $this->_cdclient->addMultiOption($value->cdclient, $value->nmclient); // } $this->_cdclient->setLabel("Paciente"); $this->_cdclient->setDecorators($this->_decoratorsDefault); $this->_cdclient->setRequired(false); $this->_dtstart = new Zend_Form_Element_Text('dtstart'); $this->_dtstart->setAttrib("id", "covenantbilling_dtstart"); $this->_dtstart->setAttrib("class", "datepicker"); $this->_dtstart->setLabel("Data Inicio"); $this->_dtstart->setDecorators($this->_decoratorsDefault); $this->_dtstart->setRequired(false); $this->_hrend = new Zend_Form_Element_Text('dtenddate'); $this->_hrend->setLabel("Hora Início"); $this->_hrend->setDecorators($this->_decoratorsDefault); $this->_hrend->setAttrib("id", "covenantbilling_hrend"); $this->_hrend->setAttrib("class", "mask_time"); $this->_dtend = new Zend_Form_Element_Text('dtend'); $this->_dtend->setAttrib("id", "covenantbilling_dtenddate"); $this->_dtend->setAttrib("class", "datepicker"); $this->_dtend->setLabel("Data Fim"); $this->_dtend->setDecorators($this->_decoratorsDefault); $this->_dtend->setRequired(false); $this->_hrstart = new Zend_Form_Element_Text('hrstart'); $this->_hrstart->setLabel("Hora Fim"); $this->_hrstart->setDecorators($this->_decoratorsDefault); $this->_hrstart->setAttrib("id", "covenantbilling_hrstart"); $this->_hrstart->setAttrib("class", "mask_time"); $this->_nrbatch = new Zend_Form_Element_Text('nrlot'); $this->_nrbatch->setAttrib("id", "covenantbilling_nrbatch"); $this->_nrbatch->setLabel("Número do Lote"); $this->_nrbatch->setDecorators($this->_decoratorsDefault); $this->_nrbatch->setRequired(false); $this->_dtduedate = new Zend_Form_Element_Text('dtduedate'); $this->_dtduedate->setAttrib("id", "covenantbilling_dtduedate"); $this->_dtduedate->setAttrib("class", "datepicker"); $this->_dtduedate->setLabel("Vencimento"); $this->_dtduedate->setDecorators($this->_decoratorsDefault); $this->_dtduedate->setRequired(false); }
public function autosearchAction() { $client = $_POST["queryString"]; $clientModel = new ClientModel(); $clientData = $clientModel->fetchAll($clientModel->getClient($client)); echo "<ul id='sug'>"; foreach ($clientData as $row) { echo '<li onClick="fill(\'' . $row->cdclient . '\', \'' . $row->nmclient . '\');"><a href="javascript:void(0);">' . $row->nmclient . '</a></li>'; } echo "</ul>"; }
public static function autoCompletePatientSearch($nmclient) { $clientModel = new ClientModel(); $clientData = $clientModel->fetchAll('nmclient like "%' . $nmclient . '%"'); $json = '['; $first = true; foreach ($clientData as $row) { if (!$first) { $json .= ','; } else { $first = false; } $json .= '{"id":"' . $row['cdclient'] . '", "value":"' . $row['nmclient'] . '"}'; } $json .= ']'; return $json; }
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 autosearchAction() { $client = $_POST["queryString"]; $clientModel = new ClientModel(); $clientData = $clientModel->fetchAll($clientModel->getClient($client)); foreach ($clientData as $row) { echo '<li onClick="fill(\'' . $row->cdclient . '\', \'' . $row->nmclient . '\');">' . $row->nmclient . '</li>'; } }
public function dadosAction() { $this->_helper->layout->disableLayout(); $page = $this->_request->getParam("page"); $limit = $this->_request->getParam("rows"); $sord = $this->_request->getParam("sord"); $clientModel = new ClientModel(); $phoneModel = new ClientphonenumberModel(); $client = $clientModel->fetchAll(); $count = count($client); if ($count > 0 && $limit > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } if ($this->_request->getParam("_search") == 'true') { $searchString = $this->_request->getParam("searchString"); $searchField = $this->_request->getParam("searchField"); $clientDados = $clientModel->fetchAll($clientModel->getClientSearchGrid($searchField, $searchString, $sord)); } else { $clientDados = $clientModel->fetchAll(null, 'nmclient', $limit, $page * $limit - $limit); } $response = new stdClass(); $response->page = $page; $response->total = $total_pages; $response->records = $count; $i = 0; foreach ($clientDados as $rows) { // TODO: Arrumar telefone de paciente $phoneData = $phoneModel->fetchRow('cdclient = ' . $rows->cdclient); $fgsex = null; switch ($rows->fgsex) { case '1': $fgsex = 'Masculino'; break; case '2': $fgsex = 'Feminino'; break; } switch ($rows->fgvip) { case '1': $fgvip = 'Sim'; break; case '2': $fgvip = 'Não'; break; } if (isset($rows["dtbirth"])) { $date = GslabUtils::dateToLocaleBR($rows["dtbirth"]); } $response->rows[$i]['cell'] = array($rows->cdclient, $rows->nmclient, $fgsex, $date, $fgvip, $phoneData['nrdddphone'] . " " . $phoneData['nrphonenumber']); $i++; } $this->view->dados = $response; }