reports.py

from storage import load_sales, load_products
from utils import pause

def reports_menu():
    while True:
        print("\nReports")
        print("-" * 10)
        print("1. Total Revenue")
        print("2. Low Stock Alert")
        print("3. Back")

        choice = input("Enter choice (1-3): ")
        if choice == "1":
            total_revenue()
        elif choice == "2":
            low_stock()
        elif choice == "3":
            break
        else:
            print(" Invalid choice")

def total_revenue():
    sales = load_sales()
    total = sales["TotalPrice"].sum()
    print(f"\n Total Revenue: {total}")
    pause()

def low_stock():
    products = load_products()
    low = products[products["Quantity"] < 5]
    if low.empty:
        print("All products sufficiently stocked.")
    else:
        print("\n Low Stock Products:")
        print(low[["ID", "Name", "Quantity"]])
    pause()