/**
    * Copyright 2011-2013 The Kuali Foundation Licensed under the
    * Educational Community License, Version 2.0 (the "License"); you may
    * not use this file except in compliance with the License. You may
    * obtain a copy of the License at
    *
    * http://www.osedu.org/licenses/ECL-2.0
    *
    * Unless required by applicable law or agreed to in writing,
   * software distributed under the License is distributed on an "AS IS"
   * BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
   * or implied. See the License for the specific language governing
   * permissions and limitations under the License.
   */
  
  package org.kuali.mobility.writer.dao;
  
  import java.util.ArrayList;
  import java.util.List;
  
  import javax.persistence.EntityManager;
  import javax.persistence.PersistenceContext;
  import javax.persistence.Query;
  
  import org.kuali.mobility.writer.entity.Article;
  import org.kuali.mobility.writer.entity.ArticleRejection;
  import org.springframework.stereotype.Repository;
  import org.springframework.transaction.annotation.Transactional;
  
  /**
   *  Data Access Object for articles.
   * @author Kuali Mobility Team (mobility.collab@kuali.org)
   * @since 3.0.0
   */
  @Repository
  public class ArticleDaoImpl implements ArticleDao {
  
  	@PersistenceContext
  	private EntityManager entityManager;
  
  	public EntityManager getEntityManager() {
  		return entityManager;
  	}
  
  	public void setEntityManager(EntityManager entityManager) {
  		this.entityManager = entityManager;
  	}
  
  	public Article getArticle(long articleId) {
  		return getEntityManager().find(Article.class, articleId);
  	}
  
  
  	@Override
  	@Transactional
  	public Article maintainArticle(Article article) {
  		Article a = article;
  		if (article.getId() == null){ // Store new
  			 getEntityManager().persist(article);
  		}
  		else { // Update existing
  			a = getEntityManager().merge(article);
  		}
  		return a;
  	}
  
  	@Override
  	public List<Article> getRejectedArticles(String tool, String userId) {
  		Query query = getEntityManager().createNamedQuery("Article.getRejectedArticles");
  		query.setParameter("userId", userId);
  		query.setParameter("tool", tool);
  		return query.getResultList();
  	}
  
  	@Override
  	public List<Article> getSavedArticles(String tool, String userId, boolean isEditor) {
  		String nq = (isEditor ? "Article.getSavedArticlesEditor" : "Article.getSavedArticles");
  		Query query = getEntityManager().createNamedQuery(nq);
  		query.setParameter("userId", userId);
  		query.setParameter("tool", tool);
  		return query.getResultList();
  	}
  
  
  	@Override
  	public List<Article> getSubmittedArticles(String tool) {
  		Query query = getEntityManager().createNamedQuery("Article.getSubmittedArticles");
  		query.setParameter("tool", tool);
  		return  query.getResultList();
  	}
  
  	@Override
  	public ArticleRejection getArticleRejection(long rejectionId) {
  		return getEntityManager().find(ArticleRejection.class, rejectionId);
  	}
  
  
  	@Override
  	public long getNumArticles(String tool, long topicId) {
 		String nq = (topicId == 0 ? "Article.getNumArticlesTopNews" : "Article.getNumArticles");
 		Query query = getEntityManager().createNamedQuery(nq);
 		if (topicId != 0) {
 			query.setParameter("topicId", topicId);
 		}
 		query.setParameter("tool", tool);
 		return (Long)query.getSingleResult();
 	}
 
 	@Override
 	public List<Article> getArticles(String tool, long topicId, int from, int fetchSize) {
 		String nq = (topicId == 0 ? "Article.getTopNewsRange" : "Article.getNewsRange");
 		Query query = getEntityManager().createNamedQuery(nq);
 		query.setFirstResult(from);
 		query.setMaxResults(fetchSize);
 		if (topicId != 0) {
 			query.setParameter("topicId", topicId);
 		}
 		query.setParameter("tool", tool);
 		List<Article> resultList = new ArrayList<Article>();
 		resultList.addAll(query.getResultList());
 		return resultList;
 	}
 
 	@Override
 	public List<Article> searchArticles(String tool, String searchText, int from, int fetchSize) {
 		Query query = this.getEntityManager().createNamedQuery("Article.searchNews");
 		query.setParameter("text","%"+ searchText+"%");
 		query.setParameter("tool", tool);
 		query.setFirstResult(from);
 		query.setMaxResults(fetchSize);
 		return query.getResultList();
 	}
 
 	@Override
 	public long searchArticlesCount(String tool, String searchText) {
 		Query query = this.getEntityManager().createNamedQuery("Article.searchNewsCount");
 		query.setParameter("text","%"+ searchText+"%");
 		query.setParameter("tool", tool);
 		return (Long)query.getSingleResult();
 	}
 
 	@Override
 	public long getNumberRejectedArticles(String tool, String userId) {
 		Query query = getEntityManager().createNamedQuery("Article.getNumRejectedArticles");
 		query.setParameter("userId", userId);
 		query.setParameter("tool", tool);
 		return (Long)query.getSingleResult();
 	}
 
 	@Override
 	public long getNumberSavedArticles(String instance, String userId, boolean isEditor) {
 		String nq = (isEditor ? "Article.getNumSavedArticlesEditor" : "Article.getNumSavedArticles");
 		Query query = getEntityManager().createNamedQuery(nq);
 		query.setParameter("userId", userId);
 		query.setParameter("tool", instance);
 		return (Long)query.getSingleResult();
 	}
 
 	@Override
 	public long getNumberSubmittedArticles(String instance) {
 		Query query = getEntityManager().createNamedQuery("Article.getNumSubmittedArticles");
 		query.setParameter("tool", instance);
 		return  (Long)query.getSingleResult();
 	}
 }