From 733edfcd6ad1c38dcf4aa761a417f4e4bfd754b2 Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Fri, 27 Aug 2021 11:05:44 +0800
Subject: [PATCH] 1.许可审批
---
src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java | 117 ++++++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 97 insertions(+), 20 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 effb09a..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
@@ -3,16 +3,26 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+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;
+import org.springblade.modules.system.service.IUserDeptService;
+import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.training.entity.TrainingRegistration;
+import org.springblade.modules.training.excel.TrainingRegistrationExcel;
import org.springblade.modules.training.mapper.TrainingRegistrationMapper;
import org.springblade.modules.training.service.TrainingRegistrationService;
import org.springblade.modules.training.util.LongTimeUtil;
import org.springblade.modules.training.vo.TrainingRegistrationVo;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import java.text.SimpleDateFormat;
+import java.util.Date;
import java.util.List;
/**
@@ -20,14 +30,20 @@
* @author zhongrj
*/
@Service
+@AllArgsConstructor
public class TrainingRegistrationServiceImpl extends ServiceImpl<TrainingRegistrationMapper, TrainingRegistration> implements TrainingRegistrationService {
+
+ private final IUserService userService;
+
+ private final IUserDeptService userDeptService;
+
@Override
public IPage<TrainingRegistrationVo> selectTrainingRegistrationPage(IPage<TrainingRegistrationVo> page, TrainingRegistrationVo trainingRegistration) {
List<TrainingRegistrationVo> trainingRegistrationVos = baseMapper.selectTrainingRegistrationPage(page, trainingRegistration);
- trainingRegistrationVos.forEach(trainingRegistrationVo -> {
- trainingRegistrationVo.setRemainingTime(LongTimeUtil.getDistanceTime(trainingRegistrationVo.getTrainExamTime().getTime(), System.currentTimeMillis()));
- });
+// trainingRegistrationVos.forEach(trainingRegistrationVo -> {
+// trainingRegistrationVo.setRemainingTime(LongTimeUtil.getDistanceTime(trainingRegistrationVo.getTrainExamTime().getTime(), System.currentTimeMillis()));
+// });
return page.setRecords(trainingRegistrationVos);
}
@@ -56,25 +72,67 @@
* @param isCovered
*/
@Override
- public void importTrainingRegistration(List<ApplyInfoExcel> data, Boolean isCovered) {
- data.forEach(applyInfoExcel -> {
- //通过准考证号
- if (null!=applyInfoExcel.getCandidateNo() && applyInfoExcel.getIdCardNo()!=""){
+ @Transactional(rollbackFor = Exception.class)
+ public void importTrainingRegistration(List<TrainingRegistrationExcel> data, Boolean isCovered) {
+ if (data.size()>0){
+ data.forEach(trainingRegistrationExcel -> {
TrainingRegistration trainingRegistration = new TrainingRegistration();
- trainingRegistration.setCandidateNo(applyInfoExcel.getCandidateNo());
- //查询报名信息
- TrainingRegistration trainingRegistration1 = baseMapper.selectOne(Condition.getQueryWrapper(trainingRegistration));
- trainingRegistration1.setIsExam(2);
- baseMapper.updateById(trainingRegistration1);
- //内网新增
- try {
-// arg.test01(arg.url+"/apply/update",apply1);
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
+ //通过身份证号
+ if (null!=trainingRegistrationExcel.getIdCardNo() && trainingRegistrationExcel.getIdCardNo()!=""){
+ User user = userService.getUserInfoByIdCardNo(trainingRegistrationExcel.getIdCardNo());
+ trainingRegistration.setUserId(user.getId().toString());
- });
+ //通过培训公司查组织机构id
+ if (null!=trainingRegistrationExcel.getDeptName() && trainingRegistrationExcel.getDeptName()!=""){
+ trainingRegistration.setTrainingUnitId(userDeptService.selectIn(trainingRegistrationExcel.getDeptName()));
+ }
+ if(null==user.getIsTrain()){
+ trainingRegistration.setIsExam(1);
+ trainingRegistration.setCancel(1);
+ trainingRegistration.setTrainingTime(new Date());
+ //新增报名
+ this.save(trainingRegistration);
+ //修改保安报名状态
+ user.setIsTrain(1);
+ userService.updateById(user);
+ //数据同步
+ saveTrainingRegistration(trainingRegistration,user);
+
+ }else {
+ if (user.getIsTrain()!=1) {
+ trainingRegistration.setIsExam(1);
+ trainingRegistration.setCancel(1);
+ trainingRegistration.setTrainingTime(new Date());
+ //新增报名
+ this.save(trainingRegistration);
+ //修改保安报名状态
+ user.setIsTrain(1);
+ userService.updateById(user);
+
+ //数据同步
+ saveTrainingRegistration(trainingRegistration,user);
+ }
+ }
+ }
+ });
+ }
+ }
+
+ /**
+ * 报名
+ */
+ 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);
}
@@ -87,4 +145,23 @@
public int getCandidateNoCount(String result) {
return baseMapper.getCandidateNoCount(result);
}
+
+ /**
+ * 查询培训报名信息
+ * @param trainingRegistration 培训报名对象信息
+ * @return
+ */
+ @Override
+ public Integer getTrainingRegistrationInfo(TrainingRegistration trainingRegistration) {
+ return baseMapper.getTrainingRegistrationInfo(trainingRegistration);
+ }
+
+ /**
+ * 查询已报名培训公司未关联考试的人员
+ * @return
+ */
+ @Override
+ public List<Long> getTrainIds() {
+ return baseMapper.getTrainIds();
+ }
}
--
Gitblit v1.9.3