org.kuali.ole.gl.batch.dataaccess.impl

Class YearEndDaoJdbc

java.lang.Object

org.springframework.dao.support.DaoSupport

org.springframework.jdbc.core.support.JdbcDaoSupport

org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport

org.kuali.rice.core.framework.persistence.jdbc.dao.PlatformAwareDaoBaseJdbc

org.kuali.ole.gl.batch.dataaccess.impl.YearEndDaoJdbc

All Implemented Interfaces:

YearEndDao, org.kuali.rice.core.framework.persistence.dao.PlatformAwareDao, org.springframework.beans.factory.InitializingBean

public class YearEndDaoJdbc
extends org.kuali.rice.core.framework.persistence.jdbc.dao.PlatformAwareDaoBaseJdbc
implements YearEndDao

A JDBC implementation of the YearEndDao, built mainly because OJB is darn slow at some queries

Field Summary

Fields

Modifier and Type	Field and Description
protected Comparator<Map<String,String>>	priorYearAccountPrimaryKeyComparator
protected org.springframework.jdbc.core.RowMapper	priorYearAccountRowMapper
protected Comparator<Map<String,String>>	subFundGroupPrimaryKeyComparator
protected org.springframework.jdbc.core.RowMapper	subFundGroupRowMapper

Fields inherited from class org.springframework.dao.support.DaoSupport

logger

Constructor Summary

Constructors

Constructor and Description
YearEndDaoJdbc()

Method Summary

Methods

Modifier and Type	Method and Description
Set<Map<String,String>>	findKeysOfMissingPriorYearAccountsForBalances(Integer balanceFiscalYear) Queries the databse to find missing prior year accounts
Set<Map<String,String>>	findKeysOfMissingPriorYearAccountsForOpenEncumbrances(Integer encumbranceFiscalYear) Queries the databsae to find missing prior year account records referred to by encumbrance records
Set<Map<String,String>>	findKeysOfMissingSubFundGroupsForBalances(Integer balanceFiscalYear) Queries the database to find missing sub fund groups
Set<Map<String,String>>	findKeysOfMissingSubFundGroupsForOpenEncumbrances(Integer encumbranceFiscalYear) Queries the database to find missing sub fund group records referred to by encumbrances
protected Set<Map<String,String>>	selectMissingPriorYearAccounts(List priorYearKeys) This method puts all of the prior year accounts that aren't in the database, based on the list of keys sent in, into the given set
protected Set<Map<String,String>>	selectMissingSubFundGroups(List subFundGroupKeys) This method puts all of the sub fund groups that are in the given list of subFundGroupKeys but aren't in the database into the given set

Methods inherited from class org.kuali.rice.core.framework.persistence.jdbc.dao.PlatformAwareDaoBaseJdbc

getDbPlatform, setDbPlatform

Methods inherited from class org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport

getSimpleJdbcTemplate, initTemplateConfig

Methods inherited from class org.springframework.jdbc.core.support.JdbcDaoSupport

checkDaoConfig, createJdbcTemplate, getConnection, getDataSource, getExceptionTranslator, getJdbcTemplate, releaseConnection, setDataSource, setJdbcTemplate

Methods inherited from class org.springframework.dao.support.DaoSupport

afterPropertiesSet, initDao

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

subFundGroupPrimaryKeyComparator

protected Comparator<Map<String,String>> subFundGroupPrimaryKeyComparator

priorYearAccountPrimaryKeyComparator

protected Comparator<Map<String,String>> priorYearAccountPrimaryKeyComparator

subFundGroupRowMapper

protected org.springframework.jdbc.core.RowMapper subFundGroupRowMapper

priorYearAccountRowMapper

protected org.springframework.jdbc.core.RowMapper priorYearAccountRowMapper

Constructor Detail

YearEndDaoJdbc

public YearEndDaoJdbc()

Method Detail

findKeysOfMissingPriorYearAccountsForBalances

public Set<Map<String,String>> findKeysOfMissingPriorYearAccountsForBalances(Integer balanceFiscalYear)

Queries the databse to find missing prior year accounts

Specified by:

findKeysOfMissingPriorYearAccountsForBalances in interface YearEndDao

Parameters:

balanceFiscalyear - the fiscal year of balances to check for missing prior year accounts for

Returns:

a Set of Maps holding the primary keys of missing prior year accounts

See Also:

YearEndDao.findKeysOfMissingPriorYearAccountsForBalances(java.lang.Integer)

selectMissingPriorYearAccounts

protected Set<Map<String,String>> selectMissingPriorYearAccounts(List priorYearKeys)

This method puts all of the prior year accounts that aren't in the database, based on the list of keys sent in, into the given set

Parameters:

priorYearKeys - the prior year keys to search for

Returns:

the set of those prior year accounts that are missing

findKeysOfMissingSubFundGroupsForBalances

public Set<Map<String,String>> findKeysOfMissingSubFundGroupsForBalances(Integer balanceFiscalYear)

Queries the database to find missing sub fund groups

Specified by:

findKeysOfMissingSubFundGroupsForBalances in interface YearEndDao

Parameters:

balanceFiscalYear - the fiscal year of the balance to find missing sub fund groups for

Returns:

a Set of Maps holding the primary keys of missing sub fund groups

See Also:

YearEndDao.findKeysOfMissingSubFundGroupsForBalances(java.lang.Integer)

selectMissingSubFundGroups

protected Set<Map<String,String>> selectMissingSubFundGroups(List subFundGroupKeys)

This method puts all of the sub fund groups that are in the given list of subFundGroupKeys but aren't in the database into the given set

Parameters:

subFundGroupKeys - the list of sub fund group keys to search through

Returns:

a set of those sub fund group keys that are missing

findKeysOfMissingPriorYearAccountsForOpenEncumbrances

public Set<Map<String,String>> findKeysOfMissingPriorYearAccountsForOpenEncumbrances(Integer encumbranceFiscalYear)

Queries the databsae to find missing prior year account records referred to by encumbrance records

Specified by:

findKeysOfMissingPriorYearAccountsForOpenEncumbrances in interface YearEndDao

Parameters:

encumbranceFiscalYear - the fiscal year of balances to find missing encumbrance records for

Returns:

a Set of Maps holding the primary keys of missing prior year accounts

See Also:

YearEndDao.findKeysOfMissingPriorYearAccountsForOpenEncumbrances(java.lang.Integer)

findKeysOfMissingSubFundGroupsForOpenEncumbrances

public Set<Map<String,String>> findKeysOfMissingSubFundGroupsForOpenEncumbrances(Integer encumbranceFiscalYear)

Queries the database to find missing sub fund group records referred to by encumbrances

Specified by:

findKeysOfMissingSubFundGroupsForOpenEncumbrances in interface YearEndDao

Parameters:

encumbranceFiscalYear - the fiscal year of encumbrances to find missing sub fund group records for

Returns:

a Set of Maps holding the primary keys of missing sub fund group records

See Also:

YearEndDao.findKeysOfMissingSubFundGroupsForOpenEncumbrances(java.lang.Integer)