/*
* The Kuali Financial System, a comprehensive financial management system for higher education.
*
* Copyright 2005-2014 The Kuali Foundation
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero 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 Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
package org.kuali.kfs.module.purap.dataaccess.impl;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import org.apache.ojb.broker.query.Criteria;
import org.apache.ojb.broker.query.QueryByCriteria;
import org.kuali.kfs.module.purap.businessobject.PurchaseOrderSensitiveData;
import org.kuali.kfs.module.purap.businessobject.SensitiveData;
import org.kuali.kfs.module.purap.businessobject.SensitiveDataAssignment;
import org.kuali.kfs.module.purap.dataaccess.SensitiveDataDao;
import org.kuali.rice.core.framework.persistence.ojb.dao.PlatformAwareDaoBaseOjb;
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.kfs.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.kfs.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.kfs.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.kfs.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();
}
}
*/
}