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

private void doSearchByParam(SchedulerConfigSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }/*from  w w w . j  a  v a2  s  .c o m*/
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchSystemLetterReferenceByParam(SystemLetterReferenceSearchParameter parameter,
        Criteria criteria) {/* www  .j  a  va2s  .  c  o m*/
    if (parameter.getLetterSumary() != null) {
        criteria.add(Restrictions.like("letterSumary", parameter.getLetterSumary(), MatchMode.ANYWHERE));
    }
    if (parameter.getName() != null) {
        criteria.add(Restrictions.like("name", parameter.getName(), MatchMode.ANYWHERE));
    }
    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.SystemScoringDaoImpl.java

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

private void doSearchTempAttendanceRealizationByParam(TempAttendanceRealizationSearchParameter parameter,
        Criteria criteria) {//from www.  j  a va 2  s  . c o m
    if (parameter.getJabatan() != null) {
        criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
        criteria.createAlias("ce.jabatanByJabatanId", "jb", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("jb.name", parameter.getJabatan(), MatchMode.ANYWHERE));
    }

    if (parameter.getName() != null) {
        criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
        criteria.createAlias("ce.bioData", "bio", JoinType.INNER_JOIN);
        criteria.add(
                Restrictions.ilike("bio.combineName", parameter.getName().toLowerCase(), MatchMode.ANYWHERE));
    }
    if (parameter.getNik() != null) {
        criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("ce.nik", parameter.getNik(), MatchMode.ANYWHERE));

    }
    if (parameter.getNoJab() != null) {
        criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
        criteria.createAlias("ce.jabatanByJabatanId", "jb", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("jb.code", parameter.getNoJab(), MatchMode.ANYWHERE));

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

}

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

private void doSearchPaidOvertimeByParam(PaidOvertimeSearchParameter searchParameter, Criteria criteria) {
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);

    if (StringUtils.isNotBlank(searchParameter.getEmpName())) {
        Disjunction disjunctionName = Restrictions.disjunction();
        disjunctionName//from w  w  w .  ja v a 2  s .  com
                .add(Restrictions.like("bioData.firstName", searchParameter.getEmpName(), MatchMode.ANYWHERE));
        disjunctionName
                .add(Restrictions.like("bioData.middleName", searchParameter.getEmpName(), MatchMode.ANYWHERE));
        disjunctionName
                .add(Restrictions.like("bioData.lastName", searchParameter.getEmpName(), MatchMode.ANYWHERE));
        criteria.add(disjunctionName);
    }

    if (StringUtils.isNotBlank(searchParameter.getNik())) {
        criteria.add(Restrictions.like("empData.nik", searchParameter.getNik(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(UnregSalarySearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.ANYWHERE));
    }/*from  w  w w  .jav  a2  s  . com*/
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearch(WtFingerExceptionSearchParameter searchParameter, Criteria criteria) {
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.jabatanByJabatanId", "jabatanByJabatanId", JoinType.INNER_JOIN);

    if (StringUtils.isNotEmpty(searchParameter.getEmpData())) {
        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);//from   w ww .j a v a 2  s.  c o  m
    }
    if (searchParameter.getNik() != null) {
        criteria.add(Restrictions.like("empData.nik", searchParameter.getNik(), MatchMode.START));
    }
    if (searchParameter.getNamaJabatan() != null) {
        criteria.add(Restrictions.like("jabatanByJabatanId.name", searchParameter.getNamaJabatan(),
                MatchMode.ANYWHERE));
    }
    if (searchParameter.getCodeJabatan() != null) {
        criteria.add(Restrictions.like("jabatanByJabatanId.code", searchParameter.getCodeJabatan(),
                MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchWtGroupWorkingByParam(WtGroupWorkingSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getKode() != null && !searchParameter.getKode().isEmpty()) {
        criteria.add(Restrictions.like("code", searchParameter.getKode(), MatchMode.START));
    }/*from  w  ww.  j a  v  a 2s . c  o m*/

    if (searchParameter.getName() != null && !searchParameter.getName().isEmpty()) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }

}

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

private void doSearchWtHolidayByParam(HolidaySearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getReligionName() != null && !searchParameter.getReligionName().isEmpty()) {
        criteria.createAlias("religion", "r");
        criteria.add(Restrictions.like("r.name", searchParameter.getReligionName(), MatchMode.START));
    }//from  ww w. j a  va  2s  . c  o m

    if (searchParameter.getHolidayName() != null && !searchParameter.getHolidayName().isEmpty()) {
        criteria.add(Restrictions.like("holidayName", searchParameter.getHolidayName(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchWtOverTimeByParam(WtOverTimeSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getOverTimecode() != null && !searchParameter.getOverTimecode().isEmpty()) {
        criteria.add(Restrictions.like("code", searchParameter.getOverTimecode(), MatchMode.START));
    }/*  ww  w  .j av  a2s .co m*/

    if (searchParameter.getOverTimeName() != null && !searchParameter.getOverTimeName().isEmpty()) {
        criteria.add(Restrictions.like("name", searchParameter.getOverTimeName(), MatchMode.START));
    }

    if (searchParameter.getMinTime() != null && searchParameter.getMinTime() != 0) {
        criteria.add(Restrictions.eq("minimumTime", searchParameter.getMinTime()));
    }

    if (searchParameter.getMaxTime() != null && searchParameter.getMaxTime() != 0) {
        criteria.add(Restrictions.eq("maximumTime", searchParameter.getMaxTime()));
    }
}