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.queuemanagement.dao.OperatorQueueManagementHibernateDAO.java

License:Open Source License

public List<OperatorQueue> getOperatorQueuesList(OperatorQueue operatorQueue) throws ScopixException {
    log.debug("start");
    List<OperatorQueue> operatorQueues = null;

    try {/*from ww  w  .  ja v  a  2  s . c  o m*/
        Criteria criteria = this.getSession().createCriteria(OperatorQueue.class);
        criteria.addOrder(Order.asc("name"));
        criteria.add(Restrictions.eq("activo", Boolean.TRUE));

        if (operatorQueue != null) {
            if (operatorQueue.getName() != null && operatorQueue.getName().length() > 0) {
                criteria.add(Restrictions.ilike("name", operatorQueue.getName(), MatchMode.ANYWHERE));
            }
            if (operatorQueue.getCreationDate() != null) {
                criteria.add(Restrictions.eq("creationDate", operatorQueue.getCreationDate()));
            }
            if (operatorQueue.getModifiedDate() != null) {
                criteria.add(Restrictions.eq("modifiedDate", operatorQueue.getModifiedDate()));
            }
        }

        operatorQueues = criteria.list();

    } catch (Exception ex) {
        log.debug("Error: ", ex);
        throw new ScopixException("operatorQueueManagement.error.list");
    }

    log.debug("end");
    return operatorQueues;

}

From source file:com.scopix.periscope.securitymanagement.dao.SecurityManagementHibernateDAO.java

License:Open Source License

/**
 * Obtain a list of AreaType object using filters.
 *
 * @param areaType Filter object//from  w  ww . j  a  v  a 2s.co  m
 * @return List<AreaType> List of AreaType objects
 */
public List<AreaType> getAreaTypeList(AreaType areaType) {
    log.debug("start");

    List<AreaType> areaTypes = null;
    Criteria criteria = this.getSession().createCriteria(AreaType.class);
    criteria.addOrder(Order.asc("id"));
    if (areaType != null) {
        if (areaType.getId() != null && areaType.getId() != 0) {
            criteria.add(Restrictions.eq("id", areaType.getId()));
        }
        if (areaType.getName() != null && areaType.getName().length() > 0) {
            criteria.add(Restrictions.ilike("name", areaType.getName(), MatchMode.ANYWHERE));
        }
        if (areaType.getDescription() != null && areaType.getDescription().length() > 0) {
            criteria.add(Restrictions.ilike("description", areaType.getDescription(), MatchMode.ANYWHERE));
        }
        if (areaType.getCorporate() != null && areaType.getCorporate().getId() != null
                && areaType.getCorporate().getId() > 0) {
            criteria.add(Restrictions.eq("corporate.id", areaType.getCorporate().getId()));
        }
    }
    areaTypes = criteria.list();
    log.debug("end");

    return areaTypes;
}

From source file:com.scopix.periscope.securitymanagement.dao.SecurityManagementHibernateDAO.java

License:Open Source License

public List<Corporate> getCorporateList(Corporate corporate) {
    log.debug("start");

    List<Corporate> corporates = null;
    Criteria criteria = this.getSession().createCriteria(Corporate.class);
    criteria.addOrder(Order.asc("id"));
    if (corporate != null) {
        if (corporate.getId() != null) {
            criteria.add(Restrictions.eq("id", corporate.getId()));
        }/*  w w  w  .ja  v  a2 s .  co  m*/
        if (corporate.getName() != null && corporate.getName().length() > 0) {
            criteria.add(Restrictions.ilike("name", corporate.getName(), MatchMode.ANYWHERE));
        }
        if (corporate.getDescription() != null && corporate.getDescription().length() > 0) {
            criteria.add(Restrictions.ilike("description", corporate.getDescription(), MatchMode.ANYWHERE));
        }
        if (corporate.getActive() != null && corporate.getActive()) {
            criteria.add(Restrictions.eq("active", corporate.getActive()));
        }
    }
    corporates = criteria.list();
    log.debug("end");

    return corporates;
}

From source file:com.scopix.periscope.securitymanagement.dao.SecurityManagementHibernateDAO.java

License:Open Source License

/**
 * Obtain a list of Store object using filters.
 *
 * @param store Filter object/*from  www . ja  va2 s  .c  om*/
 * @return List<Store> List of Store objects
 */
public List<Store> getStoreList(Store store) {
    log.debug("start");

    List<Store> stores = null;
    Criteria criteria = this.getSession().createCriteria(Store.class);
    criteria.addOrder(Order.asc("id"));
    if (store != null) {
        if (store.getId() != null && store.getId() != 0) {
            criteria.add(Restrictions.eq("id", store.getId()));
        }
        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()));
        }
    }
    stores = criteria.list();
    log.debug("end");

    return stores;
}

From source file:com.scopix.periscope.securitymanagement.dao.SecurityManagementHibernateDAO.java

License:Open Source License

public List<PeriscopeUser> getUserList(PeriscopeUser periscopeUser) {
    log.debug("start");

    List<PeriscopeUser> periscopeUsers = null;
    Criteria criteria = this.getSession().createCriteria(PeriscopeUser.class);
    criteria.addOrder(Order.asc("name"));
    if (periscopeUser != null) {
        if (periscopeUser.getName() != null && periscopeUser.getName().length() > 0) {
            criteria.add(Restrictions.ilike("name", periscopeUser.getName(), MatchMode.ANYWHERE));
        }/*from   ww w  .  j  a va2 s.c  o m*/
        if (periscopeUser.getUserState() != null) {
            criteria.add(Restrictions.eq("userState", periscopeUser.getUserState()));
        }
        if (periscopeUser.getStartDate() != null) {
            criteria.add(Restrictions.eq("startDate", periscopeUser.getStartDate()));
        }
        if (periscopeUser.getMainCorporate() != null) {
            criteria.add(Restrictions.eq("mainCorporate.id", periscopeUser.getMainCorporate().getId()));
        }
        criteria.add(Restrictions.eq("deleted", periscopeUser.isDeleted()));
    }
    periscopeUsers = criteria.list();
    log.debug("end");

    return periscopeUsers;
}

From source file:com.scopix.periscope.securitymanagement.dao.SecurityManagementHibernateDAO.java

License:Open Source License

public List<RolesGroup> getRolesGroupList(RolesGroup rolesGroup) {
    log.debug("start");

    List<RolesGroup> rolesGroups = null;
    Criteria criteria = this.getSession().createCriteria(RolesGroup.class);
    criteria.addOrder(Order.asc("name"));
    if (rolesGroup != null) {
        if (rolesGroup.getName() != null && rolesGroup.getName().length() > 0) {
            criteria.add(Restrictions.ilike("name", rolesGroup.getName(), MatchMode.ANYWHERE));
        }//from   w  ww . j av  a  2s . c  om
        if (rolesGroup.getDescription() != null) {
            criteria.add(Restrictions.ilike("description", rolesGroup.getDescription(), MatchMode.ANYWHERE));
        }
        criteria.add(Restrictions.eq("deleted", rolesGroup.isDeleted()));
    }
    rolesGroups = criteria.list();
    log.debug("end");

    return rolesGroups;
}

From source file:com.scopix.periscope.securitymanagement.dao.SecurityManagementHibernateDAO.java

License:Open Source License

public List<Role> getRoleList(Role role) {
    log.debug("start");

    List<Role> roles = null;
    Criteria criteria = this.getSession().createCriteria(Role.class);
    criteria.addOrder(Order.asc("roleName"));
    if (role != null) {
        if (role.getRoleName() != null && role.getRoleName().length() > 0) {
            criteria.add(Restrictions.ilike("roleName", role.getRoleName(), MatchMode.ANYWHERE));
        }/*  w w w . ja va2s.  co  m*/
    }
    roles = criteria.list();
    log.debug("end");

    return roles;
}

From source file:com.scopix.periscope.templatemanagement.dao.TemplateManagementHibernateDAOImpl.java

License:Open Source License

@Override
public List<MetricTemplate> getMetricTemplateList(MetricTemplate metricTemplate) throws ScopixException {
    log.debug("start");
    List<MetricTemplate> metricTemplates = null;
    try {/*  w w w. j  a  va2s.com*/
        Criteria criteria = this.getSession().createCriteria(MetricTemplate.class);
        criteria.addOrder(Order.asc("id"));
        if (metricTemplate != null) {
            if (metricTemplate.getName() != null && metricTemplate.getName().length() > 0) {
                criteria.add(Restrictions.ilike("name", metricTemplate.getName(), MatchMode.ANYWHERE));
            }
            if (metricTemplate.getDescription() != null && metricTemplate.getDescription().length() > 0) {
                criteria.add(
                        Restrictions.ilike("description", metricTemplate.getDescription(), MatchMode.ANYWHERE));
            }
            if (metricTemplate.getEvidenceTypeElement() != null) {
                criteria.add(Restrictions.eq("evidenceTypeElement", metricTemplate.getEvidenceTypeElement()));
            }
            if (metricTemplate.getMetricTypeElement() != null) {
                criteria.add(Restrictions.eq("metricTypeElement", metricTemplate.getMetricTypeElement()));
            }
        }
        metricTemplates = criteria.list();
    } catch (Exception e) {
        log.error("Error " + e.getMessage(), e);
        //"periscopeexception.list.error", new String[]{
        throw new ScopixException("label.metricTemplate");
    }
    log.debug("end");
    return metricTemplates;
}

From source file:com.scopix.periscope.templatemanagement.dao.TemplateManagementHibernateDAOImpl.java

License:Open Source License

@Override
public List<SituationTemplate> getSituationTemplateList(SituationTemplate situationTemplate)
        throws ScopixException {
    log.debug("start");
    List<SituationTemplate> situationTemplates = null;
    try {/*from   w w  w  .j a  va 2s.  c o m*/
        Criteria criteria = this.getSession().createCriteria(SituationTemplate.class);
        criteria.addOrder(Order.asc("name"));
        if (situationTemplate != null) {
            if (situationTemplate.getName() != null && situationTemplate.getName().length() > 0) {
                criteria.add(Restrictions.ilike("name", situationTemplate.getName(), MatchMode.ANYWHERE));
            }
            if (situationTemplate.getActive() != null) {
                criteria.add(Restrictions.eq("active", situationTemplate.getActive()));
            }
        }
        situationTemplates = criteria.list();
    } catch (Exception e) {
        log.error("Error " + e.getMessage(), e);
        //"periscopeexception.list.error", new String[]{
        throw new ScopixException("label.situationTemplate");
    }
    log.debug("end");
    return situationTemplates;
}

From source file:com.scopix.periscope.templatemanagement.dao.TemplateManagementHibernateDAOImpl.java

License:Open Source License

@Override
public List<Product> getProductList(Product product) throws ScopixException {
    log.debug("start");
    List<Product> products = null;
    try {//from  w  w  w  .  j  a  v a2 s .c o m
        Criteria criteria = this.getSession().createCriteria(Product.class);
        criteria.addOrder(Order.asc("id"));
        if (product != null) {
            if (product.getName() != null && product.getName().length() > 0) {
                criteria.add(Restrictions.ilike("name", product.getName(), MatchMode.ANYWHERE));
            }
            if (product.getDescription() != null && product.getDescription().length() > 0) {
                criteria.add(Restrictions.ilike("description", product.getDescription(), MatchMode.ANYWHERE));
            }
        }
        products = criteria.list();
    } catch (Exception e) {
        log.error("Error " + e.getMessage(), e);
        //"periscopeexception.list.error", new String[]{
        throw new ScopixException("label.product");
    }
    log.debug("end");
    return products;
}