From 8853292babb2ad94de4a3207966f1e83b767cd2d Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Sun, 17 Sep 2023 16:38:34 +0800
Subject: [PATCH] 新增流程节点进程查询接口
---
src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java | 467 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 466 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java b/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java
index 4e9634d..24c8ff8 100644
--- a/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java
+++ b/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java
@@ -3,18 +3,47 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springblade.modules.FTP.FtpUtil;
+import org.springblade.modules.exam.entity.ExamAnswerRecord;
import org.springblade.modules.exam.entity.ExamSubjectChoices;
+import org.springblade.modules.exam.entity.ExamSubjectOption;
+import org.springblade.modules.exam.excel.ExamSubjectExcel;
import org.springblade.modules.exam.mapper.ExamSubjectChoicesMapper;
+import org.springblade.modules.exam.service.ExamAnswerRecordService;
import org.springblade.modules.exam.service.ExamSubjectChoicesService;
+import org.springblade.modules.exam.service.ExamSubjectOptionService;
import org.springblade.modules.exam.vo.ExamSubjectChoicesVO;
+import org.springblade.modules.simulateexam.entity.SimulateExamAnswerRecord;
+import org.springblade.modules.simulateexam.service.SimulateExamAnswerRecordService;
+import org.springblade.modules.system.service.MyAsyncService;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.text.SimpleDateFormat;
+import java.util.Arrays;
+import java.util.Date;
+import java.util.List;
/**
* 选择题服务实现类
+ *
* @author zhongrj
*/
@Service
public class ExamSubjectChoicesServiceImpl extends ServiceImpl<ExamSubjectChoicesMapper, ExamSubjectChoices> implements ExamSubjectChoicesService {
+
+ @Autowired
+ private ExamSubjectOptionService examSubjectOptionService;
+
+ @Autowired
+ private ExamAnswerRecordService examAnswerRecordService;
+
+ @Autowired
+ private SimulateExamAnswerRecordService simulateExamAnswerRecordService;
+ @Autowired
+ private MyAsyncService myAsyncService;
+
@Override
public IPage<ExamSubjectChoicesVO> selectExamSubjectChoicesPage(IPage<ExamSubjectChoicesVO> page, ExamSubjectChoicesVO examSubjectChoices) {
@@ -28,6 +57,7 @@
/**
* 详情
+ *
* @param examSubjectChoices 选择题信息对象
*/
@Override
@@ -37,6 +67,441 @@
@Override
public boolean updateChoicesValue(String id, String value) {
- return baseMapper.updateChoicesValue(id,value);
+ return baseMapper.updateChoicesValue(id, value);
+ }
+
+ /**
+ * 新增题目及选项信息
+ *
+ * @param examSubjectChoices 题目信息对象
+ * @return
+ */
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public boolean saveSubjectChoicesAndOption(ExamSubjectChoicesVO examSubjectChoices) {
+ boolean status = false;
+ //新增
+ if (null == examSubjectChoices.getId()) {
+ ExamSubjectChoices subjectChoices = new ExamSubjectChoices();
+ subjectChoices.setCreateDate(new Date());
+ subjectChoices.setDelFlag(0);
+ subjectChoices.setAnswer(examSubjectChoices.getAnswer());
+ if (null != examSubjectChoices.getAnalysis() && examSubjectChoices.getAnalysis() != "") {
+ subjectChoices.setAnalysis(examSubjectChoices.getAnalysis());
+ }
+ subjectChoices.setCreator(examSubjectChoices.getCreator());
+ subjectChoices.setChoicesType(examSubjectChoices.getChoicesType());
+ subjectChoices.setSubjectName(examSubjectChoices.getSubjectName());
+ subjectChoices.setScore(examSubjectChoices.getScore());
+ subjectChoices.setTktype(examSubjectChoices.getTktype());
+ //题目新增
+ status = this.save(subjectChoices);
+ //判断类型,单选，多选，实操
+ if (examSubjectChoices.getChoicesType() == 0 || examSubjectChoices.getChoicesType() == 1 || examSubjectChoices.getChoicesType() == 3) {
+ //选项新增
+ List<ExamSubjectOption> examSubjectOptions = examSubjectChoices.getExamSubjectOptions();
+ examSubjectOptions.forEach(examSubjectOption -> {
+ examSubjectOption.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption.setCreateDate(new Date());
+ examSubjectOption.setDelFlag(0);
+ //新增
+ examSubjectOptionService.save(examSubjectOption);
+ });
+ return true;
+ }
+ } else {
+ //修改
+ ExamSubjectChoices subjectChoices = new ExamSubjectChoices();
+ subjectChoices.setId(examSubjectChoices.getId());
+ subjectChoices.setModifyDate(new Date());
+ subjectChoices.setAnswer(examSubjectChoices.getAnswer());
+ if (null != examSubjectChoices.getAnalysis() && examSubjectChoices.getAnalysis() != "") {
+ subjectChoices.setAnalysis(examSubjectChoices.getAnalysis());
+ }
+ subjectChoices.setModifier(examSubjectChoices.getCreator());
+ subjectChoices.setChoicesType(examSubjectChoices.getChoicesType());
+ subjectChoices.setSubjectName(examSubjectChoices.getSubjectName());
+ subjectChoices.setScore(examSubjectChoices.getScore());
+ subjectChoices.setTktype(examSubjectChoices.getTktype());
+ //题目修改
+ status = this.updateById(subjectChoices);
+ //判断类型,单选，多选
+ if (examSubjectChoices.getChoicesType() == 0 || examSubjectChoices.getChoicesType() == 1) {
+ //选项修改
+ List<ExamSubjectOption> examSubjectOptions = examSubjectChoices.getExamSubjectOptions();
+ examSubjectOptions.forEach(examSubjectOption -> {
+ examSubjectOption.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption.setModifyDate(new Date());
+ examSubjectOption.setModifier(examSubjectChoices.getCreator());
+ //修改
+ examSubjectOptionService.updateById(examSubjectOption);
+ });
+ return true;
+ }
+ //实操
+ if (examSubjectChoices.getChoicesType() == 3) {
+ //先将选项删除
+ baseMapper.removeBySubjectId(examSubjectChoices.getId());
+ //选项新增
+ List<ExamSubjectOption> examSubjectOptions = examSubjectChoices.getExamSubjectOptions();
+ examSubjectOptions.forEach(examSubjectOption -> {
+ examSubjectOption.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption.setCreateDate(new Date());
+ examSubjectOption.setDelFlag(0);
+ //新增
+ examSubjectOptionService.save(examSubjectOption);
+ });
+ return true;
+ }
+ }
+ return status;
+ }
+
+
+ /**
+ * 题库导入
+ *
+ * @param data 导入数据
+ * @param isCovered
+ */
+ @Override
+ public void importSubject(List<ExamSubjectExcel> data, Boolean isCovered) {
+ data.forEach(examSubjectExcel -> {
+ //题目对象
+ ExamSubjectChoices subjectChoices = new ExamSubjectChoices();
+ subjectChoices.setCreateDate(new Date());
+ subjectChoices.setDelFlag(0);
+ subjectChoices.setAnswer(examSubjectExcel.getAnswer());
+ if (null != examSubjectExcel.getAnalysis() && examSubjectExcel.getAnalysis() != "") {
+ subjectChoices.setAnalysis(examSubjectExcel.getAnalysis());
+ }
+ subjectChoices.setChoicesType(examSubjectExcel.getChoicesType());
+ subjectChoices.setSubjectName(examSubjectExcel.getSubjectName());
+ subjectChoices.setScore(examSubjectExcel.getScore());
+ subjectChoices.setTktype(examSubjectExcel.getTktype());
+ //题目新增
+ this.save(subjectChoices);
+
+
+ //判断类型,单选，多选选项新增
+ if (examSubjectExcel.getChoicesType() == 0 || examSubjectExcel.getChoicesType() == 1) {
+ //A选项新增
+ ExamSubjectOption examSubjectOption = new ExamSubjectOption();
+ //选项新增
+ examSubjectOption.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption.setCreateDate(new Date());
+ examSubjectOption.setDelFlag(0);
+ examSubjectOption.setOptionName("A");
+ examSubjectOption.setOptionContent(examSubjectExcel.getOptionContentA());
+ //新增
+ examSubjectOptionService.save(examSubjectOption);
+
+ //B选项新增
+ ExamSubjectOption examSubjectOption1 = new ExamSubjectOption();
+ //选项新增
+ examSubjectOption1.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption1.setCreateDate(new Date());
+ examSubjectOption1.setDelFlag(0);
+ examSubjectOption1.setOptionName("B");
+ examSubjectOption1.setOptionContent(examSubjectExcel.getOptionContentB());
+ //新增
+ examSubjectOptionService.save(examSubjectOption1);
+
+ //C选项新增
+ ExamSubjectOption examSubjectOption2 = new ExamSubjectOption();
+ //选项新增
+ examSubjectOption2.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption2.setCreateDate(new Date());
+ examSubjectOption2.setDelFlag(0);
+ examSubjectOption2.setOptionName("C");
+ examSubjectOption2.setOptionContent(examSubjectExcel.getOptionContentC());
+ //新增
+ examSubjectOptionService.save(examSubjectOption2);
+
+ //D选项新增
+ ExamSubjectOption examSubjectOption3 = new ExamSubjectOption();
+ //选项新增
+ examSubjectOption3.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption3.setCreateDate(new Date());
+ examSubjectOption3.setDelFlag(0);
+ examSubjectOption3.setOptionName("D");
+ examSubjectOption3.setOptionContent(examSubjectExcel.getOptionContentD());
+ //新增
+ examSubjectOptionService.save(examSubjectOption3);
+ }
+
+
+ //多选选项新增
+ if (examSubjectExcel.getChoicesType() == 3) {
+ //1选项新增
+ if (null != examSubjectExcel.getOptionContentA() && examSubjectExcel.getOptionContentA() != "") {
+ ExamSubjectOption examSubjectOption = new ExamSubjectOption();
+ //选项新增
+ examSubjectOption.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption.setCreateDate(new Date());
+ examSubjectOption.setDelFlag(0);
+ examSubjectOption.setOptionName("1");
+ examSubjectOption.setOptionContent(examSubjectExcel.getOptionContentA());
+ //新增
+ examSubjectOptionService.save(examSubjectOption);
+ }
+
+ //2选项新增
+ if (null != examSubjectExcel.getOptionContentB() && examSubjectExcel.getOptionContentB() != "") {
+ ExamSubjectOption examSubjectOption1 = new ExamSubjectOption();
+ //选项新增
+ examSubjectOption1.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption1.setCreateDate(new Date());
+ examSubjectOption1.setDelFlag(0);
+ examSubjectOption1.setOptionName("2");
+ examSubjectOption1.setOptionContent(examSubjectExcel.getOptionContentB());
+ //新增
+ examSubjectOptionService.save(examSubjectOption1);
+ }
+
+ //3选项新增
+ if (null != examSubjectExcel.getOptionContentC() && examSubjectExcel.getOptionContentC() != "") {
+ ExamSubjectOption examSubjectOption2 = new ExamSubjectOption();
+ //选项新增
+ examSubjectOption2.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption2.setCreateDate(new Date());
+ examSubjectOption2.setDelFlag(0);
+ examSubjectOption2.setOptionName("3");
+ examSubjectOption2.setOptionContent(examSubjectExcel.getOptionContentC());
+ //新增
+ examSubjectOptionService.save(examSubjectOption2);
+ }
+
+ //4选项新增
+ if (null != examSubjectExcel.getOptionContentD() && examSubjectExcel.getOptionContentD() != "") {
+ ExamSubjectOption examSubjectOption3 = new ExamSubjectOption();
+ //选项新增
+ examSubjectOption3.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption3.setCreateDate(new Date());
+ examSubjectOption3.setDelFlag(0);
+ examSubjectOption3.setOptionName("4");
+ examSubjectOption3.setOptionContent(examSubjectExcel.getOptionContentD());
+ //新增
+ examSubjectOptionService.save(examSubjectOption3);
+ }
+
+
+ //5选项新增
+ if (null != examSubjectExcel.getOptionContentE() && examSubjectExcel.getOptionContentE() != "") {
+ ExamSubjectOption examSubjectOption4 = new ExamSubjectOption();
+ //选项新增
+ examSubjectOption4.setSubjectChoicesId(subjectChoices.getId());
+ examSubjectOption4.setCreateDate(new Date());
+ examSubjectOption4.setDelFlag(0);
+ examSubjectOption4.setOptionName("5");
+ examSubjectOption4.setOptionContent(examSubjectExcel.getOptionContentE());
+ //新增
+ examSubjectOptionService.save(examSubjectOption4);
+ }
+ }
+ });
+
+ }
+
+
+ /**
+ * 判断当前题目的答题结果
+ *
+ * @param preSubJectId 题目Id
+ * @param preResult 提交的结果
+ * @param scoreId 成绩id
+ * @return
+ */
+ @Override
+ public Integer getAnswerResult(Long preSubJectId, String preResult, Long scoreId) {
+ //查询题目信息
+ ExamSubjectChoices choices = this.getById(preSubJectId);
+ //对比答案
+ if (choices.getChoicesType() == 2 || choices.getChoicesType() == 3) {
+ //保存答题记录
+ boolean result = preResult.equals(choices.getAnswer());
+ int status = 0;
+ //判断题逻辑
+ if (result) {
+ status = 1;
+ } else {
+ status = 2;
+ }
+ //新增答题记录
+ saveExamAns(choices, preSubJectId, preResult, scoreId, result);
+ //返回
+ return status;
+ } else if (choices.getChoicesType() == 0 || choices.getChoicesType() == 1) {
+ //处理多选题的答案排序
+ String[] split = preResult.split(",");
+ StringBuilder builder = new StringBuilder();
+ for (String s : split) {
+ builder.append(s);
+ }
+ char[] arrayCh = builder.toString().toCharArray();
+ //利用数组帮助类自动排序
+ Arrays.sort(arrayCh);
+ String sub0 = Arrays.toString(arrayCh);
+ String sub = sub0.substring(1, sub0.length() - 1).replaceAll(" ", "");
+
+ //保存答题记录
+ boolean result = sub.equals(choices.getAnswer());
+ int status = 0;
+ //判断题逻辑
+ if (result) {
+ status = 1;
+ } else {
+ status = 2;
+ }
+ //新增答题记录
+ saveExamAns(choices, preSubJectId, preResult, scoreId, result);
+ //返回
+ return status;
+ }
+ return 2;
+ }
+
+ /**
+ * 新增答题记录
+ *
+ * @param choices 题目
+ * @param preSubJectId 上一题题目id
+ * @param preResult 上一题答题结果
+ * @param scoreId 成绩 id
+ * @param result 答题是否正确
+ */
+ private void saveExamAns(ExamSubjectChoices choices, Long preSubJectId, String preResult, Long scoreId, boolean result) {
+ ExamAnswerRecord examAnswerRecord = new ExamAnswerRecord();
+ examAnswerRecord.setScoreId(scoreId);
+ examAnswerRecord.setAnswerOption(preResult);
+ examAnswerRecord.setSubjectChoicesId(preSubJectId);
+ examAnswerRecord.setAnswer(choices.getAnswer());
+ examAnswerRecord.setSubjectChoicesType(choices.getChoicesType());
+ examAnswerRecord.setAnswerTime(new Date());
+ int status = 0;
+ //判断题逻辑
+ if (result) {
+ status = 1;
+ examAnswerRecord.setAnswerScore(choices.getScore());
+ } else {
+ status = 2;
+ examAnswerRecord.setAnswerScore(0);
+ }
+ examAnswerRecord.setAnswerResult(status);
+ //新增
+ examAnswerRecordService.save(examAnswerRecord);
+
+ //内网数据同步...
+ String s = "insert into exam_answer_record(id,subject_choices_id,subject_choices_type,answer_option,answer" +
+ ",answer_time,answer_score,answer_result,score_id) " +
+ "values(" + "'" + examAnswerRecord.getId() + "'" +
+ "," + "'" + examAnswerRecord.getSubjectChoicesId() + "'" +
+ "," + "'" + examAnswerRecord.getSubjectChoicesType() + "'" +
+ "," + "'" + examAnswerRecord.getAnswerOption() + "'" +
+ "," + "'" + examAnswerRecord.getAnswer() + "'" +
+ "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examAnswerRecord.getAnswerTime()) + "'" +
+ "," + "'" + examAnswerRecord.getAnswerScore() + "'" +
+ "," + "'" + examAnswerRecord.getAnswerResult() + "'" +
+ "," + "'" + examAnswerRecord.getScoreId() + "'" + ")";
+ //FtpUtil.sqlFileUpload(s);
+ myAsyncService.dataSync(s);
+ }
+
+ /**
+ * 随机查询题库120道
+ *
+ * @return
+ */
+ @Override
+ public List<String> getExamSubjectChoicesList() {
+ return baseMapper.getExamSubjectChoicesList();
+ }
+
+ /**
+ * 判断当前题目的答题结果
+ *
+ * @param preSubJectId 题目 id
+ * @param preResult 提交的结果
+ * @param simulateExamId 模拟考试记录 id
+ * @return
+ */
+ @Override
+ public Integer getAnswerResultBySimulate(Long preSubJectId, String preResult, Long simulateExamId) {
+ //查询题目信息
+ ExamSubjectChoices choices = this.getById(preSubJectId);
+ //对比答案
+ if (choices.getChoicesType() == 2 || choices.getChoicesType() == 3) {
+ //保存答题记录
+ boolean result = preResult.equals(choices.getAnswer());
+ int status = 0;
+ //判断题逻辑
+ if (result) {
+ status = 1;
+ } else {
+ status = 2;
+ }
+ //新增模拟考试答题记录
+ saveSimulateExamAns(choices, preSubJectId, preResult, simulateExamId, result);
+ //返回
+ return status;
+ } else if (choices.getChoicesType() == 0 || choices.getChoicesType() == 1) {
+ //处理多选题的答案排序
+ String[] split = preResult.split(",");
+ StringBuilder builder = new StringBuilder();
+ for (String s : split) {
+ builder.append(s);
+ }
+ char[] arrayCh = builder.toString().toCharArray();
+ //利用数组帮助类自动排序
+ Arrays.sort(arrayCh);
+ String sub0 = Arrays.toString(arrayCh);
+ String sub = sub0.substring(1, sub0.length() - 1).replaceAll(" ", "");
+
+ //保存模拟考试答题记录
+ boolean result = sub.equals(choices.getAnswer());
+ int status = 0;
+ //判断题逻辑
+ if (result) {
+ status = 1;
+ } else {
+ status = 2;
+ }
+ //新增模拟考试答题记录
+ saveSimulateExamAns(choices, preSubJectId, preResult, simulateExamId, result);
+ //返回
+ return status;
+ }
+ return 2;
+ }
+
+ /**
+ * 新增模拟考试答题记录
+ *
+ * @param choices 题目信息
+ * @param preSubJectId 题目id
+ * @param preResult 提交的答案
+ * @param simulateExamId 模拟考试id
+ * @param result 答题的结果
+ */
+ private void saveSimulateExamAns(ExamSubjectChoices choices, Long preSubJectId, String preResult, Long simulateExamId, boolean result) {
+ SimulateExamAnswerRecord simulateExamAnswerRecord = new SimulateExamAnswerRecord();
+ simulateExamAnswerRecord.setSimulateExamId(simulateExamId);
+ simulateExamAnswerRecord.setAnswerOption(preResult);
+ simulateExamAnswerRecord.setSubjectChoicesId(preSubJectId);
+ simulateExamAnswerRecord.setAnswer(choices.getAnswer());
+ simulateExamAnswerRecord.setSubjectChoicesType(choices.getChoicesType());
+ simulateExamAnswerRecord.setAnswerTime(new Date());
+ int status = 0;
+ //判断题逻辑
+ if (result) {
+ status = 1;
+ simulateExamAnswerRecord.setAnswerScore(choices.getScore());
+ } else {
+ status = 2;
+ simulateExamAnswerRecord.setAnswerScore(0);
+ }
+ simulateExamAnswerRecord.setAnswerResult(status);
+ //新增
+ simulateExamAnswerRecordService.save(simulateExamAnswerRecord);
}
}
--
Gitblit v1.9.3