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.module.ar.dataaccess.impl;
017    
018    import org.apache.ojb.broker.query.Criteria;
019    import org.apache.ojb.broker.query.QueryFactory;
020    import org.kuali.kfs.module.ar.businessobject.SystemInformation;
021    import org.kuali.kfs.module.ar.dataaccess.SystemInformationDao;
022    import org.kuali.rice.kns.dao.impl.PlatformAwareDaoBaseOjb;
023    
024    public class SystemInformationDaoOjb extends PlatformAwareDaoBaseOjb implements SystemInformationDao {
025    
026        private static org.apache.log4j.Logger LOG = org.apache.log4j.Logger.getLogger(SystemInformationDaoOjb.class);
027    
028        public SystemInformation getByLockboxNumber(String lockboxNumber, Integer universityFiscalYear) {
029            LOG.debug("getByLockboxNumber() started");
030            
031            Criteria criteria = new Criteria();
032            criteria.addEqualTo("universityFiscalYear", universityFiscalYear);
033            criteria.addEqualTo("lockboxNumber", lockboxNumber);
034            
035            return (SystemInformation) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(SystemInformation.class, criteria));
036        }
037        
038        public SystemInformation getByProcessingChartOrgAndFiscalYear(String chartCode, String orgCode, Integer fiscalYear) {
039            Criteria criteria = new Criteria();
040            criteria.addEqualTo("universityFiscalYear", fiscalYear);
041            criteria.addEqualTo("processingChartOfAccountCode", chartCode);
042            criteria.addEqualTo("processingOrganizationCode", orgCode);
043            return (SystemInformation) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(SystemInformation.class, criteria));
044        }
045        
046        public int getCountByChartOrgAndLockboxNumber(String processingChartCode, String processingOrgCode, String lockboxNumber) {
047            Criteria criteria = new Criteria();
048            criteria.addEqualTo("lockboxNumber", lockboxNumber);
049            criteria.addNotEqualTo("processingChartOfAccountCode", processingChartCode);
050            criteria.addNotEqualTo("processingOrganizationCode", processingOrgCode);
051            return getPersistenceBrokerTemplate().getCount(QueryFactory.newQuery(SystemInformation.class, criteria));        
052        }
053        
054    }