@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; }
@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 int getNumberOfStepsAtRisk(final int remainingDays) { if (remainingDays < 0) { throw new IllegalArgumentException("The number of remaining days is negative"); } final Date currentDate = new Date(); final Date beginningOfTheDay = DateUtil.getBeginningOfTheDay(currentDate); final Date atRisk = DateUtil.backTo(beginningOfTheDay, -(remainingDays + 1)); return EnvTool.getJournalQueriers(getQueryList()).getNumberOfStepsAtRisk(currentDate, atRisk); }
@Override public int getNumberOfUserStepsAtRisk(final int remainingDays) { if (remainingDays < 0) { throw new IllegalArgumentException("The number of remaining days is negative"); } final String userId = EnvTool.getUserId(); final Date currentDate = new Date(); final Date beginningOfTheDay = DateUtil.getBeginningOfTheDay(currentDate); final Date atRisk = DateUtil.backTo(beginningOfTheDay, -(remainingDays + 1)); return EnvTool.getJournalQueriers(getQueryList()).getNumberOfUserStepsAtRisk(userId, currentDate, atRisk); }
private List<InternalProcessInstance> getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate( final String userId, final int remainingDays, final int startingIndex, final int pageSize, final Set<ProcessDefinitionUUID> processUUIDs, final ProcessInstanceCriterion pagingCriterion) { final boolean access = EnvTool.isRestrictedApplicationAcces(); List<InternalProcessInstance> processes = new ArrayList<InternalProcessInstance>(); final Date currentDate = new Date(); final Date beginningOfTheDay = DateUtil.getBeginningOfTheDay(currentDate); final Date atRisk = DateUtil.backTo(beginningOfTheDay, -(remainingDays + 1)); if (access) { final String applicationName = EnvTool.getApplicationAccessName(); if (applicationName != null) { Set<ProcessDefinitionUUID> visibleProcessUUIDs = FacadeUtil.getAllowedProcessUUIDsFor(applicationName, RuleType.PROCESS_READ); if (visibleProcessUUIDs == null) { visibleProcessUUIDs = new HashSet<ProcessDefinitionUUID>(); } visibleProcessUUIDs.retainAll(processUUIDs); if (visibleProcessUUIDs != null && !visibleProcessUUIDs.isEmpty()) { processes = EnvTool.getAllQueriers(getQueryList()) .getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(userId, currentDate, atRisk, startingIndex, pageSize, visibleProcessUUIDs, pagingCriterion); } } } else { processes = EnvTool.getAllQueriers(getQueryList()) .getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(userId, currentDate, atRisk, startingIndex, pageSize, processUUIDs, pagingCriterion); } return processes; }
private List<InternalProcessInstance> getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate( final String userId, final int remainingDays, final int startingIndex, final int pageSize, final Set<ProcessDefinitionUUID> processUUIDs) { final boolean access = EnvTool.isRestrictedApplicationAcces(); List<InternalProcessInstance> processes = new ArrayList<InternalProcessInstance>(); final Date currentDate = new Date(); final Date beginningOfTheDay = DateUtil.getBeginningOfTheDay(currentDate); final Date atRisk = DateUtil.backTo(beginningOfTheDay, -(remainingDays + 1)); if (access) { final String applicationName = EnvTool.getApplicationAccessName(); if (applicationName != null) { Set<ProcessDefinitionUUID> visibleProcessUUIDs = FacadeUtil.getAllowedProcessUUIDsFor(applicationName, RuleType.PROCESS_READ); if (visibleProcessUUIDs == null) { visibleProcessUUIDs = new HashSet<ProcessDefinitionUUID>(); } visibleProcessUUIDs.retainAll(processUUIDs); if (visibleProcessUUIDs != null && !visibleProcessUUIDs.isEmpty()) { processes = EnvTool.getAllQueriers(getQueryList()) .getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(userId, currentDate, atRisk, startingIndex, pageSize, visibleProcessUUIDs); } } } else { processes = EnvTool.getAllQueriers(getQueryList()) .getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(userId, currentDate, atRisk, startingIndex, pageSize, processUUIDs); } return processes; }
@Override public Integer getNumberOfParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate( final String username, final int remainingDays, final Set<ProcessDefinitionUUID> processUUIDs) { final boolean access = EnvTool.isRestrictedApplicationAcces(); final Date currentDate = new Date(); final Date beginningOfTheDay = DateUtil.getBeginningOfTheDay(currentDate); final Date atRisk = DateUtil.backTo(beginningOfTheDay, -(remainingDays + 1)); if (access) { final String applicationName = EnvTool.getApplicationAccessName(); if (applicationName != null) { Set<ProcessDefinitionUUID> visibleProcessUUIDs = FacadeUtil.getAllowedProcessUUIDsFor(applicationName, RuleType.PROCESS_READ); if (visibleProcessUUIDs == null) { visibleProcessUUIDs = new HashSet<ProcessDefinitionUUID>(); } visibleProcessUUIDs.retainAll(processUUIDs); if (visibleProcessUUIDs != null && !visibleProcessUUIDs.isEmpty()) { return EnvTool.getAllQueriers(getQueryList()) .getNumberOfParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(username, currentDate, atRisk, visibleProcessUUIDs); } } return 0; } else { return EnvTool.getAllQueriers(getQueryList()) .getNumberOfParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(username, currentDate, atRisk, processUUIDs); } }
private List<InternalProcessInstance> getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate( final String userId, final int remainingDays, final int startingIndex, final int pageSize) { final boolean access = EnvTool.isRestrictedApplicationAcces(); List<InternalProcessInstance> processes = new ArrayList<InternalProcessInstance>(); final Date currentDate = new Date(); final Date beginningOfTheDay = DateUtil.getBeginningOfTheDay(currentDate); final Date atRisk = DateUtil.backTo(beginningOfTheDay, -(remainingDays + 1)); if (access) { final String applicationName = EnvTool.getApplicationAccessName(); if (applicationName != null) { final Set<ProcessDefinitionUUID> visibleProcessUUIDs = FacadeUtil.getAllowedProcessUUIDsFor(applicationName, RuleType.PROCESS_READ); if (visibleProcessUUIDs != null && !visibleProcessUUIDs.isEmpty()) { processes = EnvTool.getAllQueriers(getQueryList()) .getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(userId, currentDate, atRisk, startingIndex, pageSize, visibleProcessUUIDs); } } } else { processes = EnvTool.getAllQueriers(getQueryList()) .getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(userId, currentDate, atRisk, startingIndex, pageSize); } return processes; }
private List<InternalProcessInstance> getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate( final String userId, final int remainingDays, final int startingIndex, final int pageSize, final ProcessInstanceCriterion pagingCriterion) { final boolean access = EnvTool.isRestrictedApplicationAcces(); List<InternalProcessInstance> processes = new ArrayList<InternalProcessInstance>(); final Date currentDate = new Date(); final Date beginningOfTheDay = DateUtil.getBeginningOfTheDay(currentDate); final Date atRisk = DateUtil.backTo(beginningOfTheDay, -(remainingDays + 1)); if (access) { final String applicationName = EnvTool.getApplicationAccessName(); if (applicationName != null) { final Set<ProcessDefinitionUUID> visibleProcessUUIDs = FacadeUtil.getAllowedProcessUUIDsFor(applicationName, RuleType.PROCESS_READ); if (visibleProcessUUIDs != null && !visibleProcessUUIDs.isEmpty()) { processes = EnvTool.getAllQueriers(getQueryList()) .getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(userId, currentDate, atRisk, startingIndex, pageSize, visibleProcessUUIDs, pagingCriterion); } } } else { processes = EnvTool.getAllQueriers(getQueryList()) .getParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(userId, currentDate, atRisk, startingIndex, pageSize, pagingCriterion); } return processes; }
@Override public Integer getNumberOfParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(final String userId, final int remainingDays) { final boolean access = EnvTool.isRestrictedApplicationAcces(); final Date currentDate = new Date(); final Date beginningOfTheDay = DateUtil.getBeginningOfTheDay(currentDate); final Date atRisk = DateUtil.backTo(beginningOfTheDay, -(remainingDays + 1)); if (access) { final String applicationName = EnvTool.getApplicationAccessName(); if (applicationName != null) { final Set<ProcessDefinitionUUID> visibleProcessUUIDs = FacadeUtil.getAllowedProcessUUIDsFor(applicationName, RuleType.PROCESS_READ); if (visibleProcessUUIDs != null && !visibleProcessUUIDs.isEmpty()) { return EnvTool.getAllQueriers(getQueryList()) .getNumberOfParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(userId, currentDate, atRisk, visibleProcessUUIDs); } } return 0; } else { return EnvTool.getAllQueriers(getQueryList()) .getNumberOfParentProcessInstancesWithActiveUserAndActivityInstanceExpectedEndDate(userId, currentDate, atRisk); } }