Example usage for org.hibernate.criterion Restrictions ge

List of usage examples for org.hibernate.criterion Restrictions ge

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. ge

Introduction

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

Prototype

public static SimpleExpression ge(String propertyName, Object value)

Source Link

Document

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

Usage

From source file:com.indicator_engine.dao.GLAUserDaoImpl.java

License:Open Source License

@Override
@Transactional(readOnly = true)//from  www  .  j a  va 2s  .  c  om
public List<GLAUser> loadUsersRange(long startRange, long endRange) {
    Session session = factory.getCurrentSession();
    Criteria criteria = session.createCriteria(GLAUser.class);
    criteria.setFetchMode("events", FetchMode.JOIN);
    criteria.add(Restrictions.ge("id", startRange));
    criteria.add(Restrictions.le("id", endRange));
    return criteria.list();

}

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

private void doSearchEmpRotasiByParamReport(ReportEmpMutationParameter searchParameter, Criteria criteria) {
    if (searchParameter.getStartDate() != null && searchParameter.getEndDate() != null) {
        Conjunction conjunction = Restrictions.conjunction();
        conjunction.add(Restrictions.ge("tglPenganngkatan", searchParameter.getStartDate()));
        conjunction.add(Restrictions.le("tglPenganngkatan", searchParameter.getEndDate()));
        criteria.add(conjunction);//  ww w . j a  v a2  s .  com
    }
}

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

private Criteria doSearchReportEmpWorkingGroupByParam(ReportEmpWorkingGroupParameter param, Criteria criteria) {
    /**/* w ww.  j  a  va  2s.  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.EmpDataDaoImpl.java

@Override
public List<String> getAllNikBetween(String from, String until) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /**/*w ww.  j a  va 2  s .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.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.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.InclusionReimbursmentDaoImpl.java

private void doSearchByParam(String parameter, Criteria criteria,
        InclusionReimbursmentModel inclusionReimbursmentModel) {
    criteria.createAlias("reimbursmentSchema", "reimbursmentSchema", JoinType.INNER_JOIN);
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("reimbursmentSchema.payrollComponent", Boolean.TRUE));
    criteria.add(Restrictions.ge("claimDate", inclusionReimbursmentModel.getStartDate()));
    criteria.add(Restrictions.lt("claimDate", inclusionReimbursmentModel.getEndDate()));
    if (StringUtils.isNotEmpty(parameter)) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", parameter, MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.firstName", parameter, MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.lastName", parameter, MatchMode.ANYWHERE));
        criteria.add(disjunction);//from  w  ww.  j  av  a 2  s  .c o  m
        //            criteria.add(Restrictions.like("bioData.firstName", parameter, MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

@Override
public List<Reimbursment> getByWtPeriodeWhereComponentPayrollIsActive(
        InclusionReimbursmentModel inclusionReimbursmentModel) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("reimbursmentSchema", "reimbursmentSchema", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("reimbursmentSchema.payrollComponent", Boolean.TRUE));
    criteria.add(Restrictions.ge("claimDate", inclusionReimbursmentModel.getStartDate()));
    criteria.add(Restrictions.lt("claimDate", inclusionReimbursmentModel.getEndDate()));
    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 PaySalaryComponent getByEmployeeTypeIdAndComponentIdAndJoinDate(Long typeId, Long componentId,
        Date joinDate) {/*from  w  ww .  ja va2 s. c o m*/
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("paySalaryEmpTypes", "payType");
    criteria.createAlias("payType.employeeType", "employeeType");
    criteria.add(Restrictions.eq("id", componentId));
    criteria.add(Restrictions.eq("employeeType.id", typeId));
    int timeTmb = 0;
    try {
        timeTmb = DateTimeUtil.getTotalDay(joinDate, new Date());
    } catch (Exception ex) {
        LOGGER.error(ex);
    }
    criteria.add(Restrictions.ge("activeFromTmb", timeTmb));
    return (PaySalaryComponent) criteria.uniqueResult();
}

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

@Override
public List<TempJadwalKaryawan> getAllDataByEmpIdAndPeriodDate(Long empDataId, Date startDate, Date endDate) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("empData.id", empDataId));
    criteria.add(Restrictions.ge("tanggalWaktuKerja", startDate));
    criteria.add(Restrictions.le("tanggalWaktuKerja", endDate));
    return criteria.list();
}