Example usage for org.hibernate.criterion DetachedCriteria createAlias

List of usage examples for org.hibernate.criterion DetachedCriteria createAlias

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. createAlias

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria createAlias.

Prototype

public DetachedCriteria createAlias(String associationPath, String alias)

Source Link

Document

Creates an association path alias within this DetachedCriteria.

Usage

From source file:org.encuestame.persistence.dao.imp.SurveyDaoImp.java

License:Apache License

@SuppressWarnings("unchecked")
//TODO: migrate search to Hibernate Search.
public List<Survey> retrieveSurveybyName(final String keyWord, final Long userId, final Integer maxResults,
        final Integer start) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Survey.class);
    criteria.createAlias("editorOwner", "editorOwner");
    criteria.add(Restrictions.like("name", keyWord, MatchMode.ANYWHERE));
    criteria.add(Restrictions.eq("editorOwner.uid", userId));
    return (List<Survey>) filterByMaxorStart(criteria, maxResults, start);
}

From source file:org.encuestame.persistence.dao.imp.SurveyDaoImp.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Survey> retrieveSurveyByDate(final Account account, final Date initDate, final Integer maxResults,
        final Integer start) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Survey.class);
    criteria.createAlias("owner", "owner");
    criteria.add(Restrictions.between("createDate", initDate, getNextDayMidnightDate()));
    criteria.add(Restrictions.eq("owner", account));
    return (List<Survey>) filterByMaxorStart(criteria, maxResults, start);
}

From source file:org.encuestame.persistence.dao.imp.SurveyDaoImp.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Survey> retrieveFavoritesSurvey(final UserAccount userAccount, final Integer maxResults,
        final Integer start) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Survey.class);
    criteria.createAlias("editorOwner", "editorOwner");
    criteria.add(Restrictions.eq("editorOwner", userAccount));
    criteria.add(Restrictions.eq("favourites", Boolean.TRUE));
    return (List<Survey>) filterByMaxorStart(criteria, maxResults, start);
}

From source file:org.encuestame.persistence.dao.imp.SurveyDaoImp.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Survey> retrieveScheduledSurvey(final Long userId, final Integer maxResults, final Integer start) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Survey.class);
    criteria.createAlias("editorOwner", "editorOwner");
    criteria.add(Restrictions.eq("scheduleSurvey", Boolean.TRUE));
    criteria.add(Restrictions.isNotNull("scheduleDate"));
    criteria.add(Restrictions.eq("editorOwner.uid", userId));
    return (List<Survey>) filterByMaxorStart(criteria, maxResults, start);
}

From source file:org.encuestame.persistence.dao.imp.SurveyDaoImp.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Survey> retrieveSurveyByUserId(final Long userId, final Integer maxResults, final Integer start) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Survey.class);
    criteria.createAlias("editorOwner", "editorOwner");
    criteria.add(Restrictions.eq("editorOwner.uid", userId));
    criteria.addOrder(Order.desc("createDate"));
    return (List<Survey>) filterByMaxorStart(criteria, maxResults, start);
}

From source file:org.encuestame.persistence.dao.imp.SurveyDaoImp.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Survey> retrieveSurveyByAccount(final Long userId, final Integer maxResults, final Integer start) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Survey.class);
    criteria.createAlias("owner", "owner");
    criteria.add(Restrictions.eq("owner.uid", userId));
    criteria.addOrder(Order.desc("createDate"));
    return (List<Survey>) filterByMaxorStart(criteria, maxResults, start);
}

From source file:org.encuestame.persistence.dao.imp.TweetPollDao.java

License:Apache License

/**
 * Retrieve Tweets Poll by User Id./*from w  ww.j  a v a 2  s  .co  m*/
 *
 * @param userId
 *            userId
 * @return list of tweet pools.
 */
@SuppressWarnings("unchecked")
public List<TweetPoll> retrieveTweetsByUserId(final String keyWord, final Long userId, final Integer maxResults,
        final Integer start, final Boolean isCompleted, final Boolean isScheduled, final Boolean isPublished,
        final Boolean isFavourite, final String period) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPoll.class);
    criteria.createAlias("tweetOwner", "tweetOwner");
    // removed because is the advancedSearchOptions should inject this value
    // criteria.add(Restrictions.eq("publishTweetPoll", Boolean.TRUE));
    criteria.add(Restrictions.eq("tweetOwner.id", userId));
    criteria.addOrder(Order.desc("createDate"));
    advancedTweetPollSearchOptions(criteria, isCompleted, isScheduled, isFavourite, isPublished, keyWord,
            period);
    return (List<TweetPoll>) filterByMaxorStart(criteria, maxResults, start);
}

From source file:org.encuestame.persistence.dao.imp.TweetPollDao.java

License:Apache License

/**
 * Get TweetPoll by Question Name./*  www  .ja va 2  s  . c  om*/
 *
 * @param keyWord
 *            keyword
 * @param userId
 *            user Id.
 * @return
 */
@SuppressWarnings("unchecked")
// TODO: migrate search to Hibernate Search.
public List<TweetPoll> retrieveTweetsByQuestionName(final String keyWord, final Long userId,
        final Integer maxResults, final Integer start, final Boolean isCompleted, final Boolean isScheduled,
        final Boolean isFavourite, final Boolean isPublished, final String period) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPoll.class);
    criteria.createAlias("tweetOwner", "tweetOwner");
    if (userId != null) {
        criteria.add(Restrictions.eq("tweetOwner.id", userId));
    }
    advancedTweetPollSearchOptions(criteria, isCompleted, isScheduled, isFavourite, isPublished, keyWord,
            period);
    return (List<TweetPoll>) filterByMaxorStart(criteria, maxResults, start);
}

From source file:org.encuestame.persistence.dao.imp.TweetPollDao.java

License:Apache License

@SuppressWarnings("unchecked")
public List<TweetPoll> retrieveTweetPollByDate(final Account account, final Integer maxResults,
        final Integer start, final Boolean isCompleted, final Boolean isScheduled, final Boolean isFavourite,
        final Boolean isPublished, final String keyword, final String period, final Date initDate) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPoll.class);
    criteria.createAlias("tweetOwner", "tweetOwner");
    criteria.add(Restrictions.eq("tweetOwner", account));
    criteria.add(Restrictions.between("createDate", initDate, getNextDayMidnightDate()));
    advancedTweetPollSearchOptions(criteria, isCompleted, isScheduled, isFavourite, isPublished, keyword,
            period);/*from   www.  j a v a 2 s.  c  om*/
    return (List<TweetPoll>) filterByMaxorStart(criteria, maxResults, start);
}

From source file:org.encuestame.persistence.dao.imp.TweetPollDao.java

License:Apache License

/**
 * Retrieve Favourites TweetPolls.//from  w  ww.  j av a2  s  . c  om
 *
 * @param keyWord
 * @param userId
 * @return
 */
@SuppressWarnings("unchecked")
public List<TweetPoll> retrieveFavouritesTweetPoll(final Account account, final Integer maxResults,
        final Integer start, final Boolean isCompleted, final Boolean isScheduled, final Boolean isFavourite,
        final Boolean isPublished, final String keyword, final String period) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPoll.class);
    criteria.createAlias("tweetOwner", "tweetOwner");
    criteria.add(Restrictions.eq("tweetOwner", account));
    advancedTweetPollSearchOptions(criteria, isCompleted, isScheduled, Boolean.TRUE, isPublished, keyword,
            period);
    return (List<TweetPoll>) filterByMaxorStart(criteria, maxResults, start);
}