| | |
|---|
| | | @RequestMapping(value = "/export", method = RequestMethod.GET) |
|---|
| | | public void export(Integer id, Integer type, HttpServletResponse response) { |
|---|
| | | |
|---|
| | | |
|---|
| | | try (ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).build()) { |
|---|
| | | // 部门考试统计sheet |
|---|
| | | List<ExamPaperDataExportVO> list = examPaperAnswerService.dataExport(new ExamPaperDataVO().setId(id).setType(type)); |
|---|
| | |
|---|
| | | excelWriter.write(list, writeSheet); |
|---|
| | | |
|---|
| | | // 考试详情sheet，一个单位一个sheet |
|---|
| | | List<PaperExcelVO> paperDetailList = examPaperService.getPaperExcelById(id); |
|---|
| | | List<PaperExcelVO> paperDetailList = examPaperService.getRandomPaperExcelById(id); |
|---|
| | | List<Integer> deptIds = paperDetailList.stream().map(PaperExcelVO::getDeptId).collect(Collectors.toList()); |
|---|
| | | Map<Integer, List<Department>> deptMap = departmentService.gets(deptIds).stream().collect(Collectors.groupingBy(Department::getId)); |
|---|
| | | Map<Integer, List<PaperExcelVO>> deptDataMap = paperDetailList.stream().collect(Collectors.groupingBy(PaperExcelVO::getDeptId)); |
|---|
