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/ActivityPlayerRepository.java | 27 +++++++++++++++++++++++++++
1 files changed, 27 insertions(+), 0 deletions(-)
diff --git a/backend/src/main/java/com/rongyichuang/player/repository/ActivityPlayerRepository.java b/backend/src/main/java/com/rongyichuang/player/repository/ActivityPlayerRepository.java
index 82e151e..419dcbe 100644
--- a/backend/src/main/java/com/rongyichuang/player/repository/ActivityPlayerRepository.java
+++ b/backend/src/main/java/com/rongyichuang/player/repository/ActivityPlayerRepository.java
@@ -8,6 +8,7 @@
import java.util.List;
import java.util.Optional;
+import java.time.LocalDateTime;
/**
* 娲诲姩閫夋墜Repository鎺ュ彛
@@ -90,6 +91,32 @@
List<ActivityPlayer> findTopRankedPlayers(@Param("activityId") Long activityId);
/**
+ * 缁熻鏈�杩戞姤鍚嶈秼鍔匡紙浠呯涓�闃舵锛宻tate鍖呭惈寰呭鏍镐笌閫氳繃锛�
+ */
+ @Query(value = "SELECT DATE(ap.create_time) AS signup_date, COUNT(*) AS total " +
+ "FROM t_activity_player ap " +
+ "JOIN t_activity stage ON stage.id = ap.stage_id " +
+ "WHERE stage.sort_order = 1 AND stage.state = 1 " +
+ " AND ap.state IN (0, 1) " +
+ " AND ap.create_time >= :startDate " +
+ "GROUP BY DATE(ap.create_time) " +
+ "ORDER BY signup_date", nativeQuery = true)
+ List<Object[]> countFirstStageRegistrationsByDate(@Param("startDate") LocalDateTime startDate);
+
+ /**
+ * 缁熻鍚勫尯鍩熸姤鍚嶆暟閲忥紙浠呯涓�闃舵锛宻tate鍖呭惈寰呭鏍镐笌閫氳繃锛�
+ */
+ @Query(value = "SELECT ap.region_id, r.name, r.leaf_flag, COUNT(*) AS total " +
+ "FROM t_activity_player ap " +
+ "JOIN t_activity stage ON stage.id = ap.stage_id " +
+ "LEFT JOIN t_region r ON r.id = ap.region_id " +
+ "WHERE stage.sort_order = 1 AND stage.state = 1 " +
+ " AND ap.state IN (0, 1) " +
+ "GROUP BY ap.region_id, r.name, r.leaf_flag " +
+ "ORDER BY total DESC", nativeQuery = true)
+ List<Object[]> countFirstStageRegistrationsByRegion();
+
+ /**
* 缁熻鎸囧畾鐘舵�佺殑鍙傝禌閫夋墜鏁伴噺
*/
long countByState(Integer state);
--
Gitblit v1.8.0