From de1edfafcb3e4287ea28d1cd3096281e0f526a21 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Mon, 04 Dec 2023 19:40:44 +0800
Subject: [PATCH] 设置登录有效期

---
 src/main/java/org/springblade/modules/exam/service/impl/ScoreAuditRecordsServiceImpl.java |   45 ++++++++++++++++++++++++++++++++++++++-------
 1 files changed, 38 insertions(+), 7 deletions(-)

diff --git a/src/main/java/org/springblade/modules/exam/service/impl/ScoreAuditRecordsServiceImpl.java b/src/main/java/org/springblade/modules/exam/service/impl/ScoreAuditRecordsServiceImpl.java
index be5bf61..5c551f1 100644
--- a/src/main/java/org/springblade/modules/exam/service/impl/ScoreAuditRecordsServiceImpl.java
+++ b/src/main/java/org/springblade/modules/exam/service/impl/ScoreAuditRecordsServiceImpl.java
@@ -18,6 +18,7 @@
 import org.springblade.modules.securitypaper.service.SecurityPaperService;
 import org.springblade.modules.system.entity.User;
 import org.springblade.modules.system.service.IUserService;
+import org.springblade.modules.system.service.MyAsyncService;
 import org.springblade.modules.system.vo.UserVO;
 import org.springblade.modules.training.entity.TrainingRegistration;
 import org.springblade.modules.training.service.TrainingRegistrationService;
@@ -53,6 +54,8 @@
 
 	@Autowired
 	private SecurityPaperService securityPaperService;
+	@Autowired
+	private  MyAsyncService myAsyncService;
 
 	/**
 	 * 自定义分页
@@ -92,8 +95,15 @@
 			ExamScore examScore = examScoreService.getById(auditRecords.getExamScoreId());
 			//1.修改培训报名考试状态
 			TrainingRegistration trainingRegistration = trainingRegistrationService.getById(examScore.getApplyId());
-			//已考试
-			trainingRegistration.setIsExam(2);
+			//考试状态修改
+			if(trainingRegistration.getIsExam()==4) {
+				//考试状态修改为纸质考试
+				trainingRegistration.setIsExam(5);
+				trainingRegistration.setCancel(1);
+			}else {
+				//考试结束
+				trainingRegistration.setIsExam(2);
+			}
 			//修改
 			trainingRegistrationService.updateById(trainingRegistration);
 
@@ -135,10 +145,12 @@
 						",qualified = " + "'" + examScore.getQualified() + "'" +
 						" " + "where id = " + "'" + examScore.getId() + "';"+
 					"update sys_training_registration set is_exam = " + "'" + trainingRegistration.getIsExam() + "'" +
+						",cancel = " + "'" + trainingRegistration.getCancel() + "'" +
 						" " + "where id = " + "'" + trainingRegistration.getId() + "';"+
 					"update blade_user set is_train = " + "'" +  user.getIsTrain() + "'" +
 						" " + "where id = " + "'" + user.getId() + "'";
-				FtpUtil.sqlFileUpload(s1);
+				//FtpUtil.sqlFileUpload(s1);
+				myAsyncService.dataSync(s1);
 			} else {
 				//实操成绩不为空
 				if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
@@ -176,6 +188,7 @@
 						securityPaper.setPeopleName(user.getRealName());
 						securityPaper.setExamId(Long.parseLong(examScore.getExamId()));
 						securityPaper.setApplyId(examScore.getApplyId());
+						securityPaper.setSource(1);
 						//新增保安员证信息
 						securityPaperService.save(securityPaper);
 
@@ -190,7 +203,8 @@
 								+ "," + "'" + securityPaper.getUserId() + "'"
 								+ "," + "'" + securityPaper.getApplyId() + "'"
 								+ "," +"'" + securityPaper.getExamId() + "'" + ")";
-						FtpUtil.sqlFileUpload(s1);
+						//FtpUtil.sqlFileUpload(s1);
+						myAsyncService.dataSync(s1);
 					}
 				} else {
 					//不合格
@@ -223,13 +237,15 @@
 						",qualified = " + "'" + examScore.getQualified() + "'" +
 						" " + "where id = " + "'" + examScore.getId() + "';"+
 					"update sys_training_registration set is_exam = " + "'" + trainingRegistration.getIsExam() + "'" +
+						",cancel = " + "'" + trainingRegistration.getCancel() + "'" +
 						" " + "where id = " + "'" + trainingRegistration.getId() + "';"+
 					"update blade_user set hold = " + "'" + user.getHold() + "'" +
 						",securitynumber = " + "'" + user.getSecuritynumber() + "'" +
 						",user_type = " + "'" + user.getUserType() + "'" +
 						",is_train = " + "'" + user.getIsTrain() + "'" +
 						" " + "where id = " + "'" + user.getId() + "'";
-				FtpUtil.sqlFileUpload(s1);
+				//FtpUtil.sqlFileUpload(s1);
+				myAsyncService.dataSync(s1);
 			}
 		}
 		//审核时间
@@ -303,7 +319,8 @@
 							" " + "where id = " + "'" + trainingRegistration.getId() + "';"+
 						"update blade_user set is_train = " + "'" +  user.getIsTrain() + "'" +
 							" " + "where id = " + "'" + user.getId() + "'";
-					FtpUtil.sqlFileUpload(s1);
+					//FtpUtil.sqlFileUpload(s1);
+					myAsyncService.dataSync(s1);
 				} else {
 					//实操成绩不为空
 					if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
@@ -333,6 +350,19 @@
 							user.setHold("1");
 							//更新保安数据
 							userService.updateById(user);
+
+							//生成保安证的同时向保安证管理表中插入一条数据
+							SecurityPaper securityPaper = new SecurityPaper();
+							securityPaper.setUserId(user.getId());
+							securityPaper.setNumber(result);
+							securityPaper.setCreateTime(new Date());
+							securityPaper.setIdCardNo(user.getCardid());
+							securityPaper.setPeopleName(user.getRealName());
+							securityPaper.setExamId(Long.parseLong(examScore.getExamId()));
+							securityPaper.setApplyId(examScore.getApplyId());
+							securityPaper.setSource(1);
+							//新增保安员证信息
+							securityPaperService.save(securityPaper);
 
 //						String s1 =
 //							"update blade_user set hold = " + "'" + user.getHold() + "'" +
@@ -378,7 +408,8 @@
 							",user_type = " + "'" + user.getUserType() + "'" +
 							",is_train = " + "'" + user.getIsTrain() + "'" +
 							" " + "where id = " + "'" + user.getId() + "'";
-					FtpUtil.sqlFileUpload(s1);
+					//FtpUtil.sqlFileUpload(s1);
+					myAsyncService.dataSync(s1);
 				}
 			}
 			//审核时间

--
Gitblit v1.9.3