班级成绩图表分析

luohairen

2024-11-14 247cb86585a1d1894596ed18a6c93efecb992946

 src/main/java/com/ycl/jxkg/service/impl/ExamPaperScoreServiceImpl.java

@@ -1,16 +1,22 @@
package com.ycl.jxkg.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.ycl.jxkg.base.Result;
import com.ycl.jxkg.domain.ExamPaperAnswerInfo;
import com.ycl.jxkg.domain.entity.*;
import com.ycl.jxkg.domain.other.KeyValue;
import com.ycl.jxkg.domain.vo.admin.exam.ClassExamScoreInfoVO;
import com.ycl.jxkg.domain.vo.admin.exam.ExamPaperInfoVO;
import com.ycl.jxkg.domain.vo.admin.paper.ExamPaperAnswerPageRequestVO;
import com.ycl.jxkg.domain.vo.admin.paper.UserAnswerPageRequestVO;
import com.ycl.jxkg.domain.vo.student.exam.ExamPaperSubmitItemVO;
import com.ycl.jxkg.domain.vo.student.exam.ExamPaperSubmitVO;
import com.ycl.jxkg.domain.vo.student.exampaper.ExamPaperAnswerPageResponseVO;
import com.ycl.jxkg.domain.vo.student.exampaper.ExamPaperAnswerPageVO;
import com.ycl.jxkg.domain.vo.student.exampaper.UserAnswerPageResponseVO;
import com.ycl.jxkg.enums.ExamPaperTypeEnum;
import com.ycl.jxkg.enums.QuestionTypeEnum;
import com.ycl.jxkg.mapper.ExamPaperMapper;
@@ -27,6 +33,8 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.stream.Collectors;
@@ -284,4 +292,49 @@
        return PageHelper.startPage(model.getPageIndex(), model.getPageSize()).doSelectPageInfo(() ->
                examPaperScoreMapper.pageExamPaper(model));
    }

    @Override
    public PageInfo<UserAnswerPageResponseVO> pageUser(UserAnswerPageRequestVO model) {
        return PageHelper.startPage(model.getPageIndex(), model.getPageSize()).doSelectPageInfo(() ->
                examPaperScoreMapper.pageUser(model));
    }



    @Override
    public Result<ExamPaperInfoVO> getExamPaperInfo(Integer id) {
        ExamPaperInfoVO result = new ExamPaperInfoVO();
        // 查询考试信息
        ExamPaperAnswerPageRequestVO model = new ExamPaperAnswerPageRequestVO();
        model.setExamId(id);
        // 最高分、最低分
        ExamPaperScore max = examPaperScoreMapper.selectOne(new LambdaQueryWrapper<>(ExamPaperScore.class)
                .eq(ExamPaperScore::getExamId, id)
                .orderByDesc(ExamPaperScore::getTotalScore)
                .last("limit 1"));
        if (null != max) {
            result.setHighestScore(max.getTotalScore());
            ExamPaperScore min = examPaperScoreMapper.selectOne(new LambdaQueryWrapper<>(ExamPaperScore.class)
                    .eq(ExamPaperScore::getExamId, id)
                    .orderByAsc(ExamPaperScore::getTotalScore)
                    .last("limit 1"));
            // 判断max和min是否为同一条数据
            if (null != min && !max.getId().equals(min.getId())) {
                result.setLowestScore(min.getTotalScore());
            }else {
                result.setLowestScore(BigDecimal.valueOf(0));
            }
        }else {
            result.setHighestScore(BigDecimal.valueOf(0));
            result.setLowestScore(BigDecimal.valueOf(0));
        }
        // 查询班级学员名称及考试成绩
        List<ClassExamScoreInfoVO> info = examPaperScoreMapper.getClassExamScoreInfo(id);
        result.setTotalUserCount(info.size());
        ClassExamScoreInfoVO classExamScoreInfoVO = info.get(0);
        result.setLackUserCount(classExamScoreInfoVO.getLackUserCount());
        result.setUserNames(info.stream().map(item -> item.getRealName()).collect(Collectors.toList()));
        result.setUserScores(info.stream().map(item -> item.getTotalScore()).collect(Collectors.toList()));
        return Result.ok(result);
    }
}