org.kuali.ole.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.core.framework.persistence.jdbc.dao.PlatformAwareDaoBaseJdbc

org.kuali.ole.gl.dataaccess.impl.AccountBalanceDaoJdbcBase

org.kuali.ole.gl.dataaccess.impl.AccountBalanceConsolidationDaoJdbc

All Implemented Interfaces:

AccountBalanceConsolidationDao, org.kuali.rice.core.framework.persistence.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.springframework.dao.support.DaoSupport

logger

Constructor Summary

Constructors

Constructor and Description
AccountBalanceConsolidationDaoJdbc()

Method Summary

Methods

Modifier and Type	Method and Description
List<Map<String,Object>>	findAccountBalanceByConsolidationObjectTypes(String[] objectTypes, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, boolean isExcludeCostShare, boolean isConsolidated, int pendingEntriesCode, SystemOptions options, UniversityDate today) 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, UniversityDate today) 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.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

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,
                                                                    SystemOptions options,
                                                                    UniversityDate today)

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

options - system options

today - current university date

Returns:

a List of Maps with the report information from this inquiry

See Also:

org.kuali.ole.gl.dataaccess.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,
                                               UniversityDate today)

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