考试成绩修改状态重置

钟日健

2021-10-22 f63fff71fcd7a62ad73b0b9eda614f3b1fa3badf

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

@@ -5,17 +5,16 @@
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.AllArgsConstructor;
import org.springblade.common.utils.arg;
import org.springblade.core.log.exception.ServiceException;
import org.springblade.core.mp.support.Condition;
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;
@@ -37,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;

@@ -68,6 +64,10 @@

   @Autowired
   private IRoleService roleService;


   @Autowired
   private ExamAnswerRecordService examAnswerRecordService;

   /**
    * 自定义分页数据
@@ -248,9 +248,19 @@
         examScoreExcelList.forEach(examScoreExcel -> {
            if (null!=examScoreExcel.getLearnGrade() && null!=examScoreExcel.getIdCardNo() && examScoreExcel.getIdCardNo()!=""){
               //使用考试名称匹配考试信息
               ExamPaper examPaper = examPaperService.getExamInfoByExamName(examScoreExcel.getExamName());
//               ExamPaper examPaper = examPaperService.getExamInfoByExamName(examScoreExcel.getExamName());
               //查询出成绩数据
               ExamScore examScore = baseMapper.getExamScoreInfoByIdCardNo(examScoreExcel.getIdCardNo(),examPaper.getId());
//               ExamScore examScore = baseMapper.getExamScoreInfoByIdCardNo(examScoreExcel.getIdCardNo(),examPaper.getId());
               //根据身份证号查询用户
               User user0 = userService.getUserInfoByIdCardNo(examScoreExcel.getIdCardNo());
               if (null==user0){
                  throw new ServiceException("用户:["+examScoreExcel.getIdCardNo()+"]不存在");
               }
               ExamScore examScore1 = new ExamScore();
               examScore1.setCandidateNo(examScoreExcel.getCandidateNo());
               examScore1.setUserId(user0.getId().toString());
               //根据准考证号和用户id查询考试成绩
               ExamScore examScore = this.getOne(Condition.getQueryWrapper(examScore1));
               if (null!=examScore) {
                  //查询当前保安信息
                  UserVO user = userService.getUserAgeById(Long.parseLong(examScore.getUserId()));
@@ -259,7 +269,7 @@
                     //合格
                     examScore.setQualified(0);
                     //正式考试通过生成保安证编号
                     if (examPaper.getExamType()==1) {
//                     if (examPaper.getExamType()==1) {
                        //去生成保安证编号
                        String pre = SecurityPaperUtil.getSecurityPaper();
                        //查询当前年份已有的保安证编号
@@ -292,7 +302,7 @@
                              ",paper_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(user.getPaperTime()) + "'" +
                              " " +"where id = " + "'" + user.getId() + "'";
                        FtpUtil.sqlFileUpload(s1);
                     }
//                     }
                  } else {
                     //不合格
                     examScore.setQualified(1);
@@ -542,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;
   }
}