public function selectedclientAction() { $cdclient = $_POST["cdclient"]; //$cdrequest = $_POST[""]; //print_r($_POST); $addressTypeModel = new AddresstypeModel(); $clientModel = new ClientModel(); $client = $clientModel->fetchRow($clientModel->getClientByCdClient($cdclient)); $dtbirth = new Zend_Date($client['dtbirth'], 'dd-MM-YYYY'); $year = $dtbirth->toString('YYYY'); $month = $dtbirth->toString('MM'); $day = $dtbirth->toString('dd'); $today = new Zend_Date(); $tdYear = $today->toString('YYYY'); $tdMonth = $today->toString('MM'); $tdDay = $today->toString('dd'); $nrage = 0; $nrage = GslabUtils::calcAgeDifferenceShort($client['dtbirth']); if ($tdMonth < $month || $tdMonth == $month && $tdDay < $day) { $nrage--; } $selectedClient = array(); $selectedClient['fgsex'] = $client['fgsex']; $selectedClient['dtbirth'] = $dtbirth->toString('dd-MM-YYYY'); $selectedClient['nrage'] = $nrage; // $selectedClient['cdrequest'] = $cdrequest; // Busca apenas convênios Ativos(fgactive = 1) $clientCovenantModel = new ClientcovenantModel(); $covenantData = $clientCovenantModel->fetchAll($clientCovenantModel->getClientCovenantsByCdClient($cdclient)); $covenantArray = array(); foreach ($covenantData as $covenant) { $covenantRow['cdcovenant'] = $covenant['cdcovenant']; $covenantRow['idcovenantcard'] = $covenant['idcovenantcard']; $covenantRow['nmcardholder'] = $covenant['nmcardholder']; $covenantRow['nmcovenant'] = $covenant['nmcovenant']; $covenantArray[] = $covenantRow; } $selectedClient['covenantData'] = $covenantArray; $this->view->selectedClient = $selectedClient; }
public function generateprotocolAction($cdrequest = 1) { require_once 'fpdf/pdf_protocol.php'; $gslabSession = Zend_Session::namespaceGet('Gslab_Session'); $cdcompany = $gslabSession['user']->cdcompany; $companyModel = new CompanyModel(); $requestModel = new RequestModel(); $sampleModel = new RequestexaminationsampleModel(); $clientModel = new ClientModel(); $covenantModel = new CovenantModel(); $forwardModel = new ForwardModel(); $examinationModel = new RequestexaminationModel(); $companyData = $companyModel->fetchRow('cdcompany = ' . $cdcompany); $requestData = $requestModel->fetchRow('cdrequest = ' . $cdrequest); $sampleData = $sampleModel->fetchRow('cdrequest = ' . $cdrequest); $clientData = $clientModel->fetchRow('cdclient = ' . $requestData->cdclient); $covenantData = $covenantModel->fetchRow('cdcovenant = ' . $requestData->cdcovenant); $forwardData = $forwardModel->fetchRow('cdforward = ' . $requestData->cdforward); $dtbirth = new Zend_Date($clientData->dtbirth, 'dd-MM-YYYY'); $dtrequest = new Zend_Date($requestData->dtrequest, 'dd-MM-YYYY HH:mm'); $dtdeadline = new Zend_Date($requestData->dtdeadline, 'dd-MM-YYYY HH:mm'); $year = $dtbirth->toString('YYYY'); $month = $dtbirth->toString('MM'); $day = $dtbirth->toString('dd'); $today = new Zend_Date(); $tdYear = $today->toString('YYYY'); $tdMonth = $today->toString('MM'); $tdDay = $today->toString('dd'); $nrage = 0; $nrage = GslabUtils::calcAgeDifferenceShort($clientData->dtbirth); $idade = GslabUtils::calcula_idade($clientData->dtbirth); if ($clientData->fgsex == 1) { $sexo = 'M'; } else { $sexo = 'F'; } if ($tdMonth < $month || $tdMonth == $month && $tdDay < $day) { $nrage--; } $pdf = new PDF_PROTOCOL(); $pdf->AddPage(); $pdf->SetFont('Courier', 'B', 11); $pdf->ln(55); $pdf->Cell(0, 0, utf8_decode(strtoupper($companyData->nmcompany)), 0, 1, 'C'); $pdf->Cell(0, 8, utf8_decode('LABORATÓRIO DE ANÁLISES CLÍNICAS'), 0, 2, 'C'); $pdf->Cell(0, -5, str_repeat('_', 81), 0, 1, 'L'); $pdf->ln(8); $pdf->SetFont('Helvetica', '', 9); $pdf->Cell(0, 0, utf8_decode(strtoupper($companyData->nmstreet) . ', ' . $companyData->nrnumber), 0, 1, 'L'); $pdf->ln(4); $pdf->Cell(0, 0, 'COMPROVANTE DE COLETA', 0, 1, 'L'); $pdf->Cell(0, 0, utf8_decode(strtoupper($companyData->nmneighborhood)) . ' - Fone: (47) 3427-3668', 0, 1, 'R'); //ADICIONAR TELEFONE NA BASE $pdf->ln(4); $pdf->Cell(0, 0, utf8_decode('Ficha: ') . $requestData->cdcompany . "-" . $requestData->cdrequest, 0, 1, 'L'); $pdf->Cell(0, 0, 'Senha: 2301', 0, 1, 'R'); $pdf->ln(8); $pdf->Cell(0, 0, utf8_decode('PRONTUÁRIO'), 0, 1, 'L'); $pdf->ln(4); $pdf->SetFont('Helvetica', '', 10); $pdf->Cell(15, 5, utf8_decode('Amostra: '), 0, 0, 'L'); $pdf->Cell(0, 5, $pdf->SetFont('Helvetica', 'BU', 10) . $sampleData->nmbarcodesample, 0, 1, 'L'); $pdf->ln(4); $pdf->SetFont('Helvetica', 'BU', 10); $pdf->Write(0, utf8_decode(strtoupper($clientData->nmclient))); $pdf->SetFont('Helvetica', '', 10); $pdf->ln(8); $pdf->Write(0, utf8_decode('Idade: ' . $nrage)); $pdf->Write(0, utf8_decode(' Sexo: ' . $sexo)); $pdf->ln(6); $pdf->Write(0, utf8_decode('Convênio: ' . $covenantData->nmcovenant)); $pdf->ln(6); $pdf->Write(0, utf8_decode('Médico: ' . $forwardData->idmaincrm . ' - ' . $forwardData->nmforward)); $pdf->ln(6); $pdf->Write(0, utf8_decode('Coleta: ' . strtoupper($companyData->cdcompany . ' - ' . $companyData->nmfantasyname))); $pdf->ln(6); $pdf->Write(0, utf8_decode('Data e Hora: ') . $dtrequest); $pdf->ln(4); $pdf->SetFont('Courier', 'B', 11); $pdf->Cell(0, 0, str_repeat('_', 81), 0, 1, 'L'); /* CAIXA LATERAL */ $pdf->SetFont('Helvetica', '', 10); $pdf->SetY(89); $pdf->SetX(90); $pdf->drawTextBox(utf8_decode('Provável local e data da entrega: Local: ' . strtoupper($companyData->nmfantasyname) . ' Data: ' . $dtdeadline . ' Salvo quando ocorrer: 1- Imprevistos técnicos 2- Bloqueio de resultado pelo controle de qualidade 3- Atraso no fornecimento de reagentes Autorizo a coleta do(s) exame(s) acima citado(s) e declaro estar ciente dos riscos quanto ao surgimento de possíveis hematomas no local da punção. Assinatura do cliente e/ou responsável:__________________________________________'), 109, 50, 'L', 'M'); /* doze exames */ $Exames = $examinationModel->fetchAll($examinationModel->getExaminationProtocol($cdrequest)); $pdf->ln(13); // Exames $pdf->SetFont('Helvetica', 'B', 9); $pdf->SetWidths(array(50, 23, 18)); $pdf->SetX(10); $pdf->Row(array(utf8_decode('Exames'), utf8_decode('Material'), utf8_decode('Status'))); $pdf->SetFont('Helvetica', '', 9); $i = 0; foreach ($Exames as $examination) { if ($examination['nmmaterial'] == 2) { $status = 'Faltante'; } else { $status = 'OK'; } if ($i == 11) { $pdf->SetY(148); } $pdf->SetX(10); $pdf->Row(array(utf8_decode($examination['nmexamination']), utf8_decode($examination['nmmaterial']), $status)); $i++; } $pdf->ln(5); /* -------------------------------------------------------------- */ /* PESQUISA DE SATISFAÇÃO */ $pdf->SetFont('Helvetica', '', 7); $pdf->SetY(205); $pdf->Cell(0, 0, str_repeat(' -', 125), 0, 1, 'L'); $pdf->SetX(10); $pdf->Write(5, utf8_decode('Prezado cliente: com o objetivo de melhorarmos cada vez mais a')); $pdf->ln(3); $pdf->SetX(10); $pdf->Write(5, utf8_decode('qualidade dos nossos serviços e o atendimento à você, solicitamos')); $pdf->ln(3); $pdf->SetX(10); $pdf->Write(5, utf8_decode('a sua gentileza preenchendo o formulário abaixo.')); $pdf->ln(5); $pdf->SetFont('Helvetica', 'B', 7); $pdf->SetWidths(array(30, 13, 13, 13, 13)); $pdf->SetX(10); $pdf->Row(array(utf8_decode('Assinale sua opinião'), utf8_decode('Ótimo'), 'Bom', 'Regular', 'Ruim')); $pdf->SetFont('Helvetica', '', 7); $pdf->SetX(10); $pdf->Row(array(utf8_decode('1. Como foi o atendimento ao telefone?'), '', '', '', '')); $pdf->SetX(10); $pdf->Row(array(utf8_decode('2. Como foi o atendimento da recepção?'), '', '', '', '')); $pdf->SetX(10); $pdf->Row(array(utf8_decode('3. Quanto ao conforto e bem estar na sala de espera?'), '', '', '', '')); $pdf->SetX(10); $pdf->Row(array(utf8_decode('4. Quanto à coleta do material para o exame?'), '', '', '', '')); $pdf->SetX(10); $pdf->Row(array(utf8_decode('5. Quanto ao prazo e entrega dos resultados?'), '', '', '', '')); $pdf->SetY(215); $pdf->SetX(117); $pdf->Write(5, utf8_decode('6. Como conheceu o Laboratório? _______________________________')); $pdf->ln(7); $pdf->SetX(117); $pdf->Write(5, utf8_decode('7. Você indicaria o laboratório para outras pessoas? ( ) Sim ( ) Não')); $pdf->ln(7); $pdf->SetX(117); $pdf->Write(5, utf8_decode('Se NÃO, por quê?____________________________________________')); $pdf->ln(7); $pdf->SetX(117); $pdf->Write(5, utf8_decode('8. Conhece nosso ')); $pdf->SetFont('Helvetica', 'BU', 7); $pdf->Write(5, utf8_decode('Programa de Coleta Domiciliar')); $pdf->SetFont('Helvetica', '', 7); $pdf->Write(5, utf8_decode(' (tel: 3433-2127)?')); $pdf->ln(7); $pdf->SetX(117); $pdf->Write(5, utf8_decode('( ) Sim ( ) Não')); $pdf->ln(7); $pdf->SetX(117); $pdf->Write(5, utf8_decode('9. Sugestões e críticas:_______________________________________')); $pdf->ln(7); $pdf->SetX(117); $pdf->Write(5, utf8_decode('__________________________________________________________')); $pdf->ln(7); $pdf->SetX(117); $pdf->Write(5, utf8_decode('__________________________________________________________')); $pdf->Output(); //IMPRIME O PDF NA TELA $pdf->Output('teste_pro.pdf', "D"); //IMPRIME O PDF NO ARQUIVO }
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; }
public function covenantbillingdataAction() { // FUNÇÃO QUE REALIZA A PESQUISA / FILTROS $cdcovenant = $this->_request->getParam('cdcovenant'); $cdcompanyparent = $this->_request->getParam('cdcompanyparent'); $dtstart = $this->_request->getParam('dtstart'); $dtend = $this->_request->getParam('dtend'); if (isset($dtstart) && $dtstart != '') { $dtstart = new Zend_Date($dtstart, 'dd-MM-YYYY HH:mm:ss'); $dtstart = $dtstart->toString('YYYY-MM-dd HH:mm:ss'); } if (isset($dtend) && $dtend != '') { $dtend = new Zend_Date($dtend, 'dd-MM-YYYY HH:mm:ss'); $dtend = $dtend->toString('YYYY-MM-dd HH:mm:ss'); } $responce = 0; $convenantModel = new CovenantModel(); $clientModel = new ClientModel(); $requestModel = new RequestModel(); $covenantbillingData = $requestModel->fetchAll($requestModel->getRequestsUnbilled($cdcovenant, $cdcompanyparent, $dtstart, $dtend)); $responce = new stdClass(); if (count($covenantbillingData) > 0) { $i = 0; foreach ($covenantbillingData as $rows) { $nmclient = ''; $cdclient = ''; $nmconvenant = ''; $cdcovenant = ''; $rows['dtrequest'] = new Zend_Date($rows['dtrequest'], 'YYYY-MM-dd HH:mm:ss'); $rows['dtrequest'] = $rows['dtrequest']->toString('dd/MM/yyyy'); if ($rows['cdclient'] != null) { $clientData = $clientModel->fetchRow('cdclient=' . $rows['cdclient']); $nmclient = $clientData['nmclient']; $cdclient = $clientData['cdclient']; } if ($rows['cdcovenant'] != null) { $convenantData = $convenantModel->fetchRow('cdcovenant=' . $rows['cdcovenant']); $nmconvenant = $convenantData->nmcovenant; $cdcovenant = $convenantData['cdcovenant']; } $responce->rows[$i]['cdrequest'] = $rows['cdrequest']; $responce->rows[$i]['cell'] = array($rows['cdrequest'], $rows['dtrequest'], $nmclient, $nmconvenant, $rows['nrguide'], $cdclient, $cdcovenant); $i++; } $this->view->covenantbillingdata = $responce; } else { $this->view->covenantbillingdata = 'vazio'; } }
public function printcardAction() { $cdclient = $this->_request->getParam("cdclient"); $clientModel = new ClientModel(); $clientCode = $clientModel->fetchRow('cdclient = ' . $cdclient); $array = array(); $array['nome'] = $clientCode->nmclient; $data = new Zend_Date($clientCode->dtbirth, "YYYY-MM-dd HH:mm:ss"); $clientCode->dtbirth = $data->toString('dd-MM-YYYY'); $array['nascimento'] = $clientCode->dtbirth; if ($clientCode->fgbloodtype == 1) { $array['sangue'] = 'O'; } else { if ($clientCode->fgbloodtype == 2) { $array['sangue'] = 'A'; } else { if ($clientCode->fgbloodtype == 3) { $array['sangue'] = 'B'; } else { if ($clientCode->fgbloodtype == 0) { $array['sangue'] = ''; } } } } if ($clientCode->fgrhfactor == 1) { $array['RH'] = 'Positivo'; } else { if ($clientCode->fgrhfactor == 2) { $array['RH'] = 'Negativo'; } else { if ($clientCode->fgrhfactor == 0) { $array['RH'] = ''; } } } echo "<div id='div_box'>\r\n Nome: " . ucwords(strtolower($array['nome'])) . "<br>\r\n Data de Nascimento: " . $array['nascimento'] . "<br>\r\n Grupo Sanguíneo: " . $array['sangue'] . "<br>\r\n Fator RH: " . $array['RH'] . "<br>\r\n </div>"; }