import bcrypt
import gradio as gr
from simple_salesforce import Salesforce

# Salesforce Connection
sf = Salesforce(username='diggavalli98@gmail.com', password='Sati@1020', security_token='sSSjyhInIsUohKpG8sHzty2q')

# Function to Hash Password
def hash_password(password):
    return bcrypt.hashpw(password.encode('utf-8'), bcrypt.gensalt()).decode('utf-8')

# Function to Verify Password
def verify_password(plain_password, hashed_password):
    return bcrypt.checkpw(plain_password.encode('utf-8'), hashed_password.encode('utf-8'))

# Signup function
def signup(name, email, phone, password):
    try:
        email = email.strip()

        # Check if the email already exists in Salesforce
        query = f"SELECT Id FROM Customer_Login__c WHERE Email__c = '{email}'"
        result = sf.query(query)

        if len(result['records']) > 0:
            return "Email already exists! Please use a different email."

        # Hash the password
        hashed_password = hash_password(password)

        # Create the new user record
        sf.Customer_Login__c.create({
            'Name': name.strip(),
            'Email__c': email,
            'Phone_Number__c': phone.strip(),
            'Password__c': hashed_password
        })
        return "Signup successful! You can now login."
    except Exception as e:
        return f"Error during signup: {str(e)}"

# Login function
def login(email, password):
    try:
        email = email.strip()
        password = password.strip()

        # Query Salesforce for user details
        query = f"SELECT Name, Password__c FROM Customer_Login__c WHERE Email__c = '{email}'"
        result = sf.query(query)

        if len(result['records']) == 0:
            return "Invalid email or password.", None

        user = result['records'][0]
        stored_password = user['Password__c']

        # Verify the entered password with the stored hash
        if verify_password(password, stored_password):
            return "Login successful!", user['Name']
        else:
            return "Invalid email or password.", None
    except Exception as e:
        return f"Error during login: {str(e)}", None

# Function to load menu data
def load_menu_from_salesforce():
    try:
        query = "SELECT Name, Price__c, Description__c, Image1__c, Veg_NonVeg__c, Section__c FROM Menu_Item__c"
        result = sf.query(query)
        return result['records']
    except Exception as e:
        return []

# Function to filter menu items
def filter_menu(preference):
    menu_data = load_menu_from_salesforce()

    filtered_data = {}
    for item in menu_data:
        if "Section__c" not in item or "Veg_NonVeg__c" not in item:
            continue

        if item["Section__c"] not in filtered_data:
            filtered_data[item["Section__c"]] = []

        if preference == "All" or (preference == "Veg" and item["Veg_NonVeg__c"] in ["Veg", "Both"]) or (preference == "Non-Veg" and item["Veg_NonVeg__c"] in ["Non veg", "Both"]):
            filtered_data[item["Section__c"]].append(item)

    html_content = '<div style="padding: 20px; max-width: 1200px; margin: auto;">'
    for section, items in filtered_data.items():
        if items:
            html_content += f"<h2 style='text-align: center;'>{section}</h2>"
            html_content += '<div style="display: flex; flex-wrap: wrap; gap: 20px; justify-content: center;">'
            for item in items:
                html_content += f"""
                <div style="width: 300px; border: 1px solid #ddd; border-radius: 10px; box-shadow: 0px 4px 8px rgba(0, 0, 0, 0.1);">
                    <img src="{item.get('Image1__c', '')}" style="width: 100%; height: 200px; object-fit: cover;">
                    <div style="padding: 10px;">
                        <h3>{item['Name']}</h3>
                        <p>${item['Price__c']}</p>
                        <p>{item['Description__c']}</p>
                    </div>
                </div>
                """
            html_content += '</div>'
    html_content += '</div>'

    if not any(filtered_data.values()):
        return "<p>No items match your filter.</p>"

    return html_content

# Gradio App
with gr.Blocks() as app:
    with gr.Row():
        gr.HTML("<h1 style='text-align: center;'>Welcome to Biryani Hub</h1>")

    with gr.Row(visible=True) as login_page:
        with gr.Column():
            login_email = gr.Textbox(label="Email")
            login_password = gr.Textbox(label="Password", type="password")
            login_button = gr.Button("Login")
            signup_button = gr.Button("Go to Signup")
            login_output = gr.Textbox(label="Status")

    with gr.Row(visible=False) as signup_page:
        with gr.Column():
            signup_name = gr.Textbox(label="Name")
            signup_email = gr.Textbox(label="Email")
            signup_phone = gr.Textbox(label="Phone")
            signup_password = gr.Textbox(label="Password", type="password")
            submit_signup = gr.Button("Signup")
            login_redirect = gr.Button("Go to Login")
            signup_output = gr.Textbox(label="Status")

    with gr.Row(visible=False) as menu_page:
        preference = gr.Radio(choices=["All", "Veg", "Non-Veg"], label="Filter Preference", value="All")
        menu_output = gr.HTML()

    with gr.Row(visible=False) as footer:
        gr.HTML("<footer style='text-align: center;'>Thank you! Welcome again!</footer>")

    def handle_login(email, password):
        status, user = login(email, password)
        if status == "Login successful!":
            content = filter_menu("All")  # Default to "All" on login
            return gr.update(visible=False), gr.update(visible=True), gr.update(visible=True), gr.update(value=content), status
        else:
            return gr.update(), gr.update(), gr.update(), gr.update(), status

    def handle_signup(name, email, phone, password):
        return signup(name, email, phone, password)

    def handle_menu(preference):
        content = filter_menu(preference)
        return content

    login_button.click(
        handle_login, [login_email, login_password], [login_page, menu_page, footer, menu_output, login_output]
    )
    signup_button.click(lambda: (gr.update(visible=False), gr.update(visible=True)), None, [login_page, signup_page])
    submit_signup.click(handle_signup, [signup_name, signup_email, signup_phone, signup_password], signup_output)
    preference.change(handle_menu, [preference], menu_output)

app.launch()