package com.rongyichuang.activity.repository;
|
|
import com.rongyichuang.activity.entity.ActivityPlayerRatingItem;
|
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.math.BigDecimal;
|
import java.util.List;
|
|
/**
|
* 活动选手评分项数据访问层
|
*/
|
@Repository
|
public interface ActivityPlayerRatingItemRepository extends JpaRepository<ActivityPlayerRatingItem, Long> {
|
|
/**
|
* 根据活动选手评分ID查找所有评分项
|
*/
|
List<ActivityPlayerRatingItem> findByActivityPlayerRatingId(Long activityPlayerRatingId);
|
|
/**
|
* 根据评分项ID查找所有评分记录
|
*/
|
List<ActivityPlayerRatingItem> findByRatingItemId(Long ratingItemId);
|
|
/**
|
* 删除指定活动选手评分的所有评分项
|
*/
|
void deleteByActivityPlayerRatingId(Long activityPlayerRatingId);
|
|
/**
|
* 计算指定活动选手评分的总分
|
*/
|
@Query("SELECT SUM(i.score) FROM ActivityPlayerRatingItem i WHERE i.activityPlayerRatingId = :activityPlayerRatingId")
|
BigDecimal calculateTotalScoreByActivityPlayerRatingId(@Param("activityPlayerRatingId") Long activityPlayerRatingId);
|
|
/**
|
* 根据活动选手评分ID和评分项ID查找评分项
|
*/
|
@Query("SELECT i FROM ActivityPlayerRatingItem i WHERE i.activityPlayerRatingId = :activityPlayerRatingId AND i.ratingItemId = :ratingItemId")
|
ActivityPlayerRatingItem findByActivityPlayerRatingIdAndRatingItemId(@Param("activityPlayerRatingId") Long activityPlayerRatingId,
|
@Param("ratingItemId") Long ratingItemId);
|
|
/**
|
* 批量查询多个活动选手评分的评分项
|
*/
|
@Query("SELECT i FROM ActivityPlayerRatingItem i WHERE i.activityPlayerRatingId IN :activityPlayerRatingIds ORDER BY i.activityPlayerRatingId, i.ratingItemId")
|
List<ActivityPlayerRatingItem> findByActivityPlayerRatingIdIn(@Param("activityPlayerRatingIds") List<Long> activityPlayerRatingIds);
|
}
|
