Example usage for org.hibernate.criterion Restrictions ilike

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions ilike.

Prototype

public static Criterion ilike(String propertyName, String value, MatchMode matchMode)

Source Link

Document

A case-insensitive "like" (similar to Postgres ilike operator) using the provided match mode

Usage

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.j  a  v a  2 s  .co 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.TempAttendanceRealizationDaoImpl.java

private void doSearchTempAttendanceRealizationByParam(TempAttendanceRealizationSearchParameter parameter,
        Criteria criteria) {/*  www  .j a v  a 2 s. co 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.isotrol.impe3.hib.query.FilterSupport.java

License:Open Source License

/**
 * Adds a restriction. The restriction is only added if the filter and the mode are not {@code null}.
 * @param c Criteria./*w  ww.  j  a  v  a 2 s . c om*/
 * @param property Property name.
 * @param filter Filter value.
 * @param mode Match mode.
 * @return The criteria for method chaining.
 */
public static Criteria add(Criteria c, String property, String filter, StringMatchMode mode) {
    if (filter != null && mode != null) {
        c.add(Restrictions.ilike(property, filter, MATCH_MAP.get(mode)));
    }
    return c;
}

From source file:com.isotrol.impe3.hib.query.FilterSupport.java

License:Open Source License

/**
 * Creates a criterion. If filter or mode is {@code null} then returns {@code null}.
 * @param property Property name.//w w w  .j  a va2  s.  co m
 * @param filter Filter value.
 * @param mode Match mode to force.
 * @return The criterion for method chaining.
 */
public static Criterion criterion(String property, String filter, StringMatchMode mode) {
    if (filter == null || mode == null) {
        return null;
    }
    return Restrictions.ilike(property, filter, MATCH_MAP.get(mode));
}

From source file:com.itfaculty.progress.dao.Impl.PatientsDaoImpl.java

@Override
public List<Patients> GetAllPatients(String patientId) {
    Criteria cr = sessionFactory.getCurrentSession().createCriteria(Patients.class);
    Criterion frist = Restrictions.ilike("patientNicid", patientId + "%", MatchMode.ANYWHERE);
    Criterion last = Restrictions.ilike("patientFirstname", patientId + "%", MatchMode.ANYWHERE);
    LogicalExpression orExp = Restrictions.or(frist, last);
    cr.add(orExp);//from  ww  w  .j  a v a2 s  . c  om
    List<Patients> result = cr.list();
    return result;
}

From source file:com.itfaculty.progress.dao.Impl.RecordsDaoImpl.java

@Override
public List<Records> GetRecordsByPationId(int pationId) {
    Criteria cr = sessionFactory.getCurrentSession().createCriteria(Records.class);
    Criterion catagarylist = Restrictions.ilike("patients.patientId", pationId + "%", MatchMode.ANYWHERE);
    cr.add(catagarylist);/*from   w ww . j a  v a 2s.  c o  m*/
    List<Records> result = cr.list();
    return result;
}

From source file:com.jsilvamoises.controller.MBPessoa.java

public List<Pessoa> listByNomeLike(String nome) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Pessoa.class);
    criteria.add(Restrictions.ilike("nome", nome, MatchMode.ANYWHERE));
    return pessoaDAO().getEntitiesByDetachedCriteria(criteria);
}

From source file:com.jubination.model.dao.ClientDAOImpl.java

@Transactional(propagation = Propagation.REQUIRED, readOnly = true)
public List<TempClient> readBackupEntityByNumberAndDate(String number, String date) {
    System.out.println(//w  ww.j  a  v a 2  s .  co  m
            "READ TEMP CLIENT TODAY WITH SAME NUMBER:::::::::::::::::::::::::::::::::::::::::::::::CHECK");
    session = getSessionFactory().getCurrentSession();
    return session.createCriteria(TempClient.class).add(Restrictions.and(Restrictions.eq("phoneNumber", number),
            Restrictions.ilike("dateCreation", date, MatchMode.START))).list();

}

From source file:com.jubination.model.dao.ProductsDAOImpl.java

@Transactional(propagation = Propagation.REQUIRED, readOnly = true)
public List<String> fetchProductNames(String name) {
    session = getSessionFactory().getCurrentSession();
    return session.createCriteria(Products.class)
            .setProjection(Projections.projectionList().add(Projections.property("name")))
            .add(Restrictions.ilike("name", name, MatchMode.START))
            .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY).list();

}

From source file:com.jubination.model.dao.ProductsDAOImpl.java

@Transactional(propagation = Propagation.REQUIRED, readOnly = true)
public List<String> fetchCampaignNames(String name) {
    session = getSessionFactory().getCurrentSession();
    return session.createCriteria(Campaigns.class)
            .setProjection(Projections.projectionList().add(Projections.property("name")))
            .add(Restrictions.ilike("name", name, MatchMode.START))
            .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY).list();
}