package com.rongyichuang.activity.repository;

import com.rongyichuang.activity.entity.ActivityPlayerRating;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Optional;

/**
 * 活动选手评分数据访问层
 */
@Repository
public interface ActivityPlayerRatingRepository extends JpaRepository<ActivityPlayerRating, Long> {

    /**
     * 根据活动选手ID和评委ID查找评分记录
     */
    Optional<ActivityPlayerRating> findByActivityPlayerIdAndJudgeId(Long activityPlayerId, Long judgeId);

    /**
     * 根据活动选手ID查找所有评分记录
     */
    List<ActivityPlayerRating> findByActivityPlayerId(Long activityPlayerId);

    /**
     * 根据活动ID查找所有评分记录
     */
    List<ActivityPlayerRating> findByActivityId(Long activityId);

    /**
     * 根据评委ID查找所有评分记录
     */
    List<ActivityPlayerRating> findByJudgeId(Long judgeId);

    /**
     * 根据选手ID查找所有评分记录
     */
    List<ActivityPlayerRating> findByPlayerId(Long playerId);

    /**
     * 检查指定评委是否已对指定选手评分
     */
    boolean existsByActivityPlayerIdAndJudgeId(Long activityPlayerId, Long judgeId);

    /**
     * 统计指定活动选手的评分数量
     */
    @Query("SELECT COUNT(r) FROM ActivityPlayerRating r WHERE r.activityPlayerId = :activityPlayerId AND r.status = 1")
    long countCompletedRatingsByActivityPlayerId(@Param("activityPlayerId") Long activityPlayerId);

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

    /**
     * 根据活动ID和评委ID查找评分记录
     */
    List<ActivityPlayerRating> findByActivityIdAndJudgeId(Long activityId, Long judgeId);

    /**
     * 删除指定活动选手的指定评委评分记录
     */
    void deleteByActivityPlayerIdAndJudgeId(Long activityPlayerId, Long judgeId);
}