From 64235949c38c1e9ff9f73460e5ff222048e9c088 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Wed, 27 Oct 2021 11:35:29 +0800
Subject: [PATCH] 1.培训考试申请接口修改

---
 src/main/java/org/springblade/modules/training/controller/TrainingRegistrationController.java |   73 ++++++++++++++++++++++++++++++++++++
 1 files changed, 73 insertions(+), 0 deletions(-)

diff --git a/src/main/java/org/springblade/modules/training/controller/TrainingRegistrationController.java b/src/main/java/org/springblade/modules/training/controller/TrainingRegistrationController.java
index c06adb3..1959237 100644
--- a/src/main/java/org/springblade/modules/training/controller/TrainingRegistrationController.java
+++ b/src/main/java/org/springblade/modules/training/controller/TrainingRegistrationController.java
@@ -605,4 +605,77 @@
 		}
 		return null;
 	}
+
+
+	/**
+	 * 生成试卷,报名,考试申请
+	 * @param trainingRegistrationVo 考试开始时
+	 */
+	@PostMapping("/batchTrainExam")
+	public R batchTrainExam(@RequestBody TrainingRegistrationVo trainingRegistrationVo){
+		//查询已报名未关联试卷的人员,同步报名列表
+		String ids = trainingRegistrationVo.getIds();
+		List<String> list = Arrays.asList(ids.split(","));
+		if (list.size()>0){
+			//生成考试
+			ExamPaper examPaper = new ExamPaper();
+			//考试类型
+			examPaper.setExamType(2);
+			//考试开始时间,考试开始截止时间
+			examPaper.setStartTime(trainingRegistrationVo.getStartTime());
+			examPaper.setEndTime(trainingRegistrationVo.getEndTime());
+			Calendar instance = Calendar.getInstance();
+			instance.setTime(trainingRegistrationVo.getStartTime());
+			int year = instance.get(Calendar.YEAR);
+			int month = instance.get(Calendar.MONTH)+1;
+			int day = instance.get(Calendar.DAY_OF_MONTH);
+			String examName = year + "年" + month+ "月"+ day +"日" +"保安员证培训考试";
+			//考试名称
+			examPaper.setExamName(examName);
+			//考试申请人
+			examPaper.setCreator(trainingRegistrationVo.getCreator());
+			//待审核
+			examPaper.setAuditStatus(3);
+			//创建时间
+			examPaper.setCreatorDate(new Date());
+			//生成考试
+			examPaperService.save(examPaper);
+			//内网数据同步
+			Long sid = examPaper.getId();
+			String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getStartTime());
+			String endTimeFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getEndTime());
+			String creatorTimeFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getCreatorDate());
+			String s = "insert into ksxt_exam(id,exam_name,exam_type,start_time,end_time,creator,creator_date,audit_status) " +
+				"values(" + "'" + sid + "'" +
+				"," + "'" + examPaper.getExamName() + "'" +
+				"," + "'" + examPaper.getExamType() +"'" +
+				"," + "'" + format +"'" +
+				"," + "'" + endTimeFormat +"'" +
+				"," + "'" + examPaper.getCreator() +"'" +
+				"," + "'" + creatorTimeFormat +"'" +
+				","  +"'" + examPaper.getAuditStatus() + "'" + ")";
+			FtpUtil.sqlFileUpload(s);
+
+			//修改报名信息
+			list.forEach(id ->{
+				//根据id查询培训信息
+				TrainingRegistration trainingRegistration = trainingRegistrationService.getById(id);
+				if (trainingRegistration.getAuditStatus()==4 && trainingRegistration.getCancel()==1) {
+					if (null == trainingRegistration.getTrainExamId() || trainingRegistration.getTrainExamId() == "") {
+						trainingRegistration.setTrainExamId(examPaper.getId().toString());
+						//提交考试审核
+						trainingRegistration.setAuditStatus(3);
+						trainingRegistrationService.updateById(trainingRegistration);
+
+						String s1 =
+							"update sys_training_registration set train_exam_id = " + "'" + trainingRegistration.getTrainExamId() + "'"
+								+ ",audit_status = " + "'" + trainingRegistration.getAuditStatus() + "'"
+								+ " " + "where id = " + "'" + trainingRegistration.getId() + "'";
+						FtpUtil.sqlFileUpload(s1);
+					}
+				}
+			});
+		}
+		return null;
+	}
 }

--
Gitblit v1.9.3