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

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

All Implemented Interfaces:

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

public class BudgetConstructionReasonStatisticsReportDaoJdbc
extends BudgetConstructionDaoJdbcBase
implements BudgetConstructionReasonStatisticsReportDao

build the set of rows for the salary reason statistics report

Field Summary

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

logger

Constructor Summary

BudgetConstructionReasonStatisticsReportDaoJdbc()

Method Summary

protected void	adjustLastYearSalaryForAppointmentChanges(String principalName, String idForSession, Integer previousFiscalYear) works in both threshold and non-threshold mode to get the summary salary statistics and appointment attributes for each person
void	cleanReportsReasonStatisticsTable(String principalName) clears any previous report data for the current user out of the reason statistics report table
void	cleanWorkTablesFromThisSession(String idForSession) clears the rows for this session out of the work tables
protected void	fetchIndividualDetailForContinuingPeople(String principalName, String idForSession) get detailed salary/FTE rows by person and organization for the continuing people to be reported
void	setPersistenceService(org.kuali.rice.kns.service.PersistenceService persistenceService)
protected void	sumTheDetailRowsToProduceTheReportData(String principalName, String idForSession) sum base and request amounts and FTE by organization to produce the data used by the report
void	updateReasonStatisticsReportsWithAThreshold(String principalName, Integer previousFiscalYear, boolean reportIncreasesAtOrAboveTheThreshold, org.kuali.rice.kns.util.KualiDecimal thresholdPercent) report salary reason statistics for people at or above or at or below a given threshold percent
void	updateReasonStatisticsReportsWithoutAThreshold(String principalName, Integer previousFiscalYear) report salary reason statistics for everyone

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

BudgetConstructionReasonStatisticsReportDaoJdbc

public BudgetConstructionReasonStatisticsReportDaoJdbc()

Method Detail

cleanReportsReasonStatisticsTable

public void cleanReportsReasonStatisticsTable(String principalName)

Description copied from interface: BudgetConstructionReasonStatisticsReportDao

clears any previous report data for the current user out of the reason statistics report table

Specified by:

cleanReportsReasonStatisticsTable in interface BudgetConstructionReasonStatisticsReportDao

See Also:

BudgetConstructionReasonStatisticsReportDao.cleanReportsReasonStatisticsTable(java.lang.String)

cleanWorkTablesFromThisSession

public void cleanWorkTablesFromThisSession(String idForSession)

clears the rows for this session out of the work tables

Parameters:

idForSession--a - unique identifier for the session

adjustLastYearSalaryForAppointmentChanges

protected void adjustLastYearSalaryForAppointmentChanges(String principalName,
                                                         String idForSession,
                                                         Integer previousFiscalYear)

works in both threshold and non-threshold mode to get the summary salary statistics and appointment attributes for each person

Parameters:

principalName--the - user running the report

idForSession--a - unique ID for the session of the user running the report

previousFiscalYear--the - fiscal year preceding the one for which we are preparing a budget

fetchIndividualDetailForContinuingPeople

protected void fetchIndividualDetailForContinuingPeople(String principalName,
                                                        String idForSession)

get detailed salary/FTE rows by person and organization for the continuing people to be reported

Parameters:

principalName -

idForSession -

updateReasonStatisticsReportsWithAThreshold

public void updateReasonStatisticsReportsWithAThreshold(String principalName,
                                                        Integer previousFiscalYear,
                                                        boolean reportIncreasesAtOrAboveTheThreshold,
                                                        org.kuali.rice.kns.util.KualiDecimal thresholdPercent)

Description copied from interface: BudgetConstructionReasonStatisticsReportDao

report salary reason statistics for people at or above or at or below a given threshold percent

Specified by:

updateReasonStatisticsReportsWithAThreshold in interface BudgetConstructionReasonStatisticsReportDao

See Also:

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

updateReasonStatisticsReportsWithoutAThreshold

public void updateReasonStatisticsReportsWithoutAThreshold(String principalName,
                                                           Integer previousFiscalYear)

Description copied from interface: BudgetConstructionReasonStatisticsReportDao

report salary reason statistics for everyone

Specified by:

updateReasonStatisticsReportsWithoutAThreshold in interface BudgetConstructionReasonStatisticsReportDao

See Also:

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

sumTheDetailRowsToProduceTheReportData

protected void sumTheDetailRowsToProduceTheReportData(String principalName,
                                                      String idForSession)

sum base and request amounts and FTE by organization to produce the data used by the report

Parameters:

idForSession--the - session of the user doing the report

setPersistenceService

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