001    /*
002     * Copyright 2011 The Kuali Foundation.
003     * 
004     * Licensed under the Educational Community License, Version 2.0 (the "License");
005     * you may not use this file except in compliance with the License.
006     * You may obtain a copy of the License at
007     * 
008     * http://www.opensource.org/licenses/ecl2.php
009     * 
010     * Unless required by applicable law or agreed to in writing, software
011     * distributed under the License is distributed on an "AS IS" BASIS,
012     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
013     * See the License for the specific language governing permissions and
014     * limitations under the License.
015     */
016    package org.kuali.kfs.coa.dataaccess.impl;
017    
018    import java.util.ArrayList;
019    import java.util.Collection;
020    import java.util.Iterator;
021    import java.util.List;
022    
023    import org.apache.ojb.broker.query.Criteria;
024    import org.apache.ojb.broker.query.QueryFactory;
025    import org.kuali.kfs.coa.businessobject.ObjectCode;
026    import org.kuali.kfs.coa.dataaccess.ObjectCodeDao;
027    import org.kuali.rice.kns.dao.impl.PlatformAwareDaoBaseOjb;
028    
029    
030    /**
031     * This class is the OJB implementation of the ObjectCodeDao interface.
032     */
033    public class ObjectCodeDaoOjb extends PlatformAwareDaoBaseOjb implements ObjectCodeDao {
034        private static org.apache.log4j.Logger LOG = org.apache.log4j.Logger.getLogger(ObjectCodeDaoOjb.class);
035    
036        /**
037         * Retrieves object code business object by primary key
038         * 
039         * @see org.kuali.kfs.coa.dataaccess.ObjectCodeDao#getByPrimaryId(Integer, String, String)
040         */
041        public ObjectCode getByPrimaryId(Integer universityFiscalYear, String chartOfAccountsCode, String financialObjectCode) {
042            Criteria criteria = new Criteria();
043            criteria.addEqualTo("universityFiscalYear", universityFiscalYear);
044            criteria.addEqualTo("chartOfAccountsCode", chartOfAccountsCode);
045            criteria.addEqualTo("financialObjectCode", financialObjectCode);
046    
047            return (ObjectCode) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(ObjectCode.class, criteria));
048        }
049    
050        /**
051         * @see org.kuali.kfs.coa.dataaccess.ObjectCodeDao#getYearList(java.lang.String, java.lang.String)
052         */
053        public List getYearList(String chartOfAccountsCode, String financialObjectCode) {
054    
055            List returnList = new ArrayList();
056            Criteria criteria = new Criteria();
057            criteria.addEqualTo("chartOfAccountsCode", chartOfAccountsCode);
058            criteria.addEqualTo("financialObjectCode", financialObjectCode);
059            Collection years = getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(ObjectCode.class, criteria));
060            for (Iterator iter = years.iterator(); iter.hasNext();) {
061                ObjectCode o = (ObjectCode) iter.next();
062                if (o != null) {
063                    returnList.add(o.getUniversityFiscalYear());
064                }
065            }
066            return returnList;
067    
068    
069        }
070    }