org.kuali.ole.gl.dataaccess.impl

Class AccountBalanceLevelDaoJdbc

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.dataaccess.impl.AccountBalanceDaoJdbcBase

org.kuali.ole.gl.dataaccess.impl.AccountBalanceLevelDaoJdbc

All Implemented Interfaces:

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

public class AccountBalanceLevelDaoJdbc
extends AccountBalanceDaoJdbcBase
implements AccountBalanceLevelDao

Calculate Balance By Level Balance Inquiry Screen

Field Summary

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

logger

Constructor Summary

Constructors

Constructor and Description
AccountBalanceLevelDaoJdbc()

Method Summary

Methods

Modifier and Type	Method and Description
List	findAccountBalanceByLevel(Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String financialConsolidationObjectCode, boolean isCostShareExcluded, boolean isConsolidated, int pendingEntriesCode, UniversityDate today, SystemOptions options) Summarizes all of the qualifying account balance information for the balance by level inquiry
protected boolean	getMatchingPendingEntriesByLevel(SystemOptions options, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String financialConsolidationObjectCode, boolean isCostShareExcluded, int pendingEntriesCode, String sessionId, UniversityDate today) Fetches pending entries summarized by level matching the keys passed in as parameter, and then saves those summaries in a temporary table
protected void	summarizePendingEntriesByLevel(SystemOptions options, String sessionId) Summarizes all pending entries by level, so they can be added to the general query if necessary

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

clearTempTable, fixPendingEntryDisplay, hasEntriesInPendingTable, inString, purgeCostShareEntries

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

Constructor Detail

AccountBalanceLevelDaoJdbc

public AccountBalanceLevelDaoJdbc()

Method Detail

findAccountBalanceByLevel

public List findAccountBalanceByLevel(Integer universityFiscalYear,
                             String chartOfAccountsCode,
                             String accountNumber,
                             String financialConsolidationObjectCode,
                             boolean isCostShareExcluded,
                             boolean isConsolidated,
                             int pendingEntriesCode,
                             UniversityDate today,
                             SystemOptions options)

Summarizes all of the qualifying account balance information for the balance by level inquiry

Specified by:

findAccountBalanceByLevel in interface AccountBalanceLevelDao

Parameters:

universityFiscalYear - the university fiscal year of reported on account balances

chartOfAccountsCode - the chart of accounts code of reported on account balances

accountNumber - the account number of reported on account balances

financialConsolidationObjectCode - the consolidation code of reported on account balances

isCostShareExcluded - whether cost share account balances should be excluded from the query or not

isConsolidated - whether the results of the query should be consolidated

pendingEntriesCode - whether this query should account for no pending entries, approved pending entries, or all pending entries

today - the current university date

options - system options

Returns:

a List of Maps with appropriate report data

See Also:

org.kuali.ole.gl.dataaccess.AccountBalanceLevelDao#findAccountBalanceByLevel(java.lang.Integer, java.lang.String, java.lang.String, java.lang.String, boolean, boolean, int, org.kuali.ole.sys.businessobject.UniversityDate, org.kuali.ole.sys.businessobject.SystemOptions)

summarizePendingEntriesByLevel

protected void summarizePendingEntriesByLevel(SystemOptions options,
                                  String sessionId)

Summarizes all pending entries by level, so they can be added to the general query if necessary

Parameters:

options - a given set of system options

sessionId - the unique web id of the currently inquiring user, which acts as a key for the temporary table

getMatchingPendingEntriesByLevel

protected boolean getMatchingPendingEntriesByLevel(SystemOptions options,
                                       Integer universityFiscalYear,
                                       String chartOfAccountsCode,
                                       String accountNumber,
                                       String financialConsolidationObjectCode,
                                       boolean isCostShareExcluded,
                                       int pendingEntriesCode,
                                       String sessionId,
                                       UniversityDate today)

Fetches pending entries summarized by level matching the keys passed in as parameter, and then saves those summaries in a temporary table

Parameters:

options - a given set of system options

universityFiscalYear - the university fiscal year of pending entries to find

chartOfAccountsCode - the chart of accounts code of pending entries to find

accountNumber - the account number of pending entries to find

financialConsolidationObjectCode - the consolidation code of pending entries to find

isCostShareExcluded - whether to exclude cost share entries or not

pendingEntriesCode - whether to include all, approved, or no pending entries in this inquiry

sessionId - the unique web id of the currently inquiring user, used as a key for the temporary tables

Returns:

true if summarization process found pending entries to process, false otherwise