Examples of org.projectforge.core.QueryFilter

org.projectforge.core.QueryFilter
Stores the expressions and settings for creating a hibernate criteria object. This template is useful for avoiding the need of a hibernate session in the stripes action classes. @author Kai Reinhard (k.reinhard@micromata.de)

    if (filter instanceof EmployeeFilter) {
      myFilter = (EmployeeFilter) filter;
    } else {
      myFilter = new EmployeeFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    final List<EmployeeDO> list = getList(queryFilter);
    final Date now = new Date();
    if (myFilter.isShowOnlyActiveEntries() == true) {
      CollectionUtils.filter(list, new Predicate() {
        public boolean evaluate(final Object object)

View Full Code Here

    if (filter instanceof TaskFilter) {
      myFilter = (TaskFilter) filter;
    } else {
      myFilter = new TaskFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    final Collection<TaskStatus> col = new ArrayList<TaskStatus>(4);
    if (myFilter.isNotOpened() == true) {
      col.add(TaskStatus.N);
    }
    if (myFilter.isOpened() == true) {
      col.add(TaskStatus.O);
    }
    if (myFilter.isClosed() == true) {
      col.add(TaskStatus.C);
    }
    if (col.size() > 0) {
      queryFilter.add(Restrictions.in("status", col));
    } else {
      // Note: Result set should be empty, because every task should has one of the following status values.
      queryFilter.add(Restrictions.not(Restrictions.in("status", new TaskStatus[] { TaskStatus.N, TaskStatus.O, TaskStatus.C})));
    }
    queryFilter.addOrder(Order.asc("title"));
    if (log.isDebugEnabled() == true) {
      log.debug(myFilter.toString());
    }
    return getList(queryFilter);
  }

View Full Code Here

    return new PollEventDO();
  }


  public List<PollEventDO> getListByPoll(PollDO poll)
  {
    QueryFilter qFilter = new QueryFilter();
    qFilter.add(Restrictions.and(Restrictions.eq("poll", poll), Restrictions.eq("deleted", false)));
    return getList(qFilter);
  }

View Full Code Here

   * @param poll
   * @return
   */
  public List<PollAttendeeDO> getListByPoll(final PollDO poll)
  {
    final QueryFilter qFilter = new QueryFilter();
    if(poll != null && poll.getId() != null) {
      qFilter.add(Restrictions.and(Restrictions.eq("poll", poll), Restrictions.eq("deleted", false)));
    }
    return getList(qFilter);
  }

View Full Code Here

   * @param poll - poll to check
   * @return
   */
  public boolean verifyUserOrKey(final PFUserDO user, final String secureKey, final PollDO poll)
  {
    final QueryFilter qFilter = new QueryFilter();
    if (user != null) {
      qFilter.add(Restrictions.and(Restrictions.and(Restrictions.eq("poll", poll), Restrictions.eq("user", user)),
          Restrictions.eq("deleted", false)));
    } else {
      qFilter.add(Restrictions.and(Restrictions.and(Restrictions.eq("poll", poll), Restrictions.eq("secureKey", secureKey)),
          Restrictions.eq("deleted", false)));
    }
    return !getList(qFilter).isEmpty();
  }

View Full Code Here

    return userGroupCache;
  }


  public QueryFilter getDefaultFilter()
  {
    final QueryFilter queryFilter = new QueryFilter();
    queryFilter.add(Restrictions.eq("deleted", false));
    return queryFilter;
  }

View Full Code Here

    if (filter instanceof PFUserFilter) {
      myFilter = (PFUserFilter) filter;
    } else {
      myFilter = new PFUserFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    if (myFilter.getDeactivatedUser() != null) {
      queryFilter.add(Restrictions.eq("deactivated", myFilter.getDeactivatedUser()));
    }
    if (Login.getInstance().hasExternalUsermanagementSystem() == true) {
      // Check hasExternalUsermngmntSystem because otherwise the filter is may-be preset for an user and the user can't change the filter
      // (because the fields aren't visible).
      if (myFilter.getRestrictedUser() != null) {
        queryFilter.add(Restrictions.eq("restrictedUser", myFilter.getRestrictedUser()));
      }
      if (myFilter.getLocalUser() != null) {
        queryFilter.add(Restrictions.eq("localUser", myFilter.getLocalUser()));
      }
    }
    if (myFilter.getHrPlanning() != null) {
      queryFilter.add(Restrictions.eq("hrPlanning", myFilter.getHrPlanning()));
    }
    queryFilter.addOrder(Order.asc("username"));
    List<PFUserDO> list = getList(queryFilter);
    if (myFilter.getIsAdminUser() != null) {
      final List<PFUserDO> origList = list;
      list = new LinkedList<PFUserDO>();
      for (final PFUserDO user : origList) {

View Full Code Here

    return taskTree.getKost2List(timesheet.getTaskId());
  }


  public QueryFilter buildQueryFilter(final TimesheetFilter filter)
  {
    final QueryFilter queryFilter = new QueryFilter(filter);
    if (filter.getUserId() != null) {
      final PFUserDO user = new PFUserDO();
      user.setId(filter.getUserId());
      queryFilter.add(Restrictions.eq("user", user));
    }
    if (filter.getStartTime() != null && filter.getStopTime() != null) {
      queryFilter.add(Restrictions.between("startTime", filter.getStartTime(), filter.getStopTime()));
    } else if (filter.getStartTime() != null) {
      queryFilter.add(Restrictions.ge("startTime", filter.getStartTime()));
    } else if (filter.getStopTime() != null) {
      queryFilter.add(Restrictions.le("startTime", filter.getStopTime()));
    }
    if (filter.getTaskId() != null) {
      if (filter.isRecursive() == true) {
        final TaskNode node = taskTree.getTaskNodeById(filter.getTaskId());
        final List<Integer> taskIds = node.getDescendantIds();
        taskIds.add(node.getId());
        queryFilter.add(Restrictions.in("task.id", taskIds));
        if (log.isDebugEnabled() == true) {
          log.debug("search in tasks: " + taskIds);
        }
      } else {
        queryFilter.add(Restrictions.eq("task.id", filter.getTaskId()));
      }
    }
    if (filter.getOrderType() == OrderDirection.DESC) {
      queryFilter.addOrder(Order.desc("startTime"));
    } else {
      queryFilter.addOrder(Order.asc("startTime"));
    }
    if (log.isDebugEnabled() == true) {
      log.debug(ToStringBuilder.reflectionToString(filter));
    }
    return queryFilter;

View Full Code Here

    if (myFilter.getStopTime() != null) {
      final DateHolder date = new DateHolder(myFilter.getStopTime());
      date.setEndOfDay();
      myFilter.setStopTime(date.getDate());
    }
    final QueryFilter queryFilter = buildQueryFilter(myFilter);
    List<TimesheetDO> result = getList(queryFilter);
    if (result == null) {
      return null;
    }
    // Check time period overlaps:

View Full Code Here

  }


  public List<TimesheetDO> getTimeperiodOverlapList(final TimesheetListFilter actionFilter)
  {
    if (actionFilter.getUserId() != null) {
      final QueryFilter queryFilter = new QueryFilter(actionFilter);
      final Set<Integer> set = getTimesheetsWithTimeoverlap(actionFilter.getUserId());
      if (set == null || set.size() == 0) {
        // No time sheets with overlap found.
        return new ArrayList<TimesheetDO>();
      }
      queryFilter.add(Restrictions.in("id", set));
      final List<TimesheetDO> result = getList(queryFilter);
      for (final TimesheetDO entry : result) {
        entry.setMarked(true);
      }
      Collections.sort(result, Collections.reverseOrder());

View Full Code Here

0 1 2 3 4 5

TOP

Related Classes of org.projectforge.core.QueryFilter

org.hibernate.Criteria

org.projectforge.access.AccessDao

org.projectforge.address.AddressDao

org.projectforge.address.AddressTest

org.projectforge.book.BookDao

org.projectforge.fibu.AuftragDao

org.projectforge.fibu.EingangsrechnungDao

org.projectforge.fibu.EmployeeDao

org.projectforge.fibu.EmployeeSalaryDao

org.projectforge.fibu.kost.BuchungssatzDao

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.