コード例 #1
0
  /** @return */
  private ArrayList<ReferenceDataRefDataType> getUsedRefSpecialtySchemes() {
    System.out.println("\n========> Getting Used specialtyscheme references");

    ArrayList<ReferenceDataRefDataType> refColl = new ArrayList<ReferenceDataRefDataType>();
    Query query = null;
    int startRec = refDetails.getStartingRecNumber();
    int maxDisplay = refDetails.getMaxRecordsToShow();

    if ((refDetails.getLookupSystem().getCodeSystem() == null)
        || (refDetails.getLookupSystem().getCodeSystem().isEmpty())) {
      query = em.createNamedQuery("KMSpecialty.findAllDistinctScheme");
    } else {
      query = em.createNamedQuery("KMSpecialty.findAllDistinctSchemeByWildcard");
      query.setParameter(
          "terminologyScheme", refDetails.getLookupSystem().getCodeSystem().toUpperCase() + "%");
    }
    query.setFirstResult(startRec);
    query.setMaxResults(maxDisplay);
    List<String> foundList = (List<String>) query.getResultList();

    for (int r = 0; r < foundList.size(); r++) {
      ReferenceDataRefDataType aRefData = new ReferenceDataRefDataType();
      aRefData.setId(
          0); // TODO Need to pull the ID for each one of this type from ref_specialty_type
      // ..another call
      aRefData.setName(foundList.get(r));

      refColl.add(aRefData);
    }
    return refColl;
  }
コード例 #2
0
  /** @return */
  private ArrayList<ReferenceDataRefDataType> getUsedRefSpecialtyCodes() {
    ArrayList<ReferenceDataRefDataType> refColl = new ArrayList<ReferenceDataRefDataType>();
    Query query = null;
    int startRec = refDetails.getStartingRecNumber();
    int maxDisplay = refDetails.getMaxRecordsToShow();
    String q = null;

    System.out.println("\n========> Getting Used Specialty reference");
    // --------------------------------------------------
    // Get Code based on schemeTypeId
    // or based on schemeTypeId AND partial Content Code.
    // --------------------------------------------------
    q =
        "SELECT NEW gov.hhs.fha.nhinc.kmr.model.RefCodeSimple(c.preferredConceptName, c.refTaxonomyCodePK.conceptCode)"
            + " FROM KMSpecialty fs, RefTaxonomyCode c, RefDictionary s"
            + " WHERE "
            + "     s.conceptName = 'SPECIALTY'"
            + " AND s.dictionaryId = c.refTaxonomyCodePK.dictionaryId"
            + " AND c.refTaxonomyCodePK.codeSystemOid = s.activeCodeSystemOid"
            + " AND c.refTaxonomyCodePK.conceptCode = fs.kMSpecialtyPK.terminologyCode";
    /*
    if ((refDetails.getLookupCode().getCodeSystem() != null) &&
            !(refDetails.getLookupCode().getCodeSystem().equals(""))) {
       q = q + " AND fs.kMSpecialtyPK.terminologyScheme = '" + refDetails.getLookupCode().getCodeSystem() + "'";
    } */
    if ((refDetails.getLookupCode().getContentCode() != null)
        && !(refDetails.getLookupCode().getContentCode().equals(""))) {
      q =
          q
              + " AND UPPER(c.preferredConceptName) LIKE '%"
              + refDetails.getLookupCode().getContentCode().toUpperCase()
              + "%'";
    }
    q = q + " GROUP BY c.preferredConceptName, c.refTaxonomyCodePK.conceptCode";
    query = em.createQuery(q);
    // ------------------------------------------------------------

    query.setFirstResult(startRec);
    query.setMaxResults(maxDisplay);
    List<RefCodeSimple> foundList = query.getResultList();

    for (RefCodeSimple c : foundList) {

      // System.out.println("---> NAME=" + c.getName());
      // System.out.println("---> NAME=" + c.getDescription());

      ReferenceDataRefDataType aRefData = new ReferenceDataRefDataType();
      aRefData.setId(0);
      aRefData.setName(c.getName());
      aRefData.setDescr(c.getDescription());
      refColl.add(aRefData);
    }
    return refColl;
  }