| | |
| | | /** |
| | | * 统计指定活动选手的评分数量 |
| | | */ |
| | | @Query("SELECT COUNT(r) FROM ActivityPlayerRating r WHERE r.activityPlayerId = :activityPlayerId AND r.status = 1") |
| | | @Query("SELECT COUNT(r) FROM ActivityPlayerRating r WHERE r.activityPlayerId = :activityPlayerId AND r.state = 1") |
| | | long countCompletedRatingsByActivityPlayerId(@Param("activityPlayerId") Long activityPlayerId); |
| | | |
| | | /** |
| | | * 获取指定活动选手的所有已完成评分 |
| | | */ |
| | | @Query("SELECT r FROM ActivityPlayerRating r WHERE r.activityPlayerId = :activityPlayerId AND r.status = 1") |
| | | @Query("SELECT r FROM ActivityPlayerRating r WHERE r.activityPlayerId = :activityPlayerId AND r.state = 1") |
| | | List<ActivityPlayerRating> findCompletedRatingsByActivityPlayerId(@Param("activityPlayerId") Long activityPlayerId); |
| | | |
| | | /** |