1.许可

tangzy

2021-12-06 cc057177b2fb17aee9a173a6adbabdc578fd74c7

 src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java

@@ -3,16 +3,29 @@

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.AllArgsConstructor;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.tool.api.R;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.apply.entity.Apply;
import org.springblade.modules.apply.excel.ApplyInfoExcel;
import org.springblade.modules.exam.entity.ExamPaper;
import org.springblade.modules.exam.service.ExamPaperService;
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.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.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

/**
@@ -20,14 +33,25 @@
 * @author zhongrj
 */
@Service
@AllArgsConstructor
public class TrainingRegistrationServiceImpl extends ServiceImpl<TrainingRegistrationMapper, TrainingRegistration> implements TrainingRegistrationService {

   private final IUserService userService;

   private final IUserDeptService userDeptService;

   private final ExamPaperService examPaperService;


   @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);
   }

@@ -56,25 +80,173 @@
    * @param isCovered
    */
   @Override
   public void importTrainingRegistration(List<ApplyInfoExcel> data, Boolean isCovered) {
      data.forEach(applyInfoExcel -> {
         //通过准考证号
         if (null!=applyInfoExcel.getCandidateNo() && applyInfoExcel.getIdCardNo()!=""){
   @Transactional(rollbackFor = Exception.class)
   public void importTrainingRegistration(List<TrainingRegistrationExcel> data, Boolean isCovered,Long examId) {
      if (data.size()>0){
         data.forEach(trainingRegistrationExcel -> {
            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();
            }
         }
            //通过身份证号
            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);
                     }
                  }
                  //新增报名
                  this.save(trainingRegistration);

                  //修改保安报名状态
                  user.setIsTrain(1);
                  userService.updateById(user);
                  //数据同步
                  saveTrainingRegistration(trainingRegistration,user);

               }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);
                  }
               }
            }
         });
      }
   }


   /**
    * 生成准考证号码
    * @param trainingRegistration 考试报名信息对象
    */
   private String getCandidateNo(TrainingRegistration trainingRegistration) {
      //获取考试信息
      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);
         String quarter  = null;
         String months = null;
         int month = Integer.parseInt(format.substring(5,7));
         int day = Integer.parseInt(format.substring(8,10));
         String days = null;
         if (month>0 && month<=3){
            quarter = "C";
         }
         if (month>3 && month<=6){
            quarter = "X";
         }
         if (month>6 && month<=9){
            quarter = "Q";
         }
         if (month>9 && month<=12){
            quarter = "D";
         }
         if (month<=9){
            months = "0" + month;
         }
         if (day<=9){
            days = "0" + day;
         }else {
            days = ""+day;
         }
         String type = null;
         if (examPaper.getExamType()==1){
            type = "z";
         }
         if (examPaper.getExamType()==2){
            type = "m";
         }
         //获取考试名称前缀,去除数字，字母
         String examName
            = examPaper.getExamName().replaceAll("\\s*", "").replaceAll("[^(\\u4e00-\\u9fa5)]", "").substring(0,1);

         //前缀 = 年的最后两位  + 月份（两位） + 考试名称（中文拼音）首字母（去除数字，字母） + 考试类型 + 季度拼音首字母大写（春季就是 C）
//         String result = year
//                     + months
//                     + toFirstChar(examName).toUpperCase()
//                     + examPaper.getExamType()
//                     + quarter;

         //前缀 = 年的最后两位  + 月份（两位） + 日 （两位） + 考试类型 正式考试  z   模拟考试   m
         String result = year
            + months
            + days
            + type;
         //查询是当前前缀已生成的数量
         int count = this.getCandidateNoCount(result);
         if (count==0){
            return result + "0000";
         }
         //格式化
         DecimalFormat decimalFormat = new DecimalFormat("0000");
         //返回
         return result + (decimalFormat.format(count++));
      }
      return null;
   }

   /**
    * 报名
    */
   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,audit_status) " +
         "values(" + "'" + id + "'"
         + "," + "'" + trainingRegistration.getTrainingUnitId() +"'"
         + "," + "'" + formatStr +"'"
         + "," + "'" + trainingRegistration.getCancel() + "'"
         + "," + "'" + trainingRegistration.getUserId() + "'"
         + "," + "'" + trainingRegistration.getIsExam() + "'"
         + "," +"'" + trainingRegistration.getAuditStatus() + "'" + ");" +
         "update blade_user set is_train = " + user1.getIsTrain() + " " +"where id = " + "'" + user1.getId() + "'";
      FtpUtil.sqlFileUpload(s);
   }


@@ -97,4 +269,15 @@
   public Integer getTrainingRegistrationInfo(TrainingRegistration trainingRegistration) {
      return baseMapper.getTrainingRegistrationInfo(trainingRegistration);
   }

   /**
    * 查询已报名培训公司未关联考试的人员
    * @return
    */
   @Override
   public List<TrainingRegistration> getTrainIds(TrainingRegistrationVo trainingRegistrationVo) {
      trainingRegistrationVo.setSerialStart(trainingRegistrationVo.getSerialStart() -1);
      trainingRegistrationVo.setSerialEnd(trainingRegistrationVo.getSerialEnd() -trainingRegistrationVo.getSerialStart());
      return baseMapper.getTrainIds(trainingRegistrationVo);
   }
}