From 78b94b6a8eb94af251450a89b1f133e92423ec84 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期二, 02 七月 2024 15:19:11 +0800
Subject: [PATCH] 题目导入导出
---
src/main/java/com/mindskip/xzs/controller/admin/QuestionController.java | 191 +++++++++++++++++++++++++----------------------
1 files changed, 103 insertions(+), 88 deletions(-)
diff --git a/src/main/java/com/mindskip/xzs/controller/admin/QuestionController.java b/src/main/java/com/mindskip/xzs/controller/admin/QuestionController.java
index faa4c6c..6c0bb5c 100644
--- a/src/main/java/com/mindskip/xzs/controller/admin/QuestionController.java
+++ b/src/main/java/com/mindskip/xzs/controller/admin/QuestionController.java
@@ -30,6 +30,7 @@
import com.mindskip.xzs.viewmodel.admin.education.SubjectPageRequestVM;
import com.mindskip.xzs.viewmodel.admin.question.*;
import com.github.pagehelper.PageInfo;
+import com.mindskip.xzs.vo.QuestionExportData;
import com.mindskip.xzs.vo.QuestionExportVO;
import com.mindskip.xzs.vo.QuestionImportVO;
import org.apache.commons.lang3.StringUtils;
@@ -159,103 +160,75 @@
// 鏋勫缓妯℃澘鏍蜂緥鏁版嵁
List<QuestionImportVO> data = new ArrayList<>(4);
- QuestionImportVO questionImportVO = new QuestionImportVO();
- questionImportVO.setQuestionType("鍗曢�夐");
- questionImportVO.setDifficult(2);
- questionImportVO.setCorrect("B");
- questionImportVO.setScore(2);
- questionImportVO.setSubjectName("娴嬭瘯璇剧洰");
- questionImportVO.setAnalyze("B鏄鐨�");
- questionImportVO.setTitle("杩欐槸涓�閬撴祴璇曢鐩紝浣跨敤璇ユā鏉胯鍒犻櫎鎴栨浛鎹㈣繖閬撻");
- questionImportVO.setOptionName("A");
- questionImportVO.setOptionValue("閫夋垜");
- data.add(questionImportVO);
-
- QuestionImportVO questionImportVO1 = new QuestionImportVO();
- questionImportVO1.setOptionName("B");
- questionImportVO1.setOptionValue("閫塀");
- data.add(questionImportVO1);
-
- QuestionImportVO questionImportVO2 = new QuestionImportVO();
- questionImportVO2.setOptionName("C");
- questionImportVO2.setOptionValue("閫塁");
- data.add(questionImportVO2);
-
- QuestionImportVO questionImportVO3 = new QuestionImportVO();
- questionImportVO3.setOptionName("D");
- questionImportVO3.setOptionValue("閫塂");
- data.add(questionImportVO3);
// 鏌ュ嚭鎵�鏈夌殑璇剧洰锛坋xcel涓嬫媺鏁版嵁锛�
List<Subject> subjects = subjectMapper.allSubject(new ArrayList<>(), Boolean.TRUE);
List<String> subjectNameList = subjects.stream().map(Subject::getName).collect(Collectors.toList());
- EasyExcel.write(response.getOutputStream(), QuestionImportVO.class)
+ EasyExcel.write(response.getOutputStream(), QuestionExportData.class)
.sheet("妯℃澘")
- .registerWriteHandler(new SelectExcel(subjectNameList))
- .registerWriteHandler(new FixedMergeCellStrategy(2, 4, Arrays.asList(0, 1, 2, 5, 6, 7, 8)))
.doWrite(data);
}
- @PostMapping("/question/export")
- public void exportQuestion(@RequestBody QuestionExportVO query, HttpServletResponse response) throws IOException {
- // 鏌ヨ瀵煎嚭鏁版嵁
- List<QuestionImportVO> exportData = questionService.export(query);
- // 鏋勫缓鏁版嵁
- List<QuestionImportVO> exportList = new ArrayList<>(exportData.size() * 4);
- // 琛屽悎骞惰鍒�
- List<RowItem> mergeRowList = new ArrayList<>(exportData.size());
- int j = 2;
- for (QuestionImportVO data : exportData) {
- QuestionObject questionContent = JSON.parseObject(data.getQuestionContent(), QuestionObject.class);
-
- RowItem rowItem = new RowItem();
- rowItem.setStart(j);
- int end = j + questionContent.getQuestionItemObjects().size() - 1;
- rowItem.setEnd(end);
- mergeRowList.add(rowItem);
- j = end + 1;
- int i = 0;
- for (QuestionItemObject option : questionContent.getQuestionItemObjects()) {
- if (i == 0) {
- QuestionImportVO master = new QuestionImportVO();
- BeanUtils.copyProperties(data, master);
- if (org.springframework.util.StringUtils.hasText(data.getQuestionType())) {
- master.setQuestionType(QuestionTypeEnum.fromCode(Integer.valueOf(data.getQuestionType())).getName());
- }
- master.setOptionName(option.getPrefix());
- master.setOptionValue(option.getContent());
- master.setTitle(questionContent.getTitleContent());
- master.setAnalyze(questionContent.getAnalyze());
- master.setSubjectName(data.getSubjectList().stream().collect(Collectors.joining("銆�")));
- master.setCorrect(data.getCorrect().replaceAll(",", "銆�"));
- BigDecimal score = BigDecimal.valueOf(master.getScore());
- master.setScore(score.divide(BigDecimal.TEN).intValue());
- exportList.add(master);
- } else {
- QuestionImportVO optionItem = new QuestionImportVO();
- optionItem.setOptionName(option.getPrefix());
- optionItem.setOptionValue(option.getContent());
- exportList.add(optionItem);
- }
- i++;
- }
- }
- response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
- response.setCharacterEncoding("utf-8");
- // 杩欓噷URLEncoder.encode鍙互闃叉涓枃涔辩爜 褰撶劧鍜宔asyexcel娌℃湁鍏崇郴
- String fileName = URLEncoder.encode("棰樼洰瀵煎嚭鏁版嵁", "UTF-8").replaceAll("\\+", "%20");
- response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
-
- // 鏌ュ嚭鎵�鏈夌殑璇剧洰锛坋xcel涓嬫媺鏁版嵁锛�
- List<Subject> subjects = subjectMapper.allSubject(new ArrayList<>(), Boolean.TRUE);
- List<String> subjectNameList = subjects.stream().map(Subject::getName).collect(Collectors.toList());
- EasyExcel.write(response.getOutputStream(), QuestionImportVO.class)
- .sheet("棰樼洰瀵煎嚭鏁版嵁")
- .registerWriteHandler(new SelectExcel(subjectNameList))
- .registerWriteHandler(new DynamicMergeCellStrategy(mergeRowList, Arrays.asList(0, 1, 2, 5, 6, 7, 8)))
- .doWrite(exportList);
- }
+// @PostMapping("/question/export")
+// public void exportQuestion(@RequestBody QuestionExportVO query, HttpServletResponse response) throws IOException {
+// // 鏌ヨ瀵煎嚭鏁版嵁
+// List<QuestionImportVO> exportData = questionService.export(query);
+// // 鏋勫缓鏁版嵁
+// List<QuestionImportVO> exportList = new ArrayList<>(exportData.size() * 4);
+// // 琛屽悎骞惰鍒�
+// List<RowItem> mergeRowList = new ArrayList<>(exportData.size());
+// int j = 2;
+// for (QuestionImportVO data : exportData) {
+// QuestionObject questionContent = JSON.parseObject(data.getQuestionContent(), QuestionObject.class);
+//
+// RowItem rowItem = new RowItem();
+// rowItem.setStart(j);
+// int end = j + questionContent.getQuestionItemObjects().size() - 1;
+// rowItem.setEnd(end);
+// mergeRowList.add(rowItem);
+// j = end + 1;
+// int i = 0;
+// for (QuestionItemObject option : questionContent.getQuestionItemObjects()) {
+// if (i == 0) {
+// QuestionImportVO master = new QuestionImportVO();
+// BeanUtils.copyProperties(data, master);
+// if (org.springframework.util.StringUtils.hasText(data.getQuestionType())) {
+// master.setQuestionType(QuestionTypeEnum.fromCode(Integer.valueOf(data.getQuestionType())).getName());
+// }
+// master.setOptionName(option.getPrefix());
+// master.setOptionValue(option.getContent());
+// master.setTitle(questionContent.getTitleContent());
+// master.setAnalyze(questionContent.getAnalyze());
+// master.setSubjectName(data.getSubjectList().stream().collect(Collectors.joining("銆�")));
+// master.setCorrect(data.getCorrect().replaceAll(",", "銆�"));
+// BigDecimal score = BigDecimal.valueOf(master.getScore());
+// master.setScore(score.divide(BigDecimal.TEN).intValue());
+// exportList.add(master);
+// } else {
+// QuestionImportVO optionItem = new QuestionImportVO();
+// optionItem.setOptionName(option.getPrefix());
+// optionItem.setOptionValue(option.getContent());
+// exportList.add(optionItem);
+// }
+// i++;
+// }
+// }
+// response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+// response.setCharacterEncoding("utf-8");
+// // 杩欓噷URLEncoder.encode鍙互闃叉涓枃涔辩爜 褰撶劧鍜宔asyexcel娌℃湁鍏崇郴
+// String fileName = URLEncoder.encode("棰樼洰瀵煎嚭鏁版嵁", "UTF-8").replaceAll("\\+", "%20");
+// response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
+//
+// // 鏌ュ嚭鎵�鏈夌殑璇剧洰锛坋xcel涓嬫媺鏁版嵁锛�
+// List<Subject> subjects = subjectMapper.allSubject(new ArrayList<>(), Boolean.TRUE);
+// List<String> subjectNameList = subjects.stream().map(Subject::getName).collect(Collectors.toList());
+// EasyExcel.write(response.getOutputStream(), QuestionImportVO.class)
+// .sheet("棰樼洰瀵煎嚭鏁版嵁")
+// .registerWriteHandler(new SelectExcel(subjectNameList))
+// .registerWriteHandler(new DynamicMergeCellStrategy(mergeRowList, Arrays.asList(0, 1, 2, 5, 6, 7, 8)))
+// .doWrite(exportList);
+// }
/**
* 棰樼洰瀵煎叆
@@ -429,4 +402,46 @@
}
return RestResponse.ok();
}
+
+ @PostMapping("/question/export")
+ public void exportQuestion(@RequestBody QuestionExportVO query, HttpServletResponse response) throws IOException {
+ // 鏌ヨ瀵煎嚭鏁版嵁
+ List<QuestionExportData> exportData = questionService.exportData(query);
+ // 澶勭悊瀹屽杽鏁版嵁
+ exportData.stream().forEach(question -> {
+ if (StringUtils.isNotBlank(question.getContent())) {
+ QuestionObject questionContent = JSON.parseObject(question.getContent(), QuestionObject.class);
+ // 璁剧疆閫夐」
+ for (QuestionItemObject option : questionContent.getQuestionItemObjects()) {
+ String optionContent = option.getContent();
+ if ("A".equals(option.getPrefix())) {
+ question.setOptionA(optionContent);
+ } else if ("B".equals(option.getPrefix())) {
+ question.setOptionB(optionContent);
+ } else if ("C".equals(option.getPrefix())) {
+ question.setOptionC(optionContent);
+ } else if ("D".equals(option.getPrefix())) {
+ question.setOptionD(optionContent);
+ }
+ }
+ // 璁剧疆棰樺共銆佽В鏋�
+ question.setAnalyze(questionContent.getAnalyze());
+ question.setTitle(questionContent.getTitleContent());
+ // 璁剧疆璇剧洰
+ question.setSubject(question.getSubjectList().stream().collect(Collectors.joining(",")));
+ // 璁剧疆棰樺瀷
+ question.setQuestionType(QuestionTypeEnum.fromCode(Integer.valueOf(question.getQuestionType())).getName());
+ }
+ });
+ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setCharacterEncoding("utf-8");
+ // 杩欓噷URLEncoder.encode鍙互闃叉涓枃涔辩爜 褰撶劧鍜宔asyexcel娌℃湁鍏崇郴
+ String fileName = URLEncoder.encode("棰樼洰瀵煎嚭鏁版嵁", "UTF-8").replaceAll("\\+", "%20");
+ response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
+
+ // 鏌ュ嚭鎵�鏈夌殑璇剧洰锛坋xcel涓嬫媺鏁版嵁锛�
+ EasyExcel.write(response.getOutputStream(), QuestionExportData.class)
+ .sheet("棰樼洰瀵煎嚭鏁版嵁")
+ .doWrite(exportData);
+ }
}
--
Gitblit v1.8.0