def kean_proj_run_actuals(company, amr_scenario):
conn_ins = db_config_part(connection.settings_dict)
print("we are at ACTUALS", company, amr_scenario)
actuals_month_dates_list = date_utils.get_dates_info_from_amr_scenario(
amr_scenario)[0]
actuals.actuals_main(conn_ins, company, amr_scenario,
actuals_month_dates_list)
def test_run_actuals(company, amr_scenario):
# print (amr_scenario);
actuals_month_dates_list,\
budget_month_dates_list,\
estimate_month_dates_list = date_utils.get_dates_info_from_amr_scenario(amr_scenario)
# print (estimate_month_dates_list);
conn_ins = db_config_part(connection.settings_dict)
print(
"actuals function called.............................................."
)
def kean_proj_run_respreads(selected_company, amr_scenario, budget_scenario):
conn_ins = db_config_part(connection.settings_dict)
respreads_period_range_list = date_utils.get_dates_info_from_amr_scenario(
amr_scenario)[1]
print(respreads_period_range_list)
respreads.respreads_main_details(conn_ins, selected_company, amr_scenario,
budget_scenario,
respreads_period_range_list)
def kean_proj_run_variance_report(company, amr_scenario, amr_version,
budget_scenario):
conn_ins = db_config_part(connection.settings_dict)
actuals_month_dates_list = date_utils.get_dates_info_from_amr_scenario(
amr_scenario)[0]
download_file_path_ytd, download_file_path_mtd = disp_controller_var.variance_report(
conn_ins, company, amr_scenario, amr_version, budget_scenario, 'vf',
actuals_month_dates_list)
return download_file_path_ytd, download_file_path_mtd
def kean_proj_run_dispatch(company, amr_scenario):
conn_ins = db_config_part(connection.settings_dict)
print(company, amr_scenario)
forecast_year_list = list(
range(
int(amr_scenario.split(" ")[0]) + 1,
int(amr_scenario.split(" ")[0]) + 5))
print("we are at DISPATCH", company, amr_scenario, forecast_year_list)
estimate_plus_forecast_month_dates_list = date_utils.get_dates_info_from_amr_scenario(
amr_scenario)[2]
for selected_year in forecast_year_list:
estimate_plus_forecast_month_dates_list += date_utils.get_month_dates_list(
selected_year, 1, 12)
estimate.estimate_main(conn_ins, company, amr_scenario,
estimate_plus_forecast_month_dates_list)
def kean_proj_copy_from_selected(selected_company, current_scenario,
selected_scenario, fsli, module):
conn_ins = db_config_part(connection.settings_dict)
actuals_month_dates_list,\
budget_month_dates_list,\
estimate_month_dates_list = date_utils.get_dates_info_from_amr_scenario(selected_scenario)
selected_period_list = []
current_year = int(selected_scenario.split(" ")[0])
year_range = list(range(current_year + 1, current_year + 5))
forecast_month_dates_list = []
for temp_year in year_range:
forecast_month_dates_list += date_utils.get_month_dates_list(
temp_year, 1, 12)
if module == 'actual':
selected_period_list = actuals_month_dates_list
if module == 'estimate':
selected_period_list = estimate_month_dates_list
if module == 'forecast':
selected_period_list = forecast_month_dates_list
if module == 'full':
selected_period_list = budget_month_dates_list
if module == 'est_forecast':
selected_period_list = estimate_month_dates_list + forecast_month_dates_list
print(module, selected_period_list)
db_controller.copy_from_selected(conn_ins, selected_company,
current_scenario, selected_scenario, fsli,
selected_period_list)
# db_controller.set_connection_instance_global(host,user,password,database);
conn_ins = db_controller.set_connection_instance_global(
host, user, password, database)
return conn_ins
if __name__ == "__main__":
print("------------------AMR processing-------------------")
"""
step 1: preset the arguments for AMR
"""
actuals_month_dates_list,\
budget_month_dates_list,\
estimate_month_dates_list = date_utils.get_dates_info_from_amr_scenario(AMR_SCENARIO)
# print (actuals_month_dates_list);
# sys.exit();
# print (estimate_month_dates_list);
"""
step 2: config db connection
"""
conn_ins = db_config_part()
"""
step 3: data input/upload to KEAN for AMR
"""
""" new budget data and budget adjustment data upload logic is to be implemented if needed. Because budget data should not change over time """
""" also we made a lot of hardcoded adjustment to it because the input file is not as clean as we want """
# budget_uploader.budget_data_upload(conn_ins, COMPANY, BUDGET_SCENARIO);
""" refactored and optimized !"""