Example usage for org.hibernate.criterion Projections 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:com.hmsinc.epicenter.model.geography.impl.GeographyRepositoryImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public Long inferPopulation(Geography geography) {

    Validate.notNull(geography);/*from w  ww  .  j a v  a 2  s  .  co  m*/

    final Long ret;
    if (geography.getPopulation() == null) {

        final Class<? extends Geography> geoClass = (Class<? extends Geography>) ModelUtils
                .getRealClass(geography);
        if (Zipcode.class.isAssignableFrom(geoClass)) {
            ret = 0L;
        } else {
            ret = (Long) criteriaQuery(entityManager, Zipcode.class)
                    .add(SpatialRestrictions.withinOrFilter(getGeometryColumnName(geoClass),
                            geography.getGeometry(), 500, false))
                    .setProjection(Projections.sum("population")).uniqueResult();
        }
    } else {
        ret = geography.getPopulation();
    }

    return ret;
}

From source file:com.inkubator.hrm.dao.impl.TempAttendanceRealizationDaoImpl.java

@Override
public Long getTotalEmpLeav() {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    Long result = (Long) criteria.setProjection(Projections.sum("leave")).uniqueResult();
    return result == null ? 0l : result;
}

From source file:com.inkubator.hrm.dao.impl.TempAttendanceRealizationDaoImpl.java

@Override
public Long getTotalEmpPermit() {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    Long result = (Long) criteria.setProjection(Projections.sum("permit")).uniqueResult();
    return result == null ? 0l : result;
}

From source file:com.inkubator.hrm.dao.impl.TempAttendanceRealizationDaoImpl.java

@Override
public Long gettotalEmpOnDuty() {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    Long result = (Long) criteria.setProjection(Projections.sum("duty")).uniqueResult();
    return result == null ? 0l : result;
}

From source file:com.inkubator.hrm.dao.impl.TempAttendanceRealizationDaoImpl.java

@Override
public Long gettotalEmpOnSick() {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    Long result = (Long) criteria.setProjection(Projections.sum("sick")).uniqueResult();
    return result == null ? 0l : result;
}

From source file:com.inkubator.hrm.dao.impl.TempAttendanceRealizationDaoImpl.java

@Override
public Long getTotalEmpLeav(long empId) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("ce.id", empId));
    Long result = (Long) criteria.setProjection(Projections.sum("leave")).uniqueResult();
    return result == null ? 0l : result;
}

From source file:com.inkubator.hrm.dao.impl.TempAttendanceRealizationDaoImpl.java

@Override
public Long getTotalEmpPermit(long empId) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("ce.id", empId));
    Long result = (Long) criteria.setProjection(Projections.sum("permit")).uniqueResult();
    return result == null ? 0l : result;
}

From source file:com.inkubator.hrm.dao.impl.TempAttendanceRealizationDaoImpl.java

@Override
public Long gettotalEmpOnDuty(long empId) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("ce.id", empId));
    Long result = (Long) criteria.setProjection(Projections.sum("duty")).uniqueResult();
    return result == null ? 0l : result;
}

From source file:com.inkubator.hrm.dao.impl.TempAttendanceRealizationDaoImpl.java

@Override
public Long gettotalEmpOnSick(long empId) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("ce.id", empId));
    Long result = (Long) criteria.setProjection(Projections.sum("sick")).uniqueResult();
    return result == null ? 0l : result;
}

From source file:com.inkubator.hrm.dao.impl.TempAttendanceRealizationDaoImpl.java

@Override
public Long totalDayPresent() {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    Long result = (Long) criteria.setProjection(Projections.sum("attendanceDaysPresent")).uniqueResult();
    return result == null ? 0l : result;
}