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

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

All Implemented Interfaces:

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

public class BudgetConstructionSalarySummaryReportDaoJdbc
extends BudgetConstructionDaoJdbcBase
implements BudgetConstructionSalarySummaryReportDao

builds the underlying data table for the salary summary report in budget construction

Field Summary

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

logger

Constructor Summary

BudgetConstructionSalarySummaryReportDaoJdbc()

Method Summary

protected void	clearCommonWorkTable(String idForSession) clean out the work table used by all reports
protected void	clearThresholdWorkTables(String idForSession) clean out the work tables for reporting by threshold
protected void	clearUserPreviouSalarySummaryReports(String principalName) clean out all rows in the report tables associated with this user
protected void	runCommonSQLForSalaryReports(String principalName, String idForSession) runs SQL used by every report
void	setPersistenceService(org.kuali.rice.kns.service.PersistenceService persistenceService)
void	updateSalaryAndReasonSummaryReportsWithoutThreshold(String principalName, boolean listSalariesWithReasonCodes) lists all salaries, or only those flagged with a reason for increase
void	updateSalaryAndReasonSummaryReportsWithThreshold(String principalName, Integer previousFiscalYear, boolean reportGreaterThanOrEqualToThreshold, org.kuali.rice.kns.util.KualiDecimal threshold) lists salaries with increases at or above a threshold, or with increases at or below a threshold

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

BudgetConstructionSalarySummaryReportDaoJdbc

public BudgetConstructionSalarySummaryReportDaoJdbc()

Method Detail

clearUserPreviouSalarySummaryReports

protected void clearUserPreviouSalarySummaryReports(String principalName)

clean out all rows in the report tables associated with this user

Parameters:

principalName--the - user requesting the report

clearCommonWorkTable

protected void clearCommonWorkTable(String idForSession)

clean out the work table used by all reports

Parameters:

idForSession--the - session which requested the report

clearThresholdWorkTables

protected void clearThresholdWorkTables(String idForSession)

clean out the work tables for reporting by threshold

Parameters:

idForSession--the - session which requested the report

runCommonSQLForSalaryReports

protected void runCommonSQLForSalaryReports(String principalName,
                                            String idForSession)

runs SQL used by every report

Parameters:

principalName--the - user requesting the report

idForSession--the - session of the user

updateSalaryAndReasonSummaryReportsWithThreshold

public void updateSalaryAndReasonSummaryReportsWithThreshold(String principalName,
                                                             Integer previousFiscalYear,
                                                             boolean reportGreaterThanOrEqualToThreshold,
                                                             org.kuali.rice.kns.util.KualiDecimal threshold)

Description copied from interface: BudgetConstructionSalarySummaryReportDao

lists salaries with increases at or above a threshold, or with increases at or below a threshold

Specified by:

updateSalaryAndReasonSummaryReportsWithThreshold in interface BudgetConstructionSalarySummaryReportDao

See Also:

org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionSalarySummaryReportDao#salarySummaryReports(java.lang.String, java.lang.Integer, boolean, org.kuali.rice.kns.util.KualiDecimal)

updateSalaryAndReasonSummaryReportsWithoutThreshold

public void updateSalaryAndReasonSummaryReportsWithoutThreshold(String principalName,
                                                                boolean listSalariesWithReasonCodes)

Description copied from interface: BudgetConstructionSalarySummaryReportDao

lists all salaries, or only those flagged with a reason for increase

Specified by:

updateSalaryAndReasonSummaryReportsWithoutThreshold in interface BudgetConstructionSalarySummaryReportDao

See Also:

org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionSalarySummaryReportDao#reasonSummaryReports(java.lang.String, boolean)

setPersistenceService

public void setPersistenceService(org.kuali.rice.kns.service.PersistenceService persistenceService)