Example usage for org.hibernate.criterion DetachedCriteria 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.TweetPollDao.java

License:Apache License

/**
 * Retrieve Favourites TweetPolls.//from w ww.  jav  a  2  s .  c  o  m
 *
 * @param keyWord
 * @param userId
 * @return
 */
@SuppressWarnings("unchecked")
public List<TweetPoll> retrieveScheduledTweetPoll(final Long userId, 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.uid", userId));
    // To retrieve all and only scheduled Tweetpoll period should be = ALLTIME
    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> retrievePublishedUnpublishedTweetPoll(final Account account, final Integer maxResults,
        final Integer start, final Boolean isPublished) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPoll.class);
    criteria.createAlias("tweetOwner", "tweetOwner");
    criteria.add(Restrictions.eq("publishTweetPoll", isPublished));
    criteria.add(Restrictions.eq("tweetOwner", account));
    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> retrieveCompletedTweetPoll(final Account account, final Integer maxResults,
        final Integer start, final Boolean isComplete) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPoll.class);
    criteria.createAlias("tweetOwner", "tweetOwner");
    criteria.add(Restrictions.eq("publishTweetPoll", Boolean.TRUE));
    criteria.add(Restrictions.eq("tweetOwner", account));
    criteria.add(Restrictions.eq("completed", isComplete));
    return (List<TweetPoll>) filterByMaxorStart(criteria, maxResults, start);
}

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

License:Apache License

@SuppressWarnings("unchecked")
public List<TweetPollResult> validateTweetPollResultsIP(final String ip, final TweetPoll tweetPoll) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPollResult.class);
    criteria.add(Restrictions.eq("ipVote", ip));
    criteria.createAlias("tweetPollSwitch", "tpSwitch");
    criteria.add(Restrictions.eq("tpSwitch.tweetPoll", tweetPoll));
    return (List<TweetPollResult>) getHibernateTemplate().findByCriteria(criteria);
}

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

License:Apache License

public TweetPoll getTweetPollByIdandSlugName(final Long tweetPollId, final String slugName)
        throws UnsupportedEncodingException {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPoll.class);
    criteria.createAlias("question", "q");
    criteria.add(Restrictions.eq("tweetPollId", tweetPollId));
    criteria.add(Restrictions.eq("q.slugQuestion", RestFullUtil.encodeUTF8(slugName)));
    return (TweetPoll) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

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

License:Apache License

@SuppressWarnings("unchecked")
public List<TweetPollSavedPublishedStatus> getSocialLinksByTweetPollSearch(final TweetPoll tweetPoll,
        final TypeSearchResult itemType, final List<SocialProvider> splist,
        final List<SocialAccount> socialAccounts) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPollSavedPublishedStatus.class);
    criteria.createAlias("socialAccount", "socialAccount");
    if (itemType.equals(TypeSearchResult.TWEETPOLL)) {
        criteria.add(Restrictions.eq("tweetPoll", tweetPoll));
        criteria.add(Restrictions.isNotNull("tweetId"));
        criteria.add(Restrictions.eq("status", Status.SUCCESS));
        if (splist.size() > 0) {
            criteria.add(Restrictions.in("apiType", splist));
        }/*  w w w  . j av  a 2  s.  co  m*/
        if (socialAccounts.size() > 0) {
            criteria.add(Restrictions.in("socialAccount", socialAccounts));
        }
    }
    return (List<TweetPollSavedPublishedStatus>) getHibernateTemplate().findByCriteria(criteria);
}

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

License:Apache License

@SuppressWarnings("unchecked")
public List<TweetPollSavedPublishedStatus> searchSocialLinksbyType(final TweetPoll tweetPoll, final Poll poll,
        final TypeSearchResult itemType, final List<SocialProvider> splist,
        final List<SocialAccount> socialAccounts) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPollSavedPublishedStatus.class);
    criteria.createAlias("socialAccount", "socialAccount");

    if (itemType.equals(TypeSearchResult.TWEETPOLL)) {
        criteria.add(Restrictions.eq("tweetPoll", tweetPoll));
        // Revisar bien estos valores porque sino encuentra nada va a evaluarlos y regresara valores
        criteriaSearchSocialLinksByType(criteria, splist, socialAccounts);

    } else if (itemType.equals(TypeSearchResult.POLL)) {
        criteria.add(Restrictions.eq("poll", poll));
        criteriaSearchSocialLinksByType(criteria, splist, socialAccounts);
    }/*from   ww w  .  j  ava 2 s.  co  m*/

    return (List<TweetPollSavedPublishedStatus>) getHibernateTemplate().findByCriteria(criteria);
}

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

License:Apache License

public Long getMaxTweetPollLikeVotesbyUser(final Long userId) {
    DetachedCriteria criteria = DetachedCriteria.forClass(TweetPoll.class);
    criteria.setProjection(Projections.max("likeVote"));
    criteria.createAlias("editorOwner", "editorOwner");
    criteria.add(Restrictions.eq("editorOwner.uid", userId));
    @SuppressWarnings("unchecked")
    List<TweetPoll> results = (List<TweetPoll>) getHibernateTemplate().findByCriteria(criteria);
    return (Long) (results.get(0) == null ? 0 : results.get(0));
}

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

License:Apache License

@SuppressWarnings("unchecked")
public Long getSocialLinksByType(final TweetPoll tweetPoll, final Survey survey, final Poll poll,
        final TypeSearchResult itemType) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPollSavedPublishedStatus.class);
    criteria.setProjection(Projections.rowCount());
    if (itemType.equals(TypeSearchResult.TWEETPOLL)) {
        criteria.add(Restrictions.eq("tweetPoll", tweetPoll));
    } else if (itemType.equals(TypeSearchResult.SURVEY)) {
        criteria.createAlias("survey", "survey");
        criteria.add(Restrictions.eq("survey", survey));
        // criteria.addOrder(Order.desc("survey.createdAt"));
    } else if (itemType.equals(TypeSearchResult.POLL)) {
        criteria.add(Restrictions.eq("poll", poll));
        // criteria.addOrder(Order.desc("poll.createdAt"));
    } else {/*from  w w w  . j  ava2s  .  c  om*/
        log.error("Item type not valid: " + itemType);
    }
    criteria.add(Restrictions.isNotNull("apiType"));
    criteria.add(Restrictions.isNotNull("tweetId"));
    criteria.add(Restrictions.eq("status", Status.SUCCESS));

    List<TweetPollSavedPublishedStatus> results = (List<TweetPollSavedPublishedStatus>) getHibernateTemplate()
            .findByCriteria(criteria);
    log.debug("Retrieve total Social Links:" + "--->" + results.size());
    return (Long) (results.get(0) == null ? 0 : results.get(0));

}

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

License:Apache License

@SuppressWarnings("unchecked")
public List<TweetPollSavedPublishedStatus> getSocialLinksByTypeAndDateRange(final TweetPoll tweetPoll,
        final Survey survey, final Poll poll, final TypeSearchResult itemType) {

    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPollSavedPublishedStatus.class);
    if (itemType.equals(TypeSearchResult.TWEETPOLL)) {
        criteria.createAlias("tweetPoll", "tweetPoll");
        criteria.add(Restrictions.eq("tweetPoll", tweetPoll));

    } else if (itemType.equals(TypeSearchResult.SURVEY)) {
        criteria.createAlias("survey", "survey");
        criteria.add(Restrictions.eq("survey", survey));

    } else if (itemType.equals(TypeSearchResult.POLL)) {
        criteria.add(Restrictions.eq("poll", poll));

    } else {/*from  w ww  .j  a  va2  s .co m*/
        log.error("Item type not valid: " + itemType);
    }

    criteria.add(Restrictions.isNotNull("apiType"));
    criteria.add(Restrictions.isNotNull("tweetId"));
    criteria.add(Restrictions.eq("status", Status.SUCCESS));
    return (List<TweetPollSavedPublishedStatus>) getHibernateTemplate().findByCriteria(criteria);
}