From 4fa9591629721797386fc11836e3a9deb69cd58c Mon Sep 17 00:00:00 2001
From: lrj <owen.stl@gmail.com>
Date: 星期三, 24 九月 2025 17:00:37 +0800
Subject: [PATCH] 修改评分逻辑，支持多个评委
---
backend/src/main/java/com/rongyichuang/player/service/ActivityPlayerDetailService.java | 17 ++++++++++-------
1 files changed, 10 insertions(+), 7 deletions(-)
diff --git a/backend/src/main/java/com/rongyichuang/player/service/ActivityPlayerDetailService.java b/backend/src/main/java/com/rongyichuang/player/service/ActivityPlayerDetailService.java
index 64f970c..00413de 100644
--- a/backend/src/main/java/com/rongyichuang/player/service/ActivityPlayerDetailService.java
+++ b/backend/src/main/java/com/rongyichuang/player/service/ActivityPlayerDetailService.java
@@ -5,6 +5,7 @@
import com.rongyichuang.rating.entity.RatingScheme;
import com.rongyichuang.rating.repository.RatingSchemeRepository;
import com.rongyichuang.common.entity.Media;
+import com.rongyichuang.common.enums.MediaTargetType;
import com.rongyichuang.common.repository.MediaRepository;
import jakarta.persistence.EntityManager;
import jakarta.persistence.PersistenceContext;
@@ -49,7 +50,7 @@
SELECT ap.id, ap.description, ap.activity_id,
p.id as player_id, p.name as player_name, p.phone, p.description as player_desc,
a.name as activity_name, a.rating_scheme_id
- FROM t_avtivity_player ap
+ FROM t_activity_player ap
JOIN t_player p ON p.id = ap.player_id
JOIN t_activity a ON a.id = ap.activity_id
WHERE ap.id = ?
@@ -73,14 +74,15 @@
// 鏋勫缓瀛﹀憳淇℃伅
PlayerInfoResponse playerInfo = new PlayerInfoResponse();
- playerInfo.setId(row[3] != null ? Long.valueOf(row[3].toString()) : null);
+ playerInfo.setId(row[3] != null ? ((Number) row[3]).longValue() : null);
playerInfo.setName(row[4] != null ? row[4].toString() : "");
playerInfo.setPhone(row[5] != null ? row[5].toString() : "");
playerInfo.setDescription(row[6] != null ? row[6].toString() : "");
- // 鏌ヨ瀛﹀憳澶村儚锛坱arget_type=5锛�
+ // 鏌ヨ瀛﹀憳澶村儚锛堜娇鐢ㄦ灇涓惧父閲忚〃绀哄鍛樺ご鍍忕被鍨嬶級
if (playerInfo.getId() != null) {
- List<Media> avatarMedias = mediaRepository.findByTargetTypeAndTargetIdAndState(5, playerInfo.getId(), 1);
+ List<Media> avatarMedias = mediaRepository.findByTargetTypeAndTargetIdAndState(
+ MediaTargetType.STUDENT_AVATAR.getValue(), playerInfo.getId(), 1);
if (!avatarMedias.isEmpty()) {
Media avatar = avatarMedias.get(0);
String avatarUrl = avatar.getPath();
@@ -90,8 +92,9 @@
}
response.setPlayerInfo(playerInfo);
- // 鏌ヨ鎻愪氦鐨勮祫鏂欙紙target_type=4锛�
- List<Media> submissionMedias = mediaRepository.findByTargetTypeAndTargetIdAndState(4, activityPlayerId, 1);
+ // 鏌ヨ鎻愪氦鐨勮祫鏂欙紙浣跨敤鏋氫妇甯搁噺琛ㄧず鍙傝禌鎶ュ悕璧勬枡绫诲瀷锛�
+ List<Media> submissionMedias = mediaRepository.findByTargetTypeAndTargetIdAndState(
+ MediaTargetType.ACTIVITY_PLAYER_SUBMISSION.getValue(), activityPlayerId, 1);
List<SubmissionMediaResponse> submissionFiles = submissionMedias.stream()
.map(this::convertToSubmissionMedia)
.collect(Collectors.toList());
@@ -99,7 +102,7 @@
log.info("鎵惧埌鎻愪氦璧勬枡 {} 涓�", submissionFiles.size());
// 鏌ヨ璇勫垎妯℃澘
- Long ratingSchemeId = row[8] != null ? Long.valueOf(row[8].toString()) : null;
+ Long ratingSchemeId = row[8] != null ? ((Number) row[8]).longValue() : null;
if (ratingSchemeId != null) {
RatingFormResponse ratingForm = buildRatingForm(ratingSchemeId);
response.setRatingForm(ratingForm);
--
Gitblit v1.8.0