From ba94ceae1315174798ae1967ef62268c6d16cd5b Mon Sep 17 00:00:00 2001
From: Codex Assistant <codex@example.com>
Date: 星期一, 06 十月 2025 22:07:06 +0800
Subject: [PATCH] feat: 评审与活动相关改动 - backend(GraphQL): Activity schema 增加 updateActivityState(id, state)；实现 resolver/service 仅更新 state=2 作为逻辑删除 - backend(GraphQL): region.graphqls 新增 Query leafRegions - backend(GraphQL): player.graphqls 的 projectReviewApplications 增加可选参数 regionId - backend(Service): listProjectReviewApplications 绑定 regionId 参数，修复 QueryParameterException - frontend(web): 新增 api/activity.js 的 updateActivityState 并接入 activity-list 删除逻辑 - frontend(web): review-list.vue 权限仅校验登录，移除角色限制；查询参数修正为 name/regionId - frontend(web): 删除未引用的 ActivityList.vue - frontend(web): projectReviewNew.js GraphQL 查询增加 name 参数
---
backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java | 16 +++++++---------
1 files changed, 7 insertions(+), 9 deletions(-)
diff --git a/backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java b/backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java
index 7371df3..69410d6 100644
--- a/backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java
+++ b/backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java
@@ -48,14 +48,13 @@
userIds.add(uid);
}
- // 3) 鎻掑叆 20 涓鍛橈紙audit_state=0 鏈鏍革級
+ // 3) 鎻掑叆 20 涓鍛�
List<Long> playerIds = new ArrayList<>();
for (int i = 1; i <= 20; i++) {
long pid = insertPlayer(conn,
"瀛﹀憳" + i,
"1380013" + String.format("%04d", i),
1, // role_id
- 0, // audit_state 鏈鏍�
1, // state=1 姝ｅ父
userIds.get(i - 1));
playerIds.add(pid);
@@ -131,15 +130,14 @@
throw new SQLException("鎻掑叆鐢ㄦ埛澶辫触");
}
- private long insertPlayer(Connection conn, String name, String phone, long roleId, int auditState, int state, long userId) throws SQLException {
- String sql = "INSERT INTO t_player (name, phone, role_id, audit_state, state, user_id) VALUES (?, ?, ?, ?, ?, ?)";
+ private long insertPlayer(Connection conn, String name, String phone, long roleId, int state, long userId) throws SQLException {
+ String sql = "INSERT INTO t_player (name, phone, role_id, state, user_id) VALUES (?, ?, ?, ?, ?)";
try (PreparedStatement ps = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)) {
ps.setString(1, name);
ps.setString(2, phone);
ps.setLong(3, roleId);
- ps.setInt(4, auditState);
- ps.setInt(5, state);
- ps.setLong(6, userId);
+ ps.setInt(4, state);
+ ps.setLong(5, userId);
ps.executeUpdate();
try (ResultSet keys = ps.getGeneratedKeys()) {
if (keys.next()) return keys.getLong(1);
@@ -148,9 +146,9 @@
throw new SQLException("鎻掑叆瀛﹀憳澶辫触");
}
- // 娉ㄦ剰锛氳〃鍚嶄负 t_avtivity_player锛堟寜 db.sql 鎷煎啓锛�
+ // 鎻掑叆娲诲姩鎶ュ悕鏁版嵁
private long insertActivityPlayer(Connection conn, long activityId, long playerId) throws SQLException {
- String sql = "INSERT INTO t_avtivity_player (activity_id, player_id) VALUES (?, ?)";
+ String sql = "INSERT INTO t_activity_player (activity_id, player_id) VALUES (?, ?)";
try (PreparedStatement ps = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)) {
ps.setLong(1, activityId);
ps.setLong(2, playerId);
--
Gitblit v1.8.0