From 8b375fe00a241b3a769b82fe3dac8d1c9dce8a02 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 16 Jun 2022 14:36:07 +0800
Subject: [PATCH] 模拟考试修改
---
src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java | 440 ++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 357 insertions(+), 83 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 ce6644c..4b51b08 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
@@ -1,32 +1,50 @@
package org.springblade.modules.training.service.impl;
+import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.AllArgsConstructor;
+import org.apache.commons.lang3.StringUtils;
+import org.springblade.common.constant.AgeUtil;
+import org.springblade.common.utils.IdCardNoUtil;
+import org.springblade.core.log.exception.ServiceException;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.tool.api.R;
+import org.springblade.core.tool.utils.BeanUtil;
import org.springblade.modules.FTP.FtpUtil;
+import org.springblade.modules.FTP.Monitor;
+import org.springblade.modules.FTP.Result;
+import org.springblade.modules.absentrecords.entity.AbsentRecords;
+import org.springblade.modules.absentrecords.service.AbsentRecordsService;
import org.springblade.modules.apply.entity.Apply;
import org.springblade.modules.apply.excel.ApplyInfoExcel;
+import org.springblade.modules.exam.entity.ExamAnswerRecord;
import org.springblade.modules.exam.entity.ExamPaper;
+import org.springblade.modules.exam.entity.ExamScore;
+import org.springblade.modules.exam.service.ExamAnswerRecordService;
import org.springblade.modules.exam.service.ExamPaperService;
+import org.springblade.modules.exam.service.ExamScoreService;
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.system.service.MyAsyncService;
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.beans.factory.annotation.Autowired;
+import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.text.DecimalFormat;
+import java.text.ParseException;
import java.text.SimpleDateFormat;
-import java.util.Date;
-import java.util.List;
+import java.util.*;
+import java.util.concurrent.atomic.AtomicBoolean;
/**
* 报名培训服务实现类
@@ -42,6 +60,18 @@
private final ExamPaperService examPaperService;
+ private final AbsentRecordsService absentRecordsService;
+
+ private final ExamScoreService examScoreService;
+
+ private final RedisTemplate redisTemplate;
+
+
+ @Autowired
+ private MyAsyncService myAsyncService;
+
+ @Autowired
+ private ExamAnswerRecordService examAnswerRecordService;
@Override
public IPage<TrainingRegistrationVo> selectTrainingRegistrationPage(IPage<TrainingRegistrationVo> page, TrainingRegistrationVo trainingRegistration) {
@@ -70,7 +100,7 @@
* @return
*/
@Override
- public List<ApplyInfoExcel> getTrainingRegistrationExcelList(TrainingRegistrationVo trainingRegistration) {
+ public List<TrainingRegistrationExcel> getTrainingRegistrationExcelList(TrainingRegistrationVo trainingRegistration) {
return baseMapper.getTrainingRegistrationExcelList(trainingRegistration);
}
@@ -81,92 +111,170 @@
*/
@Override
@Transactional(rollbackFor = Exception.class)
- public void importTrainingRegistration(List<TrainingRegistrationExcel> data, Boolean isCovered,Long examId) {
+ public void importTrainingRegistration(List<TrainingRegistrationExcel> data, Boolean isCovered,String deptId) {
+ //需要推送内网的保安员信息集合
+ List<TrainingRegistration> trainingRegistrationList = new ArrayList<>();
+ //年龄不符的保安员信息存入集合
+ List<String> ageErrorList = new ArrayList<>();
+ List<String> cardErrorList = new ArrayList<>();
+ AtomicBoolean ageStatus = new AtomicBoolean(true);
+ AtomicBoolean cardStatus = new AtomicBoolean(true);
if (data.size()>0){
- data.forEach(trainingRegistrationExcel -> {
- TrainingRegistration trainingRegistration = new TrainingRegistration();
- //通过身份证号
- 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());
- trainingRegistration.setAuditStatus(3);
- //如果examId不为空
- if (null!=examId){
- //查询考试信息
- ExamPaper examPaper = examPaperService.getById(examId);
- trainingRegistration.setTrainExamId(examId.toString());
- //审核通过
- if (examPaper.getAuditStatus()==1){
- //生成准考证号
- trainingRegistration.setCandidateNo(getCandidateNo(trainingRegistration));
- trainingRegistration.setAuditStatus(1);
- }
- //考试审核不通过
- if (examPaper.getAuditStatus()==2){
- trainingRegistration.setAuditStatus(2);
- }
- //考试待审核
- if (examPaper.getAuditStatus()==3){
- trainingRegistration.setAuditStatus(3);
- }
+ for (TrainingRegistrationExcel trainingRegistrationExcel : data) {
+ //判断是否为当前单位
+ String deptIds = userDeptService.selectIn(trainingRegistrationExcel.getDeptName());
+ if (null!=deptIds && !deptIds.equals("")) {
+ if (null != deptId && !deptId.equals("")) {
+ if (!deptId.equals(deptIds)) {
+ throw new ServiceException("导入失败!不能给予不是本公司的保安员报名!");
}
- //新增报名
- this.save(trainingRegistration);
+ }
+ }else {
+ //如果deptIds 为空，则说明还没有改公司
+ throw new ServiceException("导入失败!公司名:["+trainingRegistrationExcel.getDeptName()+"]不存在!");
+ }
- //修改保安报名状态
- user.setIsTrain(1);
- userService.updateById(user);
- //数据同步
- saveTrainingRegistration(trainingRegistration,user);
+ //身份证校验
+ if (null==trainingRegistrationExcel.getIdCardNo() || trainingRegistrationExcel.getIdCardNo().equals("")){
+ throw new ServiceException("导入失败!身份证号码不能为空!");
+ }
+ //姓名校验
+ if (null==trainingRegistrationExcel.getRealName() || trainingRegistrationExcel.getRealName().equals("")){
+ throw new ServiceException("导入失败!姓名不能为空!");
+ }
+ if (null!=trainingRegistrationExcel.getIdCardNo() && !trainingRegistrationExcel.getIdCardNo().equals("")){
+ //去除所有空格
+ String cardid = trainingRegistrationExcel.getIdCardNo().replaceAll(" ", "");
+ //校验
+ boolean b = IdCardNoUtil.checkIdCardNo(cardid);
+ if(!b){
+ cardStatus.set(false);
+ cardErrorList.add(trainingRegistrationExcel.getIdCardNo());
+ continue;
+ }
+ }
+
+ //计算年龄
+ Integer age = AgeUtil.idCardToAge(trainingRegistrationExcel.getIdCardNo());
+
+ //判断年龄
+ if (age<18 || age>60) {
+ ageStatus.set(false);
+ ageErrorList.add(trainingRegistrationExcel.getIdCardNo());
+ continue;
+ }
+
+ //向内网推送数据
+ //生成随机数
+ String uuid = UUID.randomUUID().toString();
+ //创建培训对象
+ TrainingRegistration trainingRegistration = new TrainingRegistration();
+ trainingRegistration.setName(trainingRegistrationExcel.getRealName());
+ trainingRegistration.setDeptId(Long.parseLong(deptId));
+ trainingRegistration.setIdCardNo(trainingRegistrationExcel.getIdCardNo());
+ //已报名
+ trainingRegistration.setCancel(1);
+ //默认为未考试状态
+ trainingRegistration.setIsExam(1);
+ //未提交考试审核
+ trainingRegistration.setAuditStatus(4);
+ trainingRegistration.setTrainingTime(new Date());
+ //将 user 存入 redis
+ redisTemplate.opsForValue().set(uuid, JSON.toJSONString(trainingRegistration));
+ //trainingRegistration 临时设置uuid 到 AcademicUrl字段
+ trainingRegistration.setAcademicUrl(uuid);
+ //加入集合
+ trainingRegistrationList.add(trainingRegistration);
+ }
+
+ Result result = new Result();
+ //培训批量插入
+ if (trainingRegistrationList.size()>0) {
+ //生成随机数
+ String uuid = UUID.randomUUID().toString();
+ //数据推送
+ Map<String, Object> map = new HashMap<>(1);
+ map.put(uuid, trainingRegistrationList);
+// myAsyncService.FTPObjectTrianList(map);
+
+ int count = 0;
+ //调用ftp获取返回数据
+ while (true){
+ try {
+ Thread.sleep(1000);
+ } catch (InterruptedException e) {
+ e.printStackTrace();
+ }
+ //调用ftp获取返回数据
+ result = Monitor.getFtpDataByUuidList(uuid);
+ //如果返回true,就退处
+ if (result.getCode() == 200) {
+ break;
}else {
- if (user.getIsTrain()!=1) {
- trainingRegistration.setIsExam(1);
- trainingRegistration.setCancel(1);
- trainingRegistration.setTrainingTime(new Date());
- //如果examId不为空
- if (null!=examId){
- //查询考试信息
- ExamPaper examPaper = examPaperService.getById(examId);
- trainingRegistration.setTrainExamId(examId.toString());
- //审核通过
- if (examPaper.getAuditStatus()==1){
- //生成准考证号
- trainingRegistration.setCandidateNo(getCandidateNo(trainingRegistration));
- }
- }
- //新增报名
- this.save(trainingRegistration);
- //修改保安报名状态
- user.setIsTrain(1);
- userService.updateById(user);
-
- //数据同步
- saveTrainingRegistration(trainingRegistration,user);
+ count++;
+ if (count == 30) {
+ break;
}
}
}
- });
+ }
+
+// if (null!=result){
+// //获取 result
+// List<Result> data1 = result.getData();
+// if (data1.size()>0){
+// for (Result result1 : data1) {
+// // 取出 Msg ,此 msg 存的对应的 uuid
+// String uuid = result1.getMsg();
+// // 从redis 中获取对应的用户信息
+// User user = handlerUserInfo(uuid);
+// if (result1.getCode()==200){
+// user.setId(result1.getUserId());
+// this.save(user);
+// }
+// if (result1.getCode()==201){
+// user.setId(result1.getUserId());
+// user.setCreateTime(null);
+// this.updateById(user);
+// }
+// if (result1.getCode()==202){
+// status.set(false);
+// //已在其他单位存在
+// errorList.add(user.getCardid());
+// }
+// if (result1.getCode()==203){
+// securityInvalidStatus.set(false);
+// //保安证编号不匹配
+// securityInvalidList.add(user.getCardid());
+// }
+// }
+// }
+// }
+ //如果所有数据导入有一个异常
+ StringBuilder errorBuilder = new StringBuilder();
+ if (!ageStatus.get()){
+ String errorAccount = StringUtils.join(ageErrorList, "\\\n");
+ errorBuilder.append("保安员:[" + errorAccount + "]报名失败!年龄不符,报名年龄为[18-60]周岁!");
+ }
+ if (!cardStatus.get()){
+ String errorAccount = StringUtils.join(cardErrorList, "\\\n");
+ errorBuilder.append("用户:[" + errorAccount + "]导入失败!身份证号码不正确,请核对!");
+ }
+ //抛出异常
+ if (errorBuilder.length()>0){
+ throw new ServiceException(errorBuilder.toString());
+ }
}
}
/**
* 生成准考证号码
- * @param trainingRegistration 考试报名信息对象
+ * @param examPaper 考试报名信息对象
*/
- private String getCandidateNo(TrainingRegistration trainingRegistration) {
+ private String getCandidateNo(ExamPaper examPaper) {
//获取考试信息
- ExamPaper examPaper = examPaperService.getById(trainingRegistration.getTrainExamId());
if (null!=examPaper.getStartTime()){
String format = new SimpleDateFormat("yyyy-MM-dd").format(examPaper.getStartTime());
String year = format.substring(2,4);
@@ -189,6 +297,8 @@
}
if (month<=9){
months = "0" + month;
+ }else {
+ months = String.valueOf(month);
}
if (day<=9){
days = "0" + day;
@@ -203,8 +313,8 @@
type = "m";
}
//获取考试名称前缀,去除数字，字母
- String examName
- = examPaper.getExamName().replaceAll("\\s*", "").replaceAll("[^(\\u4e00-\\u9fa5)]", "").substring(0,1);
+// String examName
+// = examPaper.getExamName().replaceAll("\\s*", "").replaceAll("[^(\\u4e00-\\u9fa5)]", "").substring(0,1);
//前缀 = 年的最后两位 + 月份（两位） + 考试名称（中文拼音）首字母（去除数字，字母） + 考试类型 + 季度拼音首字母大写（春季就是 C）
// String result = year
@@ -214,19 +324,19 @@
// + quarter;
//前缀 = 年的最后两位 + 月份（两位） + 日 （两位） + 考试类型 正式考试 z 模拟考试 m
- String result = year
+ String pre = year
+ months
+ days
+ type;
- //查询是当前前缀已生成的数量
- int count = this.getCandidateNoCount(result);
- if (count==0){
- return result + "0000";
- }
+ //查询是当前前缀已生成准考证号码最大的一位
+ int count = examPaperService.getCandidateNoCount(pre);
+ String result = null;
//格式化
DecimalFormat decimalFormat = new DecimalFormat("0000");
+ count++;
+ result = pre + (decimalFormat.format(count));
//返回
- return result + (decimalFormat.format(count++));
+ return result;
}
return null;
}
@@ -246,7 +356,8 @@
+ "," + "'" + trainingRegistration.getIsExam() + "'"
+ "," +"'" + trainingRegistration.getAuditStatus() + "'" + ");" +
"update blade_user set is_train = " + user1.getIsTrain() + " " +"where id = " + "'" + user1.getId() + "'";
- FtpUtil.sqlFileUpload(s);
+ //FtpUtil.sqlFileUpload(s);
+ myAsyncService.FTP(s);
}
@@ -280,4 +391,167 @@
trainingRegistrationVo.setSerialEnd(trainingRegistrationVo.getSerialEnd() -trainingRegistrationVo.getSerialStart());
return baseMapper.getTrainIds(trainingRegistrationVo);
}
+
+ /**
+ * 自动处理之前报了名，申请了考试又没有去考试的，做缺考标记，并将报名状态修改为已取消报名
+ */
+ @Override
+ public void examApplyStatus() {
+ //封装条件
+ TrainingRegistration trainingRegistration = new TrainingRegistration();
+ trainingRegistration.setCancel(1);
+ trainingRegistration.setAuditStatus(1);
+ trainingRegistration.setIsExam(1);
+ //查询考试申请审核通过，已报名，未考试的人员
+ List<TrainingRegistration> trainingRegistrationList = baseMapper.selectTrainingRegistrationList(trainingRegistration);
+ if (trainingRegistrationList.size()>0) {
+ trainingRegistrationList.forEach(trainingRegistration1 -> {
+ //判断时间
+ //查询考试信息
+ ExamPaper paper = examPaperService.getById(trainingRegistration1.getTrainExamId());
+ if (null!=paper) {
+ //比对考试结束时间
+ Date now = new Date();
+ Date exanEndTime = paper.getEndTime();
+ //考试截止时间小于当前时间，说明已过考试时间
+ if (exanEndTime.before(now)) {
+ //修改报名状态
+ trainingRegistration1.setCancel(1);
+ //缺考标记
+ trainingRegistration1.setIsExam(4);
+ this.updateById(trainingRegistration1);
+ //修改保安报名状态
+ User user = userService.getById(trainingRegistration1.getUserId());
+ if (null != user) {
+ //考试结束
+ user.setIsTrain(3);
+ userService.updateById(user);
+ //生成缺考记录
+ AbsentRecords absentRecords = new AbsentRecords();
+ absentRecords.setUserId(user.getId());
+ absentRecords.setApplyId(trainingRegistration1.getId());
+ absentRecords.setExamId(Long.parseLong(trainingRegistration1.getTrainExamId()));
+ absentRecords.setCandidateNo(trainingRegistration1.getCandidateNo());
+ absentRecords.setCreateTime(new Date());
+ //新增
+ absentRecordsService.save(absentRecords);
+
+ //新增成绩，成绩为0
+ ExamScore examScore = new ExamScore();
+ examScore.setCandidateNo(trainingRegistration1.getCandidateNo());
+ examScore.setTheoryGrade(0);
+ examScore.setAllGrade(0);
+ examScore.setQualified(3);
+ examScore.setUserId(user.getId().toString());
+ examScore.setApplyId(trainingRegistration1.getId());
+ examScore.setExamId(trainingRegistration1.getTrainExamId());
+ //新增
+ examScoreService.save(examScore);
+
+ //内网同步
+ String s =
+ "update sys_training_registration set cancel = " + trainingRegistration1.getCancel() +
+ ",is_exam = " + "'" + trainingRegistration1.getIsExam() + "'" +
+ " " + "where id = " + "'" + trainingRegistration1.getId() + "';" +
+ "update blade_user set is_train = " + user.getIsTrain() + " " + "where id = " + "'" + user.getId() + "';" +
+ "insert into sys_absent_records(id,user_id,create_time,exam_id,apply_id,candidate_no) " +
+ "values(" + "'" + absentRecords.getId() + "'" + ","
+ + "'" + absentRecords.getUserId() + "'" + ","
+ + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(absentRecords.getCreateTime()) + "'" + ","
+ + "'" + absentRecords.getExamId() + "'" + ","
+ + "'" + absentRecords.getApplyId() + "'" + ","
+ + "'" + absentRecords.getCandidateNo() + "'" + ");" +
+ "insert into exam_score(id,candidate_no,theory_grade,all_grade,qualified,user_id,apply_id,exam_id) " +
+ "values(" + "'" + examScore.getId() + "'" + ","
+ + "'" + examScore.getCandidateNo() + "'" + ","
+ + "'" + examScore.getTheoryGrade() + "'" + ","
+ + "'" + examScore.getAllGrade() + "'" + ","
+ + "'" + examScore.getQualified() + "'" + ","
+ + "'" + examScore.getUserId() + "'" + ","
+ + "'" + examScore.getApplyId() + "'" + ","
+ + "'" + examScore.getExamId() + "'" + ")";
+ myAsyncService.FTP(s);
+ }
+ }
+ }
+ });
+ }
+ }
+
+ /**
+ * 定时任务处理考试中的
+ */
+ @Override
+ public void examLoading() {
+ //封装条件
+ TrainingRegistration trainingRegistration = new TrainingRegistration();
+ trainingRegistration.setCancel(1);
+ trainingRegistration.setAuditStatus(1);
+ trainingRegistration.setIsExam(3);
+ //查询考试申请审核通过，已报名，未考试的人员
+ List<TrainingRegistration> trainingRegistrationList = baseMapper.selectTrainingRegistrationList(trainingRegistration);
+ if (trainingRegistrationList.size()>0){
+ //遍历
+ trainingRegistrationList.forEach(trainingRegistration1 -> {
+ //修改考试状态,已结束
+ trainingRegistration1.setIsExam(2);
+ //更新
+ this.updateById(trainingRegistration1);
+ //查询考试成绩记录
+ ExamScore examScore = new ExamScore();
+ examScore.setApplyId(trainingRegistration1.getId());
+ List<ExamScore> list = examScoreService.list(Condition.getQueryWrapper(examScore));
+ if (list.size()>0) {
+ list.forEach(examScore1 -> {
+ //查询是否有考试记录
+ ExamAnswerRecord examAnswerRecord = new ExamAnswerRecord();
+ examAnswerRecord.setScoreId(examScore1.getId());
+ List<ExamAnswerRecord> examAnswerRecordList = examAnswerRecordService.list(Condition.getQueryWrapper(examAnswerRecord));
+ if (examAnswerRecordList.size()>0){
+ //计算成绩
+ int sum = examAnswerRecordList.stream().mapToInt(ExamAnswerRecord::getAnswerScore).sum();
+ examScore1.setTheoryGrade(sum);
+ if (sum>=60){
+ //暂未录入实操成绩
+ examScore1.setQualified(2);
+ }else {
+ examScore1.setQualified(1);
+ }
+ }else {
+ //理论成绩设置为0
+ examScore1.setTheoryGrade(0);
+ //不合格
+ examScore1.setQualified(1);
+ }
+ //更新成绩数据
+ examScoreService.updateById(examScore1);
+
+ //数据同步
+ String s =
+ "update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() +
+ " " + "where id = " + "'" + trainingRegistration1.getId() + "';" +
+ "update exam_score set theory_grade = " + examScore1.getTheoryGrade() +
+ ",qualified = " + "'" + examScore1.getQualified() + "'" +
+ " " + "where id = " + "'" + examScore1.getId() + "'";
+ myAsyncService.FTP(s);
+ });
+ }else {
+ //数据同步
+ String s =
+ "update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() +
+ " " + "where id = " + "'" + trainingRegistration1.getId() + "'";
+ myAsyncService.FTP(s);
+ }
+ });
+ }
+ }
+
+ /**
+ * 查看报名集合信息
+ * @return
+ */
+ @Override
+ public List<TrainingRegistration> getList(TrainingRegistrationVo trainingRegistration) {
+ return baseMapper.getList(trainingRegistration);
+ }
}
--
Gitblit v1.9.3