| | |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 查询活动报名信息 |
|---|
| | | * 当传入activityId时，查询该比赛下第一个阶段（sort_order=1）的报名项目 |
|---|
| | | */ |
|---|
| | | @SuppressWarnings("unchecked") |
|---|
| | | public List<ActivityPlayerApplicationResponse> listApplications(String name, Long activityId, Integer state, Integer page, Integer size) { |
|---|
| | | String baseSql = |
|---|
| | | "SELECT ap.id, p.name AS player_name, a.name AS activity_name, ap.project_name AS project_name, p.phone AS phone, ap.create_time AS apply_time, ap.state AS state " + |
|---|
| | | "SELECT ap.id, p.name AS player_name, stage.name AS activity_name, ap.project_name AS project_name, p.phone AS phone, ap.create_time AS apply_time, ap.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 "; |
|---|
| | | "JOIN t_activity stage ON stage.id = ap.stage_id "; |
|---|
| | | |
|---|
| | | StringBuilder whereClause = new StringBuilder(); |
|---|
| | | boolean hasCondition = false; |
|---|
| | |
|---|
| | | if (hasCondition) { |
|---|
| | | whereClause.append(" AND "); |
|---|
| | | } |
|---|
| | | whereClause.append("ap.stage_id = :activityId"); |
|---|
| | | // 查询指定主比赛的第一阶段报名项目：activity_id=主比赛ID, stage_id=第一阶段ID |
|---|
| | | whereClause.append("ap.activity_id = :activityId AND stage.pid = :activityId AND stage.sort_order = 1"); |
|---|
| | | hasCondition = true; |
|---|
| | | } |
|---|
| | | |
|---|
