blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
fuliqi
2024-10-17 8546b3d285af4235a0ef615a0c6e89486ae2c806 
 src/main/java/com/ycl/jxkg/service/impl/ExamPaperServiceImpl.java


@@ -1,9 +1,9 @@


package com.ycl.jxkg.service.impl;




import com.alibaba.excel.EasyExcel;


import com.alibaba.fastjson.JSON;


import com.alibaba.fastjson.JSONObject;


import com.alibaba.fastjson2.JSONArray;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;


import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;


import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;


import com.github.pagehelper.PageHelper;


@@ -13,6 +13,7 @@


import com.ycl.jxkg.context.WebContext;


import com.ycl.jxkg.domain.entity.ExamPaper;


import com.ycl.jxkg.domain.entity.Question;


import com.ycl.jxkg.domain.entity.Subject;


import com.ycl.jxkg.domain.exam.PaperFixQuestionDTO;


import com.ycl.jxkg.domain.exam.PaperQuestion;


import com.ycl.jxkg.domain.exam.PaperQuestionSettingDTO;


@@ -22,16 +23,15 @@


import com.ycl.jxkg.domain.question.QuestionItemObject;


import com.ycl.jxkg.domain.question.QuestionObject;


import com.ycl.jxkg.domain.question.RandomQuestionDTO;


import com.ycl.jxkg.domain.vo.admin.exam.ExamPaperEditRequestVO;


import com.ycl.jxkg.domain.vo.admin.exam.ExamPaperPageRequestVO;


import com.ycl.jxkg.domain.vo.admin.exam.ExamPaperTitleItemVO;


import com.ycl.jxkg.domain.vo.admin.exam.ExamResponseVO;


import com.ycl.jxkg.domain.vo.admin.exam.*;


import com.ycl.jxkg.domain.vo.student.dashboard.PaperFilter;


import com.ycl.jxkg.domain.vo.student.dashboard.PaperInfo;


import com.ycl.jxkg.domain.vo.student.exam.ExamPaperPageVO;


import com.ycl.jxkg.enums.ExamPaperTypeEnum;


import com.ycl.jxkg.enums.QuestionTypeEnum;


import com.ycl.jxkg.enums.VisibilityEnum;


import com.ycl.jxkg.enums.general.StatusEnum;


import com.ycl.jxkg.excel.*;


import com.ycl.jxkg.mapper.ExamPaperMapper;


import com.ycl.jxkg.mapper.QuestionMapper;


import com.ycl.jxkg.service.ExamPaperService;


@@ -39,17 +39,20 @@


import com.ycl.jxkg.service.SubjectService;


import com.ycl.jxkg.service.TextContentService;


import com.ycl.jxkg.utils.DateTimeUtil;


import com.ycl.jxkg.utils.JsonUtil;


import com.ycl.jxkg.utils.PageInfoHelper;


import lombok.RequiredArgsConstructor;


import lombok.SneakyThrows;


import org.springframework.beans.BeanUtils;


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;


import org.springframework.util.CollectionUtils;


import org.springframework.util.StringUtils;


import org.springframework.web.multipart.MultipartFile;




import javax.servlet.http.HttpServletResponse;


import java.math.BigDecimal;


import java.net.URLEncoder;


import java.util.*;


import java.util.function.Consumer;


import java.util.stream.Collectors;




@Service


@@ -182,7 +185,7 @@




    @Override


    public PageInfo<ExamResponseVO> page(ExamPaperPageRequestVO requestVM) {


        //TODO: 数据权限


        requestVM.setCreateUser(webContext.getCurrentUser().getId());


        PageInfo<ExamPaper> page = PageHelper.startPage(requestVM.getPageIndex(), requestVM.getPageSize(), "id desc").doSelectPageInfo(() ->


                examPaperMapper.page(requestVM));


        PageInfo<ExamResponseVO> pageVO = PageInfoHelper.copyMap(page, e -> {


@@ -339,4 +342,235 @@


        });


        return list;


    }




    @Override


    @SneakyThrows


    public void importTemplate(HttpServletResponse response) {


        String fileName = URLEncoder.encode("试卷导入模板", "UTF-8").replaceAll("\\+", "%20");


        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");




        // 构建模板样例数据


        List<ExamPaperImportVO> data = new ArrayList<>(8);


        ExamPaperImportVO questionImportVO = new ExamPaperImportVO();


        questionImportVO.setLabel("标题1");


        questionImportVO.setSubject("语文");


        questionImportVO.setQuestionType("单选题");


        questionImportVO.setDifficult(2);


        questionImportVO.setCorrect("A");


        questionImportVO.setScore(2);


        questionImportVO.setAnalyze("A是对的");


        questionImportVO.setTitle("这是一道测试题目，使用该模板请删除或替换这道题");


        questionImportVO.setOptionName("A");


        questionImportVO.setOptionValue("选我");


        data.add(questionImportVO);




        ExamPaperImportVO questionImport1 = new ExamPaperImportVO();


        questionImport1.setOptionName("B");


        questionImport1.setOptionValue("选B");


        data.add(questionImport1);




        ExamPaperImportVO questionImport2 = new ExamPaperImportVO();


        questionImport2.setOptionName("C");


        questionImport2.setOptionValue("选C");


        data.add(questionImport2);




        ExamPaperImportVO questionImport3 = new ExamPaperImportVO();


        questionImport3.setOptionName("D");


        questionImport3.setOptionValue("选D");


        data.add(questionImport3);




        // 查出所有的课目（excel下拉数据）


        List<Subject> subjects = subjectService.list();


        List<String> subjectNameList = subjects.stream().map(Subject::getName).collect(Collectors.toList());


        EasyExcel.write(response.getOutputStream(), ExamPaperImportVO.class)


                .sheet("模板")


                .registerWriteHandler(new PaperSelectExcel(subjectNameList))


                .registerWriteHandler(new FixedMergeCellStrategy(2, 4, Arrays.asList(2, 3, 6, 7, 8, 9)))


                .registerWriteHandler(new FixedMergeCellStrategy(2, 20, Arrays.asList(0, 1)))


                .doWrite(data);


    }




    @Override


    @SneakyThrows


    public void export(QuestionExportVO query, HttpServletResponse response) {


        // 查询导出数据


        List<ExamPaperImportVO> exportData = questionService.export(query);


        // 构建数据


        List<ExamPaperImportVO> exportList = new ArrayList<>(exportData.size() * 4);


        // 行合并规则


        List<RowItem> mergeRowList = new ArrayList<>(exportData.size());


        int j = 2;


        for (ExamPaperImportVO 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) {


                    ExamPaperImportVO master = new ExamPaperImportVO();


                    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.setCorrect(data.getCorrect().replaceAll(",", "、"));


                    BigDecimal score = BigDecimal.valueOf(master.getScore());


                    master.setScore(score.divide(BigDecimal.TEN).intValue());


                    exportList.add(master);


                } else {


                    ExamPaperImportVO optionItem = new ExamPaperImportVO();


                    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可以防止中文乱码 当然和easyexcel没有关系


        String fileName = URLEncoder.encode("题目导出数据", "UTF-8").replaceAll("\\+", "%20");


        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");




        // 查出所有的课目（excel下拉数据）


        List<Subject> subjects = subjectService.list();


        List<String> subjectNameList = subjects.stream().map(Subject::getName).collect(Collectors.toList());


        EasyExcel.write(response.getOutputStream(), ExamPaperImportVO.class)


                .sheet("题目导出数据")


                .registerWriteHandler(new SelectExcel(subjectNameList))


                .registerWriteHandler(new DynamicMergeCellStrategy(mergeRowList, Arrays.asList(0, 1, 2, 5, 6, 7, 8)))


                .doWrite(exportList);


    }




    @Override


    @Transactional


    @SneakyThrows


    public Result importPaper(MultipartFile file, ExamPaperForm form) {


        List<Subject> subjects = subjectService.list();


        List<Integer> questionNum = new ArrayList<>();


        List<Integer> totalScore = new ArrayList<>();


        // 拿到试卷


        ExamPaper examPaper = ExamPaperForm.getEntityByForm(form, null);


        // 题目集合用于批量保存


        ArrayList<Question> questions = new ArrayList<>();


        // 一张试卷多个标题


        ArrayList<PaperFixQuestionDTO> list = new ArrayList<>();




        Consumer<List<ExamPaperImportVO>> consumer = (data) -> {


            // 循环每一行


            for (int i = 0; i < data.size(); i++) {


                // 读取的题目


                ExamPaperImportVO excelQuestion = data.get(i);


                String questionType = excelQuestion.getQuestionType();


                String label = excelQuestion.getLabel();


                // 判断是否标题


                if (excelQuestion.master()) {


                    // 一个标题多个题目


                    ArrayList<PaperQuestion> paperQuestions = new ArrayList<>();


                    // 循环题目


                    while (Boolean.TRUE) {


                        // 更新读取的题目


                        excelQuestion = data.get(i);


                        // 判断是否题目


                        if (excelQuestion.intact()) {


                            Question question = new Question();


                            totalScore.add(excelQuestion.getScore());


                            // 该题的选项


                            List<QuestionItemObject> options = new ArrayList<>(8);


                            // 选项内容


                            QuestionItemObject option = new QuestionItemObject();


                            option.setPrefix(excelQuestion.getOptionName());


                            option.setContent(excelQuestion.getOptionValue());


                            options.add(option);


                            // 循环选项


                            while (Boolean.TRUE) {


                                // 判断是否是最后一条


                                if (i + 1 == data.size()) {


                                    break;


                                }


                                ExamPaperImportVO nextQuestion = data.get(1 + i);


                                if (nextQuestion.intact()) {


                                    break;


                                }


                                QuestionItemObject nextOption = new QuestionItemObject();


                                nextOption.setPrefix(nextQuestion.getOptionName());


                                nextOption.setContent(nextQuestion.getOptionValue());


                                options.add(nextOption);


                                i++;


                            }


                            // 保存题目内容


                            QuestionObject questionObject = new QuestionObject();


                            questionObject.setQuestionItemObjects(options);


                            questionObject.setAnalyze(excelQuestion.getAnalyze());


                            questionObject.setTitleContent(excelQuestion.getTitle());


                            questionObject.setCorrect(excelQuestion.getCorrect());


                            question.setTitle(excelQuestion.getTitle());


                            question.setContent(JSON.toJSONString(questionObject));


                            question.setQuestionType(QuestionTypeEnum.get(excelQuestion.getQuestionType()));


                            // 答案(多选需要用、分割保存字符串到数据库)


                            String[] corrects = excelQuestion.getCorrect().split("、");


                            if (corrects.length > 1) {


                                question.setCorrect(String.join(",", corrects));


                            } else {


                                question.setCorrect(excelQuestion.getCorrect());


                            }


                            // 难度


                            question.setDifficult(excelQuestion.getDifficult());


                            // 创建人


                            question.setCreateUser(2);


                            question.setStatus(StatusEnum.ENABLE);


                            question.setCreateTime(new Date());


                            question.setDeleted(0);


                            question.setQuestionType(QuestionTypeEnum.get(questionType));


                            // 根据科目名称获取id


                            ExamPaperImportVO finalExcelQuestion = excelQuestion;


                            question.setSubjectId(subjects.stream().filter(subject -> subject.getName().equals(finalExcelQuestion.getSubject())).findFirst().get().getId());


                            questions.add(question);




                            PaperQuestion paperQuestion = new PaperQuestion();


                            BeanUtils.copyProperties(question, paperQuestion);


                            paperQuestion.setItems(options);


                            paperQuestion.setAnalyze(excelQuestion.getAnalyze());


                            paperQuestion.setScore(BigDecimal.valueOf(excelQuestion.getScore()));


                            paperQuestions.add(paperQuestion);


                        }


                        // 下一条数据是标题


                        if (i + 1 == data.size() || data.get(i + 1).master()) {


                            break;


                        }


                        i++;


                    }


                    // 组装试卷内容


                    PaperFixQuestionDTO paperFixQuestionDTO = new PaperFixQuestionDTO();


                    paperFixQuestionDTO.setTitle(label);


                    paperFixQuestionDTO.setQuestionType(QuestionTypeEnum.get(questionType));


                    paperFixQuestionDTO.setQuestionList(paperQuestions);


                    questionNum.add(paperQuestions.size());


                    list.add(paperFixQuestionDTO);


                }


            }


        };


        EasyExcel.read(file.getInputStream(), ExamPaperImportVO.class, new CurrencyDataListener(consumer)).sheet("模板").doRead();


        // 保存题目


        questionService.saveBatch(questions);


        // 保存试卷


        examPaper.setContent(JSON.toJSONString(list));


        examPaper.setVisibility(VisibilityEnum.fromCode(form.getVisibility()).getName());


        examPaper.setCreateUser(2);


        examPaper.setCreateTime(new Date());


        Integer score = totalScore.stream().reduce(Integer::sum).orElse(0);


        Integer num = questionNum.stream().reduce(Integer::sum).orElse(0);


        examPaper.setScore(new BigDecimal(score));


        examPaper.setNum(num);


        examPaperMapper.insert(examPaper);


        return Result.ok();


    }


}