org.kuali.kfs.gl.dataaccess.impl
Class BalancingDaoJdbc

java.lang.Object
  org.springframework.dao.support.DaoSupport
      org.springframework.jdbc.core.support.JdbcDaoSupport
          org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport
              org.kuali.rice.kns.dao.jdbc.PlatformAwareDaoBaseJdbc
                  org.kuali.kfs.gl.dataaccess.impl.BalancingDaoJdbc

All Implemented Interfaces:

BalancingDao, LedgerBalancingDao, org.kuali.rice.kns.dao.PlatformAwareDao, org.springframework.beans.factory.InitializingBean

Direct Known Subclasses:

LaborBalancingDaoJdbc

public class BalancingDaoJdbc
extends org.kuali.rice.kns.dao.jdbc.PlatformAwareDaoBaseJdbc
implements BalancingDao, LedgerBalancingDao

JDBC implementation of BalancingDao and LedgerBalancingDao. This essentially is a copy of one table to another with group by in some cases. Hence the idea is that JDBC is much faster in this case then creating BO objects that are essentially not necessary.

Field Summary

protected static String	ACCOUNT_BALANCE_AMOUNT_FIELDS
protected static String	ACCOUNT_BALANCE_KEY_FIELDS
protected static String	BALANCE_AMOUNT_FIELDS
protected static String	BALANCE_KEY_FIELDS
protected static String	BALANCE_MONTH_AMOUNT_FIELDS
protected static String	ENCUMBRANCE_AMOUNT_FIELDS
protected static String	ENCUMBRANCE_KEY_FIELDS
protected static String	ENTRY_KEY_FIELDS
protected static String	ROW_COUNT
protected static String	VER_NBR

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

logger

Constructor Summary

BalancingDaoJdbc()

Method Summary

int	populateAccountBalancesHistory(Integer universityFiscalYear) Populates AccountBalancesHistory with AccountBalances data based on the start fiscal year passed in
int	populateEncumbranceHistory(Integer universityFiscalYear) Populates EncumbranceHistory with Encumbrance data based on the start fiscal year passed in
int	populateLedgerBalanceHistory(Integer universityFiscalYear) Populates LedgerBalanceHistory with Balance (or LaborBalance) data based on the start fiscal year passed in
int	populateLedgerEntryHistory(Integer universityFiscalYear) Populates LedgerEntryHistory with Entry (or LaborEntry) data based on the start fiscal year passed in

Methods inherited from class org.kuali.rice.kns.dao.jdbc.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

VER_NBR

protected static final String VER_NBR

See Also:

Constant Field Values

ROW_COUNT

protected static final String ROW_COUNT

See Also:

Constant Field Values

ENTRY_KEY_FIELDS

protected static final String ENTRY_KEY_FIELDS

See Also:

Constant Field Values

BALANCE_KEY_FIELDS

protected static final String BALANCE_KEY_FIELDS

See Also:

Constant Field Values

BALANCE_AMOUNT_FIELDS

protected static final String BALANCE_AMOUNT_FIELDS

See Also:

Constant Field Values

BALANCE_MONTH_AMOUNT_FIELDS

protected static final String BALANCE_MONTH_AMOUNT_FIELDS

See Also:

Constant Field Values

ACCOUNT_BALANCE_KEY_FIELDS

protected static final String ACCOUNT_BALANCE_KEY_FIELDS

See Also:

Constant Field Values

ACCOUNT_BALANCE_AMOUNT_FIELDS

protected static final String ACCOUNT_BALANCE_AMOUNT_FIELDS

See Also:

Constant Field Values

ENCUMBRANCE_KEY_FIELDS

protected static final String ENCUMBRANCE_KEY_FIELDS

See Also:

Constant Field Values

ENCUMBRANCE_AMOUNT_FIELDS

protected static final String ENCUMBRANCE_AMOUNT_FIELDS

See Also:

Constant Field Values

Constructor Detail

BalancingDaoJdbc

public BalancingDaoJdbc()

Method Detail

populateLedgerEntryHistory

public int populateLedgerEntryHistory(Integer universityFiscalYear)

Description copied from interface: LedgerBalancingDao

Populates LedgerEntryHistory with Entry (or LaborEntry) data based on the start fiscal year passed in

Specified by:

populateLedgerEntryHistory in interface LedgerBalancingDao

Parameters:

universityFiscalYear - fiscal year the populate should start from

Returns:

number of rows affected

See Also:

LedgerBalancingDao.populateLedgerEntryHistory(java.lang.Integer)

populateLedgerBalanceHistory

public int populateLedgerBalanceHistory(Integer universityFiscalYear)

Description copied from interface: LedgerBalancingDao

Populates LedgerBalanceHistory with Balance (or LaborBalance) data based on the start fiscal year passed in

Specified by:

populateLedgerBalanceHistory in interface LedgerBalancingDao

Parameters:

universityFiscalYear - fiscal year the populate should start from

Returns:

number of rows affected

See Also:

LedgerBalancingDao.populateLedgerBalanceHistory(java.lang.Integer)

populateAccountBalancesHistory

public int populateAccountBalancesHistory(Integer universityFiscalYear)

Description copied from interface: BalancingDao

Populates AccountBalancesHistory with AccountBalances data based on the start fiscal year passed in

Specified by:

populateAccountBalancesHistory in interface BalancingDao

Parameters:

universityFiscalYear - fiscal year the populate should start from

Returns:

number of rows affected

See Also:

BalancingDao.populateAccountBalancesHistory(java.lang.Integer)

populateEncumbranceHistory

public int populateEncumbranceHistory(Integer universityFiscalYear)

Description copied from interface: BalancingDao

Populates EncumbranceHistory with Encumbrance data based on the start fiscal year passed in

Specified by:

populateEncumbranceHistory in interface BalancingDao

Parameters:

universityFiscalYear - fiscal year the populate should start from

Returns:

number of rows affected

See Also:

BalancingDao.populateEncumbranceHistory(java.lang.Integer)