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

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.AccountBalanceObjectDaoJdbc

All Implemented Interfaces:

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

public class AccountBalanceObjectDaoJdbc
extends AccountBalanceDaoJdbcBase
implements AccountBalanceObjectDao

Calculate Balance By Object 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

AccountBalanceObjectDaoJdbc()

Method Summary

List	findAccountBalanceByObject(Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String financialObjectLevelCode, String financialReportingSortCode, boolean isCostShareExcluded, boolean isConsolidated, int pendingEntriesCode) Returns a collection of report data for the account balance by object inquiry
protected boolean	getMatchingPendingEntriesByObject(SystemOptions options, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String financialObjectLevelCode, boolean isCostShareExcluded, int pendingEntriesCode, String sessionId) Get any matching pending entries.
protected void	summarizePendingEntriesByObject(SystemOptions options, String sessionId) Summarizes all the pending ledger entries that would need to be reported on by this inquiry, and saves all of that data to a temporary table

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

AccountBalanceObjectDaoJdbc

public AccountBalanceObjectDaoJdbc()

Method Detail

findAccountBalanceByObject

public List findAccountBalanceByObject(Integer universityFiscalYear,
                                       String chartOfAccountsCode,
                                       String accountNumber,
                                       String financialObjectLevelCode,
                                       String financialReportingSortCode,
                                       boolean isCostShareExcluded,
                                       boolean isConsolidated,
                                       int pendingEntriesCode)

Returns a collection of report data for the account balance by object inquiry

Specified by:

findAccountBalanceByObject in interface AccountBalanceObjectDao

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

financialObjectLevelCode - the object level code of reported on account balances

financialReportingSortCode - the sort code for reported results

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

Returns:

a List of Maps with the results of the query

See Also:

AccountBalanceDao.findAccountBalanceByObject(java.lang.Integer, java.lang.String, java.lang.String, java.lang.String, java.lang.String, boolean, boolean, int)

summarizePendingEntriesByObject

protected void summarizePendingEntriesByObject(SystemOptions options,
                                               String sessionId)

Summarizes all the pending ledger entries that would need to be reported on by this inquiry, and saves all of that data to a temporary table

Parameters:

options - a set of system options

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

getMatchingPendingEntriesByObject

protected boolean getMatchingPendingEntriesByObject(SystemOptions options,
                                                    Integer universityFiscalYear,
                                                    String chartOfAccountsCode,
                                                    String accountNumber,
                                                    String financialObjectLevelCode,
                                                    boolean isCostShareExcluded,
                                                    int pendingEntriesCode,
                                                    String sessionId)

Get any matching pending entries. Return true if there were some, false if not.

Parameters:

universityFiscalYear - the university fiscal year of pending entries to summarize

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

accountNumber - the account number of pending entries to summarize

financialObjectLevelCode - the object level code of pending entries to summarize

pendingEntriesCode - whether to summarize all, approved, or no pending entries

Returns:

true if any matching pending entries were found, false otherwise