完成教师端，页面顶部展示

luohairen

2024-11-08 d28ba0adc6fcec6780c4ee500077aa46dd336957

完成教师端，页面顶部展示

 src/main/java/com/ycl/jxkg/controller/admin/ExamPaperScoreController.java

@@ -71,4 +71,9 @@
        return Result.ok(examPaperScoreVO);
    }

    @PostMapping("/queryMaxAndMinScore/{id}")
    public Result queryMaxAndMinScore(@PathVariable Integer id) {
        return examPaperScoreService.queryMaxAndMinScore(id);
    }

}

 src/main/java/com/ycl/jxkg/service/ExamPaperScoreService.java

@@ -2,6 +2,7 @@

import com.baomidou.mybatisplus.extension.service.IService;
import com.github.pagehelper.PageInfo;
import com.ycl.jxkg.base.Result;
import com.ycl.jxkg.domain.ExamPaperAnswerInfo;
import com.ycl.jxkg.domain.entity.ExamPaperScore;
import com.ycl.jxkg.domain.entity.User;
@@ -77,4 +78,11 @@
     * @return 数据
     */
    PageInfo<UserAnswerPageResponseVO> pageUser(UserAnswerPageRequestVO model);

    /**
     * 最高最低分
     * @param id 查询条件
     * @return
     */
    Result queryMaxAndMinScore(Integer id);
}

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

@@ -1,8 +1,10 @@
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;
@@ -29,6 +31,7 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.stream.Collectors;
@@ -292,4 +295,22 @@
        return PageHelper.startPage(model.getPageIndex(), model.getPageSize()).doSelectPageInfo(() ->
                examPaperScoreMapper.pageUser(model));
    }

    @Override
    public Result queryMaxAndMinScore(Integer id) {
        List<ExamPaperScore> list = new ArrayList<>();
        ExamPaperScore max = examPaperScoreMapper.selectOne(new LambdaQueryWrapper<>(ExamPaperScore.class)
                .eq(ExamPaperScore::getExamId, id)
                .orderByDesc(ExamPaperScore::getTotalScore)
                .last("limit 1"));
        list.add(max);
        if (null != max) {
            ExamPaperScore min = examPaperScoreMapper.selectOne(new LambdaQueryWrapper<>(ExamPaperScore.class)
                    .eq(ExamPaperScore::getExamId, id)
                    .orderByAsc(ExamPaperScore::getTotalScore)
                    .last("limit 1"));
            list.add(min);
        }
        return Result.ok(list);
    }
}

 src/main/resources/mapper/ExamPaperScoreMapper.xml

@@ -149,6 +149,9 @@
            <if test="examName != null and examName != ''">
                AND INSTR(t.exam_name, #{examName})
            </if>
            <if test="examId != null and examId != ''">
                AND t.id = #{examId}
            </if>
        </where>
        GROUP BY t.id
        ORDER BY t.id DESC