public function saveAction()
{
$this->_helper->layout->disableLayout();
$array = $this->_request->getParams();
$arrayRequest = array();
if ($array['campo'] == 'dsobservation') {
$arrayRequest['dsobservation'] = $array['valor'];
} else {
$arrayRequest['nmpassword'] = $array['valor'];
}
$requestModel = new RequestModel();
$requestModel->update($arrayRequest, 'cdrequest =' . $array['cdrequest']);
}
public function dadosAction()
{
$this->_helper->layout->disableLayout();
$page = $this->_request->getParam("page", 1);
$array = $this->_request->getParams();
$sampleModel = new RequestModel();
$total_pages = 0;
$sampleData = $sampleModel->fetchAll($sampleModel->getControlRequest($array));
$count = count($sampleData);
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 ($sampleData as $rows) {
switch ($rows->fgstatus) {
case 1:
$fgstatus = "Coletada";
break;
case 2:
$fgstatus = "Faltante";
break;
case 3:
$fgstatus = "Em Mapa";
break;
case 4:
$fgstatus = "Lançada";
break;
case 5:
$fgstatus = "Conferida";
break;
case 6:
$fgstatus = "Impressa";
break;
case 7:
$fgstatus = "Entregue";
break;
}
$responce->rows[$i]['id'] = $rows->cdrequest;
$responce->rows[$i]['cell'] = array($rows->cdrequest, $rows->nmclient, $rows->dtrequest, isset($fgstatus) ? $fgstatus : '');
$i++;
}
$this->view->dados = $responce;
}
public function __construct()
{
$this->request = RequestModel::currentRequest();
// provide all controllers with access to the request data
$this->session = SessionModel::currentSession();
// provide all controllers with access to the session data
}
public static function redirect($url, $query_parameters = array())
{
$request = RequestModel::currentRequest();
$redirect_host = parse_url($url, PHP_URL_HOST);
// Check that we're redirecting to our own domain, avoids potential security issues...
if (!isValidURL($url)) {
$url = '/';
// fallback
} else {
if ($redirect_host !== HOSTNAME) {
// Remote Domain!
(new Log(SECURITY_LOG))->logMessage("Attempted redirect to external URL: {$url}");
$url = '/';
// fallback
} else {
// URL is OK, modify the existing URL if parameters were specified...
if (!empty($query_parameters)) {
$url = addQueryParams($url, $query_parameters);
}
}
}
// OK to Redirect User?
if (headers_sent($file, $line)) {
// Log Error
(new Log(ERROR_LOG))->logMessage("Unable to redirect, headers already sent in {$file} on line {$line}");
// Ask user for manual redirection...
echo "Unable to redirect automatically, please click this link: <a href=\"{$url}\">{$url}</a>";
} else {
// We're OK to Redirect
header("Location: {$url}");
}
exit;
// terminate
}
public function dadosAction()
{
$array = $this->_request->getParams();
$requestModel = new RequestModel();
$requestData = $requestModel->fetchAll($requestModel->getRequestGrid($array));
$this->_helper->layout->disableLayout();
$page = $this->_request->getParam("page", 1);
$responce = new stdClass();
$responce->page = $page;
$responce->total = 10;
$responce->records = 100;
$i = 0;
foreach ($attributeData as $row) {
$responce->rows[$i]['cell'] = array($row->cdattribute, $row->nmattribute, $row->fgdatatype, $row->nmmeasurementunit);
$i++;
}
$this->view->attribute = $responce;
}
public function __construct()
{
$this->request = RequestModel::currentRequest();
// Cookie Provided?
if (!empty($_COOKIE[self::COOKIE_NAME])) {
$this->cookie_token = $_COOKIE[self::COOKIE_NAME];
}
// Make sure the cookie is good, generate a new token if not (or missing)...
$this->cookie_token = $this->token();
}
function execute(Mpass_Request $client)
{
try {
$header = '';
$header = $client->read(1024);
$request = new RequestModel($header);
$handle = HandleFactory::getResponseHandle($request->isStatic());
$response = $handle->handle($header);
$client->write($response);
Mpass_Log::record($header, __METHOD__);
return true;
} catch (Exception $e) {
$EResponse = 'HTTP/1.0 ' . $e->getCode() . ' ' . $e->getMessage() . chr(13) . chr(10);
$EResponse .= 'Date:' . date("D, d M Y G:i:s \\G\\M\\T") . chr(13) . chr(10) . chr(13) . chr(10);
$client->write($EResponse);
Mpass_Log::record($EResponse, __METHOD__);
return true;
}
}
public function modalsamplesaveAction()
{
$var = $this->_request->getParams();
$requestModel = new RequestModel();
$cdrequest = $this->_request->getParam("code");
$array = array();
$requestModel->getAdapter()->beginTransaction();
try {
if (isset($cdrequest) && $cdrequest != null) {
$array['code'] = $cdrequest;
} else {
$array['code'] = null;
}
$datamodalGrid = $requestModel->fetchAll($requestModel->getDataRequestGridSample($array['code']));
$page = $this->_request->getParam("page", 1);
$limit = $this->_request->getParam("rows");
$count = count($datamodalGrid);
$responce = new stdClass();
/* Manipulação de dados para a grid */
$index = 0;
foreach ($datamodalGrid as $row) {
$date = new Zend_Date($row['dtcollection'], 'YYYY-MM-dd HH:mm:ss');
$date = $date->toString('dd-MM-YYYY');
$dateresult = new Zend_Date($row['dtresult'], 'YYYY-MM-dd HH:mm:ss');
$dateresult = $dateresult->toString('dd-MM-YYYY');
// $responce->rows[$index]['id'] = $row->request;
$responce->rows[$index]['cell'] = array($row->dtcollection, $row->dtresult, $row->fgstatus, $row->nmbarcodesample, $row->idmaterial, $row->nmexamination);
}
$this->view->modalsamplesave = $responce;
// print_r($responce);
} catch (Exception $e) {
$requestModel->getAdapter()->rollback();
echo $e->getMessage();
}
}
public function indexAction()
{
$mapsForm = new MapsForm();
$mapsForm->addElementsForm();
$mapsForm->setDecorators(array('FormElements', 'Form'));
$mapsForm->removeDecorator('form');
$this->view->fieldsetinputs = $mapsForm;
$values = $this->_request->getParams();
$arrayDepartment = array();
$arrayUniqueDepartment = array();
$arrayCovenant = array();
$arrayCollection = array();
$arrayPriorityexploded = array();
$arrayPriority = array();
$dtstartqry = null;
$dtendqry = null;
if (isset($values['cddepartment']) && ($values['cddepartment'] != '0' && $values['cddepartment'] != '')) {
$arrayDepartment = explode(',', $values['cddepartment']);
}
if (isset($values['cdcovenant']) && ($values['cdcovenant'] != '0' && $values['cdcovenant'] != '')) {
$arrayCovenant = explode(',', $values['cdcovenant']);
}
if (isset($values['collection']) && ($values['collection'] != '0' && $values['collection'] != '')) {
$arrayCollection = explode(',', $values['collection']);
}
if (isset($values['fgpriority']) && ($values['fgpriority'] != '0' && $values['fgpriority'] != '')) {
$arrayPriorityexploded = explode(',', $values['fgpriority']);
foreach ($arrayPriorityexploded as $priority) {
if ($priority == 'Normal') {
$arrayPriority[] = 0;
} else {
if ($priority == 'Urgente') {
$arrayPriority[] = 1;
}
}
}
}
if (isset($values['dtstartqry']) && ($values['dtstartqry'] != '0' && $values['dtstartqry'] != '')) {
$dtstartqry = new Zend_Date($values['dtstartqry'], 'dd-MM-YYYY');
$dtstartqry = $dtstartqry->toString('YYYY-MM-dd');
} else {
$dtstartqry = date("Y-m-d");
}
if (isset($values['dtendqry']) && ($values['dtendqry'] != '0' && $values['dtendqry'] != '')) {
$dtendqry = new Zend_Date($values['dtendqry'], 'dd-MM-YYYY');
$dtendqry = $dtendqry->toString('YYYY-MM-dd');
}
if (!($arrayDepartment == null && $arrayCovenant == null && $arrayCollection == null && $arrayPriorityexploded == null && $arrayPriority == null && $dtstartqry == null && $dtendqry == null)) {
$requestExaminationSampleModel = new RequestexaminationsampleModel();
$requestModel = new RequestModel();
$mapdataReturn = $requestExaminationSampleModel->fetchAll($requestExaminationSampleModel->getMapData($arrayDepartment, $arrayCovenant, $arrayCollection, $arrayPriority, $dtstartqry, $dtendqry));
foreach ($mapdataReturn as $maprequests) {
$departments = $requestModel->fetchAll($requestModel->getRequestDepartments($maprequests['cdrequest']));
foreach ($departments as $uniqueDepartment) {
$arrayUniqueDepartment[] = $uniqueDepartment['cddepartment'];
}
}
$arrayUniqueDepartment = array_unique($arrayUniqueDepartment);
$this->view->mapdata = $mapdataReturn;
$this->view->departments = $arrayUniqueDepartment;
$this->view->searchparams = json_encode($values);
}
}
public function isUserAuthenticated($auth_required = true)
{
// Cached Result... (if checked before, return the result)
if ($this->authentication != self::AUTH_UNKNOWN) {
return $this->authentication == self::AUTH_PASSED;
}
// Check Token Validity -- Avoid DB Overhead
if (self::isSessionIDValid($this->id)) {
$db = Database::getConnection();
$query = $db->query("SELECT user_id, update_timestamp, persistent FROM " . self::TABLE_NAME . " WHERE (id=:id) AND (expiry_timestamp > :now)", array(":id" => $this->id, ":now" => Carbon::now()));
} else {
if (!$auth_required) {
return false;
}
}
// Check Query Result (and that it was executed)
if (isset($query) && $query && $query->rowCount()) {
$db_row = $query->fetch(PDO::FETCH_ASSOC);
$this->user_id = $db_row['user_id'];
// only set here, force people to call this function first before being allowed to look at the ID
// We need to renew sessions on a regular basis in order for us to determine when sessions become inactive...
if (Carbon::parse($db_row['update_timestamp'])->diffInSeconds(Carbon::now()) > self::SESSION_RENEWAL_PERIOD_SECONDS) {
$this->create($db_row['user_id'], isTrue($db_row['persistent']));
}
// renew
$this->authentication = self::AUTH_PASSED;
return true;
} else {
if ($auth_required) {
// Determine the Current Target/Action
$request = RequestModel::currentRequest();
$router = RouteController::getController();
$route = $router->findRouteForURL($request->url());
// Add Query Params?
$url = $router->urlForAction($route->action(), $route->extractArgs($request->url()));
if (count($request->queryArgArray())) {
$url = addQueryParams($url, $request->queryArgArray());
}
// Request a Login
AppController::requestUserLogin($url);
// we need to extract and re-inject any args or we lose context...
} else {
$this->authentication = self::AUTH_FAILED;
return false;
}
}
}
public static function assetURL($asset)
{
return RequestModel::currentRequest()->protocol() . "://" . HOSTNAME . '/assets/' . $asset;
}
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 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 searchAction()
{
$var = $this->_request->getParams();
// var_dump($var); die;
//PESQUISA POR PACIENTE
$cdpatient = null;
$nrsample = null;
$cdrequest = null;
$sector = null;
$startdate = null;
$enddate = null;
//PESQUISA POR MAPA
$sector2 = null;
$cdmap = null;
$homepage = null;
$lastpage = null;
$dtfirstmaps = null;
$dtendmaps = null;
$page = $this->_request->getParam("page", 1);
$limit = $this->_request->getParam("rows");
$sidx = $this->_request->getParam("sidx", 1);
$sord = $this->_request->getParam("sord");
//Pesquisa por Paciente
$requestModel = new RequestModel();
// <- Instanciando a classe Request
$cdpatient = $this->_request->getParam("cdpatient");
// passando o valor dos parâmetros para as variaveis
$nrsample = $this->_request->getParam("nrsample");
$cdrequest = $this->_request->getParam("cdrequest");
$sector = $this->_request->getParam("sector");
if ($sector == 'Nenhuma opção selecionada') {
$sector = null;
}
$startdate = $this->_request->getParam("startdate");
$enddate = $this->_request->getParam("enddate");
//PESQUISA POR MAPA
$sector2 = $this->_request->getParam("sector2");
if ($sector2 == 'Nenhuma opção selecionada') {
$sector2 = null;
}
$cdmap = $this->_request->getParam("cdmap");
$homepage = $this->_request->getParam("homepage");
$lastpage = $this->_request->getParam("lastpage");
$dtfirstmaps = $this->_request->getParam("dtfirstmaps");
$dtendmaps = $this->_request->getParam("dtendmaps");
$array = array();
$requestModel->getAdapter()->beginTransaction();
try {
//PESQUISA POR PACIENTE
if (isset($cdpatient) && $cdpatient != null) {
$array['cdpatient'] = $cdpatient;
} else {
$array['cdpatient'] = null;
}
if (isset($cdrequest) && $cdrequest != null) {
$array['cdrequest'] = $cdrequest;
} else {
$array['cdrequest'] = null;
}
if (isset($nrsample) && $nrsample != null) {
$array['nrsample'] = $nrsample;
} else {
$array['nrsample'] = null;
}
if (isset($sector) && $sector != null) {
$array['sector'] = $sector;
} else {
$array['sector'] = null;
}
if (isset($startdate) && $startdate != null) {
$startdate = new Zend_Date($startdate, 'YYYY-MM-dd HH:mm:ss');
$array['startdate'] = $startdate->toString('YYYY-MM-dd HH:mm:ss');
} else {
$array['startdate'] = null;
}
if (isset($enddate) && $enddate != null) {
$enddate = new Zend_Date($enddate, 'YYYY-MM-dd HH:mm:ss');
$array['enddate'] = $enddate->toString('YYYY-MM-dd HH:mm:ss');
} else {
$array['enddate'] = null;
}
//PESQUISA POR MAPA DE TRABALHO
if (isset($sector2) && $sector2 != null) {
$array['sector2'] = $sector2;
} else {
$array['sector2'] = null;
}
if (isset($cdmap) && $cdmap != null) {
$array['cdmap'] = $cdmap;
} else {
$array['cdmap'] = null;
}
if (isset($homepage) && $homepage != null) {
$array['homepage'] = $homepage;
} else {
$array['homepage'] = null;
}
if (isset($lastpage) && $lastpage != null) {
$array['lastpage'] = $lastpage;
} else {
$array['lastpage'] = null;
}
if (isset($dtfirstmaps) && $dtfirstmaps != null) {
$dtfirstmaps = new Zend_Date($dtfirstmaps, 'YYYY-MM-dd HH:mm:ss');
$array['dtfirstmaps'] = $dtfirstmaps->toString('YYYY-MM-dd HH:mm:ss');
} else {
$array['dtfirstmaps'] = null;
}
if (isset($dtendmaps) && $dtendmaps != null) {
$dtendmaps = new Zend_Date($dtendmaps, 'YYYY-MM-dd HH:mm:ss');
$array['dtendmaps'] = $dtendmaps->toString('YYYY-MM-dd HH:mm:ss');
} else {
$array['dtendmaps'] = null;
}
// $array['cdpatient'], $array['cdrequest'], $array['nrsample'], $array['sector'], $array['startdate'], $array['enddate'], $array['sector2'], $array['cdplug'], $array['homepage'], $array['lastpage'], $array['dtfirstmaps'], $array['dtendmaps']
if ($array['cdpatient'] == null && $array['cdrequest'] == null && $array['nrsample'] == null && $array['sector'] == null && $array['startdate'] == null && $array['enddate'] == null && $array['sector2'] == null && $array['cdmap'] == null && $array['homepage'] == null && $array['lastpage'] == null && $array['dtfirstmaps'] == null && $array['dtendmaps'] == null) {
$dados = null;
$count = count($dados);
} else {
$dados = $requestModel->fetchAll($requestModel->getRequestsData($array, array(3)));
$count = count($dados);
$array['rows'] = $this->_request->getParam('rows');
$array['page'] = $this->_request->getParam('page');
$array['sidx'] = $this->_request->getParam('sidx');
$array['sord'] = $this->_request->getParam('sord');
$dados = $requestModel->fetchAll($requestModel->getRequestsData($array, array(3)));
}
if ($count > 0 && $limit > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$response = new stdClass();
$response->page = $page;
$response->total = $total_pages;
$response->records = $count;
$index = 0;
foreach ($dados as $row) {
switch ($row->fgstatus) {
case '1':
$fgcollection = "Coletado";
break;
case '2':
$fgcollection = "Faltante";
break;
case '3':
$fgcollection = "Em Mapa";
break;
case '4':
$fgcollection = "Lançada";
break;
case '5':
$fgcollection = "Conferida";
break;
}
$response->rows[$index]['cell'] = array($row['nmbarcodesample'], $fgcollection, $row['nmexamination'], $row['nmmaterial'], $row['nmclient'], $row['nmdepartment'], $row['cdrequest'], $row['cddepartment']);
$index++;
}
$this->view->dados = $response;
} catch (Exception $e) {
$requestModel->getAdapter()->rollback();
echo $e->getMessage();
}
}
public function printviewAction()
{
require_once 'fpdf/pdf.php';
$cdrequest = $_GET["cdrequest"];
$Request = new RequestModel();
$Attribute = new AttributeModel();
$AttributeExaminationMaterial = new AppraisalcontrolModel();
$Factor = new FactorModel();
$array = array();
$req = $Request->fetchAll($Request->getAllRequestData($cdrequest));
if (count($req) <= 0) {
die;
}
foreach ($req as $row) {
$dtbirth = new Zend_Date($row['dtbirth'], 'dd-MM-YYYY');
$dtrequest = new Zend_Date($row['dtrequest'], 'dd-MM-YYYY HH:mm:ss');
$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::calcAgeDifference($row['dtbirth']);
$idade = GslabUtils::calcula_idade($row['dtbirth']);
if ($tdMonth < $month || $tdMonth == $month && $tdDay < $day) {
$nrage--;
}
if ($row['fgsex'] == 1) {
$fgsex = "Masculino";
} else {
$fgsex = "Feminino";
}
$array['nmclient'] = $row['nmclient'];
$array['nmforward'] = $row['nmforward'];
$array['nmcompany'] = $row['nmcompany'];
$array['nmbarcodesample'] = $row['nmbarcodesample'];
$array['nmcovenant'] = $row['nmcovenant'];
$array['dtrequest'] = $dtrequest;
$array['idade'] = $nrage;
$array['sexo'] = $fgsex;
}
$GLOBALS = $array;
$ano = explode(" ", $nrage);
$pdf = new PDF();
$pdf->AddPage();
$pdf->ln(30);
$pdf->AliasNbPages('{total}');
$req2 = $Request->fetchAll($Request->getAllRequestData($cdrequest));
$appraisalCommon = AppraisalCommon::getInstance($this);
foreach ($req2 as $rows) {
$fgstatus = true;
/* NOME DO EXAME */
$pdf->SetFont('Courier', 'BI', 11);
$pdf->Cell(0, 10, strtoupper(utf8_decode($rows['nmexamination'])), 0, 2, 'L');
$pdf->SetFont('Courier', '', 9);
$pdf->Cell(0, 0, utf8_decode("Material: " . strtoupper($rows['nmmaterial'])), 0, 0, 'L');
$pdf->Cell(-30, 0, utf8_decode("Método: Automação CELL-DYN 3000/3500"), 0, 2, 'R');
$pdf->ln(2);
// $pdf->Cell(250, 5, utf8_decode("Valores referenciais"), 0, 1, 'C');
$pdf->ln(2);
$sons = $this->getExamSons($rows['cdexamination']);
if (count($sons) > 0) {
for ($aux_i = 0; $aux_i < count($sons); $aux_i++) {
$pdf->SetFont('Courier', '', 10);
$pdf->Cell(-360, 5, strtoupper(utf8_decode($sons[$aux_i]['nmexamination'])), 0, 0, 'L');
/* NOME DO ATRIBUTO E VALOR */
$attributes = $appraisalCommon->getExamAttribs($sons[$aux_i]['cdexaminationmaterial']);
//print_r($attributes);
$fgstatus = true;
foreach ($attributes as $attr) {
$vlattr = '';
$cdattr = '';
$obj = new stdClass();
$obj->cdexaminationmaterial = $sons[$aux_i]['cdexaminationmaterial'];
$obj->cdrequest = $cdrequest;
$obj->cdexamination = $rows['cdexamination'];
$obj->cdattribute = $attr['cdattribute'];
$vlattribute = $appraisalCommon->getAppraisalAttributeValue($obj);
foreach ($vlattribute as $kAttr => $vAttr) {
if ($kAttr == 'vlattribute') {
$vlattr = $vAttr['vlattribute'];
}
if ($kAttr == 'cdattribute') {
$cdattr = $vAttr['cdattribute'];
}
}
$AttributeData = $Attribute->fetchAll($Attribute->getAtributeNotation($cdattr));
foreach ($AttributeData as $key => $value) {
if ($key == 'idnotation') {
$idnotation = $value['idnotation'];
}
}
$pdf->SetFont('Courier', '', 10);
$pdf->ln();
$pdf->Cell(40, 5, " " . str_pad(utf8_decode($attr['nmattribute']), 15, "."), 0, 0, 'L');
$pdf->SetFont('Courier', 'B', 10);
$pdf->Cell(65, 5, str_pad($vlattr . " " . $idnotation, 15, ".", STR_PAD_LEFT), 0, 0, 'L');
$ref = $appraisalCommon->getExamFactors($sons[$aux_i]['cdexaminationmaterial'], $cdattr);
foreach ($ref as $vlref) {
if ($vlref['fgfactor'] == 1) {
$fator = "Idade Valores referenciais";
} else {
if ($vlref['fgfactor'] == 2) {
$fator = "Masculino Feminino";
} else {
if ($vlref['fgfactor'] == 3) {
$fator = "Idade Masculino Feminino";
}
}
}
}
if ($fgstatus == true) {
$pdf->Cell(-1);
$pdf->Cell(1, -5, $fator, 0, 0, 'L');
$fgstatus = false;
}
/* VALORES DE REFERÊNCIA */
foreach ($ref as $vlref) {
/*
* AQUI SÃO DEFINIDAS AS REGRAS DE EXIBIÇÃO DO PDF, COLUNAS POR IDADE, SEXO OU AMBOS:
*
* fgfactor = 1
* ATRIBUTO........VALOR IDADE REFERÊNCIA
*
* fgfactor = 2
* ATRIBUTO........VALOR MASCULINO FEMININO
*
* fgfactor = 3
* ATRIBUTO........VALOR IDADE MASCULINO FEMININO
*
*/
$pdf->SetFont('Courier', '', 9);
/* DEFINE QUAL CAMPO DA TABELA ESTÁ PREENCHIDO (VALOR OU NUMÉRICO) E ALOCA À UMA VARIÁVEL */
if ($vlref['nrminvalue'] == '' && $vlref['nrmaxvalue'] == '' && $vlref['vlminvalue'] != '' && $vlref['vlmaxvalue'] != '') {
$minvalue = $vlref['vlminvalue'];
$maxvalue = $vlref['vlmaxvalue'];
} else {
if ($vlref['nrminvalue'] != '' && $vlref['nrmaxvalue'] != '' && $vlref['vlminvalue'] == '' && $vlref['vlmaxvalue'] == '') {
$minvalue = $vlref['nrminvalue'];
$maxvalue = $vlref['nrmaxvalue'];
}
}
if ($vlref['fgfactor'] == 1) {
//SEPARADOS PELA IDADE, DEFINE UMA COLUNA DE RESULTADOS
if ($vlref['nrminage'] <= $ano[0] && $vlref['nrmaxage'] >= $ano[0]) {
$pdf->Cell(12, 5, utf8_decode($vlref['nrminage'] . " à " . $vlref['nrmaxage'] . " " . $vlref['nmtimetype']), 0, 0, 'R');
$pdf->Cell(67, 5, utf8_decode($minvalue . " à " . $maxvalue), 0, 0, 'R');
}
} else {
if ($vlref['fgfactor'] == 2) {
//SEPARADOS PELO SEXO, DEFINE DUAS COLUNAS DE RESULTADOS
if ($vlref['fggender'] == 1) {
// MASCULINO
$pdf->Cell(20, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 0, 'R');
} else {
if ($vlref['fggender'] == 2) {
// FEMININO
$pdf->Cell(60, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 1, 'R');
}
}
} else {
if ($vlref['fgfactor'] == 3) {
//SEPARADOS PELO SEXO E IDADE, DEFINE TRÊS COLUNAS DE RESULTADOS
if ($vlref['fggender'] == 1) {
// MASCULINO
$pdf->Cell(12, 5, utf8_decode($vlref['nrminage'] . " à " . $vlref['nrmaxage'] . " " . $vlref['nmtimetype']), 0, 0, 'R');
$pdf->Cell(33, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 0, 'R');
} else {
if ($vlref['fggender'] == 2) {
// FEMININO
$pdf->Cell(35, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 1, 'R');
}
}
}
}
}
}
unset($obj);
}
$pdf->ln();
$pdf->ln();
}
}
}
$pdf->Output();
//IMPRIME O PDF NA TELA
$pdf->Output("teste.pdf");
//IMPRIME O PDF NO ARQUIVO
}
protected function initValidators()
{
parent::addValidator('name', 'StringEmpty', self::ERROR_NAME_IS_REQUIRED);
parent::addValidator('email', 'Email', self::ERROR_EMAIL_IS_NOT_VALID);
parent::addValidator('message', 'StringLength', self::ERROR_MESSAGE_IS_WRONG_FORMAT);
}
public function searchAction()
{
$var = $this->_request->getParams();
$controlbillingModel = new RequestModel();
// <- Instanciando a classe Request
$cdcovenant = $this->_request->getParam("cdcovenant");
$nmcolectionplace = $this->_request->getParam("nmcolectionplace");
$nmdepartament = $this->_request->getParam("nmdepartament");
$fgstatus = $this->_request->getParam("fgstatus");
$nmpacient = $this->_request->getParam("nmpacient");
$responsible = $this->_request->getParam("responsible");
$dtbegindate = $this->_request->getParam("dtbegindate");
$dtenddate = $this->_request->getParam("dtenddate");
$timebeginhour = $this->_request->getParam("timebeginhour");
$timeendhour = $this->_request->getParam("timeendhour");
$nrlot = $this->_request->getParam("nrlot");
$dtmaturity = $this->_request->getParam("dtmaturity");
$array = array();
$controlbillingModel->getAdapter()->beginTransaction();
try {
if (isset($cdcovenant) && $cdcovenant != '') {
$array['cdcovenant'] = $cdcovenant;
} else {
$array['cdcovenant'] = '';
}
if (isset($nmcolectionplace) && $nmcolectionplace != '') {
$array['nmcolectionplace'] = $nmcolectionplace;
} else {
$array['nmcolectionplace'] = '';
}
if (isset($nmdepartament) && $nmdepartament != '') {
$array['nmdepartament'] = $nmdepartament;
} else {
$array['nmdepartament'] = '';
}
if (isset($fgstatus) && $fgstatus != '') {
$array['fgstatus'] = $fgstatus;
} else {
$array['fgstatus'] = '';
}
if (isset($nmpacient) && $nmpacient != '') {
$array['nmpacient'] = $nmpacient;
} else {
$array['nmpacient'] = '';
}
if (isset($responsible) && $responsible != '') {
$array['responsible'] = $responsible;
} else {
$array['responsible'] = '';
}
if (isset($dtbegindate) && $dtbegindate != '') {
$array['dtbegindate'] = $dtbegindate;
} else {
$array['dtbegindate'] = '';
}
if (isset($dtenddate) && $dtenddate != '') {
$array['dtenddate'] = $dtenddate;
} else {
$array['dtenddate'] = '';
}
if (isset($timebeginhour) && $timebeginhour != '') {
$array['timebeginhour'] = $timebeginhour;
} else {
$array['timebeginhour'] = '';
}
if (isset($timeendhour) && $timeendhour != '') {
$array['timeendhour'] = $timeendhour;
} else {
$array['timeendhour'] = '';
}
if (isset($nrlot) && $nrlot != '') {
$array['nrlot'] = $nrlot;
} else {
$array['nrlot'] = '';
}
if (isset($dtmaturity) && $dtmaturity != '') {
$array['dtmaturity'] = $dtmaturity;
} else {
$array['dtmaturity'] = '';
}
$dados = $controlbillingModel->fetchAll($controlbillingModel->getControlbillingRequest($array['cdcovenant'], $array['dtbegindate'], $array['dtenddate'], $array['timebeginhour'], $array['timeendhour']));
print_r($dados);
$dadoscontrol = $controlbillingModel->fetchAll($controlbillingModel->getBillingdadosRequest($array['nmpacient']));
} catch (Exception $e) {
$controlbillingModel->getAdapter()->rollback();
echo $e->getMessage();
}
}
public function printviewAction()
{
require_once 'fpdf/pdf.php';
$cdrequest = $_GET["cdrequest"];
$Request = new RequestModel();
$Factor = new FactorModel();
$Method = new MethodModel();
$Comment = new AppraisalcommentModel();
$Patterntext = new PatterntextModel();
$array = array();
$req = $Request->fetchAll($Request->getAllRequestData($cdrequest));
if (count($req) <= 0) {
die;
}
foreach ($req as $row) {
$dtbirth = new Zend_Date($row['dtbirth'], 'dd-MM-YYYY');
$dtrequest = new Zend_Date($row['dtrequest'], 'dd-MM-YYYY HH:mm:ss');
$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::calcAgeDifference($row['dtbirth']);
$idade = GslabUtils::calcula_idade($row['dtbirth']);
if ($tdMonth < $month || $tdMonth == $month && $tdDay < $day) {
$nrage--;
}
if ($row['fgsex'] == 1) {
$fgsex = "Masculino";
} else {
$fgsex = "Feminino";
}
$array['nmclient'] = $row['nmclient'];
$array['nmforward'] = $row['nmforward'];
$array['nmcompany'] = $row['nmcompany'];
$array['nmbarcodesample'] = $row['nmbarcodesample'];
$array['nmcovenant'] = $row['nmcovenant'];
$array['dtrequest'] = $dtrequest;
$array['idade'] = $nrage;
$array['sexo'] = $fgsex;
}
$GLOBALS = $array;
$ano = explode(" ", $nrage);
$pdf = new PDF();
$pdf->AddPage();
$pdf->ln(30);
$pdf->AliasNbPages('{total}');
$req2 = $Request->fetchAll($Request->getAllRequestData($cdrequest));
foreach ($req2 as $rows) {
$comentario_text = '';
/* COMENTÁRIO DOS EXAMES */
$comments = $Comment->fetchRow($Comment->getAppraisalComments($rows['cdrequestexamination']));
if (count($comments) > 0) {
$dscomment = explode(',', $comments->dscomment);
foreach ($dscomment as $comm) {
$comentario = $Patterntext->fetchRow($Patterntext->getPatterntextById($comm));
$comentario_text .= utf8_decode($comentario->dspatterntext) . "\n";
}
} else {
$comentario_text = '';
}
/* MÉTODO DOS EXAMES */
$method = $Method->fetchRow($Method->getMethodByCd($rows['cdmethod']));
$metodo = utf8_decode("Método: " . $method->nmmethod);
$fgstatus = true;
/* NOME DO EXAME */
$pdf->SetFont('Courier', 'BI', 11);
$pdf->Cell(0, 10, strtoupper(utf8_decode($rows['nmexamination'])), 0, 2, 'L');
$pdf->SetFont('Courier', '', 9);
$pdf->Cell(0, 0, utf8_decode("Material: " . strtoupper($rows['nmmaterial'])), 0, 0, 'L');
$pdf->Cell(-30, 0, $metodo, 0, 1, 'R');
$pdf->ln(2);
$pdf->ln(2);
$sons = $this->getExamSons($rows['cdexamination'], $cdrequest);
if (count($sons) > 0) {
for ($aux_i = 0; $aux_i < count($sons); $aux_i++) {
$pdf->SetFont('Courier', '', 9);
$pdf->Cell(-15, 5, strtoupper(utf8_decode($sons[$aux_i]['nmexamination'])), 0, 0, 'L');
/* NOME DO ATRIBUTO E VALOR */
$attributes = $this->getAttrValues($sons[$aux_i]['cdrequestexamination'], $sons[$aux_i]['cdexaminationmaterial']);
if ($sons[$aux_i]['fgpercentage'] == 1) {
$soma = 0;
foreach ($attributes as $sum) {
$soma = $soma + $sum['vlattribute'];
}
$valor_calc = $soma / 100;
$pdf->SetFont('Courier', 'B', 9);
$pdf->Cell(100, 5, "%", 0, 0, 'R');
}
$fgstatus = true;
foreach ($attributes as $attr) {
if ($sons[$aux_i]['fgpercentage'] == 1) {
$valor = round($attr['vlattribute'] / $valor_calc, 1);
$n = explode(".", $valor);
if ($n[1] < 5 && $n[1] != 5) {
$vl_at = floor($valor);
} else {
if ($n[1] > 5 && $n[1] != 5) {
$vl_at = ceil($valor);
} else {
if ($n[1] == 5) {
$vl_at = $valor;
}
}
}
} else {
$vl_at = '';
$valor = '';
}
$pdf->SetFont('Courier', '', 9);
$pdf->ln();
$pdf->Cell(40, 5, " " . str_pad(utf8_decode($attr['nmattribute']), 18, "."), 0, 0, 'L');
$pdf->SetFont('Courier', 'B', 9);
$pdf->Cell(65, 5, str_pad(utf8_decode($attr['vlattribute']) . " " . utf8_decode($attr['idnotation']), 15, ".", STR_PAD_LEFT) . " " . $vl_at, 0, 0, 'L');
$ref = $Factor->fetchAll($Factor->getAllFactors($attr['cdattribute']));
// var_dump($ref);die;
foreach ($ref as $vlref) {
if ($vlref['fgfactor'] == 1) {
$fator = "Idade Valores referenciais";
} else {
if ($vlref['fgfactor'] == 2) {
$fator = "Masculino Feminino";
} else {
if ($vlref['fgfactor'] == 3) {
$fator = "Idade Masculino Feminino";
}
}
}
}
if ($fgstatus == true) {
$pdf->Cell(-1);
$pdf->Cell(1, -5, $fator, 0, 0, 'L');
$fgstatus = false;
}
/* VALORES DE REFERÊNCIA */
foreach ($ref as $vlref) {
/*
* AQUI SÃO DEFINIDAS AS REGRAS DE EXIBIÇÃO DO PDF, COLUNAS POR IDADE, SEXO OU AMBOS:
*
* fgfactor = 1
* ATRIBUTO........VALOR IDADE REFERÊNCIA
*
* fgfactor = 2
* ATRIBUTO........VALOR MASCULINO FEMININO
*
* fgfactor = 3
* ATRIBUTO........VALOR IDADE MASCULINO FEMININO
*
*/
$pdf->SetFont('Courier', '', 8);
/* DEFINE QUAL CAMPO DA TABELA ESTÁ PREENCHIDO (VALOR OU NUMÉRICO) E ALOCA À UMA VARIÁVEL */
if ($vlref['nrminvalue'] == '' && $vlref['nrmaxvalue'] == '' && $vlref['vlminvalue'] != '' && $vlref['vlmaxvalue'] != '') {
$minvalue = $vlref['vlminvalue'];
$maxvalue = $vlref['vlmaxvalue'];
} else {
if ($vlref['nrminvalue'] != '' && $vlref['nrmaxvalue'] != '' && $vlref['vlminvalue'] == '' && $vlref['vlmaxvalue'] == '') {
$minvalue = $vlref['nrminvalue'];
$maxvalue = $vlref['nrmaxvalue'];
}
}
if ($vlref['fgfactor'] == 1) {
//SEPARADOS PELA IDADE, DEFINE UMA COLUNA DE RESULTADOS
if ($vlref['nrminage'] <= $ano[0] && $vlref['nrmaxage'] >= $ano[0]) {
$pdf->Cell(12, 5, utf8_decode($vlref['nrminage'] . " à " . $vlref['nrmaxage'] . " " . $vlref['nmtimetype']), 0, 0, 'R');
$pdf->Cell(67, 5, utf8_decode($minvalue . " à " . $maxvalue), 0, 0, 'R');
}
} else {
if ($vlref['fgfactor'] == 2) {
//SEPARADOS PELO SEXO, DEFINE DUAS COLUNAS DE RESULTADOS
if ($vlref['fggender'] == 1) {
// MASCULINO
$pdf->Cell(20, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 0, 'R');
} else {
if ($vlref['fggender'] == 2) {
// FEMININO
$pdf->Cell(60, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 0, 'R');
}
}
} else {
if ($vlref['fgfactor'] == 3) {
//SEPARADOS PELO SEXO E IDADE, DEFINE TRÊS COLUNAS DE RESULTADOS
if ($vlref['fggender'] == 1) {
// MASCULINO
$pdf->Cell(12, 5, utf8_decode($vlref['nrminage'] . " à " . $vlref['nrmaxage'] . " " . $vlref['nmtimetype']), 0, 0, 'R');
$pdf->Cell(33, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 0, 'R');
} else {
if ($vlref['fggender'] == 2) {
// FEMININO
$pdf->Cell(35, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 0, 'R');
}
}
}
}
}
}
}
$pdf->ln();
$pdf->ln();
}
} else {
$examination = $this->getExam($rows['cdexamination'], $cdrequest);
for ($aux_i = 0; $aux_i < count($examination); $aux_i++) {
/* NOME DO ATRIBUTO E VALOR */
$attributes = $this->getAttrValues($examination[$aux_i]['cdrequestexamination'], $examination[$aux_i]['cdexaminationmaterial']);
if ($examination[$aux_i]['fgpercentage'] == 1) {
$soma = 0;
foreach ($attributes as $sum) {
$soma = $soma + $sum['vlattribute'];
}
$valor_calc = $soma / 100;
$pdf->SetFont('Courier', 'B', 9);
$pdf->Cell(83, 5, "%", 0, 0, 'R');
}
$rangeruleCount = count($attributes);
$fgstatus = true;
foreach ($attributes as $attr) {
if ($examination[$aux_i]['fgpercentage'] == 1) {
$valor = round($attr['vlattribute'] / $valor_calc, 1);
$n = explode(".", $valor);
if ($n[1] < 5 && $n[1] != 5) {
$vl_at = floor($valor);
} else {
if ($n[1] > 5 && $n[1] != 5) {
$vl_at = ceil($valor);
} else {
if ($n[1] == 5) {
$vl_at = $valor;
}
}
}
} else {
$vl_at = '';
$valor = '';
}
$pdf->SetFont('Courier', '', 9);
$pdf->ln();
$pdf->Cell(40, 15, " " . str_pad(utf8_decode($attr['nmattribute']), 18, "."), 0, 0, 'L');
$pdf->SetFont('Courier', 'B', 9);
$pdf->Cell(65, 15, str_pad($attr['vlattribute'] . " " . $attr['idnotation'], 15, ".", STR_PAD_LEFT) . " " . $vl_at, 0, 0, 'L');
$ref = $Factor->fetchAll($Factor->getAllFactors($attr['cdattribute']));
foreach ($ref as $vlref) {
if ($vlref['fgfactor'] == 1) {
$fator = "Idade Valores referenciais";
} else {
if ($vlref['fgfactor'] == 2) {
$fator = "Masculino Feminino";
} else {
if ($vlref['fgfactor'] == 3) {
$fator = "Idade Masculino Feminino";
}
}
}
}
if ($fgstatus == true) {
$pdf->Cell(-1);
$pdf->Cell(1, 5, $fator, 0, 0, 'L');
$fgstatus = false;
}
/* VALORES DE REFERÊNCIA */
foreach ($ref as $vlref) {
/*
* AQUI SÃO DEFINIDAS AS REGRAS DE EXIBIÇÃO DO PDF, COLUNAS POR IDADE, SEXO OU AMBOS:
*
* fgfactor = 1
* ATRIBUTO........VALOR IDADE REFERÊNCIA
*
* fgfactor = 2
* ATRIBUTO........VALOR MASCULINO FEMININO
*
* fgfactor = 3
* ATRIBUTO........VALOR IDADE MASCULINO FEMININO
*
*/
$pdf->SetFont('Courier', '', 8);
$imgRR = "./images/result/rangerule_img-" . $attr['cdrequestexamination'] . "_" . $rows['cdexamination'] . "_" . $attr['cdattribute'] . "_" . $examination[$aux_i]['cdexaminationmaterial'] . ".png";
/* DEFINE QUAL CAMPO DA TABELA ESTÁ PREENCHIDO (VALOR OU NUMÉRICO) E ALOCA À UMA VARIÁVEL */
if ($vlref['nrminvalue'] == '' && $vlref['nrmaxvalue'] == '' && $vlref['vlminvalue'] != '' && $vlref['vlmaxvalue'] != '') {
$minvalue = $vlref['vlminvalue'];
$maxvalue = $vlref['vlmaxvalue'];
} else {
if ($vlref['nrminvalue'] != '' && $vlref['nrmaxvalue'] != '' && $vlref['vlminvalue'] == '' && $vlref['vlmaxvalue'] == '') {
$minvalue = $vlref['nrminvalue'];
$maxvalue = $vlref['nrmaxvalue'];
}
}
if ($vlref['fgfactor'] == 1) {
//SEPARADOS PELA IDADE, DEFINE UMA COLUNA DE RESULTADOS
if ($vlref['nrminage'] <= $ano[0] && $vlref['nrmaxage'] >= $ano[0]) {
$pdf->Cell(12, 15, utf8_decode($vlref['nrminage'] . " à " . $vlref['nrmaxage'] . " " . $vlref['nmtimetype']), 0, 0, 'R');
if ($rangeruleCount == 1) {
$pdf->Cell(40, 50, $pdf->Image($imgRR, $pdf->GetX() + 5, $pdf->GetY() + 6, 70), 0, 0, 'L', false);
}
$pdf->Cell(67, 8, utf8_decode($minvalue . " à " . $maxvalue), 0, 0, 'R');
}
} else {
if ($vlref['fgfactor'] == 2) {
//SEPARADOS PELO SEXO, DEFINE DUAS COLUNAS DE RESULTADOS
if ($vlref['fggender'] == 1) {
// MASCULINO
$pdf->Cell(20, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 0, 'R');
} else {
if ($vlref['fggender'] == 2) {
// FEMININO
$pdf->Cell(60, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 1, 'R');
}
}
} else {
if ($vlref['fgfactor'] == 3) {
//SEPARADOS PELO SEXO E IDADE, DEFINE TRÊS COLUNAS DE RESULTADOS
if ($vlref['fggender'] == 1) {
// MASCULINO
$pdf->Cell(12, 5, utf8_decode($vlref['nrminage'] . " à " . $vlref['nrmaxage'] . " " . $vlref['nmtimetype']), 0, 0, 'R');
$pdf->Cell(33, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 0, 'R');
} else {
if ($vlref['fggender'] == 2) {
// FEMININO
$pdf->Cell(35, 5, utf8_decode($vlref['vlminvalue'] . " à " . $vlref['vlmaxvalue']), 0, 1, 'R');
}
}
}
}
}
}
}
$pdf->ln();
$pdf->ln();
}
}
if (count($comments) > 0) {
$pdf->SetFont('Courier', 'B', 9);
$pdf->Cell(5, 2, utf8_decode("Observações: "), 0, 1, 'L');
$pdf->ln();
$pdf->SetFont('Courier', '', 7);
$pdf->Multicell(0, 3, $comentario_text);
$pdf->ln();
}
}
$pdf->Output();
//IMPRIME O PDF NA TELA
$pdf->Output('teste.pdf', "D");
//IMPRIME O PDF NO ARQUIVO
}
public function searchAction()
{
//Parâmetros da pesquisa em comum
$searchDataArray = array();
$searchDataArray['startDate'] = $this->_request->getParam("startDate");
$searchDataArray['endDate'] = $this->_request->getParam("endDate");
$searchDataArray['sector'] = $this->_request->getParam("cddepartment");
//paciente
$searchDataArray['nrsample'] = $this->_request->getParam("nrsample");
$searchDataArray['cdrequest'] = $this->_request->getParam("cdrequest");
$searchDataArray['cdpatient'] = $this->_request->getParam("cdpatient");
//ficha - mapa de trabalho
$searchDataArray['cdmap'] = $this->_request->getParam("nrplug");
$searchDataArray['startPage'] = $this->_request->getParam("nrhomepage");
$searchDataArray['endPage'] = $this->_request->getParam("nrlastpage");
//ultimos resultados
$searchDataArray['startTime'] = $this->_request->getParam("startTime");
$searchDataArray['endTime'] = $this->_request->getParam("endTime");
$request = new RequestModel();
$dados = $request->fetchAll($request->getRequestsData($searchDataArray, array(4)));
$response = new stdClass();
$index = 0;
foreach ($dados as $row) {
switch ($row['fgstatus']) {
case 4:
$fgstatus = "Lançada";
break;
default:
$fgstatus = "ERRO!";
// Não deve cair aqui pois ainda não está lançado, logo nãpo há conferência
break;
}
$response->rows[$index]['cell'] = array($row['nmbarcodesample'], $fgstatus, $row['idexamination'], $row['idmaterial'], $row['nmclient'], $row['nmdepartment'], $row['cdrequest']);
$index++;
}
$response = json_encode($response);
print_r($response);
return $response;
}
protected function initValidators()
{
parent::addValidator('name', 'StringEmpty', self::ERROR_NAME_IS_REQUIRED);
parent::addValidator('password', 'StringEmpty', self::ERROR_PASSWORD_IS_REQUIRED);
}
public function searchAction()
{
//funcao para realizar busca ao BD
$var = $this->_request->getParams();
//Passando os parâmetros para vetores... através do método Request
$patientsituationModel = new RequestModel();
// <- Instanciando a classe Request
$cdpatient = $this->_request->getParam("cdpacient");
// passando o valor dos parâmetros para as variaveis
$requisicion = $this->_request->getParam("requisicion");
$cdagemin = $this->_request->getParam("nrminage");
$cdagemax = $this->_request->getParam("nrmaxage");
$fgvip = $this->_request->getParam("vip");
$maladireta = $this->_request->getParam("maladireta");
$amostra = $this->_request->getParam("amostra");
$urgente = $this->_request->getParam("urgente");
$convenio = $this->_request->getParam("convenio");
$historicexamination = $this->_request->getParam("historicexamination");
$cdclientrequest = $this->_request->getParam("cdclientrequest");
$cdexamination = $this->_request->getParam("cdexamination");
////O metodo FetchAll, faz a consulta ao banco de dados(RequestModel) buscando todos os valores da classe instanciada
// print_r($_POST);die;
//O metodo beginTransaction inicia uma transaçao com o banco de dados
$array = array();
$patientsituationModel->getAdapter()->beginTransaction();
try {
if (isset($cdpatient) && $cdpatient != '') {
$array['cdpacient'] = $cdpatient;
} else {
$array['cdpacient'] = '';
}
if (isset($requisicion) && $requisicion != '') {
$array['requisicion'] = $requisicion;
} else {
$array['requisicion'] = '';
}
if (isset($amostra) && $amostra != '') {
$array['amostra'] = $amostra;
} else {
$array['amostra'] = '';
}
if (isset($urgente) && $urgente != '') {
$array['urgente'] = $urgente;
} else {
$array['urgente'] = '';
}
if (isset($fgvip) && $fgvip != '') {
$array['vip'] = $fgvip;
} else {
$array['vip'] = '';
}
if (isset($maladireta) && $maladireta != '') {
$array['maladireta'] = $maladireta;
} else {
$array['maladireta'] = '';
}
if (isset($cdagemax) && $cdagemax != '') {
$array['nrmaxage'] = $cdagemax;
} else {
$array['nrmaxage'] = '';
}
if (isset($cdagemin) && $cdagemin != '') {
$array['nrminage'] = $cdagemin;
} else {
$array['nrminage'] = '';
}
if (isset($convenio) && $convenio != '') {
$array['convenio'] = $convenio;
} else {
$array['convenio'] = '';
}
if (isset($historicexamination) && $historicexamination != '') {
$array['historicexamination'] = $historicexamination;
} else {
$array['historicexamination'] = '';
}
if (isset($cdclientrequest) && $cdclientrequest != '') {
$array['cdclientrequest'] = $cdclientrequest;
} else {
$array['cdclientrequest'] = '';
}
if (isset($cdexamination) && $cdexamination != '') {
$array['cdexamination'] = $cdexamination;
} else {
$array['cdexamination'] = '';
}
/*$dadospatient = $patientsituationModel->fetchAll($patientsituationModel->getPatientSituationCdRequest($array['cdpacient'], $array['requisicion'],
$array['amostra'], $array['vip'], $array['maladireta'], $array['urgente'], $array['convenio'], $array['historicexamination']));
$dadosnmrequest = $patientsituationModel->fetchAll($patientsituationModel->getPatientSituationNmRequest($array['cdclientrequest']));*/
$dadosnmexamination = $patientsituationModel->fetchAll($patientsituationModel->getNmexaminationTotal($array['cdexamination']));
print_r($dadosnmexamination);
die;
} catch (Exception $e) {
/* O método rollBack()faz o oposto: ele descarta as alterações feitas durante sua transação. As mudanças são efetivamente desfeitas, e o estado dos dados retorna a como
ele era antes de você começar sua transação. Entretanto, descartar sua transação não tem efeito sobre mudanças feitas por outras transações rodando concorrentemente. */
$patientsituationModel->getAdapter()->rollback();
echo $e->getMessage();
}
/* $index = 0;
foreach ($dados as $l) {
$responce->rows[$index]['cdexamination'] = $row->cdexamination;
$responce->rows[$index]['cell'] = array(
$row->cdseqexamination,
$row->nmsynonymous,
$row->cdexamination,
$row->nmexamination
//$row->cdsupply
//$row->nmsupply
//$row->dtcollect
//$row->dtresult
/*foreach($dados as $linha){
echo " {
nmclient:".$linha['nmclient'].",
idade:".$linha['age'].",
cdclientrequest:".$linha['cdclientrequest'].",
cdexamination:".$linha['cdexamination'].",
cdcovenante:".$linha['cdcovenant'].",
vip:".$linha['vip'].",
}";
}
//enviar para index o resultado da consulta*/
}
