import mysql.connector
 
# Function to connect to the database
def connect_db():
    return mysql.connector.connect(
        host="localhost",
        user="root",
        password="",
        database="food"
    )
 
# Function to add a menu item
def add_item(cursor, item_name, item_price):
    try:
        cursor.execute("INSERT INTO item (Food_Item, Food_Price) VALUES (%s, %s)", (item_name, item_price))
        print(f"{item_name} has been added to the menu with a price of {item_price}.")
    except mysql.connector.Error as err:
        print(f"Error: {err}")
 
# Function to display the menu
def display_menu(cursor):
    cursor.execute("SELECT * FROM item")
    items = cursor.fetchall()
    print("********** Cafe Menu **********")
    for item in items:
        print(f"ID: {item[0]}, Food Item: {item[1]}, Price: {item[2]}")
    print("*******************************")
 
# Function to place an order
def place_order(cursor, customer_name, item_id, quantity):
    cursor.execute("SELECT * FROM item WHERE S_no = %s", (item_id,))
    item = cursor.fetchone()
 
    if item:
        item_name = item[1]
        item_price = item[2]
        total_price = item_price * quantity
 
        # Insert order into the orders table
        cursor.execute("INSERT INTO orders (O_name, O_price, Quantity, Total_Price) VALUES (%s, %s, %s, %s)",
                       (item_name, item_price, quantity, total_price))
        print("\nYour order has been placed successfully.")
        print(f"Food: {item_name}, Quantity: {quantity}, Total Price: {total_price}")
    else:
        print("Item not found in the menu.")
 
# Function to view all orders
def view_orders(cursor):
    cursor.execute("SELECT * FROM orders")
    orders = cursor.fetchall()
    print("\n********** Order History **********")
    for order in orders:
        print(f"Order ID: {order[0]}, Food Name: {order[1]}, Price: {order[2]}, Quantity: {order[3]}, Total Price: {order[4]}")
    print("***********************************")
 
# Main function to control the flow of the Cafe Bill Management System
def main():
    conn = connect_db()
    cursor = conn.cursor()
 
    while True:
        print("\n********** WELCOME TO OPAL CAFE **********")
        print("1. Add Menu Item")
        print("2. View Menu")
        print("3. Place an Order")
        print("4. View Orders")
        print("5. Exit")
        choice = input("Please select an option (1-5): ")
 
        if choice == "1":
            item_name = input("Enter food item name: ")
            item_price = float(input("Enter food price: "))
            add_item(cursor, item_name, item_price)
            conn.commit()
 
        elif choice == "2":
            display_menu(cursor)
 
        elif choice == "3":
            customer_name = input("Enter your name: ")
            item_id = int(input("Enter the item ID you want to order: "))
            quantity = int(input("Enter the quantity: "))
            place_order(cursor, customer_name, item_id, quantity)
            conn.commit()
 
        elif choice == "4":
            view_orders(cursor)
 
        elif choice == "5":
            print("Thank you for visiting our cafe!")
            break
 
        else:
            print("Invalid option, please try again.")
 
    cursor.close()
    conn.close()
 
# Run the program
if __name__ == "__main__":
    main()
 

aW1wb3J0IG15c3FsLmNvbm5lY3RvcgoKIyBGdW5jdGlvbiB0byBjb25uZWN0IHRvIHRoZSBkYXRhYmFzZQpkZWYgY29ubmVjdF9kYigpOgogICAgcmV0dXJuIG15c3FsLmNvbm5lY3Rvci5jb25uZWN0KAogICAgICAgIGhvc3Q9ImxvY2FsaG9zdCIsCiAgICAgICAgdXNlcj0icm9vdCIsCiAgICAgICAgcGFzc3dvcmQ9IiIsCiAgICAgICAgZGF0YWJhc2U9ImZvb2QiCiAgICApCgojIEZ1bmN0aW9uIHRvIGFkZCBhIG1lbnUgaXRlbQpkZWYgYWRkX2l0ZW0oY3Vyc29yLCBpdGVtX25hbWUsIGl0ZW1fcHJpY2UpOgogICAgdHJ5OgogICAgICAgIGN1cnNvci5leGVjdXRlKCJJTlNFUlQgSU5UTyBpdGVtIChGb29kX0l0ZW0sIEZvb2RfUHJpY2UpIFZBTFVFUyAoJXMsICVzKSIsIChpdGVtX25hbWUsIGl0ZW1fcHJpY2UpKQogICAgICAgIHByaW50KGYie2l0ZW1fbmFtZX0gaGFzIGJlZW4gYWRkZWQgdG8gdGhlIG1lbnUgd2l0aCBhIHByaWNlIG9mIHtpdGVtX3ByaWNlfS4iKQogICAgZXhjZXB0IG15c3FsLmNvbm5lY3Rvci5FcnJvciBhcyBlcnI6CiAgICAgICAgcHJpbnQoZiJFcnJvcjoge2Vycn0iKQoKIyBGdW5jdGlvbiB0byBkaXNwbGF5IHRoZSBtZW51CmRlZiBkaXNwbGF5X21lbnUoY3Vyc29yKToKICAgIGN1cnNvci5leGVjdXRlKCJTRUxFQ1QgKiBGUk9NIGl0ZW0iKQogICAgaXRlbXMgPSBjdXJzb3IuZmV0Y2hhbGwoKQogICAgcHJpbnQoIioqKioqKioqKiogQ2FmZSBNZW51ICoqKioqKioqKioiKQogICAgZm9yIGl0ZW0gaW4gaXRlbXM6CiAgICAgICAgcHJpbnQoZiJJRDoge2l0ZW1bMF19LCBGb29kIEl0ZW06IHtpdGVtWzFdfSwgUHJpY2U6IHtpdGVtWzJdfSIpCiAgICBwcmludCgiKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKiIpCgojIEZ1bmN0aW9uIHRvIHBsYWNlIGFuIG9yZGVyCmRlZiBwbGFjZV9vcmRlcihjdXJzb3IsIGN1c3RvbWVyX25hbWUsIGl0ZW1faWQsIHF1YW50aXR5KToKICAgIGN1cnNvci5leGVjdXRlKCJTRUxFQ1QgKiBGUk9NIGl0ZW0gV0hFUkUgU19ubyA9ICVzIiwgKGl0ZW1faWQsKSkKICAgIGl0ZW0gPSBjdXJzb3IuZmV0Y2hvbmUoKQoKICAgIGlmIGl0ZW06CiAgICAgICAgaXRlbV9uYW1lID0gaXRlbVsxXQogICAgICAgIGl0ZW1fcHJpY2UgPSBpdGVtWzJdCiAgICAgICAgdG90YWxfcHJpY2UgPSBpdGVtX3ByaWNlICogcXVhbnRpdHkKCiAgICAgICAgIyBJbnNlcnQgb3JkZXIgaW50byB0aGUgb3JkZXJzIHRhYmxlCiAgICAgICAgY3Vyc29yLmV4ZWN1dGUoIklOU0VSVCBJTlRPIG9yZGVycyAoT19uYW1lLCBPX3ByaWNlLCBRdWFudGl0eSwgVG90YWxfUHJpY2UpIFZBTFVFUyAoJXMsICVzLCAlcywgJXMpIiwKICAgICAgICAgICAgICAgICAgICAgICAoaXRlbV9uYW1lLCBpdGVtX3ByaWNlLCBxdWFudGl0eSwgdG90YWxfcHJpY2UpKQogICAgICAgIHByaW50KCJcbllvdXIgb3JkZXIgaGFzIGJlZW4gcGxhY2VkIHN1Y2Nlc3NmdWxseS4iKQogICAgICAgIHByaW50KGYiRm9vZDoge2l0ZW1fbmFtZX0sIFF1YW50aXR5OiB7cXVhbnRpdHl9LCBUb3RhbCBQcmljZToge3RvdGFsX3ByaWNlfSIpCiAgICBlbHNlOgogICAgICAgIHByaW50KCJJdGVtIG5vdCBmb3VuZCBpbiB0aGUgbWVudS4iKQoKIyBGdW5jdGlvbiB0byB2aWV3IGFsbCBvcmRlcnMKZGVmIHZpZXdfb3JkZXJzKGN1cnNvcik6CiAgICBjdXJzb3IuZXhlY3V0ZSgiU0VMRUNUICogRlJPTSBvcmRlcnMiKQogICAgb3JkZXJzID0gY3Vyc29yLmZldGNoYWxsKCkKICAgIHByaW50KCJcbioqKioqKioqKiogT3JkZXIgSGlzdG9yeSAqKioqKioqKioqIikKICAgIGZvciBvcmRlciBpbiBvcmRlcnM6CiAgICAgICAgcHJpbnQoZiJPcmRlciBJRDoge29yZGVyWzBdfSwgRm9vZCBOYW1lOiB7b3JkZXJbMV19LCBQcmljZToge29yZGVyWzJdfSwgUXVhbnRpdHk6IHtvcmRlclszXX0sIFRvdGFsIFByaWNlOiB7b3JkZXJbNF19IikKICAgIHByaW50KCIqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKiIpCgojIE1haW4gZnVuY3Rpb24gdG8gY29udHJvbCB0aGUgZmxvdyBvZiB0aGUgQ2FmZSBCaWxsIE1hbmFnZW1lbnQgU3lzdGVtCmRlZiBtYWluKCk6CiAgICBjb25uID0gY29ubmVjdF9kYigpCiAgICBjdXJzb3IgPSBjb25uLmN1cnNvcigpCgogICAgd2hpbGUgVHJ1ZToKICAgICAgICBwcmludCgiXG4qKioqKioqKioqIFdFTENPTUUgVE8gT1BBTCBDQUZFICoqKioqKioqKioiKQogICAgICAgIHByaW50KCIxLiBBZGQgTWVudSBJdGVtIikKICAgICAgICBwcmludCgiMi4gVmlldyBNZW51IikKICAgICAgICBwcmludCgiMy4gUGxhY2UgYW4gT3JkZXIiKQogICAgICAgIHByaW50KCI0LiBWaWV3IE9yZGVycyIpCiAgICAgICAgcHJpbnQoIjUuIEV4aXQiKQogICAgICAgIGNob2ljZSA9IGlucHV0KCJQbGVhc2Ugc2VsZWN0IGFuIG9wdGlvbiAoMS01KTogIikKCiAgICAgICAgaWYgY2hvaWNlID09ICIxIjoKICAgICAgICAgICAgaXRlbV9uYW1lID0gaW5wdXQoIkVudGVyIGZvb2QgaXRlbSBuYW1lOiAiKQogICAgICAgICAgICBpdGVtX3ByaWNlID0gZmxvYXQoaW5wdXQoIkVudGVyIGZvb2QgcHJpY2U6ICIpKQogICAgICAgICAgICBhZGRfaXRlbShjdXJzb3IsIGl0ZW1fbmFtZSwgaXRlbV9wcmljZSkKICAgICAgICAgICAgY29ubi5jb21taXQoKQoKICAgICAgICBlbGlmIGNob2ljZSA9PSAiMiI6CiAgICAgICAgICAgIGRpc3BsYXlfbWVudShjdXJzb3IpCgogICAgICAgIGVsaWYgY2hvaWNlID09ICIzIjoKICAgICAgICAgICAgY3VzdG9tZXJfbmFtZSA9IGlucHV0KCJFbnRlciB5b3VyIG5hbWU6ICIpCiAgICAgICAgICAgIGl0ZW1faWQgPSBpbnQoaW5wdXQoIkVudGVyIHRoZSBpdGVtIElEIHlvdSB3YW50IHRvIG9yZGVyOiAiKSkKICAgICAgICAgICAgcXVhbnRpdHkgPSBpbnQoaW5wdXQoIkVudGVyIHRoZSBxdWFudGl0eTogIikpCiAgICAgICAgICAgIHBsYWNlX29yZGVyKGN1cnNvciwgY3VzdG9tZXJfbmFtZSwgaXRlbV9pZCwgcXVhbnRpdHkpCiAgICAgICAgICAgIGNvbm4uY29tbWl0KCkKCiAgICAgICAgZWxpZiBjaG9pY2UgPT0gIjQiOgogICAgICAgICAgICB2aWV3X29yZGVycyhjdXJzb3IpCgogICAgICAgIGVsaWYgY2hvaWNlID09ICI1IjoKICAgICAgICAgICAgcHJpbnQoIlRoYW5rIHlvdSBmb3IgdmlzaXRpbmcgb3VyIGNhZmUhIikKICAgICAgICAgICAgYnJlYWsKCiAgICAgICAgZWxzZToKICAgICAgICAgICAgcHJpbnQoIkludmFsaWQgb3B0aW9uLCBwbGVhc2UgdHJ5IGFnYWluLiIpCgogICAgY3Vyc29yLmNsb3NlKCkKICAgIGNvbm4uY2xvc2UoKQoKIyBSdW4gdGhlIHByb2dyYW0KaWYgX19uYW1lX18gPT0gIl9fbWFpbl9fIjoKICAgIG1haW4oKQo=