Package org.projectforge.core

Examples of org.projectforge.core.QueryFilter

172
173
174
175
176
177
178
179
180
181
182
183
   */
  @Transactional(readOnly = true, propagation = Propagation.SUPPORTS)
  public List<PFUserDO> getUnplannedResources(final HRViewData data)
  {
    final List<PFUserDO> users = new ArrayList<PFUserDO>();
    final QueryFilter queryFilter = new QueryFilter(new BaseSearchFilter());
    queryFilter.addOrder(Order.asc("firstname")).addOrder(Order.asc("lastname"));
    final List<PFUserDO> allUsers = userDao.getList(queryFilter);
    if (allUsers != null) {
      for (final PFUserDO user : allUsers) {
        final HRViewUserData userData = data.getUserData(user);
        if (userData == null || NumberHelper.isNotZero(userData.getPlannedDaysSum()) == false) {
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
    if (filter instanceof PostFilter) {
      myFilter = (PostFilter) filter;
    } else {
      myFilter = new PostFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(filter);
    queryFilter.setYearAndMonth("datum", myFilter.getYear(), myFilter.getMonth());
    queryFilter.addOrder(Order.desc("datum"));
    queryFilter.addOrder(Order.asc("absender"));
    final List<PosteingangDO> list = getList(queryFilter);
    return list;
  }
View Full Code Here
72
73
74
75
76
77
78
79
    this.supportAfterUpdate = true;
  }

  public QueryFilter getDefaultFilter()
  {
    final QueryFilter queryFilter = new QueryFilter();
    return queryFilter;
  }
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
    if (filter instanceof GroupFilter) {
      myFilter = (GroupFilter) filter;
    } else {
      myFilter = new GroupFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    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.getLocalGroup() != null) {
        queryFilter.add(Restrictions.eq("localGroup", myFilter.getLocalGroup()));
      }
    }
    queryFilter.addOrder(Order.asc("name"));
    return getList(queryFilter);
  }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
    if (filter instanceof PostFilter) {
      myFilter = (PostFilter) filter;
    } else {
      myFilter = new PostFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(filter);
    queryFilter.setYearAndMonth("datum", myFilter.getYear(), myFilter.getMonth());
    queryFilter.addOrder(Order.desc("datum"));
    queryFilter.addOrder(Order.asc("empfaenger"));
    final List<PostausgangDO> list = getList(queryFilter);
    return list;
  }
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
    if (filter instanceof ContractFilter) {
      myFilter = (ContractFilter) filter;
    } else {
      myFilter = new ContractFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    if (myFilter.getStatus() != null) {
      queryFilter.add(Restrictions.eq("status", myFilter.getStatus().name()));
    }
    if (myFilter.getType() != null) {
      queryFilter.add(Restrictions.eq("type", myFilter.getType().getValue()));
    }
    queryFilter.setYearAndMonth("date", myFilter.getYear(), -1);
    if (log.isDebugEnabled() == true) {
      log.debug(myFilter.toString());
    }
    return getList(queryFilter);
  }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
    if (myFilter.getStopTime() != null) {
      final DateHolder date = new DateHolder(myFilter.getStopTime());
      date.setEndOfDay();
      myFilter.setStopTime(date.getDate());
    }
    final QueryFilter queryFilter = buildQueryFilter(myFilter);
    myFilter.setIgnoreDeleted(true); // Ignore deleted flag of HRPlanningEntryDOs, use instead:
    if (myFilter.isDeleted() == true) {
      queryFilter.add(Restrictions.or(Restrictions.eq("deleted", true), Restrictions.eq("p.deleted", true)));
    } else {
      queryFilter.add(Restrictions.and(Restrictions.eq("deleted", false), Restrictions.eq("p.deleted", false)));
    }
    final List<HRPlanningEntryDO> list = getList(queryFilter);
    if (list == null) {
      return null;
    }
View Full Code Here
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
    return result;
  }

  public QueryFilter buildQueryFilter(final HRPlanningFilter filter)
  {
    final QueryFilter queryFilter = new QueryFilter(filter);
    queryFilter.createAlias("planning", "p").createAlias("p.user", "u");
    if (filter.getUserId() != null) {
      final PFUserDO user = new PFUserDO();
      user.setId(filter.getUserId());
      queryFilter.add(Restrictions.eq("p.user", user));
    }
    if (filter.getStartTime() != null && filter.getStopTime() != null) {
      queryFilter.add(Restrictions.between("p.week", filter.getStartTime(), filter.getStopTime()));
    } else if (filter.getStartTime() != null) {
      queryFilter.add(Restrictions.ge("p.week", filter.getStartTime()));
    } else if (filter.getStopTime() != null) {
      queryFilter.add(Restrictions.le("p.week", filter.getStopTime()));
    }
    if (filter.getProjektId() != null) {
      queryFilter.add(Restrictions.eq("projekt.id", filter.getProjektId()));
    }
    queryFilter.addOrder(Order.desc("p.week")).addOrder(Order.asc("u.firstname"));
    if (log.isDebugEnabled() == true) {
      log.debug(ToStringBuilder.reflectionToString(filter));
    }
    return queryFilter;
  }
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
    if (myFilter.getStopTime() != null) {
      final DateHolder date = new DateHolder(myFilter.getStopTime());
      date.setEndOfDay();
      myFilter.setStopTime(date.getDate());
    }
    final QueryFilter queryFilter = buildQueryFilter(myFilter);
    final List<HRPlanningDO> result = getList(queryFilter);
    if (result == null) {
      return null;
    }
    return result;
View Full Code Here
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
    return result;
  }

  public QueryFilter buildQueryFilter(final HRPlanningFilter 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("week", filter.getStartTime(), filter.getStopTime()));
    } else if (filter.getStartTime() != null) {
      queryFilter.add(Restrictions.ge("week", filter.getStartTime()));
    } else if (filter.getStopTime() != null) {
      queryFilter.add(Restrictions.le("week", filter.getStopTime()));
    }
    if (filter.getProjektId() != null) {
      queryFilter.add(Restrictions.eq("projekt.id", filter.getProjektId()));
    }
    queryFilter.addOrder(Order.desc("week"));
    if (log.isDebugEnabled() == true) {
      log.debug(ToStringBuilder.reflectionToString(filter));
    }
    return queryFilter;
  }
View Full Code Here
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
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.