答题下一题接口修改

zhongrj

2023-11-06 ba65fbde975845fd84212f853bb640c1e07e5d02

 src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java

@@ -1,6 +1,7 @@

package org.springblade.modules.exam.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.modules.FTP.FtpUtil;
@@ -371,6 +372,31 @@
    * @param result       答题是否正确
    */
   private void saveExamAns(ExamSubjectChoices choices, Long preSubJectId, String preResult, Long scoreId, boolean result) {
      // 判断是否修改了答案
      QueryWrapper<ExamAnswerRecord> wrapper = new QueryWrapper<>();
      wrapper.eq("score_id",scoreId)
         .eq("subject_choices_id",preSubJectId);
      ExamAnswerRecord one = examAnswerRecordService.getOne(wrapper);
      if (null!=one){
         // 更新
         one.setAnswerOption(preResult);
         one.setAnswer(choices.getAnswer());
         one.setSubjectChoicesType(choices.getChoicesType());
         one.setAnswerTime(new Date());
         int status = 0;
         //判断题逻辑
         if (result) {
            status = 1;
            one.setAnswerScore(choices.getScore());
         } else {
            status = 2;
            one.setAnswerScore(0);
         }
         one.setAnswerResult(status);
         //修改
         examAnswerRecordService.updateById(one);
      }else {

      ExamAnswerRecord examAnswerRecord = new ExamAnswerRecord();
      examAnswerRecord.setScoreId(scoreId);
      examAnswerRecord.setAnswerOption(preResult);
@@ -390,21 +416,22 @@
      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);
//
//         //内网数据同步...
//         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);
      }
   }

   /**