From 9f8395fab13ca4b230a0f7d62636e209745c91d4 Mon Sep 17 00:00:00 2001 From: lrj <owen.stl@gmail.com> Date: 星期日, 28 九月 2025 14:16:18 +0800 Subject: [PATCH] feat: 完善注册流程的文件上传功能 --- backend/src/main/java/com/rongyichuang/player/service/PlayerApplicationService.java | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/backend/src/main/java/com/rongyichuang/player/service/PlayerApplicationService.java b/backend/src/main/java/com/rongyichuang/player/service/PlayerApplicationService.java index 2a34eb1..962cf57 100644 --- a/backend/src/main/java/com/rongyichuang/player/service/PlayerApplicationService.java +++ b/backend/src/main/java/com/rongyichuang/player/service/PlayerApplicationService.java @@ -20,7 +20,7 @@ @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 "; @@ -65,8 +65,8 @@ 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; -- Gitblit v1.8.0