Example usage for org.hibernate.criterion Restrictions ge

Introduction

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

Prototype

public static SimpleExpression ge(String propertyName, Object value) 

Source Link

Document

Apply a "greater than or equal" constraint to the named property

Usage

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

License:Open Source License

public Collection<EventModel> listVisibleEventsBetweenDates(Date start, Date end, GroupChapterModel chapter)
        throws HibernateException {
    Criteria criteria = hibernateSession.createCriteria(EventModel.class);

    LogicalExpression singleDayEvents = Restrictions.and(Restrictions.ge("startDate", start),
            Restrictions.le("endDate", end));
    LogicalExpression endsToday = Restrictions.and(Restrictions.lt("startDate", start),
            Restrictions.and(Restrictions.ge("endDate", start), Restrictions.le("endDate", end)));
    LogicalExpression startsToday = Restrictions.and(
            Restrictions.and(Restrictions.ge("startDate", start), Restrictions.le("startDate", end)),
            Restrictions.gt("endDate", end));
    LogicalExpression ongoing = Restrictions.and(Restrictions.lt("startDate", start),
            Restrictions.gt("endDate", end));

    criteria.add(Restrictions.or(singleDayEvents,
            Restrictions.or(endsToday, Restrictions.or(startsToday, ongoing))));

    if (chapter == null) {
        if (!currentUser.isAdmin()) {
            criteria.add(Restrictions.in("group", Permissions.visibleGroups(currentUser, true)));
        } else {// w w  w.ja  v  a2  s .  c o m
            List<GroupModel> adminGroups = Helpers.getNationalRepLists(true, true);
            adminGroups.add(Helpers.getGroup("Exec"));
            adminGroups.add(Helpers.getGroup("ProChaptersExec"));

            criteria.add(Restrictions.in("group", adminGroups));
        }
    } else {
        criteria.add(Restrictions.in("group", Permissions.visibleGroupsInChapter(currentUser, chapter)));
    }

    criteria.addOrder(Order.asc("startDate"));
    criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

    return new SafeHibList<EventModel>(criteria).list();
}

---

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

License:Open Source License

private void addBooleanFilters(Date endAfter, Criteria criteria) {
    if (endAfter != null) {
        log.info("Events that ended after endDate set");
        criteria.add(Restrictions.ge("endDate", endAfter));
    }/*from w  ww. j  a va 2s. co  m*/
}

---

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

License:Apache License

@SuppressWarnings("unchecked")
@Override/*w ww.java2  s  .com*/
public List<ObserverParameter> getObserverParameters(Observer observer, Date since) {
    return session.createCriteria(ObserverParameter.class).add(Restrictions.eq("observer", observer))
            .add(Restrictions.ge("updated", since)).addOrder(Order.asc("updated")).list();
}

---

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

License:Apache License

@SuppressWarnings("unchecked")
@Override// w  w  w  . java  2 s  .  c o m
public List<ObserverParameter> getObserverParameters(Observer observer, Date from, Date until) {
    return session.createCriteria(ObserverParameter.class).add(Restrictions.eq("observer", observer))
            .add(Restrictions.ge("updated", from)).add(Restrictions.le("updated", until))
            .addOrder(Order.asc("updated")).list();
}

---

From source file:ch.systemsx.cisd.openbis.generic.server.dataaccess.db.search.DefaultFullTextIndexer.java

License:Apache License

private <T> Criteria createCriteriaWithRestrictedId(final FullTextSession fullTextSession, final Class<T> clazz,
        final long minId, final long maxId) {
    return createCriteria(fullTextSession, clazz).add(Restrictions.ge(ID_PROPERTY_NAME, minId))
            .add(Restrictions.lt(ID_PROPERTY_NAME, maxId));
}

---

From source file:cms.pageList.entity.ArchiverLabel.java

License:Apache License

public String getIterativeString(TagLabel tagLabel, List<PropertyFilter> filters) {

    String strTag = tagLabel.getTagName();// ??

    if (tagLabel == null)
        return strTag;

    // ????ID/*from w w  w.  j a  v a2 s .  c o m*/
    List<Arctype> arctypeList = atm.getArctypeManager().getAdviceList(new Long(tagLabel.getTypeid()));
    String typeidStr = tagLabel.getTypeid() + "";
    for (Arctype arctypeTest : arctypeList) {
        typeidStr += "," + arctypeTest.getId();
    }

    // 

    // ??
    if ((!tagLabel.getOrderby().trim().equalsIgnoreCase(""))
            && (!tagLabel.getOrderbyType().trim().equalsIgnoreCase(""))) {

        String arcattStr = null;// 
        for (Long flagid : tagLabel.getflagIds()) {
            arcattStr += "," + flagid;
        }

        // 
        if (arcattStr != null) {
            // ?0,?
            if (tagLabel.getTypeid() == 0) {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.ge("arcrank", 0),
                        Restrictions.sqlRestriction(
                                "archives_id in  ( select archives_id from archives_arcatt where arcatt_id in("
                                        + arcattStr + ") )"));
            } else {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.sqlRestriction("typeid in (" + typeidStr + ")"),
                        Restrictions.ge("arcrank", 0),
                        Restrictions.sqlRestriction(
                                "archives_id in  ( select archives_id from archives_arcatt where arcatt_id in("
                                        + arcattStr + ") )"));
            }
        } else { // 

            // ?0,?
            if (tagLabel.getTypeid() == 0) {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.ge("arcrank", 0));
            } else {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.ge("arcrank", 0),
                        Restrictions.sqlRestriction("typeid in (" + typeidStr + ")"));
            }

        }

    } else { // ?
        // ?0,?

        if (tagLabel.getTypeid() == 0) {
            addArchivesList(tagLabel.getRow(), 1, "senddate", "desc", Restrictions.ge("arcrank", 0),
                    Restrictions.sqlRestriction("typeid in (" + typeidStr + ")"));
        } else {
            addArchivesList(tagLabel.getRow(), 1, "senddate", "desc", Restrictions.ge("arcrank", 0));
        }

    }

    /*strTag = "<s:iterator value=\"pagecontent.listLabel.get("
    + pfValue("getNum", filters)
    + ").getPage().getResult()\" status=\"st\">"
    + tagLabel.getBody() + "</s:iterator>";*/
    strTag = "<#list pagecontent.listLabel.get(" + pfValue("getNum", filters)
            + ").getPage().getResult() as xx >" + tagLabel.getBody() + "</#list>";

    return strTag;
}

---

From source file:cms.pageList.entity.GeneralArcPageLabel.java

License:Apache License

public String getIterativeString(TagLabel tagLabel, List<PropertyFilter> filters) {

    String strTag = tagLabel.getTagName();

    // System.out.println("3:"+pageNo);

    //???   /*w  w w  . j  a  v a 2  s. c  om*/
    String typeidStr = pfValue("typeId", filters);//??ID
    typeidStr += arctypeidStr(new Long(Integer.parseInt(pfValue("typeId", filters))));//???ID

    // ??
    if ((!tagLabel.getOrderby().trim().equalsIgnoreCase(""))
            && (!tagLabel.getOrderbyType().trim().equalsIgnoreCase(""))) {

        addArchivesList(tagLabel.getRow(), Integer.parseInt(pfValue("pageNo", filters)), tagLabel.getOrderby(),
                tagLabel.getOrderbyType(), Restrictions.ge("arcrank", 0),
                Restrictions.sqlRestriction("typeid in (" + typeidStr + ")"));

    } else {// ?
        System.out.println("B:" + typeidStr);
        addArchivesList(tagLabel.getRow(), Integer.parseInt(pfValue("pageNo", filters)), "senddate", "desc",
                Restrictions.ge("arcrank", 0), Restrictions.sqlRestriction("typeid in (" + typeidStr + ")"));
    }

    // ??

    /*strTag = "<s:iterator value=\"pagecontent.listLabel.get("
    + pfValue("getNum", filters)
    + ").getPage().getResult()\" status=\"st\">"
    + tagLabel.getBody() + "</s:iterator>";*/
    strTag = "<#list pagecontent.listLabel.get(" + pfValue("getNum", filters)
            + ").getPage().getResult() as xx >" + tagLabel.getBody() + "</#list>";

    return strTag;
}

---

From source file:cms.pageList.entity.GeneralShopPageLabel.java

License:Apache License

public String getIterativeString(TagLabel tagLabel, List<PropertyFilter> filters) {

    String strTag = tagLabel.getTagName();

    // System.out.println("3:"+pageNo);

    // ????ID//  w  w  w . j  a va  2 s. com
    List<Arctype> arctypeList = sm.getArctypeManager()
            .getAdviceList(new Long(Integer.parseInt(pfValue("typeId", filters))));
    String typeidStr = pfValue("typeId", filters);
    for (Arctype arctypeTest : arctypeList) {
        typeidStr += "," + arctypeTest.getId();
    }

    //??
    if ((!tagLabel.getOrderby().trim().equalsIgnoreCase(""))
            && (!tagLabel.getOrderbyType().trim().equalsIgnoreCase(""))) {

        addArchivesList(tagLabel.getRow(), Integer.parseInt(pfValue("pageNo", filters)), tagLabel.getOrderby(),
                tagLabel.getOrderbyType(), Restrictions.ge("arcrank", 0),
                Restrictions.sqlRestriction("typeid in (" + typeidStr + ")"));
    } else {//?
        addArchivesList(tagLabel.getRow(), Integer.parseInt(pfValue("pageNo", filters)), "senddate", "desc",
                Restrictions.ge("arcrank", 0), Restrictions.sqlRestriction("typeid in (" + typeidStr + ")"));
    }

    //??

    /*strTag = "<s:iterator value=\"pagecontent.listLabel.get("+pfValue("getNum" ,filters)+").getPage().getResult()\" status=\"st\">"
    + tagLabel.getBody() + "</s:iterator>";*/
    strTag = "<#list pagecontent.listLabel.get(" + pfValue("getNum", filters)
            + ").getPage().getResult() as xx >" + tagLabel.getBody() + "</#list>";

    return strTag;
}

---

From source file:cms.pageList.entity.SearcherLabel.java

License:Apache License

public String getIterativeString(TagLabel tagLabel, List<PropertyFilter> filters) {

    String strTag = tagLabel.getTagName();// ??

    // System.out.println("------------------------------------");

    if (tagLabel == null)
        return strTag;

    // //from  w  w  w  .j a  v  a2  s . c  om

    // ??
    if ((!tagLabel.getOrderby().trim().equalsIgnoreCase(""))
            && (!tagLabel.getOrderbyType().trim().equalsIgnoreCase(""))) {

        String arcattStr = null;// 
        for (Long flagid : tagLabel.getflagIds()) {
            arcattStr += "," + flagid;
        }

        // 
        if (arcattStr != null) {
            // ?0,?
            if (tagLabel.getTypeid() == 0) {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.ge("arcrank", 0),
                        Restrictions.sqlRestriction(
                                "id in  ( select archives_id from archives_arcatt where arcatt_id in("
                                        + arcattStr + ") )"),
                        Restrictions.or(
                                Restrictions.like("title", pfValue("title", filters), MatchMode.ANYWHERE),
                                Restrictions.like("body", pfValue("title", filters), MatchMode.ANYWHERE)));
            } else {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.eq("typeid", tagLabel.getTypeid()), Restrictions.ge("arcrank", 0),
                        Restrictions.sqlRestriction(
                                "id in  ( select archives_id from archives_arcatt where arcatt_id in("
                                        + arcattStr + ") )"),
                        Restrictions.or(
                                Restrictions.like("title", pfValue("title", filters), MatchMode.ANYWHERE),
                                Restrictions.like("body", pfValue("title", filters), MatchMode.ANYWHERE)));
            }
        } else { // 

            // ?0,?
            if (tagLabel.getTypeid() == 0) {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.ge("arcrank", 0),
                        Restrictions.or(
                                Restrictions.like("title", pfValue("title", filters), MatchMode.ANYWHERE),
                                Restrictions.like("body", pfValue("title", filters), MatchMode.ANYWHERE)));
            } else {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.ge("arcrank", 0), Restrictions.eq("typeid", tagLabel.getTypeid()),
                        Restrictions.or(
                                Restrictions.like("title", pfValue("title", filters), MatchMode.ANYWHERE),
                                Restrictions.like("body", pfValue("title", filters), MatchMode.ANYWHERE)));
            }

        }

    } else { // ?
        // ?0,?

        if (tagLabel.getTypeid() == 0) {
            addArchivesList(tagLabel.getRow(), 1, "senddate", "desc", Restrictions.ge("arcrank", 0),
                    Restrictions.eq("typeid", tagLabel.getTypeid()));
        } else {
            addArchivesList(tagLabel.getRow(), 1, "senddate", "desc", Restrictions.ge("arcrank", 0));
        }

    }

    /*strTag = "<s:iterator value=\"pagecontent.listLabel.get("
    + pfValue("getNum", filters)
    + ").getPage().getResult()\" status=\"st\">"
    + tagLabel.getBody() + "</s:iterator>";*/
    strTag = "<#list pagecontent.listLabel.get(" + pfValue("getNum", filters)
            + ").getPage().getResult() as xx >" + tagLabel.getBody() + "</#list>";

    return strTag;
}

---

From source file:cms.pageList.entity.ShopLabel.java

License:Apache License

public String getIterativeString(TagLabel tagLabel, List<PropertyFilter> filters) {
    String strTag = tagLabel.getTagName();// ??

    if (tagLabel == null)
        return strTag;

    // /*from  w w  w .j a v a 2  s  .  co m*/

    // ??
    if ((!tagLabel.getOrderby().trim().equalsIgnoreCase(""))
            && (!tagLabel.getOrderbyType().trim().equalsIgnoreCase(""))) {

        String arcattStr = null;// 
        for (Long flagid : tagLabel.getflagIds()) {
            arcattStr += "," + flagid;
        }
        // 
        if (arcattStr != null) {
            // ?0,?
            if (tagLabel.getTypeid() == 0) {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.ge("arcrank", 0),
                        Restrictions.sqlRestriction(
                                "shop_id in  ( select shop_id from shop_arcatt where arcatt_id in(" + arcattStr
                                        + ") )"));
            } else {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.eq("typeid", tagLabel.getTypeid()), Restrictions.ge("arcrank", 0),
                        Restrictions.sqlRestriction(
                                "shop_id in  ( select shop_id from shop_arcatt where arcatt_id in(" + arcattStr
                                        + ") )"));
            }
        } else { // 

            // ?0,?
            if (tagLabel.getTypeid() == 0) {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.ge("arcrank", 0));
            } else {
                addArchivesList(tagLabel.getRow(), 1, tagLabel.getOrderby(), tagLabel.getOrderbyType(),
                        Restrictions.ge("arcrank", 0), Restrictions.eq("typeid", tagLabel.getTypeid()));
            }

        }

    } else { // ?
        // ?0,?

        if (tagLabel.getTypeid() == 0) {
            addArchivesList(tagLabel.getRow(), 1, "senddate", "desc", Restrictions.ge("arcrank", 0),
                    Restrictions.eq("typeid", tagLabel.getTypeid()));
        } else {
            addArchivesList(tagLabel.getRow(), 1, "senddate", "desc", Restrictions.ge("arcrank", 0));
        }

    }

    strTag = "<s:iterator value=\"pagecontent.listLabel.get(" + pfValue("getNum", filters)
            + ").getPage().getResult()\" status=\"st\">" + tagLabel.getBody() + "</s:iterator>";

    return strTag;
}

---

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