backend/src/main/java/com/rongyichuang/player/repository/ActivityPlayerRepository.java
@@ -88,4 +88,9 @@ "WHERE ap.activityId = :activityId AND ap.state = 1 AND ap.rank IS NOT NULL " + "ORDER BY ap.rank ASC") List<ActivityPlayer> findTopRankedPlayers(@Param("activityId") Long activityId); /** * 根据状态统计报名数量 */ long countByState(Integer state); }