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)