feat: 修复员工管理功能并优化UI

lrj

2 天以前 7ad9c3c93f0cc103347ae2e2429e0122fb512e24

 backend/src/main/java/com/rongyichuang/player/service/ActivityPlayerRatingService.java

@@ -259,20 +259,25 @@
            Long judgeId = ((Number) row.get("id")).longValue();
            String judgeName = (String) row.get("name");
            
            // 查找该评委的评分
            Optional<ActivityPlayerRating> ratingOpt = activityPlayerRatingRepository
                    .findByActivityPlayerIdAndJudgeId(activityPlayerId, judgeId);
            // 查找该评委的评分记录数量（从t_activity_player_rating表按activity_player_id和judge_id查询）
            String ratingCountSql = "SELECT COUNT(*) FROM t_activity_player_rating WHERE activity_player_id = ? AND judge_id = ?";
            Integer ratingCount = jdbcTemplate.queryForObject(ratingCountSql, Integer.class, activityPlayerId, judgeId);
            
            Boolean hasRated = false;
            Boolean hasRated = ratingCount != null && ratingCount > 0; // 评审次数>0表示已评审
            String ratingTime = null;
            BigDecimal totalScore = null;
            
            if (ratingOpt.isPresent()) {
                ActivityPlayerRating rating = ratingOpt.get();
                hasRated = rating.getState() != null && rating.getState() == 1; // 使用state判断是否已评分
                totalScore = rating.getTotalScore();
                if (rating.getUpdateTime() != null) {
                    ratingTime = rating.getUpdateTime().toString();
            // 如果已评分，获取最新的评分记录
            if (hasRated) {
                Optional<ActivityPlayerRating> ratingOpt = activityPlayerRatingRepository
                        .findByActivityPlayerIdAndJudgeId(activityPlayerId, judgeId);
                
                if (ratingOpt.isPresent()) {
                    ActivityPlayerRating rating = ratingOpt.get();
                    totalScore = rating.getTotalScore();
                    if (rating.getUpdateTime() != null) {
                        ratingTime = rating.getUpdateTime().toString();
                    }
                }
            }