Example usage for org.hibernate.criterion Restrictions like

Introduction

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

Prototype

public static SimpleExpression like(String propertyName, String value, MatchMode matchMode) 

Source Link

Document

Apply a "like" constraint to the named property using the provided match mode

Usage

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

private Criteria doSearchSalaryConfirmationByParam(SalaryConfirmationParameter param, Criteria criteria) {
    /**/*from  ww  w . j ava2s  .  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.createAlias("bioData", "bioData", JoinType.INNER_JOIN);
    criteria.createAlias("golonganJabatan", "golonganJabatan", JoinType.INNER_JOIN);
    criteria.add(Restrictions.isNotEmpty("payTempKalkulasis"));

    if (StringUtils.isNotEmpty(param.getNik())) {
        criteria.add(Restrictions.like("nik", param.getNik(), MatchMode.START));
    }

    if (StringUtils.isNotEmpty(param.getName())) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("bioData.firstName", param.getName(), MatchMode.START));
        disjunction.add(Restrictions.like("bioData.lastName", param.getName(), MatchMode.START));
        criteria.add(disjunction);
    }

    if (param.getGolonganJabatanId() != null && param.getGolonganJabatanId() != 0) {
        criteria.add(Restrictions.eq("golonganJabatan.id", param.getGolonganJabatanId()));
    }

    return criteria;
}

---

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

private void doSearchEmpDataByParam(String nikOrNameSearchParameter, Criteria criteria) {

    if (nikOrNameSearchParameter != null) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("nik", nikOrNameSearchParameter, MatchMode.START));
        disjunction.add(Restrictions.like("bioData.firstName", nikOrNameSearchParameter, MatchMode.START));
        disjunction.add(Restrictions.like("bioData.lastName", nikOrNameSearchParameter, MatchMode.START));
        criteria.add(disjunction);//from  ww w  .  j a va 2 s  .com
    }
}

---

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

@Override
public List<EmpData> getAllDataNotTerminatePaging(TempAttendanceRealizationSearchParameter parameter,
        int firstResult, int maxResult, Order order) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));
    if (parameter.getNik() != null) {
        criteria.add(Restrictions.like("nik", parameter.getNik(), MatchMode.ANYWHERE));
    }/*from   ww w. ja v  a  2 s.c om*/
    criteria.createAlias("bioData", "bio", JoinType.INNER_JOIN);
    if (parameter.getName() != null) {
        //            criteria.createAlias("bioData", "bio", JoinType.INNER_JOIN);
        Disjunction orCondition = Restrictions.disjunction();
        orCondition.add(
                Restrictions.ilike("bio.combineName", parameter.getName().toLowerCase(), MatchMode.ANYWHERE));
        orCondition.add(Restrictions.like("nik", parameter.getName(), MatchMode.ANYWHERE));
        criteria.add(orCondition);
    }

    //String sorting = "bio." + order;
    criteria.addOrder(order);
    //        if (order==null) {
    //            criteria.addOrder(order);
    //        } else {
    //            if (order.isAscending()) {
    //             
    //                criteria.addOrder(Order.asc(sorting));
    //            } else {
    //                
    //                criteria.addOrder(Order.desc(sorting));
    //            }
    //        }

    criteria.setFirstResult(firstResult);
    criteria.setMaxResults(maxResult);
    return criteria.list();
}

---

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

@Override
public Long getTotalNotTerminatePaging(TempAttendanceRealizationSearchParameter parameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());

    criteria.add(Restrictions.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));
    if (parameter.getNik() != null) {
        criteria.add(Restrictions.like("nik", parameter.getNik(), MatchMode.ANYWHERE));
    }/*from   w w w .j  a v a2 s  .  c  o  m*/

    if (parameter.getName() != null) {
        criteria.createAlias("bioData", "bio", JoinType.INNER_JOIN);
        Disjunction orCondition = Restrictions.disjunction();
        orCondition.add(
                Restrictions.ilike("bio.combineName", parameter.getName().toLowerCase(), MatchMode.ANYWHERE));
        orCondition.add(Restrictions.like("nik", parameter.getName(), MatchMode.ANYWHERE));
        criteria.add(orCondition);
    }
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

---

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

private void doSearchByParam(EmpDataSearchParameter dataSearchParameter, Criteria criteria) {
    criteria.add(Restrictions.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));

    criteria.createAlias("jabatanByJabatanId", "jabatanByJabatanId", JoinType.INNER_JOIN);
    criteria.createAlias("wtGroupWorking", "wtGroupWorking", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("bioData", "bioData", JoinType.INNER_JOIN);

    if (dataSearchParameter.getJabatanKode() != null) {
        criteria.add(Restrictions.like("jabatanByJabatanId.code", dataSearchParameter.getJabatanKode(),
                MatchMode.START));// w w w.  j a  va2  s .  com
    }
    if (dataSearchParameter.getJabatanName() != null) {
        criteria.add(Restrictions.like("jabatanByJabatanId.name", dataSearchParameter.getJabatanName(),
                MatchMode.ANYWHERE));
    }
    if (dataSearchParameter.getWorkingGroupName() != null) {
        criteria.add(Restrictions.like("wtGroupWorking.name", dataSearchParameter.getWorkingGroupName(),
                MatchMode.ANYWHERE));
    }
    if (dataSearchParameter.getNIK() != null) {
        criteria.add(Restrictions.like("nik", dataSearchParameter.getNIK(), MatchMode.START));
    }
    if (dataSearchParameter.getName() != null) {
        criteria.add(Restrictions.ilike("bioData.combineName", dataSearchParameter.getName().toLowerCase(),
                MatchMode.ANYWHERE));
    }
}

---

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

private void doSearchByParamOnlyEmployee(Long companyId, EmpDataSearchParameter dataSearchParameter,
        Criteria criteria) {/* w  w  w.  ja  v  a2s. c o  m*/
    criteria = this.addJoinRelationsOfCompanyId(criteria, companyId);
    criteria.add(Restrictions.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));
    if (dataSearchParameter.getJabatanKode() != null) {
        criteria.add(Restrictions.like("jabatanByJabatanId.code", dataSearchParameter.getJabatanKode(),
                MatchMode.START));
    }

    if (dataSearchParameter.getJabatanName() != null) {
        criteria.add(Restrictions.like("jabatanByJabatanId.name", dataSearchParameter.getJabatanName(),
                MatchMode.ANYWHERE));
    }

    if (dataSearchParameter.getNIK() != null) {
        criteria.add(Restrictions.like("nik", dataSearchParameter.getNIK(), MatchMode.START));
    }
    criteria.createAlias("bioData", "bioData", JoinType.INNER_JOIN);
    if (dataSearchParameter.getName() != null) {
        criteria.add(Restrictions.ilike("bioData.combineName", dataSearchParameter.getName().toLowerCase(),
                MatchMode.ANYWHERE));
    }
}

---

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

private void doSearchByParamOnlyEmployeeNotIncludeCompany(EmpDataSearchParameter dataSearchParameter,
        Criteria criteria) {/*from   ww  w .  ja va2s . co  m*/
    //        criteria = this.addJoinRelationsOfCompanyId(criteria, companyId);
    //        criteria.add(Restrictions.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));
    //        if (dataSearchParameter.getJabatanKode() != null) {
    //            criteria.add(Restrictions.like("jabatanByJabatanId.code", dataSearchParameter.getJabatanKode(), MatchMode.START));
    //        }
    //
    //        if (dataSearchParameter.getJabatanName() != null) {
    //            criteria.add(Restrictions.like("jabatanByJabatanId.name", dataSearchParameter.getJabatanName(), MatchMode.ANYWHERE));
    //        }
    criteria.createAlias("taxFree", "taxFree", JoinType.LEFT_OUTER_JOIN);
    if (dataSearchParameter.getNIK() != null) {
        criteria.add(Restrictions.like("nik", dataSearchParameter.getNIK(), MatchMode.START));
    }
    criteria.createAlias("bioData", "bioData", JoinType.INNER_JOIN);
    if (dataSearchParameter.getName() != null) {
        criteria.add(Restrictions.ilike("bioData.combineName", dataSearchParameter.getName().toLowerCase(),
                MatchMode.ANYWHERE));
    }
}

---

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

private void doSearchEmpRotasiByParam(EmpRotasiSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getNIK() != null) {
        criteria.createAlias("empData", "ep", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("ep.nik", searchParameter.getNIK(), MatchMode.START));
    }/*from w  w  w .j ava 2 s  .  c  om*/

    if (searchParameter.getName() != null) {
        criteria.createAlias("empData", "ep", JoinType.INNER_JOIN);
        criteria.createAlias("ep.bioData", "bio", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("bio.firstName", searchParameter.getName(), MatchMode.START));
    }
    if (searchParameter.getJabatanLama() != null) {
        criteria.createAlias("jabatanByOldFunctionId", "jbo", JoinType.INNER_JOIN);
        criteria.add(Restrictions.eq("jbo.name", searchParameter.getJabatanLama()));
    }

    if (searchParameter.getJabatanBaru() != null) {
        criteria.createAlias("jabatanByNewFunctionId", "jbn", JoinType.INNER_JOIN);
        criteria.add(Restrictions.eq("jbn.name", searchParameter.getJabatanBaru()));
    }

    criteria.add(Restrictions.isNotNull("id"));
}

---

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

private void doSearchFamilyRelationByParam(FamilyRelationSearchParameter parameter, Criteria criteria) {
    if (parameter.getRelasiName() != null) {
        criteria.add(Restrictions.like("relasiName", parameter.getRelasiName(), MatchMode.ANYWHERE));
    }/*from  w w  w  . j a  va 2 s .  com*/
    if (parameter.getCode() != null) {
        criteria.add(Restrictions.like("code", parameter.getCode(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

---

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

private void doSearchByParam(GolonganJabatanSearchParameter parameter, Criteria criteria) {
    criteria.createAlias("pangkat", "pangkat", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("paySalaryGrade", "paySalaryGrade", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("paySalaryGrade.currency", "currency", JoinType.LEFT_OUTER_JOIN);
    if (StringUtils.isNotEmpty(parameter.getCode())) {
        criteria.add(Restrictions.like("code", parameter.getCode(), MatchMode.ANYWHERE));
    }// w w w .j  av  a 2  s.c om
    if (StringUtils.isNotEmpty(parameter.getPangkatName())) {
        criteria.add(Restrictions.like("pangkat.pangkatName", parameter.getPangkatName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• »