Example usage for org.hibernate.criterion DetachedCriteria setProjection

List of usage examples for org.hibernate.criterion DetachedCriteria setProjection

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. setProjection

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria setProjection.

Prototype

public DetachedCriteria setProjection(Projection projection)

Source Link

Document

Set the projection to use.

Usage

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

License:Open Source License

private Long sumOfCurrentValueForAllMySubdomains(AbstractDomain domain) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.eq("parentDomain", domain));
    criteria.setProjection(Projections.sum("currentValue"));
    List<DomainQuota> list = findByCriteria(criteria);
    if (list.size() > 0 && list.get(0) != null) {
        return DataAccessUtils.longResult(findByCriteria(criteria));
    }//from w  w  w .ja v a2  s  .c o  m
    return 0L;
}

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

License:Open Source License

private Long sumOfcurrentValueForSubdomainsOfAllMySubdomains(AbstractDomain domain) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.eq("parentDomain", domain));
    criteria.setProjection(Projections.sum("currentValueForSubdomains"));
    List<DomainQuota> list = findByCriteria(criteria);
    if (list.size() > 0 && list.get(0) != null) {
        return DataAccessUtils.longResult(findByCriteria(criteria));
    }/* w ww.j av a2s  . co  m*/
    return 0L;
}

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));
    }/*from  w  ww  .  j a va2  s  .co  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 ava2  s  .  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  .  j ava  2  s.  co  m
    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));
    }/*  w  w w.  j  a v  a  2s  . c o 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));
    }/*from  w  w w. j a v  a  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 ww. ja  v  a2 s.c  o  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 w w.  jav a  2  s  . co  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.GenericStatisticRepositoryImpl.java

License:Open Source License

@Override
public List<AbstractDomain> findDomainBetweenTwoDates(Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    if (beginDate != null) {
        criteria.add(Restrictions.ge("statisticDate", beginDate));
    }/*from w w  w .java  2  s. c  o m*/
    if (endDate != null) {
        criteria.add(Restrictions.le("statisticDate", endDate));
    }
    criteria.setProjection(Projections.property("domain"));
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    @SuppressWarnings("unchecked")
    List<AbstractDomain> listDomains = (List<AbstractDomain>) getHibernateTemplate().findByCriteria(criteria);
    return listDomains;
}