From b74f8511ee18cb0556aec293a8431752d610fec5 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 30 Sep 2021 17:03:25 +0800
Subject: [PATCH] 主要管理人员,出资人员,培训查询,考试流程修改

---
 src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java |   99 ++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 92 insertions(+), 7 deletions(-)

diff --git a/src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java b/src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java
index db2a437..884a13b 100644
--- a/src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java
+++ b/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;
+	}
 }

--
Gitblit v1.9.3