智慧保安后台管理-外网
Administrator
2022-06-10 1726249dfc5b9e925ef360ec457453de72a209e8
去除考试成绩再外网保存
3 files modified
24 ■■■■ changed files
src/main/java/org/springblade/modules/apply/controller/ApplyController.java 1 ●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java 17 ●●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java 6 ●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/apply/controller/ApplyController.java
@@ -742,7 +742,6 @@
                "," + "'" + examScore.getUserId() + "'" +
                "," + "'" + examScore.getExamId() + "'" +
                "," + "'" + examScore.getApplyId() + "'" + ")";
            //FtpUtil.sqlFileUpload(s);
            myAsyncService.FTP(s);
        }
        return examScore;
src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java
@@ -2,6 +2,7 @@
import com.alibaba.excel.EasyExcel;
import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import io.swagger.annotations.ApiOperation;
@@ -20,11 +21,13 @@
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.FTP.Monitor;
import org.springblade.modules.FTP.Result;
import org.springblade.modules.exam.entity.ExamAnswerRecord;
import org.springblade.modules.exam.entity.ExamPaper;
import org.springblade.modules.exam.entity.ExamScore;
import org.springblade.modules.exam.excel.ExamScoreExcel;
import org.springblade.modules.exam.excel.ExamScoreImporter;
import org.springblade.modules.exam.excel.ExportExamScoreExcel;
import org.springblade.modules.exam.service.ExamAnswerRecordService;
import org.springblade.modules.exam.service.ExamPaperService;
import org.springblade.modules.exam.service.ExamScoreService;
import org.springblade.modules.exam.util.SecurityPaperUtil;
@@ -70,6 +73,9 @@
    private final MyAsyncService myAsyncService;
    private final RedisTemplate redisTemplate;
    private final ExamAnswerRecordService examAnswerRecordService;
    /**
     * 自定义分页
@@ -377,6 +383,17 @@
    public R<ExamScore> detail(ExamScore examScore) {
        //查询考试成绩详情
        ExamScore detail = examScoreService.getOne(Condition.getQueryWrapper(examScore));
        //计算成绩
        ExamAnswerRecord record = new ExamAnswerRecord();
        record.setScoreId(detail.getId());
        List<ExamAnswerRecord> list = examAnswerRecordService.list(new QueryWrapper<>(record));
        int num = 0;
        if (list.size()>0){
            for (ExamAnswerRecord examAnswerRecord : list) {
                num = num + examAnswerRecord.getAnswerScore();
            }
        }
        detail.setTheoryGrade(num);
        //返回
        return R.data(detail);
    }
src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java
@@ -236,7 +236,7 @@
                examScore.setQualified(1);
            }
            //修改成绩数据
            int i = baseMapper.updateById(examScore);
//            int i = baseMapper.updateById(examScore);
            String s1 =
                "update exam_score set exam_id = " + examScore.getExamId() +
@@ -248,10 +248,10 @@
            //FtpUtil.sqlFileUpload(s1);
            myAsyncService.FTP(s1);
            if (i > 0) {
//            if (i > 0) {
                //返回结果
                return true;
            }
//            }
        }
        //返回结果
        return false;