001/*
002 * Copyright 2005-2006 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 */
016package org.kuali.ole.sys.dataaccess.impl;
017
018import java.sql.Date;
019import java.util.Collection;
020
021import org.apache.ojb.broker.query.Criteria;
022import org.apache.ojb.broker.query.QueryByCriteria;
023import org.apache.ojb.broker.query.QueryFactory;
024import org.apache.ojb.broker.query.ReportQueryByCriteria;
025import org.kuali.ole.sys.OLEPropertyConstants;
026import org.kuali.ole.sys.businessobject.UniversityDate;
027import org.kuali.ole.sys.dataaccess.UniversityDateDao;
028import org.kuali.rice.core.framework.persistence.ojb.dao.PlatformAwareDaoBaseOjb;
029
030/**
031 * The OJB implementation of the UniversityDateDao
032 */
033public class UniversityDateDaoOjb extends PlatformAwareDaoBaseOjb implements UniversityDateDao {
034    private static final org.apache.log4j.Logger LOG = org.apache.log4j.Logger.getLogger(UniversityDateDaoOjb.class);
035
036    /**
037     * Converts a java.util.Date to a java.sql.Date
038     * 
039     * @param date a java.util.Date to convert
040     * @return a java.sql.Date
041     */
042    protected java.sql.Date convertDate(java.util.Date date) {
043        return new Date(date.getTime());
044    }
045
046    /**
047     * Returns the last university date for a given fiscal year
048     * 
049     * @param fiscalYear the fiscal year to find the last date for
050     * @return a UniversityDate record for the last day in the given fiscal year, or null if nothing can be found
051     * @see org.kuali.ole.sys.dataaccess.UniversityDateDao#getLastFiscalYearDate(java.lang.Integer)
052     */
053    @Override
054    public UniversityDate getLastFiscalYearDate(Integer fiscalYear) {
055        ReportQueryByCriteria subQuery;
056        Criteria subCrit = new Criteria();
057        Criteria crit = new Criteria();
058
059        subCrit.addEqualTo(OLEPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear);
060        subQuery = QueryFactory.newReportQuery(UniversityDate.class, subCrit);
061        subQuery.setAttributes(new String[] { "max(univ_dt)" });
062
063        crit.addGreaterOrEqualThan(OLEPropertyConstants.UNIVERSITY_DATE, subQuery);
064
065        QueryByCriteria qbc = QueryFactory.newQuery(UniversityDate.class, crit);
066
067        return (UniversityDate) getPersistenceBrokerTemplate().getObjectByQuery(qbc);
068    }
069
070    /**
071     * Returns the first university date for a given fiscal year
072     * 
073     * @param fiscalYear the fiscal year to find the first date for
074     * @return a UniversityDate record for the first day of the given fiscal year, or null if nothing can be found
075     * @see org.kuali.ole.sys.dataaccess.UniversityDateDao#getFirstFiscalYearDate(java.lang.Integer)
076     */
077    @Override
078    public UniversityDate getFirstFiscalYearDate(Integer fiscalYear) {
079        ReportQueryByCriteria subQuery;
080        Criteria subCrit = new Criteria();
081        Criteria crit = new Criteria();
082
083        subCrit.addEqualTo(OLEPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear);
084        subQuery = QueryFactory.newReportQuery(UniversityDate.class, subCrit);
085        subQuery.setAttributes(new String[] { "min(univ_dt)" });
086
087        crit.addGreaterOrEqualThan(OLEPropertyConstants.UNIVERSITY_DATE, subQuery);
088
089        QueryByCriteria qbc = QueryFactory.newQuery(UniversityDate.class, crit);
090
091        return (UniversityDate) getPersistenceBrokerTemplate().getObjectByQuery(qbc);
092    }
093
094}