def get_on_display_products(self):
probe_match_list = self.match_product_in_scene['probe_match_fk'].values.tolist()
on_display_products = pd.DataFrame(columns=["probe_match_fk", "smart_attribute"])
if probe_match_list:
query = PEPSICOUK_Queries.on_display_products_query(probe_match_list)
on_display_products = pd.read_sql_query(query, self.rds_conn.db)
return on_display_products
def get_store_data_by_store_id(self):
store_id = self.store_id if self.store_id else self.session_info[
'store_fk'].values[0]
query = PEPSICOUK_Queries.get_store_data_by_store_id(store_id)
query_result = pd.read_sql_query(query, self.rds_conn.db)
return query_result
def get_probe_group(self):
query = PEPSICOUK_Queries.get_probe_group(self.session_uid)
probe_group = pd.read_sql_query(query, self.rds_conn.db)
return probe_group
def get_match_display_in_scene(self):
query = PEPSICOUK_Queries.get_match_display(self.session_uid)
match_display = pd.read_sql_query(query, self.rds_conn.db)
return match_display
def get_custom_entity_data(self):
query = PEPSICOUK_Queries.get_custom_entities_query()
custom_entity_data = pd.read_sql_query(query, self.rds_conn.db)
return custom_entity_data
def get_all_kpi_external_targets(self):
query = PEPSICOUK_Queries.get_kpi_external_targets(self.visit_date)
external_targets = pd.read_sql_query(query, self.rds_conn.db)
return external_targets
def get_kpi_score_values_df(self):
query = PEPSICOUK_Queries.get_kpi_score_values()
query_result = pd.read_sql_query(query, self.rds_conn.db)
return query_result
def get_scene_to_store_area_map(self):
query = PEPSICOUK_Queries.get_scene_store_area(self.session_uid)
query_result = pd.read_sql_query(query, self.rds_conn.db)
return query_result
def get_store_areas(self):
query = PEPSICOUK_Queries.get_all_store_areas()
query_result = pd.read_sql_query(query, self.rds_conn.db)
return query_result
