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.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

/**
 * Obtain a list of Area object using filters.
 *
 * @param area Filter object//from w  w  w. j a v  a  2s . c o m
 * @return List<Area> List of Area objects
 */
@Override
public List<Area> getAreaList(Area area) {
    List<Area> areas = null;
    Criteria criteria = this.getSession().createCriteria(Area.class);
    criteria.addOrder(Order.asc("id"));
    if (area != null) {
        if (area.getName() != null && area.getName().length() > 0) {
            criteria.add(Restrictions.ilike("name", area.getName(), MatchMode.ANYWHERE));
        }
        if (area.getDescription() != null && area.getDescription().length() > 0) {
            criteria.add(Restrictions.ilike("description", area.getDescription(), MatchMode.ANYWHERE));
        }
        if (area.getAreaType() != null && area.getAreaType().getId() != null
                && area.getAreaType().getId() > 0) {
            criteria.add(Restrictions.eq("areaType.id", area.getAreaType().getId()));
        }
        if (area.getStore() != null && area.getStore().getId() != null && area.getStore().getId() > 0) {
            criteria.add(Restrictions.eq("store.id", area.getStore().getId()));
        }
    }
    areas = criteria.list();
    return areas;
}

---

From source file:com.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

/**
 * Obtain a list of Store object using filters.
 *
 * @param store Filter object/*from   w  w  w  . j  a  v  a  2  s .  com*/
 * @return List<Store> List of Store objects
 */
@Override
public List<Store> getStoreList(Store store) {
    List<Store> stores = null;
    Criteria criteria = this.getSession().createCriteria(Store.class);
    criteria.addOrder(Order.asc("description"));
    if (store != null) {
        if (store.getName() != null && store.getName().length() > 0) {
            criteria.add(Restrictions.ilike("name", store.getName(), MatchMode.ANYWHERE));
        }
        if (store.getDescription() != null && store.getDescription().length() > 0) {
            criteria.add(Restrictions.ilike("description", store.getDescription(), MatchMode.ANYWHERE));
        }
        if (store.getCorporate() != null && store.getCorporate().getId() != null
                && store.getCorporate().getId() > 0) {
            criteria.add(Restrictions.eq("corporate.id", store.getCorporate().getId()));
        }
        if (store.getAddress() != null && store.getAddress().length() > 0) {
            criteria.add(Restrictions.ilike("address", store.getAddress(), MatchMode.ANYWHERE));
        }
        if (store.getEvidenceExtractionServicesServer() != null
                && store.getEvidenceExtractionServicesServer().getId() != null
                && store.getEvidenceExtractionServicesServer().getId() > 0) {
            criteria.add(Restrictions.eq("evidenceExtractionServicesServer.id",
                    store.getEvidenceExtractionServicesServer().getId()));
        }
        if (store.getEvidenceServicesServer() != null && store.getEvidenceServicesServer().getId() != null
                && store.getEvidenceServicesServer().getId() > 0) {
            criteria.add(
                    Restrictions.eq("evidenceServicesServer.id", store.getEvidenceServicesServer().getId()));
        }
    }
    stores = criteria.list();
    return stores;
}

---

From source file:com.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

/**
 * Obtain a list of EvidenceServicesServer object using filters.
 *
 * @param ess Filter object/*from w w w . j ava2s.  co  m*/
 * @return List<EvidenceServicesServer> List of EvidenceServicesServer objects
 */
@Override
public List<EvidenceServicesServer> getEvidenceServicesServersList(EvidenceServicesServer ess) {
    List<EvidenceServicesServer> list = null;
    Criteria criteria = this.getSession().createCriteria(EvidenceServicesServer.class);
    criteria.addOrder(Order.asc("id"));
    if (ess != null) {
        if (ess.getUrl() != null && ess.getUrl().length() > 0) {
            criteria.add(Restrictions.ilike("url", ess.getUrl(), MatchMode.ANYWHERE));
        }
        if (ess.getEvidencePath() != null && ess.getEvidencePath().length() > 0) {
            criteria.add(Restrictions.ilike("evidencePath", ess.getEvidencePath(), MatchMode.ANYWHERE));
        }
    }
    list = criteria.list();
    return list;
}

---

From source file:com.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

/**
 * Obtain a list of EvidenceExtractionServicesServer object using filters.
 *
 * @param eess Filter object/*  www. j  a  v a  2  s  .c o  m*/
 * @return List<EvidenceExtractionServicesServer> List of EvidenceExtractionServicesServer objects
 */
@Override
public List<EvidenceExtractionServicesServer> getEvidenceExtractionServicesServersList(
        EvidenceExtractionServicesServer eess) {
    List<EvidenceExtractionServicesServer> list = null;
    Criteria criteria = this.getSession().createCriteria(EvidenceExtractionServicesServer.class);
    criteria.addOrder(Order.asc("id"));
    if (eess != null) {
        if (eess.getEvidenceServicesServer() != null && eess.getEvidenceServicesServer().getId() != null
                && eess.getEvidenceServicesServer().getId() > 0) {
            criteria.add(
                    Restrictions.eq("evidenceServicesServer.id", eess.getEvidenceServicesServer().getId()));
        }
        if (eess.getUrl() != null && eess.getUrl().length() > 0) {
            criteria.add(Restrictions.ilike("url", eess.getUrl(), MatchMode.ANYWHERE));
        }
        if (eess.getStores() != null && eess.getStores().size() > 0) {
            List<String> names = new LinkedList<String>();
            for (Store store : eess.getStores()) {
                names.add(store.getName());
            }
            criteria.setFetchMode("Place", FetchMode.JOIN).add(Restrictions.in("name", names));
        }
    }
    list = criteria.list();
    return list;
}

---

From source file:com.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

/**
 * Obtain a list of EvidenceExtractionServicesServer object using filters.
 *
 * @param eess Filter object/*from   w w  w .ja va 2s  .c om*/
 * @return List<EvidenceExtractionServicesServer> List of EvidenceExtractionServicesServer objects
 */
@Override
public List<EvidenceExtractionServicesServer> getFreeEvidenceExtractionServicesServersList(
        EvidenceExtractionServicesServer eess) {
    List<EvidenceExtractionServicesServer> list = null;
    Criteria criteria = this.getSession().createCriteria(EvidenceExtractionServicesServer.class);
    criteria.addOrder(Order.asc("id"));
    if (eess != null) {
        if (eess.getEvidenceServicesServer() != null && eess.getEvidenceServicesServer().getId() != null
                && eess.getEvidenceServicesServer().getId() > 0) {
            criteria.add(
                    Restrictions.eq("evidenceServicesServer.id", eess.getEvidenceServicesServer().getId()));
        }
        if (eess.getUrl() != null && eess.getUrl().length() > 0) {
            criteria.add(Restrictions.ilike("url", eess.getUrl(), MatchMode.ANYWHERE));
        }
    }
    // se elimina ya que in ees puede tener mucho stores asociados
    // if (eess != null && eess.getStore() != null && eess.getStore().getId() != null && eess.getStore().getId() > 0) {
    // criteria.add(Restrictions.or(Restrictions.eq("store.id", eess.getStore().getId()), Restrictions.isNull("store")));
    // } else {
    // criteria.add(Restrictions.isNull("store.id"));
    // }
    list = criteria.list();
    return list;
}

---

From source file:com.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

/**
 * Obtain a list of EvidenceProvider object using filters.
 *
 * @param evidenceProvider Filter object
 * @return List<EvidenceProvider> List of EvidenceProvider objects
 *///from www .j  a  v  a  2  s  . c  om
@Override
public List<EvidenceProvider> getEvidenceProvidersList(EvidenceProvider evidenceProvider) {
    log.info("start");
    List<EvidenceProvider> list = null;
    Criteria criteria = this.getSession().createCriteria(EvidenceProvider.class);
    criteria.addOrder(Order.asc("id"));
    if (evidenceProvider != null) {
        if (evidenceProvider.getName() != null && evidenceProvider.getName().length() > 0) {
            criteria.add(Restrictions.ilike("name", evidenceProvider.getName(), MatchMode.ANYWHERE));
        }
        if (evidenceProvider.getDescription() != null && evidenceProvider.getDescription().length() > 0) {
            criteria.add(
                    Restrictions.ilike("description", evidenceProvider.getDescription(), MatchMode.ANYWHERE));
        }
        if (evidenceProvider.getEvidenceProviderType() != null
                && evidenceProvider.getEvidenceProviderType().getId() != null
                && evidenceProvider.getEvidenceProviderType().getId() > 0) {
            criteria.add(Restrictions.eq("evidenceProviderType.id",
                    evidenceProvider.getEvidenceProviderType().getId()));
        }
        if (evidenceProvider.getStore() != null && evidenceProvider.getStore().getId() != null
                && evidenceProvider.getStore().getId() > 0) {
            criteria.add(Restrictions.eq("store.id", evidenceProvider.getStore().getId()));
        }
        if (!evidenceProvider.getAreas().isEmpty()) {
            Set<Integer> ids = new HashSet<Integer>();
            for (Area a : evidenceProvider.getAreas()) {
                if (a.getId() != -1) {
                    ids.add(a.getId());
                }
            }
            if (ids.size() > 0) {
                criteria.createCriteria("areas").add(Restrictions.in("id", ids.toArray(new Integer[0])));
                // debemos cargar tambien las relaciones
                // criteria.createCriteria("relationEvidenceProviderLocationsFrom").add(Restrictions.in("area.id",
                // ids.toArray(new Integer[0])));
            }

        }
        // if (evidenceProvider.getArea() != null && evidenceProvider.getArea().getAreaType() != null
        // && evidenceProvider.getArea().getAreaType().getId() != null && evidenceProvider.getArea().
        // getAreaType().getId() > 0) {
        // criteria.createCriteria("area").add(Restrictions.eq("areaType.id",
        // evidenceProvider.getArea().getAreaType().getId()));
        // }
    }

    list = criteria.list();
    log.info("end " + list.size());
    return list;
}

---

From source file:com.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

/**
 * Obtain a list of Sensor object using filters.
 *
 * @param sensor Filter object// w  w w.j a v a 2  s.  c om
 * @return List<EvidenceProvider> List of EvidenceProvider objects
 */
@Override
public List<Sensor> getSensorList(Sensor sensor) {
    List<Sensor> list = null;
    Criteria criteria = this.getSession().createCriteria(Sensor.class);
    criteria.addOrder(Order.asc("id"));
    if (sensor != null) {
        if (sensor.getName() != null && sensor.getName().length() > 0) {
            criteria.add(Restrictions.ilike("name", sensor.getName(), MatchMode.ANYWHERE));
        }
        if (sensor.getDescription() != null && sensor.getDescription().length() > 0) {
            criteria.add(Restrictions.ilike("description", sensor.getDescription(), MatchMode.ANYWHERE));
        }
        if (sensor.getStore() != null && sensor.getStore().getId() != null && sensor.getStore().getId() > 0) {
            criteria.add(Restrictions.eq("store.id", sensor.getStore().getId()));
        }
        if (sensor.getArea() != null && sensor.getArea().getId() != null && sensor.getArea().getId() > 0) {
            criteria.add(Restrictions.eq("area.id", sensor.getArea().getId()));
        }
        if (sensor.getArea() != null && sensor.getArea().getAreaType() != null
                && sensor.getArea().getAreaType().getId() != null
                && sensor.getArea().getAreaType().getId() > 0) {
            criteria.createCriteria("area")
                    .add(Restrictions.eq("areaType.id", sensor.getArea().getAreaType().getId()));
        }
    }
    list = criteria.list();
    return list;
}

---

From source file:com.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

/**
 * Obtain a list of Country object using filters.
 *
 * @param country Filter object/*from  w w  w. jav a2 s . co m*/
 * @return List<Country> List of Country objects
 */
@Override
public List<Country> getCountryList(Country country) {
    List<Country> list = null;
    Criteria criteria = this.getSession().createCriteria(Country.class);
    criteria.addOrder(Order.asc("id"));
    if (country != null) {
        if (country.getName() != null && country.getName().length() > 0) {
            criteria.add(Restrictions.ilike("name", country.getName(), MatchMode.ANYWHERE));
        }
        if (country.getDescription() != null && country.getDescription().length() > 0) {
            criteria.add(Restrictions.ilike("description", country.getDescription(), MatchMode.ANYWHERE));
        }
        if (country.getCode() != null && country.getCode().length() > 0) {
            criteria.add(Restrictions.ilike("code", country.getCode(), MatchMode.ANYWHERE));
        }
    }
    list = criteria.list();
    return list;
}

---

From source file:com.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

/**
 * Obtain a list of Region object using filters.
 *
 * @param region Filter object//from ww  w  . j  a va2  s . c o m
 * @return List<Region> List of Region objects
 */
@Override
public List<Region> getRegionList(Region region) {
    List<Region> list = null;
    Criteria criteria = this.getSession().createCriteria(Region.class);
    criteria.addOrder(Order.asc("id"));
    if (region != null) {
        if (region.getName() != null && region.getName().length() > 0) {
            criteria.add(Restrictions.ilike("name", region.getName(), MatchMode.ANYWHERE));
        }
        if (region.getDescription() != null && region.getDescription().length() > 0) {
            criteria.add(Restrictions.ilike("description", region.getDescription(), MatchMode.ANYWHERE));
        }
        if (region.getCountry() != null && region.getCountry().getId() != null
                && region.getCountry().getId() > 0) {
            Criteria criteriaCountry = criteria.createCriteria("country");
            criteriaCountry.add(Restrictions.eq("id", region.getCountry().getId()));
        }
    }
    list = criteria.list();
    return list;
}

---

From source file:com.scopix.periscope.evaluationmanagement.dao.ObservedSituationHibernateDAOImpl.java

License:Open Source License

@Override
public List<Formula> getFormulaList(Formula filter) {
    Session session = this.getSession();
    List<Formula> formulas = null;
    try {/*from  w w w .  j  a  v a 2 s. co  m*/
        Criteria criteria = session.createCriteria(Formula.class);
        criteria.addOrder(Order.asc("description"));
        if (filter != null) {
            if (filter.getDescription() != null && filter.getDescription().length() > 0) {
                criteria.add(Restrictions.ilike("description", filter.getDescription(), MatchMode.ANYWHERE));
            }
            if (filter.getSituationTemplates() != null && !filter.getSituationTemplates().isEmpty()) {
                List<Integer> stIds = new ArrayList<Integer>();
                for (SituationTemplate st : filter.getSituationTemplates()) {
                    stIds.add(st.getId());
                }
                criteria.createCriteria("situationTemplates").add(Restrictions.in("id", stIds));
            }
            if (filter.getStores() != null && !filter.getStores().isEmpty()) {
                List<Integer> sIds = new ArrayList<Integer>();
                for (Store s : filter.getStores()) {
                    sIds.add(s.getId());
                }
                criteria.createCriteria("stores").add(Restrictions.in("id", sIds));
            }
            if (filter.getType() != null) {
                criteria.add(Restrictions.eq("type", filter.getType()));
            }
            if (filter.getCompliantType() != null) {
                criteria.add(Restrictions.eq("compliantType", filter.getCompliantType()));
            }
        }
        formulas = criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return formulas;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• »