Esempio n. 1
0
  @Override
  public void DocumentsRoutedReport(Stats stats, Date begDate, Date endDate)
      throws SQLException, LookupException {
    Query query =
        entityManager.createQuery(
            "select count(*) as count, drhv.docRouteStatus from DocumentRouteHeaderValue drhv where drhv.createDate between :beginDate and :endDate group by docRouteStatus");
    //        Query query = entityManager.createNamedQuery("Stats.DocumentsRoutedReport");
    query.setParameter("beginDate", new Timestamp(begDate.getTime()));
    query.setParameter("endDate", new Timestamp(endDate.getTime()));

    @SuppressWarnings("unchecked")
    List<Object[]> resultList = query.getResultList();

    for (Object[] result : resultList) {
      String actionType = result[1].toString();
      String number = result[0].toString();
      if (actionType.equals(KEWConstants.ROUTE_HEADER_CANCEL_CD)) {
        stats.setCanceledNumber(number);
      } else if (actionType.equals(KEWConstants.ROUTE_HEADER_DISAPPROVED_CD)) {
        stats.setDisapprovedNumber(number);
      } else if (actionType.equals(KEWConstants.ROUTE_HEADER_ENROUTE_CD)) {
        stats.setEnrouteNumber(number);
      } else if (actionType.equals(KEWConstants.ROUTE_HEADER_EXCEPTION_CD)) {
        stats.setExceptionNumber(number);
      } else if (actionType.equals(KEWConstants.ROUTE_HEADER_FINAL_CD)) {
        stats.setFinalNumber(number);
      } else if (actionType.equals(KEWConstants.ROUTE_HEADER_INITIATED_CD)) {
        stats.setInitiatedNumber(number);
      } else if (actionType.equals(KEWConstants.ROUTE_HEADER_PROCESSED_CD)) {
        stats.setProcessedNumber(number);
      } else if (actionType.equals(KEWConstants.ROUTE_HEADER_SAVED_CD)) {
        stats.setSavedNumber(number);
      }
    }
  }
Esempio n. 2
0
 @Override
 public void NumActiveItemsReport(Stats stats) throws SQLException, LookupException {
   stats.setNumActionItems(
       entityManager
           .createQuery("select count(*) from ActionItem ai")
           .getSingleResult()
           .toString());
   //
   // stats.setNumActionItems(entityManager.createNamedQuery("Stats.NumActiveItemsReport").getSingleResult().toString());
 }
Esempio n. 3
0
 @Override
 public void NumUsersReport(Stats stats) throws SQLException, LookupException {
   stats.setNumUsers(
       entityManager
           .createQuery("select count(distinct uo.workflowId) from UserOptions uo")
           .getSingleResult()
           .toString());
   //
   // stats.setNumUsers(entityManager.createNamedQuery("Stats.NumUsersReport").getSingleResult().toString());
 }
Esempio n. 4
0
 @Override
 public void NumberOfDocTypesReport(Stats stats) throws SQLException, LookupException {
   stats.setNumDocTypes(
       entityManager
           .createQuery("select count(*) from DocumentType dt where dt.currentInd = true")
           .getSingleResult()
           .toString());
   //
   // stats.setNumDocTypes(entityManager.createNamedQuery("Stats.NumberOfDocTypesReport").getSingleResult().toString());
 }
Esempio n. 5
0
  @Override
  public void NumInitiatedDocsByDocTypeReport(Stats stats) throws SQLException, LookupException {
    Query query =
        entityManager.createQuery(
            "select count(*), dt.name from DocumentRouteHeaderValue drhv, DocumentType dt where drhv.createDate > :createDate and drhv.documentTypeId = dt.documentTypeId group by dt.name");
    //        Query query = entityManager.createNamedQuery("Stats.NumInitiatedDocsByDocTypeReport");
    Calendar calendar = Calendar.getInstance();
    calendar.add(Calendar.DAY_OF_YEAR, -29);
    calendar.set(Calendar.HOUR_OF_DAY, 0);
    calendar.set(Calendar.MINUTE, 0);
    calendar.set(Calendar.SECOND, 0);
    calendar.set(Calendar.MILLISECOND, 0);
    query.setParameter("createDate", new Timestamp(calendar.getTime().getTime()));

    @SuppressWarnings("unchecked")
    List<Object[]> resultList = query.getResultList();

    List<KeyValue> numDocs = new ArrayList<KeyValue>(resultList.size());
    for (Object[] result : resultList) {
      numDocs.add(new ConcreteKeyValue(result[1].toString(), result[0].toString()));
    }

    stats.setNumInitiatedDocsByDocType(numDocs);
  }