Example usage for org.hibernate.criterion Restrictions le

Introduction

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

Prototype

public static SimpleExpression le(String propertyName, Object value)

Source Link

Document

Apply a "less than or equal" constraint to the named property

Usage

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

private Criteria doSearchReportEmpWorkingGroupByParam(ReportEmpWorkingGroupParameter param, Criteria criteria) {
    /**/*from www. j a va2s .com*/
     * 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.EmpDataDaoImpl.java

@Override
public List<String> getAllNikBetween(String from, String until) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /**//from  w  w  w .  ja v  a  2s  .  com
     * 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.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));

    criteria.add(Restrictions.ge("nik", from));
    criteria.add(Restrictions.le("nik", until));
    criteria.setProjection(Projections.property("nik"));
    return criteria.list();
}

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

@Override
public List<EmpData> getAllDataNotTerminateAndJoinDateLowerThan(Long companyId, Date date) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /**/*ww  w .  jav a  2s .  c  om*/
     * 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, companyId);
    criteria.add(Restrictions.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));

    criteria.add(Restrictions.le("joinDate", date));

    return criteria.list();
}

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

@Override
public List<EmpData> getAllDataNotTerminateAndJoinDateLowerThan(Date date) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));
    criteria.add(Restrictions.le("joinDate", date));

    return criteria.list();
}

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

@Override
public Long getTotalKaryawanByJabatanIdWithJoinDateBeforeOrEqualDate(Long jabatanId, Date joinDateLimit) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /**/*from   w w  w.j  a  va 2s. c  om*/
     * 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.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));
    criteria.add(Restrictions.le("joinDate", joinDateLimit));

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

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

@Override
public List<HrmUser> getListUserWithExpiredPasswordButStatusStillNotUpdateToExpired(
        Integer numberOfMonthToExpired) {
    Date limitLastUpdate = DateTimeUtil.getDateFrom(new Date(), -numberOfMonthToExpired,
            CommonUtilConstant.DATE_FORMAT_MONTH);
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.le("updatedOn", limitLastUpdate));
    criteria.add(Restrictions.eq("isExpired", HRMConstant.NOTEXPIRED));
    return criteria.list();
}

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

@Override
public List<HrmUser> getListUserWithPasswordAlmostExpired(Integer numberOfMonthToExpired,
        Integer notificationPeriod) {
    Date lastUpdateExpiredLimit = DateTimeUtil.getDateFrom(new Date(), -numberOfMonthToExpired,
            CommonUtilConstant.DATE_FORMAT_MONTH);
    Date expiredPeriodWarningLimit = DateTimeUtil.getDateFrom(lastUpdateExpiredLimit, notificationPeriod,
            CommonUtilConstant.DATE_FORMAT_MONTH);

    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.le("updatedOn", expiredPeriodWarningLimit));
    criteria.add(Restrictions.ge("updatedOn",
            DateTimeUtil.getDateFrom(lastUpdateExpiredLimit, 1, CommonUtilConstant.DATE_FORMAT_DAY)));
    criteria.add(Restrictions.eq("isExpired", HRMConstant.NOTEXPIRED));
    return criteria.list();
}

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

@Override
public List<LoanNewApplicationInstallment> getAllDataDisbursedByEmpDataIdAndLoanTypeIdAndPeriodDate(
        Long empDataId, Long loanTypeId, Date startPeriodDate, Date endPeriodDate) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("loanNewApplication", "loanNewApplication", JoinType.INNER_JOIN);
    criteria.createAlias("loanNewApplication.empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("loanNewApplication.loanNewType", "loanNewType", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("loanNewType.id", loanTypeId));
    criteria.add(Restrictions.eq("empData.id", empDataId));
    criteria.add(Restrictions.le("installmentDate", endPeriodDate));
    criteria.add(Restrictions.ge("installmentDate", startPeriodDate));
    criteria.add(Restrictions.ge("loanNewApplication.loanStatus", HRMConstant.LOAN_DISBURSED));
    return criteria.list();
}

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

@Override
public List<PaySalaryComponent> getAllDataByEmpTypeIdAndActiveFromTmAndIdNotIn(Long empTypeId, int fromTbm,
        List<Long> componentIds) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("paySalaryEmpTypes", "payType");
    criteria.createAlias("payType.employeeType", "employeeType");
    criteria.add(Restrictions.eq("employeeType.id", empTypeId));
    criteria.add(Restrictions.le("activeFromTmb", fromTbm));
    if (!componentIds.isEmpty()) {
        criteria.add(Restrictions.not(Restrictions.in("id", componentIds)));
    }// w  ww .  j a v a 2  s. co m
    return criteria.list();
}

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

@Override
public List<TempJadwalKaryawan> getAllByMaxEndDate(Date date) {
    ProjectionList proList = Projections.projectionList();
    proList.add(Property.forName("tanggalWaktuKerja").max());
    proList.add(Projections.groupProperty("empData"));
    DetachedCriteria data = DetachedCriteria.forClass(getEntityClass()).setProjection(proList);
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    String[] var = { "tanggalWaktuKerja", "empData" };
    criteria.add(Subqueries.propertiesIn(var, data));
    criteria.add(Restrictions.le("tanggalWaktuKerja", date));
    return criteria.list();

}