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.JabatanDaoImpl.java

@Override
public List<Jabatan> getAllDataByCodeOrName(String param) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /** automatically get relations of department, company 
       *  don't create alias for that entity, or will get error : duplicate association path */
    criteria = this.addJoinRelationsOfCompanyId(criteria, HrmUserInfoUtil.getCompanyId());

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("code", param, MatchMode.ANYWHERE));
    disjunction.add(Restrictions.like("name", param, MatchMode.ANYWHERE));
    criteria.add(disjunction);/*from  w  ww.j a v  a2 s  .  co m*/
    return criteria.list();
}

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

private void doSearchByParam(JabatanDeskripsiSearcParameter parameter, Criteria criteria) {

    criteria.createAlias("jabatan", "jb");
    criteria.createAlias("jb.jabatan", "jbb");
    if (StringUtils.isNotEmpty(parameter.getJobsName())) {
        criteria.add(Restrictions.like("jb.name", parameter.getJobsName(), MatchMode.ANYWHERE));
    }//from  w ww .  java 2  s  . com
    if (StringUtils.isNotEmpty(parameter.getParentJobsName())) {
        criteria.add(Restrictions.like("jbb.name", parameter.getParentJobsName(), MatchMode.ANYWHERE));
    }

}

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

private void doSearchByParam(KlasifikasiKerjaLevelSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }//w w w  .  ja v  a  2 s .  c  om
    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.LoanCanceledDaoImpl.java

private void doSearchByParam(LoanCanceledSearchParameter searchParameter, Criteria criteria) {

    if (StringUtils.isNotEmpty(searchParameter.getLoanSchema())) {
        criteria.createAlias("loanSchema", "loanSchema", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("loanSchema.name", searchParameter.getLoanSchema(), MatchMode.ANYWHERE));
    }//from   w ww.j  ava 2s.com
    if (StringUtils.isNotEmpty(searchParameter.getEmployee())) {
        criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
        criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);

        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", searchParameter.getEmployee(), MatchMode.ANYWHERE));
        disjunction
                .add(Restrictions.like("bioData.firstName", searchParameter.getEmployee(), MatchMode.ANYWHERE));
        disjunction
                .add(Restrictions.like("bioData.lastName", searchParameter.getEmployee(), MatchMode.ANYWHERE));
        criteria.add(disjunction);
    }

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

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

private void doSearchByParam(LoanNewSearchParameter parameter, Criteria criteria) {

    if (StringUtils.isNotEmpty(parameter.getLoanType())) {
        criteria.createAlias("loanNewType", "loanNewType", JoinType.INNER_JOIN);
        criteria.add(//from ww  w .ja v a 2 s . c  om
                Restrictions.like("loanNewType.loanTypeName", parameter.getLoanType(), MatchMode.ANYWHERE));
    }
    if (StringUtils.isNotEmpty(parameter.getEmployee())) {
        criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
        criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);

        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", parameter.getEmployee(), MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.firstName", parameter.getEmployee(), MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.lastName", parameter.getEmployee(), MatchMode.ANYWHERE));
        criteria.add(disjunction);
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

public void doSearchByParam(LoanNewSchemaSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("loanSchemaName", searchParameter.getName(), MatchMode.ANYWHERE));
    }/*  ww  w.  j a  v a2 s.c o m*/
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("loanSchemaCode", searchParameter.getCode(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchLoanTypeByParam(LoanNewTypeSearchParameter parameter, Criteria criteria) {
    if (parameter.getLoanTypeCode() != null) {
        criteria.add(Restrictions.like("loanTypeCode", parameter.getLoanTypeCode(), MatchMode.ANYWHERE));
    }/*from   ww  w.  ja  v  a2s .co  m*/

    if (parameter.getLoanTypeName() != null) {
        criteria.add(Restrictions.like("loanTypeName", parameter.getLoanTypeName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchLoanTypeByParam(LoanTypeSearchParameter parameter, Criteria criteria) {
    if (parameter.getLoanTypeCode() != null) {
        criteria.add(Restrictions.like("loanTypeCode", parameter.getLoanTypeCode(), MatchMode.ANYWHERE));
    }/*from w  w  w  .  ja va2  s.com*/

    if (parameter.getLoanTypeName() != null) {
        criteria.add(Restrictions.like("loanTypeName", parameter.getLoanTypeName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchLoginHistByParam(LoginHistorySearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getUserId() != null) {
        criteria.add(Restrictions.like("hrmUser.userId", searchParameter.getUserId(), MatchMode.START));
    }//from  w w w .j a  va  2s . c  om
    if (searchParameter.getIpAddress() != null) {
        criteria.add(Restrictions.like("ipAddress", searchParameter.getIpAddress(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchMecineFingerByParam(MecineFingerSearchParameter parameter, Criteria criteria) {

    if (parameter.getCode() != null) {
        criteria.add(Restrictions.like("code", parameter.getCode(), MatchMode.ANYWHERE));
    }/*from w w  w .  ja  va2s .  c o  m*/
    if (parameter.getName() != null) {
        criteria.add(Restrictions.like("name", parameter.getName(), MatchMode.ANYWHERE));
    }

    if (parameter.getMethodType() != null) {
        criteria.add(Restrictions.eq("mecineMethode", Integer.parseInt(parameter.getMethodType())));
    }
    criteria.add(Restrictions.isNotNull("id"));
}