/*******************************************************************************
 * Australian National University Data Commons
 * Copyright (C) 2013  The Australian National University
 * 
 * This file is part of Australian National University Data Commons.
 * 
 * Australian National University Data Commons is free software: you
 * can redistribute it and/or modify it under the terms of the GNU
 * General Public License as published by the Free Software Foundation,
 * either version 3 of the License, or (at your option) any later
 * version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 ******************************************************************************/

package au.edu.anu.datacommons.data.db.dao;

import javax.persistence.EntityManager;
import javax.persistence.Query;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import au.edu.anu.datacommons.collectionrequest.Question;
import au.edu.anu.datacommons.collectionrequest.QuestionMap;
import au.edu.anu.datacommons.data.db.PersistenceManager;

/**
 * QuestionMapDAOImpl
 * 
 * Australian National University Data Commons
 * 
 * Placeholder
 *
 * JUnit Coverage:
 * None
 * 
 * <pre>
 * Version	Date		Developer				Description
 * 0.1		04/04/2013	Genevieve Turner (GT)	Initial
 * </pre>
 *
 */
public class QuestionMapDAOImpl extends GenericDAOImpl<QuestionMap, Long> implements
		QuestionMapDAO {
	static final Logger LOGGER = LoggerFactory.getLogger(QuestionMapDAOImpl.class);
	
	private static final String fedoraObjectQueryStr = "SELECT qm FROM QuestionMap qm WHERE qm.pid = :pid AND qm.question = :question";
	private static final String groupQueryStr = "SELECT qm FROM QuestionMap qm WHERE qm.group.id = :groupId AND qm.question = :question";
	private static final String domainQueryStr = "SELECT qm FROM QuestionMap qm WHERE qm.domain.id = :domainId AND qm.question = :question";

	/**
	 * Constructor
	 * 
	 * Constructor class that includes the type
	 * 
	 * <pre>
	 * Version	Date		Developer				Description
	 * 0.1		29/06/2012	Genevieve Turner(GT)	Initial
	 * </pre>
	 */
	public QuestionMapDAOImpl() {
		super(QuestionMap.class);
	}
	
	/**
	 * getSingleByPidAndQuestion
	 *
	 * Retrieves a QuestionMap with the given pid and question
	 *
	 * <pre>
	 * Version	Date		Developer				Description
	 * 0.1		29/06/2012	Genevieve Turner(GT)	Initial
	 * </pre>
	 * 
	 * @param pid The pid of the fedora object to retrieve the QuestionMap
	 * @param question The question to retrieve the question map for
	 * @return The question map
	 * @see au.edu.anu.datacommons.data.db.dao.QuestionMapDAO#getSingleByPidAndQuestion(java.lang.String, au.edu.anu.datacommons.collectionrequest.Question)
	 */
	public QuestionMap getSingleByPidAndQuestion(String pid, Question question) {
		EntityManager entityManager = PersistenceManager.getEntityManagerFactory().createEntityManager();
		
		//Query query = entityManager.createQuery("SELECT qm FROM QuestionMap qm WHERE qm.pid = :pid AND qm.question = :question", QuestionMap.class);
		Query query = entityManager.createQuery(fedoraObjectQueryStr, QuestionMap.class);
		query.setParameter("pid", pid);
		query.setParameter("question", question);
		
		QuestionMap questionMap = (QuestionMap) query.getSingleResult();
		
		return questionMap;
	}
	
	/**
	 * getSingleByObjectAndQuestion
	 * 
	 * Retrieve the QuestionMap with the given pid, group or domain
	 *
	 * <pre>
	 * Version	Date		Developer				Description
	 * X.X		04/04/2013	Genevieve Turner(GT)	Initial
	 * </pre>
	 * 
	 * @param question The question to retrieve the map for
	 * @param pid The pid to potentially retrieve the map for
	 * @param groupId The group to potentially retrieve the map for
	 * @param domainId The domain to potentially retrieve the map for
	 * @return The question map for the given information
	 * @see au.edu.anu.datacommons.data.db.dao.QuestionMapDAO#getSingleByObjectAndQuestion(au.edu.anu.datacommons.collectionrequest.Question, java.lang.String, java.lang.Long, java.lang.Long)
	 */
	public QuestionMap getSingleByObjectAndQuestion(Question question, String pid, Long groupId, Long domainId) {
		EntityManager entityManager = PersistenceManager.getEntityManagerFactory().createEntityManager();
		QuestionMap questionMap = null;
		try {
			if (pid != null && pid.trim().length() > 0) {
				Query query = entityManager.createQuery(fedoraObjectQueryStr, QuestionMap.class);
				query.setParameter("pid", pid);
				query.setParameter("question", question);
				questionMap = (QuestionMap) query.getSingleResult();
			}
			else if (groupId != null) {
				Query query = entityManager.createQuery(groupQueryStr, QuestionMap.class);
				query.setParameter("groupId", groupId);
				query.setParameter("question", question);
				questionMap = (QuestionMap) query.getSingleResult();
			}
			else if (domainId != null) {
				Query query = entityManager.createQuery(domainQueryStr);
				query.setParameter("domainId", domainId);
				query.setParameter("question", question);
				questionMap = (QuestionMap) query.getSingleResult();
			}
		}
		finally {
			entityManager.close();
		}
		
		return questionMap;
	}
}