Esempio n. 1
0
  public Date initialScreeningDate(Long clientId) {

    List resultList = null;

    Date returnDate = null;

    String hql =
        "Select min(c.performedDate)from RsdiFormColorectalCancer c "
            + "where c.rsdiFormClientSnapshot.clientId = :clientId ";

    Query q = getEntityManager().createQuery(hql);
    q.setParameter("clientId", String.valueOf(clientId));

    resultList = q.getResultList();

    if (resultList.size() >= 1) {
      returnDate = (Date) resultList.get(0);
    }

    return returnDate;
  }
Esempio n. 2
0
  public Date nextFollowupDate(Long clientId) {

    List resultList = null;
    Date returnDate = null;

    String hql =
        "Select c.recommendedFollowupDate from RsdiFormColorectalCancer c "
            + "where c.rsdiFormClientSnapshot.clientId = :clientId "
            + "and c.performedDate IN( "
            + "select max(c2.performedDate) from RsdiFormColorectalCancer c2 "
            + "where c2.rsdiFormClientSnapshot.clientId = :clientId ) ";

    Query q = getEntityManager().createQuery(hql);
    q.setParameter("clientId", String.valueOf(clientId));

    resultList = q.getResultList();

    if (resultList.size() >= 1) {
      returnDate = (Date) resultList.get(0);
    }

    return returnDate;
  }