/*

  * Copyright 2005-2007 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.kns.dao.impl;

 import java.lang.annotation.Annotation;

 import java.lang.reflect.Field;

 import java.lang.reflect.InvocationTargetException;

 import java.util.Collection;

 import java.util.HashMap;

 import java.util.Iterator;

 import java.util.List;

 import java.util.Map;

 import java.util.Set;

 import org.apache.commons.lang.StringUtils;

 import org.apache.ojb.broker.query.Criteria;

 import org.apache.ojb.broker.query.QueryByCriteria;

 import org.apache.ojb.broker.query.QueryFactory;

 import org.kuali.rice.kns.bo.BusinessObject;

 import org.kuali.rice.kns.bo.PersistableBusinessObject;

 import org.kuali.rice.kns.dao.BusinessObjectDao;

 import org.kuali.rice.kns.service.KNSServiceLocatorInternal;

 import org.kuali.rice.kns.service.PersistenceStructureService;

 import org.kuali.rice.kns.util.KNSPropertyConstants;

 import org.kuali.rice.kns.util.ObjectUtils;

 import org.kuali.rice.kns.util.OjbCollectionAware;

 import org.springframework.dao.DataAccessException;

 /**

  * This class is the OJB implementation of the BusinessObjectDao interface and should be used for generic business object unit

  * tests.

  */

 public class BusinessObjectDaoOjb extends PlatformAwareDaoBaseOjb implements BusinessObjectDao, OjbCollectionAware {

     private static final org.apache.log4j.Logger LOG = org.apache.log4j.Logger.getLogger(BusinessObjectDaoOjb.class);

     private PersistenceStructureService persistenceStructureService;

     /**

          * This constructs a {@link BusinessObjectDaoOjb}

          */

         public BusinessObjectDaoOjb(PersistenceStructureService persistenceStructureService) {

                 this.persistenceStructureService = persistenceStructureService;

         }

     /**

          * @see org.kuali.rice.kns.dao.BusinessObjectDao#findBySinglePrimaryKey(java.lang.Class, java.lang.Object)

          */

         public <T extends BusinessObject> T findBySinglePrimaryKey(Class<T> clazz, Object primaryKey) {

                 if (primaryKey.getClass().getName().startsWith("java.lang.")) {

                         try {

                                 return (T) getPersistenceBrokerTemplate().getObjectById(clazz, primaryKey);

                         } catch ( DataAccessException ex ) {

                             // it doesn't exist, just return null

                                 return null;

                         }

                 } else {

                         Criteria criteria = buildCriteria(primaryKey);

                 return (T) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(clazz, criteria));

                 }

         }

     /**

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#findByPrimaryKey(java.lang.Class, java.util.Map)

      */

     public <T extends BusinessObject> T findByPrimaryKey(Class<T> clazz, Map<String, ?> primaryKeys) {

         Criteria criteria = buildCriteria(primaryKeys);

         return (T) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(clazz, criteria));

     }

     /**

      * Retrieves all of the records for a given class name.

      *

      * @param clazz - the name of the object being used, either KualiCodeBase or a subclass

      * @return Collection

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#findAll(java.lang.Class)

      */

     public <T extends BusinessObject> Collection<T> findAll(Class<T> clazz) {

         return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(clazz, (Criteria) null));

     }

     /**

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#findAllOrderBy(java.lang.Class, java.lang.String, boolean)

      */

     public <T extends BusinessObject> Collection<T> findAllOrderBy(Class<T> clazz, String sortField, boolean sortAscending) {

         QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, (Criteria) null);

         if (sortAscending) {

             queryByCriteria.addOrderByAscending(sortField);

         }

         else {

             queryByCriteria.addOrderByDescending(sortField);

         }

         return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);

     }

     /**

      * This is the default impl that comes with Kuali - uses OJB.

      *

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#findMatching(java.lang.Class, java.util.Map)

      */

     public <T extends BusinessObject> Collection<T> findMatching(Class<T> clazz, Map<String, ?> fieldValues) {

         Criteria criteria = buildCriteria(fieldValues);

         return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(clazz, criteria));

     }

     /**

          * Throws an UnsupportedOperationException

          * @see org.kuali.rice.kns.dao.BusinessObjectDao#findMatching(org.kuali.rice.core.framework.persistence.jpa.criteria.Criteria)

          */

         //public <T extends BusinessObject> Collection<T> findMatching(org.kuali.rice.core.jpa.criteria.Criteria criteria) {

         //        throw new UnsupportedOperationException("OJB does not support finding matching business objects using JPA criteria");

         //}

         /**

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#findAllActive(java.lang.Class)

      */

     public <T extends BusinessObject> Collection<T> findAllActive(Class<T> clazz) {

         return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(clazz, buildActiveCriteria()));

     }

     /**

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#findAllActive(java.lang.Class)

      */

     public <T extends BusinessObject> Collection<T> findAllInactive(Class<T> clazz) {

         return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(clazz, buildInactiveCriteria()));

     }

     /**

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#findAllActiveOrderBy(java.lang.Class, java.lang.String, boolean)

      */

     public <T extends BusinessObject> Collection<T> findAllActiveOrderBy(Class<T> clazz, String sortField, boolean sortAscending) {

         QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, buildActiveCriteria());

         if (sortAscending) {

             queryByCriteria.addOrderByAscending(sortField);

         }

         else {

             queryByCriteria.addOrderByDescending(sortField);

         }

         return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);

     }

     /**

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#findMatchingActive(java.lang.Class, java.util.Map)

      */

     public <T extends BusinessObject> Collection<T> findMatchingActive(Class<T> clazz, Map<String, ?> fieldValues) {

         Criteria criteria = buildCriteria(fieldValues);

         criteria.addAndCriteria(buildActiveCriteria());

         return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(clazz, criteria));

     }

     /**

      * This is the default impl that comes with Kuali - uses OJB.

      *

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#countMatching(java.lang.Class, java.util.Map)

      */

     public int countMatching(Class clazz, Map<String, ?> fieldValues) {

         Criteria criteria = buildCriteria(fieldValues);

         return getPersistenceBrokerTemplate().getCount(QueryFactory.newQuery(clazz, criteria));

     }

     /**

      * This is the default impl that comes with Kuali - uses OJB.

      *

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#countMatching(java.lang.Class, java.util.Map, java.util.Map)

      */

     public int countMatching(Class clazz, Map<String, ?> positiveFieldValues, Map<String, ?> negativeFieldValues) {

         Criteria criteria = buildCriteria(positiveFieldValues);

         Criteria negativeCriteria = buildNegativeCriteria(negativeFieldValues);

         criteria.addAndCriteria(negativeCriteria);

         return getPersistenceBrokerTemplate().getCount(QueryFactory.newQuery(clazz, criteria));

     }

     /**

      * This is the default impl that comes with Kuali - uses OJB.

      *

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#findMatching(java.lang.Class, java.util.Map)

      */

     public <T extends BusinessObject> Collection<T> findMatchingOrderBy(Class<T> clazz, Map<String, ?> fieldValues, String sortField, boolean sortAscending) {

         Criteria criteria = buildCriteria(fieldValues);

         QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, criteria);

         if (sortAscending) {

             queryByCriteria.addOrderByAscending(sortField);

         }

         else {

             queryByCriteria.addOrderByDescending(sortField);

         }

         return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);

     }

         /**

          * Saves a business object.

          *

          * @see org.kuali.rice.kns.dao.BusinessObjectDao#save(org.kuali.rice.kns.bo.PersistableBusinessObject)

          */

         public PersistableBusinessObject save(PersistableBusinessObject bo) throws DataAccessException {

                 // if collections exist on the BO, create a copy and use to process the

                 // collections to ensure

                 // that removed elements are deleted from the database

                 Set<String> boCollections = getPersistenceStructureService().listCollectionObjectTypes(bo.getClass()).keySet();

                 PersistableBusinessObject savedBo = null;

                 if (!boCollections.isEmpty()) {

                         // refresh bo to get db copy of collections

                         savedBo = (PersistableBusinessObject) ObjectUtils.deepCopy(bo);

                         for (String boCollection : boCollections) {

                                 if (getPersistenceStructureService().isCollectionUpdatable(savedBo.getClass(), boCollection)) {

                                         savedBo.refreshReferenceObject(boCollection);

                                 }

                         }

             KNSServiceLocatorInternal.getOjbCollectionHelper().processCollections(this, bo, savedBo);

         }

                 getPersistenceBrokerTemplate().store(bo);

                 return bo;

         }

     /**

      * Saves a business object.

      *

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#save(org.kuali.rice.kns.bo.PersistableBusinessObject)

      */

     public List<? extends PersistableBusinessObject> save(List businessObjects) throws DataAccessException {

             if ( LOG.isDebugEnabled() ) {

                     LOG.debug( "About to persist the following BOs:" );

                     for ( Object bo : businessObjects ) {

                             LOG.debug( "   --->" + bo );

                     }

             }

         for (Iterator i = businessObjects.iterator(); i.hasNext();) {

             Object bo = i.next();

             getPersistenceBrokerTemplate().store(bo);

         }

         return businessObjects;

     }

     /**

      * Deletes the business object passed in.

      *

      * @param bo

      * @throws DataAccessException

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#delete(org.kuali.rice.kns.bo.PersistableBusinessObject)

      */

     public void delete(PersistableBusinessObject bo) {

         getPersistenceBrokerTemplate().delete(bo);

     }

     /**

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#delete(java.util.List)

      */

     public void delete(List<? extends PersistableBusinessObject> boList) {

         for (PersistableBusinessObject bo : boList) {

             getPersistenceBrokerTemplate().delete(bo);

         }

     }

     /**

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#deleteMatching(java.lang.Class, java.util.Map)

      */

     public void deleteMatching(Class clazz, Map<String, ?> fieldValues) {

         Criteria criteria = buildCriteria(fieldValues);

         getPersistenceBrokerTemplate().deleteByQuery(QueryFactory.newQuery(clazz, criteria));

         // An ojb delete by query doesn't update the cache so we need to clear the cache for everything to work property.

         // don't believe me? Read the source code to OJB

         getPersistenceBrokerTemplate().clearCache();

     }

     /**

      * @see org.kuali.rice.kns.dao.BusinessObjectDao#retrieve(org.kuali.rice.kns.bo.PersistableBusinessObject)

      */

     public PersistableBusinessObject retrieve(PersistableBusinessObject object) {

         return (PersistableBusinessObject) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQueryByIdentity(object));

     }

     /**

          * OJB does not support this method

          * @see org.kuali.rice.kns.dao.BusinessObjectDao#findByPrimaryKey(java.lang.Class, java.lang.Object)

          */

         public  <T extends BusinessObject> T findByPrimaryKeyUsingKeyObject(Class<T> clazz, Object pkObject) {

                 throw new UnsupportedOperationException("OJB does not support this option");

         }

         /**

          * No need to do anything - avoid saving and OJB will "manage read only"

          * @see org.kuali.rice.kns.dao.BusinessObjectDao#manageReadOnly(org.kuali.rice.kns.bo.PersistableBusinessObject)

          */

         public PersistableBusinessObject manageReadOnly(PersistableBusinessObject bo) {

                 return bo;

         }

         /**

      * This method will build out criteria in the key-value paradigm (attribute-value).

      *

      * @param fieldValues

      * @return

      */

     private Criteria buildCriteria(Map<String, ?> fieldValues) {

         Criteria criteria = new Criteria();

         for (Iterator i = fieldValues.entrySet().iterator(); i.hasNext();) {

             Map.Entry<String, Object> e = (Map.Entry<String, Object>) i.next();

             String key = e.getKey();

             Object value = e.getValue();

             if (value instanceof Collection) {

                 criteria.addIn(key, (Collection) value);

             }

             else {

                 criteria.addEqualTo(key, value);

             }

         }

         return criteria;

     }

     private Criteria buildCriteria(Object primaryKey) {

             Map<String, Object> fieldValues = new HashMap<String, Object>();

         //create map of values

             for (Field field : primaryKey.getClass().getDeclaredFields()) {

                     Object fieldValue;

                         try {

                 for (Annotation an : field.getAnnotations()) {

                     //look for class' Id fields.  This is a bit of a hack because this relies on JPA

                     //annotations existing, but removes any extra generated fields from the criteria.

                     if (an.annotationType().getName().equals("javax.persistence.Id")) {

                         fieldValue = primaryKey.getClass().getMethod("get" + StringUtils.capitalize(field.getName())).invoke(primaryKey);

                         fieldValues.put(field.getName(), fieldValue);

                         break;

                     }

                 }

                         } catch (IllegalArgumentException e) {

                                 e.printStackTrace();

                         } catch (IllegalAccessException e) {

                                 e.printStackTrace();

                         } catch (SecurityException e) {

                                 e.printStackTrace();

                         } catch (InvocationTargetException e) {

                                 e.printStackTrace();

                         } catch (NoSuchMethodException e) {

                                 e.printStackTrace();

                         }

             }

         //profit

         return this.buildCriteria(fieldValues);

     }

     /**

      * Builds a Criteria object for active field set to true

      * @return Criteria

      */

     private Criteria buildActiveCriteria(){

         Criteria criteria = new Criteria();

         criteria.addEqualTo(KNSPropertyConstants.ACTIVE, true);

         return criteria;

     }

     /**

      * Builds a Criteria object for active field set to true

      * @return Criteria

      */

     private Criteria buildInactiveCriteria(){

         Criteria criteria = new Criteria();

         criteria.addEqualTo(KNSPropertyConstants.ACTIVE, false);

         return criteria;

     }

     /**

      * This method will build out criteria in the key-value paradigm (attribute-value).

      *

      * @param negativeFieldValues

      * @return

      */

     private Criteria buildNegativeCriteria(Map<String, ?> negativeFieldValues) {

         Criteria criteria = new Criteria();

         for (Iterator i = negativeFieldValues.entrySet().iterator(); i.hasNext();) {

             Map.Entry<String, Object> e = (Map.Entry<String, Object>) i.next();

             String key = e.getKey();

             Object value = e.getValue();

             if (value instanceof Collection) {

                 criteria.addNotIn(key, (Collection) value);

             }

             else {

                 criteria.addNotEqualTo(key, value);

             }

         }

         return criteria;

     }

     /**

      * Gets the persistenceStructureService attribute.

      * @return Returns the persistenceStructureService.

      */

     protected PersistenceStructureService getPersistenceStructureService() {

         return persistenceStructureService;

     }

     /**

      * Sets the persistenceStructureService attribute value.

      * @param persistenceStructureService The persistenceStructureService to set.

      */

     public void setPersistenceStructureService(PersistenceStructureService persistenceStructureService) {

         this.persistenceStructureService = persistenceStructureService;

     }

 }