Example usage for org.hibernate.criterion Projections rowCount

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

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

Introduction

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

Prototype

public static Projection rowCount()

Source Link

Document

The query row count, ie.

Usage

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

@Override
public Long getTotalTempAttendanceRealizationByParam(TempAttendanceRealizationSearchParameter parameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    doSearchTempAttendanceRealizationByParam(parameter, criteria);
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalPaidOvertimeByParam(PaidOvertimeSearchParameter searchParameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    doSearchPaidOvertimeByParam(searchParameter, criteria);
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalByTanggalWaktuKerja(Date date, Long companyId) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.jabatanByJabatanId", "jabatanByJabatanId", JoinType.INNER_JOIN);
    criteria.createAlias("jabatanByJabatanId.department", "department", JoinType.INNER_JOIN);
    criteria.createAlias("department.company", "company", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("tanggalWaktuKerja", date));
    criteria.add(Restrictions.eq("company.id", companyId));
    criteria.add(Restrictions.not(Restrictions.eq("empData.status", HRMConstant.EMP_TERMINATION)));
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalByParam(UnregSalarySearchParameter searchParameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    doSearchByParam(searchParameter, criteria);
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalByParamBySalaryCalculation(UnregSalarySearchParameter searchParameter,
        Date fromPeriodPayrollType) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("wtPeriode", "wtPeriode", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("isAlreadyPaid", false));
    criteria.add(Restrictions.lt("wtPeriode.fromPeriode", fromPeriodPayrollType));
    doSearchByParam(searchParameter, criteria);
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalByParamBySalaryPayroll(UnregSalarySearchParameter searchParameter,
        Date fromPeriodPayrollType) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    criteria.createAlias("wtPeriode", "wtPeriode", JoinType.INNER_JOIN);
    criteria.add(Restrictions.lt("wtPeriode.fromPeriode", fromPeriodPayrollType));
    doSearchByParam(searchParameter, criteria);
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalWtFingerExceptionByParam(WtFingerExceptionSearchParameter searchParameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    doSearch(searchParameter, criteria);
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalWtGroupWorkingByParam(WtGroupWorkingSearchParameter searchParameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    doSearchWtGroupWorkingByParam(searchParameter, criteria);
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalByCode(String code) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("code", code));
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalWtHolidayByParam(HolidaySearchParameter searchParameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    doSearchWtHolidayByParam(searchParameter, criteria);
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}