智慧保安后台管理-外网项目备份
zhongrj
2023-11-06 ba65fbde975845fd84212f853bb640c1e07e5d02
答题下一题接口修改
1 files modified
93 ■■■■■ changed files
src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java 93 ●●●●● patch | view | raw | blame | history
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,40 +372,66 @@
     * @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);
        // 判断是否修改了答案
        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 {
        //内网数据同步...
        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);
            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);
        }
    }
    /**