public ArrayList<LabResultData> populatePathnetResultsData( String providerNo, String demographicNo, String patientFirstName, String patientLastName, String patientHealthNumber, String status) { if (providerNo == null) { providerNo = ""; } if (patientFirstName == null) { patientFirstName = ""; } if (patientLastName == null) { patientLastName = ""; } if (patientHealthNumber == null) { patientHealthNumber = ""; } if (status == null) { status = ""; } ArrayList<LabResultData> labResults = new ArrayList<LabResultData>(); try { Hl7MshDao dao = SpringUtils.getBean(Hl7MshDao.class); List<Object[]> pathnetResultsData; if (demographicNo == null) { pathnetResultsData = dao.findPathnetResultsDataByPatientNameHinStatusAndProvider( patientLastName + "%^" + patientFirstName + "%", "%" + patientHealthNumber + "%", "%" + status + "%", providerNo.equals("") ? "%" : providerNo, "BCP"); } else { pathnetResultsData = dao.findPathnetResultsDeomgraphicNo( ConversionUtils.fromIntString(demographicNo), "BCP"); } for (Object[] o : pathnetResultsData) { Hl7Msh msh = (Hl7Msh) o[0]; Hl7Pid pid = (Hl7Pid) o[1]; Hl7Orc orc = (Hl7Orc) o[2]; ProviderLabRoutingModel p = (ProviderLabRoutingModel) o[4]; Long stat = (Long) o[5]; LabResultData lbData = new LabResultData(LabResultData.EXCELLERIS); lbData.labType = LabResultData.EXCELLERIS; lbData.segmentID = "" + pid.getMessageId(); if (demographicNo == null && !providerNo.equals("0")) { lbData.acknowledgedStatus = p.getStatus(); } else { lbData.acknowledgedStatus = "U"; } lbData.accessionNumber = justGetAccessionNumber(orc.getFillerOrderNumber()); lbData.healthNumber = pid.getExternalId(); lbData.patientName = pid.getPatientName(); if (lbData.patientName != null) { lbData.patientName = lbData.patientName.replaceAll("\\^", " "); } lbData.sex = pid.getSex(); lbData.resultStatus = "0"; // TODO // solve lbData.resultStatus.add(oscar.Misc.getString(rs,"abnormalFlag")); lbData.dateTime = ConversionUtils.toTimestampString(msh.getDateTime()); // priority lbData.priority = "----"; lbData.requestingClient = justGetDocName(orc.getOrderingProvider()); lbData.reportStatus = "" + stat; if (lbData.reportStatus != null && lbData.reportStatus.equals("F")) { lbData.finalRes = true; } else { lbData.finalRes = false; } labResults.add(lbData); } } catch (Exception e) { logger.error("exception in pathnetPopulate", e); } return labResults; }