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/player/repository/PlayerRepository.java | 16 +++++-----------
1 files changed, 5 insertions(+), 11 deletions(-)
diff --git a/backend/src/main/java/com/rongyichuang/player/repository/PlayerRepository.java b/backend/src/main/java/com/rongyichuang/player/repository/PlayerRepository.java
index 45cdab7..17151bf 100644
--- a/backend/src/main/java/com/rongyichuang/player/repository/PlayerRepository.java
+++ b/backend/src/main/java/com/rongyichuang/player/repository/PlayerRepository.java
@@ -26,11 +26,6 @@
Optional<Player> findByUserId(Long userId);
/**
- * 鏍规嵁瀹℃牳鐘舵�佹煡鎵惧鍛�
- */
- List<Player> findByAuditState(Integer auditState);
-
- /**
* 鏍规嵁瑙掕壊ID鏌ユ壘瀛﹀憳
*/
List<Player> findByRoleId(Long roleId);
@@ -41,10 +36,10 @@
List<Player> findByState(Integer state);
/**
- * 鏌ユ壘瀹℃牳閫氳繃鐨勫鍛�
+ * 鏌ユ壘鏈夋晥鐨勫鍛�
*/
- @Query("SELECT p FROM Player p WHERE p.auditState = 1 AND p.state = 1")
- List<Player> findApprovedPlayers();
+ @Query("SELECT p FROM Player p WHERE p.state = 1")
+ List<Player> findActivePlayers();
/**
* 鏍规嵁濮撳悕妯＄硦鏌ヨ瀛﹀憳
@@ -53,8 +48,7 @@
List<Player> findByNameContaining(@Param("name") String name);
/**
- * 缁熻鍚勫鏍哥姸鎬佺殑瀛﹀憳鏁伴噺
+ * 鏍规嵁鐘舵�佺粺璁″鍛樻暟閲�
*/
- @Query("SELECT p.auditState, COUNT(p) FROM Player p WHERE p.state = 1 GROUP BY p.auditState")
- List<Object[]> countByAuditState();
+ long countByState(Integer state);
}
\ No newline at end of file
--
Gitblit v1.8.0