@Override
public List<Report593ByDayDTO> getBatteriesByDayFor593(
String fromDate, String toDate, List<Integer> clinicIds) {
Query q =
entityManager.createNativeQuery(
"SELECT date_format(date_completed, '%m/%d/%Y'), date_format(date_completed, '%W'), "
+ " count(*)"
+ " FROM veteran_assessment "
+ " WHERE assessment_status_id <> 7 AND date_completed >= :fromDate AND date_completed <= :toDate "
+ "AND clinic_id IN (:clinicIds) AND date_completed IS NOT NULL "
+ "GROUP BY date_format( date_completed, '%Y%m%d' ) "
+ "ORDER BY date_format( date_completed, '%Y%m%d' ) ");
setParametersFor593(q, fromDate, toDate, clinicIds);
List<Report593ByDayDTO> result = new ArrayList<>();
for (Object aRow : q.getResultList()) {
Object[] objs = (Object[]) aRow;
Report593ByDayDTO dto = new Report593ByDayDTO();
dto.setTotal(Integer.toString(((Number) objs[2]).intValue()));
dto.setDate((String) objs[0]);
dto.setDayOfWeek((String) objs[1]);
result.add(dto);
}
return result;
}
@Override
public List<Report594DTO> findAlertsCount(
String fromDate, String toDate, List<Integer> clinicIds) {
Query q =
entityManager.createNativeQuery(
"SELECT a.name, count(*) FROM veteran_assessment_dashboard_alert vada JOIN dashboard_alert a "
+ "ON vada.dashboard_alert_id=a.dashboard_alert_id "
+ " INNER JOIN veteran_assessment va ON vada.veteran_assessment_id=va.veteran_assessment_id "
+ "WHERE va.assessment_status_id IN (3, 5) AND va.clinic_id IN (:clinicIds) AND date_completed >= :fromDate "
+ " AND va.date_completed <= :toDate AND va.date_completed IS NOT NULL GROUP BY a.name");
setParametersFor593(q, fromDate, toDate, clinicIds);
List<Object[]> rows = q.getResultList();
List<Report594DTO> dtos = new ArrayList<>();
if (rows != null && rows.size() > 0) {
for (Object[] aRow : rows) {
Report594DTO dto = new Report594DTO();
dto.setModuleName((String) aRow[0]);
dto.setModuleCount("" + ((Number) aRow[1]).intValue());
dtos.add(dto);
}
}
return dtos;
}
@Override
public List<Integer> getGenderCount(
List<Integer> clinicIds, String fromDate, String toDate, List<Integer> measureAnswerIds) {
Query q =
entityManager.createNativeQuery(
"SELECT measure_answer_id, sum(boolean_value) FROM survey_measure_response "
+ "WHERE measure_answer_id IN (:measureAnswerIds) "
+ "AND veteran_assessment_id IN ( "
+ "SELECT DISTINCT veteran_assessment_id FROM veteran_assessment "
+ "WHERE assessment_status_id <> 7 AND date_completed >= :fromDate AND date_completed <=:toDate "
+ "AND date_completed IS NOT NULL AND clinic_id IN (:clinicIds) "
+ ") AND boolean_value IS NOT NULL "
+ "GROUP BY measure_answer_id ORDER BY measure_answer_id");
setParametersFor593(q, fromDate, toDate, clinicIds);
q.setParameter("measureAnswerIds", measureAnswerIds);
List r = q.getResultList();
if (r != null && r.size() > 0) {
List<Integer> result = new ArrayList<>();
for (Object a : r) {
Object[] aRow = (Object[]) a;
result.add(((Number) aRow[1]).intValue());
}
return result;
}
return null;
}
@Override
public float getAvgNumOfAssessmentPerClinicianClinicFor593(
String fromDate, String toDate, List<Integer> clinicIds) {
Query q =
entityManager.createNativeQuery(
"SELECT "
+ "count(*) "
+ "FROM "
+ "veteran_assessment va, clinic c, user u "
+ "WHERE va.assessment_status_id <> 7 AND "
+ "va.clinic_id = c.clinic_id AND "
+ "va.clinician_id = u.user_id AND "
+ "va.date_completed BETWEEN :fromDate AND :toDate AND "
+ "va.clinic_id IN (:clinicIds) "
+ "GROUP BY c.clinic_id , u.user_id");
setParametersFor593(q, fromDate, toDate, clinicIds);
final List<BigInteger> resultList = q.getResultList();
float sum = 0;
for (BigInteger assessmentCnt : resultList) {
sum += Float.parseFloat(assessmentCnt.toString());
}
float avgNumOfAssessmentPerClinicianClinicFor593 =
resultList.isEmpty() ? 0.0f : sum / Float.valueOf(resultList.size());
return avgNumOfAssessmentPerClinicianClinicFor593;
}
private List<Integer> getExportAssessmentStates() {
List<Integer> exportStates = new ArrayList<Integer>();
exportStates.add(AssessmentStatusEnum.COMPLETE.getAssessmentStatusId());
exportStates.add(AssessmentStatusEnum.INCOMPLETE.getAssessmentStatusId());
exportStates.add(AssessmentStatusEnum.FINALIZED.getAssessmentStatusId());
exportStates.add(AssessmentStatusEnum.REVIEWED.getAssessmentStatusId());
return exportStates;
}
@Override
public List<Number> getNumOfDeploymentStatistics(
List<Integer> cList, String fromDate, String toDate) {
Query q =
entityManager.createNativeQuery(
"SELECT avg(numOfDeployment), min(numOfDeployment), max(numOfDeployment) FROM (SELECT count(*) AS numOfDeployment"
+ " FROM survey_measure_response WHERE measure_answer_id = 1210 "
+ " AND text_value IS NOT NULL AND veteran_assessment_id IN (SELECT veteran_assessment_id FROM veteran_assessment WHERE assessment_status_id <> 7 AND clinic_id IN (:clinicIds) AND date_completed >= :fromDate "
+ " AND date_completed <= :toDate AND date_completed IS NOT NULL)"
+ " GROUP BY veteran_assessment_id) a ");
setParametersFor593(q, fromDate, toDate, cList);
List r = q.getResultList();
if (r == null || r.size() == 0) {
return null;
} else {
List<Number> result = new ArrayList<>();
Object[] aRow = (Object[]) r.get(0);
if (aRow[0] != null) {
result.add((Number) aRow[0]);
}
if (aRow[1] != null) {
result.add((Number) aRow[1]);
}
if (aRow[2] != null) {
result.add((Number) aRow[2]);
}
return result;
}
}
@Override
public List<Number> getAgeStatistics(List<Integer> cList, String fromDate, String toDate) {
Query q =
entityManager.createNativeQuery(
"SELECT avg(datediff(CURDATE(), STR_TO_DATE(text_value, '%m/%d/%Y'))/365), min(datediff(CURDATE(), STR_TO_DATE(text_value, '%m/%d/%Y'))/365), "
+ "max(datediff(CURDATE(), STR_TO_DATE(text_value, '%m/%d/%Y'))/365)"
+ " FROM survey_measure_response WHERE measure_answer_id = 170 "
+ " AND text_value IS NOT NULL AND veteran_assessment_id IN "
+ "(SELECT veteran_assessment_id FROM veteran_assessment WHERE "
+ "assessment_status_id <> 7 AND clinic_id IN (:clinicIds) AND "
+ "date_completed >= :fromDate "
+ " AND date_completed <= :toDate AND date_completed IS NOT NULL)");
setParametersFor593(q, fromDate, toDate, cList);
List r = q.getResultList();
if (r == null || r.size() == 0) {
return null;
} else {
List<Number> result = new ArrayList<>();
Object[] aRow = (Object[]) r.get(0);
if (aRow[0] != null) {
result.add((Number) aRow[0]);
}
if (aRow[1] != null) {
result.add((Number) aRow[1]);
}
if (aRow[2] != null) {
result.add((Number) aRow[2]);
}
return result;
}
}
@Override
public Date getDateModified(int veteranAssessmentId) {
String sql =
"SELECT UNIX_TIMESTAMP(max(date_created)), UNIX_TIMESTAMP(max(date_modified)) FROM survey_measure_response WHERE veteran_assessment_id = :veteranAssessmentId";
@SuppressWarnings("unchecked")
List<Object[]> rows =
entityManager
.createNativeQuery(sql)
.setParameter("veteranAssessmentId", veteranAssessmentId)
.getResultList();
if (rows.isEmpty()) {
// no results saved for this assessment
return new Date(0);
}
Object[] row = rows.get(0);
Long created = null;
try {
created = Long.valueOf(row[0].toString());
} catch (Exception e) {
}
Long modified = null;
try {
modified = Long.valueOf(row[1].toString());
} catch (Exception e) {
}
if (created == null) {
if (modified == null) {
// no results saved for this assessment
return new Date(0);
}
// this should never happen but we know what happens when we say that :)
return new Date(modified);
} else if (modified == null) {
return new Date(created);
}
// found both
return new Date(Math.max(created, modified));
}
@Override
public Integer getVetWithMultipleBatteriesFor593(
String fromDate, String toDate, List<Integer> clinicIds) {
Query q =
entityManager.createNativeQuery(
"SELECT count(veteran_id) FROM veteran_assessment "
+ " WHERE assessment_status_id <> 7 AND date_completed >= :fromDate AND date_completed <= :toDate "
+ "AND clinic_id IN (:clinicIds) AND date_completed IS NOT NULL "
+ "GROUP BY veteran_id "
+ "HAVING count(*) > 1 ");
setParametersFor593(q, fromDate, toDate, clinicIds);
List r = q.getResultList();
if (r != null) {
return r.size();
}
return 0;
}
@Override
public List<VeteranAssessment> findByProgramIdList(List<Integer> programIdList) {
List<VeteranAssessment> veteranAssessmentList = new ArrayList<VeteranAssessment>();
String sql =
"SELECT DISTINCT va FROM VeteranAssessment va JOIN va.program p WHERE va.dateArchived is null AND p.programId IN (:programIdList)";
if (programIdList != null && programIdList.size() > 0) {
TypedQuery<VeteranAssessment> query = entityManager.createQuery(sql, VeteranAssessment.class);
query.setParameter("programIdList", programIdList);
veteranAssessmentList = query.getResultList();
}
return veteranAssessmentList;
}
@Override
public List<VeteranAssessment> findAllByVeteranIdAndAssessmentStatusIdList(
Integer veteranId, List<Integer> assessmentStatusIdList) {
List<VeteranAssessment> veteranAssessmentList = new ArrayList<VeteranAssessment>();
String sql =
"SELECT va FROM VeteranAssessment va JOIN va.veteran v JOIN va.assessmentStatus ast WHERE v.veteranId = :veteranId AND ast.assessmentStatusId IN (:assessmentStatusIdList) ORDER BY va.veteranAssessmentId";
if (assessmentStatusIdList != null && assessmentStatusIdList.size() > 0) {
TypedQuery<VeteranAssessment> query = entityManager.createQuery(sql, VeteranAssessment.class);
query.setParameter("veteranId", veteranId);
query.setParameter("assessmentStatusIdList", assessmentStatusIdList);
veteranAssessmentList = query.getResultList();
}
return veteranAssessmentList;
}
@Override
public List<VeteranAssessment> searchVeteranAssessmentForExport(
Integer clinicanId,
Integer createdByUserId,
Integer programId,
Date fromAssessmentDate,
Date toAssessmentDate,
Integer veteranId,
List<Integer> programIdList) {
CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
CriteriaQuery<VeteranAssessment> criteriaQuery =
criteriaBuilder.createQuery(VeteranAssessment.class);
Root<VeteranAssessment> veteranAssessmentRoot = criteriaQuery.from(VeteranAssessment.class);
Join<VeteranAssessment, AssessmentStatus> assessmentStatusJoin =
veteranAssessmentRoot.join("assessmentStatus");
List<Predicate> criteriaList = new ArrayList<Predicate>();
// only include assessments in the appropriate state
Expression<Integer> statusExp = assessmentStatusJoin.get("assessmentStatusId");
Predicate statusPredicate = statusExp.in(getExportAssessmentStates());
criteriaList.add(statusPredicate);
if (clinicanId != null) {
Join<VeteranAssessment, User> clinicianJoin = veteranAssessmentRoot.join("clinician");
criteriaList.add(criteriaBuilder.equal(clinicianJoin.get("userId"), clinicanId));
}
if (createdByUserId != null) {
Join<VeteranAssessment, User> createdByUserJoin = veteranAssessmentRoot.join("createdByUser");
criteriaList.add(criteriaBuilder.equal(createdByUserJoin.get("userId"), createdByUserId));
}
if (fromAssessmentDate != null) {
criteriaList.add(
criteriaBuilder.greaterThan(
veteranAssessmentRoot.<Date>get("dateCreated"), fromAssessmentDate));
}
if (toAssessmentDate != null) {
criteriaList.add(
criteriaBuilder.lessThanOrEqualTo(
veteranAssessmentRoot.<Date>get("dateCreated"), toAssessmentDate));
}
if (veteranId != null) {
Join<VeteranAssessment, Veteran> veteranJoin = veteranAssessmentRoot.join("veteran");
criteriaList.add(criteriaBuilder.equal(veteranJoin.get("veteranId"), veteranId));
}
if (programId != null) {
// criteriaList.add(criteriaBuilder.equal(programJoin.get("programId"), programId));
if (programIdList == null) {
programIdList = new ArrayList<Integer>();
}
programIdList.add(programId);
}
if (programIdList != null && programIdList.size() > 0) {
Join<VeteranAssessment, Program> programJoin = veteranAssessmentRoot.join("program");
Expression<Integer> exp = programJoin.get("programId");
Predicate programIdPredicate = exp.in(programIdList);
criteriaList.add(programIdPredicate);
}
criteriaQuery.select(veteranAssessmentRoot);
criteriaQuery.where(criteriaBuilder.and(criteriaList.toArray(new Predicate[0])));
@SuppressWarnings("rawtypes")
Expression orderByPath = veteranAssessmentRoot.get("veteranAssessmentId");
criteriaQuery.orderBy(criteriaBuilder.desc(orderByPath));
// Generate the query based on the criteria.
TypedQuery<VeteranAssessment> query = entityManager.createQuery(criteriaQuery);
List<VeteranAssessment> veteranAssessments = query.getResultList();
return veteranAssessments;
}
@Override
public List<Report595DTO> getTopSkippedQuestions(
List<Integer> clinicIds, String fromDate, String toDate) {
List<Report595DTO> resultList = new ArrayList<>();
Query q =
entityManager.createNativeQuery(
"SELECT count(*), measure_id FROM veteran_assessment_question_presence vsaq "
+ "INNER JOIN veteran_assessment va ON vsaq.veteran_assessment_id = va.veteran_assessment_id "
+ " WHERE skipped = -1 AND date_completed >= :fromDate AND date_completed <= :toDate "
+ "AND clinic_id IN (:clinicIds) AND date_completed IS NOT NULL "
+ " GROUP BY measure_id "
+ " ORDER BY count(*) DESC ");
setParametersFor593(q, fromDate, toDate, clinicIds);
List r = q.getResultList();
if (r != null && r.size() > 0) {
for (Object aRow : q.getResultList()) {
Object[] data = (Object[]) aRow;
int count = ((Number) data[0]).intValue();
if (count == 0) break;
int measureId = ((Number) data[1]).intValue();
Measure m = measureRepository.findOne(measureId);
// only allow singleSelect or multiSelect
int measureType = m.getMeasureType().getMeasureTypeId();
if (measureType != 1 && measureType != 2 && measureType != 3) {
continue;
}
Report595DTO dto = new Report595DTO();
Query q1 =
entityManager.createNativeQuery(
"select count(*) from veteran_assessment_question_presence vsaq "
+ "inner join veteran_assessment va on vsaq.veteran_assessment_id = va.veteran_assessment_id "
+ " where date_completed >= :fromDate and date_completed <= :toDate "
+ "and clinic_id in (:clinicIds) and date_completed is not null "
+ " and measure_id ="
+ measureId);
setParametersFor593(q1, fromDate, toDate, clinicIds);
int total = ((Number) q1.getSingleResult()).intValue();
DecimalFormat formatter = new DecimalFormat("###.##");
String percent = formatter.format(count * 100d / total);
dto.setPercentage(percent + "% (" + count + "/" + total + ")");
dto.setQuestions(((Number) data[1]).intValue() + "");
dto.setQuestions(m.getMeasureText());
dto.setVariableName(m.getVariableName());
resultList.add(dto);
}
}
Collections.sort(
resultList,
new Comparator<Report595DTO>() {
@Override
public int compare(Report595DTO o1, Report595DTO o2) {
String[] a1 = o1.getPercentage().split("%");
String[] a2 = o2.getPercentage().split("%");
float one = Float.parseFloat(a1[0]);
float two = Float.parseFloat(a2[0]);
if (one > two) return 1;
else if (one < two) return -1;
return 0;
}
});
int index = 1;
List<Report595DTO> results = new ArrayList<>(20);
for (Report595DTO dto : resultList) {
dto.setOrder(Integer.toString(index++));
results.add(dto);
if (index > 20) break;
}
return results;
}
@Override
public List<Report593ByTimeDTO> getBatteriesByTimeFor593(
String fromDate, String toDate, List<Integer> clinicIds) {
HashMap<String, Report593ByTimeDTO> cache = new HashMap<>();
Report593ByTimeDTO dto = null;
Query q =
entityManager.createNativeQuery(
"SELECT date_format(date_completed, '%m/%d/%Y'), date_format(date_completed, '%W'), "
+ " count(*)"
+ " FROM veteran_assessment "
+ " WHERE assessment_status_id <> 7 AND date_completed >= :fromDate AND date_completed <= :toDate "
+ "AND clinic_id IN (:clinicIds) AND date_completed IS NOT NULL "
+ "AND extract(HOUR FROM date_completed) >= :fr AND extract(HOUR FROM date_completed) <= :to "
+ "GROUP BY date_format( date_completed, '%Y%m%d' ) "
+ "ORDER BY date_format( date_completed, '%Y%m%d' ) ");
setParametersFor593(q, fromDate, toDate, clinicIds);
List result = getData(q, 6, 7);
if (result != null && result.size() > 0) {
for (Object aRow : result) {
Object[] objs = (Object[]) aRow;
dto = new Report593ByTimeDTO();
dto.setDate((String) objs[0]);
dto.setDayOfWeek((String) objs[1]);
dto.setSixToEight(Integer.toString(((Number) objs[2]).intValue()));
cache.put(dto.getDate(), dto);
}
}
setParametersFor593(q, fromDate, toDate, clinicIds);
result = getData(q, 8, 9);
if (result != null && result.size() > 0) {
for (Object aRow : result) {
Object[] objs = (Object[]) aRow;
dto = cache.get((String) objs[0]);
if (dto == null) {
dto = new Report593ByTimeDTO();
}
dto.setDate((String) objs[0]);
dto.setDayOfWeek((String) objs[1]);
dto.setEightToTen(Integer.toString(((Number) objs[2]).intValue()));
cache.put(dto.getDate(), dto);
}
}
result = getData(q, 10, 11);
if (result != null && result.size() > 0) {
for (Object aRow : result) {
Object[] objs = (Object[]) aRow;
dto = cache.get((String) objs[0]);
if (dto == null) {
dto = new Report593ByTimeDTO();
}
dto.setDate((String) objs[0]);
dto.setDayOfWeek((String) objs[1]);
dto.setTenToTwelve(Integer.toString(((Number) objs[2]).intValue()));
cache.put(dto.getDate(), dto);
}
}
result = getData(q, 12, 13);
if (result != null && result.size() > 0) {
for (Object aRow : result) {
Object[] objs = (Object[]) aRow;
dto = cache.get((String) objs[0]);
if (dto == null) {
dto = new Report593ByTimeDTO();
}
dto.setDate((String) objs[0]);
dto.setDayOfWeek((String) objs[1]);
dto.setTwelveToTwo(Integer.toString(((Number) objs[2]).intValue()));
cache.put(dto.getDate(), dto);
}
}
result = getData(q, 14, 15);
if (result != null && result.size() > 0) {
for (Object aRow : result) {
Object[] objs = (Object[]) aRow;
dto = cache.get((String) objs[0]);
if (dto == null) {
dto = new Report593ByTimeDTO();
}
dto.setDate((String) objs[0]);
dto.setDayOfWeek((String) objs[1]);
dto.setTwoToFour(Integer.toString(((Number) objs[2]).intValue()));
cache.put(dto.getDate(), dto);
}
}
result = getData(q, 16, 17);
if (result != null && result.size() > 0) {
for (Object aRow : result) {
Object[] objs = (Object[]) aRow;
dto = cache.get((String) objs[0]);
if (dto == null) {
dto = new Report593ByTimeDTO();
}
dto.setDate((String) objs[0]);
dto.setDayOfWeek((String) objs[1]);
dto.setFourToSix(Integer.toString(((Number) objs[2]).intValue()));
cache.put(dto.getDate(), dto);
}
}
List<Report593ByTimeDTO> resultList = new ArrayList<>();
if (!cache.isEmpty()) {
resultList.addAll(cache.values());
for (Report593ByTimeDTO d : resultList) {
if (d.getEightToTen() == null) {
d.setEightToTen("0");
}
if (d.getFourToSix() == null) {
d.setFourToSix("0");
}
if (d.getSixToEight() == null) {
d.setSixToEight("0");
}
if (d.getTenToTwelve() == null) {
d.setTenToTwelve("0");
}
if (d.getTwelveToTwo() == null) {
d.setTwelveToTwo("0");
}
if (d.getTwoToFour() == null) {
d.setTwoToFour("0");
}
d.setTotal(
Integer.toString(
Integer.parseInt(d.getEightToTen())
+ Integer.parseInt(d.getFourToSix())
+ Integer.parseInt(d.getSixToEight())
+ Integer.parseInt(d.getTenToTwelve())
+ Integer.parseInt(d.getTwelveToTwo())
+ Integer.parseInt(d.getTwoToFour())));
}
Collections.sort(
resultList,
new Comparator<Report593ByTimeDTO>() {
@Override
public int compare(Report593ByTimeDTO o1, Report593ByTimeDTO o2) {
SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy");
try {
return sdf.parse(o1.getDate()).compareTo(sdf.parse(o2.getDate()));
} catch (Exception e) {
return 0;
}
}
});
}
return resultList;
}
@Override
public SearchResult<VeteranAssessment> searchVeteranAssessment(
Integer veteranAssessmentId,
Integer veteranId,
Integer programId,
Integer clinicanId,
Integer createdByUserId,
Date fromAssessmentDate,
Date toAssessmentDate,
List<Integer> programIdList,
SearchAttributes searchAttributes) {
CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
CriteriaQuery<VeteranAssessment> criteriaQuery =
criteriaBuilder.createQuery(VeteranAssessment.class);
Root<VeteranAssessment> veteranAssessmentRoot = criteriaQuery.from(VeteranAssessment.class);
Join<VeteranAssessment, AssessmentStatus> assessmentStatusJoin =
veteranAssessmentRoot.join("assessmentStatus");
Join<VeteranAssessment, Veteran> veteranJoin = veteranAssessmentRoot.join("veteran");
Join<VeteranAssessment, Program> programJoin = veteranAssessmentRoot.join("program");
Join<VeteranAssessment, User> clinicianJoin = veteranAssessmentRoot.join("clinician");
Join<VeteranAssessment, User> createdByUserJoin = veteranAssessmentRoot.join("createdByUser");
List<Predicate> criteriaList = new ArrayList<Predicate>();
if (veteranAssessmentId != null) {
criteriaList.add(
criteriaBuilder.equal(
veteranAssessmentRoot.get("veteranAssessmentId"), veteranAssessmentId));
}
if (veteranId != null) {
criteriaList.add(criteriaBuilder.equal(veteranJoin.get("veteranId"), veteranId));
}
if (programId != null) {
criteriaList.add(criteriaBuilder.equal(programJoin.get("programId"), programId));
}
if (clinicanId != null) {
criteriaList.add(criteriaBuilder.equal(clinicianJoin.get("userId"), clinicanId));
}
if (createdByUserId != null) {
criteriaList.add(criteriaBuilder.equal(createdByUserJoin.get("userId"), createdByUserId));
}
if (fromAssessmentDate != null) {
criteriaList.add(
criteriaBuilder.greaterThanOrEqualTo(
veteranAssessmentRoot.<Date>get("dateUpdated"), fromAssessmentDate));
}
if (toAssessmentDate != null) {
criteriaList.add(
criteriaBuilder.lessThanOrEqualTo(
veteranAssessmentRoot.<Date>get("dateUpdated"), toAssessmentDate));
}
if (programIdList != null && programIdList.size() > 0) {
Expression<Integer> exp = programJoin.get("programId");
Predicate programIdPredicate = exp.in(programIdList);
criteriaList.add(programIdPredicate);
}
criteriaQuery.select(veteranAssessmentRoot);
criteriaQuery.where(criteriaBuilder.and(criteriaList.toArray(new Predicate[0])));
// Set default order by field and then check if one was passed to us.
@SuppressWarnings("rawtypes")
Expression orderByPath = veteranAssessmentRoot.get("veteranAssessmentId");
if (StringUtils.isNotBlank(searchAttributes.getSortColumn())) {
if (searchAttributes.getSortColumn().equalsIgnoreCase("programName")) {
orderByPath = programJoin.get("name");
} else if (searchAttributes.getSortColumn().equalsIgnoreCase("clinicianName")) {
orderByPath = clinicianJoin.get("lastName");
} else if (searchAttributes.getSortColumn().equalsIgnoreCase("createdBy")) {
orderByPath = createdByUserJoin.get("lastName");
} else if (searchAttributes.getSortColumn().equalsIgnoreCase("createDate")) {
orderByPath = veteranAssessmentRoot.get("dateCreated");
} else if (searchAttributes.getSortColumn().equalsIgnoreCase("assessmentDate")) {
orderByPath = veteranAssessmentRoot.get("dateUpdated");
} else if (searchAttributes.getSortColumn().equalsIgnoreCase("completeDate")) {
orderByPath = veteranAssessmentRoot.get("dateCompleted");
} else if (searchAttributes.getSortColumn().equalsIgnoreCase("veteranId")) {
orderByPath = veteranJoin.get("veteranId");
} else if (searchAttributes.getSortColumn().equalsIgnoreCase("veteranName")) {
orderByPath = veteranJoin.get("lastName");
} else if (searchAttributes.getSortColumn().equalsIgnoreCase("assessmentStatusName")) {
orderByPath = assessmentStatusJoin.get("name");
} else if (searchAttributes.getSortColumn().equalsIgnoreCase("ssnLastFour")) {
orderByPath = veteranJoin.get("ssnLastFour");
} else if (searchAttributes.getSortColumn().equalsIgnoreCase("duration")) {
orderByPath = veteranAssessmentRoot.get("duration");
} else if (searchAttributes.getSortColumn().equalsIgnoreCase("percentComplete")) {
orderByPath = veteranAssessmentRoot.get("percentComplete");
}
}
if (searchAttributes.getSortDirection() == SortDirection.SORT_DESCENDING) {
criteriaQuery.orderBy(criteriaBuilder.desc(orderByPath));
} else {
criteriaQuery.orderBy(criteriaBuilder.asc(orderByPath));
}
// Generate the query based on the criteria.
TypedQuery<VeteranAssessment> query = entityManager.createQuery(criteriaQuery);
SearchResult<VeteranAssessment> searchResult = new SearchResult<VeteranAssessment>();
// Get the total count. Not a very efficient way....
Integer totalCount = query.getResultList().size();
searchResult.setTotalNumRowsFound(totalCount);
// Now get only the page.
query.setFirstResult(searchAttributes.getRowStartIndex());
query.setMaxResults(searchAttributes.getPageSize());
List<VeteranAssessment> veteranAssessments = query.getResultList();
searchResult.setResultList(veteranAssessments);
return searchResult;
}