From 832d80c13f96155264fc35ffc8b1136dbdf5946b Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 12 Aug 2021 21:38:54 +0800
Subject: [PATCH] 公司装备导入

---
 src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java |   76 ++++++++++++++++++++++++++++++++++++-
 1 files changed, 73 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 a3ae2de..30c5378 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,9 @@
 
 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;
 import org.springblade.modules.training.service.TrainingRegistrationService;
@@ -22,9 +25,9 @@
 	@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);
 	}
 
@@ -36,4 +39,71 @@
 	public TrainingRegistrationVo selectTrainingRegistrationInfo(TrainingRegistration trainingRegistration) {
 		return baseMapper.selectTrainingRegistrationInfo(trainingRegistration);
 	}
+
+	/**
+	 * 导出报名数数据
+	 * @param trainingRegistration 培训报名对象
+	 * @return
+	 */
+	@Override
+	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);
+	}
+
+	/**
+	 * 查询培训报名信息
+	 * @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