/*
    * Copyright 2008 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.ole.module.purap.dataaccess.impl;
  
  import org.apache.ojb.broker.query.Criteria;
  import org.apache.ojb.broker.query.QueryByCriteria;
  import org.kuali.ole.module.purap.businessobject.PurchaseOrderSensitiveData;
  import org.kuali.ole.module.purap.businessobject.SensitiveData;
  import org.kuali.ole.module.purap.businessobject.SensitiveDataAssignment;
  import org.kuali.ole.module.purap.dataaccess.SensitiveDataDao;
  import org.kuali.rice.core.framework.persistence.ojb.dao.PlatformAwareDaoBaseOjb;
  
  import java.util.ArrayList;
  import java.util.Collection;
  import java.util.List;
  
  public class SensitiveDataDaoOjb extends PlatformAwareDaoBaseOjb implements SensitiveDataDao {
  
      private static org.apache.log4j.Logger LOG = org.apache.log4j.Logger.getLogger(SensitiveDataDaoOjb.class);
  
      public SensitiveDataDaoOjb() {
          super();
      }
  
      /**
       * @see org.kuali.ole.integration.service.SensitiveDataDaoe#getSensitiveDatasAssignedByPoId(java.lang.Integer)
       */
      public List<SensitiveData> getSensitiveDatasAssignedByPoId(Integer poId) {
          LOG.debug("getSensitiveDatasAssignedByPoId(Integer) started");
  
          Criteria criteria = new Criteria();
          criteria.addEqualTo("purapDocumentIdentifier", poId);
          Collection<PurchaseOrderSensitiveData> posdColl = getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(PurchaseOrderSensitiveData.class, criteria));
          List<SensitiveData> sdList = new ArrayList<SensitiveData>();
          for (PurchaseOrderSensitiveData posd : posdColl) {
              sdList.add(posd.getSensitiveData());
          }
  
          return sdList;
      }
  
      /**
       * @see org.kuali.ole.integration.service.SensitiveDataDaoe#getSensitiveDatasAssignedByReqId(java.lang.Integer)
       */
      public List<SensitiveData> getSensitiveDatasAssignedByReqId(Integer reqId) {
          LOG.debug("getSensitiveDatasAssignedByReqId(Integer) started");
  
          Criteria criteria = new Criteria();
          criteria.addEqualTo("requisitionIdentifier", reqId);
          Collection<PurchaseOrderSensitiveData> posdColl = getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(PurchaseOrderSensitiveData.class, criteria));
          List<SensitiveData> sdList = new ArrayList<SensitiveData>();
          for (PurchaseOrderSensitiveData posd : posdColl) {
              sdList.add(posd.getSensitiveData());
          }
  
          return sdList;
      }
  
      /**
       * @see org.kuali.ole.integration.service.SensitiveDataDaoe#deletePurchaseOrderSensitiveDatas(java.lang.Integer)
       */
      public void deletePurchaseOrderSensitiveDatas(Integer poId) {
          LOG.debug("deletePurchaseOrderSensitiveDatas(Integer) started");
          Criteria criteria = new Criteria();
          criteria.addEqualTo("purapDocumentIdentifier", poId);
          getPersistenceBrokerTemplate().deleteByQuery(new QueryByCriteria(PurchaseOrderSensitiveData.class, criteria));
      }
  
      /**
       * @see org.kuali.ole.integration.service.SensitiveDataDaoe#getLastSensitiveDataAssignment(java.lang.Integer)
       */
      public SensitiveDataAssignment getLastSensitiveDataAssignment(Integer poId) {
          LOG.debug("getLastSensitiveDataAssignment(Integer) started");
  
          Criteria criteria = new Criteria();
          criteria.addEqualTo("purapDocumentIdentifier", poId);
          Collection<SensitiveDataAssignment> sdaColl = getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(SensitiveDataAssignment.class, criteria));
  
          // look for the greatest assignment ID, which will be the latest one for this PO
          int max = 0;
          SensitiveDataAssignment lastsda = null;
          for (SensitiveDataAssignment sda : sdaColl) {
              if (sda.getSensitiveDataAssignmentIdentifier() >= max) {
                  max = sda.getSensitiveDataAssignmentIdentifier();
                  lastsda = sda;
              }
         }
 
         return lastsda;
     }
 
     /*
     public Integer getLastSensitiveDataAssignmentId(Integer poId) {
         LOG.debug("getLastSensitiveDataAssignmentId(Integer) started");
 
         Criteria criteria = new Criteria();
         criteria.addEqualTo("purapDocumentIdentifier", poId);
         Collection sdaColl = getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(SensitiveDataAssignment.class, criteria));
         if (sdaColl == null || sdaColl.isEmpty())
             return null;
         else {
             SensitiveDataAssignment sda = (SensitiveDataAssignment)sdaColl.toArray()[0];        
             return sda.getSensitiveDataAssignmentIdentifier();
         }
     }
     */
 
 }