考试成绩修改状态重置

钟日健

2021-10-22 f63fff71fcd7a62ad73b0b9eda614f3b1fa3badf

考试成绩修改状态重置

 src/main/java/org/springblade/modules/exam/controller/ExamScoreController.java

@@ -413,4 +413,14 @@
        //导出成绩集合数据
        ExcelUtil.export(response, "成绩数据", "成绩数据表", examScoreExcels, ExportExamScoreExcel.class);
    }


    /**
     * 考试成绩恢复状态重置（重考）
     * @param
     */
    @GetMapping("/refreshTrainExamScore")
    public R refreshTrainExamScore() {
        return R.status(examScoreService.refreshTrainExamScore());
    }
}

 src/main/java/org/springblade/modules/exam/service/ExamScoreService.java

@@ -82,4 +82,12 @@
     * @return
     */
    List<ExportExamScoreExcel> exportExamScoreList(ExamScoreVO examScoreVO);


    /**
     * 考试状态修改,考试成绩恢复
     * @param
     * @return
     */
    Boolean refreshTrainExamScore();
}

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

@@ -10,13 +10,11 @@
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.apply.entity.Apply;
import org.springblade.modules.apply.service.ApplyService;
import org.springblade.modules.exam.entity.ExamExaminationSubject;
import org.springblade.modules.exam.entity.ExamPaper;
import org.springblade.modules.exam.entity.ExamScore;
import org.springblade.modules.exam.entity.ExamSubjectChoices;
import org.springblade.modules.exam.entity.*;
import org.springblade.modules.exam.excel.ExamScoreExcel;
import org.springblade.modules.exam.excel.ExportExamScoreExcel;
import org.springblade.modules.exam.mapper.ExamScoreMapper;
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.service.ExamSubjectChoicesService;
@@ -38,10 +36,7 @@
import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.*;

import static com.bstek.ureport.expression.model.condition.Join.and;

@@ -69,6 +64,10 @@

    @Autowired
    private IRoleService roleService;


    @Autowired
    private ExamAnswerRecordService examAnswerRecordService;

    /**
     * 自定义分页数据
@@ -553,4 +552,68 @@
    public List<ExportExamScoreExcel> exportExamScoreList(ExamScoreVO examScoreVO) {
        return baseMapper.getExamScoreList(examScoreVO);
    }


    /**
     * 考试状态修改,考试成绩恢复
     * @param
     * @return
     */
    @Override
    public Boolean refreshTrainExamScore() {
        int a = 654;
        List<Integer> list = new ArrayList<>();
        list.add(a);
        while (a>=654 && a<=702){
            a++;
            list.add(a);
        }
        //遍历集合
        list.forEach(b->{
            //查询考试记录
            if (b!=698) {
                ExamAnswerRecord examAnswerRecord = new ExamAnswerRecord();
                examAnswerRecord.setScoreId(Long.parseLong(b.toString()));
                //查询考试成绩
                ExamScore examScore = this.getById(b);
                //查询考试记录
                List<ExamAnswerRecord> examAnswerRecords = examAnswerRecordService.list(Condition.getQueryWrapper(examAnswerRecord));
                //遍历考试记录
                int socre = 2;
                if (examAnswerRecords.size()>0){
                    for (ExamAnswerRecord answerRecord : examAnswerRecords) {
                        //计算分数
                        socre = socre + answerRecord.getAnswerScore();
                    }
                    //修改考试成绩
                    examScore.setTheoryGrade(socre);
                    examScore.setAllGrade(socre/2);
                    String endDate = "2021-10-16 15:30:25";
                    try {
                        examScore.setExamEndTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(endDate));
                    } catch (ParseException e) {
                        e.printStackTrace();
                    }
                    if (socre>=60){
                        examScore.setQualified(2);
                    }else {
                        examScore.setQualified(1);
                    }
                    //更新数据
                    this.updateById(examScore);

                    //修改培训考试状态
                    User user = new User();
                    user.setId(Long.parseLong(examScore.getUserId()));
                    user.setIsTrain(3);
                    userService.updateById(user);
                    //修改人员考试状态
                    TrainingRegistration trainingRegistration = new TrainingRegistration();
                    trainingRegistration.setId(examScore.getApplyId());
                    trainingRegistration.setIsExam(2);
                }
            }
        });
        return false;
    }
}