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

zhongrj

2022-08-22 3c607f075990d6d3238daa7db1c68eaae8126424

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

@@ -170,7 +170,7 @@
         + "," +"'" + trainingRegistration.getAuditStatus() + "'" + ");" +
         "update blade_user set is_train = " + user1.getIsTrain() + " " +"where id = " + "'" + user1.getId() + "'";
      //FtpUtil.sqlFileUpload(sql);
      myAsyncService.FTP(sql);
      myAsyncService.dataSync(sql);
   }


@@ -300,7 +300,7 @@
            " " +"where id = " + "'" + trainingRegistration.getId() + "';" +
            "update blade_user set is_train = " + user.getIsTrain() + " " +"where id = " + "'" + user.getId() + "'";
      //FtpUtil.sqlFileUpload(s);
      myAsyncService.FTP(s);
      myAsyncService.dataSync(s);
   }

   /**
@@ -634,7 +634,7 @@
               "," + "'" + creatorTimeFormat +"'" +
               ","  +"'" + examPaper.getAuditStatus() + "'" + ")";
            //FtpUtil.sqlFileUpload(s);
            myAsyncService.FTP(s);
            myAsyncService.dataSync(s);


            //修改报名信息
@@ -650,7 +650,7 @@
                        + ",audit_status = " + "'" + trainingRegistration.getAuditStatus() + "'"
                        + " " + "where id = " + "'" + trainingRegistration.getId() + "'";
                  //FtpUtil.sqlFileUpload(s1);
                  myAsyncService.FTP(s1);
                  myAsyncService.dataSync(s1);
               }
            });
         }
@@ -707,7 +707,7 @@
            "," + "'" + creatorTimeFormat +"'" +
            ","  +"'" + examPaper.getAuditStatus() + "'" + ")";
         //FtpUtil.sqlFileUpload(s);
         myAsyncService.FTP(s);
         myAsyncService.dataSync(s);

         //修改报名信息
         list.forEach(id ->{
@@ -725,7 +725,7 @@
                        + ",audit_status = " + "'" + trainingRegistration.getAuditStatus() + "'"
                        + " " + "where id = " + "'" + trainingRegistration.getId() + "'";
                  //FtpUtil.sqlFileUpload(s1);
                  myAsyncService.FTP(s1);
                  myAsyncService.dataSync(s1);
               }
            }
         });
@@ -751,7 +751,7 @@
         "update sys_training_registration set vip_status = " + "'" + trainingRegistration.getVipStatus() + "'"
            + " " + "where id = " + "'" + trainingRegistration.getId() + "'";
      //FtpUtil.sqlFileUpload(s1);
      myAsyncService.FTP(s1);
      myAsyncService.dataSync(s1);
      //更新并返回数据
      return R.data(trainingRegistrationService.updateById(trainingRegistration));
   }
@@ -779,7 +779,7 @@
                  "update sys_training_registration set vip_status = " + "'" + registration.getVipStatus() + "'"
                     + " " + "where id = " + "'" + registration.getId() + "'";
               //FtpUtil.sqlFileUpload(s1);
               myAsyncService.FTP(s1);
               myAsyncService.dataSync(s1);
               //更新
               trainingRegistrationService.updateById(registration);
            }