From c4938f6f4e839890b032c75c7a57333a6a9157a9 Mon Sep 17 00:00:00 2001
From: peng <peng.com>
Date: 星期四, 06 十一月 2025 17:06:10 +0800
Subject: [PATCH] 添加新闻功能
---
backend/src/main/java/com/rongyichuang/player/repository/ActivityPlayerRepository.java | 6 ++++++
1 files changed, 6 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 419dcbe..dec8c64 100644
--- a/backend/src/main/java/com/rongyichuang/player/repository/ActivityPlayerRepository.java
+++ b/backend/src/main/java/com/rongyichuang/player/repository/ActivityPlayerRepository.java
@@ -127,6 +127,12 @@
Long countByStageIdAndState(Long stageId, Integer state);
/**
+ * 鏍规嵁闃舵ID缁熻鍙傝禌閫夋墜鏁伴噺锛堝寘鎷湭瀹℃牳鍜屽鏍搁�氳繃鐨勶紝鎺掗櫎瀹℃牳椹冲洖鐨勶級
+ */
+ @Query("SELECT COUNT(ap) FROM ActivityPlayer ap WHERE ap.stageId = :stageId AND ap.state IN (0, 1)")
+ Long countByStageId(@Param("stageId") Long stageId);
+
+ /**
* 鏍规嵁娲诲姩ID鍜岀姸鎬佺粺璁″弬璧涢�夋墜鏁伴噺
*/
@Query("SELECT COUNT(ap) FROM ActivityPlayer ap WHERE ap.activityId = :activityId AND ap.state = :state")
--
Gitblit v1.8.0