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:ca.myewb.controllers.common.Member.java

License:Open Source License

private void searchMode(Context ctx) throws Exception, RedirectionException {
    MemberSearchForm searchForm = null;/* w  ww .ja v a 2 s. c  o  m*/
    List result = null;

    if (currentUser.isAdmin()) {
        result = hibernateSession.createQuery("FROM GroupChapterModel where visible=true").list();
    }

    // run search, store results in temp list
    if (requestParams.get("Advanced") != null) {
        searchForm = new MemberSearchForm(getInterpageVar("membersearchtarget") + "/search", requestParams,
                true, result);
        ctx.put("advanced", new Boolean(true));
    } else {
        searchForm = new MemberSearchForm(getInterpageVar("membersearchtarget") + "/search", requestParams,
                false, result);
    }

    Message m = searchForm.validate();

    if (m != null) // validation failed, redirect to self, next time we'll be entering the next block
    {
        // Display error and prompt user to fix
        throw getValidationException(searchForm, m, (String) getInterpageVar("membersearchtarget"));
    }

    //form validation succeeded!
    String first = searchForm.getParameter("Firstname");
    String last = searchForm.getParameter("Lastname");
    String email = searchForm.getParameter("Email");
    String city = searchForm.getParameter("City", false);
    String province = searchForm.getParameter("Province", false);
    String lang = searchForm.getParameter("Language", false);
    String gender = searchForm.getParameter("Gender", false);
    String birth = searchForm.getParameter("Birth", false);
    String student = searchForm.getParameter("Student", false);
    String username = searchForm.getParameter("Username", false);

    Criteria crit = hibernateSession.createCriteria(UserModel.class);

    if ((username != null) && !username.equals("")) {
        crit.add(Restrictions.like("username", "%" + username.trim() + "%"));
    }

    if ((first != null) && !first.equals("")) {
        crit.add(Restrictions.like("firstname", "%" + first.trim() + "%"));
    }

    if ((last != null) && !last.equals("")) {
        crit.add(Restrictions.like("lastname", "%" + last.trim() + "%"));
    }

    if ((email != null) && !email.equals("")) {
        List ids = HibernateUtil.currentSession()
                .createSQLQuery("SELECT userid FROM useremails e WHERE e.email LIKE '%" + email.trim() + "%'")
                .list();
        if (!ids.isEmpty()) {
            crit.add(Restrictions.in("id", ids));
        } else {
            crit.add(Restrictions.eq("email", "###invalidemail###")); //so that no results are given
        }
    }

    if ((city != null) && !city.equals("")) {
        crit.add(Restrictions.like("address", "%\n%" + city.trim() + "%\n%"));
    }

    if ((province != null) && !province.equals("")) {
        crit.add(Restrictions.like("address", "%\n%" + province.trim() + "%\n%"));
    }

    if ((lang != null) && !lang.equals("")) {
        crit.add(Restrictions.eq("language", lang.trim()));
    }

    if ((gender != null) && !gender.equals("")) {
        crit.add(Restrictions.eq("gender", gender.trim()));
    }

    if ((birth != null) && !birth.equals("")) {
        crit.add(Restrictions.eq("birth", new Integer(birth)));
    }

    if ((student != null) && !student.equals("")) {
        crit.add(Restrictions.eq("student", new Boolean(student)));
    }

    // Get "my" own lead groups, since I can only
    // see people in groups I lead
    crit.createAlias("roles", "r");
    crit.add(Restrictions.isNull("r.end"));

    if (!currentUser.isAdmin()) {
        crit.add(Restrictions.in("r.group", currentUser.getGroups('l')));
    } else {
        GroupChapterModel chapter = null;

        if (searchForm.getParameter("Chapter", false) != null) {
            if (!searchForm.getParameter("Chapter", false).equals("")) {
                chapter = (GroupChapterModel) hibernateSession.get(GroupChapterModel.class,
                        new Integer(searchForm.getParameter("Chapter", false)));
            }
        }

        if (chapter != null) {
            crit.add(Restrictions.eq("r.group", chapter));
            crit.add(Restrictions.eq("r.level", new Character('m')));
        }

        //don't filter out deleted users!
    }

    crit.add(Restrictions.ne("id", new Integer(1)));

    crit.addOrder(Order.asc("lastname"));
    crit.addOrder(Order.asc("firstname"));
    crit.setProjection(Projections.groupProperty("id"));
    crit.setMaxResults(101);

    List uniqueResultsList = crit.list();
    Vector<UserModel> uniqueResults = new Vector<UserModel>();

    if (uniqueResultsList.size() < 101) {
        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());
            }
        }
    } else {
        ctx.put("tooMany", "yes");
    }

    setInterpageVar("membersearchtempresults", uniqueResultsList);
    ctx.put("tempresults", uniqueResults); //NOT the ids, but the users
    ctx.put("searchmode", "yes");
    if (searchForm == null) {
        log.info("search form was null!");
        throw new RedirectionException(getInterpageVar("membersearchtarget") + "/new");
    }

    ctx.put("form", searchForm);
    ctx.put("target", getInterpageVar("membersearchtarget"));
}

---

From source file:ca.myewb.controllers.common.WhiteboardList.java

License:Open Source License

public List<WhiteboardModel> listPaginatedVisibleWhiteboards(int startPage, int eventsPerPage)
        throws HibernateException {
    Criteria criteria = hibernateSession.createCriteria(WhiteboardModel.class);

    if (!currentUser.isAdmin() || !currentUser.getAdminToggle()) {
        criteria.add(Restrictions.in("group", Permissions.visibleGroups(currentUser, true)));
    }/*from   w  w w  .  j  a  v  a 2 s. c om*/
    criteria.add(Restrictions.ne("numEdits", 0));
    criteria.add(Restrictions.gt("lastEditDate", currentUser.getLastLogin()));
    criteria.addOrder(Order.desc("lastEditDate"));
    criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

    addPagination(startPage, eventsPerPage, criteria);

    return getUniqueWhiteboardList(criteria);
}

---

From source file:ca.myewb.controllers.common.WhiteboardList.java

License:Open Source License

public int visibleWhiteboardCount() throws HibernateException {
    Criteria criteria = hibernateSession.createCriteria(WhiteboardModel.class);

    if (!currentUser.isAdmin() || !currentUser.getAdminToggle()) {
        criteria.add(Restrictions.in("group", Permissions.visibleGroups(currentUser, true)));
    }//www .  ja v a2  s  .  com
    criteria.add(Restrictions.ne("numEdits", 0));
    criteria.add(Restrictions.gt("lastEditDate", currentUser.getLastLogin()));

    criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

    return getUniqueWhiteboardCount(criteria);
}

---

From source file:ch.astina.hesperid.dao.hibernate.FailureDAOHibernate.java

License:Apache License

@SuppressWarnings("unchecked")
@Override//from   ww  w.  ja  v  a  2  s.  c o  m
public List<Failure> getUnresolvedFailures() {
    return session.createCriteria(Failure.class).add(Restrictions.ne("failureStatus", FailureStatus.RESOLVED))
            .addOrder(Order.asc("detected")).list();
}

---

From source file:ch.astina.hesperid.dao.hibernate.FailureDAOHibernate.java

License:Apache License

@SuppressWarnings("unchecked")
@Override/*from w w w .j  a va  2 s.  c  o m*/
public List<Failure> getUnresolvedFailures(Asset asset) {
    return session.createCriteria(Failure.class).add(Restrictions.ne("failureStatus", FailureStatus.RESOLVED))
            .add(Restrictions.eq("asset", asset)).addOrder(Order.asc("detected")).list();
}

---

From source file:ch.astina.hesperid.dao.hibernate.FailureDAOHibernate.java

License:Apache License

@SuppressWarnings("unchecked")
@Override/*  w  w w .  j a va 2 s.  c om*/
public List<Failure> getUnresolvedFailures(Observer observer) {
    return session.createCriteria(Failure.class).add(Restrictions.ne("failureStatus", FailureStatus.RESOLVED))
            .add(Restrictions.eq("observer", observer)).addOrder(Order.asc("detected")).list();
}

---

From source file:ch.astina.hesperid.dao.hibernate.FailureDAOHibernate.java

License:Apache License

@Override
public Failure getFailureByExample(Failure failure) {
    Failure persistent = (Failure) session.createCriteria(Failure.class)
            .add(Restrictions.eq("asset", failure.getAsset()))
            .add(Restrictions.eq("observer", failure.getObserver()))
            .add(Restrictions.ne("failureStatus", FailureStatus.RESOLVED))
            .add(Restrictions.eq("message", failure.getMessage())).uniqueResult();

    return persistent;
}

---

From source file:ch.astina.hesperid.web.components.FailureList.java

License:Apache License

public FilterGridDataSource getFailures() {
    FilterGridDataSource dataSource = failureDAO.getFailureFilterGridDataSource();

    if (observer != null) {
        dataSource.addFilter(Restrictions.eq("observer", observer));
    }/*from  www .j a  v  a2  s  .c  om*/
    if (filterUnresolved == true) {
        dataSource.addFilter(Restrictions.ne("failureStatus", FailureStatus.RESOLVED));
    }
    if (filterMine == true) {
        User user = userService.getCurrentUser();
        if (user != null) {
            dataSource.addAlias("escalationLevel");
            dataSource.addFilter(Restrictions.eq("escalationLevel.username", user.getUsername()));
        }
    }

    return dataSource;
}

---

From source file:cn.lhfei.airqa.dao.impl.CompanyDao.java

License:Apache License

@Override
public PageModel findCompany(int page, int rows) {
    PageModel pageModel = new PageModel();

    Criteria criteria = getCriteria();//w ww . j  ava2  s. c  om
    criteria.add(Restrictions.ne("dataStatus", Constants.STATUS_DELETE));

    // ???
    int total = criteria.list().size();
    pageModel.setTotal(total);

    criteria.setFirstResult((page - 1) * rows).setMaxResults(rows);
    pageModel.setRows(criteria.list());

    return pageModel;
}

---

From source file:co.com.codesoftware.logic.productos.FacturaCompraLogic.java

/**
 * funcion que consulta las facturas por vencer
 *
 * @return//from w w w  .jav  a2s  . co m
 */
public List<FacturaCompraEntity> consultaFacturaCompraXVencer() {
    List<FacturaCompraEntity> facturas = new ArrayList<>();
    try {
        ParametrosEmpresaLogic logic = new ParametrosEmpresaLogic();
        ParametrosEntity param = logic.consultaDiasParametrizadosEnvioCorreo();
        Date fechaFinal = new Date();
        fechaFinal.setHours(23);
        fechaFinal.setMinutes(59);
        fechaFinal.setSeconds(59);
        Calendar calendar = Calendar.getInstance();
        calendar.setTime(fechaFinal);
        calendar.add(Calendar.DAY_OF_YEAR, Integer.parseInt(param.getValor()) * -1);
        Date fechaInicial = calendar.getTime();
        initOperation();
        facturas = sesion.createCriteria(FacturaCompraEntity.class)
                .add(Restrictions.between("fechaFacCompra", fechaInicial, fechaFinal))
                .add(Restrictions.ne("estado", "P")).list();

    } catch (Exception e) {
        e.printStackTrace();
    }
    return facturas;

}

---

• «
• 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
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »