Example usage for org.hibernate.criterion Restrictions 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:br.com.hslife.orcamento.repository.ContaRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Conta> findByDescricaoAndUsuario(String descricao, Usuario usuario) {
    Criteria criteria = getSession().createCriteria(Conta.class);
    criteria.add(Restrictions.ilike("descricao", descricao, MatchMode.ANYWHERE));
    if (!usuario.getLogin().equals("admin")) {
        criteria.add(Restrictions.eq("usuario.id", usuario.getId()));
    }// w w  w.  ja v a 2  s . com
    criteria.add(Restrictions.ne("tipoConta", TipoConta.CARTAO));
    return criteria.addOrder(Order.asc("descricao")).list();
}

From source file:br.com.hslife.orcamento.repository.ContaRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Conta> findByBancoAndUsuario(Banco banco, Usuario usuario) {
    Criteria criteria = getSession().createCriteria(Conta.class);
    criteria.add(Restrictions.eq("banco.id", banco.getId()));
    criteria.add(Restrictions.eq("usuario.id", usuario.getId()));
    criteria.add(Restrictions.ne("tipoConta", TipoConta.CARTAO));
    return criteria.addOrder(Order.asc("descricao")).list();
}

From source file:br.com.hslife.orcamento.repository.ContaRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Conta> findByTipoContaAndUsuario(TipoConta tipoConta, Usuario usuario) {
    Criteria criteria = getSession().createCriteria(Conta.class);
    criteria.add(Restrictions.eq("tipoConta", tipoConta));
    criteria.add(Restrictions.eq("usuario.id", usuario.getId()));
    criteria.add(Restrictions.ne("tipoConta", TipoConta.CARTAO));
    return criteria.addOrder(Order.asc("descricao")).list();
}

From source file:br.com.hslife.orcamento.repository.ContaRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Conta> findEnabledByUsuario(Usuario usuario) {
    Criteria criteria = getSession().createCriteria(Conta.class);
    criteria.add(Restrictions.eq("ativo", true));
    criteria.add(Restrictions.eq("usuario.id", usuario.getId()));
    criteria.add(Restrictions.ne("tipoConta", TipoConta.CARTAO));
    return criteria.addOrder(Order.asc("descricao")).list();
}

From source file:br.com.hslife.orcamento.repository.LancamentoContaRepository.java

License:Open Source License

public LancamentoConta findLastLancamentoContaByConta(Conta conta) {
    Criteria criteria = getSession().createCriteria(LancamentoConta.class);
    criteria.add(Restrictions.ne("statusLancamentoConta", StatusLancamentoConta.QUITADO));
    criteria.add(Restrictions.eq("conta.id", conta.getId()));
    return (LancamentoConta) criteria.addOrder(Order.desc("dataPagamento")).setMaxResults(1).uniqueResult();
}

From source file:br.com.muranodesign.dao.impl.CalendarioEventosDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<CalendarioEventos> listarNotMural() {
    Criteria criteria = getSession().createCriteria(CalendarioEventos.class);
    criteria.createAlias("tipoEvento", "tipoEvento");
    criteria.add(Restrictions.ne("tipoEvento.tipoEvento", "mural"));
    List<CalendarioEventos> result = criteria.list();
    return result;

}

From source file:br.com.webbudget.domain.repository.user.UserRepository.java

License:Open Source License

/**
 * /*from ww  w .ja v  a  2 s .  co m*/
 * @param blocked
 * @param authenticated
 * @return 
 */
@Override
public List<User> listByStatusAndRemoveAuthenticated(Boolean blocked, User authenticated) {

    final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass());

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

    criteria.add(Restrictions.ne("id", authenticated.getId()));

    return criteria.list();
}

From source file:ca.myewb.controllers.chapter.FindDupes.java

License:Open Source License

private void findEmailMatch(Context ctx, String toMatch, String key) {
    int maxSize = 11;
    String query = "SELECT userid FROM useremails e WHERE e.email LIKE '%" + toMatch + "%'";
    List ids = HibernateUtil.currentSession().createSQLQuery(query).list();
    if (ids.isEmpty()) {
        ctx.put(key, new Vector());
        return;/*from w  w w. j a va  2s. c o  m*/
    }

    Criteria crit = hibernateSession.createCriteria(UserModel.class);
    List uniqueResultsList = crit.add(Restrictions.in("id", ids)).add(Restrictions.ne("id", new Integer(1)))
            .setProjection(Projections.groupProperty("id")).setMaxResults(maxSize).list();

    Vector<UserModel> uniqueResults = new Vector<UserModel>();

    if (uniqueResultsList.size() < maxSize) {
        Iterator iter = uniqueResultsList.iterator();

        while (iter.hasNext()) {
            Integer i = (Integer) iter.next();

            // This try/catch block is a workaround to the deleted-admin-causes-cgilib-blowup bug
            try {
                uniqueResults.add((UserModel) hibernateSession.get(UserModel.class, i));
            } catch (Exception e) {
                log.warn("Unable to add user to usersearch: id " + i.toString());
            }
        }
        ctx.put(key, uniqueResults);
    }
}

From source file:ca.myewb.controllers.chapter.FindDupes.java

License:Open Source License

private void findNameMatch(Context ctx, UserModel targetUser, String key) {
    int maxSize = 11;

    Criteria crit = hibernateSession.createCriteria(UserModel.class);
    List uniqueResultsList = crit.add(Restrictions.eq("firstname", targetUser.getFirstname()))
            .add(Restrictions.eq("lastname", targetUser.getLastname()))
            .add(Restrictions.ne("id", new Integer(1))).setProjection(Projections.groupProperty("id"))
            .setMaxResults(maxSize).list();

    Vector<UserModel> uniqueResults = new Vector<UserModel>();

    if (uniqueResultsList.size() < maxSize) {
        Iterator iter = uniqueResultsList.iterator();

        while (iter.hasNext()) {
            Integer i = (Integer) iter.next();

            // This try/catch block is a workaround to the deleted-admin-causes-cgilib-blowup bug
            try {
                uniqueResults.add((UserModel) hibernateSession.get(UserModel.class, i));
            } catch (Exception e) {
                log.warn("Unable to add user to usersearch: id " + i.toString());
            }/* ww w  .  j  a v a  2  s .c o m*/
        }
        ctx.put(key, uniqueResults);
    }
}

From source file:ca.myewb.controllers.chapter.FindDupes.java

License:Open Source License

private void findUsernameMatch(Context ctx, UserModel targetUser, String key) {
    int maxSize = 11;

    Criteria crit = hibernateSession.createCriteria(UserModel.class);
    List uniqueResultsList = crit
            .add(Restrictions.like("username", "%" + targetUser.getEmail().split("@")[0] + "%"))
            .add(Restrictions.ne("id", new Integer(1))).setProjection(Projections.groupProperty("id"))
            .setMaxResults(maxSize).list();

    Vector<UserModel> uniqueResults = new Vector<UserModel>();

    if (uniqueResultsList.size() < maxSize) {
        Iterator iter = uniqueResultsList.iterator();

        while (iter.hasNext()) {
            Integer i = (Integer) iter.next();

            // This try/catch block is a workaround to the deleted-admin-causes-cgilib-blowup bug
            try {
                uniqueResults.add((UserModel) hibernateSession.get(UserModel.class, i));
            } catch (Exception e) {
                log.warn("Unable to add user to usersearch: id " + i.toString());
            }/*  w  w  w.j  a  v a  2  s .c o m*/
        }
        ctx.put(key, uniqueResults);
    }
}