| | |
| | | |
| | | // 查询基本信息,包含区域信息 |
| | | String sql = """ |
| | | SELECT ap.id as ap_id, ap.description as ap_description, ap.activity_id, ap.region_id, |
| | | 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.gender, u.birthday, p.education, p.introduction, u.id as user_id, |
| | |
| | | response.setState(0); |
| | | } |
| | | response.setActivityName(row.get("activity_name") != null ? row.get("activity_name").toString() : ""); |
| | | |
| | | // 设置阶段ID |
| | | Object stageIdObj = row.get("stage_id"); |
| | | if (stageIdObj != null) { |
| | | if (stageIdObj instanceof Number) { |
| | | response.setStageId(((Number) stageIdObj).longValue()); |
| | | } else { |
| | | log.warn("阶段ID类型不匹配: {}, 类型: {}", stageIdObj, stageIdObj.getClass().getName()); |
| | | response.setStageId(Long.valueOf(stageIdObj.toString())); |
| | | } |
| | | } else { |
| | | response.setStageId(null); |
| | | } |
| | | |
| | | // 构建学员信息 |
| | | PlayerInfoResponse playerInfo = new PlayerInfoResponse(); |