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

public void doSearchByParam(String searchParameter, Criteria criteria, Long paySalaryComponentId) {
    criteria.createAlias("paySalaryComponent", "paySalaryComponent", JoinType.INNER_JOIN);
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("paySalaryComponent.id", paySalaryComponentId));
    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);/*from   ww w.j a v 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.PayTempKalkulasiEmpPajakDaoImpl.java

public void doSearchByParam(String searchParameter, Criteria criteria, Long taxComponentId) {
    criteria.createAlias("taxComponent", "taxComponent", JoinType.INNER_JOIN);
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("taxComponent.id", taxComponentId));
    if (StringUtils.isNotEmpty(searchParameter)) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", searchParameter, MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.firstName", searchParameter, MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.lastName", searchParameter, MatchMode.ANYWHERE));
        criteria.add(disjunction);/*from   ww w .java  2  s  .co m*/
        //            criteria.add(Restrictions.like("bioData.firstName", parameter, MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(PayTempOvertimeSearchParameter searchParameter, Criteria criteria) {
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    if (searchParameter.getEmployeeName() != null) {
        //            criteria.add(Restrictions.like("bioData.firstName", searchParameter.getEmployeeName(), MatchMode.ANYWHERE));
        criteria.add(Restrictions.ilike("bioData.combineName", searchParameter.getEmployeeName().toLowerCase(),
                MatchMode.ANYWHERE));/*from  w  w  w  .ja v a  2  s .  c  o  m*/
    }
    if (searchParameter.getNim() != null) {
        criteria.add(Restrictions.like("empData.nik", searchParameter.getNim(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

public void doSearchProscessToApproveByParam(ProscessToApproveSearchParameter approveSearchParameter,
        Criteria criteria) {/*from   ww w  .  j  a  v a 2 s .  c  o  m*/
    if (approveSearchParameter.getProcessApproval() != null) {
        criteria.add(
                Restrictions.like("code", approveSearchParameter.getProcessApproval(), MatchMode.ANYWHERE));
    }
}

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

private void doSearchByParam(RecruitAdvertisementCategorySearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }//from  w  w  w .  j  a  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.RecruitAdvertisementMediaDaoImpl.java

private void doSearchByParam(RecruitAdvertisementMediaSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }//from ww w. j av a  2 s. com
    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.RecruitLettersDaoImpl.java

private void doSearchRecruitLettersByParam(RecrutimentLetterSearchParameter parameter, Criteria criteria) {
    if (StringUtils.isNotEmpty(parameter.getSelectionType())) {
        criteria.createAlias("recruitLetterSelections", "rs", JoinType.INNER_JOIN);
        criteria.createAlias("rs.recruitSelectionType", "se", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("se.name", parameter.getSelectionType(), MatchMode.ANYWHERE));

    }//from ww w  .j  a v a 2  s  .  c  o  m
    if (StringUtils.isNotEmpty(parameter.getLetterType())) {
        criteria.add(Restrictions.eq("leterTypeId", Integer.parseInt(parameter.getLetterType())));
    }
    if (StringUtils.isNotEmpty(parameter.getSenderBy())) {
        criteria.createAlias("recruitLetterComChannels", "rc", JoinType.INNER_JOIN);
        criteria.createAlias("rc.recruitCommChannels", "rcom", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("rcom.channelName", parameter.getSenderBy(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(RecruitmenSelectionSeriesSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }//from  www .j  a va  2s .  com
    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.RecruitSelectionTypeDaoImpl.java

private void doSearchByParam(RecruitSelectionTypeSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }/*w ww.  ja  va 2 s . 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.RecruitVacancySelectionDaoImpl.java

private void doSearchByParam(RecruitVacancySelectionSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.START));
    }// ww  w .  j  a va 2 s .  co m
    if (searchParameter.getRecruitment() != null) {
        criteria.createAlias("recruitHireApply", "recruitHireApply", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("recruitHireApply.reqHireCode", searchParameter.getRecruitment(),
                MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}