| | |
|---|
| | | 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 |
|---|
| | |
|---|
| | | 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()); |
|---|
