注释

xiangpei

2024-03-15 69f8a6959595299ec18a33ba4247676b1370c2db

注释

 src/main/java/com/mindskip/xzs/controller/admin/ExamTemplatesUserCountController.java

@@ -129,14 +129,20 @@
    @RequestMapping(value = "/exportRandownTemplatesId/{id}", method = RequestMethod.GET)
    @SneakyThrows
    public void exportRandownTemplatesId(@PathVariable("id") Integer id, HttpServletResponse response, HttpServletRequest request) {
        // 查出试卷模板
        ExamTemplates byId = examTemplatesMapper.getById(id);
        // 查出该模板的参考人数据
        List<ExamTemplatesUser> byId1 = examTemplatesUserMapper.getById(id);

        // 查出这张试卷的参考记录
        List<ExamTemplatesUserCount> byTemplates = examTemplatesUserCountService.getByTemplates(id);
        // 获取每个人的试卷ID
        List<Integer> list = byTemplates.stream().map(ExamTemplatesUserCount::getExamPaperId).collect(Collectors.toList());
        // 获取参考用户ID
        List<Integer> userIds = byId1.stream().map(e->Integer.parseInt(e.getUserId())).collect(Collectors.toList());
        //考试
        // 答卷
        List<ExamPaperAnswer> result = new ArrayList<>();

        // 获取考试答卷
        if(list.size()!=0){
            result = examPaperAnswerMapper.getResult(list);
        }
@@ -167,8 +173,6 @@
            str = false;

        }


        ExcelUtils.export(response,"个人练习",list1, TeamplatesUserExcelVO.class);
    }


 src/main/resources/mapper/ExamPaperAnswerMapper.xml

@@ -383,7 +383,7 @@
    select a.paper_name as name, u.real_name as userName,SUBSTRING_INDEX(a.user_score/10,".",1) as userScore,
           SUBSTRING_INDEX(a.paper_score/10,".",1) as paperScore,a.do_time as doTime from t_exam_paper_answer a
    left join t_user u on a.create_user = u.id
    where a.create_time between '2023-11-28 09:00:00' and '2023-12-01 10:00:00'
    where a.create_time
  </select>

</mapper>