From c4a9cad1c50e89365e2a58b50e259af642ed3b8c Mon Sep 17 00:00:00 2001
From: Codex Assistant <codex@example.com>
Date: 星期二, 07 十月 2025 16:12:20 +0800
Subject: [PATCH] feat(review): 调整评审详情展示顺序与样式,描述支持多行,项目信息列宽40/60 fix(auth): 登录页与首页循环跳转保护;api.ts 在登录页不再重定向;401分支在登录页不跳转 fix(router): /login 放行策略优化,避免死循环;评审列表跳转到 /project-review/:id/detail fix(frontend): 补齐 utils/appConfig.ts,避免启动白屏 fix(review): 详情页提交评分缺少stageId时回退使用项目详情的stageId feat(backend): ActivityPlayerDetailResponse.playerInfo 补充 avatarUrl/avatar,服务组装时填充用户头像 chore(dev): 启动脚本注入本地JWT密钥,重启前后端

---
 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