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.DashboardDao.java

License:Apache License

@SuppressWarnings("unchecked")
public List retrievePropertiesbyGadget(final Long gadgetId) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(GadgetProperties.class);
    criteria.createAlias("gadget", "gadget");
    criteria.add(Restrictions.eq("gadget.gadgetId", gadgetId));
    return getHibernateTemplate().findByCriteria(criteria);
}

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

License:Apache License

@SuppressWarnings("unchecked")
public List retrieveGadgetsbyDashboard(final Long boardId) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Gadget.class);
    criteria.createAlias("dashboard", "dashboard");
    criteria.add(Restrictions.eq("dashboard.boardId", boardId));
    return getHibernateTemplate().findByCriteria(criteria);
}

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

License:Apache License

/**
 * Find Emails by User.//from   www  . j a  v  a2 s. c o m
 * @return
 */
@SuppressWarnings("unchecked")
public List<EmailList> findListbyUser(final Long userId) {
    // return (Notification) getHibernateTemplate().get(Notification.class, notificationId);
    final DetachedCriteria criteria = DetachedCriteria.forClass(EmailList.class);
    criteria.createAlias("user", "usuarioEmail");
    criteria.add(Restrictions.eq("user.uid", userId));
    return (List<EmailList>) getHibernateTemplate().findByCriteria(criteria);
}

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

License:Apache License

/**
 * Find Emails By List Id./*ww  w.  j  a  v  a2 s  . com*/
 * @param emailList
 * @return
 */
@SuppressWarnings("unchecked")
public List<Email> findEmailsByListId(final Long idList) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Email.class);
    criteria.createAlias("emailList", "idListEmail");
    criteria.add(Restrictions.eq("emailList.idList", idList));
    return (List<Email>) getHibernateTemplate().findByCriteria(criteria);

}

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

License:Apache License

/**
 * Get TweetPoll Front End./*from  ww  w . j  av  a  2s.  c  o  m*/
 * @param period date period
 * @param firstResult first results
 * @param maxResults max results
 * @return list of tweetPoll.
 */
@SuppressWarnings("unchecked")
public final List<TweetPoll> getTweetPollFrontEnd(final SearchPeriods period, final Integer start,
        final Integer maxResults, final Integer firstResult) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(TweetPoll.class);
    criteria.createAlias("question", "question");
    calculateSearchPeriodsDates(period, criteria, "createDate");
    criteria.add(Restrictions.eq("publishTweetPoll", Boolean.TRUE)); //should be published
    criteria.add(Restrictions.gt("relevance", 0L));
    criteria.addOrder(Order.desc("relevance"));
    criteria.addOrder(Order.desc("createDate"));
    return (List<TweetPoll>) filterByMaxorStart(criteria, maxResults, start);
    //return getHibernateTemplate().findByCriteria(criteria, firstResult, maxResults);
}

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

License:Apache License

/**
 * Get Poll on Front End//from   w ww .  j  a  va2 s .  co  m
 * @param period period
 * @param maxResults maxResults
 * @param firstResult firstResults.
 * @return list of poll.
 */
@SuppressWarnings("unchecked")
public final List<Poll> getPollFrontEnd(final SearchPeriods period, final Integer start,
        final Integer maxResults, final Integer firstResult) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Poll.class);
    criteria.createAlias("question", "question");
    calculateSearchPeriodsDates(period, criteria, "createDate");
    criteria.add(Restrictions.gt("relevance", 0L));
    criteria.add(Restrictions.eq("publish", Boolean.TRUE)); //should be published
    criteria.add(Restrictions.or(Restrictions.eq("isHidden", Boolean.FALSE), Restrictions.isNull("isHidden")));
    criteria.add(Restrictions.isNotNull("isPasswordProtected"));
    criteria.add(Restrictions.isNull("passProtection"));
    //criteria.add(Restrictions.isEmpty("passProtection"));
    criteria.addOrder(Order.desc("createDate"));
    criteria.addOrder(Order.desc("relevance"));
    List<Poll> polls = (List<Poll>) filterByMaxorStart(criteria, maxResults, start);
    return polls;
}

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

License:Apache License

@SuppressWarnings("unchecked")
public List<Hit> getAllHitsByType(final TweetPoll tweetpoll, final Poll poll, final Survey survey) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(Hit.class);
    if (poll != null) {
        criteria.createAlias("poll", "poll");
        criteria.add(Restrictions.eq("poll", poll));
    } else if (tweetpoll != null) {
        criteria.createAlias("tweetPoll", "tweetPoll");
        criteria.add(Restrictions.eq("tweetPoll", tweetpoll));
    } else if (survey != null) {
        criteria.createAlias("survey", "survey");
        criteria.add(Restrictions.eq("survey", survey));
    }//  w w w .  j a  va2  s . c  o  m
    return (List<Hit>) getHibernateTemplate().findByCriteria(criteria);
}

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

License:Apache License

public final Long getTotalHitsbyType(final Long id, final TypeSearchResult searchHitby, final Integer period) {
    Date startDate = null;/*from w  ww  . j  ava 2 s. co m*/
    Date endDate = null;
    if (period != null) {
        final DateTime dateTime = new DateTime();
        endDate = dateTime.toDate();
        startDate = DateUtil.minusDaysToCurrentDate(period, dateTime.toDate());
    }
    final DetachedCriteria criteria = DetachedCriteria.forClass(Hit.class);
    criteria.setProjection(Projections.rowCount());
    if (searchHitby.equals(TypeSearchResult.TWEETPOLL)) {
        criteria.createAlias("tweetPoll", "tweetPoll");
        criteria.add(Restrictions.eq("tweetPoll.tweetPollId", id));
    } else if (searchHitby.equals(TypeSearchResult.POLL)) {
        criteria.createAlias("poll", "poll");
        criteria.add(Restrictions.eq("poll.pollId", id));
    } else if (searchHitby.equals(TypeSearchResult.SURVEY)) {
        criteria.createAlias("survey", "survey");
        criteria.add(Restrictions.eq("survey.sid", id));
    } else if (searchHitby.equals(TypeSearchResult.HASHTAG)) {
        criteria.createAlias("hashTag", "hashTag");
        criteria.add(Restrictions.eq("hashTag.hashTagId", id));
    } else {
        log.error(" Search hit result type undefined " + searchHitby);
    }

    if (startDate != null && endDate != null) {
        criteria.add(Restrictions.between("hitDate", startDate, endDate));
    }

    //define as a VISIT category
    criteria.add(Restrictions.eq("hitCategory", HitCategory.VISIT));
    @SuppressWarnings("unchecked")
    List<Hit> results = (List<Hit>) getHibernateTemplate().findByCriteria(criteria);
    log.debug("Retrieve total hits by  " + searchHitby + "--->" + results.size());
    return (Long) (results.get(0) == null ? 0 : results.get(0));
}

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

License:Apache License

@SuppressWarnings("unchecked")
public List<Hit> getHashTagHitsbyDateRange(final Long tagId, final Integer period) {
    Date startDate = null;//from w  w w .j a v  a  2  s  .c  om
    Date endDate = null;
    if (period != null) {
        final Calendar hi = Calendar.getInstance();
        hi.add(Calendar.DAY_OF_YEAR, -period);
        startDate = hi.getTime();
        endDate = Calendar.getInstance().getTime();

    }

    final DetachedCriteria criteria = DetachedCriteria.forClass(Hit.class);
    criteria.createAlias("hashTag", "hashTag");
    criteria.add(Restrictions.eq("hashTag.hashTagId", tagId));
    criteria.addOrder(Order.desc("hitDate"));
    criteria.add(Restrictions.between("hitDate", startDate, endDate));
    //define as a VISIT category
    criteria.add(Restrictions.eq("hitCategory", HitCategory.VISIT));
    return (List<Hit>) getHibernateTemplate().findByCriteria(criteria);

}

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

License:Apache License

@SuppressWarnings("unchecked")
public List<Hit> getHashTagHitsRange(final Long tagId, final SearchPeriods period) {

    final DetachedCriteria criteria = DetachedCriteria.forClass(Hit.class);
    criteria.createAlias("hashTag", "hashTag");
    criteria.add(Restrictions.eq("hashTag.hashTagId", tagId));
    criteria.addOrder(Order.desc("hitDate"));

    // define as a VISIT category
    criteria.add(Restrictions.eq("hitCategory", HitCategory.VISIT));

    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.groupProperty("hitDate"));

    projList.add(Projections.rowCount());
    criteria.setProjection(projList);/* w  w  w.  j a v a2 s .  c  o m*/
    return (List<Hit>) getHibernateTemplate().findByCriteria(criteria);

}