import streamlit as st
from supabase import create_client, Client
from deep_translator import GoogleTranslator

URL = "https://ulqepcglktyojwtnhnga.supabase.co"
KEY = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InVscWVwY2dsa3R5b2p3dG5obmdhIiwicm9sZSI6ImFub24iLCJpYXQiOjE3NzIwMDM0MjAsImV4cCI6MjA4NzU3OTQyMH0.JLcSI9fYNxjW0MSkJKexXU8KBRQUzrZEj7s7hcbXuAc"
supabase: Client = create_client(URL, KEY)

st.set_page_config(page_title="Info Prodotto", page_icon="🍷")
def translate(text, lang):
    if not text or lang == 'it': return text
    try: return GoogleTranslator(source='auto', target=lang).translate(text)
    except: return text

id_v = st.query_params.get("id")

if id_v:
    res = supabase.table("wine_labels").select("*").eq("id", id_v).execute()
    if res.data:
        v = res.data[0]
        t = {"Italiano": "it", "English": "en", "Français": "fr", "Deutsch": "de", "Español": "es"}[st.selectbox("🌍 Language", ["Italiano", "English", "Français", "Deutsch", "Español"])]
        
        st.markdown(f"### {v.get('brand_name', '')}")
        st.header(f"{v.get('wine_name', '')} {int(v.get('vintage', 0))}")
        
        if v.get('is_dealcoholized'):
            st.warning("⚠️ " + translate("Prodotto ottenuto mediante dealcolizzazione", t))
        
        st.subheader("📊 " + translate("Dichiarazione Nutrizionale", t))
        st.markdown(f"**{translate('Energia', t)}:** {int(v.get('energy_kj', 0))} kJ / {int(v.get('energy_kcal', 0))} kcal  \n**{translate('Zuccheri', t)}:** {v.get('carbs_sugar', 0)} g  \n**{translate('Sale', t)}:** {v.get('salt', 0)} g")
        st.info(f"**{translate('Ingredienti', t)}:** {translate(v.get('ingredients', ''), t)}")
        
        st.subheader("♻️ " + translate("Smaltimento", t))
        c1, c2, c3 = st.columns(3)
        c1.write(f"🍾 **Bottiglia**\n{v.get('bottle_material', 'GL 71')}")
        c2.write(f"🌱 **Tappo**\n{v.get('cork_material', 'FOR 51')}")
        c3.write(f"🛡️ **Capsula**\n{v.get('capsule_material', 'C/ALU 90')}")
    else:
        st.error("Etichetta non trovata.")
else:
    st.info("Scansiona un QR Code WineLink.")