Example usage for org.hibernate.criterion Restrictions lt

List of usage examples for org.hibernate.criterion Restrictions lt

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. lt

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions lt.

Prototype

public static SimpleExpression lt(String propertyName, Object value)

Source Link

Document

Apply a "less than" constraint to the named property

Usage

From source file:org.linagora.linshare.core.repository.hibernate.LogEntryRepositoryImpl.java

License:Open Source License

public List<LogEntry> findByCriteria(LogCriteriaBean logCriteria, String domainId) {

    DetachedCriteria criteria = DetachedCriteria.forClass(LogEntry.class);

    if (CollectionUtils.isNotEmpty(logCriteria.getActorMails())) {
        Disjunction or = Restrictions.disjunction();
        for (String mail : logCriteria.getActorMails()) {
            if (StringUtils.isNotBlank(mail))
                or.add(Restrictions.like("actorMail", mail, MatchMode.ANYWHERE));
        }/*from  w ww .ja  v  a  2  s. c om*/
        criteria.add(or);
    }

    if (CollectionUtils.isNotEmpty(logCriteria.getTargetMails())) {
        Disjunction or = Restrictions.disjunction();
        for (String mail : logCriteria.getTargetMails()) {
            if (StringUtils.isNotBlank(mail))
                or.add(Restrictions.like("targetMail", mail, MatchMode.ANYWHERE));
        }
        criteria.add(or);
    }

    if (StringUtils.isNotBlank(logCriteria.getActorFirstname())) {
        criteria.add(Restrictions.like("actorFirstname", logCriteria.getActorFirstname(), MatchMode.ANYWHERE)
                .ignoreCase());
    }

    if (StringUtils.isNotBlank(logCriteria.getActorLastname())
            && (logCriteria.getActorLastname().length() > 0)) {
        criteria.add(Restrictions.like("actorLastname", logCriteria.getActorLastname(), MatchMode.ANYWHERE)
                .ignoreCase());
    }

    if (StringUtils.isNotBlank(domainId)) {
        criteria.add(Restrictions.like("actorDomain", domainId));
    } else if (StringUtils.isNotBlank(logCriteria.getActorDomain())) {
        criteria.add(Restrictions.like("actorDomain", logCriteria.getActorDomain()));
    }

    if (StringUtils.isNotBlank(logCriteria.getTargetFirstname())) {
        criteria.add(Restrictions.like("targetFirstname", logCriteria.getTargetFirstname(), MatchMode.ANYWHERE)
                .ignoreCase());
    }

    if (StringUtils.isNotBlank(logCriteria.getTargetLastname())) {
        criteria.add(Restrictions.like("targetLastname", logCriteria.getTargetLastname(), MatchMode.ANYWHERE)
                .ignoreCase());
    }

    if (StringUtils.isNotBlank(logCriteria.getTargetDomain())) {
        criteria.add(Restrictions.like("targetDomain", logCriteria.getTargetDomain()));
    }

    if (CollectionUtils.isNotEmpty(logCriteria.getLogActions())) {
        criteria.add(Restrictions.in("logAction", logCriteria.getLogActions()));
    }
    if (logCriteria.getBeforeDate() != null) {
        criteria.add(Restrictions.gt("actionDate", logCriteria.getBeforeDate()));
    }

    if (logCriteria.getAfterDate() != null) {
        criteria.add(Restrictions.lt("actionDate", logCriteria.getAfterDate()));
    }

    if (StringUtils.isNotBlank(logCriteria.getFileName())) {

        if (logCriteria.getFileNameMatchMode().equals(CriterionMatchMode.ANYWHERE)) {
            criteria.add(
                    Restrictions.like("fileName", logCriteria.getFileName(), MatchMode.ANYWHERE).ignoreCase());
        } else {
            criteria.add(
                    Restrictions.like("fileName", logCriteria.getFileName(), MatchMode.ANYWHERE).ignoreCase());
        }
    }

    if (StringUtils.isNotBlank(logCriteria.getFileExtension())) {
        criteria.add(Restrictions.like("fileName", logCriteria.getFileExtension(), MatchMode.END).ignoreCase());
    }

    criteria.addOrder(Order.desc("actionDate"));

    return findBy(criteria);
}

From source file:org.linagora.linshare.core.repository.hibernate.OperationHistoryRepositoryImpl.java

License:Open Source License

@Override
public List<AbstractDomain> findDomainBeforeDate(Date creationDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.lt("creationDate", creationDate));
    criteria.setProjection(Projections.distinct(Projections.property("domain")));
    @SuppressWarnings("unchecked")
    List<AbstractDomain> result = (List<AbstractDomain>) getHibernateTemplate().findByCriteria(criteria);
    return result;
}

From source file:org.linagora.linshare.core.repository.hibernate.ShareEntryGroupRepositoryImpl.java

License:Open Source License

@Override
public List<String> findAllAnonymousShareEntriesAboutToBeNotified(Date dt) {
    DetachedCriteria det = DetachedCriteria.forClass(getPersistentClass());
    det.add(Restrictions.eq("notified", false));
    det.add(Restrictions.lt("notificationDate", dt));
    // only identifier instead of entity
    det.setProjection(Projections.property("uuid"));
    det.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    // join/*from www.j ava 2s .  c o m*/
    det.createAlias("anonymousShareEntries", "ase");
    // restrict
    det.add(Restrictions.eq("ase.downloaded", new Long(0)));
    @SuppressWarnings("unchecked")
    List<String> list = listByCriteria(det);
    return list;
}

From source file:org.linagora.linshare.core.repository.hibernate.ShareEntryGroupRepositoryImpl.java

License:Open Source License

@Override
public List<String> findAllShareEntriesAboutToBeNotified(Date dt) {
    DetachedCriteria det = DetachedCriteria.forClass(getPersistentClass());
    det.add(Restrictions.eq("notified", false));
    det.add(Restrictions.lt("notificationDate", dt));
    // only identifier instead of entity
    det.setProjection(Projections.property("uuid"));
    det.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    // join/*from  w  w w .  j a  v a2  s  . c  om*/
    det.createAlias("shareEntries", "se");
    // restrict
    det.add(Restrictions.eq("se.downloaded", new Long(0)));
    @SuppressWarnings("unchecked")
    List<String> list = listByCriteria(det);
    return list;
}

From source file:org.linagora.linshare.core.repository.hibernate.ShareEntryRepositoryImpl.java

License:Open Source License

@Override
public List<ShareEntry> findAllExpiredEntries() {
    List<ShareEntry> entries = findByCriteria(Restrictions.lt("expirationDate", Calendar.getInstance()));
    if (entries == null) {
        logger.error("the result is null ! this should not happen.");
        return new ArrayList<ShareEntry>();
    }//w  w  w .  j a  va2s. c o  m
    return entries;
}

From source file:org.linagora.linshare.core.repository.hibernate.ShareEntryRepositoryImpl.java

License:Open Source License

@Override
public List<ShareEntry> findUpcomingExpiredEntries(Integer date) {
    Calendar calMin = Calendar.getInstance();
    calMin.add(Calendar.DAY_OF_MONTH, date);

    Calendar calMax = Calendar.getInstance();
    calMax.add(Calendar.DAY_OF_MONTH, date + 1);

    return findByCriteria(Restrictions.lt("expirationDate", calMax), Restrictions.gt("expirationDate", calMin));
}

From source file:org.linagora.linshare.core.repository.hibernate.UploadRequestEntryUrlRepositoryImpl.java

License:Open Source License

@Override
public Set<UploadRequestEntryUrl> findAllExpired() {
    HashSet<UploadRequestEntryUrl> set = Sets.newHashSet();
    List<UploadRequestEntryUrl> uREUrl = findByCriteria(Restrictions.lt("expiryDate", new Date()));
    if (uREUrl != null) {
        set.addAll(uREUrl);//from  w  w w  .j ava 2s  .  c o m
    }
    return set;
}

From source file:org.linagora.linshare.core.repository.hibernate.UploadRequestRepositoryImpl.java

License:Open Source License

@Override
public List<String> findOutdatedRequests() {
    DetachedCriteria crit = DetachedCriteria.forClass(getPersistentClass());
    crit.add(Restrictions.lt("expiryDate", new Date()));
    crit.add(Restrictions.eq("status", UploadRequestStatus.STATUS_ENABLED));
    crit.setProjection(Projections.property("uuid"));
    @SuppressWarnings("unchecked")
    List<String> list = listByCriteria(crit);
    return list;/*from w  ww  . j a  va  2  s.c  om*/
}

From source file:org.linagora.linshare.core.repository.hibernate.UploadRequestRepositoryImpl.java

License:Open Source License

@Override
public List<String> findCreatedUploadRequests() {
    DetachedCriteria crit = DetachedCriteria.forClass(getPersistentClass());
    crit.add(Restrictions.lt("activationDate", new Date()));
    crit.add(Restrictions.eq("status", UploadRequestStatus.STATUS_CREATED));
    crit.setProjection(Projections.property("uuid"));
    @SuppressWarnings("unchecked")
    List<String> list = listByCriteria(crit);
    return list;//  w w w. j  a va2s.  c om
}

From source file:org.linagora.linshare.core.repository.hibernate.UploadRequestRepositoryImpl.java

License:Open Source License

@Override
public List<String> findAllRequestsToBeNotified() {
    DetachedCriteria crit = DetachedCriteria.forClass(getPersistentClass());
    GregorianCalendar gc = new GregorianCalendar();
    gc.set(GregorianCalendar.HOUR_OF_DAY, 0);
    gc.set(GregorianCalendar.MINUTE, 0);
    gc.set(GregorianCalendar.SECOND, 0);
    gc.set(GregorianCalendar.MILLISECOND, 0);
    Date before = gc.getTime();/*from ww  w  .j av  a2 s.co m*/
    gc.add(GregorianCalendar.DAY_OF_MONTH, 1);
    Date after = gc.getTime();
    crit.add(Restrictions.lt("notificationDate", after));
    crit.add(Restrictions.gt("notificationDate", before));
    crit.add(Restrictions.ltProperty("notificationDate", "expiryDate"));
    crit.add(Restrictions.eq("status", UploadRequestStatus.STATUS_ENABLED));
    crit.setProjection(Projections.property("uuid"));
    @SuppressWarnings("unchecked")
    List<String> list = listByCriteria(crit);
    return list;
}