Example usage for org.hibernate.criterion Restrictions ne

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions ne.

Prototype

public static SimpleExpression ne(String propertyName, Object value)

Source Link

Document

Apply a "not equal" constraint to the named property

Usage

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. j  av  a2 s  .  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 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.BioDataDaoImpl.java

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

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

@Override
public Long getTotalByNikandNotId(String nik, Long id) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /**//from  ww w  . ja va2 s.  c o  m
     * automatically get relations of jabatanByJabatanId, department,
     * company don't create alias for that entity, or will get error :
     * duplicate association path
     */
    criteria = this.addJoinRelationsOfCompanyId(criteria, HrmUserInfoUtil.getCompanyId());

    criteria.add(Restrictions.eq("nik", nik));
    criteria.add(Restrictions.ne("id", id));
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

private Criteria doSearchReportEmpWorkingGroupByParam(ReportEmpWorkingGroupParameter param, Criteria criteria) {
    /**/* www. j av  a 2 s . c  o m*/
     * automatically get relations of jabatanByJabatanId, department,
     * company don't create alias for that entity, or will get error :
     * duplicate association path
     */
    criteria = this.addJoinRelationsOfCompanyId(criteria, HrmUserInfoUtil.getCompanyId());
    if (param.getDepartmentId() != null && param.getDepartmentId() != 0) {
        criteria.add(Restrictions.eq("jabatanByJabatanId.department.id", param.getDepartmentId()));
    }

    if (StringUtils.isNotEmpty(param.getNikStart())) {
        criteria.add(Restrictions.ge("nik", param.getNikStart()));
    }

    if (StringUtils.isNotEmpty(param.getNikEnd())) {
        criteria.add(Restrictions.le("nik", param.getNikEnd()));
    }

    criteria.add(Restrictions.ne("status", HRMConstant.EMP_TERMINATION));
    return criteria;
}

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

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

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

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

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

@Override
public List<LoanNewApplication> getListUnpaidLoanByEmpDataIdAndLoanNewTypeId(Long empDataId,
        Long loanNewTypeId) {/* w  w  w .  j  a  v  a 2s  .c  o m*/
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());

    criteria.setFetchMode("empData", FetchMode.JOIN);
    criteria.setFetchMode("loanNewType", FetchMode.JOIN);
    criteria.add(Restrictions.eq("empData.id", empDataId));
    criteria.add(Restrictions.eq("loanNewType.id", loanNewTypeId));
    criteria.add(Restrictions.ne("loanStatus", HRMConstant.LOAN_PAID));
    return criteria.list();
}

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

@Override
public List<LoanNewApplication> getListUnpaidLoanByEmpDataId(Long empDataId) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());

    criteria.setFetchMode("empData", FetchMode.JOIN);
    criteria.setFetchMode("loanNewType", FetchMode.JOIN);
    criteria.add(Restrictions.eq("empData.id", empDataId));
    criteria.add(Restrictions.ne("loanStatus", HRMConstant.LOAN_PAID));
    criteria.add(Restrictions.ne("loanStatus", HRMConstant.LOAN_CANCELED));
    criteria.add(Restrictions.ne("loanStatus", HRMConstant.LOAN_REJECTED));
    criteria.add(Restrictions.ne("loanStatus", HRMConstant.LOAN_UNDISBURSED));
    return criteria.list();
}