Example usage for org.hibernate.criterion Restrictions like

Introduction

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

Prototype

public static SimpleExpression like(String propertyName, Object value) 

Source Link

Document

Apply a "like" constraint to the named property

Usage

From source file:com.itrus.ca.modules.sys.service.LogService.java

License:Open Source License

public Page<Log> find(Page<Log> page, Map<String, Object> paramMap) {
    DetachedCriteria dc = logDao.createDetachedCriteria();

    Long createById = StringUtils.toLong(paramMap.get("createById"));
    if (createById > 0) {
        dc.add(Restrictions.eq("createBy.id", createById));
    }//w  ww  .j a v  a 2s  .  c o m

    String requestUri = ObjectUtils.toString(paramMap.get("requestUri"));
    if (StringUtils.isNotBlank(requestUri)) {
        dc.add(Restrictions.like("requestUri", "%" + EscapeUtil.escapeLike(requestUri) + "%"));
    }

    String exception = ObjectUtils.toString(paramMap.get("exception"));
    if (StringUtils.isNotBlank(exception)) {
        dc.add(Restrictions.eq("type", Log.TYPE_EXCEPTION));
    }

    Date beginDate = DateUtils.parseDate(paramMap.get("beginDate"));
    if (beginDate == null) {
        beginDate = DateUtils.setDays(new Date(), 1);
        paramMap.put("beginDate", DateUtils.formatDate(beginDate, "yyyy-MM-dd"));
    }
    Date endDate = DateUtils.parseDate(paramMap.get("endDate"));
    if (endDate == null) {
        endDate = DateUtils.addDays(DateUtils.addMonths(beginDate, 1), -1);
        paramMap.put("endDate", DateUtils.formatDate(endDate, "yyyy-MM-dd"));
    }
    dc.add(Restrictions.between("createDate", beginDate, endDate));

    dc.addOrder(Order.desc("id"));
    return logDao.find(page, dc);
}

---

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

/**
 *  ??//from   w  w  w  .  j av  a2  s.  c o m
* @Title: find
* @Description: TODO(????)
* @param @param page
* @param @param office
* @param @return    
* @return Page<Office>    
* @throws
 */
public Page<Office> find(Page<Office> page, Office office) {
    User user = UserUtils.getUser();
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(office.getName())) {
        dc.add(Restrictions.like("name", "%" + EscapeUtil.escapeLike(office.getName()) + "%"));
    }

    dc.add(Restrictions.eq("delFlag", DataEntity.DEL_FLAG_NORMAL));
    Office off = new Office();
    off.setId(1L);
    dc.add(Restrictions.eq("parent", off));
    //dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.ne("id", 34L));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(page, dc);
}

---

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

/**
 * ?/*  w ww .  jav a2  s . c  om*/
 * ?del
* @Title: findByDel
* @Description: TODO(????)
* @param @param page
* @param @param office
* @param @return    
* @return Page<Office>    
* @throws
 */
public Page<Office> findByDel(Page<Office> page, Office office) {
    User user = UserUtils.getUser();
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(office.getName())) {
        dc.add(Restrictions.like("name", "%" + EscapeUtil.escapeLike(office.getName()) + "%"));
    }
    Office off = new Office();
    off.setId(1L);
    dc.add(Restrictions.ne("parent", off));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.ne("id", 34L));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(page, dc);
}

---

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

/**
 * /*from w ww  .  j  av  a 2  s . c  o m*/
 * @param office
 * @return
 */
public List<Office> findAllByDel(Office office) {
    User user = UserUtils.getUser();
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(office.getName())) {
        dc.add(Restrictions.like("name", "%" + EscapeUtil.escapeLike(office.getName()) + "%"));
    }
    Office off = new Office();
    off.setId(1L);
    dc.add(Restrictions.ne("parent", off));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.ne("id", 34L));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}

---

From source file:com.itrus.ca.modules.sys.service.SystemService.java

License:Open Source License

public Page<User> findUser(Page<User> page, User user) {
    DetachedCriteria dc = userDao.createDetachedCriteria();
    User currentUser = UserUtils.getUser();
    dc.createAlias("company", "company");
    if (user.getCompany() != null && user.getCompany().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("company.id", user.getCompany().getId()),
                Restrictions.like("company.parentIds", "%," + user.getCompany().getId() + ",%")));
    }//from   w w  w  .j a  v  a  2  s  . c o m
    dc.createAlias("office", "office");
    if (user.getOffice() != null && user.getOffice().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("office.id", user.getOffice().getId()),
                Restrictions.like("office.parentIds", "%," + user.getOffice().getId() + ",%")));
    }
    // ????
    if (!currentUser.isAdmin()) {
        dc.add(Restrictions.ne("id", 1L));
    }
    dc.add(dataScopeFilter(currentUser, "office", ""));
    //System.out.println(dataScopeFilterString(currentUser, "office", ""));
    if (StringUtils.isNotEmpty(user.getLoginName())) {
        dc.add(Restrictions.like("loginName", "%" + EscapeUtil.escapeLike(user.getLoginName()) + "%"));
    }
    if (StringUtils.isNotEmpty(user.getName())) {
        dc.add(Restrictions.like("name", "%" + EscapeUtil.escapeLike(user.getName()) + "%"));
    }
    dc.add(Restrictions.eq(User.DEL_FLAG, User.DEL_FLAG_NORMAL));
    //      if (!StringUtils.isNotEmpty(page.getOrderBy())){
    //         dc.addOrder(Order.asc("company.code")).addOrder(Order.asc("office.code")).addOrder(Order.desc("id"));
    //      }
    return userDao.find(page, dc);
}

---

From source file:com.ivanbiz.dao.impl.PembayaranDAOImpl.java

@Override
public List getDataByLike(Class clasImpl, String variable, Object input) throws Exception {
    List list = null;//from w ww. j a  va2 s . c  om
    try {
        Session session = HibernateUtil.getSession();
        HibernateUtil.beginTransaction();
        Criteria crit = session.createCriteria(clasImpl);
        crit.add(Restrictions.like(variable, "%" + input + "%"));
        crit.add(Restrictions.eq("status", "1"));
        list = crit.list();
        HibernateUtil.commitTransaction();
    } catch (Exception e) {
        HibernateUtil.rollbackTransaction();
        throw e;
    } finally {
        HibernateUtil.closeSession();
    }
    return list;
}

---

From source file:com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateFilter.java

License:Open Source License

public void applyPropertyFilter(PropertyFilter filter) {
    Criterion propCriterion;// w  ww . j  a  v  a 2s.c  om
    switch (filter.getOp()) {
    case PropertyFilter.EQ:
        propCriterion = Restrictions.eq(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.LIKE:
        propCriterion = Restrictions.like(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.GT:
        propCriterion = Restrictions.gt(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.LT:
        propCriterion = Restrictions.lt(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.BETWEEN:
        propCriterion = Restrictions.between(filter.getProperty(), filter.getLowValue(), filter.getHighValue());
        break;
    case PropertyFilter.IN:
        propCriterion = Restrictions.in(filter.getProperty(), filter.getValues());
        break;
    default:
        throw new JSException("jsexception.hibernate.unknown.property.filter.operation",
                new Object[] { new Byte(filter.getOp()) });
    }
    add(propCriterion);
}

---

From source file:com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateFilter.java

License:Open Source License

protected Criterion ancestorFolderRestriction(String folderURI) {
    if (Folder.SEPARATOR.equals(folderURI)) {
        return null;
    }// w w  w.j a  v a 2 s.co m

    return Restrictions.or(
            folderURI.indexOf("%") == -1 ? Restrictions.eq("parent.URI", folderURI)
                    : Restrictions.like("parent.URI", folderURI),
            Restrictions.like("parent.URI", folderURI + "/%"));
}

---

From source file:com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public int getFoldersCount(final String parentURI) {
    return (Integer) executeCallback(new DaoCallback() {
        public Object execute() {
            DetachedCriteria criteria = DetachedCriteria.forClass(RepoFolder.class);
            criteria.add(Restrictions.eq("hidden", Boolean.FALSE));
            criteria.setProjection(Projections.rowCount());
            if (parentURI != null && !Folder.SEPARATOR.equals(parentURI)) {
                criteria.add(Restrictions.or(
                        (parentURI.contains("%")) ? Restrictions.eq("URI", parentURI)
                                : Restrictions.like("URI", parentURI),
                        Restrictions.like("URI", parentURI + "/%")));
            }//from   w w  w  .  j av a  2  s .c o m
            return new BasicTransformer().transformToCount(getHibernateTemplate().findByCriteria(criteria));
        }
    });
}

---

From source file:com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.java

License:Open Source License

protected List loadAllSubfolders(ExecutionContext context, String parentURI) {
    DetachedCriteria criteria = DetachedCriteria.forClass(RepoFolder.class);
    criteria.add(Restrictions.eq("hidden", Boolean.FALSE));

    if (parentURI != null && !Folder.SEPARATOR.equals(parentURI)) {
        criteria.add(Restrictions.or((parentURI.indexOf("%") == -1) ? Restrictions.eq("URI", parentURI)
                : Restrictions.like("URI", parentURI), Restrictions.like("URI", parentURI + "/%")));
    }/*from ww w.  java2  s . com*/

    criteria.getExecutableCriteria(getSession()).setCacheable(true);
    List repoFolders = getHibernateTemplate().findByCriteria(criteria);
    List folders = new ArrayList(repoFolders.size());
    for (Iterator iter = repoFolders.iterator(); iter.hasNext();) {
        RepoFolder repoFolder = (RepoFolder) iter.next();
        Folder folder = repoFolder.toClient();
        folders.add(folder);
    }

    SortingUtils.sortFoldersByURI(getCollator(context), folders);

    return folders;
}

---

• «
• 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
• »