ExportCompositionService.java 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308
  1. package com.njuzr.eaibackend.service;
  2. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  3. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  4. import com.njuzr.eaibackend.exception.MyException;
  5. import com.njuzr.eaibackend.mapper.EngagementMapper;
  6. import com.njuzr.eaibackend.mapper.serviceIpml.EngagementMapperServiceImpl;
  7. import com.njuzr.eaibackend.po.Engagement;
  8. import com.njuzr.eaibackend.po.User;
  9. import com.njuzr.eaibackend.po.Assignment;
  10. import com.njuzr.eaibackend.utils.WordExporter;
  11. import com.njuzr.eaibackend.utils.ZipExport;
  12. import com.njuzr.eaibackend.vo.AssignmentVO;
  13. import com.njuzr.eaibackend.vo.EngagementVO;
  14. import com.njuzr.eaibackend.vo.UserVO;
  15. import com.njuzr.eaibackend.vo.StudentInfoVO;
  16. import com.njuzr.eaibackend.vo.EngagementHistoryVO;
  17. import freemarker.template.Configuration;
  18. import freemarker.template.TemplateException;
  19. import lombok.extern.slf4j.Slf4j;
  20. import org.apache.commons.lang3.tuple.Pair;
  21. import org.springframework.beans.factory.annotation.Autowired;
  22. import org.springframework.http.HttpStatus;
  23. import org.springframework.stereotype.Service;
  24. import org.springframework.util.CollectionUtils;
  25. import java.io.IOException;
  26. import java.util.*;
  27. import java.util.stream.Collectors;
  28. @Slf4j
  29. @Service
  30. public class ExportCompositionService {
  31. @Autowired
  32. private Configuration freemarkerConfig;
  33. @Autowired
  34. private EngagementMapper engagementMapper;
  35. @Autowired
  36. private AssignmentService assignmentService;
  37. @Autowired
  38. private UserService userService;
  39. @Autowired
  40. private WordExporter wordExporter;
  41. @Autowired
  42. private EngagementMapperServiceImpl engagementMapperServiceImpl;
  43. @Autowired
  44. private com.njuzr.eaibackend.mapper.UserMapper userMapper;
  45. @Autowired
  46. private com.njuzr.eaibackend.mapper.AssignmentMapper assignmentMapper;
  47. public Pair<UserVO, byte[]> exportWord(Long assignmentId, Long studentId) {
  48. AssignmentVO assignment = assignmentService.findAssignmentById(assignmentId);
  49. EngagementVO engagement = assignmentService.getEngagement(studentId, assignmentId);
  50. UserVO user = userService.searchUsers(new Page<>(1,1), studentId, null, null, null).getRecords().get(0);
  51. Map<String, Object> model = buildWordInfoModel(assignment, user, engagement);
  52. return Pair.of(user, wordExporter.exportCompositionWord(model));
  53. }
  54. private Map<String, Object> buildWordInfoModel(AssignmentVO assignment, UserVO user, EngagementVO engagement) {
  55. Map<String, Object> model = new HashMap<>();
  56. model.put("title", assignment.getAssignmentName());
  57. model.put("studentName", user.getName());
  58. model.put("officialNumber", user.getOfficialNumber());
  59. model.put("assignmentName", assignment.getAssignmentName());
  60. model.put("date", new Date());
  61. model.put("content", processContent(engagement.getTextContent()));
  62. return model;
  63. }
  64. public byte[] exportBatchToZip(List<Long> studentIds, Long assignmentId) {
  65. if(assignmentId == null){
  66. throw MyException.create(HttpStatus.BAD_REQUEST, "assignmentId不能为空");
  67. }
  68. if (CollectionUtils.isEmpty(studentIds)) {
  69. List<Engagement> engagements = engagementMapperServiceImpl.getEngagementByAssignmentId(assignmentId);
  70. if (CollectionUtils.isEmpty(engagements)) {
  71. return null;
  72. }
  73. studentIds = engagements.stream()
  74. .map(Engagement::getStudentId)
  75. .toList();
  76. }
  77. return exportBatchToZipByStudentIds(studentIds, assignmentId);
  78. }
  79. private byte[] exportBatchToZipByStudentIds(List<Long> studentIds, Long assignmentId) {
  80. List<ZipExport.ZipItem> zipItems = studentIds.stream()
  81. .map(studentId -> {
  82. try {
  83. Pair<UserVO, byte[]> pair = exportWord(assignmentId, studentId);
  84. UserVO student = pair.getLeft();
  85. byte[] wordBytes = pair.getRight();
  86. String fileName = String.format("%s_%s.%s", student.getName(), student.getOfficialNumber(), "docx");
  87. return new ZipExport.ZipItem(fileName, wordBytes);
  88. } catch (Exception e) {
  89. log.error("exportBatchToZip failed, studentId: {}, reason: {}", studentId, e.getMessage());
  90. return null;
  91. }
  92. })
  93. .filter(Objects::nonNull)
  94. .collect(Collectors.toList());
  95. try {
  96. return ZipExport.packToZip(zipItems);
  97. } catch (IOException e) {
  98. throw MyException.create(HttpStatus.INTERNAL_SERVER_ERROR, "ZIP打包失败"+e.getMessage());
  99. }
  100. }
  101. public byte[] exportWordTest(Long assignmentId, Long studentId) throws IOException, TemplateException {
  102. String assignmentName = "My Favorite Season";
  103. String content = "My favorite season is autumn. The weather is cool and comfortable, and the leaves turn golden, making the scenery beautiful. I enjoy walking in the park and listening to the sound of rustling leaves. Autumn is also a harvest season, with fruits like apples and pears ripe for picking.\n" +
  104. "During this season, my family often goes hiking or has picnics. The Mid-Autumn Festival, when we eat mooncakes and admire the full moon, is my favorite holiday. Autumn reminds me of warmth and joy.\n" +
  105. "In short, autumn is not only pleasant but also full of happy memories. That’s why I love it most.";
  106. Map<String, Object> model = new HashMap<>();
  107. model.put("title", "title_"+assignmentName);
  108. model.put("studentName", "柏琪");
  109. model.put("assignmentName", assignmentName);
  110. model.put("date", new Date());
  111. model.put("content", content.replaceAll("\n", "<br/>"));
  112. return wordExporter.exportCompositionWord(model);
  113. }
  114. private String processContent(String content) {
  115. return content.replaceAll("\n", "<br/>");
  116. }
  117. public byte[] downloadClassAssignments(Long classId) {
  118. // 获取班级信息
  119. com.njuzr.eaibackend.po.Class cls = classService.getClassById(classId);
  120. if (cls == null) {
  121. throw MyException.create(HttpStatus.BAD_REQUEST, "班级不存在");
  122. }
  123. // 获取班级所有学生
  124. List<StudentInfoVO> students = classService.getStudentsByClassId(classId);
  125. if (students.isEmpty()) {
  126. throw MyException.create(HttpStatus.BAD_REQUEST, "班级无学生");
  127. }
  128. // 获取班级对应的课程ID
  129. Long courseId = cls.getCourseId();
  130. if (courseId == null) {
  131. throw MyException.create(HttpStatus.BAD_REQUEST, "班级未关联课程");
  132. }
  133. // 获取课程的所有作业
  134. List<Assignment> courseAssignments = assignmentMapper.selectByCourseId(courseId);
  135. if (courseAssignments.isEmpty()) {
  136. throw MyException.create(HttpStatus.BAD_REQUEST, "课程无作业");
  137. }
  138. // 生成ZIP文件
  139. try {
  140. List<ZipExport.ZipItem> zipItems = new ArrayList<>();
  141. for (StudentInfoVO student : students) {
  142. String officialNumber = student.getOfficialNumber();
  143. User user = userMapper.selectOne(new QueryWrapper<User>().eq("official_number", officialNumber));
  144. if (user == null) {
  145. continue;
  146. }
  147. Long studentId = user.getId();
  148. for (Assignment assignment : courseAssignments) {
  149. Long assignmentId = assignment.getAssignmentId();
  150. String assignmentDir = assignment.getAssignmentName() + "/";
  151. String studentDir = assignmentDir + user.getOfficialNumber() + "_" + user.getName() + "/";
  152. try {
  153. List<EngagementHistoryVO> historyList = assignmentService.getEngagementHistory(studentId, assignmentId);
  154. for (EngagementHistoryVO history : historyList) {
  155. Map<String, Object> model = new HashMap<>();
  156. model.put("title", assignment.getAssignmentName());
  157. model.put("studentName", user.getName());
  158. model.put("officialNumber", user.getOfficialNumber());
  159. model.put("assignmentName", assignment.getAssignmentName());
  160. model.put("date", history.getSubmitTime());
  161. model.put("content", processContent(history.getTextContent()));
  162. byte[] wordBytes = wordExporter.exportCompositionWord(model);
  163. String fileName = studentDir + user.getOfficialNumber() + "_" + user.getName() + "_版本" + history.getVersion() + ".docx";
  164. zipItems.add(new ZipExport.ZipItem(fileName, wordBytes));
  165. }
  166. } catch (Exception e) {
  167. log.warn("学生 {} 未提交作业 {},跳过", studentId, assignmentId);
  168. }
  169. }
  170. }
  171. return ZipExport.packToZip(zipItems);
  172. } catch (IOException e) {
  173. throw MyException.create(HttpStatus.INTERNAL_SERVER_ERROR, "ZIP打包失败" + e.getMessage());
  174. }
  175. }
  176. public byte[] downloadAssignmentSubmissions(Long assignmentId) {
  177. AssignmentVO assignment = assignmentService.findAssignmentById(assignmentId);
  178. if (assignment == null) {
  179. throw MyException.create(HttpStatus.BAD_REQUEST, "作业不存在");
  180. }
  181. Long courseId = assignment.getCourseId();
  182. List<com.njuzr.eaibackend.po.Class> courseClasses = classService.select(courseId);
  183. if (courseClasses.isEmpty()) {
  184. throw MyException.create(HttpStatus.BAD_REQUEST, "课程无班级");
  185. }
  186. try {
  187. List<ZipExport.ZipItem> zipItems = new ArrayList<>();
  188. for (com.njuzr.eaibackend.po.Class cls : courseClasses) {
  189. String className = cls.getClassName();
  190. String classDir = className + "/";
  191. List<StudentInfoVO> students = classService.getStudentsByClassId(cls.getClassId());
  192. for (StudentInfoVO student : students) {
  193. String officialNumber = student.getOfficialNumber();
  194. User user = userMapper.selectOne(new QueryWrapper<User>().eq("official_number", officialNumber));
  195. if (user == null) continue;
  196. Long studentId = user.getId();
  197. String studentDir = classDir + user.getOfficialNumber() + "_" + user.getName() + "/";
  198. List<EngagementHistoryVO> historyList = assignmentService.getEngagementHistory(studentId, assignmentId);
  199. for (EngagementHistoryVO history : historyList) {
  200. Map<String, Object> model = new HashMap<>();
  201. model.put("title", assignment.getAssignmentName());
  202. model.put("studentName", user.getName());
  203. model.put("officialNumber", user.getOfficialNumber());
  204. model.put("assignmentName", assignment.getAssignmentName());
  205. model.put("date", history.getSubmitTime());
  206. model.put("content", processContent(history.getTextContent()));
  207. byte[] wordBytes = wordExporter.exportCompositionWord(model);
  208. String fileName = studentDir + user.getOfficialNumber() + "_" + user.getName() + "_版本" + history.getVersion() + ".docx";
  209. zipItems.add(new ZipExport.ZipItem(fileName, wordBytes));
  210. }
  211. }
  212. }
  213. return ZipExport.packToZip(zipItems);
  214. } catch (IOException e) {
  215. throw MyException.create(HttpStatus.INTERNAL_SERVER_ERROR, "ZIP打包失败" + e.getMessage());
  216. }
  217. }
  218. public byte[] downloadClassAssignment(Long classId, Long assignmentId) {
  219. com.njuzr.eaibackend.po.Class cls = classService.getClassById(classId);
  220. if (cls == null) {
  221. throw MyException.create(HttpStatus.BAD_REQUEST, "班级不存在");
  222. }
  223. AssignmentVO assignment = assignmentService.findAssignmentById(assignmentId);
  224. if (assignment == null) {
  225. throw MyException.create(HttpStatus.BAD_REQUEST, "作业不存在");
  226. }
  227. String folderName = cls.getClassName() + "_" + assignment.getAssignmentName();
  228. String folderDir = folderName + "/";
  229. List<StudentInfoVO> students = classService.getStudentsByClassId(classId);
  230. if (students.isEmpty()) {
  231. throw MyException.create(HttpStatus.BAD_REQUEST, "班级无学生");
  232. }
  233. try {
  234. List<ZipExport.ZipItem> zipItems = new ArrayList<>();
  235. for (StudentInfoVO student : students) {
  236. String officialNumber = student.getOfficialNumber();
  237. User user = userMapper.selectOne(new QueryWrapper<User>().eq("official_number", officialNumber));
  238. if (user == null) continue;
  239. Long studentId = user.getId();
  240. String studentDir = folderDir + user.getOfficialNumber() + "_" + user.getName() + "/";
  241. List<EngagementHistoryVO> historyList = assignmentService.getEngagementHistory(studentId, assignmentId);
  242. for (EngagementHistoryVO history : historyList) {
  243. Map<String, Object> model = new HashMap<>();
  244. model.put("title", assignment.getAssignmentName());
  245. model.put("studentName", user.getName());
  246. model.put("officialNumber", user.getOfficialNumber());
  247. model.put("assignmentName", assignment.getAssignmentName());
  248. model.put("date", history.getSubmitTime());
  249. model.put("content", processContent(history.getTextContent()));
  250. byte[] wordBytes = wordExporter.exportCompositionWord(model);
  251. String fileName = studentDir + user.getOfficialNumber() + "_" + user.getName() + "_版本" + history.getVersion() + ".docx";
  252. zipItems.add(new ZipExport.ZipItem(fileName, wordBytes));
  253. }
  254. }
  255. return ZipExport.packToZip(zipItems);
  256. } catch (IOException e) {
  257. throw MyException.create(HttpStatus.INTERNAL_SERVER_ERROR, "ZIP打包失败" + e.getMessage());
  258. }
  259. }
  260. // 需要注入 ClassService
  261. @Autowired
  262. private ClassService classService;
  263. }