/*
    * Copyright 2007-2009 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.opensource.org/licenses/ecl2.php
    *
   * 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.rice.kew.docsearch.dao.impl;
  
  import java.math.BigDecimal;
  import java.sql.Timestamp;
  import java.util.ArrayList;
  import java.util.List;
  
  import javax.persistence.EntityManager;
  import javax.persistence.PersistenceContext;
  import javax.persistence.Query;
  
  import org.kuali.rice.kew.docsearch.SearchableAttributeDateTimeValue;
  import org.kuali.rice.kew.docsearch.SearchableAttributeFloatValue;
  import org.kuali.rice.kew.docsearch.SearchableAttributeLongValue;
  import org.kuali.rice.kew.docsearch.SearchableAttributeStringValue;
  import org.kuali.rice.kew.docsearch.dao.SearchableAttributeDAO;
  
  /**
   * JPA implementation of SearchableAttributeDAO
   *
   * @author Kuali Rice Team (rice.collab@kuali.org)
   *
   */
  public class SearchableAttributeDAOJpaImpl implements SearchableAttributeDAO {
  
  	@PersistenceContext(unitName = "kew-unit")
  	private EntityManager entityManager;
  
  	/**
  	 * This overridden method queries the SearchableAttributeDateTimeValue persistence class
  	 *
  	 * @see org.kuali.rice.kew.docsearch.dao.SearchableAttributeDAO#getSearchableAttributeDateTimeValuesByKey(java.lang.Long,
  	 *      java.lang.String)
  	 */
  	public List<Timestamp> getSearchableAttributeDateTimeValuesByKey(
  			Long documentId, String key) {
  
  		List<Timestamp> lRet = null;
  		Query query = entityManager.createNamedQuery("SearchableAttributeDateTimeValue.FindByKey");
          query.setParameter("routeHeaderId", documentId);
          query.setParameter("searchableAttributeKey", key);
          List<SearchableAttributeDateTimeValue> results = query.getResultList();
          if (!results.isEmpty()) {
          	lRet = new ArrayList<Timestamp>();
              for (SearchableAttributeDateTimeValue attribute: results) {
              	lRet.add(attribute.getSearchableAttributeValue());
              }
          }
  		return lRet;
  	}
  
  	/**
  	 * This overridden method queries the SearchableAttributeFloatValue persistence class
  	 *
  	 * @see org.kuali.rice.kew.docsearch.dao.SearchableAttributeDAO#getSearchableAttributeFloatValuesByKey(java.lang.Long,
  	 *      java.lang.String)
  	 */
  	public List<BigDecimal> getSearchableAttributeFloatValuesByKey(
  			Long documentId, String key) {
  		List<BigDecimal> lRet = null;
  		Query query = entityManager.createNamedQuery("SearchableAttributeFloatValue.FindByKey");
          query.setParameter("routeHeaderId", documentId);
          query.setParameter("searchableAttributeKey", key);
          List<SearchableAttributeFloatValue> results = query.getResultList();
          if (!results.isEmpty()) {
          	lRet = new ArrayList<BigDecimal>();
              for (SearchableAttributeFloatValue attribute: results) {
              	lRet.add(attribute.getSearchableAttributeValue());
              }
          }
  		return lRet;
  	}
  
  	/**
  	 * This overridden method queries the searchableAttributeKey persistence class
  	 *
  	 * @see org.kuali.rice.kew.docsearch.dao.SearchableAttributeDAO#getSearchableAttributeLongValuesByKey(java.lang.Long,
  	 *      java.lang.String)
  	 */
  	public List<Long> getSearchableAttributeLongValuesByKey(Long documentId,
  			String key) {
  		List<Long> lRet = null;
  		Query query = entityManager.createNamedQuery("SearchableAttributeLongValue.FindByKey");
          query.setParameter("routeHeaderId", documentId);
         query.setParameter("searchableAttributeKey", key);
         List<SearchableAttributeLongValue> results = query.getResultList();
         if (!results.isEmpty()) {
         	lRet = new ArrayList<Long>();
             for (SearchableAttributeLongValue attribute: results) {
             	lRet.add(attribute.getSearchableAttributeValue());
             }
         }
 		return lRet;
 	}
 
 	/**
 	 * This overridden method queries the SearchableAttributeStringValue persistence class
 	 *
 	 * @see org.kuali.rice.kew.docsearch.dao.SearchableAttributeDAO#getSearchableAttributeStringValuesByKey(java.lang.Long,
 	 *      java.lang.String)
 	 */
 	public List<String> getSearchableAttributeStringValuesByKey(
 			Long documentId, String key) {
 		List<String> lRet = null;
 		Query query = entityManager.createNamedQuery("SearchableAttributeStringValue.FindByKey");
         query.setParameter("routeHeaderId", documentId);
         query.setParameter("searchableAttributeKey", key);
         List<SearchableAttributeStringValue> results = query.getResultList();
         if (!results.isEmpty()) {
         	lRet = new ArrayList<String>();
             for (SearchableAttributeStringValue attribute: results) {
             	lRet.add(attribute.getSearchableAttributeValue());
             }
         }
 		return lRet;
 	}
 
     public EntityManager getEntityManager() {
         return this.entityManager;
     }
 
     public void setEntityManager(EntityManager entityManager) {
         this.entityManager = entityManager;
     }
 
 }