streamlit_app (2).py

import streamlit as st
import pandas as pd
import datetime

# 1. 設置頁面配置
st.set_page_config(page_title="TNYP DUPR 專業驗證錄入", page_icon="🏓", layout="wide")

# ==========================================
# 賽程邏輯定義 (落地得分 21場 vs 發球得分 14場)
# ==========================================

# --- 8 人制雙打 ---
# 落地得分 (Rally) - 21 場 (基於原本 19 場新增 2 場)
SCHEDULE_8_RALLY = [
  ("A", "G", "D", "C"),("E", "H", "F", "B"),("C", "F", "D", "H"),("A", "E", "G", "B"),
  ("G", "D", "E", "F"),("C", "A", "H", "B"),("G", "F", "D", "A"),("E", "B", "C", "H"),
  ("G", "F", "B", "C"),("A", "H", "D", "E"),("B", "C", "D", "F"),("G", "E", "H", "A"),
  ("H", "E", "D", "B"),("C", "G", "F", "A"),("G", "H", "E", "C"),("B", "A", "D", "F"),
  ("H", "B", "G", "A"),("C", "F", "E", "D"),("B", "G", "F", "H"),("A", "E", "C", "D"),
  ("E", "C", "B", "D")
]

# 發球得分 (Sideout) - 14 場 (擷取前 14 場)
SCHEDULE_8_SIDEOUT = [
    ("H", "A", "B", "D"), ("C", "G", "E", "F"), ("E", "B", "G", "A"), ("H", "C", "D", "F"), 
    ("B", "F", "D", "E"), ("H", "G", "A", "C"), ("H", "D", "E", "G"), ("F", "C", "A", "B"), 
    ("H", "B", "C", "E"), ("D", "A", "F", "G"), ("A", "E", "C", "D"), ("H", "F", "G", "B"), 
    ("G", "D", "B", "C"), ("H", "E", "F", "A")
]

# --- 7 人制雙打 ---
# 落地得分 (Rally) - 21 場
SCHEDULE_7_RALLY = [
    ("F", "D", "B", "E"),("C", "G", "A", "B"),("A", "F", "E", "D"),("G", "F", "C", "E"),
    ("B", "D", "A", "C"),("G", "A", "F", "E"),("C", "B", "D", "G"),("E", "A", "D", "C"),
    ("F", "A", "B", "G"),("E", "C", "B", "F"),("D", "A", "G", "E"),("C", "F", "D", "B"),
    ("G", "C", "A", "E"),("F", "B", "G", "D"),("A", "C", "E", "B"),("D", "C", "G", "F"),
    ("B", "A", "E", "G"),("F", "C", "D", "A"),("E", "F", "G", "B"),("D", "E", "B", "C"),
    ("A", "G", "F", "D")
]
# 發球得分 (Sideout) - 14 場
SCHEDULE_7_SIDEOUT = [
    ("E", "G", "A", "C"), ("B", "F", "D", "C"), ("D", "E", "F", "G"), ("A", "G", "B", "C"), 
    ("A", "E", "D", "B"), ("F", "D", "C", "E"), ("G", "B", "A", "F"), ("C", "G", "B", "D"), 
    ("E", "A", "F", "C"), ("B", "E", "G", "D"), ("F", "C", "A", "D"), ("B", "G", "F", "E"), 
    ("A", "B", "E", "D"), ("C", "A", "G", "F")
]

# 6 人與 5 人維持原本邏輯 (可視需求調整)
SCHEDULE_6_DBL = [("A", "B", "C", "D"), ("E", "F", "A", "C"), ("B", "E", "D", "F"), ("A", "D", "B", "F"), ("C", "E", "A", "B"), ("D", "F", "C", "E"), ("A", "F", "B", "D"), ("C", "D", "A", "E"), ("B", "C", "E", "F"), ("A", "D", "B", "E"), ("C", "F", "A", "B"), ("B", "D", "E", "F"), ("A", "F", "C", "D"), ("B", "E", "A", "D"), ("C", "E", "B", "F")]
SCHEDULE_5_SGL = [("A", None, "B", None), ("C", None, "D", None), ("E", None, "A", None), ("B", None, "C", None), ("D", None, "E", None), ("A", None, "C", None), ("B", None, "D", None), ("C", None, "E", None), ("A", None, "D", None), ("B", None, "E", None), ("B", None, "A", None), ("D", None, "C", None), ("A", None, "E", None), ("C", None, "B", None), ("E", None, "D", None), ("C", None, "A", None), ("D", None, "B", None), ("E", None, "C", None), ("D", None, "A", None), ("E", None, "B", None)]

# 更新：完全對齊 single-match-import.csv 的所有欄位與順序
DUPR_COLS = [
    'matchType', 'event', 'date', 
    'playerA1', 'playerA1DuprId', 'playerA1ExternalId', 
    'playerA2', 'playerA2DuprId', 'playerA2ExternalId', 
    'playerB1', 'playerB1DuprId', 'playerB1ExternalId', 
    'playerB2', 'playerB2DuprId', 'playerB2ExternalId', 
    'teamAGame1', 'teamBGame1', 'teamAGame2', 'teamBGame2', 
    'teamAGame3', 'teamBGame3', 'teamAGame4', 'teamBGame4', 
    'teamAGame5', 'teamBGame5', 'location', 'scoreType'
]

st.title("🏓 TNYP DUPR 專業驗證錄入系統")

with st.sidebar:
    st.header("⚙️ 全域設定")
    event_main = st.text_input("活動名稱", value="TNYP Match")
    global_date = st.date_input("日期", datetime.date.today())
    
    # 新增：設定全域的比賽地址 Location
    global_location = st.text_input("比賽地址 (Location)", value="", placeholder="例如: 台北市某某球館")
    
    # 決定核心邏輯的計分方式
    global_score_type = st.selectbox("計分方式", ["RALLY (落地得分 - 21場)", "SIDEOUT (發球得分 - 14場)"])
    score_type_val = "RALLY" if "RALLY" in global_score_type else "SIDEOUT"
    court_count = st.number_input("場地數量", min_value=1, max_value=6, value=2)

tab_list = st.tabs([f"🏟️ 場地 {i+1}" for i in range(court_count)])
all_matches_combined = []

for i in range(court_count):
    cid = i + 1
    with tab_list[i]:
        mode = st.selectbox(f"場地 {cid} 賽制", 
                            ["雙打 - 8人制", "雙打 - 7人制", "雙打 - 6人制", "單打 - 5人制 (20場)"], 
                            key=f"mode_sel_{cid}")
        
        # 根據選擇的人數與計分方式，決定最終的賽程表
        if "8人制" in mode:
            p_labels, m_type = ['A','B','C','D','E','F','G','H'], "D"
            sch = SCHEDULE_8_RALLY if score_type_val == "RALLY" else SCHEDULE_8_SIDEOUT
        elif "7人制" in mode:
            p_labels, m_type = ['A','B','C','D','E','F','G'], "D"
            sch = SCHEDULE_7_RALLY if score_type_val == "RALLY" else SCHEDULE_7_SIDEOUT
        elif "6人制" in mode:
            p_labels, sch, m_type = ['A','B','C','D','E','F'], SCHEDULE_6_DBL, "D"
        else:
            p_labels, sch, m_type = ['A','B','C','D','E'], SCHEDULE_5_SGL, "S"

        # 球員名單
        with st.expander(f"👤 名單驗證 (場地 {cid})", expanded=True):
            p_map = {}
            col1, col2 = st.columns(2)
            temp_ids = set()
            for idx, l in enumerate(p_labels):
                target_col = col1 if idx % 2 == 0 else col2
                n = target_col.text_input(f"姓名 {l}", key=f"n_{cid}_{l}")
                did = target_col.text_input(f"ID {l}", key=f"id_{cid}_{l}").strip().upper()
                if did and did in temp_ids: st.error(f"ID 重複: {did}")
                temp_ids.add(did)
                p_map[l] = {"n": n, "id": did}

        # 比分錄入
        st.subheader(f"🎯 比分錄入 (共 {len(sch)} 場)")
        court_data = []
        c_error = False

        for g_idx, (a1, a2, b1, b2) in enumerate(sch, 1):
            with st.container(border=True):
                idx_col, c1, c2, mid, c3, c4 = st.columns([0.6, 2, 1, 0.5, 1, 2])
                idx_col.markdown(f"### {g_idx:02d}")
                c1.markdown(f"**{a1}:** {p_map[a1]['n'] or '?'}")
                if a2: c1.markdown(f"**{a2}:** {p_map[a2]['n'] or '?'}")
                sa = c2.text_input("A", key=f"sA_{cid}_{g_idx}", label_visibility="collapsed")
                mid.write("-")
                sb = c3.text_input("B", key=f"sB_{cid}_{g_idx}", label_visibility="collapsed")
                c4.markdown(f"**{b1}:** {p_map[b1]['n'] or '?'}")
                if b2: c4.markdown(f"**{b2}:** {p_map[b2]['n'] or '?'}")

                if sa.strip() and sb.strip():
                    try:
                        s1, s2 = int(sa), int(sb)
                        if s1 == s2:
                            st.error(f"第 {g_idx} 場平分")
                            c_error = True
                        
                        # 更新：包含新增的 location 與各球員的 ExternalId
                        entry = {
                            'matchType': m_type, 'scoreType': score_type_val,
                            'event': f"{event_main}-C{cid}", 'date': global_date.strftime("%Y-%m-%d"),
                            'location': global_location,
                            'playerA1': p_map[a1]['n'], 'playerA1DuprId': p_map[a1]['id'], 'playerA1ExternalId': '',
                            'playerA2': p_map[a2]['n'] if a2 else '', 'playerA2DuprId': p_map[a2]['id'] if a2 else '', 'playerA2ExternalId': '',
                            'playerB1': p_map[b1]['n'], 'playerB1DuprId': p_map[b1]['id'], 'playerB1ExternalId': '',
                            'playerB2': p_map[b2]['n'] if b2 else '', 'playerB2DuprId': p_map[b2]['id'] if b2 else '', 'playerB2ExternalId': '',
                            'teamAGame1': s1, 'teamBGame1': s2,
                            'teamAGame2': '', 'teamBGame2': '', 'teamAGame3': '', 'teamBGame3': '',
                            'teamAGame4': '', 'teamBGame4': '', 'teamAGame5': '', 'teamBGame5': ''
                        }
                        court_data.append(entry)
                        all_matches_combined.append(entry)
                    except: st.error("請輸入整數數字")

        # 個別場地下載
        if court_data:
            st.divider()
            if not c_error:
                df_c = pd.DataFrame(court_data).reindex(columns=DUPR_COLS).fillna('')
                st.download_button(f"📥 下載場地 {cid} CSV", df_c.to_csv(index=False).encode('utf-8'), 
                                   f"Court_{cid}.csv", "text/csv", key=f"btn_{cid}")
            else:
                st.warning("請修正平分錯誤後下載")

# 總下載
if all_matches_combined:
    st.divider()
    df_all = pd.DataFrame(all_matches_combined).reindex(columns=DUPR_COLS).fillna('')
    st.download_button("🚀 下載所有場地合併 CSV", df_all.to_csv(index=False).encode('utf-8'), 
                       "TNYP_Total.csv", "text/csv", type="primary", use_container_width=True)