主要管理人员，出资人员，培训查询，考试流程修改

Administrator

2021-09-30 b74f8511ee18cb0556aec293a8431752d610fec5

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

@@ -29,6 +29,7 @@
import org.springblade.modules.system.vo.UserVO;
import org.springblade.modules.training.entity.TrainingRegistration;
import org.springblade.modules.training.service.TrainingRegistrationService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@@ -47,20 +48,25 @@
 * @author zhongrj
 */
@Service
@AllArgsConstructor
public class ExamScoreServiceImpl extends ServiceImpl<ExamScoreMapper, ExamScore> implements ExamScoreService {

   private final IUserService userService;
   @Autowired
   private IUserService userService;

   private final ExamSubjectChoicesService examSubjectChoicesService;
   @Autowired
   private ExamSubjectChoicesService examSubjectChoicesService;

   private final ExamPaperService examPaperService;
   @Autowired
   private ExamPaperService examPaperService;

   private final ApplyService applyService;
   @Autowired
   private ApplyService applyService;

   private final TrainingRegistrationService trainingRegistrationService;
   @Autowired
   private TrainingRegistrationService trainingRegistrationService;

   private final IRoleService roleService;
   @Autowired
   private IRoleService roleService;

   /**
    * 自定义分页数据
@@ -446,4 +452,83 @@
      }
      return true;
   }


   /**
    * 考试重置
    * @param updateParamVo
    * @return
    */
   @Override
   public boolean refreshTrainExamInfo(UpdateParamVo updateParamVo) {
      if (null!=updateParamVo.getScoreId()){
         ExamScore examScore = this.getById(updateParamVo.getScoreId());
         //获取成绩数据，准考证号，用户id,报名培训id,考试id
         if (null!=examScore){
            ExamPaper paper = examPaperService.getById(examScore.getExamId());
            //判断考试类型
            //考试
            if (paper.getExamType()==1){
               //1.修改培训报名信息
               Apply apply = new Apply();
               apply.setId(examScore.getApplyId());
               apply.setIsExam(1);
               //修改
               applyService.updateById(apply);

               //2.修改用户考试状态
               User user = new User();
               user.setIsTrain(1);
               user.setId(Long.parseLong(examScore.getUserId()));
               //修改
               userService.updateById(user);

               //3.删除当前考试成绩信息
               this.removeById(updateParamVo.getScoreId());

               //4.内网数据同步
               String s1 =
                  "update sys_apply set is_exam = " + "'" + apply.getIsExam() + "'" +
                     " " + "where id = " + "'" + apply.getId() + "';"+
                     "update blade_user set is_train = " + "'" + user.getIsTrain() + "'" +
                     " " + "where id = " + "'" + user.getId() + "';"+
                     "delete from exam_score where id = " + "'" + updateParamVo.getScoreId() + "'";
               FtpUtil.sqlFileUpload(s1);

               return true;
            }
            //培训考试
            if (paper.getExamType()==2){
               //1.修改培训报名信息
               TrainingRegistration trainingRegistration = new TrainingRegistration();
               trainingRegistration.setId(examScore.getApplyId());
               trainingRegistration.setIsExam(1);
               //修改
               trainingRegistrationService.updateById(trainingRegistration);

               //2.修改用户考试状态
               User user = new User();
               user.setIsTrain(1);
               user.setId(Long.parseLong(examScore.getUserId()));
               //修改
               userService.updateById(user);

               //3.删除当前考试成绩信息
               this.removeById(updateParamVo.getScoreId());

               //4.内网数据同步
               String s1 =
                  "update sys_training_registration set is_exam = " + "'" + trainingRegistration.getIsExam() + "'" +
                     " " + "where id = " + "'" + trainingRegistration.getId() + "';"+
                  "update blade_user set is_train = " + "'" + user.getIsTrain() + "'" +
                     " " + "where id = " + "'" + user.getId() + "';"+
                  "delete from exam_score where id = " + "'" + updateParamVo.getScoreId() + "'";
               FtpUtil.sqlFileUpload(s1);

               return true;
            }
         }
      }
      return false;
   }
}