org.kuali.kfs.module.endow.batch.dataaccess.impl
Class GLInterfaceBatchProcessDaoJdbc

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.module.endow.batch.dataaccess.impl.GLInterfaceBatchProcessDaoJdbc

All Implemented Interfaces:

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

public class GLInterfaceBatchProcessDaoJdbc
extends org.kuali.rice.kns.dao.jdbc.PlatformAwareDaoBaseJdbc
implements GLInterfaceBatchProcessDao

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

Field Summary

protected GLLinkDao	gLLinkDao
protected KemidGeneralLedgerAccountDao	kemidGeneralLedgerAccountDao
protected TransactionArchiveSecurityDao	transactionArchiveSecurityDao

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

logger

Constructor Summary

GLInterfaceBatchProcessDaoJdbc()

Method Summary

protected void	buildCombinedTransactionActivities(Collection<GlInterfaceBatchProcessKemLine> kemCombinedArchiveTransactions, Collection<GlInterfaceBatchProcessKemLine> kemArchiveTransactions, boolean cashType) method to combine the kem transactions based on chart, account and object code into single data records
protected void	buildTransactionActivities(Collection<GlInterfaceBatchProcessKemLine> kemArchiveTransactions, org.springframework.jdbc.support.rowset.SqlRowSet archiveTransactions, boolean cashType) method to go through the rowset and put into transient bo and add to the collection.
Collection<String>	findDocumentTypes() method to find distinct document types from table END_TRAN_ARCHV_T.
Collection<GlInterfaceBatchProcessKemLine>	getAllCombinedKemTransactions(Date postedDate) method to gather all the kem transactions as collection of records First all the document types are retrieved then for each document type, all cash activity records are collected.
Collection<GlInterfaceBatchProcessKemLine>	getAllKemCombinedTransactionsByDocumentType(String documentType, Date postedDate) method to gather all the kem transactions as collection of records.
Collection<GlInterfaceBatchProcessKemLine>	getAllKemTransactions(Date postedDate) method to gather all the kem transactions as collection of records First all the document types are retrieved then for each document type, all cash activity records are collected and then all non-cash activity records are gathered.
protected org.springframework.jdbc.support.rowset.SqlRowSet	getAllKemTransactions(String documentType, Date postedDate, String TransactionSubTypeCode) Method to get the cash activity transactions for a given document type.
Collection<GlInterfaceBatchProcessKemLine>	getAllKemTransactionsByDocumentType(String documentType, Date postedDate) method to gather all the kem transactions as collection of records First all cash activity records are collected for the given document type, The single records are then grouped based on chart, account number and object codes.
protected GLLinkDao	getgLLinkDao() gets attribute gLLinkDao
protected KemidGeneralLedgerAccountDao	getKemidGeneralLedgerAccountDao() gets attribute kemidGeneralLedgerAccountDao
TransactionArchiveSecurityDao	getTransactionArchiveSecurityDao() gets attribute transactionArchiveSecurityDao
void	setgLLinkDao(GLLinkDao gLLinkDao) sets attribute gLLinkDao
void	setKemidGeneralLedgerAccountDao(KemidGeneralLedgerAccountDao kemidGeneralLedgerAccountDao) sets attribute kemidGeneralLedgerAccountDao
void	setTransactionArchiveSecurityDao(TransactionArchiveSecurityDao transactionArchiveSecurityDao) sets attribute transactionArchiveSecurityDao

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

kemidGeneralLedgerAccountDao

protected KemidGeneralLedgerAccountDao kemidGeneralLedgerAccountDao

gLLinkDao

protected GLLinkDao gLLinkDao

transactionArchiveSecurityDao

protected TransactionArchiveSecurityDao transactionArchiveSecurityDao

Constructor Detail

GLInterfaceBatchProcessDaoJdbc

public GLInterfaceBatchProcessDaoJdbc()

Method Detail

findDocumentTypes

public Collection<String> findDocumentTypes()

Description copied from interface: GLInterfaceBatchProcessDao

method to find distinct document types from table END_TRAN_ARCHV_T.

Specified by:

findDocumentTypes in interface GLInterfaceBatchProcessDao

Returns:

List>

See Also:

GLInterfaceBatchProcessDao.findDocumentTypes()

getAllKemTransactions

public Collection<GlInterfaceBatchProcessKemLine> getAllKemTransactions(Date postedDate)

Description copied from interface: GLInterfaceBatchProcessDao

method to gather all the kem transactions as collection of records First all the document types are retrieved then for each document type, all cash activity records are collected and then all non-cash activity records are gathered.

Specified by:

getAllKemTransactions in interface GLInterfaceBatchProcessDao

Returns:

Collection

See Also:

GLInterfaceBatchProcessDao.getAllKemTransactions(java.util.Date)

getAllCombinedKemTransactions

public Collection<GlInterfaceBatchProcessKemLine> getAllCombinedKemTransactions(Date postedDate)

Description copied from interface: GLInterfaceBatchProcessDao

method to gather all the kem transactions as collection of records First all the document types are retrieved then for each document type, all cash activity records are collected. The single records are then grouped based on chart, account number and object codes. The same process is done for non-cash activity records.

Specified by:

getAllCombinedKemTransactions in interface GLInterfaceBatchProcessDao

Returns:

Collection

See Also:

GLInterfaceBatchProcessDao.getAllCombinedKemTransactions(java.util.Date)

getAllKemTransactionsByDocumentType

public Collection<GlInterfaceBatchProcessKemLine> getAllKemTransactionsByDocumentType(String documentType,
                                                                                      Date postedDate)

Description copied from interface: GLInterfaceBatchProcessDao

method to gather all the kem transactions as collection of records First all cash activity records are collected for the given document type, The single records are then grouped based on chart, account number and object codes. The same process is done for non-cash activity records.

Specified by:

getAllKemTransactionsByDocumentType in interface GLInterfaceBatchProcessDao

Returns:

Collection

See Also:

org.kuali.kfs.module.endow.batch.dataaccess.GLInterfaceBatchProcessDao#getAllKemTransactionsByDocumentType(Stringjava.util.Date)

getAllKemCombinedTransactionsByDocumentType

public Collection<GlInterfaceBatchProcessKemLine> getAllKemCombinedTransactionsByDocumentType(String documentType,
                                                                                              Date postedDate)

Description copied from interface: GLInterfaceBatchProcessDao

method to gather all the kem transactions as collection of records. First all cash activity records are collected for the given document type and then these records are grouped based on chart, account number and object codes. The same process is done for non-cash activity records.

Specified by:

getAllKemCombinedTransactionsByDocumentType in interface GLInterfaceBatchProcessDao

Returns:

Collection

See Also:

org.kuali.kfs.module.endow.batch.dataaccess.GLInterfaceBatchProcessDao#getAllKemCombinedTransactionsByDocumentType(Stringjava.util.Date)

getAllKemTransactions

protected org.springframework.jdbc.support.rowset.SqlRowSet getAllKemTransactions(String documentType,
                                                                                  Date postedDate,
                                                                                  String TransactionSubTypeCode)

Method to get the cash activity transactions for a given document type.

Parameters:

documenType, - postedDate, sortOrder joins records from END_TRAN_ARCHV_T, END_KEMID_GL_LNK_T, and END_ETRAN_GL_LNK_T tables in the given sort order

buildTransactionActivities

protected void buildTransactionActivities(Collection<GlInterfaceBatchProcessKemLine> kemArchiveTransactions,
                                          org.springframework.jdbc.support.rowset.SqlRowSet archiveTransactions,
                                          boolean cashType)

method to go through the rowset and put into transient bo and add to the collection.

buildCombinedTransactionActivities

protected void buildCombinedTransactionActivities(Collection<GlInterfaceBatchProcessKemLine> kemCombinedArchiveTransactions,
                                                  Collection<GlInterfaceBatchProcessKemLine> kemArchiveTransactions,
                                                  boolean cashType)

method to combine the kem transactions based on chart, account and object code into single data records

getKemidGeneralLedgerAccountDao

protected KemidGeneralLedgerAccountDao getKemidGeneralLedgerAccountDao()

gets attribute kemidGeneralLedgerAccountDao

Returns:

kemidGeneralLedgerAccountDao

setKemidGeneralLedgerAccountDao

public void setKemidGeneralLedgerAccountDao(KemidGeneralLedgerAccountDao kemidGeneralLedgerAccountDao)

sets attribute kemidGeneralLedgerAccountDao

getgLLinkDao

protected GLLinkDao getgLLinkDao()

gets attribute gLLinkDao

Returns:

gLLinkDao

setgLLinkDao

public void setgLLinkDao(GLLinkDao gLLinkDao)

sets attribute gLLinkDao

getTransactionArchiveSecurityDao

public TransactionArchiveSecurityDao getTransactionArchiveSecurityDao()

gets attribute transactionArchiveSecurityDao

Returns:

transactionArchiveSecurityDao

setTransactionArchiveSecurityDao

public void setTransactionArchiveSecurityDao(TransactionArchiveSecurityDao transactionArchiveSecurityDao)

sets attribute transactionArchiveSecurityDao