def insert_product_category(self):
category = input("Enter category ")
additional_info = input("Enter additional_info ")
prod_categ = tables.ProductCategory(category, additional_info)
self.db.add_instanse(prod_categ)
self.db.commit_changes()
view.print_action("insert", "product_category ", prod_categ.id)
def get_product_name_by_id(self):
while True:
print("Enter product id ")
prod_id = input()
if not prod_id.isnumeric() or int(prod_id) < 1:
print("Incorrect prod_id value")
continue
break
res = self.db.get_product_name_by_id(prod_id)
if not res:
print("No data for such input")
else:
view.print_action("get name", "Product", str(tuple(res)))
def get_products_below_cost(self):
while True:
print("Cost")
cost = input()
if not cost.isnumeric() or int(cost) < 1:
print("Incorrect prod_id value")
continue
break
res = self.db.get_products_below_cost(cost)
if not res:
print("No data for such input")
else:
view.print_action("get below cost","produc", tuple(res))
def get_average_time_in_road_for_product(self):
while True:
print("Enter product id ")
prod_id = input()
if not prod_id.isnumeric() or int(prod_id) < 1:
print("Incorrect prod_id value")
continue
prod_id = int(prod_id)
res = list(self.db.get_avg_time_in_road_for_product(prod_id))
if not res:
print("No data for such input")
break
view.print_action("get average time in road for", f"product with id {prod_id}", res[0][0])
break
def get_time_in_road(self):
while True:
print("Enter consignment id ")
cons_id = input()
if not cons_id.isnumeric() or int(cons_id) < 1:
print("Incorrect cons_id value")
continue
cons_id = int(cons_id)
res = list(self.db.get_time_in_road(cons_id))
if not res:
print("No data for such input")
break
view.print_action(f"get time in road", "consignment with id {cons_id} ", res[0][0])
break
def get_fulness_of_warehouse(self):
while True:
print("Enter warehouse id ")
war_id = input()
if not war_id.isnumeric() or int(war_id) < 1:
print("Incorrect war_id value")
continue
war_id = int(war_id)
res = list(self.db.get_fullness(war_id))
if not res:
print("No data for such input")
break
view.print_action("get fullness", "warehouse ", str(res[0][0] * 100) + '%')
break
def get_sold_volume_between_dates_product(self):
while True:
print("Enter product id ")
prod_id = input()
if not prod_id.isnumeric() or int(prod_id) < 1:
print("Incorrect prod_id value")
continue
prod_id = int(prod_id)
print("Enter first date")
date1 = self.create_date()
print("Enter second date")
date2 = self.create_date()
res = list(self.db.get_sold_volume_between_dates(prod_id, date1, date2))
view.print_action("get", f"sold volume of product with id {prod_id} ", res[0][0])
break
def get_sold_volume_between_dates_warehouse(self):
while True:
print("Enter warehouse id ")
war_id = input()
if not war_id.isnumeric() or int(war_id) < 1:
print("Incorrect war_id value")
continue
war_id = int(war_id)
print("Enter first date")
date1 = self.create_date()
print("Enter second date")
date2 = self.create_date()
res = tuple(self.db.get_sold_volume_between_dates_warehouse(war_id, date1, date2))
view.print_action("get", f"sold product volume from warhouse with id {war_id}", res[0][0])
break