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