定时任务修改

Administrator

2022-06-14 39bdaa3ba56e1f7190e847278e616ba452ffffe7

 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,13 +60,28 @@

   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) {
      List<TrainingRegistrationVo> trainingRegistrationVos = baseMapper.selectTrainingRegistrationPage(page, trainingRegistration);
//      trainingRegistrationVos.forEach(trainingRegistrationVo -> {
//         trainingRegistrationVo.setRemainingTime(LongTimeUtil.getDistanceTime(trainingRegistrationVo.getTrainExamTime().getTime(), System.currentTimeMillis()));
//      });
      trainingRegistrationVos.forEach(trainingRegistrationVo -> {
         //如果考试id 为空,考试尚未提交审核
         if (null==trainingRegistrationVo.getAuditStatus()){
            trainingRegistrationVo.setAuditStatus(4);
         }
      });
      return page.setRecords(trainingRegistrationVos);
   }

@@ -67,7 +100,7 @@
    * @return
    */
   @Override
   public List<ApplyInfoExcel> getTrainingRegistrationExcelList(TrainingRegistrationVo trainingRegistration) {
   public List<TrainingRegistrationExcel> getTrainingRegistrationExcelList(TrainingRegistrationVo trainingRegistration) {
      return baseMapper.getTrainingRegistrationExcelList(trainingRegistration);
   }

@@ -78,82 +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());
                  //如果examId不为空
                  if (null!=examId){
                     //查询考试信息
                     ExamPaper examPaper = examPaperService.getById(examId);
                     trainingRegistration.setTrainExamId(examId.toString());
                     //审核通过
                     if (examPaper.getAuditStatus()==1){
                        //生成准考证号
                        trainingRegistration.setCandidateNo(getCandidateNo(trainingRegistration));
                     }
         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);
@@ -176,6 +297,8 @@
         }
         if (month<=9){
            months = "0" + month;
         }else {
            months = String.valueOf(month);
         }
         if (day<=9){
            days = "0" + day;
@@ -190,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
@@ -201,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;
   }
@@ -224,15 +347,17 @@
   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) " +
      String s = "insert into sys_training_registration(id,training_unit_id,training_time,cancel,user_id,is_exam,audit_status) " +
         "values(" + "'" + id + "'"
         + "," + "'" + trainingRegistration.getTrainingUnitId() +"'"
         + "," + "'" + formatStr +"'"
         + "," + "'" + trainingRegistration.getCancel() + "'"
         + "," + "'" + trainingRegistration.getUserId() + "'"
         + "," +"'" + trainingRegistration.getIsExam() + "'" + ");" +
         + "," + "'" + 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);
   }


@@ -261,7 +386,172 @@
    * @return
    */
   @Override
   public List<Long> getTrainIds() {
      return baseMapper.getTrainIds();
   public List<TrainingRegistration> getTrainIds(TrainingRegistrationVo trainingRegistrationVo) {
      trainingRegistrationVo.setSerialStart(trainingRegistrationVo.getSerialStart() -1);
      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);
   }
}