| | |
| | | List<ActivityPlayer> findByPlayerId(Long playerId); |
| | | |
| | | /** |
| | | * 根据活动ID和选手ID查找参赛记录 |
| | | * 根据活动ID和选手ID查找参赛记录列表,按创建时间降序排序 |
| | | */ |
| | | Optional<ActivityPlayer> findByActivityIdAndPlayerId(Long activityId, Long playerId); |
| | | List<ActivityPlayer> findByActivityIdAndPlayerIdOrderByCreateTimeDesc(Long activityId, Long playerId); |
| | | |
| | | /** |
| | | * 根据阶段ID查找参赛选手 |
| | |
| | | Long countByActivityIdAndState(@Param("activityId") Long activityId, @Param("state") Integer state); |
| | | |
| | | /** |
| | | * 统计同一活动+同一选手的有效报名数量(state IN (0,1)) |
| | | */ |
| | | @Query("SELECT COUNT(ap) FROM ActivityPlayer ap WHERE ap.activityId = :activityId AND ap.playerId = :playerId AND ap.state IN (0, 1)") |
| | | Long countActiveOrPendingByActivityAndPlayer(@Param("activityId") Long activityId, @Param("playerId") Long playerId); |
| | | |
| | | /** |
| | | * 根据阶段ID和状态查找参赛选手(包含选手信息) |
| | | */ |
| | | @Query("SELECT ap FROM ActivityPlayer ap " + |