@Override public List<Integer> getNumberOfExecutingCasesPerDay(Date since, final Date to) { final List<Integer> executingCases = new ArrayList<Integer>(); while (since.before(to) || since.equals(to)) { final Date nextDayBegining = DateUtil.getBeginningOfTheDay(DateUtil.getNextDay(since)); final Query query = getSession().getNamedQuery("getNumberOfExecutingCases"); query.setLong("date", nextDayBegining.getTime()); executingCases.add(((Long) query.uniqueResult()).intValue()); since = DateUtil.getNextDay(since); } return executingCases; }
@Override public List<Integer> getNumberOfOpenStepsPerDay(Date since, final Date to) { final List<Integer> finishedCases = new ArrayList<Integer>(); while (since.before(to) || since.equals(to)) { final Date nextDayBegining = DateUtil.getBeginningOfTheDay(DateUtil.getNextDay(since)); final Query query = getSession().getNamedQuery("getNumberOfOpenSteps2"); query.setLong("date", nextDayBegining.getTime()); finishedCases.add(((Long) query.uniqueResult()).intValue()); since = DateUtil.getNextDay(since); } return finishedCases; }
@Override public List<Integer> getNumberOfFinishedCasesPerDay(Date since, final Date to) { final List<Integer> finishedCases = new ArrayList<Integer>(); while (since.before(to) || since.equals(to)) { final Date beginningOfTheDay = DateUtil.getBeginningOfTheDay(since); final Date nextBeginningOfTheDay = DateUtil.getBeginningOfTheDay(DateUtil.getNextDay(since)); final Query query = getSession().getNamedQuery("getNumberOfFinishedCases"); query.setLong("beginningOfTheDay", beginningOfTheDay.getTime()); query.setLong("nextBeginningOfTheDay", nextBeginningOfTheDay.getTime()); finishedCases.add(((Long) query.uniqueResult()).intValue()); since = DateUtil.getNextDay(since); } return finishedCases; }