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, Object value)

Source Link

Document

A case-insensitive "like" (similar to Postgres ilike operator)

Usage

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

public java.util.Collection<Upload> searchUpload(Upload upload) {
    Criteria criteria = getSession().createCriteria(Upload.class);

    if (upload.getId() != null) {
        criteria.add(Restrictions.eq(au.org.theark.phenotypic.web.Constants.UPLOAD_ID, upload.getId()));
    }/* w  ww .j a v a2  s .  com*/

    if (upload.getStudy() != null) {
        criteria.add(Restrictions.eq(au.org.theark.phenotypic.web.Constants.UPLOAD_STUDY, upload.getStudy()));
    }

    if (upload.getArkFunction() != null) {
        criteria.add(Restrictions.eq("arkFunction", upload.getArkFunction()));
    }

    if (upload.getFileFormat() != null) {
        criteria.add(Restrictions.ilike(au.org.theark.phenotypic.web.Constants.UPLOAD_FILE_FORMAT,
                upload.getFileFormat()));
    }

    if (upload.getDelimiterType() != null) {
        criteria.add(Restrictions.ilike(au.org.theark.phenotypic.web.Constants.UPLOAD_DELIMITER_TYPE,
                upload.getDelimiterType()));
    }

    if (upload.getFilename() != null) {
        criteria.add(Restrictions.ilike(au.org.theark.phenotypic.web.Constants.UPLOAD_FILENAME,
                upload.getFilename()));
    }

    criteria.addOrder(Order.desc(au.org.theark.phenotypic.web.Constants.UPLOAD_ID));
    java.util.Collection<Upload> uploadCollection = criteria.list();

    return uploadCollection;
}

From source file:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Phone> getPersonPhoneList(Long personId, Phone phone) throws ArkSystemException {

    Criteria phoneCriteria = getSession().createCriteria(Phone.class);

    if (personId != null) {
        phoneCriteria.add(Restrictions.eq(Constants.PERSON_PERSON_ID, personId));
    }/* www.j  a va2s.c  om*/

    if (phone != null) {

        if (phone.getId() != null) {
            phoneCriteria.add(Restrictions.eq(Constants.PHONE_ID, phone.getId()));
        }

        if (phone.getPhoneNumber() != null) {
            phoneCriteria.add(Restrictions.ilike(Constants.PHONE_NUMBER, phone.getPhoneNumber()));
        }

        if (phone.getPhoneType() != null) {
            phoneCriteria.add(Restrictions.eq(Constants.PHONE_TYPE, phone.getPhoneType()));
        }

        if (phone.getAreaCode() != null) {
            phoneCriteria.add(Restrictions.eq(Constants.AREA_CODE, phone.getAreaCode()));
        }
        phoneCriteria.setFetchMode("silentMode", FetchMode.JOIN);

    }

    List<Phone> personPhoneList = phoneCriteria.list();
    //log.info("Number of phones fetched " + personPhoneList.size() + "  Person Id" + personId.intValue());

    //if (personPhoneList.isEmpty()) {
    // throw new EntityNotFoundException("The entity with id" + personId.toString() + " cannot be found.");
    //   log.info(" personId " + personId + " had no phones.  No drama");
    //   }
    return personPhoneList;
}

From source file:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

private ConsentOption getConsentOption(String value) {
    Criteria criteria = getSession().createCriteria(ConsentOption.class);
    criteria.add(Restrictions.ilike("name", value));
    return (ConsentOption) criteria.list().get(0);
}

From source file:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

/**
 * Genenal Phone search.//from  w  w  w  .  ja va2s  . c  o  m
 * @param personId
 * @param phone
 * @return
 */
private Criteria buildGeneralPhoneCriteria(Long personId, Phone phone) {
    Criteria phoneCriteria = getSession().createCriteria(Phone.class);

    if (personId != null) {
        phoneCriteria.add(Restrictions.eq(Constants.PERSON_PERSON_ID, personId));
    }

    if (phone != null) {

        if (phone.getId() != null) {
            phoneCriteria.add(Restrictions.eq(Constants.PHONE_ID, phone.getId()));
        }

        if (phone.getPhoneNumber() != null) {
            phoneCriteria.add(Restrictions.ilike(Constants.PHONE_NUMBER, phone.getPhoneNumber()));
        }

        if (phone.getPhoneType() != null) {
            phoneCriteria.add(Restrictions.eq(Constants.PHONE_TYPE, phone.getPhoneType()));
        }

        if (phone.getAreaCode() != null) {
            phoneCriteria.add(Restrictions.eq(Constants.AREA_CODE, phone.getAreaCode()));
        }
        phoneCriteria.setFetchMode("silentMode", FetchMode.JOIN);

    }
    return phoneCriteria;
}

From source file:br.com.bb.intranet.supermt.governo.repository.Clientes.java

public Cliente porMci(String mci) {
    Criteria criteria = criarCriteria();
    criteria.add(Restrictions.ilike("mci", mci));

    return (Cliente) criteria.uniqueResult();
}

From source file:br.com.bb.intranet.supermt.pf.desembolso.repository.Desembolsos.java

public List<Desembolso> porGrupo(String grupo) {
    Criteria criteria = criarCriteria();

    criteria.add(Restrictions.ilike("grupo", grupo));

    return criteria.list();
}

From source file:br.com.caelum.vraptor.mydvds.dao.DefaultDvdDao.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Dvd> searchSimilarTitle(String title) {
    // creates a criteria based on the Dvd class and adds
    // the "title" restriction and then returns the list.
    return session.createCriteria(Dvd.class).add(Restrictions.ilike("title", "%" + title + "%")).list();
}

From source file:br.com.moises.suport.EmbarqueSuport.java

public List<Embarque> embarquePorNumero(Long valor) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Embarque.class).add(Restrictions.ilike("id", valor));

    return Dao().getEntitiesByDetachetCriteria(criteria);
}

From source file:br.com.rhmanager.daoImpl.FuncionarioDAOImpl.java

@Override
public List<Funcionario> getFuncionariosBusca(String nome, String cpf, Cargo cargo) {
    Session session = null;//from   w ww .  j a  v  a2 s.  co m
    try {
        session = HibernateUtil.getSession();
        Criteria criteria = session.createCriteria(Funcionario.class);

        if (nome.length() > 0) {
            criteria.add(Restrictions.ilike("nome", "%" + nome + "%"));
        }

        if (cpf.length() > 0) {
            criteria.add(Restrictions.ilike("cpf", cpf + "%"));
        }

        criteria.setFetchMode("cargos", FetchMode.JOIN);

        return criteria.list();
    } catch (Exception e) {
        e.printStackTrace();
        return null;
    } finally {
        if (!session.isConnected()) {
            session.close();
        }
    }
}

From source file:br.com.una.pa.condominio.mobile.dao.impl.CondominioDAOImpl.java

public Boolean verificarSeJaExiste(Condominio condominio) throws DAOException {
    HashMap<String, String> hash = new HashMap<>();
    hash.put("endereco", "ende");
    List<Object[]> lista = this.consultarPorRestricoes(0, 0, null, hash, getProjectList("id", "nome"),
            Restrictions.eq("tipoCondominio.id", condominio.getTipoCondominio().getId()),
            Restrictions.ilike("nome", condominio.getNome()),
            Restrictions.eq("ende.cep", condominio.getEndereco().getCep()));
    return lista != null && lista.size() > 0;
}