org.kuali.kfs.module.bc.document.service.impl
Class ReportExportServiceImpl

java.lang.Object
  extended by org.kuali.kfs.module.bc.document.service.impl.ReportExportServiceImpl
All Implemented Interfaces:
ReportExportService

@Transactional
public class ReportExportServiceImpl
extends Object
implements ReportExportService

See Also:
ReportExportService

Constructor Summary
ReportExportServiceImpl()
           
 
Method Summary
 StringBuilder buildAccountDumpFile(String principalId, String fieldSeperator, String textDelimiter, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String subAccountNumber)
          Retrieves records for account dump and outputs file based on user preferences
 StringBuilder buildAccountFundingDumpFile(String principalId, String fieldSeperator, String textDelimiter, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String subAccountNumber)
          Retrieves records for organization funding dump and outputs file based on user preferences
 StringBuilder buildAccountMonthlyDumpFile(String principalId, String fieldSeperator, String textDelimiter, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String subAccountNumber)
          Retrieves records for account monthly dump and outputs file based on user preferences
 StringBuilder buildOrganizationAccountDumpFile(String principalId, String fieldSeperator, String textDelimiter)
          Retrieves records for organization account dump and outputs file based on user preferences
 StringBuilder buildOrganizationFundingDumpFile(String principalId, String fieldSeperator, String textDelimiter)
          Retrieves records for organization funding dump and outputs file based on user preferences
 StringBuilder buildOrganizationMonthlyDumpFile(String principalId, String fieldSeperator, String textDelimiter)
          Retrieves records for organization monthly dump and outputs file based on user preferences
protected  String constructAccountDumpLine(PendingBudgetConstructionGeneralLedger pendingEntry, String textDelimiter, String fieldSeperator)
          Constructs a line for the Account Dump Report
protected  String constructFundingDumpLine(PendingBudgetConstructionAppointmentFunding fundingRecord, String fieldSeperator, String textDelimiter)
          Constructs a line of the Funding Dump File
protected  String constructMonthlyDumpLine(BudgetConstructionMonthly monthlyRecord, String fieldSeperator, String textDelimiter)
          Constructs a monthly dump file line
protected  List<BudgetConstructionAccountDump> getBudgetConstructionAccountDump(String principalId)
          Retrieves all BudgetConstructionAccountDump by principalId
protected  List<BudgetConstructionMonthly> getBudgetConstructionMonthlyRecords(BudgetConstructionAccountDump accountRecord)
          Retrieves all BudgetConstructionMonthly sorted by "financialObjectCode", "financialSubObjectCode"
protected  List<PendingBudgetConstructionAppointmentFunding> getPendingBudgetConstructionAppointmentFundingRecords(BudgetConstructionAccountDump accountRecord)
          Retrieves all PendingBudgetConstructionAppointmentFunding sorted by "financialObjectCode", "financialSubObjectCode", "positionNumber", "emplid"
protected  List<PendingBudgetConstructionGeneralLedger> getPendingBudgetConstructionGeneralLedgerRecords(BudgetConstructionAccountDump accountRecord)
          Retrieves all PendingBudgetConstructionGeneralLedger sorted by financialObjectCode and financialSubObjectCode
 void setBusinessObjectService(org.kuali.rice.kns.service.BusinessObjectService businessObjectService)
           
 void setReportDumpDao(ReportDumpDao reportDumpDao)
          Sets the reportDumpDao attribute value.
 void updateAccountDump(String principalId)
          Rebuilds the account dump maintenance table.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

ReportExportServiceImpl

public ReportExportServiceImpl()
Method Detail

updateAccountDump

public void updateAccountDump(String principalId)
Description copied from interface: ReportExportService
Rebuilds the account dump maintenance table.

Specified by:
updateAccountDump in interface ReportExportService
Parameters:
principalId - - current user who is running the dump
See Also:
ReportExportService.updateAccountDump(java.lang.String)

buildOrganizationAccountDumpFile

public StringBuilder buildOrganizationAccountDumpFile(String principalId,
                                                      String fieldSeperator,
                                                      String textDelimiter)
Description copied from interface: ReportExportService
Retrieves records for organization account dump and outputs file based on user preferences

Specified by:
buildOrganizationAccountDumpFile in interface ReportExportService
Parameters:
principalId - - current user who is running the dump
fieldSeperator - - string to seperate fields
textDelimiter - - string for text delimiter
See Also:
org.kuali.kfs.module.bc.document.service.ReportExportService#buildAccountDumpFile(java.lang.String, java.lang.String, java.lang.String)

buildOrganizationFundingDumpFile

public StringBuilder buildOrganizationFundingDumpFile(String principalId,
                                                      String fieldSeperator,
                                                      String textDelimiter)
Description copied from interface: ReportExportService
Retrieves records for organization funding dump and outputs file based on user preferences

Specified by:
buildOrganizationFundingDumpFile in interface ReportExportService
Parameters:
principalId - - current user who is running the dump
fieldSeperator - - string to seperate fields
textDelimiter - - string for text delimiter
See Also:
// read u_where %\ // (univ_fiscal_yr.ld_pndbc_apptfnd_t = univ_fiscal_yr.ld_bcn_acct_dump_t & %\ // fin_coa_cd.ld_pndbc_apptfnd_t = fin_coa_cd.ld_bcn_acct_dump_t & %\ // account_nbr.ld_pndbc_apptfnd_t = account_nbr.ld_bcn_acct_dump_t & %\ // sub_acct_nbr.ld_pndbc_apptfnd_t = sub_acct_nbr.ld_bcn_acct_dump_t) %\ // order by "fin_object_cd , fin_sub_obj_cd, position_nbr, emplid" // // // if ($empty(ld_pndbc_apptfnd_t) = 0) // repeat // ;build the output line // ;note that gennum and genpct are used to strip numbers of commas // ;bcpct and bcfte are used also to force the display of decimals // $line$ = "%%univ_fiscal_yr.ld_pndbc_apptfnd_t%%$sep$" // $line$ = "%%$line$%%$dlm$%%fin_coa_cd.ld_pndbc_apptfnd_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%account_nbr.ld_pndbc_apptfnd_t%%$dlm$%%$sep$" // ;add in org code field // $line$ = "%%$line$%%$dlm$%%$org_cd$%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%sub_acct_nbr.ld_pndbc_apptfnd_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%fin_object_cd.ld_pndbc_apptfnd_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%fin_sub_obj_cd.ld_pndbc_apptfnd_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%position_nbr.ld_pndbc_apptfnd_t%%$dlm$%%$sep$" // ;add in position and job rank fields // $line$ = "%%$line$%%$dlm$%%pos_descr.ld_bcn_pos_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%setid_salary.ld_bcn_pos_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%pos_sal_plan_dflt.ld_bcn_pos_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%pos_grade_dflt.ld_bcn_pos_t%%$dlm$%%$sep$" // ;add in work months and pay months // $line$ = "%%$line$%%iu_norm_work_months.ld_bcn_pos_t%%$sep$" // $line$ = "%%$line$%%iu_pay_months.ld_bcn_pos_t%%$sep$" // ;add in incumbent fields // $line$ = "%%$line$%%$dlm$%%emplid.ld_pndbc_apptfnd_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%person_nm.ld_bcn_intincbnt_t%%$dlm$%%$sep$" // $line$ = %\ // "%%$line$%%$dlm$%%iu_classif_level.ld_bcn_intincbnt_t%%$dlm$%%$sep$" // ;add in the admin post // $line$ = %\ // "%%$line$%%$dlm$%%admin_post.ld_bcn_adm_post_t%%$dlm$%%$sep$" // ;add in the csf info // $gennum$ = pos_csf_amt.ld_bcn_csf_trckr_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $bcfte$ = pos_csf_fte_qty.ld_bcn_csf_trckr_t // $line$ = "%%$line$%%$bcfte$%%$sep$" // $bcpct$ = pos_csf_tm_pct.ld_bcn_csf_trckr_t // $line$ = "%%$line$%%$bcpct$%%$sep$" // ;rest of bcaf // $line$ = "%%$line$%%$dlm$%%appt_fnd_dur_cd.ld_pndbc_apptfnd_t%%$dlm$%%$sep$" // $gennum$ = appt_rqst_csf_amt.ld_pndbc_apptfnd_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $bcfte$ = appt_rqcsf_fte_qty.ld_pndbc_apptfnd_t // $line$ = "%%$line$%%$bcfte$%%$sep$" // $bcpct$ = appt_rqcsf_tm_pct.ld_pndbc_apptfnd_t // $line$ = "%%$line$%%$bcpct$%%$sep$" // $gennum$ = appt_tot_intnd_amt.ld_pndbc_apptfnd_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $bcfte$ = appt_totintfte_qty.ld_pndbc_apptfnd_t // $line$ = "%%$line$%%$bcfte$%%$sep$" // $gennum$ = appt_rqst_amt.ld_pndbc_apptfnd_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $bcpct$ = appt_rqst_tm_pct.ld_pndbc_apptfnd_t // $line$ = "%%$line$%%$bcpct$%%$sep$" // $bcfte$ = appt_rqst_fte_qty.ld_pndbc_apptfnd_t // $line$ = "%%$line$%%$bcfte$%%$sep$" // $gennum$ = appt_rqst_pay_rt.ld_pndbc_apptfnd_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $line$ = "%%$line$%%$dlm$%%appt_fnd_dlt_cd.ld_pndbc_apptfnd_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%appt_fnd_mo.ld_pndbc_apptfnd_t%%$sep$" // $line$ = "%%$line$%%$dlm$%%appt_fnd_reason_cd.ld_bcn_af_reason_t%%$dlm$%%$sep$" // ; rc_cd added 12/20/2004 - gwp // $line$ = "%%$line$%%$dlm$%%$rc_cd$%%$dlm$" // // $line$ = "%%$line$%%^"

buildOrganizationMonthlyDumpFile

public StringBuilder buildOrganizationMonthlyDumpFile(String principalId,
                                                      String fieldSeperator,
                                                      String textDelimiter)
Description copied from interface: ReportExportService
Retrieves records for organization monthly dump and outputs file based on user preferences

Specified by:
buildOrganizationMonthlyDumpFile in interface ReportExportService
Parameters:
principalId - - current user who is running the dump
fieldSeperator - - string to seperate fields
textDelimiter - - string for text delimiter
See Also:
// read u_where %\ // (univ_fiscal_yr.ld_bcnstr_month_t = univ_fiscal_yr.ld_bcn_acct_dump_t & %\ // fin_coa_cd.ld_bcnstr_month_t = fin_coa_cd.ld_bcn_acct_dump_t & %\ // account_nbr.ld_bcnstr_month_t = account_nbr.ld_bcn_acct_dump_t & %\ // sub_acct_nbr.ld_bcnstr_month_t = sub_acct_nbr.ld_bcn_acct_dump_t) %\ // order by "fin_object_cd, fin_sub_obj_cd" // endif // // if ($empty(ld_bcnstr_month_t) = 0) // repeat // ;build the output line // ;note that gennum are used to strip numbers of commas // $line$ = "%%$dlm$%%fs_origin_cd.ld_bcnstr_month_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%fdoc_nbr.ld_bcnstr_month_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%univ_fiscal_yr.ld_bcnstr_month_t%%$sep$" // $line$ = "%%$line$%%$dlm$%%fin_coa_cd.ld_bcnstr_month_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%account_nbr.ld_bcnstr_month_t%%$dlm$%%$sep$" // ;add in org code field // $line$ = "%%$line$%%$dlm$%%$org_cd$%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%sub_acct_nbr.ld_bcnstr_month_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%fin_object_cd.ld_bcnstr_month_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%fin_sub_obj_cd.ld_bcnstr_month_t%%$dlm$%%$sep$" // $line$ = %\ // "%%$line$%%$dlm$%%fin_balance_typ_cd.ld_bcnstr_month_t%%$dlm$%%$sep$" // $line$ = "%%$line$%%$dlm$%%fin_obj_typ_cd.ld_bcnstr_month_t%%$dlm$%%$sep$" // $gennum$ = fdoc_ln_mo1_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $gennum$ = fdoc_ln_mo2_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $gennum$ = fdoc_ln_mo3_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $gennum$ = fdoc_ln_mo4_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $gennum$ = fdoc_ln_mo5_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $gennum$ = fdoc_ln_mo6_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $gennum$ = fdoc_ln_mo7_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $gennum$ = fdoc_ln_mo8_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $gennum$ = fdoc_ln_mo9_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $gennum$ = fdoc_ln_mo10_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $gennum$ = fdoc_ln_mo11_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // $gennum$ = fdoc_ln_mo12_amt.ld_bcnstr_month_t // $line$ = "%%$line$%%$gennum$%%$sep$" // ; rc_cd added 12/20/2004 - gwp // $line$ = "%%$line$%%$dlm$%%$rc_cd$%%$dlm$" // // $line$ = "%%$line$%%^"

buildAccountDumpFile

public StringBuilder buildAccountDumpFile(String principalId,
                                          String fieldSeperator,
                                          String textDelimiter,
                                          Integer universityFiscalYear,
                                          String chartOfAccountsCode,
                                          String accountNumber,
                                          String subAccountNumber)
Description copied from interface: ReportExportService
Retrieves records for account dump and outputs file based on user preferences

Specified by:
buildAccountDumpFile in interface ReportExportService
Returns:
See Also:
ReportExportService.buildAccountDumpFile(java.lang.String, java.lang.String, java.lang.String, java.lang.Integer, java.lang.String, java.lang.String, java.lang.String)

buildAccountFundingDumpFile

public StringBuilder buildAccountFundingDumpFile(String principalId,
                                                 String fieldSeperator,
                                                 String textDelimiter,
                                                 Integer universityFiscalYear,
                                                 String chartOfAccountsCode,
                                                 String accountNumber,
                                                 String subAccountNumber)
Description copied from interface: ReportExportService
Retrieves records for organization funding dump and outputs file based on user preferences

Specified by:
buildAccountFundingDumpFile in interface ReportExportService
Returns:
See Also:
ReportExportService.buildAccountFundingDumpFile(java.lang.String, java.lang.String, java.lang.String, java.lang.Integer, java.lang.String, java.lang.String, java.lang.String)

buildAccountMonthlyDumpFile

public StringBuilder buildAccountMonthlyDumpFile(String principalId,
                                                 String fieldSeperator,
                                                 String textDelimiter,
                                                 Integer universityFiscalYear,
                                                 String chartOfAccountsCode,
                                                 String accountNumber,
                                                 String subAccountNumber)
Description copied from interface: ReportExportService
Retrieves records for account monthly dump and outputs file based on user preferences

Specified by:
buildAccountMonthlyDumpFile in interface ReportExportService
Returns:
See Also:
ReportExportService.buildAccountMonthlyDumpFile(java.lang.String, java.lang.String, java.lang.String, java.lang.Integer, java.lang.String, java.lang.String, java.lang.String)

setReportDumpDao

public void setReportDumpDao(ReportDumpDao reportDumpDao)
Sets the reportDumpDao attribute value.

Parameters:
reportDumpDao - The reportDumpDao to set.

setBusinessObjectService

public void setBusinessObjectService(org.kuali.rice.kns.service.BusinessObjectService businessObjectService)
See Also:
org.kuali.kfs.module.bc.document.service.ReportExportService#setBusinessObjectService(org.kuali.rice.kns.service.BusinessObjectService)

getPendingBudgetConstructionGeneralLedgerRecords

protected List<PendingBudgetConstructionGeneralLedger> getPendingBudgetConstructionGeneralLedgerRecords(BudgetConstructionAccountDump accountRecord)
Retrieves all PendingBudgetConstructionGeneralLedger sorted by financialObjectCode and financialSubObjectCode

Parameters:
accountRecord -
Returns:

getPendingBudgetConstructionAppointmentFundingRecords

protected List<PendingBudgetConstructionAppointmentFunding> getPendingBudgetConstructionAppointmentFundingRecords(BudgetConstructionAccountDump accountRecord)
Retrieves all PendingBudgetConstructionAppointmentFunding sorted by "financialObjectCode", "financialSubObjectCode", "positionNumber", "emplid"

Parameters:
accountRecord -
Returns:

getBudgetConstructionMonthlyRecords

protected List<BudgetConstructionMonthly> getBudgetConstructionMonthlyRecords(BudgetConstructionAccountDump accountRecord)
Retrieves all BudgetConstructionMonthly sorted by "financialObjectCode", "financialSubObjectCode"

Parameters:
accountRecord -
Returns:

getBudgetConstructionAccountDump

protected List<BudgetConstructionAccountDump> getBudgetConstructionAccountDump(String principalId)
Retrieves all BudgetConstructionAccountDump by principalId

Parameters:
principalId -
Returns:

constructAccountDumpLine

protected String constructAccountDumpLine(PendingBudgetConstructionGeneralLedger pendingEntry,
                                          String textDelimiter,
                                          String fieldSeperator)
Constructs a line for the Account Dump Report

Parameters:
pendingEntry -
textDelimiter -
fieldSeperator -
Returns:

constructFundingDumpLine

protected String constructFundingDumpLine(PendingBudgetConstructionAppointmentFunding fundingRecord,
                                          String fieldSeperator,
                                          String textDelimiter)
Constructs a line of the Funding Dump File

Parameters:
fundingRecord -
fieldSeperator -
textDelimiter -
Returns:

constructMonthlyDumpLine

protected String constructMonthlyDumpLine(BudgetConstructionMonthly monthlyRecord,
                                          String fieldSeperator,
                                          String textDelimiter)
Constructs a monthly dump file line

Parameters:
monthlyRecord -
fieldSeperator -
textDelimiter -
Returns:


Copyright © 2005-2012 The Kuali Foundation. All Rights Reserved.