考试成绩修改状态重置

钟日健

2021-10-22 f63fff71fcd7a62ad73b0b9eda614f3b1fa3badf

 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;
   }
}