jlrdspkg: package for jlrds app

#手工运行
mrpt_calc_runAll_target(FPeriod = 1)
mrpt_calc_runAll_target(FPeriod = 2)
mrpt_calc_runAll_target(FPeriod = 3)
mrpt_calc_runAll_target(FPeriod = 4)
mrpt_calc_runAll_target(FPeriod = 5)


mrpt_calc_mpv(FPeriod = 10)


mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 1)

mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 2)

mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 3)

mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 4)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 6)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 7)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 8)

mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 9)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 11)








#RPA运行
mrpt_calc_runAll_rpa(FPeriod = 6)
mrpt_calc_runAll_rpa(FPeriod = 7)
mrpt_calc_runAll_rpa(FPeriod = 8)
mrpt_calc_runAll_rpa(FPeriod = 9)





graph_rpa_period(FYear = 2021,FPeriod = 6)

graph_rpa_period(FYear = 2021,FPeriod = 7)

graph_rpa_period(FYear = 2021,FPeriod = 8)
graph_rpa_period(FYear = 2021,FPeriod = 9)







mrpt_calc_cumSum_Period_actual


















mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 1)





conn=tsda::conn_rds('jlrds')
FYear =2019
FPeriod =1
plan_table ='t_mrpt2_calcPlan_actual'
src_table = 't_mrpt_actual'
res_table = 't_mrpt3_res_actual'
data_table = 'vw_mrpt_actual_count'

  mrpt_calc_plan(conn = conn,FYear = FYear,FPeriod = FPeriod,plan_table = plan_table,data_table = data_table)
  mrpt_calc_brandChannel_step1_setDone(conn = conn,FYear = FYear,FPeriod = FPeriod,plan_table = plan_table)
  mrpt_calc_brandChannel_step1_writeRes(conn = conn,FYear = FYear,FPeriod = FPeriod,res_table = res_table,src_table = src_table,plan_table = plan_table )
  mrpt_calc_brandChannel_step1_updateStatus(conn = conn,FYear = FYear,FPeriod = FPeriod,plan_table = plan_table)
  mrpt_calc_brandChannel_step2_writeRes(conn = conn,FYear = FYear,FPeriod = FPeriod,res_table = res_table,plan_table = plan_table)
  mrpt_calc_brandChannel_step2_updateStatus(conn = conn,FYear = FYear,FPeriod = FPeriod,plan_table = plan_table)
  mrpt_calc_brandChannel_step3_setDone(conn = conn,FYear = FYear,FPeriod = FPeriod,plan_table = plan_table)
  mrpt_calc_brandChannel_step3_writeRes(conn = conn,FYear = FYear,FPeriod = FPeriod,res_table = res_table,plan_table = plan_table,src_table = src_table)
  mrpt_calc_brandChannel_step3_updateStatus(conn = conn,FYear = FYear,FPeriod = FPeriod,plan_table = plan_table)
  mrpt_calc_brandChannel_step4_writeRes(conn = conn,FYear = FYear,FPeriod = FPeriod,res_table = res_table,plan_table = plan_table)
  mrpt_calc_brandChannel_step4_updateStatus(conn = conn,FYear = FYear,FPeriod = FPeriod,plan_table = plan_table)
  mrpt_calc_brandChannel_step5_writeRes(conn = conn,FYear = FYear,FPeriod = FPeriod,res_table = res_table,plan_table = plan_table)
  mrpt_calc_brandChannel_step5_updateStatus(conn = conn,FYear = FYear,FPeriod = FPeriod,plan_table = plan_table)
  mrpt_calc_brandChannel_step6_writeRes(conn = conn,FYear = FYear,FPeriod = FPeriod,res_table = res_table,plan_table = plan_table)
  mrpt_calc_brandChannel_step6_updateStatus(conn = conn,FYear = FYear,FPeriod = FPeriod,plan_table = plan_table)









mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 1)
mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 2)
mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 3)
mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 4)
mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 5)
mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 6)
mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 7)
mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 8)
mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 9)
mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 10)
mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 11)
mrpt_calc_runAll_actual(FYear = 2019,FPeriod = 12)



mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 1)
mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 2)
mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 3)
mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 4)
mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 5)
mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 6)
mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 7)
mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 8)
mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 9)
mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 10)
mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 11)
mrpt_calc_runAll_actual(FYear = 2020,FPeriod = 12)




mrpt_calc_cumSum_Period_actual

mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 1)
mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 2)
mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 3)
mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 4)
mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 5)
mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 6)
mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 7)
mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 8)
mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 9)
mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 10)
mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 11)
mrpt_calc_cumSum_Period_actual(FYear = 2019,FPeriod = 12)



mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 1)
mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 2)
mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 3)
mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 4)
mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 5)
mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 6)
mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 7)
mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 8)
mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 9)
mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 10)
mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 11)
mrpt_calc_cumSum_Period_actual(FYear = 2020,FPeriod = 12)







mrpt_calc_runAll_budget(FPeriod = 1)
mrpt_calc_runAll_budget(FPeriod = 2)
mrpt_calc_runAll_budget(FPeriod = 3)
mrpt_calc_runAll_budget(FPeriod = 4)
mrpt_calc_runAll_budget(FPeriod = 5)
mrpt_calc_runAll_budget(FPeriod = 6)
mrpt_calc_runAll_budget(FPeriod = 7)
mrpt_calc_runAll_budget(FPeriod = 8)



#历史数据计算累计数,没有重新按图处理，沿用已开发的功能，

mrpt_calc_cumSum_Year(FYear = 2019)
mrpt_calc_cumSum_Year(FYear = 2020)

graph_actual_year(FYear = 2021)
mrpt_calc_cumSum_Year(FYear = 2021)




#执行预算计算累计数
mrpt_calc_cumSum_Period_budget(FYear = 2021,FPeriod = 1)
mrpt_calc_cumSum_Period_budget(FYear = 2021,FPeriod = 2)
mrpt_calc_cumSum_Period_budget(FYear = 2021,FPeriod = 3)
mrpt_calc_cumSum_Period_budget(FYear = 2021,FPeriod = 4)
mrpt_calc_cumSum_Period_budget(FYear = 2021,FPeriod = 5)
mrpt_calc_cumSum_Period_budget(FYear = 2021,FPeriod = 6)
mrpt_calc_cumSum_Period_budget(FYear = 2021,FPeriod = 7)
mrpt_calc_cumSum_Period_budget(FYear = 2021,FPeriod = 8)
mrpt_calc_cumSum_Period_budget(FYear = 2021,FPeriod = 9)

#当期数据
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 1)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 2)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 3)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 4)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 5)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 6)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 7)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 8)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 9)




mrpt_md_rule_bw2_dim_allocAll(FYear = 2021,FPeriod = 8)
mrpt_md_rule_bw2_dim_allocAll(FYear = 2021,FPeriod = 9)


mrpt_run(FPeriod = 8)
mrpt_run(FPeriod = 9)







mrpt_run(FYear = 2021,FPeriod = 7)

graph_rpa_period(FYear = 2021,FPeriod = 7)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 7)




mrpt_run(FYear = 2021,FPeriod = 8)

graph_rpa_period(FYear = 2021,FPeriod = 8)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 8)



mrpt_run(FYear = 2021,FPeriod = 9)
graph_rpa_period(FYear = 2021,FPeriod = 9)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 9)


mrpt_run(FYear = 2021,FPeriod = 10)
graph_rpa_period(FYear = 2021,FPeriod = 10)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 10)




mrpt_run(FYear = 2021,FPeriod = 11)
graph_rpa_period(FYear = 2021,FPeriod = 11)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 11)


mrpt_run(FYear = 2021,FPeriod = 12)
graph_rpa_period(FYear = 2021,FPeriod = 12)
mrpt_calc_cumSum_Period_res(FYear = 2021,FPeriod = 12)




mrpt_diff_calc(FPeriod = 8)
mrpt_diff_calc(FPeriod = 9)
mrpt_diff_calc(FPeriod = 10)







mrpt_md_rule_bw2_dim_allocation(FDimName = 'F30_customerNumber_in',
                                 FDimTable = 't_mrpt_ds_bw_F30_customerNumber_in',
                                 FPrefix = '',
                                 FYear = 2021,
                                 FPeriod = 8,opt = TRUE)