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 AccessFilter) {
      myFilter = (AccessFilter) filter;
    } else {
      myFilter = new AccessFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    if (myFilter.getTaskId() != null) {
      List<Integer> descendants = null;
      List<Integer> ancestors = null;
      final TaskNode node = taskTree.getTaskNodeById(myFilter.getTaskId());
      if (myFilter.isIncludeDescendentTasks() == true) {
        descendants = node.getDescendantIds();
      }
      if (myFilter.isInherit() == true || myFilter.isIncludeAncestorTasks() == true) {
        ancestors = node.getAncestorIds();
      }
      if (descendants != null || ancestors != null) {
        final List<Integer> taskIds = new ArrayList<Integer>();
        if (descendants != null) {
          taskIds.addAll(descendants);
        }
        if (ancestors != null) {
          taskIds.addAll(ancestors);
        }
        taskIds.add(node.getId());
        queryFilter.add(Restrictions.in("task.id", taskIds));
      } else {
        queryFilter.add(Restrictions.eq("task.id", myFilter.getTaskId()));
      }
    }
    if (myFilter.getGroupId() != null) {
      final GroupDO group = new GroupDO();
      group.setId(myFilter.getGroupId());
      queryFilter.add(Restrictions.eq("group", group));
    }
    final List<GroupTaskAccessDO> qlist = getList(queryFilter);
    List<GroupTaskAccessDO> list;
    if (myFilter.getTaskId() != null && myFilter.isInherit() == true && myFilter.isIncludeAncestorTasks() == false) {
      // Now we have to remove all inherited entries of ancestor nodes which are not declared as recursive.

View Full Code Here

    if (filter instanceof TrainingAttendeeFilter) {
      myFilter = (TrainingAttendeeFilter) filter;
    } else {
      myFilter = new TrainingAttendeeFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    final String searchString = myFilter.getSearchString();


    if (myFilter.getAttendeeId() != null) {
      final PFUserDO attendee = new PFUserDO();
      attendee.setId(myFilter.getAttendeeId());
      queryFilter.add(Restrictions.eq("trainingAttendee", attendee));
    }
    if (myFilter.getTrainingId() != null) {
      final TrainingDO training = new TrainingDO();
      training.setId(myFilter.getTrainingId());
      queryFilter.add(Restrictions.eq("training", training));
    }
    queryFilter.addOrder(Order.desc("created"));
    final List<TrainingAttendeeDO> list = getList(queryFilter);
    myFilter.setSearchString(searchString); // Restore search string.
    return list;
  }

View Full Code Here

    assertEquals("testa3", address.getName());


    // Select filter
    BaseSearchFilter searchFilter = new BaseSearchFilter();
    searchFilter.setSearchString("testa*");
    QueryFilter filter = new QueryFilter(searchFilter);
    filter.addOrder(Order.asc("name"));
    List<AddressDO> result = addressDao.getList(filter);
    assertEquals("Should found 3 address'.", 3, result.size());
    HashSet<String> set = new HashSet<String>();
    set.add("testa1");
    set.add("testa2");

View Full Code Here

    if (filter instanceof ToDoFilter) {
      myFilter = (ToDoFilter) filter;
    } else {
      myFilter = new ToDoFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    final Collection<ToDoStatus> col = new ArrayList<ToDoStatus>(5);
    final String searchString = myFilter.getSearchString();
    if (myFilter.isOnlyRecent() == true) {
      final PFUserDO assignee = new PFUserDO();
      assignee.setId(PFUserContext.getUserId());
      queryFilter.add(Restrictions.eq("assignee", assignee));
      myFilter.setSearchString(""); // Delete search string for ignoring it.
      queryFilter.add(Restrictions.eq("recent", true));
    } else {
      if (myFilter.isOpened() == true) {
        col.add(ToDoStatus.OPENED);
      }
      if (myFilter.isClosed() == true) {
        col.add(ToDoStatus.CLOSED);
      }
      if (myFilter.isPostponed() == true) {
        col.add(ToDoStatus.POSTPONED);
      }
      if (myFilter.isReopened() == true) {
        col.add(ToDoStatus.RE_OPENED);
      }
      if (myFilter.isInprogress() == true) {
        col.add(ToDoStatus.IN_PROGRESS);
      }
      if (col.size() > 0) {
        queryFilter.add(Restrictions.in("status", col));
      }
      if (myFilter.getTaskId() != null) {
        final TaskNode node = taskTree.getTaskNodeById(myFilter.getTaskId());
        final List<Integer> taskIds = node.getDescendantIds();
        taskIds.add(node.getId());
        queryFilter.add(Restrictions.in("task.id", taskIds));
      }
      if (myFilter.getAssigneeId() != null) {
        final PFUserDO assignee = new PFUserDO();
        assignee.setId(myFilter.getAssigneeId());
        queryFilter.add(Restrictions.eq("assignee", assignee));
      }
      if (myFilter.getReporterId() != null) {
        final PFUserDO reporter = new PFUserDO();
        reporter.setId(myFilter.getReporterId());
        queryFilter.add(Restrictions.eq("reporter", reporter));
      }
    }
    queryFilter.addOrder(Order.desc("created"));
    final List<ToDoDO> list = getList(queryFilter);
    myFilter.setSearchString(searchString); // Restore search string.
    return list;
  }

View Full Code Here

    assertEquals("testa3", address.getName());


    // Select filter
    final BaseSearchFilter searchFilter = new BaseSearchFilter();
    searchFilter.setSearchString("testa*");
    final QueryFilter filter = new QueryFilter(searchFilter);
    filter.addOrder(Order.asc("name"));
    final List<ContactDO> result = contactDao.getList(filter);
    assertEquals("Should found 3 address'.", 3, result.size());
    final HashSet<String> set = new HashSet<String>();
    set.add("testa1");
    set.add("testa2");

View Full Code Here

    if (filter instanceof TrainingFilter) {
      myFilter = (TrainingFilter) filter;
    } else {
      myFilter = new TrainingFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    final String searchString = myFilter.getSearchString();


    if (myFilter.getSkillId() != null) {
      final SkillDO skill = new SkillDO();
      skill.setId(myFilter.getSkillId());
      queryFilter.add(Restrictions.eq("skill", skill));
    }
    if (myFilter.getTrainingId() != null) {
      queryFilter.add(Restrictions.eq("id", myFilter.getTrainingId()));
    }
    queryFilter.addOrder(Order.desc("created"));
    final List<TrainingDO> list = getList(queryFilter);
    myFilter.setSearchString(searchString); // Restore search string.
    return list;
  }

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.