Example usage for org.hibernate.criterion Restrictions between

Introduction

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

Prototype

public static Criterion between(String propertyName, Object low, Object high)

Source Link

Document

Apply a "between" constraint to the named property

Usage

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

License:Open Source License

@Override
public Long sumOfOperationCount(AbstractDomain domain, Account account, Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.between("statisticDate", beginDate, endDate));
    if (account != null) {
        criteria.add(Restrictions.eq("account", account));
    }//ww w . j  a v a 2 s  . c o  m
    if (domain != null) {
        criteria.add(Restrictions.eq("domain", domain));
    }
    criteria.setProjection(Projections.sum("operationCount"));
    List<T> list = findByCriteria(criteria);
    if (list.size() > 0 && list.get(0) != null)
        return DataAccessUtils.longResult(findByCriteria(criteria));
    return (long) 0;
}

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

License:Open Source License

@Override
public Long sumOfDeleteOperationCount(AbstractDomain domain, Account account, Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.between("statisticDate", beginDate, endDate));
    if (account != null) {
        criteria.add(Restrictions.eq("account", account));
    }//  w w  w . j ava  2s  .c  o m
    if (domain != null) {
        criteria.add(Restrictions.eq("domain", domain));
    }
    criteria.setProjection(Projections.sum("deleteOperationCount"));
    List<T> list = findByCriteria(criteria);
    if (list.size() > 0 && list.get(0) != null)
        return DataAccessUtils.longResult(findByCriteria(criteria));
    return (long) 0;
}

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

License:Open Source License

@Override
public Long sumOfCreateOperationCount(AbstractDomain domain, Account account, Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.between("statisticDate", beginDate, endDate));
    if (account != null) {
        criteria.add(Restrictions.eq("account", account));
    }// w  w w .ja  v  a2s. com
    if (domain != null) {
        criteria.add(Restrictions.eq("domain", domain));
    }
    criteria.setProjection(Projections.sum("createOperationCount"));
    List<T> list = findByCriteria(criteria);
    if (list.size() > 0 && list.get(0) != null)
        return DataAccessUtils.longResult(findByCriteria(criteria));
    return (long) 0;
}

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

License:Open Source License

@Override
public Long sumOfCreateOperationSum(AbstractDomain domain, Account account, Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.between("statisticDate", beginDate, endDate));
    if (account != null) {
        criteria.add(Restrictions.eq("account", account));
    }//from  ww w. j  av a  2s  . co  m
    if (domain != null) {
        criteria.add(Restrictions.eq("domain", domain));
    }
    criteria.setProjection(Projections.sum("createOperationSum"));
    List<T> list = findByCriteria(criteria);
    if (list.size() > 0 && list.get(0) != null)
        return DataAccessUtils.longResult(findByCriteria(criteria));
    return (long) 0;
}

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

License:Open Source License

@Override
public Long sumOfDeleteOperationSum(AbstractDomain domain, Account account, Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.between("statisticDate", beginDate, endDate));
    if (account != null) {
        criteria.add(Restrictions.eq("account", account));
    }/* w  ww  .  java  2  s  . c  o m*/
    if (domain != null) {
        criteria.add(Restrictions.eq("domain", domain));
    }
    criteria.setProjection(Projections.sum("deleteOperationSum"));
    List<T> list = findByCriteria(criteria);
    if (list.size() > 0 && list.get(0) != null)
        return DataAccessUtils.longResult(findByCriteria(criteria));
    return (long) 0;
}

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

License:Open Source License

@Override
public Long sumOfDiffOperationSum(AbstractDomain domain, Account account, Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.between("statisticDate", beginDate, endDate));
    if (account != null) {
        criteria.add(Restrictions.eq("account", account));
    }// w  w w. ja  v  a 2s.  co  m
    if (domain != null) {
        criteria.add(Restrictions.eq("domain", domain));
    }
    criteria.setProjection(Projections.sum("diffOperationSum"));
    List<T> list = findByCriteria(criteria);
    if (list.size() > 0 && list.get(0) != null)
        return DataAccessUtils.longResult(findByCriteria(criteria));
    return (long) 0;
}

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

License:Open Source License

@Override
public Long sumOfActualOperationSum(AbstractDomain domain, Account account, Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.between("statisticDate", beginDate, endDate));
    if (account != null) {
        criteria.add(Restrictions.eq("account", account));
    }//from  w ww.jav  a2s  .  c  o m
    if (domain != null) {
        criteria.add(Restrictions.eq("domain", domain));
    }
    criteria.setProjection(Projections.sum("actualOperationSum"));
    List<T> list = findByCriteria(criteria);
    if (list.size() > 0 && list.get(0) != null)
        return DataAccessUtils.longResult(findByCriteria(criteria));
    return (long) 0;
}

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

License:Open Source License

@Override
public List<UploadRequest> findByDomainsAndStatus(List<AbstractDomain> domains,
        List<UploadRequestStatus> status, Date after, Date before) {
    Junction add = Restrictions.conjunction().add(Restrictions.in("abstractDomain", domains))
            .add(Restrictions.between("creationDate", after, before));
    if (!status.isEmpty()) {
        add.add(Restrictions.in("status", status));
    }//  w w  w  . jav  a  2s. c  o m
    return findByCriteria(add);
}

From source file:org.motechproject.server.model.db.hibernate.HibernateMotechDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<ScheduledMessage> getScheduledMessages(Date startDate, Date endDate) {
    Session session = sessionFactory.getCurrentSession();
    return (List<ScheduledMessage>) session.createCriteria(ScheduledMessage.class)
            .add(Restrictions.between("scheduledFor", startDate, endDate)).list();
}

From source file:org.motechproject.server.model.db.hibernate.HibernateMotechDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Message> getMessages(Date startDate, Date endDate, MessageStatus status) {
    Session session = sessionFactory.getCurrentSession();
    return (List<Message>) session.createCriteria(Message.class)
            .add(Restrictions.between("attemptDate", startDate, endDate))
            .add(Restrictions.eq("attemptStatus", status)).list();
}