def calculate_kpis(self):
# self.timer.start()
# self.scene_generator.scene_score()
template_path = os.path.join(
os.path.dirname(os.path.dirname(os.path.realpath(__file__))),
'Data', 'Brand Score.xlsx')
diageo_generator = DIAGEOGenerator(self._data_provider, None,
self.common)
diageo_generator.diageo_global_tap_brand_score_function(
template_path=template_path,
rank_kpi=False,
sub_category_rank_kpi=False,
save_scene_level=True,
calculate_components=True)
self.common.commit_results_data(result_entity='scene')
class DIAGEOIEToolBox:
def __init__(self, data_provider, output):
self.output = output
self.data_provider = data_provider
self.store_id = self.data_provider[Data.STORE_FK]
self.scif = self.data_provider[Data.SCENE_ITEM_FACTS]
self.output = output
self.common = Common(self.data_provider)
self.commonV2 = CommonV2(self.data_provider)
self.diageo_generator = DIAGEOGenerator(self.data_provider,
self.output,
self.common,
menu=True)
def main_calculation(self):
"""
This function calculates the KPI results.
"""
# SOS Out Of The Box kpis
sos_res = self.diageo_generator.global_sos_calculation(
include_posm=True)
self.commonV2.save_json_to_new_tables(sos_res)
# sos by scene type
self.diageo_generator.sos_by_scene_type_with_posm(self.commonV2)
# Global assortment kpis
assortment_res = self.diageo_generator.diageo_global_grouping_assortment_calculation(
)
self.commonV2.save_json_to_new_tables(assortment_res)
# Global Menu kpis
menus_res = self.diageo_generator.diageo_global_new_share_of_menu_function(
)
self.commonV2.save_json_to_new_tables(menus_res)
# Global Tap Brand Score
template_path = os.path.join(
os.path.dirname(os.path.dirname(os.path.realpath(__file__))),
'Data', 'Brand Score.xlsx')
res_dict = self.diageo_generator.diageo_global_tap_brand_score_function(
template_path, save_to_tables=False, calculate_components=True)
self.commonV2.save_json_to_new_tables(res_dict)
# Global Visible to Consumer function
sku_list = filter(
None, self.scif[self.scif['product_type'] ==
'SKU'].product_ean_code.tolist())
res_dict = self.diageo_generator.diageo_global_visible_percentage(
sku_list)
if res_dict:
self.commonV2.save_json_to_new_tables(res_dict)
# committing to new tables
self.commonV2.commit_results_data()
# committing to the old tables
self.common.commit_results_data()
