From 4002dcb5e86b8cfb319a820b6a9d1a8fdf85d8d8 Mon Sep 17 00:00:00 2001 From: 龚焕茏 <2842157468@qq.com> Date: 星期五, 24 五月 2024 15:18:17 +0800 Subject: [PATCH] feat:分数统计新增导出 --- src/main/java/com/mindskip/xzs/service/impl/ExamPaperAnswerServiceImpl.java | 75 ++++++++++++++++++++++++++++++++++--- 1 files changed, 68 insertions(+), 7 deletions(-) diff --git a/src/main/java/com/mindskip/xzs/service/impl/ExamPaperAnswerServiceImpl.java b/src/main/java/com/mindskip/xzs/service/impl/ExamPaperAnswerServiceImpl.java index 5319359..cc3f478 100644 --- a/src/main/java/com/mindskip/xzs/service/impl/ExamPaperAnswerServiceImpl.java +++ b/src/main/java/com/mindskip/xzs/service/impl/ExamPaperAnswerServiceImpl.java @@ -10,6 +10,9 @@ import com.mindskip.xzs.domain.other.ExamPaperAnswerUpdate; import com.mindskip.xzs.domain.other.KeyValue; import com.mindskip.xzs.domain.task.TaskItemAnswerObject; +import com.mindskip.xzs.domain.vo.ExamPaperDataExportVO; +import com.mindskip.xzs.domain.vo.ExamPaperDataVO; +import com.mindskip.xzs.domain.vo.ExamPaperStatisticVO; import com.mindskip.xzs.repository.ExamPaperAnswerMapper; import com.mindskip.xzs.repository.ExamPaperMapper; import com.mindskip.xzs.repository.QuestionMapper; @@ -160,8 +163,8 @@ } @Override - public Integer selectAllCount() { - return examPaperAnswerMapper.selectAllCount(); + public Integer selectAllCount(List<Integer> deptIds) { + return examPaperAnswerMapper.selectAllCount(deptIds); } @Override @@ -312,12 +315,70 @@ } @Override - public Map<String, Object> statistic(String examPaperId, String departmentId) { + public Map<String, Object> statistic(ExamPaperStatisticVO examPaperStatisticVO) { + // 鑾峰彇鍘熷鏁版嵁 + Map<String, Object> histogram = examPaperAnswerMapper.histogram(examPaperStatisticVO); + Map<String, Object> pieChart = examPaperAnswerMapper.pieChart(examPaperStatisticVO); + // 鍒濆鍖栫粨鏋滃鍣� HashMap<String, Object> map = new HashMap<>(); - Map<String, Object> histogram = examPaperAnswerMapper.histogram(examPaperId, departmentId); - Map<String, Object> pieChart = examPaperAnswerMapper.pieChart(examPaperId, departmentId); - map.put("histogram", histogram); - map.put("pieChart", pieChart); + List<Map<String, Object>> score = new ArrayList<>(); + List<Map<String, Object>> age = new ArrayList<>(); + List<Map<String, Object>> examPeopleNum = new ArrayList<>(); + // 澶勭悊鎴愮哗涓庡勾榫勫垎甯� + histogram.forEach((k, v) -> { + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put(k, v); + if (k.contains("score")) { + score.add(hashMap); + } + if (k.contains("age")) { + age.add(hashMap); + } + }); + // 澶勭悊鍙傝�冧汉鏁帮紙鍑哄腑涓庣己甯級 + pieChart.forEach((k, v) -> { + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put(k, v); + if ("totalAttended".equals(k)) { + examPeopleNum.add(hashMap); + } + if ("totalAbsent".equals(k)) { + examPeopleNum.add(hashMap); + } + }); + map.put("score", score); + map.put("age", age); + map.put("examPeopleNum", examPeopleNum); return map; } + + @Override + public Map<String, Object> data(ExamPaperDataVO examPaperDataVO) { + Map<String, Object> map = new HashMap<>(); + // 闅忔満璇曞嵎 + if (Objects.equals(examPaperDataVO.getType(), 7)) { + map.put("data", examPaperAnswerMapper.dataByTemplate(examPaperDataVO)); + map.put("total", examPaperAnswerMapper.totalByTemplate(examPaperDataVO)); + } else { + map.put("data", examPaperAnswerMapper.dataByPaper(examPaperDataVO)); + map.put("total", examPaperAnswerMapper.totalByPaper(examPaperDataVO)); + } + return map; + } + + @Override + public List<ExamPaperDataExportVO> dataExport(ExamPaperDataVO examPaperDataVO) { + // 闅忔満璇曞嵎 + if (Objects.equals(examPaperDataVO.getType(), 7)) { + List<ExamPaperDataExportVO > dataByTemplate = examPaperAnswerMapper.dataByTemplate(examPaperDataVO); + ExamPaperDataExportVO totalByTemplate = examPaperAnswerMapper.totalByTemplate(examPaperDataVO); + dataByTemplate.add(0, totalByTemplate.setName("鎵�鏈夐儴闂�")); + return dataByTemplate; + } else { + List<ExamPaperDataExportVO > dataByPaper = examPaperAnswerMapper.dataByPaper(examPaperDataVO); + ExamPaperDataExportVO totalByPaper = examPaperAnswerMapper.totalByPaper(examPaperDataVO); + dataByPaper.add(0, totalByPaper.setName("鎵�鏈夐儴闂�")); + return dataByPaper; + } + } } -- Gitblit v1.8.0