def get_biggest_revenue_product():
temp_list = data_manager.read_table_from_file(sales.DATAFILE)
revenues = []
for item in temp_list:
revenues.append(float(item[3]))
max_revenue_index = revenues.index(max(revenues))
id = 2
id_max_revenue_transaction = temp_list[max_revenue_index][id]
view.print_message(f'\nBiggest revenue product is {id_max_revenue_transaction}')
def menu():
option = None
while option != '0':
display_menu()
try:
option = view.get_input("Select module ")
load_module(int(option))
except KeyError:
view.print_error_message("There is no such option!")
except ValueError:
view.print_error_message("Please enter a number!")
view.print_message("Good-bye!")
def delete(datafile, headers):
temp_list = data_manager.read_table_from_file(datafile)
item_to_delete = view.get_input("Please enter an id to delete ")
marker = 0
for item in temp_list:
if item_to_delete == item[0]:
temp_list.remove(item)
data_manager.write_table_to_file(datafile, temp_list)
view.print_message('Delete successful')
marker += 1
break
if marker == 0:
view.print_error_message('Delete failed')
def update(datafile, headers):
temp_list = data_manager.read_table_from_file(datafile)
row = view.get_inputs(headers)
marker = 0
for i in range(len(temp_list)):
if temp_list[i][0] == row[0]:
marker += 1
temp_list[i] = row
data_manager.write_table_to_file(datafile, temp_list)
view.print_message('Update successful')
break
if marker == 0:
view.print_error_message('Update failed')
def sum_transactions_between():
temp_list = data_manager.read_table_from_file(sales.DATAFILE)
start_date = view.get_input('Enter start date YYYY-MM-DD and press enter ')
while not CRUD.validate(start_date):
start_date = view.get_input('Enter start date YYYY-MM-DD and press enter ')
CRUD.validate(start_date)
end_date = view.get_input('Enter end date YYYY-MM-DD and press enter ')
while not CRUD.validate(end_date):
end_date = view.get_input('Enter end date YYYY-MM-DD and press enter ')
CRUD.validate(end_date)
sum = 0
for item in temp_list:
if start_date <= item[4] <= end_date:
sum += float(item[3])
view.print_message(f'The sum of transactions between {start_date} and {end_date} is {sum}')
def count_transactions_between():
temp_list = data_manager.read_table_from_file(sales.DATAFILE)
start_date = view.get_input('Enter start date YYYY-MM-DD and press enter ')
while not CRUD.validate(start_date):
start_date = view.get_input('Enter start date YYYY-MM-DD and press enter ')
CRUD.validate(start_date)
end_date = view.get_input('Enter end date YYYY-MM-DD and press enter ')
while not CRUD.validate(end_date):
end_date = view.get_input('Enter end date YYYY-MM-DD and press enter ')
CRUD.validate(end_date)
counter = 0
for item in temp_list:
if start_date <= item[4] <= end_date:
counter += 1
view.print_message(f'The number of transactions between {start_date} and {end_date} is {counter}')