From 58d9f460b2f8c34430285115e2557d18333c5cab Mon Sep 17 00:00:00 2001
From: Codex Assistant <codex@example.com>
Date: 星期三, 08 十月 2025 14:16:55 +0800
Subject: [PATCH] feat: 修复Player实体phone字段数据冗余问题并优化小程序报名逻辑

---
 backend/src/main/java/com/rongyichuang/player/service/ActivityPlayerDetailService.java |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/backend/src/main/java/com/rongyichuang/player/service/ActivityPlayerDetailService.java b/backend/src/main/java/com/rongyichuang/player/service/ActivityPlayerDetailService.java
index ba7601e..1ab5cf0 100644
--- a/backend/src/main/java/com/rongyichuang/player/service/ActivityPlayerDetailService.java
+++ b/backend/src/main/java/com/rongyichuang/player/service/ActivityPlayerDetailService.java
@@ -59,8 +59,9 @@
         String sql = """
             SELECT ap.id as ap_id, ap.description as ap_description, ap.activity_id, ap.region_id, ap.stage_id,
                    ap.project_name, ap.feedback, ap.state as ap_state,
-                   p.id as player_id, p.name as player_name, p.phone, p.description as player_desc,
+                   p.id as player_id, p.name as player_name, u.phone, p.description as player_desc,
                    p.gender, u.birthday, p.education, p.introduction, u.id as user_id,
+                   u.name as user_name, u.phone as user_phone,
                    a.name as activity_name, a.rating_scheme_id,
                    r.id as region_id, r.name as region_name, r.full_path as region_path
             FROM t_activity_player ap

--
Gitblit v1.8.0