/** * builds report body * * @param BudgetConstructionLevelSummary bcas */ public void buildReportsBody( BudgetConstructionOrgLevelSummaryReport orgLevelSummaryReportEntry, BudgetConstructionLevelSummary levelSummary) { if (levelSummary.getFinancialObjectLevel() == null) { orgLevelSummaryReportEntry.setFinancialObjectLevelName( kualiConfigurationService.getPropertyValueAsString( BCKeyConstants.ERROR_REPORT_GETTING_OBJECT_LEVEL_NAME)); } else { orgLevelSummaryReportEntry.setFinancialObjectLevelName( levelSummary.getFinancialObjectLevel().getFinancialObjectLevelName()); } orgLevelSummaryReportEntry.setPositionCsfLeaveFteQuantity( BudgetConstructionReportHelper.setDecimalDigit( levelSummary.getPositionCsfLeaveFteQuantity(), 2, true)); orgLevelSummaryReportEntry.setCsfFullTimeEmploymentQuantity( BudgetConstructionReportHelper.setDecimalDigit( levelSummary.getCsfFullTimeEmploymentQuantity(), 2, true)); orgLevelSummaryReportEntry.setAppointmentRequestedCsfFteQuantity( BudgetConstructionReportHelper.setDecimalDigit( levelSummary.getAppointmentRequestedCsfFteQuantity(), 2, true)); orgLevelSummaryReportEntry.setAppointmentRequestedFteQuantity( BudgetConstructionReportHelper.setDecimalDigit( levelSummary.getAppointmentRequestedFteQuantity(), 2, true)); if (levelSummary.getAccountLineAnnualBalanceAmount() != null) { orgLevelSummaryReportEntry.setAccountLineAnnualBalanceAmount( levelSummary.getAccountLineAnnualBalanceAmount()); } if (levelSummary.getFinancialBeginningBalanceLineAmount() != null) { orgLevelSummaryReportEntry.setFinancialBeginningBalanceLineAmount( levelSummary.getFinancialBeginningBalanceLineAmount()); } if (levelSummary.getAccountLineAnnualBalanceAmount() != null && levelSummary.getFinancialBeginningBalanceLineAmount() != null) { orgLevelSummaryReportEntry.setAmountChange( levelSummary .getAccountLineAnnualBalanceAmount() .subtract(levelSummary.getFinancialBeginningBalanceLineAmount())); } orgLevelSummaryReportEntry.setPercentChange( BudgetConstructionReportHelper.calculatePercent( orgLevelSummaryReportEntry.getAmountChange(), orgLevelSummaryReportEntry.getFinancialBeginningBalanceLineAmount())); }
/** * builds report total * * @param BudgetConstructionAccountSummary bcas * @param List reportTotalList */ protected void buildReportsTotal( BudgetConstructionOrgAccountSummaryReport orgAccountSummaryReportEntry, BudgetConstructionAccountSummary accountSummary, List reportTotalList) { Iterator totalListIter = reportTotalList.iterator(); while (totalListIter.hasNext()) { BudgetConstructionOrgAccountSummaryReportTotal bcasTotalEntry = (BudgetConstructionOrgAccountSummaryReportTotal) totalListIter.next(); if (BudgetConstructionReportHelper.isSameEntry( accountSummary, bcasTotalEntry.getBcas(), fieldsForTotal())) { BigDecimal percentChange = BigDecimal.ZERO; orgAccountSummaryReportEntry.setTotalRevenueBaseAmount( bcasTotalEntry.getTotalRevenueBaseAmount()); orgAccountSummaryReportEntry.setTotalGrossBaseAmount( bcasTotalEntry.getTotalGrossBaseAmount()); orgAccountSummaryReportEntry.setTotalTransferInBaseAmount( bcasTotalEntry.getTotalTransferInBaseAmount()); orgAccountSummaryReportEntry.setTotalNetTransferBaseAmount( bcasTotalEntry.getTotalNetTransferBaseAmount()); orgAccountSummaryReportEntry.setTotalRevenueReqAmount( bcasTotalEntry.getTotalRevenueReqAmount()); orgAccountSummaryReportEntry.setTotalGrossReqAmount( bcasTotalEntry.getTotalGrossReqAmount()); orgAccountSummaryReportEntry.setTotalTransferInReqAmount( bcasTotalEntry.getTotalTransferInReqAmount()); orgAccountSummaryReportEntry.setTotalNetTransferReqAmount( bcasTotalEntry.getTotalNetTransferReqAmount()); orgAccountSummaryReportEntry.setTotalRevenueAmountChange( orgAccountSummaryReportEntry.getTotalRevenueReqAmount() - orgAccountSummaryReportEntry.getTotalRevenueBaseAmount()); percentChange = BudgetConstructionReportHelper.calculatePercent( orgAccountSummaryReportEntry.getTotalRevenueAmountChange(), orgAccountSummaryReportEntry.getTotalRevenueBaseAmount()); orgAccountSummaryReportEntry.setTotalRevenuePercentChange(percentChange); orgAccountSummaryReportEntry.setTotalGrossAmountChange( orgAccountSummaryReportEntry.getTotalGrossReqAmount() - orgAccountSummaryReportEntry.getTotalGrossBaseAmount()); percentChange = BudgetConstructionReportHelper.calculatePercent( orgAccountSummaryReportEntry.getTotalGrossAmountChange(), orgAccountSummaryReportEntry.getTotalGrossBaseAmount()); orgAccountSummaryReportEntry.setTotalGrossPercentChange(percentChange); orgAccountSummaryReportEntry.setTotalTransferAmountChange( orgAccountSummaryReportEntry.getTotalTransferInReqAmount() - orgAccountSummaryReportEntry.getTotalTransferInBaseAmount()); percentChange = BudgetConstructionReportHelper.calculatePercent( orgAccountSummaryReportEntry.getTotalTransferAmountChange(), orgAccountSummaryReportEntry.getTotalTransferInBaseAmount()); orgAccountSummaryReportEntry.setTotalTransferInPercentChange(percentChange); orgAccountSummaryReportEntry.setTotalNetTransferAmountChange( orgAccountSummaryReportEntry.getTotalNetTransferReqAmount() - orgAccountSummaryReportEntry.getTotalNetTransferBaseAmount()); percentChange = BudgetConstructionReportHelper.calculatePercent( orgAccountSummaryReportEntry.getTotalNetTransferAmountChange(), orgAccountSummaryReportEntry.getTotalNetTransferBaseAmount()); orgAccountSummaryReportEntry.setTotalNetTransferPercentChange(percentChange); orgAccountSummaryReportEntry.setRevExpDifferenceBaseAmount( orgAccountSummaryReportEntry.getTotalRevenueBaseAmount() - orgAccountSummaryReportEntry.getTotalNetTransferBaseAmount()); orgAccountSummaryReportEntry.setRevExpDifferenceReqAmount( orgAccountSummaryReportEntry.getTotalRevenueReqAmount() - orgAccountSummaryReportEntry.getTotalNetTransferReqAmount()); orgAccountSummaryReportEntry.setRevExpDifferenceAmountChange( orgAccountSummaryReportEntry.getRevExpDifferenceReqAmount() - orgAccountSummaryReportEntry.getRevExpDifferenceBaseAmount()); percentChange = BudgetConstructionReportHelper.calculatePercent( orgAccountSummaryReportEntry.getRevExpDifferenceAmountChange(), orgAccountSummaryReportEntry.getRevExpDifferenceBaseAmount()); orgAccountSummaryReportEntry.setRevExpDifferencePercentChange(percentChange); } } }
/** * builds report body * * @param BudgetConstructionAccountSummary bcas */ protected void buildReportsBody( BudgetConstructionOrgAccountSummaryReport orgAccountSummaryReportEntry, BudgetConstructionAccountSummary accountSummary) { orgAccountSummaryReportEntry.setAccountNumber(accountSummary.getAccountNumber()); orgAccountSummaryReportEntry.setSubAccountNumber(accountSummary.getSubAccountNumber()); if (accountSummary.getSubAccountNumber().equals(BCConstants.Report.DASHES_SUB_ACCOUNT_CODE)) { if (accountSummary.getAccount().getAccountName() == null) { orgAccountSummaryReportEntry.setAccountNameAndSubAccountName( kualiConfigurationService.getPropertyString( BCKeyConstants.ERROR_REPORT_GETTING_ACCOUNT_DESCRIPTION)); } else orgAccountSummaryReportEntry.setAccountNameAndSubAccountName( accountSummary.getAccount().getAccountName()); } else { try { if (accountSummary.getSubAccount().getSubAccountName() == null) { orgAccountSummaryReportEntry.setAccountNameAndSubAccountName( kualiConfigurationService.getPropertyString( BCKeyConstants.ERROR_REPORT_GETTING_SUB_ACCOUNT_DESCRIPTION)); } else orgAccountSummaryReportEntry.setAccountNameAndSubAccountName( accountSummary.getSubAccount().getSubAccountName()); } catch (PersistenceBrokerException e) { orgAccountSummaryReportEntry.setAccountNameAndSubAccountName( kualiConfigurationService.getPropertyString( BCKeyConstants.ERROR_REPORT_GETTING_SUB_ACCOUNT_DESCRIPTION)); } } // build income expense description if (accountSummary.getIncomeExpenseCode().equals(BCConstants.Report.INCOME_EXP_TYPE_A)) { orgAccountSummaryReportEntry.setIncExpDesc( kualiConfigurationService.getPropertyString( BCKeyConstants.MSG_REPORT_INCOME_EXP_DESC_REVENUE)); } else if (accountSummary.getIncomeExpenseCode().equals(BCConstants.Report.INCOME_EXP_TYPE_E)) { orgAccountSummaryReportEntry.setIncExpDesc( kualiConfigurationService.getPropertyString( BCKeyConstants.MSG_REPORT_INCOME_EXP_DESC_EXP_GROSS)); } else if (accountSummary.getIncomeExpenseCode().equals(BCConstants.Report.INCOME_EXP_TYPE_T)) { trExist = true; orgAccountSummaryReportEntry.setIncExpDesc( kualiConfigurationService.getPropertyString( BCKeyConstants.MSG_REPORT_INCOME_EXP_DESC_TRNFR_IN)); } else { if (trExist) { trExist = false; orgAccountSummaryReportEntry.setIncExpDesc( kualiConfigurationService.getPropertyString( BCKeyConstants.MSG_REPORT_INCOME_EXP_DESC_EXP_NET_TRNFR)); } else { orgAccountSummaryReportEntry.setIncExpDesc( kualiConfigurationService.getPropertyString( BCKeyConstants.MSG_REPORT_INCOME_EXP_DESC_EXPENDITURE)); } } Integer beginingBalanceLineAmt = 0; Integer accountLineAnnualBalAmt = 0; if (accountSummary.getFinancialBeginningBalanceLineAmount() != null) { beginingBalanceLineAmt = BudgetConstructionReportHelper.convertKualiInteger( accountSummary.getFinancialBeginningBalanceLineAmount()); } if (accountSummary.getFinancialBeginningBalanceLineAmount() != null) { accountLineAnnualBalAmt = BudgetConstructionReportHelper.convertKualiInteger( accountSummary.getAccountLineAnnualBalanceAmount()); } orgAccountSummaryReportEntry.setBaseAmount(beginingBalanceLineAmt); orgAccountSummaryReportEntry.setReqAmount(accountLineAnnualBalAmt); orgAccountSummaryReportEntry.setAmountChange(accountLineAnnualBalAmt - beginingBalanceLineAmt); orgAccountSummaryReportEntry.setPercentChange( BudgetConstructionReportHelper.calculatePercent( orgAccountSummaryReportEntry.getAmountChange(), beginingBalanceLineAmt)); }
/** * builds report total * * @param BudgetConstructionLevelSummary bcas * @param List reportTotalList */ public void buildReportsTotal( BudgetConstructionOrgLevelSummaryReport orgLevelSummaryReportEntry, BudgetConstructionLevelSummary levelSummary, List<BudgetConstructionOrgLevelSummaryReportTotal> levelSummaryTotalConsList, List<BudgetConstructionOrgLevelSummaryReportTotal> levelSummaryTotalGexpAndTypeList, List<BudgetConstructionOrgLevelSummaryReportTotal> levelSummaryTotalList) { for (BudgetConstructionOrgLevelSummaryReportTotal consTotal : levelSummaryTotalConsList) { if (BudgetConstructionReportHelper.isSameEntry( levelSummary, consTotal.getBcls(), fieldsForCons())) { orgLevelSummaryReportEntry.setTotalConsolidationDescription( levelSummary.getFinancialConsolidationObject().getFinConsolidationObjectName()); // The total part shouldn't have null value, so just checking '0' orgLevelSummaryReportEntry.setTotalConsolidationPositionCsfLeaveFteQuantity( BudgetConstructionReportHelper.setDecimalDigit( consTotal.getTotalConsolidationPositionCsfLeaveFteQuantity(), 2, true)); orgLevelSummaryReportEntry.setTotalConsolidationPositionCsfFullTimeEmploymentQuantity( BudgetConstructionReportHelper.setDecimalDigit( consTotal.getTotalConsolidationPositionCsfFullTimeEmploymentQuantity(), 2, true)); orgLevelSummaryReportEntry.setTotalConsolidationFinancialBeginningBalanceLineAmount( consTotal.getTotalConsolidationFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setTotalConsolidationAppointmentRequestedCsfFteQuantity( BudgetConstructionReportHelper.setDecimalDigit( consTotal.getTotalConsolidationAppointmentRequestedCsfFteQuantity(), 2, true)); orgLevelSummaryReportEntry.setTotalConsolidationAppointmentRequestedFteQuantity( BudgetConstructionReportHelper.setDecimalDigit( consTotal.getTotalConsolidationAppointmentRequestedFteQuantity(), 2, true)); orgLevelSummaryReportEntry.setTotalConsolidationAccountLineAnnualBalanceAmount( consTotal.getTotalConsolidationAccountLineAnnualBalanceAmount()); KualiInteger amountChange = consTotal .getTotalConsolidationAccountLineAnnualBalanceAmount() .subtract(consTotal.getTotalConsolidationFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setTotalConsolidationAmountChange(amountChange); orgLevelSummaryReportEntry.setTotalConsolidationPercentChange( BudgetConstructionReportHelper.calculatePercent( amountChange, consTotal.getTotalConsolidationFinancialBeginningBalanceLineAmount())); } } for (BudgetConstructionOrgLevelSummaryReportTotal gexpAndTypeTotal : levelSummaryTotalGexpAndTypeList) { if (BudgetConstructionReportHelper.isSameEntry( levelSummary, gexpAndTypeTotal.getBcls(), fieldsForGexpAndType())) { orgLevelSummaryReportEntry.setGrossFinancialBeginningBalanceLineAmount( gexpAndTypeTotal.getGrossFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setGrossAccountLineAnnualBalanceAmount( gexpAndTypeTotal.getGrossAccountLineAnnualBalanceAmount()); KualiInteger gexpAndTypeAmountChange = gexpAndTypeTotal .getGrossAccountLineAnnualBalanceAmount() .subtract(gexpAndTypeTotal.getGrossFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setGrossAmountChange(gexpAndTypeAmountChange); orgLevelSummaryReportEntry.setGrossPercentChange( BudgetConstructionReportHelper.calculatePercent( gexpAndTypeAmountChange, gexpAndTypeTotal.getGrossFinancialBeginningBalanceLineAmount())); if (levelSummary.getIncomeExpenseCode().equals(BCConstants.Report.INCOME_EXP_TYPE_A)) { orgLevelSummaryReportEntry.setTypeDesc( kualiConfigurationService.getPropertyValueAsString( BCKeyConstants.MSG_REPORT_INCOME_EXP_DESC_UPPERCASE_REVENUE)); } else { orgLevelSummaryReportEntry.setTypeDesc( kualiConfigurationService.getPropertyValueAsString( BCKeyConstants.MSG_REPORT_INCOME_EXP_DESC_EXPENDITURE_NET_TRNFR)); } orgLevelSummaryReportEntry.setTypePositionCsfLeaveFteQuantity( BudgetConstructionReportHelper.setDecimalDigit( gexpAndTypeTotal.getTypePositionCsfLeaveFteQuantity(), 2, true)); orgLevelSummaryReportEntry.setTypePositionCsfFullTimeEmploymentQuantity( BudgetConstructionReportHelper.setDecimalDigit( gexpAndTypeTotal.getTypePositionCsfFullTimeEmploymentQuantity(), 2, true)); orgLevelSummaryReportEntry.setTypeFinancialBeginningBalanceLineAmount( gexpAndTypeTotal.getTypeFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setTypeAppointmentRequestedCsfFteQuantity( BudgetConstructionReportHelper.setDecimalDigit( gexpAndTypeTotal.getTypeAppointmentRequestedCsfFteQuantity(), 2, true)); orgLevelSummaryReportEntry.setTypeAppointmentRequestedFteQuantity( BudgetConstructionReportHelper.setDecimalDigit( gexpAndTypeTotal.getTypeAppointmentRequestedFteQuantity(), 2, true)); orgLevelSummaryReportEntry.setTypeAccountLineAnnualBalanceAmount( gexpAndTypeTotal.getTypeAccountLineAnnualBalanceAmount()); KualiInteger typeAmountChange = gexpAndTypeTotal .getTypeAccountLineAnnualBalanceAmount() .subtract(gexpAndTypeTotal.getTypeFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setTypeAmountChange(typeAmountChange); orgLevelSummaryReportEntry.setTypePercentChange( BudgetConstructionReportHelper.calculatePercent( typeAmountChange, gexpAndTypeTotal.getTypeFinancialBeginningBalanceLineAmount())); } } for (BudgetConstructionOrgLevelSummaryReportTotal total : levelSummaryTotalList) { if (BudgetConstructionReportHelper.isSameEntry( levelSummary, total.getBcls(), fieldsForTotal())) { orgLevelSummaryReportEntry.setTotalSubFundGroupDesc( levelSummary.getSubFundGroup().getSubFundGroupDescription()); orgLevelSummaryReportEntry.setRevenueFinancialBeginningBalanceLineAmount( total.getRevenueFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setRevenueAccountLineAnnualBalanceAmount( total.getRevenueAccountLineAnnualBalanceAmount()); orgLevelSummaryReportEntry.setExpenditureFinancialBeginningBalanceLineAmount( total.getExpenditureFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setExpenditureAccountLineAnnualBalanceAmount( total.getExpenditureAccountLineAnnualBalanceAmount()); KualiInteger revenueAmountChange = total .getRevenueAccountLineAnnualBalanceAmount() .subtract(total.getRevenueFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setRevenueAmountChange(revenueAmountChange); orgLevelSummaryReportEntry.setRevenuePercentChange( BudgetConstructionReportHelper.calculatePercent( revenueAmountChange, total.getRevenueFinancialBeginningBalanceLineAmount())); KualiInteger expenditureAmountChange = total .getExpenditureAccountLineAnnualBalanceAmount() .subtract(total.getExpenditureFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setExpenditureAmountChange(expenditureAmountChange); orgLevelSummaryReportEntry.setExpenditurePercentChange( BudgetConstructionReportHelper.calculatePercent( expenditureAmountChange, total.getExpenditureFinancialBeginningBalanceLineAmount())); orgLevelSummaryReportEntry.setDifferenceFinancialBeginningBalanceLineAmount( total.getDifferenceFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setDifferenceAccountLineAnnualBalanceAmount( total.getDifferenceAccountLineAnnualBalanceAmount()); KualiInteger differenceAmountChange = total .getDifferenceAccountLineAnnualBalanceAmount() .subtract(total.getDifferenceFinancialBeginningBalanceLineAmount()); orgLevelSummaryReportEntry.setDifferenceAmountChange(differenceAmountChange); orgLevelSummaryReportEntry.setDifferencePercentChange( BudgetConstructionReportHelper.calculatePercent( differenceAmountChange, total.getDifferenceFinancialBeginningBalanceLineAmount())); } } }