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.ApprovalDefinitionDaoImpl.java

@Override
public Long getTotalSameAprrovalProsesExist(String approvalName, String procesName, int sequance) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("name", approvalName));
    criteria.add(Restrictions.eq("processType", procesName));
    criteria.add(Restrictions.eq("sequence", sequance));
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();

}

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

@Override
public Long getTotalApprovalExistWithSequenceOne(String approvalName) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("name", approvalName));
    criteria.add(Restrictions.eq("sequence", 1));
    criteria.add(Restrictions.eq("isActive", true));// query bagi approval definisi yang active saja
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalDataWithSequenceLower(String approvalName, int sequance) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.eq("processType", HRMConstant.ON_APPROVE_INFO));
    disjunction.add(Restrictions.eq("processType", HRMConstant.ON_REJECT_INFO));
    criteria.add(Restrictions.eq("name", approvalName));
    criteria.add(Restrictions.le("sequence", sequance));
    criteria.add(disjunction);//from  w w w.  j  a  v a 2  s. co  m
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalDataWithSequenceLowerAndNotId(String approvalName, int sequance, long id) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.eq("processType", HRMConstant.ON_APPROVE_INFO));
    disjunction.add(Restrictions.eq("processType", HRMConstant.ON_REJECT_INFO));
    criteria.add(Restrictions.eq("name", approvalName));
    criteria.add(Restrictions.le("sequence", sequance));
    criteria.add(Restrictions.ne("id", id));
    criteria.add(disjunction);/*from   w ww .  ja  va  2s . c o  m*/
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalSameAprrovalProsesExistAndNotId(String approvalName, String procesName, int sequance,
        long id) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("name", approvalName));
    criteria.add(Restrictions.eq("processType", procesName));
    criteria.add(Restrictions.eq("sequence", sequance));
    criteria.add(Restrictions.ne("id", id));
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public Long getTotalAttendanceStatusyParam(AttendanceStatusSearchParamater searchParameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    doSearchAttendanceStatusByParam(searchParameter, criteria);
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

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

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

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

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

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

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

@Override
public Long getTotalByParam(BatchJobExecutionSearchParameter parameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    if (parameter.getJobName() != null) {
        criteria.createAlias("batchJobInstance", "bj", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("bj.jobName", parameter.getJobName(), MatchMode.ANYWHERE));
    }/* www  .  j  a v  a 2s.co m*/
    if (parameter.getStatus() != null) {
        criteria.add(Restrictions.like("BatchJobExecution", parameter.getStatus()));
    }
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}