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

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.AccountBalanceDaoJdbcBase
                      org.kuali.kfs.gl.dataaccess.impl.AccountBalanceConsolidationDaoJdbc

All Implemented Interfaces:

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

public class AccountBalanceConsolidationDaoJdbc
extends AccountBalanceDaoJdbcBase
implements AccountBalanceConsolidationDao

A class to do the database queries needed to calculate Balance By Consolidation Balance Inquiry Screen

Field Summary

Fields inherited from class org.kuali.kfs.gl.dataaccess.impl.AccountBalanceDaoJdbcBase

optionsService, universityDateService

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

logger

Constructor Summary

AccountBalanceConsolidationDaoJdbc()

Method Summary

List<Map<String,Object>>	findAccountBalanceByConsolidationObjectTypes(String[] objectTypes, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, boolean isExcludeCostShare, boolean isConsolidated, int pendingEntriesCode) Returns account balance information that qualifies, based on the inquiry formed out of the parameters
protected boolean	getMatchingPendingEntriesByConsolidation(String[] objectTypes, SystemOptions options, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, boolean isCostShareExcluded, int pendingEntriesCode, String sessionId) Finds whether pending entries exist that would change the results of this inquiry
protected void	summarizePendingEntriesByConsolidation(SystemOptions options, String sessionId) This method summarizes pending entries to temporary tables for easier inclusion into the inquiry

Methods inherited from class org.kuali.kfs.gl.dataaccess.impl.AccountBalanceDaoJdbcBase

clearTempTable, fixPendingEntryDisplay, getOptionsService, getUniversityDateService, hasEntriesInPendingTable, inString, purgeCostShareEntries, setOptionsService, setUniversityDateService

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

Constructor Detail

AccountBalanceConsolidationDaoJdbc

public AccountBalanceConsolidationDaoJdbc()

Method Detail

findAccountBalanceByConsolidationObjectTypes

public List<Map<String,Object>> findAccountBalanceByConsolidationObjectTypes(String[] objectTypes,
                                                                             Integer universityFiscalYear,
                                                                             String chartOfAccountsCode,
                                                                             String accountNumber,
                                                                             boolean isExcludeCostShare,
                                                                             boolean isConsolidated,
                                                                             int pendingEntriesCode)

Returns account balance information that qualifies, based on the inquiry formed out of the parameters

Specified by:

findAccountBalanceByConsolidationObjectTypes in interface AccountBalanceConsolidationDao

Parameters:

objectTypes - the object types of account balances to include in the inquiry

universityFiscalYear - the fiscal year of account balances to include in the inquiry

chartOfAccountsCode - the chart of accounts of account balances to include in the inquiry

accountNumber - the account number of account balances to include in the inquiry

isExcludeCostShare - whether to exclude cost share entries from this inquiry or not

isConsolidated - whether the results of the inquiry should be consolidated

pendingEntriesCode - whether the inquiry should also report results based on no pending entries, approved pending entries, or all pending entries

Returns:

a List of Maps with the report information from this inquiry

See Also:

AccountBalanceConsolidationDao.findAccountBalanceByConsolidationObjectTypes(java.lang.String[], java.lang.Integer, java.lang.String, java.lang.String, boolean, boolean, int)

getMatchingPendingEntriesByConsolidation

protected boolean getMatchingPendingEntriesByConsolidation(String[] objectTypes,
                                                           SystemOptions options,
                                                           Integer universityFiscalYear,
                                                           String chartOfAccountsCode,
                                                           String accountNumber,
                                                           boolean isCostShareExcluded,
                                                           int pendingEntriesCode,
                                                           String sessionId)

Finds whether pending entries exist that would change the results of this inquiry

Parameters:

objectTypes - the object types to search for

options - the options table for the fiscal year being inquiring on

universityFiscalYear - the university fiscal year of account balances being inquired upon

chartOfAccountsCode - the chart of accounts of account balances being inquired upon

accountNumber - the account number of account balances being inquired upon

isCostShareExcluded - whether cost share entries should be excluded

pendingEntriesCode - is the inquiry for no pending entries, approved pending entries, or all pending entries

sessionId - the unique session id of the web session of the currently inquiring users, so temp table entries have a unique identifier

Returns:

true if pending entries exist that would affect this inquiry, false otherwise

summarizePendingEntriesByConsolidation

protected void summarizePendingEntriesByConsolidation(SystemOptions options,
                                                      String sessionId)

This method summarizes pending entries to temporary tables for easier inclusion into the inquiry

Parameters:

options - the system options of the fiscal year that is being inquired upon

sessionId - the session id of the inquiring user, for a unique primary key in the temporary tables