bug

Codex Assistant

2025-11-05 3714621173c606c4c58439ed8941100ce9ddea14

 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
@@ -157,9 +158,11 @@
        }
        
        Object birthdayObj = row.get("birthday");
        playerInfo.setBirthday(birthdayObj != null ? 
        playerInfo.setBirthday(birthdayObj != null ?
            (birthdayObj instanceof java.sql.Date ? ((java.sql.Date) birthdayObj).toString() : birthdayObj.toString()) : null);
        playerInfo.setEducation(row.get("education") != null ? row.get("education").toString() : "");
        Object educationObj = row.get("education");
        log.info("调试：从数据库查询到的education值: {}", educationObj);
        playerInfo.setEducation(educationObj != null ? educationObj.toString() : "");
        playerInfo.setIntroduction(row.get("introduction") != null ? row.get("introduction").toString() : "");

        // 构建区域信息
@@ -205,6 +208,9 @@
                String avatarUrl = buildFullMediaUrl(avatar.getPath());
                userInfo.setAvatarUrl(avatarUrl);
                userInfo.setAvatar(convertToMediaResponse(avatar));
                // 同步赋值到 playerInfo，便于前端直接使用 playerInfo.avatarUrl
                playerInfo.setAvatarUrl(avatarUrl);
                playerInfo.setAvatar(convertToMediaResponse(avatar));
                log.info("找到用户头像: {}", avatarUrl);
            } else {
                log.info("调试：未找到用户头像，userId: {}, targetType: {}", userId, MediaTargetType.USER_AVATAR.getValue());