/**
 * Copyright or © or Copr. Ministère Français chargé de la Culture
 * et de la Communication (2013)
 * <p/>
 * contact.gincoculture_at_gouv.fr
 * <p/>
 * This software is a computer program whose purpose is to provide a thesaurus
 * management solution.
 * <p/>
 * This software is governed by the CeCILL license under French law and
 * abiding by the rules of distribution of free software. You can use,
 * modify and/ or redistribute the software under the terms of the CeCILL
 * license as circulated by CEA, CNRS and INRIA at the following URL
 * "http://www.cecill.info".
 * <p/>
 * As a counterpart to the access to the source code and rights to copy,
 * modify and redistribute granted by the license, users are provided only
 * with a limited warranty and the software's author, the holder of the
 * economic rights, and the successive licensors have only limited liability.
 * <p/>
 * In this respect, the user's attention is drawn to the risks associated
 * with loading, using, modifying and/or developing or reproducing the
 * software by the user in light of its specific status of free software,
 * that may mean that it is complicated to manipulate, and that also
 * therefore means that it is reserved for developers and experienced
 * professionals having in-depth computer knowledge. Users are therefore
 * encouraged to load and test the software's suitability as regards their
 * requirements in conditions enabling the security of their systemsand/or
 * data to be ensured and, more generally, to use and operate it in the
 * same conditions as regards security.
 * <p/>
 * The fact that you are presently reading this means that you have had
 * knowledge of the CeCILL license and that you accept its terms.
 */
package fr.mcc.ginco.dao.hibernate;

import java.util.List;

import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Repository;

import fr.mcc.ginco.beans.Suggestion;
import fr.mcc.ginco.dao.ISuggestionDAO;

/**
 * Implementation of the data access object to the suggestion database table
 * 
 */
@Repository
public class SuggestionDAO extends GenericHibernateDAO<Suggestion, Integer>
		implements ISuggestionDAO {

	public SuggestionDAO() {
		super(Suggestion.class);
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see
	 * fr.mcc.ginco.dao.ISuggestionDAO#findConceptPaginatedSuggestions(java.
	 * lang.String, java.lang.Integer, java.lang.Integer)
	 */
	@Override
	public List<Suggestion> findConceptPaginatedSuggestions(String conceptId,
			Integer startIndex, Integer limit) {
		return getCurrentSession().createCriteria(Suggestion.class)
				.setMaxResults(limit)
				.add(Restrictions.eq("concept.identifier", conceptId))
				.setFirstResult(startIndex).addOrder(Order.desc("created"))
				.list();
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see
	 * fr.mcc.ginco.dao.ISuggestionDAO#findTermPaginatedSuggestions(java.lang
	 * .String, java.lang.Integer, java.lang.Integer)
	 */
	@Override
	public List<Suggestion> findTermPaginatedSuggestions(String termId,
			Integer startIndex, Integer limit) {
		return getCurrentSession().createCriteria(Suggestion.class)
				.setMaxResults(limit)
				.add(Restrictions.eq("term.identifier", termId))
				.setFirstResult(startIndex).addOrder(Order.desc("created"))
				.list();
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see
	 * fr.mcc.ginco.dao.ISuggestionDAO#getConceptSuggestionCount(java.lang.String
	 * )
	 */
	@Override
	public Long getConceptSuggestionCount(String conceptId) {
		return (Long) getCurrentSession().createCriteria(Suggestion.class)
				.add(Restrictions.eq("concept.identifier", conceptId))
				.setProjection(Projections.rowCount()).list().get(0);
	}


	/*
	 * (non-Javadoc)
	 * 
	 * @see
	 * fr.mcc.ginco.dao.ISuggestionDAO#getTermSuggestionCount(java.lang.String)
	 */
	@Override
	public Long getTermSuggestionCount(String termId) {
		return (Long) getCurrentSession().createCriteria(Suggestion.class)
				.add(Restrictions.eq("term.identifier", termId))
				.setProjection(Projections.rowCount()).list().get(0);
	}

	/* (non-Javadoc)
	 * @see fr.mcc.ginco.dao.ISuggestionDAO#findPaginatedSuggestionsByRecipient(java.lang.String, java.lang.Integer, java.lang.Integer)
	 */
	@Override
	public List<Suggestion> findPaginatedSuggestionsByRecipient(
			String recipient, Integer startIndex, Integer limit) {
		return getCurrentSession().createCriteria(Suggestion.class)
				.setMaxResults(limit)
				.add(Restrictions.eq("recipient", recipient))
				.setFirstResult(startIndex).addOrder(Order.desc("created"))
				.list();
	}
	
	/* (non-Javadoc)
	 * @see fr.mcc.ginco.dao.ISuggestionDAO#getSuggestionsByRecipientCount(java.lang.String)
	 */
	@Override
	public Long getSuggestionsByRecipientCount(String recipient) {
		return (Long) getCurrentSession().createCriteria(Suggestion.class)
				.add(Restrictions.eq("recipient", recipient))
				.setProjection(Projections.rowCount()).list().get(0);
	}

}