|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.kuali.kfs.module.bc.document.service.impl.ReportExportServiceImpl
@Transactional public class ReportExportServiceImpl
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 |
---|
public ReportExportServiceImpl()
Method Detail |
---|
public void updateAccountDump(String principalId)
ReportExportService
updateAccountDump
in interface ReportExportService
principalId
- - current user who is running the dumpReportExportService.updateAccountDump(java.lang.String)
public StringBuilder buildOrganizationAccountDumpFile(String principalId, String fieldSeperator, String textDelimiter)
ReportExportService
buildOrganizationAccountDumpFile
in interface ReportExportService
principalId
- - current user who is running the dumpfieldSeperator
- - string to seperate fieldstextDelimiter
- - string for text delimiterorg.kuali.kfs.module.bc.document.service.ReportExportService#buildAccountDumpFile(java.lang.String, java.lang.String,
java.lang.String)
public StringBuilder buildOrganizationFundingDumpFile(String principalId, String fieldSeperator, String textDelimiter)
ReportExportService
buildOrganizationFundingDumpFile
in interface ReportExportService
principalId
- - current user who is running the dumpfieldSeperator
- - string to seperate fieldstextDelimiter
- - string for text delimiter// 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$%%^"
public StringBuilder buildOrganizationMonthlyDumpFile(String principalId, String fieldSeperator, String textDelimiter)
ReportExportService
buildOrganizationMonthlyDumpFile
in interface ReportExportService
principalId
- - current user who is running the dumpfieldSeperator
- - string to seperate fieldstextDelimiter
- - string for text delimiter// 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$%%^"
public StringBuilder buildAccountDumpFile(String principalId, String fieldSeperator, String textDelimiter, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String subAccountNumber)
ReportExportService
buildAccountDumpFile
in interface ReportExportService
ReportExportService.buildAccountDumpFile(java.lang.String, java.lang.String,
java.lang.String, java.lang.Integer, java.lang.String, java.lang.String, java.lang.String)
public StringBuilder buildAccountFundingDumpFile(String principalId, String fieldSeperator, String textDelimiter, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String subAccountNumber)
ReportExportService
buildAccountFundingDumpFile
in interface ReportExportService
ReportExportService.buildAccountFundingDumpFile(java.lang.String,
java.lang.String, java.lang.String, java.lang.Integer, java.lang.String, java.lang.String, java.lang.String)
public StringBuilder buildAccountMonthlyDumpFile(String principalId, String fieldSeperator, String textDelimiter, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String subAccountNumber)
ReportExportService
buildAccountMonthlyDumpFile
in interface ReportExportService
ReportExportService.buildAccountMonthlyDumpFile(java.lang.String,
java.lang.String, java.lang.String, java.lang.Integer, java.lang.String, java.lang.String, java.lang.String)
public void setReportDumpDao(ReportDumpDao reportDumpDao)
reportDumpDao
- The reportDumpDao to set.public void setBusinessObjectService(org.kuali.rice.kns.service.BusinessObjectService businessObjectService)
org.kuali.kfs.module.bc.document.service.ReportExportService#setBusinessObjectService(org.kuali.rice.kns.service.BusinessObjectService)
protected List<PendingBudgetConstructionGeneralLedger> getPendingBudgetConstructionGeneralLedgerRecords(BudgetConstructionAccountDump accountRecord)
accountRecord
-
protected List<PendingBudgetConstructionAppointmentFunding> getPendingBudgetConstructionAppointmentFundingRecords(BudgetConstructionAccountDump accountRecord)
accountRecord
-
protected List<BudgetConstructionMonthly> getBudgetConstructionMonthlyRecords(BudgetConstructionAccountDump accountRecord)
accountRecord
-
protected List<BudgetConstructionAccountDump> getBudgetConstructionAccountDump(String principalId)
principalId
-
protected String constructAccountDumpLine(PendingBudgetConstructionGeneralLedger pendingEntry, String textDelimiter, String fieldSeperator)
pendingEntry
- textDelimiter
- fieldSeperator
-
protected String constructFundingDumpLine(PendingBudgetConstructionAppointmentFunding fundingRecord, String fieldSeperator, String textDelimiter)
fundingRecord
- fieldSeperator
- textDelimiter
-
protected String constructMonthlyDumpLine(BudgetConstructionMonthly monthlyRecord, String fieldSeperator, String textDelimiter)
monthlyRecord
- fieldSeperator
- textDelimiter
-
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |