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 (timesheetsWithOverlapByUser.get(userId) != null) {
        return timesheetsWithOverlapByUser.get((userId));
      }
      // log.info("Getting time sheet overlaps for user: " + user.getUsername());
      final Set<Integer> result = new HashSet<Integer>();
      final QueryFilter queryFilter = new QueryFilter();
      queryFilter.add(Restrictions.eq("user", user));
      queryFilter.addOrder(Order.asc("startTime"));
      final List<TimesheetDO> list = getList(queryFilter);
      long endTime = 0;
      TimesheetDO lastEntry = null;
      for (final TimesheetDO entry : list) {
        if (entry.getStartTime().getTime() < endTime) {

View Full Code Here


  @Override
  public List<UserPrefDO> getList(final BaseSearchFilter filter)
  {
    final UserPrefFilter myFilter = (UserPrefFilter) filter;
    final QueryFilter queryFilter = new QueryFilter(filter);
    if (myFilter.getArea() != null) {
      queryFilter.add(Restrictions.eq("areaString", myFilter.getArea().getId()));
    }
    queryFilter.addOrder(Order.asc("areaString"));
    queryFilter.addOrder(Order.asc("name"));
    final List<UserPrefDO> list = getList(queryFilter);
    return list;
  }

View Full Code Here

   */
  public boolean hasTimeOverlap(final TimesheetDO timesheet, final boolean throwException)
  {
    Validate.notNull(timesheet);
    Validate.notNull(timesheet.getUser());
    final QueryFilter queryFilter = new QueryFilter();
    queryFilter.add(Restrictions.eq("user", timesheet.getUser()));
    queryFilter.add(Restrictions.lt("startTime", timesheet.getStopTime()));
    queryFilter.add(Restrictions.gt("stopTime", timesheet.getStartTime()));
    if (timesheet.getId() != null) {
      // Update time sheet, do not compare with itself.
      queryFilter.add(Restrictions.ne("id", timesheet.getId()));
    }
    final List<TimesheetDO> list = getList(queryFilter);
    if (list != null && list.size() > 0) {
      final TimesheetDO ts = list.get(0);
      if (throwException == true) {

View Full Code Here

    if (filter instanceof BookFilter) {
      myFilter = (BookFilter) filter;
    } else {
      myFilter = new BookFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    if (StringUtils.isBlank(myFilter.getSearchString()) == true) {
      Collection<BookStatus> col = null;
      if (myFilter.isPresent() == true || myFilter.isMissed() == true || myFilter.isDisposed() == true) {
        col = new ArrayList<BookStatus>();
        if (myFilter.isPresent() == true) {
          // Book must be have status 'present'.
          col.add(BookStatus.PRESENT);
        }
        if (myFilter.isMissed() == true) {
          // Book must be have status 'missed'.
          col.add(BookStatus.MISSED);
        }
        if (myFilter.isDisposed() == true) {
          // Book must be have status 'disposed'.
          col.add(BookStatus.DISPOSED);
        }
      }
      myFilter.setIgnoreDeleted(false);
      if (col != null) {
        final Criterion inCrit = Restrictions.in("status", col);
        if (myFilter.isDeleted() == true) {
          queryFilter.add(Restrictions.or(inCrit, Restrictions.eq("deleted", true)));
          myFilter.setIgnoreDeleted(true);
        } else {
          queryFilter.add(inCrit);
        }
      }
    }
    queryFilter.addOrder(Order.desc("created"));
    queryFilter.addOrder(Order.asc("authors"));
    return getList(queryFilter);
  }

View Full Code Here

  }


  @Override
  public List<UserRightDO> getList(BaseSearchFilter filter)
  {
    final QueryFilter queryFilter = new QueryFilter(filter);
    final UserRightFilter myFilter = (UserRightFilter) filter;
    if (myFilter.getUser() != null) {
      queryFilter.add(Restrictions.eq("user", myFilter.getUser()));
    }
    queryFilter.createAlias("user", "u");
    queryFilter.addOrder(Order.asc("u.username")).addOrder(Order.asc("rightIdString"));
    List<UserRightDO> list = getList(queryFilter);
    return list;
  }

View Full Code Here

    if (filter instanceof EmployeeSalaryFilter) {
      myFilter = (EmployeeSalaryFilter) filter;
    } else {
      myFilter = new EmployeeSalaryFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    if (myFilter.getYear() >= 0) {
      queryFilter.add(Restrictions.eq("year", myFilter.getYear()));
      if (myFilter.getMonth() >= 0) {
        queryFilter.add(Restrictions.eq("month", myFilter.getMonth()));
      }
    }
    queryFilter.addOrder(Order.desc("year")).addOrder(Order.desc("month"));


    List<EmployeeSalaryDO> list = getList(queryFilter);
    return list;
  }

View Full Code Here

  }


  @Override
  public List<Kost2ArtDO> getList(BaseSearchFilter filter)
  {
    QueryFilter queryFilter = new QueryFilter(filter);
    queryFilter.addOrder(Order.asc("id"));
    return getList(queryFilter);
  }

View Full Code Here

    if (filter instanceof AuftragFilter) {
      myFilter = (AuftragFilter) filter;
    } else {
      myFilter = new AuftragFilter(filter);
    }
    final QueryFilter queryFilter = new QueryFilter(myFilter);
    Boolean vollstaendigFakturiert = null;
    if (myFilter.isShowBeauftragtNochNichtVollstaendigFakturiert() == true) {
      queryFilter.add(Restrictions.not(Restrictions.in("auftragsStatus", new AuftragsStatus[] { AuftragsStatus.ABGELEHNT,
          AuftragsStatus.ERSETZT, AuftragsStatus.GELEGT, AuftragsStatus.GROB_KALKULATION, AuftragsStatus.IN_ERSTELLUNG})));
      vollstaendigFakturiert = false;
    } else if (myFilter.isShowNochNichtVollstaendigFakturiert() == true) {
      queryFilter.add(Restrictions.not(Restrictions.in("auftragsStatus", new AuftragsStatus[] { AuftragsStatus.ABGELEHNT,
          AuftragsStatus.ERSETZT})));
      vollstaendigFakturiert = false;
    } else if (myFilter.isShowVollstaendigFakturiert() == true) {
      vollstaendigFakturiert = true;
    } else if (myFilter.isShowAbgelehnt() == true) {
      queryFilter.add(Restrictions.eq("auftragsStatus", AuftragsStatus.ABGELEHNT));
    } else if (myFilter.isShowAbgeschlossenNichtFakturiert() == true) {
      queryFilter
      .createAlias("positionen", "position")
      .createAlias("paymentSchedules", "paymentSchedule", Criteria.FULL_JOIN)
      .add(
          Restrictions.or(
              Restrictions.or(Restrictions.eq("auftragsStatus", AuftragsStatus.ABGESCHLOSSEN),
                  Restrictions.eq("position.status", AuftragsPositionsStatus.ABGESCHLOSSEN)),
                  Restrictions.eq("paymentSchedule.reached", true)));
      vollstaendigFakturiert = false;
    } else if (myFilter.isShowAkquise() == true) {
      queryFilter.add(Restrictions.in("auftragsStatus", new AuftragsStatus[] { AuftragsStatus.GELEGT, AuftragsStatus.IN_ERSTELLUNG,
          AuftragsStatus.GROB_KALKULATION}));
    } else if (myFilter.isShowBeauftragt() == true) {
      queryFilter.add(Restrictions.in("auftragsStatus", new AuftragsStatus[] { AuftragsStatus.BEAUFTRAGT, AuftragsStatus.LOI,
          AuftragsStatus.ESKALATION}));
    } else if (myFilter.isShowErsetzt() == true) {
      queryFilter.add(Restrictions.eq("auftragsStatus", AuftragsStatus.ERSETZT));
    }
    if (myFilter.getYear() > 1900) {
      final Calendar cal = DateHelper.getUTCCalendar();
      cal.set(Calendar.YEAR, myFilter.getYear());
      java.sql.Date lo = null;
      java.sql.Date hi = null;
      cal.set(Calendar.DAY_OF_YEAR, 1);
      lo = new java.sql.Date(cal.getTimeInMillis());
      final int lastDayOfYear = cal.getActualMaximum(Calendar.DAY_OF_YEAR);
      cal.set(Calendar.DAY_OF_YEAR, lastDayOfYear);
      hi = new java.sql.Date(cal.getTimeInMillis());
      queryFilter.add(Restrictions.between("angebotsDatum", lo, hi));
    }
    queryFilter.addOrder(Order.desc("nummer"));
    final List<AuftragDO> list;
    if (checkAccess == true) {
      list = getList(queryFilter);
    } else {
      list = internalGetList(queryFilter);

View Full Code Here

    sheetProvider.putFormat(AccountsCol.DATE_OF_LAST_MODIFICATION, "dd.MM.yyyy HH:mm");
    sheetProvider.putFormat(AccountsCol.DATE_OF_CREATION, "dd.MM.yyyy HH:mm");
    sheetProvider.putFormat(AccountsCol.NUMBER, "#");


    final KontoDao kontoDao = Registry.instance().getDao(KontoDao.class);
    final QueryFilter filter = new QueryFilter();
    filter.addOrder(Order.desc("lastUpdate"));
    final List<KontoDO> list = kontoDao.getList(filter);


    final PropertyMapping mapping = new PropertyMapping();
    for (final KontoDO konto : list) {
      mapping.add(AccountsCol.NUMBER, konto.getNummer());

View Full Code Here

    final String searchNumber = NumberHelper.extractPhonenumber(number);
    final AddressDao addressDao = (AddressDao) Registry.instance().getDao(AddressDao.class);


    final BaseSearchFilter filter = new BaseSearchFilter();
    filter.setSearchString("*" + searchNumber);
    final QueryFilter queryFilter = new QueryFilter(filter);


    final StringBuffer buf = new StringBuffer();
    // Use internal get list method for avoiding access checking (no user is logged-in):
    final List<AddressDO> list = addressDao.internalGetList(queryFilter);
    if (list != null && list.size() >= 1) {

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.