新增数据同步方式及配置，当选择为sql时则为数据库直连同步，全局替换所有的同步方法，用户修改，离职，注销修改调整，文件上传去除同步推送上传

zhongrj

2022-08-22 3c607f075990d6d3238daa7db1c68eaae8126424

 src/main/java/org/springblade/modules/training/controller/TrainingRegistrationController.java

@@ -25,11 +25,17 @@
import org.springblade.modules.exam.service.ExamPaperService;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.system.service.MyAsyncService;
import org.springblade.modules.system.vo.UserVO;
import org.springblade.modules.training.entity.TrainingRegistration;
import org.springblade.modules.training.excel.TrainingRegistrationExcel;
import org.springblade.modules.training.excel.TrainingRegistrationImporter;
import org.springblade.modules.training.service.TrainingRegistrationService;
import org.springblade.modules.training.vo.TrainingRegistrationVo;
import org.springblade.modules.vip.service.UserVipService;
import org.springblade.modules.vip.service.VipTopicService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

@@ -55,6 +61,12 @@

   private final ExamPaperService examPaperService;

   private final UserVipService userVipService;

   private final VipTopicService vipTopicService;
   private final MyAsyncService myAsyncService;


   /**
    * 自定义分页
    * @param query page,size
@@ -74,7 +86,7 @@
   @ApiOperation(value = "新增", notes = "传入trainingRegistration")
   public R save(@RequestBody TrainingRegistration trainingRegistration){
      //查询人员是否已报名
      User user = userService.getById(trainingRegistration.getUserId());
      User user = userService.getUserById(trainingRegistration.getUserId());
      if (null==user.getIsTrain()){
         //已报名
         trainingRegistration.setCancel(1);
@@ -157,7 +169,8 @@
         + "," + "'" + trainingRegistration.getIsExam() + "'"
         + "," +"'" + trainingRegistration.getAuditStatus() + "'" + ");" +
         "update blade_user set is_train = " + user1.getIsTrain() + " " +"where id = " + "'" + user1.getId() + "'";
      FtpUtil.sqlFileUpload(sql);
      //FtpUtil.sqlFileUpload(sql);
      myAsyncService.dataSync(sql);
   }


@@ -168,7 +181,8 @@
   @PostMapping("/cancelTrain")
   public R cancelApply(@RequestBody TrainingRegistration trainingRegistration){
      //查询人员是否已报名
      User user = userService.getById(trainingRegistration.getUserId());
      User user = userService.getUserById(trainingRegistration.getUserId());

      if(null==user.getIsTrain()){
         trainingRegistration.setCancel(2);
         boolean status = trainingRegistrationService.updateById(trainingRegistration);
@@ -211,7 +225,7 @@
   @PostMapping("/auditSucess")
   public R auditSucess(@RequestBody TrainingRegistration trainingRegistration){
      //查询人员信息
      User user = userService.getById(trainingRegistration.getUserId());
      User user = userService.getUserById(trainingRegistration.getUserId());
      boolean status = false;
      if (null!=user){
         //修改为已报名状态
@@ -236,7 +250,7 @@
   @PostMapping("/cancelTrainAudit")
   public R cancelApplyAudit(@RequestBody TrainingRegistration trainingRegistration){
      //查询人员是否已报名
      User user = userService.getById(trainingRegistration.getUserId());
      User user = userService.getUserById(trainingRegistration.getUserId());
      if(null==user.getIsTrain()){
         trainingRegistration.setCancel(2);
         trainingRegistration.setAuditStatus(2);
@@ -285,7 +299,8 @@
            ",audit_status = " + "'" + trainingRegistration.getAuditStatus() + "'" +
            " " +"where id = " + "'" + trainingRegistration.getId() + "';" +
            "update blade_user set is_train = " + user.getIsTrain() + " " +"where id = " + "'" + user.getId() + "'";
      FtpUtil.sqlFileUpload(s);
      //FtpUtil.sqlFileUpload(s);
      myAsyncService.dataSync(s);
   }

   /**
@@ -301,10 +316,10 @@
//      AtomicReference<StringBuilder> builder = new AtomicReference<>(new StringBuilder());
      //遍历
      list.forEach(userId ->{
         User user = userService.getById(userId);
         User user = userService.getUserById(userId);
         UserVO userVO = userService.getUserAgeById(Long.parseLong(userId));
         //判断年龄
         Integer age = AgeUtil.idCardToAge(user.getCardid());
         if (age>=18 && age<=60) {
         if (userVO.getAge()>=18 && userVO.getAge()<=60) {
            //未报名的新增，已报名的不做处理
            if (null == user.getIsTrain()) {
               TrainingRegistration trainingRegistration1 = new TrainingRegistration();
@@ -618,7 +633,8 @@
               "," + "'" + examPaper.getCreator() +"'" +
               "," + "'" + creatorTimeFormat +"'" +
               ","  +"'" + examPaper.getAuditStatus() + "'" + ")";
            FtpUtil.sqlFileUpload(s);
            //FtpUtil.sqlFileUpload(s);
            myAsyncService.dataSync(s);


            //修改报名信息
@@ -633,7 +649,8 @@
                     "update sys_training_registration set train_exam_id = " + "'" + trainingRegistration.getTrainExamId() + "'"
                        + ",audit_status = " + "'" + trainingRegistration.getAuditStatus() + "'"
                        + " " + "where id = " + "'" + trainingRegistration.getId() + "'";
                  FtpUtil.sqlFileUpload(s1);
                  //FtpUtil.sqlFileUpload(s1);
                  myAsyncService.dataSync(s1);
               }
            });
         }
@@ -689,7 +706,8 @@
            "," + "'" + examPaper.getCreator() +"'" +
            "," + "'" + creatorTimeFormat +"'" +
            ","  +"'" + examPaper.getAuditStatus() + "'" + ")";
         FtpUtil.sqlFileUpload(s);
         //FtpUtil.sqlFileUpload(s);
         myAsyncService.dataSync(s);

         //修改报名信息
         list.forEach(id ->{
@@ -706,11 +724,68 @@
                     "update sys_training_registration set train_exam_id = " + "'" + trainingRegistration.getTrainExamId() + "'"
                        + ",audit_status = " + "'" + trainingRegistration.getAuditStatus() + "'"
                        + " " + "where id = " + "'" + trainingRegistration.getId() + "'";
                  FtpUtil.sqlFileUpload(s1);
                  //FtpUtil.sqlFileUpload(s1);
                  myAsyncService.dataSync(s1);
               }
            }
         });
      }
      return null;
   }


   /**
    * 是否为会员标记
    * @param trainingRegistration
    * @return
    */
   @PostMapping("/vipSign")
   @Transactional(rollbackFor = Exception.class)
   public R vipSign(@RequestBody TrainingRegistration trainingRegistration){
      //新增会员记录
      userVipService.insertUserVipInfo(trainingRegistration);
      //新增会员题库记录
      vipTopicService.insertVipTopicInfo(trainingRegistration);
      //内网报名信息同步
      String s1 =
         "update sys_training_registration set vip_status = " + "'" + trainingRegistration.getVipStatus() + "'"
            + " " + "where id = " + "'" + trainingRegistration.getId() + "'";
      //FtpUtil.sqlFileUpload(s1);
      myAsyncService.dataSync(s1);
      //更新并返回数据
      return R.data(trainingRegistrationService.updateById(trainingRegistration));
   }

   /**
    * 批量将已报名人员标记为已缴费
    * @param trainingRegistration
    * @return
    */
   @PostMapping("/vipSignBatch")
   @Transactional(rollbackFor = Exception.class)
   public R vipSignBatch(@RequestBody TrainingRegistrationVo trainingRegistration){
      //查询已报名，未考试的报名信息
      List<TrainingRegistration> trainingRegistrationList = trainingRegistrationService.getList(trainingRegistration);
      if (trainingRegistrationList.size()>0){
         for (TrainingRegistration registration : trainingRegistrationList) {
            if (registration.getVipStatus().equals(2)) {
               registration.setVipStatus(1);
               //新增会员记录
               userVipService.insertUserVipInfo(registration);
               //新增会员题库记录
               vipTopicService.insertVipTopicInfo(registration);
               //内网报名信息同步
               String s1 =
                  "update sys_training_registration set vip_status = " + "'" + registration.getVipStatus() + "'"
                     + " " + "where id = " + "'" + registration.getId() + "'";
               //FtpUtil.sqlFileUpload(s1);
               myAsyncService.dataSync(s1);
               //更新
               trainingRegistrationService.updateById(registration);
            }
         }
      }
      //返回数据
      return R.data(true);
   }
}