From 7b18a6778a4ab36ff4181ebcef1d2f747a7291c6 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 03 Aug 2021 15:45:09 +0800
Subject: [PATCH] 1.新增培训考试生成准考证号码 2.考试报名清册导入功能实现

---
 src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java |   40 ++++++++++++++++++++++++++++++++++++++++
 1 files changed, 40 insertions(+), 0 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 2c3cb68..effb09a 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,6 +3,8 @@
 
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springblade.core.mp.support.Condition;
+import org.springblade.modules.apply.entity.Apply;
 import org.springblade.modules.apply.excel.ApplyInfoExcel;
 import org.springblade.modules.training.entity.TrainingRegistration;
 import org.springblade.modules.training.mapper.TrainingRegistrationMapper;
@@ -47,4 +49,42 @@
 	public List<ApplyInfoExcel> getTrainingRegistrationExcelList(TrainingRegistrationVo trainingRegistration) {
 		return baseMapper.getTrainingRegistrationExcelList(trainingRegistration);
 	}
+
+	/**
+	 * 培训考试清册导入
+	 * @param data
+	 * @param isCovered
+	 */
+	@Override
+	public void importTrainingRegistration(List<ApplyInfoExcel> data, Boolean isCovered) {
+		data.forEach(applyInfoExcel -> {
+			//通过准考证号
+			if (null!=applyInfoExcel.getCandidateNo() && applyInfoExcel.getIdCardNo()!=""){
+				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();
+				}
+			}
+
+		});
+	}
+
+
+	/**
+	 * 查询准考证前缀相同的数量
+	 * @param result
+	 * @return
+	 */
+	@Override
+	public int getCandidateNoCount(String result) {
+		return baseMapper.getCandidateNoCount(result);
+	}
 }

--
Gitblit v1.9.3