Restaurant Project UI.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "1e70c7d6",
   "metadata": {},
   "source": [
    "## Project -- Restaurant Management System Application"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "a151e3bc",
   "metadata": {},
   "outputs": [],
   "source": [
    "import tkinter as tk\n",
    "import customtkinter as customTk\n",
    "from customtkinter.windows.ctk_tk import CTk\n",
    "from decimal import Decimal\n",
    "import os\n",
    "from PIL import Image\n",
    "from PIL import ImageTk, Image\n",
    "import mysql.connector\n",
    "\n",
    "\n",
    "# Connect to the database\n",
    "db = mysql.connector.connect(\n",
    "    host=\"127.0.0.1\",\n",
    "    user=\"root\",\n",
    "    password=\"Harini@1994\",\n",
    "    database=\"restaurant_project\"\n",
    ")\n",
    "\n",
    "# Create a cursor object to interact with the database\n",
    "cursor = db.cursor()\n",
    "\n",
    "# Define frame stack\n",
    "frame_stack = []\n",
    "\n",
    "\n",
    "# function to navigate back to previous screen\n",
    "def back_button():\n",
    "    # Remove the current frame from the stack\n",
    "    frame_stack.pop()\n",
    "    # Get the previous frame from the stack\n",
    "    previous_frame = frame_stack[-1]\n",
    "    # Forget the current frame and pack the previous frame\n",
    "    current_frame = master.pack_slaves()[0]\n",
    "    current_frame.pack_forget()\n",
    "    previous_frame.pack(fill=\"both\", expand=True)\n",
    "            \n",
    "\n",
    "'''Customer flow'''\n",
    "\n",
    "def customer_Info():\n",
    "    # Clear the current frame\n",
    "    current_frame = master.pack_slaves()[0]\n",
    "    current_frame.pack_forget()\n",
    "    \n",
    "    # create frames\n",
    "    cframe_1 = customTk.CTkFrame(master)\n",
    "    cframe_1.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "    \n",
    "    # Add the current frame to the stack\n",
    "    frame_stack.append(cframe_1)\n",
    "    \n",
    "    # create back button widget\n",
    "    cback_button = customTk.CTkButton(cframe_1, text=\"Back\", command=back_button)\n",
    "    cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "\n",
    "    \n",
    "    customTk.CTkLabel(cframe_1, text=\"Customer_ID\").pack(side=\"top\")\n",
    "    cid_entry = customTk.CTkEntry(cframe_1)\n",
    "    cid_entry.pack(side=\"top\", padx=10)\n",
    "\n",
    "    def validate_cid(cid_entry):\n",
    "        cursor.execute(f\"SELECT * FROM Customer WHERE Customer_id='{cid_entry}'\")\n",
    "        result = cursor.fetchone()\n",
    "        return result\n",
    "    \n",
    "    csubmit_button = customTk.CTkButton(cframe_1, text=\"Submit\", command=lambda: customer_validation())\n",
    "    csubmit_button.pack(side=\"bottom\", pady=20, padx=200)\n",
    "    \n",
    "    def customer_validation():\n",
    "        cid = cid_entry.get()\n",
    "        result = validate_cid(cid)\n",
    "            \n",
    "        if result:\n",
    "            # if customer ID exists, switch to the customer frame\n",
    "            switch_to_Restaurant_options_frame(cid)\n",
    "        else:\n",
    "            switch_to_add_customer_frame(cid)\n",
    "            \n",
    "\n",
    "    def switch_to_add_customer_frame(cid_entry):\n",
    "        # Clear the current frame\n",
    "        current_frame = master.pack_slaves()[0]\n",
    "        current_frame.pack_forget()\n",
    "        \n",
    "        add_customer_frame = customTk.CTkFrame(master)\n",
    "        add_customer_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "        \n",
    "        # Add the current frame to the stack\n",
    "        frame_stack.append(add_customer_frame)\n",
    "        \n",
    "        # create back button widget\n",
    "        cback_button = customTk.CTkButton(add_customer_frame, text=\"Back\", command=back_button)\n",
    "        cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "\n",
    "            \n",
    "        name_label = customTk.CTkLabel(add_customer_frame, text=\"Customer Name:\")\n",
    "        name_label.pack(pady=10, padx=10)\n",
    "        name_entry = customTk.CTkEntry(add_customer_frame)\n",
    "        name_entry.pack(pady=10, padx=10)\n",
    "        \n",
    "        # create label and entry field for customer phone number\n",
    "        phone_label = customTk.CTkLabel(add_customer_frame, text=\"Phone Number:\")\n",
    "        phone_label.pack(pady=10, padx=10)\n",
    "        phone_entry = customTk.CTkEntry(add_customer_frame)\n",
    "        phone_entry.pack(pady=10, padx=10)\n",
    "        \n",
    "        # create label and entry field for customer email\n",
    "        email_label = customTk.CTkLabel(add_customer_frame, text=\"Email:\")\n",
    "        email_label.pack(pady=10, padx=10)\n",
    "        email_entry = customTk.CTkEntry(add_customer_frame)\n",
    "        email_entry.pack(pady=10, padx=10)\n",
    "        \n",
    "        # create label and entry field for customer address\n",
    "        address_label = customTk.CTkLabel(add_customer_frame, text=\"Address:\")\n",
    "        address_label.pack(pady=10, padx=10)\n",
    "        address_entry = customTk.CTkEntry(add_customer_frame)\n",
    "        address_entry.pack(pady=10, padx=10)\n",
    "        \n",
    "        # create button to submit customer details\n",
    "        submit_button = customTk.CTkButton(add_customer_frame, text=\"Submit\", command=lambda: add_customer(cid_entry))\n",
    "        submit_button.pack(pady=10, padx=10)\n",
    "        \n",
    "        def add_customer(cid_entry):\n",
    "            cursor.execute(f\"INSERT INTO Customer (Customer_id, Customer_Name, CPhone_Number, CEmail, CAddress) VALUES ('{cid_entry}', '{name_entry.get()}', '{phone_entry.get()}', '{email_entry.get()}', '{address_entry.get()}')\")\n",
    "            db.commit()\n",
    "            conf_add_cust = customTk.CTkLabel(add_customer_frame, text=f\"Customer {cid_entry} is added successfully, click on Restaurant Options button to continue\", font=(\"Helvetica\", 14))\n",
    "            conf_add_cust.pack(pady=10, padx=10)\n",
    "            \n",
    "        rest_op_button = customTk.CTkButton(add_customer_frame, text=\"Restaurant Options\", \n",
    "                                            command=lambda: switch_to_Restaurant_options_frame(cid_entry))\n",
    "        rest_op_button.pack(pady=10, padx=10)\n",
    "            \n",
    "    def switch_to_Restaurant_options_frame(cid_entry):\n",
    "        # clear the current frame and pack the options frame\n",
    "        current_frame = master.pack_slaves()[0]\n",
    "        current_frame.pack_forget()\n",
    "        \n",
    "        restaurant_options_frame = customTk.CTkFrame(master)\n",
    "        restaurant_options_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "        \n",
    "        # Add the current frame to the stack\n",
    "        frame_stack.append(restaurant_options_frame)\n",
    "        \n",
    "        # create back button widget\n",
    "        cback_button = customTk.CTkButton(restaurant_options_frame, text=\"Back\", command=back_button)\n",
    "        cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "        \n",
    "        # create a label with customer name\n",
    "        customer_name_label = customTk.CTkLabel(restaurant_options_frame, text=f\"Welcome to our UNT Restaurant\", font=(\"Helvetica\", 16))\n",
    "        customer_name_label.pack(pady=20, padx=60)\n",
    "        \n",
    "        # create buttons for Reservation, Order, Feedback\n",
    "        reservation_button = customTk.CTkButton(restaurant_options_frame, text=\"Reservation\", \n",
    "                                                command=switch_to_reservation_frame)\n",
    "        reservation_button.pack(pady=10, padx=200)\n",
    "        \n",
    "        order_button = customTk.CTkButton(restaurant_options_frame, text=\"Order\", command=switch_to_order_frame)\n",
    "        order_button.pack(pady=10, padx=200)\n",
    "        \n",
    "        feedback_button = customTk.CTkButton(restaurant_options_frame, text=\"Feedback\", command=switch_to_feedback_frame)\n",
    "        feedback_button.pack(pady=10, padx=200)\n",
    "        \n",
    "    '''Reservation Flow'''\n",
    "    \n",
    "    def switch_to_reservation_frame():\n",
    "        # Clear the current frame\n",
    "        current_frame = master.pack_slaves()[0]\n",
    "        current_frame.pack_forget()\n",
    "    \n",
    "        # Create new frame\n",
    "        reservation_frame = customTk.CTkFrame(master)\n",
    "        reservation_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "        \n",
    "        # Add the current frame to the stack\n",
    "        frame_stack.append(reservation_frame)\n",
    "        \n",
    "        # create back button widget\n",
    "        cback_button = customTk.CTkButton(reservation_frame, text=\"Back\", command=back_button)\n",
    "        cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "    \n",
    "        # Add title label\n",
    "        customTk.CTkLabel(reservation_frame, text=\"Select Zone for Reserving Table\", font=(\"Helvetica\", 16)).pack(pady=20)\n",
    "        \n",
    "        Zone_1_btn = customTk.CTkButton(reservation_frame, text=\"Zone 1\", command=lambda: select_table(1)).pack(pady=10)\n",
    "        Zone_2_btn = customTk.CTkButton(reservation_frame, text=\"Zone 2\", command=lambda: select_table(2)).pack(pady=10)\n",
    "        Zone_3_btn = customTk.CTkButton(reservation_frame, text=\"Zone 3\", command=lambda: select_table(3)).pack(pady=10)\n",
    "    \n",
    "        # Add buttons for zones\n",
    "        def select_table(zone):\n",
    "            \n",
    "            # Clear the current frame\n",
    "            #reservation_frame.destroy()\n",
    "            current_frame = master.pack_slaves()[0]\n",
    "            current_frame.pack_forget()\n",
    "        \n",
    "            # Create new frame\n",
    "            table_frame = customTk.CTkFrame(master)\n",
    "            table_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "            \n",
    "            # Add the current frame to the stack\n",
    "            frame_stack.append(table_frame)\n",
    "            \n",
    "            # create back button widget\n",
    "            cback_button = customTk.CTkButton(table_frame, text=\"Back\", command=back_button)\n",
    "            cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "            \n",
    "            # Add title label\n",
    "            customTk.CTkLabel(table_frame, text=f\"Choose Table in Zone {zone}\", font=(\"Helvetica\", 16)).pack(pady=20)\n",
    "                \n",
    "            # Get available tables in the selected zone\n",
    "            cursor.execute(f\"SELECT Table_id FROM `Table` WHERE TStatus='Available' AND Zone_id={zone}\")\n",
    "            available_table_ids = [str(row[0]) for row in cursor.fetchall()]\n",
    "            \n",
    "            if available_table_ids:\n",
    "                # Add a combobox to display the available table IDs\n",
    "                table_id_combo_box = customTk.CTkComboBox(table_frame, values=available_table_ids)\n",
    "                table_id_combo_box.pack(pady=20)\n",
    "            else:\n",
    "                no_tables_label = customTk.CTkLabel(table_frame, text=\"No tables available in this zone for Reservation! Click on Okay button to move back to Restaurant Options!\", font=(\"Helvetica\", 16))\n",
    "                no_tables_label.pack(pady=20)\n",
    "    \n",
    "            def reserve_table():                             \n",
    "                table_no = table_id_combo_box.get()\n",
    "                \n",
    "                # Get the next consecutive Reservation id from the Reservation table\n",
    "                cursor.execute(\"SELECT MAX(Reservation_id) FROM Reservation\")\n",
    "                result = cursor.fetchone()\n",
    "                reservation_id = int(result[0]) + 1 if result[0] else 1\n",
    "    \n",
    "                # Insert reservation into Reservation table\n",
    "                cid_int = int(cid_entry.get())\n",
    "                cursor.execute(f\"INSERT INTO Reservation (Reservation_id, Customer_id, Restaurant_id, Table_id, R_Date, Time, Status) VALUES ('{reservation_id}', '{cid_int}', '1', '{table_no}', NOW(), NOW(), 'confirmed')\")\n",
    "                db.commit()\n",
    "            \n",
    "                # Update table status to 'occupied'\n",
    "                cursor.execute(f\"UPDATE `Table` SET TStatus='occupied' WHERE Table_id='{table_no}'\")\n",
    "                db.commit()\n",
    "                \n",
    "            \n",
    "            # Add submit button\n",
    "            submit_btn = customTk.CTkButton(table_frame, text=\"Submit\", command=lambda: \n",
    "                                            ((reserve_table(),switch_to_Restaurant_options_frame(cid_entry)) \n",
    "                                             if available_table_ids else switch_to_Restaurant_options_frame(cid_entry))).pack()\n",
    "\n",
    "\n",
    "\n",
    "    '''Order Flow'''\n",
    "    \n",
    "    def switch_to_order_frame():\n",
    "        # Clear the current frame\n",
    "        current_frame = master.pack_slaves()[0]\n",
    "        current_frame.pack_forget()\n",
    "    \n",
    "        # Create new frame\n",
    "        order_frame = customTk.CTkFrame(master)\n",
    "        # Pack the reservation frame\n",
    "        order_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "        \n",
    "        # Add the current frame to the stack\n",
    "        frame_stack.append(order_frame)\n",
    "        \n",
    "        # create back button widget\n",
    "        cback_button = customTk.CTkButton(order_frame, text=\"Back\", command=back_button)\n",
    "        cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "        \n",
    "        global cart_items\n",
    "        cart_items = []\n",
    "    \n",
    "        # Add title label\n",
    "        customTk.CTkLabel(order_frame, text=\"Enter Order details for a Customer\", font=(\"Helvetica\", 16)).pack(pady=20)\n",
    "        \n",
    "        cursor.execute(\"SELECT MAX(order_id) FROM `Order`\")\n",
    "        result = cursor.fetchone()\n",
    "        order_id = int(result[0]) + 1 if result[0] else 1\n",
    "        order_id_label = customTk.CTkLabel(order_frame, text=f\"Order id : {order_id}\").pack()\n",
    "        \n",
    "        # Get the list of all tables\n",
    "        table_id_label = customTk.CTkLabel(order_frame, text=\"Table id:\")\n",
    "        table_id_label.pack(pady=10, padx=10)\n",
    "        cursor.execute(\"SELECT Table_id FROM `Table`\")\n",
    "        table_ids = [str(row[0]) for row in cursor.fetchall()]\n",
    "        table_id_combo_box = customTk.CTkComboBox(order_frame, values=table_ids)\n",
    "        table_id_combo_box.pack(pady=20)\n",
    "        \n",
    "        # Get the list of all Customers\n",
    "        customer_id_label = customTk.CTkLabel(order_frame, text=\"Customer id:\")\n",
    "        customer_id_label.pack(pady=10, padx=10)\n",
    "        cursor.execute(\"SELECT Customer_id FROM Customer\")\n",
    "        customer_ids = [str(row[0]) for row in cursor.fetchall()]\n",
    "        customer_id_combo_box = customTk.CTkComboBox(order_frame, values=customer_ids)\n",
    "        customer_id_combo_box.pack(pady=20)\n",
    "        \n",
    "        # Get the list of all Discounts\n",
    "        Discount_id_label = customTk.CTkLabel(order_frame, text=\"Discount id:\")\n",
    "        Discount_id_label.pack(pady=10, padx=10)\n",
    "        cursor.execute(\"SELECT * FROM Discount\")\n",
    "        discounts = [str(row[0]) for row in cursor.fetchall()]\n",
    "        discounts_combo_box = customTk.CTkComboBox(order_frame, values=discounts)\n",
    "        discounts_combo_box.pack(pady=20)\n",
    "    \n",
    "        \n",
    "        def switch_to_food_category_frame(): \n",
    "            # Clear the current frame\n",
    "            current_frame = master.pack_slaves()[0]\n",
    "            current_frame.pack_forget()\n",
    "\n",
    "            # Create new frame\n",
    "            food_category_frame = customTk.CTkFrame(master)\n",
    "            food_category_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "            \n",
    "            # Add the current frame to the stack\n",
    "            frame_stack.append(food_category_frame)\n",
    "        \n",
    "            # create back button widget\n",
    "            cback_button = customTk.CTkButton(food_category_frame, text=\"Back\", command=back_button)\n",
    "            cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "\n",
    "            # Add title label\n",
    "            customTk.CTkLabel(food_category_frame, text=\"Choose the food category\", font=(\"Helvetica\", 16)).pack(pady=20)\n",
    "    \n",
    "            # Get the list of all food categories\n",
    "            cursor.execute(\"SELECT FCName FROM food_category\")\n",
    "            food_categories = [row[0] for row in cursor.fetchall()]\n",
    "\n",
    "            # Create dynamic buttons for each food category\n",
    "            for category in food_categories:\n",
    "                food_category_button = customTk.CTkButton(food_category_frame, text=category, width=200, height=60, \n",
    "                                                          command=lambda cat=category: switch_to_menu_item_frame(cat))\n",
    "                food_category_button.pack(pady=10, padx=200)\n",
    "        \n",
    "            \n",
    "        order_details_submit_button = customTk.CTkButton(order_frame, text=\"Submit\", \n",
    "                                                         command=lambda: (switch_to_food_category_frame()))\n",
    "        order_details_submit_button.pack(pady=10, padx=200)\n",
    "                \n",
    "        \n",
    "                \n",
    "        def switch_to_menu_item_frame(food_category_choosen):\n",
    "            # Clear the current frame\n",
    "            current_frame = master.pack_slaves()[0]\n",
    "            current_frame.pack_forget()\n",
    "    \n",
    "            # Create new frame\n",
    "            menu_item_frame = customTk.CTkFrame(master)\n",
    "            menu_item_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "            \n",
    "            # Add the current frame to the stack\n",
    "            frame_stack.append(menu_item_frame)\n",
    "        \n",
    "            # create back button widget\n",
    "            cback_button = customTk.CTkButton(menu_item_frame, text=\"Back\", command=back_button)\n",
    "            cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "    \n",
    "            # Add title label\n",
    "            customTk.CTkLabel(menu_item_frame, text=\"Choose Menu Items\", font=(\"Helvetica\", 16)).pack(pady=20)\n",
    "            \n",
    "            # Fetch menu items from database\n",
    "            cursor.execute(f\"SELECT MName, Price FROM menu_item WHERE MName LIKE '%{food_category_choosen}%'\")\n",
    "            menu_items = [row for row in cursor.fetchall()]\n",
    "            \n",
    "            print(menu_items)\n",
    "            \n",
    "            # Create dynamic buttons for each food category\n",
    "            for mitem in menu_items:\n",
    "                menu_item_button = customTk.CTkButton(menu_item_frame, text=mitem[0], width=200, height=60, font=(\"Helvetica\", 16), \n",
    "                                                      command=lambda mi=mitem: switch_to_ingredients_frame(mi))\n",
    "                menu_item_button.pack(pady=10, padx=200)\n",
    "                price_label = customTk.CTkLabel(menu_item_frame, text=f'{mitem[0]} price : {mitem[1]}', font=(\"Helvetica\", 16))\n",
    "                price_label.pack(pady=10, padx=200)\n",
    "                \n",
    "        \n",
    "        def switch_to_ingredients_frame(menu_item_choosen):\n",
    "            # clear previous frames\n",
    "            current_frame = master.pack_slaves()[0]\n",
    "            current_frame.pack_forget()\n",
    "\n",
    "            # create new frame\n",
    "            ingredients_frame = customTk.CTkFrame(master)\n",
    "            ingredients_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "            \n",
    "            # Add the current frame to the stack\n",
    "            frame_stack.append(ingredients_frame)\n",
    "        \n",
    "            # create back button widget\n",
    "            cback_button = customTk.CTkButton(ingredients_frame, text=\"Back\", command=back_button)\n",
    "            cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "        \n",
    "            ingredient_label = customTk.CTkLabel(ingredients_frame, text=\"Choose an ingredient:\", font=(\"Helvetica\", 16))\n",
    "            ingredient_label.pack(pady=10)\n",
    "\n",
    "            # get ingredients from database\n",
    "            cursor.execute(\"SELECT IName, cost FROM Ingredient\")\n",
    "            ingredients = [row for row in cursor.fetchall()]\n",
    "            \n",
    "            x_pos = 10\n",
    "            y_pos = 10\n",
    "            \n",
    "            none_name = \"None\"\n",
    "            none_button = customTk.CTkButton(ingredients_frame, text=none_name, width=50, height=30, font=(\"Helvetica\", 16), \n",
    "                                             command=lambda ing=none_name: switch_to_quantity_frame(menu_item_choosen, ing))\n",
    "            none_button.place(x=x_pos, y=y_pos)\n",
    "            y_pos += 35\n",
    "            \n",
    "            # Create dynamic buttons for each ingredient \n",
    "            for ing_item in ingredients:\n",
    "                ing_item_button = customTk.CTkButton(ingredients_frame, text=ing_item[0], width=50, height=30, font=(\"Helvetica\", 16), \n",
    "                                                     command=lambda ing=ing_item: switch_to_quantity_frame(menu_item_choosen, ing))\n",
    "                ing_item_button.place(x=x_pos, y=y_pos)\n",
    "                ing_price_label = customTk.CTkLabel(ingredients_frame, text=f'price : {ing_item[1]}', font=(\"Helvetica\", 16))\n",
    "                ing_price_label.place(x=x_pos+150, y=y_pos)\n",
    "                y_pos += 35\n",
    "                \n",
    "            \n",
    "        def switch_to_quantity_frame(menu_item_choosen, ingredient_choosen):\n",
    "            # clear previous frames\n",
    "            current_frame = master.pack_slaves()[0]\n",
    "            current_frame.pack_forget()\n",
    "\n",
    "            # create new frame\n",
    "            quantity_frame = customTk.CTkFrame(master)\n",
    "            quantity_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "            \n",
    "            # Add the current frame to the stack\n",
    "            frame_stack.append(quantity_frame)\n",
    "\n",
    "            # create back button widget\n",
    "            cback_button = customTk.CTkButton(quantity_frame, text=\"Back\", command=back_button)\n",
    "            cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "        \n",
    "            menu_item_quantity_label = customTk.CTkLabel(quantity_frame, text=f\"Choose Quantity of {menu_item_choosen} you want to add to cart :\", font=(\"Helvetica\", 16))\n",
    "            menu_item_quantity_label.pack(pady=10)\n",
    "        \n",
    "            quantity_numbers = [str(i) for i in range(1, 11)]\n",
    "\n",
    "            # create dropdown list for quantity\n",
    "            menu_item_quantity_combo_box = customTk.CTkComboBox(quantity_frame, values=quantity_numbers)\n",
    "            menu_item_quantity_combo_box.pack(pady=20)\n",
    "\n",
    "            # function to add item to cart\n",
    "            def add_to_cart(menu_item, ingredient, menu_item_quantity):\n",
    "                # Convert menu_item_quantity to integer\n",
    "                menu_item_quantity = int(menu_item_quantity)\n",
    "                \n",
    "                \n",
    "                print(ingredient)\n",
    "                print(type(ingredient))\n",
    "            \n",
    "                # Get price of Menu Item from database\n",
    "                menu_item_price_query = f\"SELECT Price FROM menu_item WHERE MName = '{menu_item[0]}'\"\n",
    "                cursor.execute(menu_item_price_query)\n",
    "                m_price = cursor.fetchone()[0]\n",
    "                \n",
    "                if ingredient==\"None\":\n",
    "                    i_price = 0\n",
    "                else:\n",
    "                    # Get cost of ingredient from database\n",
    "                    ingredient_cost_query = f\"SELECT Cost FROM Ingredient WHERE IName = '{ingredient[0]}'\"\n",
    "                    cursor.execute(ingredient_cost_query)\n",
    "                    i_price = cursor.fetchone()[0]\n",
    "\n",
    "                # calculate item cost\n",
    "                item_cost = (m_price + i_price)*menu_item_quantity\n",
    "\n",
    "                # add item to cart\n",
    "                cart_items.append((menu_item[0], ingredient[0], menu_item_quantity, item_cost))\n",
    "                \n",
    "                items_added_cart_label = customTk.CTkLabel(quantity_frame, text=\"Items added to the cart successfully!\", font=(\"Helvetica\", 16))\n",
    "                items_added_cart_label.pack(pady=10)\n",
    "\n",
    "            # function to switch to cart frame\n",
    "            def switch_to_cart_frame():\n",
    "                # clear previous frames\n",
    "                current_frame = master.pack_slaves()[0]\n",
    "                current_frame.pack_forget()\n",
    "\n",
    "                # create new frame\n",
    "                cart_frame = customTk.CTkFrame(master)\n",
    "                cart_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "                \n",
    "                # Add the current frame to the stack\n",
    "                frame_stack.append(cart_frame)\n",
    "\n",
    "                # create back button widget\n",
    "                cback_button = customTk.CTkButton(cart_frame, text=\"Back\", command=back_button)\n",
    "                cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "\n",
    "                # display cart items\n",
    "                total_cost = 0\n",
    "                for item in cart_items:\n",
    "                    item_label = customTk.CTkLabel(cart_frame, text=f\"{item[0]} - {item[1]} x {item[2]}\", font=(\"Helvetica\", 16))\n",
    "                    item_label.pack(pady=10)\n",
    "                    price_label = customTk.CTkLabel(cart_frame, text=f\"${item[3]:.2f}\", font=(\"Helvetica\", 16))\n",
    "                    price_label.pack(pady=10)\n",
    "                    total_cost += item[3]\n",
    "\n",
    "                # display total cost\n",
    "                total_cost_label = customTk.CTkLabel(cart_frame, text=f\"Total Cost: ${total_cost:.2f}\", font=(\"Helvetica\", 16))\n",
    "                total_cost_label.pack(pady=10)\n",
    "\n",
    "                # create add more items button\n",
    "                add_more_items_button = customTk.CTkButton(cart_frame, text=\"Add More Items\", \n",
    "                                                           command=lambda: switch_to_food_category_frame())\n",
    "                add_more_items_button.pack(pady=10)\n",
    "\n",
    "                # create payment button\n",
    "                payment_button = customTk.CTkButton(cart_frame, text=\"Payment\", \n",
    "                                                    command=lambda: switch_to_payment_frame(total_cost))\n",
    "                payment_button.pack(pady=10)\n",
    "            \n",
    "            # function to make payment\n",
    "            def switch_to_payment_frame(total_amount):\n",
    "                # clear previous frames\n",
    "                current_frame = master.pack_slaves()[0]\n",
    "                current_frame.pack_forget()\n",
    "\n",
    "                # create new frame\n",
    "                payment_frame = customTk.CTkFrame(master)\n",
    "                payment_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "                \n",
    "                # Add the current frame to the stack\n",
    "                frame_stack.append(payment_frame)\n",
    "\n",
    "                # create back button widget\n",
    "                cback_button = customTk.CTkButton(payment_frame, text=\"Back\", command=back_button)\n",
    "                cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "                \n",
    "                discount = discounts_combo_box.get()\n",
    "                discount = int(discount)\n",
    "                \n",
    "                amount_label = customTk.CTkLabel(payment_frame, text=f\"Total Amount: ${total_amount:.2f}\", font=(\"Helvetica\", 16))\n",
    "                amount_label.pack(pady=10)\n",
    "                \n",
    "                discount_label = customTk.CTkLabel(payment_frame, text=f\"Discount : ${discount}\", font=(\"Helvetica\", 16))\n",
    "                discount_label.pack(pady=10)\n",
    "                \n",
    "                final_amount = total_amount - discount\n",
    "                \n",
    "                # Create a label to display the total amount\n",
    "                final_amount_label = customTk.CTkLabel(payment_frame, text=f\"Total Amount to be paid : {final_amount}\", font=(\"Helvetica\", 16))\n",
    "                final_amount_label.pack(pady=10)\n",
    "                \n",
    "                # Create radio buttons for different payment modes\n",
    "                payment_modes = [\"Cash\", \"Credit Card\", \"Debit Card\", \"Others\"]\n",
    "                payment_mode_combo_box = customTk.CTkComboBox(payment_frame, values=payment_modes)\n",
    "                payment_mode_combo_box.pack(pady=20)\n",
    "                \n",
    "                # Submit button\n",
    "                payment_submit_button = customTk.CTkButton(payment_frame, text=\"Submit\", \n",
    "                                                           command=lambda: (update_database_after_payment()))\n",
    "                payment_submit_button.pack(pady=10, padx=200)\n",
    "                \n",
    "                def update_database_after_payment():\n",
    "                    # Update Order table\n",
    "                    cursor.execute(f\"INSERT INTO `Order` (Order_id, Table_id, Customer_id, Discount_id, Time, Status) VALUES ('{order_id}', '{table_id_combo_box.get()}', '{customer_id_combo_box.get()}', '{discounts_combo_box.get()}', NOW(), 'Close')\")\n",
    "                    db.commit()\n",
    "                    \n",
    "                    # Update Payment table\n",
    "                    cursor.execute(\"SELECT MAX(Payment_id) FROM Payment\")\n",
    "                    result = cursor.fetchone()\n",
    "                    payment_id = int(result[0]) + 1 if result[0] else 1\n",
    "                    cursor.execute(f\"INSERT INTO Payment (Payment_id, Customer_id, Order_id, Order_Amount, Payment_Time, Payment_Method) VALUES ('{payment_id}', '{customer_id_combo_box.get()}', '{order_id}', '{final_amount}', NOW(), '{payment_mode_combo_box.get()}')\")\n",
    "                    db.commit()\n",
    "                    \n",
    "                    # Create a label to display the confirmation of Payment\n",
    "                    payment_confirmation_label = customTk.CTkLabel(payment_frame, text=\"Amount Paid Successfully!\", font=(\"Helvetica\", 16))\n",
    "                    payment_confirmation_label.pack(pady=10)\n",
    "                    \n",
    "                # Navigate back to Main Screen \n",
    "                return_back_button = customTk.CTkButton(payment_frame, text=\"Return Back\", \n",
    "                                                        command=lambda: (switch_to_Restaurant_options_frame(customer_id_combo_box.get())))\n",
    "                return_back_button.pack(pady=10, padx=200)\n",
    "                \n",
    "            \n",
    "             # create add to cart button\n",
    "            add_to_cart_button = customTk.CTkButton(quantity_frame, text=\"Add to Cart\",\n",
    "                                       command=lambda: add_to_cart(menu_item_choosen, ingredient_choosen,  menu_item_quantity_combo_box.get()))\n",
    "            add_to_cart_button.pack(pady=20)\n",
    "\n",
    "            # go to cart frame button\n",
    "            go_to_cart_button = customTk.CTkButton(quantity_frame, text=\"Go to Cart\", command=switch_to_cart_frame)\n",
    "            go_to_cart_button.pack(pady=10)\n",
    "            \n",
    "            \n",
    "\n",
    "    '''FeedBack Flow'''\n",
    "    \n",
    "    def switch_to_feedback_frame():\n",
    "        # Clear previous frames\n",
    "        current_frame = master.pack_slaves()[0]\n",
    "        current_frame.pack_forget()\n",
    "\n",
    "        # Create new frame\n",
    "        feedback_frame = customTk.CTkFrame(master)\n",
    "        feedback_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "        \n",
    "        # Add the current frame to the stack\n",
    "        frame_stack.append(feedback_frame)\n",
    "        \n",
    "        # create back button widget\n",
    "        cback_button = customTk.CTkButton(feedback_frame, text=\"Back\", command=back_button)\n",
    "        cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "\n",
    "        # Get max feedback_id from Feedback Table by query\n",
    "        cursor.execute(\"SELECT MAX(Feedback_id) FROM Feedback\")\n",
    "        max_feedback_id = cursor.fetchone()[0]\n",
    "\n",
    "        # Store +1 id to a feedback_id variable and display it as label\n",
    "        feedback_id = max_feedback_id + 1\n",
    "        feedback_id_label = customTk.CTkLabel(feedback_frame, text=f\"Feedback ID: {feedback_id}\", font=(\"Helvetica\", 16))\n",
    "        feedback_id_label.pack(pady=5)\n",
    "\n",
    "        # Display combobox for Customer_id from Customer table query\n",
    "        cursor.execute(\"SELECT Customer_id FROM Customer\")\n",
    "        customer_ids = [str(row[0]) for row in cursor.fetchall()]\n",
    "        customer_label = customTk.CTkLabel(feedback_frame, text=\"Customer ID: \", font=(\"Helvetica\", 16))\n",
    "        customer_label.pack(pady=5)\n",
    "        customer_combobox = customTk.CTkComboBox(feedback_frame, values=customer_ids)\n",
    "        customer_combobox.pack()\n",
    "\n",
    "        # Display Restaurant id label as 1 and store 1 in a variable\n",
    "        restaurant_id = 1\n",
    "        restaurant_id_label = customTk.CTkLabel(feedback_frame, text=f\"Restaurant ID: {restaurant_id}\", font=(\"Helvetica\", 16))\n",
    "        restaurant_id_label.pack(pady=5)\n",
    "\n",
    "        # Display radio buttons for Ratings (1,2,3,4,5)\n",
    "        rating_label = customTk.CTkLabel(feedback_frame, text=\"Rating: \", font=(\"Helvetica\", 16))\n",
    "        rating_label.pack(pady=5)\n",
    "        rating_var = tk.StringVar()\n",
    "        rating_var.set(\"1\")\n",
    "\n",
    "        for i in range(1, 6):\n",
    "            rating_radio_button = tk.Radiobutton(feedback_frame, text=str(i), width=2, variable=rating_var, value=str(i))\n",
    "            rating_radio_button.pack(pady=5)\n",
    "\n",
    "        # Display Comment Entry field to provide the comments\n",
    "        comment_label = customTk.CTkLabel(feedback_frame, text=\"Comment: \", font=(\"Helvetica\", 16))\n",
    "        comment_label.pack(pady=5)\n",
    "        comment_entry = customTk.CTkEntry(feedback_frame, width=150, height=15)\n",
    "        comment_entry.pack()\n",
    "\n",
    "        # Submit button, which calls a function where it stores these in feedback table\n",
    "        def submit_feedback():\n",
    "            customer_id = customer_combobox.get()\n",
    "            rating = rating_var.get()\n",
    "            comment = comment_entry.get()\n",
    "\n",
    "            # Store data in Feedback table\n",
    "            cursor.execute(f\"INSERT INTO Feedback (Feedback_id, Customer_id, Restaurant_id, Rating, Comment) VALUES ('{feedback_id}', '{customer_id}', '{restaurant_id}', '{rating}','{comment}' )\")\n",
    "            db.commit()\n",
    "\n",
    "            # Display success message\n",
    "            feedback_success_label = customTk.CTkLabel(feedback_frame, text=\"FeedBack stored successfully!\", font=(\"Helvetica\", 16))\n",
    "            feedback_success_label.pack(pady=5)\n",
    "\n",
    "        submit_button = customTk.CTkButton(feedback_frame, text=\"Submit\", font=(\"Helvetica\", 16), command=submit_feedback)\n",
    "        submit_button.pack(pady=5)\n",
    "\n",
    "        # Mainmenu button to return back to main_frame\n",
    "        mainmenu_button = customTk.CTkButton(feedback_frame, text=\"Main Menu\", font=(\"Helvetica\", 16), \n",
    "                                             command=lambda: switch_to_Restaurant_options_frame(customer_combobox.get()))\n",
    "        mainmenu_button.pack(pady=5, padx=10, side=\"bottom\")\n",
    "\n",
    "\n",
    "        \n",
    "'''Employee Flow'''\n",
    "\n",
    "def switch_to_Employee_frame():\n",
    "    # Clear previous frames\n",
    "    current_frame = master.pack_slaves()[0]\n",
    "    current_frame.pack_forget()\n",
    "    \n",
    "    # create Employee side frame\n",
    "    employee_side_frame = customTk.CTkFrame(master)\n",
    "    employee_side_frame.pack(pady=20, padx=60,expand=True, fill=\"both\")\n",
    "    \n",
    "    # Add the current frame to the stack\n",
    "    frame_stack.append(employee_side_frame)\n",
    "\n",
    "    # create back button widget\n",
    "    cback_button = customTk.CTkButton(employee_side_frame, text=\"Back\", command=back_button)\n",
    "    cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "    \n",
    "    def restaurant_back_data():\n",
    "        # Clear previous frames\n",
    "        current_frame = master.pack_slaves()[0]\n",
    "        current_frame.pack_forget()\n",
    "\n",
    "        # create Employee side frame\n",
    "        rest_backdata_frame = customTk.CTkFrame(master)\n",
    "        rest_backdata_frame.pack(pady=20, padx=60,expand=True, fill=\"both\")\n",
    "\n",
    "        # Add the current frame to the stack\n",
    "        frame_stack.append(rest_backdata_frame)\n",
    "\n",
    "        # create back button widget\n",
    "        cback_button = customTk.CTkButton(rest_backdata_frame, text=\"Back\", command=back_button)\n",
    "        cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "        \n",
    "        # create combobox for file selection\n",
    "        rest_backdata_combobox = customTk.CTkComboBox(rest_backdata_frame, \n",
    "                                                      values=[\"Employee\", \"Kitchen_Station\", \"Feedback\", \"Supplier\", \"Purchase_Order\", \"Purchase_Item\"])\n",
    "        rest_backdata_combobox.pack(pady=10)\n",
    "        \n",
    "        def display_rest_data():\n",
    "            rest_backdata_combo_name = rest_backdata_combobox.get()\n",
    "            query = f\"SELECT * FROM {rest_backdata_combo_name}\"\n",
    "            cursor.execute(query)\n",
    "            results = cursor.fetchall()\n",
    "            # clear any existing widgets in the frame\n",
    "            for widget in rest_backdata_frame.winfo_children():\n",
    "                widget.destroy()\n",
    "            # create a label to display the column names\n",
    "            cols = [column[0] for column in cursor.description]\n",
    "            col_names = \" | \".join(cols)\n",
    "            col_label = customTk.CTkLabel(rest_backdata_frame, text=col_names)\n",
    "            col_label.pack(pady=10)\n",
    "            # create a label for each row of data\n",
    "            for row in results:\n",
    "                row_label = customTk.CTkLabel(rest_backdata_frame, text=\" | \".join(str(cell) for cell in row))\n",
    "                row_label.pack()\n",
    "            cback_button = customTk.CTkButton(rest_backdata_frame, text=\"Back\", command=back_button)\n",
    "            cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "            \n",
    "        rest_submit_button = customTk.CTkButton(rest_backdata_frame, text=\"Submit\", command=display_rest_data)\n",
    "        rest_submit_button.pack(pady=10)\n",
    "        \n",
    "    def customers_orders_data():\n",
    "        # Clear previous frames\n",
    "        current_frame = master.pack_slaves()[0]\n",
    "        current_frame.pack_forget()\n",
    "\n",
    "        # create Employee side frame\n",
    "        customers_orders_frame = customTk.CTkFrame(master)\n",
    "        customers_orders_frame.pack(pady=20, padx=60,expand=True, fill=\"both\")\n",
    "\n",
    "        # Add the current frame to the stack\n",
    "        frame_stack.append(customers_orders_frame)\n",
    "\n",
    "        # create back button widget\n",
    "        cback_button = customTk.CTkButton(customers_orders_frame, text=\"Back\", command=back_button)\n",
    "        cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "        \n",
    "        # create combobox for file selection\n",
    "        customers_orders_data_combobox = customTk.CTkComboBox(customers_orders_frame, \n",
    "                                                              values=[\"Customer\", \"Table\", \"Reservation\", \"Discount\", \"Order\", \"Payment\", \"Feedback\"])\n",
    "        customers_orders_data_combobox.pack(pady=10)\n",
    "        \n",
    "        def display_customer_orders_data():\n",
    "            customers_orders_data_combo_name = customers_orders_data_combobox.get()\n",
    "            query = f\"SELECT * FROM {customers_orders_data_combo_name}\"\n",
    "            cursor.execute(query)\n",
    "            results = cursor.fetchall()\n",
    "            # clear any existing widgets in the frame\n",
    "            for widget in customers_orders_frame.winfo_children():\n",
    "                widget.destroy()\n",
    "            # create a label to display the column names\n",
    "            cols = [column[0] for column in cursor.description]\n",
    "            col_names = \" | \".join(cols)\n",
    "            col_label = customTk.CTkLabel(customers_orders_frame, text=col_names)\n",
    "            col_label.pack(pady=10)\n",
    "            # create a label for each row of data\n",
    "            for row in results:\n",
    "                row_label = customTk.CTkLabel(customers_orders_frame, text=\" | \".join(str(cell) for cell in row))\n",
    "                row_label.pack()\n",
    "            cback_button = customTk.CTkButton(customers_orders_frame, text=\"Back\", command=back_button)\n",
    "            cback_button.pack(side=\"bottom\", pady=20, padx=50)\n",
    "            \n",
    "        cust_submit_button = customTk.CTkButton(customers_orders_frame, text=\"Submit\", command=display_customer_orders_data)\n",
    "        cust_submit_button.pack(pady=10)\n",
    "\n",
    "    # Create 2 buttons \n",
    "    restaurant_related_button = customTk.CTkButton(employee_side_frame, text=\"Restaurant Related\", \n",
    "                                                   command=restaurant_back_data)\n",
    "    restaurant_related_button.pack(pady=20)\n",
    "    \n",
    "    customer_orders_button = customTk.CTkButton(employee_side_frame, text=\"Customers Orders Data\", \n",
    "                                                command=customers_orders_data)\n",
    "    customer_orders_button.pack(pady=20)\n",
    "\n",
    "   \n",
    "        \n",
    "                \n",
    "        \n",
    "master = customTk.CTk()\n",
    "master.title(\"Restaurant Management Application\")\n",
    "master.geometry(\"1000x1000\")\n",
    "        \n",
    "        \n",
    "# create frames\n",
    "main_frame = customTk.CTkFrame(master)\n",
    "main_frame.pack(pady=20, padx=60, fill=\"both\", expand=True)\n",
    "\n",
    "# Add the main frame to the frame stack\n",
    "frame_stack.append(main_frame)\n",
    "\n",
    "# create labels and buttons\n",
    "Employee_button = customTk.CTkButton(main_frame, text='Employee', command=switch_to_Employee_frame)\n",
    "Employee_button.pack(pady=10, padx=200)\n",
    "        \n",
    "Customer_button = customTk.CTkButton(main_frame, text='Customer', command=customer_Info)\n",
    "Customer_button.pack(pady=20, padx=200)\n",
    "\n",
    "image_path = os.path.expanduser(\"C:\\\\Users\\\\klnv2\\\\OneDrive\\\\Desktop\\\\FDB\\\\Restaurant Project\\\\UI Code\\\\Test images\")\n",
    "image = customTk.CTkImage(Image.open(os.path.join(image_path, \"Restaurant Image.jpg\")), size=(1000, 1000))\n",
    "label_image = customTk.CTkLabel(main_frame, image=image, text=\"UNT Restaurant\", font=(\"Helvetica\", 60), text_color=\"green\")\n",
    "label_image.pack(pady=5)\n",
    "\n",
    "\n",
    "    \n",
    "master.mainloop()\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "eb2ab7fc",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}