Package org.hibernate.criterion

Examples of org.hibernate.criterion.DetachedCriteria.addOrder()

60
61
62
63
64
65
66
67
68
69
70
         final DetachedCriteria criteria = DetachedCriteria.forClass(Notification.class);
            criteria.add(Restrictions.or(Restrictions.eq("account", user), Restrictions.isNull("account")));
            if (onlyUnread) {
                criteria.add(Restrictions.eq("readed", Boolean.FALSE));
            }
            criteria.addOrder(Order.desc("created"));
            return getHibernateTemplate().findByCriteria(criteria, start, limit);
    }

    /*
     *  (non-Javadoc)
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
            final Date endDate,
            final Boolean onlyUnread) {
         final DetachedCriteria criteria = DetachedCriteria.forClass(Notification.class);
            criteria.add(Restrictions.or(Restrictions.eq("account", user), Restrictions.isNull("account")));
            criteria.add(Restrictions.between("created", startDate, endDate));
            criteria.addOrder(Order.desc("created"));
            return getHibernateTemplate().findByCriteria(criteria, start, limit);
    }

    /**
     * Retrieve Notification Status
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
  public List<Comment> getCommentsbyUser(final UserAccount userAcc,
      final Integer maxResults, final Integer start,
      final List<CommentOptions> commentOptions) {
        final DetachedCriteria criteria = DetachedCriteria.forClass(Comment.class);
        criteria.add(Restrictions.eq("user", userAcc));
        criteria.addOrder(Order.desc("createdAt"));
    criteria.addOrder(Order.desc("likeVote"));
    if ((commentOptions.size() != 1)
        && (!commentOptions.get(0).equals(CommentOptions.ALL))) {
      criteria.add(Restrictions.in("commentOptions", commentOptions));
    }
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
      final Integer maxResults, final Integer start,
      final List<CommentOptions> commentOptions) {
        final DetachedCriteria criteria = DetachedCriteria.forClass(Comment.class);
        criteria.add(Restrictions.eq("user", userAcc));
        criteria.addOrder(Order.desc("createdAt"));
    criteria.addOrder(Order.desc("likeVote"));
    if ((commentOptions.size() != 1)
        && (!commentOptions.get(0).equals(CommentOptions.ALL))) {
      criteria.add(Restrictions.in("commentOptions", commentOptions));
    }
    return (List<Comment>) filterByMaxorStart(criteria, maxResults, start);
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
     */
    @SuppressWarnings("unchecked")
    public List<Comment> getCommentsbyTweetPoll(final TweetPoll tpoll, final Integer maxResults, final Integer start){
        final DetachedCriteria criteria = DetachedCriteria.forClass(Comment.class);
        criteria.add(Restrictions.eq("tweetPoll",tpoll));
        criteria.addOrder(Order.desc("likeVote"));
        return (List<Comment>) filterByMaxorStart(criteria, maxResults, start);
    }

  @SuppressWarnings("unchecked")
  public List<Comment> getCommentsbyTypeAndStatus(final Long id,
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
      criteria.add(Restrictions.eq("survey.sid", id));
    } else {
      log.error(" Search result type undefined " + typeSearch.toString());
    }

    criteria.addOrder(Order.desc("likeVote"));
    if (!commentOptions.equals(CommentOptions.ALL)) {
      criteria.add(Restrictions.eq("commentOptions", commentOptions));
    }

    if(period!=null){
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
     */
    @SuppressWarnings("unchecked")
    public List<Comment> getCommentsbPoll(final Poll poll, final Integer maxResults, final Integer start) {
        final DetachedCriteria criteria = DetachedCriteria.forClass(Comment.class);
        criteria.add(Restrictions.eq("poll",poll));
        criteria.addOrder(Order.desc("likeVote"));
        return (List<Comment>) filterByMaxorStart(criteria, maxResults, start);
    }


    /*
 
View Full Code Here
245
246
247
248
249
250
251
252
253
254
255
        criteria.add(Restrictions.between("createdAt",
                getCommentTimeRange(timeRange), getNextDayMidnightDate()));
        if (socialOption != null) {
            if (socialOption.equals(CommentsSocialOptions.LIKE_VOTE)) {
                criteria.addOrder(Order.desc("likeVote"));
            } else if (socialOption.equals(CommentsSocialOptions.DISLIKE_VOTE)) {
                criteria.addOrder(Order.desc("dislikeVote"));
            } else {
                criteria.addOrder(Order.desc("likeVote"));
            }
View Full Code Here
247
248
249
250
251
252
253
254
255
256
257
                getCommentTimeRange(timeRange), getNextDayMidnightDate()));
        if (socialOption != null) {
            if (socialOption.equals(CommentsSocialOptions.LIKE_VOTE)) {
                criteria.addOrder(Order.desc("likeVote"));
            } else if (socialOption.equals(CommentsSocialOptions.DISLIKE_VOTE)) {
                criteria.addOrder(Order.desc("dislikeVote"));
            } else {
                criteria.addOrder(Order.desc("likeVote"));
            }
        } else {
            criteria.addOrder(Order.desc("likeVote"));
View Full Code Here
249
250
251
252
253
254
255
256
257
258
259
            if (socialOption.equals(CommentsSocialOptions.LIKE_VOTE)) {
                criteria.addOrder(Order.desc("likeVote"));
            } else if (socialOption.equals(CommentsSocialOptions.DISLIKE_VOTE)) {
                criteria.addOrder(Order.desc("dislikeVote"));
            } else {
                criteria.addOrder(Order.desc("likeVote"));
            }
        } else {
            criteria.addOrder(Order.desc("likeVote"));
        }
        return (List<Comment>) filterByMaxorStart(criteria, maxResults,
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.