org.kuali.kfs.module.bc.document.dataaccess.impl
Class BudgetOrganizationPushPullDaoJdbc

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.bc.document.dataaccess.impl.BudgetConstructionDaoJdbcBase
                      org.kuali.kfs.module.bc.document.dataaccess.impl.BudgetOrganizationPushPullDaoJdbc

All Implemented Interfaces:

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

public class BudgetOrganizationPushPullDaoJdbc
extends BudgetConstructionDaoJdbcBase
implements BudgetOrganizationPushPullDao

Implements BudgetOrganizationPushPullDao using raw SQL and populating temporary tables with the potential set of documents to push down or pull up. The temporary tables are then used to drive the entire push down or pull up process. First, an attempt is made to place budget locks on each document. Successfully locked documents are then pushed down or pulled up by setting the associated BudgetConstructionHeader (LD_BCNSTR_HDR_T) row with the appropriate level attribute values and releasing the locks.

Field Summary

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

logger

Constructor Summary

BudgetOrganizationPushPullDaoJdbc()

Method Summary

int	buildPullUpBudgetedDocuments(String principalId, Integer fiscalYear, String pointOfViewCharOfAccountsCode, String pointOfViewOrganizationCode) Uses sql jdbc call to populate the account select table for the set of pull up documents.
int	buildPushDownBudgetedDocuments(String principalId, Integer fiscalYear, String pointOfViewCharOfAccountsCode, String pointOfViewOrganizationCode) Uses sql jdbc call to populate the account select table for the set of push up documents.
void	pullupSelectedOrganizationDocuments(String principalId, Integer fiscalYear, String pointOfViewCharOfAccountsCode, String pointOfViewOrganizationCode) Pulls up Budget Construction documents based on user selected Organizations and the current point of view Organization on the Organization Selection screen running in Pullup mode.
void	pushdownSelectedOrganizationDocuments(String principalId, Integer fiscalYear, String pointOfViewCharOfAccountsCode, String pointOfViewOrganizationCode) Pushes down Budget Construction documents based on user selected Organizations and the current point of view Organization on the Organization Selection screen running in Pushdown mode.

Methods inherited from class org.kuali.kfs.module.bc.document.dataaccess.impl.BudgetConstructionDaoJdbcBase

clearTempTableBySesId, clearTempTableByUnvlId, getExpenditureINList, getFiscalYearStartDate, getRevenueINList, getSqlSubStringFunction, inString, inString, setOjbOraclePlatform, setOjbPlatform, setParameterService

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

BudgetOrganizationPushPullDaoJdbc

public BudgetOrganizationPushPullDaoJdbc()

Method Detail

pullupSelectedOrganizationDocuments

public void pullupSelectedOrganizationDocuments(String principalId,
                                                Integer fiscalYear,
                                                String pointOfViewCharOfAccountsCode,
                                                String pointOfViewOrganizationCode)

Description copied from interface: BudgetOrganizationPushPullDao

Pulls up Budget Construction documents based on user selected Organizations and the current point of view Organization on the Organization Selection screen running in Pullup mode.

Specified by:

pullupSelectedOrganizationDocuments in interface BudgetOrganizationPushPullDao

See Also:

BudgetOrganizationPushPullDao.pullupSelectedOrganizationDocuments(java.lang.String, java.lang.Integer, java.lang.String, java.lang.String)

pushdownSelectedOrganizationDocuments

public void pushdownSelectedOrganizationDocuments(String principalId,
                                                  Integer fiscalYear,
                                                  String pointOfViewCharOfAccountsCode,
                                                  String pointOfViewOrganizationCode)

Description copied from interface: BudgetOrganizationPushPullDao

Pushes down Budget Construction documents based on user selected Organizations and the current point of view Organization on the Organization Selection screen running in Pushdown mode.

Specified by:

pushdownSelectedOrganizationDocuments in interface BudgetOrganizationPushPullDao

See Also:

BudgetOrganizationPushPullDao.pushdownSelectedOrganizationDocuments(java.lang.String, java.lang.Integer, java.lang.String, java.lang.String)

buildPullUpBudgetedDocuments

public int buildPullUpBudgetedDocuments(String principalId,
                                        Integer fiscalYear,
                                        String pointOfViewCharOfAccountsCode,
                                        String pointOfViewOrganizationCode)

Uses sql jdbc call to populate the account select table for the set of pull up documents.

Specified by:

buildPullUpBudgetedDocuments in interface BudgetOrganizationPushPullDao

Parameters:

principalId - current user doing the pullup

fiscalYear - budget fiscal year

pointOfViewCharOfAccountsCode - user's point of view chart

pointOfViewOrganizationCode - user's point of view org

Returns:

int number of rows affected (number of documents)

See Also:

org.kuali.kfs.module.bc.document.dataaccess..BudgetOrganizationPushPullDao#buildPullUpBudgetedDocuments(java.lang.String, java.lang.Integer, java.lang.String, java.lang.String)

buildPushDownBudgetedDocuments

public int buildPushDownBudgetedDocuments(String principalId,
                                          Integer fiscalYear,
                                          String pointOfViewCharOfAccountsCode,
                                          String pointOfViewOrganizationCode)

Uses sql jdbc call to populate the account select table for the set of push up documents.

Specified by:

buildPushDownBudgetedDocuments in interface BudgetOrganizationPushPullDao

Parameters:

principalId - current user doing the pushdown

fiscalYear - budget fiscal year

pointOfViewCharOfAccountsCode - user's point of view chart

pointOfViewOrganizationCode - user's point of view org

Returns:

int number of rows affected (number of documents)

See Also:

org.kuali.kfs.module.bc.document.dataaccess..BudgetOrganizationPushPullDao#buildPushDownBudgetedDocuments(java.lang.String, java.lang.Integer, java.lang.String, java.lang.String)