Example usage for org.hibernate.criterion Restrictions like

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

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. 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.OhsaCategoryDaoImpl.java

public void doSearchByParam(OhsaCategorySearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }//from  ww  w. j  a  v a 2s  . c  o m
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(OhsaIncidentSearchParameter parameter, Criteria criteria) {

    criteria.createAlias("ohsaCategory", "ohsaCategory", JoinType.INNER_JOIN);
    if (StringUtils.isNotEmpty(parameter.getKategori())) {
        criteria.add(Restrictions.like("ohsaCategory.name", parameter.getKategori(), MatchMode.ANYWHERE));
    }/*from  w  ww . jav a 2s .c  om*/
    if (StringUtils.isNotEmpty(parameter.getSubjek())) {
        criteria.add(Restrictions.like("subject", parameter.getSubjek(), MatchMode.ANYWHERE));
    }
    if (StringUtils.isNotEmpty(parameter.getLokasi())) {
        criteria.add(Restrictions.like("location", parameter.getLokasi(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(OrgTypeOfSpecListSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }/*www  .ja  v a2s. co  m*/
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearch(OverTimeDistributionSearchParameter searchParameter, Criteria criteria) {
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.createAlias("wtOverTime", "wtOverTime", JoinType.INNER_JOIN);
    if (searchParameter.getEmpData() != null) {

        //            Disjunction disjunction = Restrictions.disjunction();
        //            disjunction.add(Restrictions.like("bioData.firstName", searchParameter.getEmpData(), MatchMode.START));
        //            disjunction.add(Restrictions.like("bioData.lastName", searchParameter.getEmpData(), MatchMode.START));
        //            criteria.add(disjunction);
        criteria.add(Restrictions.ilike("bioData.combineName", searchParameter.getEmpData().toLowerCase(),
                MatchMode.ANYWHERE));/*  w  ww.  j  a  v  a 2s .co  m*/
    }
    if (searchParameter.getNik() != null) {
        criteria.add(Restrictions.like("empData.nik", searchParameter.getNik(), MatchMode.START));
    }
    if (StringUtils.isNotEmpty(searchParameter.getWtOverTime())) {

        criteria.add(Restrictions.like("wtOverTime.name", searchParameter.getWtOverTime(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchPasswordHistByParam(PasswordHistorySearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getUsername() != null) {
        criteria.add(Restrictions.like("userName", searchParameter.getUsername(), MatchMode.START));
    }/*ww  w.j a va 2  s. c  o m*/
    if (searchParameter.getRealname() != null) {
        criteria.add(Restrictions.like("realName", searchParameter.getRealname(), MatchMode.START));
    }
    if (searchParameter.getEmailAddress() != null) {
        criteria.add(Restrictions.like("emailAddress", searchParameter.getEmailAddress(), MatchMode.START));
    }
    if (searchParameter.getPhoneNumber() != null) {
        criteria.add(Restrictions.like("phoneNumber", searchParameter.getPhoneNumber(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(PayComponentDataExceptionSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getPaySalaryComponent() != null) {
        criteria.createAlias("paySalaryComponent", "paySalaryComponent", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("paySalaryComponent.name", searchParameter.getPaySalaryComponent(),
                MatchMode.START));/*from w  w  w .j a  v a2  s  .c om*/
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParamForDetail(String searchParameter, Criteria criteria) {
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.createAlias("paySalaryComponent", "paySalaryComponent", JoinType.INNER_JOIN);
    if (StringUtils.isNotEmpty(searchParameter)) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", searchParameter, MatchMode.START));
        disjunction.add(Restrictions.like("bioData.firstName", searchParameter, MatchMode.START));
        disjunction.add(Restrictions.like("bioData.lastName", searchParameter, MatchMode.START));
        criteria.add(disjunction);/* ww  w. j  a  v  a  2 s  .c o  m*/
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(PaySalaryComponentSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.ANYWHERE));
    }/*from  www. ja  va 2s .  c  o  m*/
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchComponentUploadByParam(PaySalaryComponentSearchParameter searchParameter,
        Criteria criteria) {//from  w w w .j  a  va2 s.c o  m
    if (StringUtils.isNotEmpty(searchParameter.getName())) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.ANYWHERE));
    }
    if (StringUtils.isNotEmpty(searchParameter.getCode())) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
    criteria.createAlias("modelComponent", "modelComponent");
    criteria.add(Restrictions.eq("modelComponent.spesific", HRMConstant.MODEL_COMP_UPLOAD));
}

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

private void doSearchByParam(PayTempKalkulasiSearchParameter parameter, Criteria criteria) {
    criteria.createAlias("paySalaryComponent", "paySalaryComponent", JoinType.INNER_JOIN);
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    if (StringUtils.isNotEmpty(parameter.getEmpData())) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("bioData.firstName", parameter.getEmpData(), MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.lastName", parameter.getEmpData(), MatchMode.ANYWHERE));
        criteria.add(disjunction);//www .j  a  v a  2  s.c  o  m
    }
    if (StringUtils.isNotEmpty(parameter.getPaySalaryComponent())) {
        criteria.add(
                Restrictions.like("bioData.firstName", parameter.getPaySalaryComponent(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}