public DiagLiteVoCollection listDiagnosis(String name) { // Use StringBuilder to build the HQL query (more memory efficient) StringBuilder hqlQuery = new StringBuilder(); hqlQuery.append("from Diagnosis as diag"); ArrayList<String> paramNames = new ArrayList<String>(); ArrayList<Object> paramValues = new ArrayList<Object>(); // Create parameters string if (name != null && name.length() > 0) { hqlQuery.append(" where UPPER(diag.diagnosisName) like :NAME"); paramNames.add("NAME"); paramValues.add("%" + name.toUpperCase() + "%"); } // Set order mode hqlQuery.append(" order by UPPER(diag.diagnosisName) asc"); return DiagLiteVoAssembler.createDiagLiteVoCollectionFromDiagnosis(getDomainFactory().find(hqlQuery.toString(), paramNames, paramValues)); }
public ims.core.vo.DiagLiteVoCollection listDiagnosis(String filterName) { String hql = "from Diagnosis as d1_1 where " + "(UPPER(d1_1.diagnosisName) like :nameFilter and d1_1.isActive = 1) " + "order by d1_1.diagnosisName asc"; List<?> result = getDomainFactory().find(hql,"nameFilter","%"+filterName.toUpperCase()+"%"); //wdev-16291 if (result == null || result.size() == 0) return null; return DiagLiteVoAssembler.createDiagLiteVoCollectionFromDiagnosis(result); }
/** * List of Diagnoses to choose from * @throws DomainInterfaceException */ public ims.core.vo.DiagLiteVoCollection listDiagnosisLiteVo(String filter) throws DomainInterfaceException { DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer(" from Diagnosis d join d.keywords as kw "); ArrayList names = new ArrayList(); ArrayList values = new ArrayList(); hql.append(" where d.isActive = :isActive"); names.add("isActive"); values.add(Boolean.TRUE); return DiagLiteVoAssembler.createDiagLiteVoCollectionFromDiagnosis(Keywords.searchByKeywords(factory, filter, hql.toString(), names, values)); }
/** * listHotListDiagnosis * @throws DomainInterfaceException */ public ims.core.vo.DiagLiteVoCollection listHotListDiagnosis(String name, ims.core.vo.lookups.Specialty specialty) throws DomainInterfaceException { if(name == null) throw new DomainRuntimeException("Invalid Search criteria. Diagnosis name filter must be supplied."); if(specialty == null) throw new DomainRuntimeException("Invalid Search criteria. Specialty must be supplied."); DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer("select distinct diagHotListItem from DiagnosisHotlist as diagHotList left join diagHotList.hotListItem as diagHotListItem left join diagHotListItem.diagnosis as diag left join diag.keywords as kw "); ArrayList names = new ArrayList(); ArrayList values = new ArrayList(); hql.append(" where diag.isActive = :isActive"); names.add("isActive"); values.add(Boolean.TRUE); hql.append(" and diagHotList.specialty = :spec"); names.add("spec"); values.add(getDomLookup(specialty)); List hits = Keywords.searchByKeywords(factory, name, hql.toString(), names, values); List diags = new ArrayList(); for (int i = 0; i < hits.size(); i++) { diags.add(((DiagnosisHotlistItem)hits.get(i)).getDiagnosis()); } return DiagLiteVoAssembler.createDiagLiteVoCollectionFromDiagnosis(diags); }
public DiagLiteVoCollection listHotListDiagnosis(String diagName, Specialty specialty) throws DomainInterfaceException { if(diagName == null) throw new DomainRuntimeException("Invalid Search criteria. Diagnosis name filter must be supplied."); if(specialty == null) throw new DomainRuntimeException("Invalid Search criteria. Specialty must be supplied."); DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer(" select distinct item from DiagnosisHotlistItem item join item.diagnosis as diag join diag.keywords as kw "); ArrayList names = new ArrayList(); ArrayList values = new ArrayList(); hql.append(" where diag.isActive = :isActive"); names.add("isActive"); values.add(Boolean.TRUE); hql.append(" and item.hotlist.specialty = :spec"); names.add("spec"); values.add(getDomLookup(specialty)); List hits = Keywords.searchByKeywords(factory, diagName, hql.toString(), names, values); List diags = new ArrayList(); for (int i = 0; i < hits.size(); i++) { diags.add(((DiagnosisHotlistItem)hits.get(i)).getDiagnosis()); } return DiagLiteVoAssembler.createDiagLiteVoCollectionFromDiagnosis(diags); }
public ims.core.vo.DiagLiteVoCollection getDiagnoses(String ids, String diagnosisName) { ArrayList<String> markers = new ArrayList<String>(); ArrayList<Object> values = new ArrayList<Object>(); StringBuffer hql = new StringBuffer(); hql.append(" select diag from Diagnosis as diag where diag.isActive = 1"); if (ids != "") { hql.append(" and diag.id not in (" + ids + ")"); } if (diagnosisName != null) { diagnosisName.trim(); diagnosisName = diagnosisName.toUpperCase(); diagnosisName = "%" + diagnosisName + "%"; hql.append(" and UPPER(diag.diagnosisName) like :diagName "); markers.add("diagName"); values.add(diagnosisName); } hql.append(" order by diag.diagnosisName asc"); return DiagLiteVoAssembler.createDiagLiteVoCollectionFromDiagnosis(getDomainFactory().find(hql.toString(), markers, values)); }
/** * listHotListDiagnosis * @throws DomainInterfaceException */ //WDEV-21039 public DiagLiteVoCollection listHotListDiagnosis(String name, Specialty specialty, Boolean includeExcludedKeywords) throws DomainInterfaceException { if(name == null) throw new DomainRuntimeException("Invalid Search criteria. Diagnosis name filter must be supplied."); if(specialty == null) throw new DomainRuntimeException("Invalid Search criteria. Specialty must be supplied."); DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer("select distinct diagHotListItem from DiagnosisHotlist as diagHotList left join diagHotList.hotListItem as diagHotListItem left join diagHotListItem.diagnosis as diag left join diag.keywords as kw "); ArrayList names = new ArrayList(); ArrayList values = new ArrayList(); hql.append(" where diag.isActive = :isActive"); names.add("isActive"); values.add(Boolean.TRUE); hql.append(" and diagHotList.specialty = :spec"); names.add("spec"); values.add(getDomLookup(specialty)); List hits = Keywords.searchByKeywords(factory, name, hql.toString(), names, values,includeExcludedKeywords); //WDEV-21039 List diags = new ArrayList(); for (int i = 0; i < hits.size(); i++) { diags.add(((DiagnosisHotlistItem)hits.get(i)).getDiagnosis()); } return DiagLiteVoAssembler.createDiagLiteVoCollectionFromDiagnosis(diags); }
public DiagLiteVoCollection listDivisionDiagnoses(String name, DiagnosisDivisions division, Boolean includeExcludedKeywords) throws DomainInterfaceException //WDEV-22287 { DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer("select distinct diag from DivisionalDiagnoses as divDiag left join divDiag.diagnoses as diag left join divDiag.division as div left join diag.keywords as kw "); ArrayList<String> names = new ArrayList<String>(); ArrayList<Object> values = new ArrayList<Object>(); hql.append(" where diag.isActive = :isActive"); names.add("isActive"); values.add(Boolean.TRUE); hql.append(" and div = :divisionLookup"); names.add("divisionLookup"); values.add(getDomLookup(division)); List<?> hits = Keywords.searchByKeywords(factory, name, hql.toString(), names, values, includeExcludedKeywords); //WDEV-22287 List diags = new ArrayList(); for (int i = 0; i < hits.size(); i++) { diags.add(hits.get(i)); } return DiagLiteVoAssembler.createDiagLiteVoCollectionFromDiagnosis(diags); }
private DiagLiteVoCollection listDiagnosis(String filter, boolean activeOnly) throws DomainInterfaceException { return DiagLiteVoAssembler.createDiagLiteVoCollectionFromDiagnosis(listDomDiagnosis(filter, activeOnly)).sort(); }
public IGenericItem[] listIGenericItems(String filter, CciType cciType, Boolean activeOnly) { List resultsList; try { resultsList = listDomIGenericItemInfo(filter, cciType, activeOnly.booleanValue()); } catch (DomainInterfaceException e) { return null; } if (resultsList.size() > 0) { if (cciType.equals(CciType.ALLERGEN)) { return AllergenVoAssembler.createAllergenVoCollectionFromAllergen(resultsList).toIGenericItemArray(); } else if (cciType.equals(CciType.MEDICATION)) { return MedicationLiteVoAssembler.createMedicationLiteVoCollectionFromMedication(resultsList).toIGenericItemArray(); } else if (cciType.equals(CciType.DIAGNOSIS)) { return DiagLiteVoAssembler.createDiagLiteVoCollectionFromDiagnosis(resultsList).toIGenericItemArray(); } else if (cciType.equals(CciType.PROBLEM)) { return ClinicalProblemShortVoAssembler.createClinicalProblemShortVoCollectionFromClinicalProblem(resultsList).toIGenericItemArray(); } else if (cciType.equals(CciType.PROCEDURE)) { return ProcedureLiteVoAssembler.createProcedureLiteVoCollectionFromProcedure(resultsList).toIGenericItemArray(); } else if (cciType.equals(CciType.CANCERIMAGE)) { return CancerImagingEventLiteVoAssembler.createCancerImagingEventLiteVoCollectionFromCancerImagingEvent(resultsList).toIGenericItemArray(); } else if (cciType.equals(CciType.VACCINE)) { return VaccineLiteVoAssembler.createVaccineLiteVoCollectionFromVaccine(resultsList).toIGenericItemArray(); } else if(cciType.equals(CciType.PRESENTING_ISSUE)) { return PresentingComplaintVoAssembler.createPresentingComplaintVoCollectionFromPresentingComplaint(resultsList).toICciFullArray(); } else if(cciType.equals(CciType.TREATMENT_INTERVENTION))//WDEV-17060 { return TreatmentInterventionVoAssembler.createTreatmentInterventionVoCollectionFromTreatmentIntervention(resultsList).toICciFullArray(); } else { throw new DomainRuntimeException("Unknown CCI Type in 'listCciLite' = " + cciType.toString()); } } return null; }