Example usage for org.hibernate.criterion Projections sum

List of usage examples for org.hibernate.criterion Projections sum

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Projections
  6. sum

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections sum.

Prototype

public static AggregateProjection sum(String propertyName)

Source Link

Document

A property value sum projection

Usage

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

License:Open Source License

@Override
public Long sumOfCurrentValue(ContainerQuota containerQuota) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.eq("containerQuota", containerQuota));
    criteria.add(Restrictions.ge("batchModificationDate", getTodayBegin()));
    criteria.setProjection(Projections.sum("currentValue"));
    List<AccountQuota> list = findByCriteria(criteria);
    if (list.size() > 0 && list.get(0) != null) {
        return DataAccessUtils.longResult(findByCriteria(criteria));
    }//from w  ww.  ja va  2 s.  c  om
    return (long) 0;
}

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

License:Open Source License

@Override
public Long sumOfCurrentValue(DomainQuota domainQuota) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    criteria.add(Restrictions.eq("domainQuota", domainQuota));
    criteria.add(Restrictions.ge("batchModificationDate", getTodayBegin()));
    criteria.setProjection(Projections.sum("currentValue"));
    List<ContainerQuota> list = findByCriteria(criteria);
    if (list.size() > 0 && list.get(0) != null) {
        return DataAccessUtils.longResult(findByCriteria(criteria));
    }//  w w  w .j a va2  s  . co m
    return 0L;
}

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));
    }/*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));
    }//ww w . j  a v a 2s  .c o  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));
    }/*w ww. ja va  2  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));
    }/*  ww w. j  a va 2 s . co 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));
    }/*from  ww  w.ja v  a2 s .c  o 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 av  a2 s .com
    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));
    }/* ww  w  .jav a  2 s. com*/
    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));
    }/*from w  w w .j  av  a  2  s  . c  om*/
    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;
}