Example usage for org.hibernate.criterion Restrictions ilike

List of usage examples for org.hibernate.criterion Restrictions ilike

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. 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.ar.dev.tierra.api.dao.impl.DetalleTransferenciaDAOimpl.java

@Override
@SuppressWarnings("null")
public List<WrapperStock> findByParams(String descripcion, String marca, String talla, String codigo,
        String categoria, int sucursal) {
    Criteria criteria = null;/*  ww  w.ja v a2 s .co m*/
    switch (sucursal) {
    case 1:
        criteria = getSession().createCriteria(StockTierra.class);
        break;
    case 2:
        criteria = getSession().createCriteria(StockBebelandia.class);
        break;
    case 3:
        criteria = getSession().createCriteria(StockLibertador.class);
        break;
    }
    criteria.add(Restrictions.eq("estado", true));
    criteria.addOrder(Order.asc("idStock"));
    Criteria producto = criteria.createCriteria("idProducto");
    if (!descripcion.equals("")) {
        producto.add(Restrictions.ilike("descripcion", descripcion, MatchMode.START));
    }
    if (!marca.equals("")) {
        Criteria marcas = producto.createCriteria("marcas");
        marcas.add(Restrictions.ilike("nombreMarca", marca, MatchMode.START));
    }
    if (!talla.equals("")) {
        producto.add(Restrictions.ilike("talla", talla, MatchMode.START));
    }
    if (!codigo.equals("")) {
        producto.add(Restrictions.ilike("codigoProducto", codigo, MatchMode.START));
    }
    if (!categoria.equals("")) {
        Criteria categorias = producto.createCriteria("categoria");
        categorias.add(Restrictions.ilike("nombreCategoria", categoria, MatchMode.START));
    }
    List<WrapperStock> list = new ArrayList<>();
    switch (sucursal) {
    case 1:
        List<StockTierra> tierraList = criteria.list();
        for (StockTierra stockTierra : tierraList) {
            WrapperStock wrapperTierra = new WrapperStock();
            wrapperTierra.setStockTierra(stockTierra);
            list.add(wrapperTierra);
        }
        break;
    case 2:
        List<StockBebelandia> bebeList = criteria.list();
        for (StockBebelandia stockBebelandia : bebeList) {
            WrapperStock wrapperBebelandia = new WrapperStock();
            wrapperBebelandia.setStockBebelandia(stockBebelandia);
            list.add(wrapperBebelandia);
        }
        break;
    case 3:
        List<StockLibertador> libertadorList = criteria.list();
        for (StockLibertador stockLibertador : libertadorList) {
            WrapperStock wrapperLibertador = new WrapperStock();
            wrapperLibertador.setStockLibertador(stockLibertador);
            list.add(wrapperLibertador);
        }
        break;
    }
    return list;
}

From source file:com.ar.dev.tierra.api.dao.impl.FacturaDAOImpl.java

@Override
public List<Factura> findByRegalo(String serial) {
    Criteria criteria = getSession().createCriteria(Factura.class);
    Calendar calendar = Calendar.getInstance();
    Date toDate = calendar.getTime();
    calendar.add(Calendar.MONTH, -1);
    Date fromDate = calendar.getTime();
    criteria.add(Restrictions.between("fechaCreacion", fromDate, toDate));
    criteria.add(Restrictions.ilike("regalo", serial, MatchMode.ANYWHERE));
    return criteria.list();
}

From source file:com.ar.dev.tierra.api.dao.impl.MarcasDAImpl.java

@Override
public List<Marcas> searchByText(String text) {
    Criteria criteria = getSession().createCriteria(Marcas.class);
    criteria.add(Restrictions.ilike("nombreMarca", text, MatchMode.ANYWHERE));
    List<Marcas> list = criteria.list();
    return list;// ww  w.j ava  2  s .co m
}

From source file:com.ar.dev.tierra.api.dao.impl.ProductoDAOImpl.java

@Override
public List<Producto> findByText(String text) {
    Criteria criteria = getSession().createCriteria(Producto.class);
    criteria.add(Restrictions.ilike("descripcion", text, MatchMode.ANYWHERE));
    List<Producto> productos = criteria.list();
    return productos;
}

From source file:com.ar.dev.tierra.api.dao.impl.ProductoDAOImpl.java

@Override
public List<Producto> findByBarcode(String barcode) {
    Criteria criteria = getSession().createCriteria(Producto.class);
    criteria.add(Restrictions.ilike("codigoProducto", barcode, MatchMode.START));
    criteria.add(Restrictions.gt("cantidadTotal", 0));
    List<Producto> list = criteria.list();
    return list;/*from www . j  a  va2 s . c  o m*/
}

From source file:com.ar.dev.tierra.api.dao.impl.ProductoDAOImpl.java

@Override
public List<Producto> advancedSearch(String descripcion, String marca, String talla, String codigo,
        String categoria) {//from   ww  w .j  a va  2  s.  c om
    Criteria producto = getSession().createCriteria(Producto.class);
    producto.add(Restrictions.ilike("descripcion", descripcion, MatchMode.ANYWHERE));
    producto.add(Restrictions.ilike("talla", talla, MatchMode.ANYWHERE));
    producto.add(Restrictions.ilike("codigoProducto", codigo, MatchMode.ANYWHERE));
    Criteria marcas = producto.createCriteria("marcas");
    marcas.add(Restrictions.ilike("nombreMarca", marca, MatchMode.ANYWHERE));
    Criteria categorias = producto.createCriteria("categoria");
    categorias.add(Restrictions.ilike("nombreCategoria", categoria, MatchMode.ANYWHERE));
    List<Producto> list = producto.list();
    return list;
}

From source file:com.ar.dev.tierra.api.dao.impl.ProveedorDAOImpl.java

@Override
public List<Proveedor> searchByText(String text) {
    Criteria criteria = getSession().createCriteria(Proveedor.class);
    criteria.add(Restrictions.ilike("nombreProveedor", text, MatchMode.ANYWHERE));
    List<Proveedor> list = criteria.list();
    return list;/*from  w  w  w.  j  a  va  2  s. c om*/
}

From source file:com.ar.dev.tierra.api.dao.impl.StockDAOImpl.java

@Override
@SuppressWarnings("null")
public List<WrapperStock> searchByBarcodeInStock(int sucursal, String barcode) {
    Criteria criteria = null;//  w w w . j a  va2 s.c  om
    switch (sucursal) {
    case 1:
        criteria = getSession().createCriteria(StockTierra.class);
        break;
    case 2:
        criteria = getSession().createCriteria(StockBebelandia.class);
        break;
    case 3:
        criteria = getSession().createCriteria(StockLibertador.class);
        break;
    }
    criteria.add(Restrictions.eq("estado", true));
    Criteria producto = criteria.createCriteria("idProducto");
    producto.add(Restrictions.ilike("codigoProducto", barcode, MatchMode.START));
    criteria.add(Restrictions.gt("cantidad", 0));
    criteria.addOrder(Order.desc("idStock"));
    List<WrapperStock> list = new ArrayList<>();
    switch (sucursal) {
    case 1:
        List<StockTierra> tierraList = criteria.list();
        for (StockTierra stockTierra : tierraList) {
            WrapperStock wrapperTierra = new WrapperStock();
            wrapperTierra.setStockTierra(stockTierra);
            list.add(wrapperTierra);
        }
        break;
    case 2:
        List<StockBebelandia> bebeList = criteria.list();
        for (StockBebelandia stockBebelandia : bebeList) {
            WrapperStock wrapperBebelandia = new WrapperStock();
            wrapperBebelandia.setStockBebelandia(stockBebelandia);
            list.add(wrapperBebelandia);
        }
        break;
    case 3:
        List<StockLibertador> libertadorList = criteria.list();
        for (StockLibertador stockLibertador : libertadorList) {
            WrapperStock wrapperLibertador = new WrapperStock();
            wrapperLibertador.setStockLibertador(stockLibertador);
            list.add(wrapperLibertador);
        }
        break;
    }
    return list;
}

From source file:com.benfante.minimark.blo.QuestionBo.java

License:Apache License

/**
 * Search questions by example./*from   w w w.  j  a v a2 s .  c  o m*/
 * 
 * @param questionBean The values for searching questions.
 * @return The list of questions matching the questionBean values.
 */
public List<Question> search(QuestionBean questionBean) {
    DetachedCriteria crit = null;
    if (StringUtils.isBlank(questionBean.getType())) {
        crit = DetachedCriteria.forClass(Question.class);
    } else {
        if ("open".equals(questionBean.getType())) {
            crit = DetachedCriteria.forClass(OpenQuestion.class);
            if (StringUtils.isNotBlank(questionBean.getVisualization())) {
                crit.add(Restrictions.eq("visualization", questionBean.getVisualization()));
            }
        } else if ("closed".equals(questionBean.getType())) {
            crit = DetachedCriteria.forClass(ClosedQuestion.class);
        } else {
            throw new IllegalArgumentException("Unknown question type (" + questionBean.getType() + ")");
        }
    }
    if (StringUtils.isNotBlank(questionBean.getTitle())) {
        crit.add(Restrictions.ilike("title", questionBean.getTitle(), MatchMode.ANYWHERE));
    }
    if (questionBean.getWeight() != null) {
        crit.add(Restrictions.eq("weight", questionBean.getWeight()));
    }
    if (questionBean.getCourse() != null && questionBean.getCourse().getId() != null) {
        crit.add(Restrictions.eq("course.id", questionBean.getCourse().getId()));
    }
    crit.addOrder(Order.asc("title"));
    crit.addOrder(Order.asc("content"));
    if (StringUtils.isNotBlank(questionBean.getTags())) {
        crit.createAlias("tags", "tags");
        crit.createAlias("tags.tag", "tag");
        crit.add(Restrictions.in("tag.name", questionBean.getTagList()));
    }
    crit.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    return questionDao.searchByCriteria(crit);
}

From source file:com.creativity.repository.Fichas.java

@SuppressWarnings("unchecked")
public List<Ficha> filtradosNovo(FichaFilter filtro) {
    Session session = manager.unwrap(Session.class);
    Criteria criteria = session.createCriteria(Ficha.class).createAlias("gestor", "v");
    ;/* w  ww.j  a  v  a 2 s  . co  m*/

    if (StringUtils.isNotBlank(filtro.getNomeVendedor())) {
        criteria.add(Restrictions.ilike("v.nome", filtro.getNomeVendedor(), MatchMode.ANYWHERE));
    }

    return criteria.addOrder(Order.asc("v.nome")).list();
}