| | |
| | | List<ActivityPlayer> findByState(Integer state); |
| | | |
| | | /** |
| | | * 查找活动的参赛选手数量 |
| | | * 根据活动ID统计参赛选手数量(包括未审核和审核通过的,排除审核驳回的) |
| | | */ |
| | | @Query("SELECT COUNT(ap) FROM ActivityPlayer ap WHERE ap.activityId = :activityId AND ap.state = 1") |
| | | @Query("SELECT COUNT(ap) FROM ActivityPlayer ap WHERE ap.activityId = :activityId AND ap.state IN (0, 1)") |
| | | Long countByActivityId(@Param("activityId") Long activityId); |
| | | |
| | | /** |
| | |
| | | Long countByStageIdAndState(Long stageId, Integer state); |
| | | |
| | | /** |
| | | * 根据活动ID和状态统计参赛选手数量 |
| | | */ |
| | | @Query("SELECT COUNT(ap) FROM ActivityPlayer ap WHERE ap.activityId = :activityId AND ap.state = :state") |
| | | Long countByActivityIdAndState(@Param("activityId") Long activityId, @Param("state") Integer state); |
| | | |
| | | /** |
| | | * 根据阶段ID和状态查找参赛选手(包含选手信息) |
| | | */ |
| | | @Query("SELECT ap FROM ActivityPlayer ap " + |