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

private void doSearchLHrmRoleByParam(HrmRoleSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getRoleName() != null) {
        criteria.add(Restrictions.like("roleName", searchParameter.getRoleName(), MatchMode.START));
    }/*  ww  w .ja  v  a2  s  .  c om*/
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchSpiUserByParam(HrmUserSearchParameter parameter, Criteria criteria) {
    if (parameter.getUserName() != null) {
        criteria.add(Restrictions.like("userId", parameter.getUserName(), MatchMode.ANYWHERE));

    }/*from   w  w  w.  ja v  a  2 s  .c  o m*/

    if (parameter.getRealName() != null) {
        criteria.add(Restrictions.like("realName", parameter.getRealName(), MatchMode.ANYWHERE));
    }

    if (parameter.getRoleName() != null) {
        criteria.createAlias("hrmUserRoles", "h");
        criteria.createAlias("h.hrmRole", "hrmRole");
        criteria.add(Restrictions.like("hrmRole.roleName", parameter.getRoleName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

@Override
public List<HrmUser> getByName(String name) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.like("realName", name, MatchMode.ANYWHERE));
    criteria.add(Restrictions.eq("isActive", HRMConstant.ACTIVE));
    criteria.setFirstResult(0);//  w ww  .  j av  a 2 s .c  o  m
    criteria.setMaxResults(7);
    return criteria.list();
}

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

@Override
public List<HrmUser> getAllDataByNameOrNik(String param) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("bioData.firstName", param, MatchMode.ANYWHERE));
    disjunction.add(Restrictions.like("bioData.lastName", param, MatchMode.ANYWHERE));
    disjunction.add(Restrictions.like("empData.nik", param, MatchMode.ANYWHERE));
    criteria.add(disjunction);//w  w w  .j  a  v  a2s .co  m
    return criteria.list();
}

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

private void doSearchByParam(String parameter, Criteria criteria,
        InclusionReimbursmentModel inclusionReimbursmentModel) {
    criteria.createAlias("reimbursmentSchema", "reimbursmentSchema", JoinType.INNER_JOIN);
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("reimbursmentSchema.payrollComponent", Boolean.TRUE));
    criteria.add(Restrictions.ge("claimDate", inclusionReimbursmentModel.getStartDate()));
    criteria.add(Restrictions.lt("claimDate", inclusionReimbursmentModel.getEndDate()));
    if (StringUtils.isNotEmpty(parameter)) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", parameter, MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.firstName", parameter, MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.lastName", parameter, MatchMode.ANYWHERE));
        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.InsuranceDaoImpl.java

private void doSearchByParam(InsuranceSearchParameter parameter, Criteria criteria) {
    if (parameter.getCode() != null) {
        criteria.add(Restrictions.like("code", parameter.getCode(), MatchMode.ANYWHERE));
    }/*  w w w.  j a  va2s  . c o  m*/

    if (parameter.getName() != null) {
        criteria.add(Restrictions.like("name", parameter.getName(), MatchMode.ANYWHERE));
    }
    if (parameter.getInsuranceProduct() != null) {
        criteria.add(
                Restrictions.like("insuranceProduct", parameter.getInsuranceProduct(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

@Override
public Long getByIpPermitLocation(String location) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.like("lokasi", location, MatchMode.ANYWHERE));
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

private void doSearchMaritalStatusByParam(IpPermitSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getLokasi() != null) {
        criteria.add(Restrictions.like("lokasi", searchParameter.getLokasi(), MatchMode.START));
    }//from  www . j  a  va 2  s  . c  o m
    if (searchParameter.getFrom() != null) {
        criteria.add(Restrictions.like("ipAddressFromView", searchParameter.getFrom(), MatchMode.START));
    }
    if (searchParameter.getUntil() != null) {
        criteria.add(Restrictions.like("ipAddressUntilView", searchParameter.getUntil(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(JabatanSearchParameter parameter, Criteria criteria) {
    /** 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());
    criteria.createAlias("department.company", "company", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("company.id", HrmUserInfoUtil.getCompanyId()));
    if (StringUtils.isNotEmpty(parameter.getCode())) {
        criteria.add(Restrictions.like("code", parameter.getCode(), MatchMode.ANYWHERE));
    }/*from   www. jav  a 2s.c om*/

    if (StringUtils.isNotEmpty(parameter.getGolJab())) {
        criteria.add(Restrictions.like("golonganJabatan.code", parameter.getGolJab(), MatchMode.ANYWHERE));
    }
    if (StringUtils.isNotEmpty(parameter.getName())) {
        criteria.add(Restrictions.like("name", parameter.getName(), MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotEmpty(parameter.getCostCenterName())) {
        criteria.add(Restrictions.like("costCenter.name", parameter.getCostCenterName(), MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotEmpty(parameter.getDepartementName())) {
        criteria.add(Restrictions.like("department.departmentName", parameter.getDepartementName(),
                MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotEmpty(parameter.getJabatan())) {
        criteria.add(Restrictions.like("pangkat.pangkatName", parameter.getJabatan(), MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotEmpty(parameter.getUnitKerjaName())) {
        criteria.add(Restrictions.like("unitKerja.name", parameter.getUnitKerjaName(), MatchMode.ANYWHERE));
    }

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

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

@Override
public List<Jabatan> getByName(String name) {
    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());

    criteria.add(Restrictions.like("name", name, MatchMode.ANYWHERE));
    criteria.addOrder(Order.asc("name"));
    criteria.setFetchMode("department", FetchMode.JOIN);
    criteria.setFirstResult(0);//  w w  w  .  ja v  a 2 s  . c  o m
    criteria.setMaxResults(7);
    return criteria.list();
}