import gradio as gr
from utils.database_handler import check_credentials, save_user
import pandas as pd

# Function to load the menu data
def load_menu():
    menu_file = "menu.xlsx"  # Ensure this file exists in the same directory
    try:
        return pd.read_excel(menu_file)
    except Exception as e:
        raise ValueError(f"Error loading menu file: {e}")

# Function to filter menu items based on preference
def filter_menu(preference):
    menu_data = load_menu()
    if preference == "Halal/Non-Veg":
        filtered_data = menu_data[menu_data["Ingredients"].str.contains("Chicken|Mutton|Fish|Prawns|Goat", case=False, na=False)]
    elif preference == "Vegetarian":
        filtered_data = menu_data[~menu_data["Ingredients"].str.contains("Chicken|Mutton|Fish|Prawns|Goat", case=False, na=False)]
    elif preference == "Guilt-Free":
        filtered_data = menu_data[menu_data["Description"].str.contains(r"Fat: ([0-9]|10)g", case=False, na=False)]
    else:
        filtered_data = menu_data

    html_content = ""
    for _, item in filtered_data.iterrows():
        html_content += f"""
        <div style=\"display: flex; align-items: center; border: 1px solid #ddd; border-radius: 8px; padding: 15px; margin-bottom: 10px; box-shadow: 0px 4px 8px rgba(0, 0, 0, 0.1);\">
            <div style=\"flex: 1; margin-right: 15px;\">
                <h3 style=\"margin: 0; font-size: 18px;\">{item['Dish Name']}</h3>
                <p style=\"margin: 5px 0; font-size: 16px; color: #888;\">${item['Price ($)']}</p>
                <p style=\"margin: 5px 0; font-size: 14px; color: #555;\">{item['Description']}</p>
            </div>
            <div style=\"flex-shrink: 0; text-align: center;\">
                <img src=\"{item['Image URL']}\" alt=\"{item['Dish Name']}\" style=\"width: 100px; height: 100px; border-radius: 8px; object-fit: cover; margin-bottom: 10px;\">
                <button style=\"background-color: #28a745; color: white; border: none; padding: 8px 15px; font-size: 14px; border-radius: 5px; cursor: pointer;\" onclick=\"alert('{item['Dish Name']} added!');\">Add</button>
            </div>
        </div>
        """
    return html_content

# JavaScript for modal and cart behavior
modal_and_cart_js = """
<style>
  .cart-container {
    border: 1px solid #ddd;
    border-radius: 8px;
    padding: 15px;
    margin-bottom: 15px;
    background-color: #f9f9f9;
    display: flex;
    flex-direction: column;
    gap: 10px;
  }
  .cart-item {
    display: flex;
    justify-content: space-between;
    align-items: center;
    border-bottom: 1px solid #ddd;
    padding: 10px 0;
  }
  .cart-item:last-child {
    border-bottom: none;
  }
  .cart-item span {
    font-size: 16px;
    margin-right: 10px;
  }
  .cart-item .quantity-container {
    display: flex;
    align-items: center;
    gap: 5px;
  }
  .cart-total {
    font-size: 18px;
    font-weight: bold;
    text-align: right;
    margin-top: 10px;
  }
</style>
<script>
    let cart = [];
    const extrasPrices = {
        "Thums up": 2,
        "Sprite": 2,
        "Extra Raitha": 1,
        "Extra Salan": 2,
        "Extra Onion & Lemon": 2,
        "Chilli Chicken": 14,
        "Veg Manchurian": 12
    };
    let finalized = false;
    function openModal(name, image, description, price) {
        if (finalized) {
            alert("You cannot add more items after finalizing your order.");
            return;
        }
        const modal = document.getElementById('modal');
        modal.style.display = 'block';
        modal.style.position = 'fixed';
        if (window.innerWidth <= 768) {
            modal.style.width = '90%';
        } else {
            modal.style.width = '30%';
        }
        modal.style.top = '15%';
        modal.style.left = '50%';
        modal.style.transform = 'translate(-50%, -50%)';
        document.getElementById('modal-image').src = image;
        document.getElementById('modal-name').innerText = name;
        document.getElementById('modal-description').innerText = description;
        document.getElementById('modal-price').innerText = price;
        const extrasInputs = document.querySelectorAll('input[name="biryani-extra"]');
        extrasInputs.forEach(input => input.checked = false);
        document.getElementById('quantity').value = 1;
        document.getElementById('special-instructions').value = '';
    }
    function closeModal() {
        document.getElementById('modal').style.display = 'none';
    }
    function addToCart() {
        if (finalized) {
            alert("You cannot add more items after finalizing your order.");
            return;
        }
        const name = document.getElementById('modal-name').innerText;
        const price = parseFloat(document.getElementById('modal-price').innerText.replace('$', ''));
        const quantity = parseInt(document.getElementById('quantity').value) || 1;
        const instructions = document.getElementById('special-instructions').value;
        const extras = Array.from(document.querySelectorAll('input[name="biryani-extra"]:checked')).map(extra => extra.value);
        const extrasCost = extras.reduce((sum, extra) => sum + (extrasPrices[extra] || 0), 0);
        const itemTotal = (price + extrasCost) * quantity;
        const cartItem = { name, price, quantity, instructions, extras, itemTotal, extrasQuantities: extras.map(() => 1) };
        cart.push(cartItem);
        alert(`${name} added to cart!`);
        updateCartDisplay();
        closeModal();
    }
    function updateCartDisplay() {
        let totalBill = 0;
        let cartHTML = "<div class='cart-container'>";
        cart.forEach((item, index) => {
            totalBill += item.itemTotal;
            const extras = item.extras.map((extra, i) => {
                const extraQuantity = item.extrasQuantities ? item.extrasQuantities[i] || 1 : 1;
                const extraTotal = extrasPrices[extra] * extraQuantity;
                totalBill += extraTotal;
                return `<div class='cart-item'>
                            <span>${extra}</span>
                            <span>Price: $${extrasPrices[extra].toFixed(2)}</span>
                            <div class='quantity-container'>
                                <label for='extra-quantity-${index}-${i}'>Quantity:</label>
                                <input type='number' id='extra-quantity-${index}-${i}' value='${extraQuantity}' min='1' style='width: 50px;' onchange='updateExtraQuantity(${index}, ${i}, this.value)'>
                            </div>
                            <span>Total: $${extraTotal.toFixed(2)}</span>
                            <input type='checkbox' id='extra-remove-${index}-${i}' onclick='removeExtra(${index}, ${i})'> Remove
                        </div>`;
            }).join('');
            cartHTML += `<div class='cart-item'>
                            <span>${item.name}</span>
                            <span>Item Price: $${item.price.toFixed(2)}</span>
                            <div class='quantity-container'>
                                <label for='item-quantity-${index}'>Quantity:</label>
                                <input type='number' id='item-quantity-${index}' value='${item.quantity}' min='1' style='width: 50px;' onchange='updateItemQuantity(${index}, this.value)'>
                            </div>
                            <span>Total: $${(item.price * item.quantity).toFixed(2)}</span>
                            <input type='checkbox' id='item-remove-${index}' onclick='removeItem(${index})'> Remove
                        </div>
                        ${extras}
                        <div class='cart-item'><strong>Instructions:</strong> ${item.instructions || "None"}</div>`;
        });
        cartHTML += `</div><p class='cart-total'>Total Bill: $${totalBill.toFixed(2)}</p>`;
        cartHTML += `<button style='margin-top: 10px; background-color: #007bff; color: white; border: none; padding: 10px; border-radius: 5px; width: 100%; cursor: pointer;' onclick='submitCart()'>Submit</button>`;
        document.getElementById('floating-cart').innerHTML = cartHTML;
    }
    function updateItemQuantity(index, newQuantity) {
        const quantity = parseInt(newQuantity) || 1;
        cart[index].quantity = quantity;
        cart[index].itemTotal = cart[index].price * quantity;
        updateCartDisplay();
    }
    function updateExtraQuantity(cartIndex, extraIndex, newQuantity) {
        const quantity = parseInt(newQuantity) || 1;
        cart[cartIndex].extrasQuantities = cart[cartIndex].extrasQuantities || [];
        cart[cartIndex].extrasQuantities[extraIndex] = quantity;
        updateCartDisplay();
    }
    function removeExtra(cartIndex, extraIndex) {
        cart[cartIndex].extras.splice(extraIndex, 1);
        if (cart[cartIndex].extrasQuantities) {
            cart[cartIndex].extrasQuantities.splice(extraIndex, 1);
        }
        updateCartDisplay();
    }
    function removeItem(index) {
        cart.splice(index, 1);
        updateCartDisplay();
    }
    function submitCart() {
        let finalOrderHTML = "<h3>Final Order:</h3><ul>";
        let totalBill = 0;
        cart.forEach(item => {
            totalBill += item.itemTotal;
            const extras = item.extras.map((extra, i) => {
                const extraQuantity = item.extrasQuantities ? item.extrasQuantities[i] || 1 : 1;
                const extraTotal = extrasPrices[extra] * extraQuantity;
                totalBill += extraTotal;
                return `${extra} (x${extraQuantity}) - $${extraTotal.toFixed(2)}`;
            }).join(', ');
            finalOrderHTML += `<li>
                ${item.name} (x${item.quantity}) - $${item.itemTotal.toFixed(2)}
                <br>Extras: ${extras}
                <br>Instructions: ${item.instructions || "None"}
            </li>`;
        });
        finalOrderHTML += `</ul><p><strong>Total Bill: $${totalBill.toFixed(2)}</strong></p>`;
        document.getElementById('final-order').innerHTML = finalOrderHTML;
        alert("Your final order has been submitted!");
    }
</script>
"""

def app_interface():
    # Login Button Actions
    def authenticate_user(email, password):
        if check_credentials(email, password):
            return (
                gr.update(visible=False),  # Hide login page
                gr.update(visible=True),  # Show preferences page
                gr.update(visible=True),  # Show menu page
                "",  # Clear any error message
            )
        else:
            return (
                gr.update(visible=True),  # Show error box
                gr.update(visible=False),  # Keep preferences page hidden
                gr.update(visible=False),  # Keep menu page hidden
                "Invalid email or password. Try again.",  # Error message
            )

    def navigate_to_signup():
        return gr.update(visible=False), gr.update(visible=True)

    def create_account(name, phone, email, password):
        if save_user(name, phone, email, password):
            return "Account created successfully! You can now log in.", gr.update(visible=True), gr.update(visible=False)
        else:
            return "Email already exists. Try logging in.", gr.update(visible=False), gr.update(visible=True)

    def navigate_to_login():
        return gr.update(visible=True), gr.update(visible=False)

    with gr.Blocks() as app:
        # Login Page
        with gr.Column(visible=True) as login_section:
            gr.Markdown("# Login Page")
            email = gr.Textbox(label="Email", placeholder="Enter your email")
            password = gr.Textbox(label="Password", placeholder="Enter your password", type="password")
            error_box = gr.Markdown("", visible=False)
            login_btn = gr.Button("Login")
            create_account_btn = gr.Button("Create an Account")

        # Sign-Up Page
        with gr.Column(visible=False) as signup_section:
            gr.Markdown("# Sign Up Page")
            name = gr.Textbox(label="Name", placeholder="Enter your full name")
            phone = gr.Textbox(label="Phone", placeholder="Enter your phone number")
            signup_email = gr.Textbox(label="Email", placeholder="Enter your email")
            signup_password = gr.Textbox(label="Password", placeholder="Enter a password", type="password")
            success_message = gr.Markdown("", visible=False)
            error_message = gr.Markdown("", visible=False)
            submit_btn = gr.Button("Sign Up")
            back_to_login_btn = gr.Button("Back to Login")

        # Preferences Page
        with gr.Column(visible=False) as preference_section:
            gr.Markdown("# Preferences Page")

        # Menu Page
        with gr.Column(visible=False) as menu_section:
            gr.Markdown("## Dynamic Menu with Preferences")

            selected_preference = gr.Radio(
                choices=["All", "Vegetarian", "Halal/Non-Veg", "Guilt-Free"],
                value="All",
                label="Choose a Preference",
            )

            menu_output = gr.HTML(value=filter_menu("All"))
            cart_output = gr.HTML(value="Your cart is empty.", elem_id="floating-cart")

            selected_preference.change(filter_menu, inputs=[selected_preference], outputs=[menu_output])

        # Button Actions for Login
        login_btn.click(
            authenticate_user,
            inputs=[email, password],
            outputs=[login_section, preference_section, menu_section, error_box],
        )
        create_account_btn.click(
            navigate_to_signup,
            inputs=[],
            outputs=[login_section, signup_section],
        )

        # Button Actions for Sign-Up
        submit_btn.click(
            create_account,
            inputs=[name, phone, signup_email, signup_password],
            outputs=[success_message, signup_section, login_section],
        )
        back_to_login_btn.click(
            navigate_to_login,
            inputs=[],
            outputs=[login_section, signup_section],
        )

    return app

if __name__ == "__main__":
    app = app_interface()
    app.launch()