| | |
| | | @SuppressWarnings("unchecked") |
| | | public List<ActivityPlayerApplicationResponse> listApplications(String name, Long activityId, Integer page, Integer size) { |
| | | String baseSql = |
| | | "SELECT ap.id, p.name AS player_name, a.name AS activity_name, p.phone AS phone, ap.create_time AS apply_time, p.audit_state AS state " + |
| | | "SELECT ap.id, p.name AS player_name, a.name AS activity_name, p.phone AS phone, ap.create_time AS apply_time, p.state AS state " + |
| | | "FROM t_activity_player ap " + |
| | | "JOIN t_player p ON p.id = ap.player_id " + |
| | | "JOIN t_activity a ON a.id = ap.activity_id "; |
| | |
| | | dto.setActivityName(r[2] != null ? r[2].toString() : ""); |
| | | dto.setPhone(r[3] != null ? r[3].toString() : ""); |
| | | dto.setApplyTime(r[4] != null ? r[4].toString() : ""); |
| | | // 映射状态:使用 t_player.audit_state(0=未审核,1=进行中,2=已驳回,3=结束) |
| | | dto.setState(r[5] != null ? Integer.valueOf(r[5].toString()) : 0); |
| | | // 映射状态:使用 t_player.state(1=有效,0=无效) |
| | | dto.setState(r[5] != null ? Integer.valueOf(r[5].toString()) : 1); |
| | | list.add(dto); |
| | | } |
| | | return list; |