fi.foyt.fni.persistence.dao.forum.ForumTopicDAO Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of persistence Show documentation
Forge & Illusion - Persistence
There is a newer version: 3.3.13
package fi.foyt.fni.persistence.dao.forum;

import java.util.Date;
import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.TypedQuery;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;

import fi.foyt.fni.persistence.dao.GenericDAO;
import fi.foyt.fni.persistence.model.forum.Forum;
import fi.foyt.fni.persistence.model.forum.ForumPost;
import fi.foyt.fni.persistence.model.forum.ForumPost_;
import fi.foyt.fni.persistence.model.forum.ForumTopic;
import fi.foyt.fni.persistence.model.forum.ForumTopic_;
import fi.foyt.fni.persistence.model.users.User;

public class ForumTopicDAO extends GenericDAO {

	private static final long serialVersionUID = 1L;

	public ForumTopic create(Forum forum, User author, Date created, Date modified, String urlName, String subject, Long views) {
    EntityManager entityManager = getEntityManager();

    ForumTopic forumTopic = new ForumTopic();
    forumTopic.setAuthor(author);
    forumTopic.setCreated(created);
    forumTopic.setForum(forum);
    forumTopic.setModified(modified);
    forumTopic.setSubject(subject);
    forumTopic.setUrlName(urlName);
    forumTopic.setViews(views);

    entityManager.persist(forumTopic);
    return forumTopic;
  }

  public ForumTopic findByForumAndUrlName(Forum forum, String urlName) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(ForumTopic.class);
    Root root = criteria.from(ForumTopic.class);
    criteria.select(root);
    
    
    criteria.where(
      criteriaBuilder.and(
        criteriaBuilder.equal(root.get(ForumTopic_.urlName), urlName),
        criteriaBuilder.equal(root.get(ForumTopic_.forum), forum)
      )
    );

    return getSingleResult(entityManager.createQuery(criteria));
  }
  
  public List listByForum(Forum forum) {
    EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(ForumTopic.class);
    Root root = criteria.from(ForumTopic.class);
    criteria.select(root);
    criteria.where(criteriaBuilder.equal(root.get(ForumTopic_.forum), forum));

    return entityManager.createQuery(criteria).getResultList();
  }

	public Long countByForum(Forum forum) {
		EntityManager entityManager = getEntityManager();

    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery criteria = criteriaBuilder.createQuery(Long.class);
    Root root = criteria.from(ForumTopic.class);
    criteria.select(criteriaBuilder.count(root));
    criteria.where(criteriaBuilder.equal(root.get(ForumTopic_.forum), forum));

    return entityManager.createQuery(criteria).getSingleResult();
	}

  public ForumTopic updateViews(ForumTopic forumTopic, Long views) {
    EntityManager entityManager = getEntityManager();

    forumTopic.setViews(views);
    
    entityManager.persist(forumTopic);
    
    return forumTopic;
  }

	public List listAllSortByAuthorMessageCount(User author, int firstResult, int maxResults) {
		EntityManager entityManager = getEntityManager();
		CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    
    CriteriaQuery criteria = criteriaBuilder.createQuery(ForumTopic.class);
    Root root = criteria.from(ForumPost.class);
    root.join(ForumPost_.topic);
    criteria.select(root.get(ForumPost_.topic));
    criteria.where(
    	criteriaBuilder.equal(root.get(ForumPost_.author), author)
    );
    criteria.groupBy(root.get(ForumPost_.topic));
    criteria.orderBy(
      criteriaBuilder.desc(
    	  criteriaBuilder.count(root.get(ForumPost_.id))		
      )
    );

    TypedQuery query = entityManager.createQuery(criteria);

    query.setFirstResult(firstResult);
    query.setMaxResults(maxResults);
    
    return query.getResultList();
	}

}