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.List;
019    
020    import org.apache.ojb.broker.query.Criteria;
021    import org.apache.ojb.broker.query.QueryByCriteria;
022    import org.apache.ojb.broker.query.QueryFactory;
023    import org.kuali.kfs.coa.businessobject.OrganizationReversion;
024    import org.kuali.kfs.coa.businessobject.OrganizationReversionCategory;
025    import org.kuali.kfs.coa.dataaccess.OrganizationReversionDao;
026    import org.kuali.rice.kns.dao.impl.PlatformAwareDaoBaseOjb;
027    
028    /**
029     * This class implements the {@link OrganizationReversionDao} data access methods using Ojb
030     */
031    public class OrganizationReversionDaoOjb extends PlatformAwareDaoBaseOjb implements OrganizationReversionDao {
032        private static org.apache.log4j.Logger LOG = org.apache.log4j.Logger.getLogger(OrganizationReversionDaoOjb.class);
033    
034        /**
035         * @see org.kuali.kfs.coa.dataaccess.OrganizationReversionDao#getByPrimaryId(java.lang.Integer, java.lang.String,
036         *      java.lang.String)
037         */
038        public OrganizationReversion getByPrimaryId(Integer universityFiscalYear, String financialChartOfAccountsCode, String organizationCode) {
039            LOG.debug("getByPrimaryId() started");
040    
041            Criteria criteria = new Criteria();
042            criteria.addEqualTo("universityFiscalYear", universityFiscalYear);
043            criteria.addEqualTo("chartOfAccountsCode", financialChartOfAccountsCode);
044            criteria.addEqualTo("organizationCode", organizationCode);
045    
046            return (OrganizationReversion) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(OrganizationReversion.class, criteria));
047        }
048    
049        /**
050         * @see org.kuali.kfs.coa.dataaccess.OrganizationReversionDao#getCategories()
051         */
052        public List<OrganizationReversionCategory> getCategories() {
053            LOG.debug("getCategories() started");
054    
055            Criteria criteria = new Criteria();
056            criteria.addEqualTo("active", true);
057            QueryByCriteria q = QueryFactory.newQuery(OrganizationReversionCategory.class, criteria);
058            q.addOrderByAscending("organizationReversionSortCode");
059    
060            return (List) getPersistenceBrokerTemplate().getCollectionByQuery(q);
061        }
062    }