Example usage for org.hibernate.criterion Projections 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.LoginHistoryDaoImpl.java

@Override
public Long getTotalLoginHistoryByParam(LoginHistorySearchParameter searchParameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("hrmUser", "hrmUser", JoinType.LEFT_OUTER_JOIN);
    doSearchLoginHistByParam(searchParameter, criteria);
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalDataByParam(LogWtAttendanceRealizationModel model) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    //        criteria.add(Restrictions.ge("periodeDateStart", model.getStartPeriod()));
    //        criteria.add(Restrictions.lt("periodeDateEnd", model.getEndPeriod()));
    //        criteria.add(Restrictions.eq("wtPeriodeId", model.getWtPeriodeId()));

    if (model.getWtPeriodeId() != null) {
        criteria.add(Restrictions.eq("wtPeriodeId", model.getWtPeriodeId()));
    }/*from  w  w w  .  j a v a  2  s  .c o  m*/

    if (model.getListDeptName() != null && model.getListDeptName().size() > 0) {
        criteria.add(Restrictions.in("empDepartementName", model.getListDeptName()));
    }
    if (model.getListDeptName() != null && model.getListGolJabName().size() > 0) {
        criteria.add(Restrictions.in("empGolJab", model.getListGolJabName()));
    }
    //        if (model.getListGolJabName() != null) {
    //            criteria.add(Restrictions.in("empGolJab", model.getListGolJabName()));
    //        }
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalByParam(MecineFingerSearchParameter parameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    doSearchMecineFingerByParam(parameter, criteria);
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();

}

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

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

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

@Override
public Long getTotalEmpInvolveByIdOhsaIncident(Long idOhsaIncident) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.setFetchMode("ohsaIncident", FetchMode.JOIN);
    criteria.add(Restrictions.eq("ohsaIncident.id", idOhsaIncident));

    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

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

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

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

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

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

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

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

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

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