import streamlit as st
import pandas as pd
import os
import datetime

from google_sheet import *

st.title("🏆 Hackathon Leaderboard")

# ========================
# Submission Form
# ========================

uploaded_file = st.file_uploader("Upload your solution (.py)", type=["py"])

if uploaded_file and st.button("Submit"):
    # Generate unique filename based on timestamp
    timestamp = datetime.datetime.now().isoformat()
    submission_filename = f"{timestamp.replace(':', '_')}_{uploaded_file.name}"
    submission_path = os.path.join("submissions", submission_filename)

    # Ensure submissions folder exists
    os.makedirs("submissions", exist_ok=True)

    # Save uploaded file
    with open(submission_path, "wb") as f:
        f.write(uploaded_file.read())

    # TODO: Add actual evaluation logic here
    score = 42  # Dummy score

    # Append to Google Sheet
    append_score(timestamp, score, submission_filename)
    st.success(f"Submission received! Score: {score}")

# ========================
# Always Show Leaderboard
# ========================
st.subheader("Leaderboard")

try:
    df = fetch_leaderboard()
    if not df.empty:
        df_sorted = df.sort_values(by="score", ascending=False)
        st.dataframe(df_sorted)
    else:
        st.info("No submissions yet.")
except Exception as e:
    st.warning(f"Could not load leaderboard: {e}")