From feba1c5df4ab7ac0313b91d9cb552a12997abfc6 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Mon, 23 Aug 2021 18:21:11 +0800
Subject: [PATCH] 考试，培训考试，成绩数据同步
---
src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java | 30 +++++++++++++++++++++++++++---
1 files changed, 27 insertions(+), 3 deletions(-)
diff --git a/src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java b/src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java
index 59bc92a..325f969 100644
--- a/src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java
+++ b/src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java
@@ -6,6 +6,7 @@
import lombok.AllArgsConstructor;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.tool.api.R;
+import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.apply.entity.Apply;
import org.springblade.modules.apply.excel.ApplyInfoExcel;
import org.springblade.modules.system.entity.User;
@@ -20,6 +21,7 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
@@ -75,9 +77,8 @@
if (data.size()>0){
data.forEach(trainingRegistrationExcel -> {
TrainingRegistration trainingRegistration = new TrainingRegistration();
- //通过准考证号
+ //通过身份证号
if (null!=trainingRegistrationExcel.getIdCardNo() && trainingRegistrationExcel.getIdCardNo()!=""){
- trainingRegistration.setCandidateNo(trainingRegistrationExcel.getIdCardNo());
User user = userService.getUserInfoByIdCardNo(trainingRegistrationExcel.getIdCardNo());
trainingRegistration.setUserId(user.getId().toString());
@@ -94,8 +95,11 @@
//修改保安报名状态
user.setIsTrain(1);
userService.updateById(user);
+ //数据同步
+ saveTrainingRegistration(trainingRegistration,user);
+
}else {
- if (2 == user.getIsTrain()) {
+ if (user.getIsTrain()!=1) {
trainingRegistration.setIsExam(1);
trainingRegistration.setCancel(1);
trainingRegistration.setTrainingTime(new Date());
@@ -104,6 +108,9 @@
//修改保安报名状态
user.setIsTrain(1);
userService.updateById(user);
+
+ //数据同步
+ saveTrainingRegistration(trainingRegistration,user);
}
}
}
@@ -111,6 +118,23 @@
}
}
+ /**
+ * 报名
+ */
+ private void saveTrainingRegistration(TrainingRegistration trainingRegistration,User user1){
+ String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
+ Long id = trainingRegistration.getId();
+ String s = "insert into sys_training_registration(id,training_unit_id,training_time,cancel,user_id,is_exam) " +
+ "values(" + "'" + id + "'"
+ + "," + "'" + trainingRegistration.getTrainingUnitId() +"'"
+ + "," + "'" + formatStr +"'"
+ + "," + "'" + trainingRegistration.getCancel() + "'"
+ + "," + "'" + trainingRegistration.getUserId() + "'"
+ + "," +"'" + trainingRegistration.getIsExam() + "'" + ");" +
+ "update blade_user set is_train = " + user1.getIsTrain() + " " +"where id = " + "'" + user1.getId() + "'";
+ FtpUtil.sqlFileUpload(s);
+ }
+
/**
* 查询准考证前缀相同的数量
--
Gitblit v1.9.3