From 69f8a6959595299ec18a33ba4247676b1370c2db Mon Sep 17 00:00:00 2001 From: xiangpei <xiangpei@timesnew.cn> Date: 星期五, 15 三月 2024 16:39:40 +0800 Subject: [PATCH] 注释 --- src/main/java/com/mindskip/xzs/controller/admin/ExamTemplatesUserCountController.java | 12 ++++++++---- src/main/resources/mapper/ExamPaperAnswerMapper.xml | 2 +- 2 files changed, 9 insertions(+), 5 deletions(-) diff --git a/src/main/java/com/mindskip/xzs/controller/admin/ExamTemplatesUserCountController.java b/src/main/java/com/mindskip/xzs/controller/admin/ExamTemplatesUserCountController.java index 90bd8b9..ae8c8a3 100644 --- a/src/main/java/com/mindskip/xzs/controller/admin/ExamTemplatesUserCountController.java +++ b/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()); + // 鑾峰彇鍙傝�冪敤鎴稩D 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); } diff --git a/src/main/resources/mapper/ExamPaperAnswerMapper.xml b/src/main/resources/mapper/ExamPaperAnswerMapper.xml index 7d06dce..2e9cba5 100644 --- a/src/main/resources/mapper/ExamPaperAnswerMapper.xml +++ b/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> -- Gitblit v1.8.0