Example usage for org.hibernate.criterion Restrictions ne

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

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. ne

Introduction

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

Prototype

public static SimpleExpression ne(String propertyName, Object value)

Source Link

Document

Apply a "not equal" constraint to the named property

Usage

From source file:com.inkubator.hrm.dao.impl.WtOverTimeDaoImpl.java

@Override
public Long getTotalDuplicaByCodeAndNotId(String code, Long id) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("code", code));
    criteria.add(Restrictions.ne("id", id));
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

From source file:com.inkubator.sms.gateway.dao.impl.ModemDefinitionDaoImpl.java

@Override
public long getTotalByModemIdAndNotId(String modemId, Long id) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.like("modemId", modemId, MatchMode.ANYWHERE));
    criteria.add(Restrictions.ne("id", id));
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

From source file:com.isotrol.impe3.web20.dao.impl.DAOImpl.java

License:Open Source License

/**
 * Create a new criteria for member memberships.
 * @param filter Member memberships filter.
 * @return The created criteria./*from   w w  w  .ja  va  2s.  co  m*/
 */
private Criteria getMemberMembershipCriteria(PageFilter<MembershipSelFilterDTO> filter) {
    Criteria c = newCriteria(MembershipEntity.class);
    c.add(Restrictions.eq("member.id", filter.getFilter().getId()));
    if (filter.getFilter().getRole() != null) {
        c.add(Restrictions.eq("role", filter.getFilter().getRole()));
    }

    c.createAlias("community", "c", Criteria.LEFT_JOIN);
    c.add(Restrictions.eq("c.deleted", false));
    if (!filter.getFilter().isGlobal()) {
        c.add(Restrictions.ne("c.id", CommunityManager.GLOBAL_ID));
    }
    c.add(Restrictions.isNull("deletion"));
    if (filter.getFilter().isValidated() == null) {
        // nothing here.
    } else if (filter.getFilter().isValidated().equals(Boolean.FALSE)) {
        c.add(Restrictions.isNull("validation"));
    } else {
        c.add(Restrictions.isNotNull("validation"));
    }
    return c;
}

From source file:com.isotrol.impe3.web20.dao.impl.DAOImpl.java

License:Open Source License

/**
 * Create a new criteria for communities.
 * @param filter Community filter./*from  ww w . j  av a  2 s.  c  o  m*/
 * @return The created criteria.
 */
private Criteria getCommunityCriteria(PageFilter<CommunityFilterDTO> filter) {
    Criteria c = newCriteria(CommunityEntity.class);
    c.add(Restrictions.ne("id", CommunityManager.GLOBAL_STR_ID));
    c.add(Restrictions.eq("deleted", Boolean.FALSE));

    if (filter.getFilter().getName() != null && filter.getFilter().getDescription() != null) {
        c.add(Restrictions.or(FilterSupport.criterion("name", filter.getFilter().getName()),
                FilterSupport.criterion("description", filter.getFilter().getDescription())));
    } else if (filter.getFilter().getName() != null || filter.getFilter().getDescription() != null) {
        FilterSupport.add(c, "name", filter.getFilter().getName());
        FilterSupport.add(c, "description", filter.getFilter().getDescription());
    }
    return c;
}

From source file:com.it250.projekat.dao.UserDaoImpl.java

@Override
public boolean checkEmail(String email, int id) {
    long count = (Long) session.createCriteria(User.class).add(Restrictions.eq("email", email))
            .add(Restrictions.ne("id", id)).setProjection(Projections.rowCount()).uniqueResult();
    System.out.println("checkEmail " + count);
    return count == 0;
}

From source file:com.it250.projekat.dao.UserDaoImpl.java

@Override
public boolean checkUsername(String username, int id) {
    long count = (Long) session.createCriteria(User.class).add(Restrictions.eq("username", username))
            .add(Restrictions.ne("id", id)).setProjection(Projections.rowCount()).uniqueResult();

    System.out.println("checkUsername " + count);
    return count == 0;
}

From source file:com.itrus.ca.modules.cms.service.ArticleService.java

License:Open Source License

public Page<Article> find(Page<Article> page, Article article, boolean isDataScopeFilter) {
    // ??6??//from ww  w .  ja v  a  2  s.com
    Date updateExpiredWeightDate = (Date) CacheUtils.get("updateExpiredWeightDateByArticle");
    if (updateExpiredWeightDate == null
            || (updateExpiredWeightDate != null && updateExpiredWeightDate.getTime() < new Date().getTime())) {
        articleDao.updateExpiredWeight();
        CacheUtils.put("updateExpiredWeightDateByArticle", DateUtils.addHours(new Date(), 6));
    }
    DetachedCriteria dc = articleDao.createDetachedCriteria();
    dc.createAlias("category", "category");
    dc.createAlias("category.site", "category.site");
    if (article.getCategory() != null && article.getCategory().getId() != null
            && !Category.isRoot(article.getCategory().getId())) {
        Category category = categoryDao.findOne(article.getCategory().getId());
        if (category != null) {
            dc.add(Restrictions.or(Restrictions.eq("category.id", category.getId()),
                    Restrictions.like("category.parentIds", "%," + category.getId() + ",%")));
            dc.add(Restrictions.eq("category.site.id", category.getSite().getId()));
            article.setCategory(category);
        } else {
            dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
        }
    } else {
        dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
    }
    if (StringUtils.isNotEmpty(article.getTitle())) {
        dc.add(Restrictions.like("title", "%" + EscapeUtil.escapeLike(article.getTitle()) + "%"));
    }
    if (StringUtils.isNotEmpty(article.getPosid())) {
        dc.add(Restrictions.like("posid", "%," + article.getPosid() + ",%"));
    }
    if (StringUtils.isNotEmpty(article.getImage()) && Article.YES.equals(article.getImage())) {
        dc.add(Restrictions.and(Restrictions.isNotNull("image"), Restrictions.ne("image", "")));
    }
    if (article.getCreateBy() != null && article.getCreateBy().getId() > 0) {
        dc.add(Restrictions.eq("createBy.id", article.getCreateBy().getId()));
    }
    if (isDataScopeFilter) {
        dc.createAlias("category.office", "categoryOffice").createAlias("createBy", "createBy");
        dc.add(dataScopeFilter(UserUtils.getUser(), "categoryOffice", "createBy"));
    }
    dc.add(Restrictions.eq(Article.DEL_FLAG, article.getDelFlag()));
    if (StringUtils.isBlank(page.getOrderBy())) {
        dc.addOrder(Order.desc("weight"));
        dc.addOrder(Order.desc("updateDate"));
    }
    return articleDao.find(page, dc);
}

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

License:Open Source License

/**
 *  ??/*  www .  ja  v a 2  s. c om*/
* @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

/**
 * ?//from   w  w  w .j a v a2s.c o m
 * ?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

/**
 * /*ww  w .j  av  a 2  s.  c  om*/
 * @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);
}