org.kuali.kfs.gl.dataaccess
Interface BalanceDao

All Known Implementing Classes:

BalanceDaoOjb

public interface BalanceDao

The DAO interface that declares methods needed to query the database about balances

Method Summary

int	countBalancesForFiscalYear(Integer year) This method returns the total count of balances for a fiscal year
Iterator<Balance>	findAccountBalances(Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber) Returns the balance entries for the given year, chart, and account.
Iterator<Balance>	findAccountBalances(Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String sfCode) Returns the balance entries for the given year, chart, and account.
Iterator	findBalance(Map fieldValues, boolean isConsolidated) This method finds the records of balance entries according to input fields and values
Iterator	findBalances(Account account, Integer fiscalYear, Collection includedObjectCodes, Collection excludedObjectCodes, Collection objectTypeCodes, Collection balanceTypeCodes) Based on specific query types, return an Iterator of balance records
Iterator<Balance>	findBalancesForFiscalYear(Integer year) Returns all of the balances of a given fiscal year
Iterator<Balance>	findCashBalance(Map fieldValues, boolean isConsolidated) This method finds the cash balance entries according to input fields and values
Iterator<Balance>	findCumulativeBalancesToForwardForFiscalYear(Integer year) Returns the C&G balances specifically to be forwarded to the next fiscal year, based on the "cumulative" rule
Iterator<Balance>	findGeneralBalancesToForwardForFiscalYear(Integer year) Returns the balances specifically to be forwarded to the next fiscal year, based on the "general" rule
Iterator<Balance>	findNominalActivityBalancesForFiscalYear(Integer year) This method returns all of the balances specifically for the nominal activity closing job
Iterator<Balance>	findOrganizationReversionBalancesForFiscalYear(Integer year, boolean endOfYear) Returns the balances that would specifically be picked up by the Organization Reversion year end process
Balance	getBalanceByPrimaryId(Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber) Given the primary keys of a balance, finds the balance in the database.
Balance	getBalanceByTransaction(Transaction t) Given a transaction, finds the balance record it would affect
Iterator	getConsolidatedBalanceRecordCount(Map fieldValues) This method gets the size collection of balance entry groups according to input fields and values if the entries are required to be consolidated
Iterator	getConsolidatedCashBalanceRecordCount(Map fieldValues) This method gets the size collection of cash balance entry groups according to input fields and values if the entries are required to be consolidated
Balance	getCurrentBudgetForObjectCode(Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String objectCode) Returns the CB (current budget) record for the given year, chart, account, and object code if one is found.
Integer	getDetailedCashBalanceRecordCount(Map fieldValues) This method gets the size collection of cash balance entries or entry groups according to input fields and values
Iterator<Object[]>	getGlSummary(int universityFiscalYear, List<String> balanceTypeCodes) Get the GL Summary data
void	purgeYearByChart(String chart, int year) Purge the sufficient funds balance table by year/chart
void	save(Balance b) Saves a balance to the database

Method Detail

getGlSummary

Iterator<Object[]> getGlSummary(int universityFiscalYear,
                                List<String> balanceTypeCodes)

Get the GL Summary data

Parameters:

universityFiscalYear - the fiscal year of balances to search for

balanceTypeCodes - a list of balance type codes of balances to search for

Returns:

iterator of reported on java.lang.Object arrays with the report data

getBalanceByTransaction

Balance getBalanceByTransaction(Transaction t)

Given a transaction, finds the balance record it would affect

Parameters:

t - a transaction

Returns:

the balance record it would affect

getBalanceByPrimaryId

Balance getBalanceByPrimaryId(Integer universityFiscalYear,
                              String chartOfAccountsCode,
                              String accountNumber)

Given the primary keys of a balance, finds the balance in the database. Although not all of the primary keys are sent into this method... Programmers are seriously advised not to use this method; the default implementation does not work

Parameters:

universityFiscalYear - the university fiscal year of the balance to find

chartOfAccountsCode - the chart of accounts code of the balance to find

accountNumber - the account number of the balance to find

Returns:

the balance that is specified by those...er...partially defined primary keys.

findBalances

Iterator findBalances(Account account,
                      Integer fiscalYear,
                      Collection includedObjectCodes,
                      Collection excludedObjectCodes,
                      Collection objectTypeCodes,
                      Collection balanceTypeCodes)

Based on specific query types, return an Iterator of balance records

Parameters:

account - the account of balances to find

fiscalYear - the fiscal year of balances to find

includedObjectCodes - a Collection of object codes found balances should have one of

excludedObjectCodes - a Collection of object codes found balances should not have one of

objectTypeCodes - a Collection of object type codes found balances should have one of

balanceTypeCodes - a Collection of balance type codes found balances should have one of

Returns:

an Iterator of Balances

save

void save(Balance b)

Saves a balance to the database

Parameters:

b - a balance to save

findCashBalance

Iterator<Balance> findCashBalance(Map fieldValues,
                                  boolean isConsolidated)

This method finds the cash balance entries according to input fields and values

Parameters:

fieldValues - the input fields and values

isConsolidated - consolidation option is applied or not

Returns:

the records of cash balance entries

getDetailedCashBalanceRecordCount

Integer getDetailedCashBalanceRecordCount(Map fieldValues)

This method gets the size collection of cash balance entries or entry groups according to input fields and values

Parameters:

fieldValues - the input fields and values

isConsolidated - consolidation option is applied or not

Returns:

the size collection of cash balance entry groups

getConsolidatedCashBalanceRecordCount

Iterator getConsolidatedCashBalanceRecordCount(Map fieldValues)

This method gets the size collection of cash balance entry groups according to input fields and values if the entries are required to be consolidated

Parameters:

fieldValues - the input fields and values

Returns:

the size collection of cash balance entry groups

findBalance

Iterator findBalance(Map fieldValues,
                     boolean isConsolidated)

This method finds the records of balance entries according to input fields and values

Parameters:

fieldValues - the input fields and values

isConsolidated - consolidation option is applied or not

Returns:

the records of balance entries

getConsolidatedBalanceRecordCount

Iterator getConsolidatedBalanceRecordCount(Map fieldValues)

This method gets the size collection of balance entry groups according to input fields and values if the entries are required to be consolidated

Parameters:

fieldValues - the input fields and values

Returns:

the size collection of balance entry groups

findAccountBalances

Iterator<Balance> findAccountBalances(Integer universityFiscalYear,
                                      String chartOfAccountsCode,
                                      String accountNumber,
                                      String sfCode)

Returns the balance entries for the given year, chart, and account.

Parameters:

universityFiscalYear - the unversity fiscal year of balances to return

chartOfAccountsCode - the chart of accounts code of balances to return

accountNumber - the account number of balances to return

sfCode - Sufficient Funds Code (used to determine sorting)

Returns:

balance entries matching above

findAccountBalances

Iterator<Balance> findAccountBalances(Integer universityFiscalYear,
                                      String chartOfAccountsCode,
                                      String accountNumber)

Returns the balance entries for the given year, chart, and account.

Parameters:

universityFiscalYear - the fiscal year of balances to return

chartOfAccountsCode - the chart of accounts code of balances to return

accountNumber - the account number of balances to return

Returns:

balance entries matching above sorted by object code

getCurrentBudgetForObjectCode

Balance getCurrentBudgetForObjectCode(Integer universityFiscalYear,
                                      String chartOfAccountsCode,
                                      String accountNumber,
                                      String objectCode)

Returns the CB (current budget) record for the given year, chart, account, and object code if one is found.

Parameters:

universityFiscalYear - the fiscal year of the CB balance to return

chartOfAccountsCode - the chart of the accounts code of the CB balanes to return

accountNumber - the account number of the CB balance to return

objectCode - the object code of the CB balance to return

Returns:

the CB Balance record

purgeYearByChart

void purgeYearByChart(String chart,
                      int year)

Purge the sufficient funds balance table by year/chart

Parameters:

chart - the chart of balances to purge

year - the university fiscal year of balances to purge

findBalancesForFiscalYear

Iterator<Balance> findBalancesForFiscalYear(Integer year)

Returns all of the balances of a given fiscal year

Parameters:

year - the university fiscal year of balances to return

Returns:

an iterator over all balances for a given fiscal year

countBalancesForFiscalYear

int countBalancesForFiscalYear(Integer year)

This method returns the total count of balances for a fiscal year

Parameters:

year - fiscal year to check

Returns:

the count of balances

findNominalActivityBalancesForFiscalYear

Iterator<Balance> findNominalActivityBalancesForFiscalYear(Integer year)

This method returns all of the balances specifically for the nominal activity closing job

Parameters:

year - year to find balances for

Returns:

an Iterator of nominal activity balances

findGeneralBalancesToForwardForFiscalYear

Iterator<Balance> findGeneralBalancesToForwardForFiscalYear(Integer year)

Returns the balances specifically to be forwarded to the next fiscal year, based on the "general" rule

Parameters:

year - the fiscal year to find balances for

Returns:

an Iterator full of Balances

findCumulativeBalancesToForwardForFiscalYear

Iterator<Balance> findCumulativeBalancesToForwardForFiscalYear(Integer year)

Returns the C&G balances specifically to be forwarded to the next fiscal year, based on the "cumulative" rule

Parameters:

year - the fiscal year to find balances for

Returns:

and Iterator chuck full of Balances

findOrganizationReversionBalancesForFiscalYear

Iterator<Balance> findOrganizationReversionBalancesForFiscalYear(Integer year,
                                                                 boolean endOfYear)

Returns the balances that would specifically be picked up by the Organization Reversion year end process

Parameters:

year - the year to find balances for

Returns:

an iterator of the balances to process