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

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

All Implemented Interfaces:

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

Direct Known Subclasses:

AccountBalanceConsolidationDaoJdbc, AccountBalanceLevelDaoJdbc, AccountBalanceObjectDaoJdbc

public class AccountBalanceDaoJdbcBase
extends org.kuali.rice.kns.dao.jdbc.PlatformAwareDaoBaseJdbc

A base class to support the JDBC operations done for AccountBalance inquiries

Field Summary

protected OptionsService	optionsService
protected UniversityDateService	universityDateService

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

logger

Constructor Summary

AccountBalanceDaoJdbcBase()

Method Summary

protected void	clearTempTable(String tableName, String sessionIdColumn, String sessionId) Deletes all entries in the temporary table for the given unique user
protected void	fixPendingEntryDisplay(Integer universityFiscalYear, String sessionId) Updates the fiscal year and account numbers of temporary pending entries for display
OptionsService	getOptionsService()
UniversityDateService	getUniversityDateService()
protected boolean	hasEntriesInPendingTable(String sessionId) Determines if the currently inquiring user has associated temporary pending entries in the temporary pending entry table
protected String	inString(int count) Creates a String bounded with parantheses with count number of question marks, like this: (?, ?, ?) if count is 3.
protected void	purgeCostShareEntries(String tableName, String sessionIdColumn, String sessionId) Removes all cost share entries from the temporary holding table for this unique inquiry
void	setOptionsService(OptionsService optionsService)
void	setUniversityDateService(UniversityDateService universityDateService)

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

optionsService

protected OptionsService optionsService

universityDateService

protected UniversityDateService universityDateService

Constructor Detail

AccountBalanceDaoJdbcBase

public AccountBalanceDaoJdbcBase()

Method Detail

getOptionsService

public OptionsService getOptionsService()

setOptionsService

public void setOptionsService(OptionsService optionsService)

getUniversityDateService

public UniversityDateService getUniversityDateService()

setUniversityDateService

public void setUniversityDateService(UniversityDateService universityDateService)

inString

protected String inString(int count)

Creates a String bounded with parantheses with count number of question marks, like this: (?, ?, ?) if count is 3. Right, for creating the SQL queries

Parameters:

count - the count of question marks

Returns:

the resulting String

purgeCostShareEntries

protected void purgeCostShareEntries(String tableName,
                                     String sessionIdColumn,
                                     String sessionId)

Removes all cost share entries from the temporary holding table for this unique inquiry

Parameters:

tableName - the name of the temporary table to remove cost share entries from

sessionIdColumn - the name of the column in the temporary table that holds the unique id of the inquiry

sessionId - the unique id of the web session of the inquiring user

hasEntriesInPendingTable

protected boolean hasEntriesInPendingTable(String sessionId)

Determines if the currently inquiring user has associated temporary pending entries in the temporary pending entry table

Parameters:

sessionId - the unique web id of the inquiring user

Returns:

true if this inquiring user has temporary pending entries, false otherwise

fixPendingEntryDisplay

protected void fixPendingEntryDisplay(Integer universityFiscalYear,
                                      String sessionId)

Updates the fiscal year and account numbers of temporary pending entries for display

Parameters:

universityFiscalYear - the fiscal year to update all the temporary pending entries of this inquiry to

sessionId - the unique web id of the inquiring user

clearTempTable

protected void clearTempTable(String tableName,
                              String sessionIdColumn,
                              String sessionId)

Deletes all entries in the temporary table for the given unique user

Parameters:

tableName - the table name to purge data from

sessionIdColumn - the name of the unique field on that table

sessionId - the unique value of the inquiry; basically, the unique web session id of the inquiring user