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

zhongrj

2022-08-22 3c607f075990d6d3238daa7db1c68eaae8126424

 src/main/java/org/springblade/modules/talk/controller/TalkController.java

@@ -24,12 +24,14 @@

import javax.validation.Valid;

import org.springblade.common.config.FtpConfig;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.Func;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.information.entity.Information;
import org.springblade.modules.system.service.MyAsyncService;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springblade.modules.talk.entity.Talk;
@@ -39,6 +41,7 @@
import springfox.documentation.annotations.ApiIgnore;

import java.text.SimpleDateFormat;
import java.util.List;
import java.util.Map;

/**
@@ -54,6 +57,7 @@
public class TalkController extends BladeController {

   private final ITalkService talkService;
   private final MyAsyncService myAsyncService;

   /**
    * 详情
@@ -95,25 +99,31 @@
   @ApiOperationSupport(order = 4)
   @ApiOperation(value = "新增", notes = "传入talk")
   public R save(@Valid @RequestBody Talk talk) {
      talkService.save(talk);
      boolean save = talkService.save(talk);
      String url = "";
      String[] split = talk.getImgurl().split(",");
      for (int i=0;i<split.length;i++){
         String s = split[i].substring(0,split[i].indexOf("/"));
         System.out.println(s);
      for (int i = 0; i < split.length; i++) {
         String s = split[i].substring(26, split[i].length());
         url += FtpConfig.ip + s + ",";
      }
//      //数据同步
//      String s1 =
//         "insert into sys_talk(id,title,real_name,talkcontent,talktime,conclusion,evaluate,deptid,imgurl) " +
//            "values(" + "'" + talk.getId() + "'" + "," +
//            "'" + talk.getTitle() + "'" + "," +
//            "'" + talk.getRealName() + "'" + "," +
//            "'" + talk.getTalkcontent() + "'" + "," +
//            "'" + new SimpleDateFormat("yyyy-MM-dd").format(talk.getTalktime()) + "'" + "," +
//            "'" + talk.getConclusion() + "'" + "," +
//            "'" + talk.getEvaluate() + "'" + "," +
//            "'" + talk.getDeptid() + "'" + "," +
//            "'" + talk.getImgurl() + "'" + ")";
//      FtpUtil.sqlFileUpload(s1);
      String substring = url.substring(0, url.length() - 1);
      talk.setImgurl(substring);
      if (save) {
         //数据同步
         String s1 =
            "insert into sys_talk(id,title,real_name,talkcontent,talktime,conclusion,evaluate,deptid,imgurl) " +
               "values(" + "'" + talk.getId() + "'" + "," +
               "'" + talk.getTitle() + "'" + "," +
               "'" + talk.getRealName() + "'" + "," +
               "'" + talk.getTalkcontent() + "'" + "," +
               "'" + new SimpleDateFormat("yyyy-MM-dd").format(talk.getTalktime()) + "'" + "," +
               "'" + talk.getConclusion() + "'" + "," +
               "'" + talk.getEvaluate() + "'" + "," +
               "'" + talk.getDeptid() + "'" + "," +
               "'" + talk.getImgurl() + "'" + ")";
         //FtpUtil.sqlFileUpload(s1);
         myAsyncService.dataSync(s1);
      }
      return R.success("新增成功");
   }

@@ -124,7 +134,29 @@
   @ApiOperationSupport(order = 5)
   @ApiOperation(value = "修改", notes = "传入talk")
   public R update(@Valid @RequestBody Talk talk) {
      return R.status(talkService.updateById(talk));
      boolean b = talkService.updateById(talk);
      String url = "";
      String[] split = talk.getImgurl().split(",");
      for (int i = 0; i < split.length; i++) {
         String s = split[i].substring(26, split[i].length());
         url += FtpConfig.ip + s + ",";
      }
      String substring = url.substring(0, url.length() - 1);
      talk.setImgurl(substring);
      if (b) {
         String s1 = "update sys_talk set title = " + "'" + talk.getTitle() + "'" +
            ",real_name = " + "'" + talk.getRealName() + "'" +
            ",talkcontent = " + "'" + talk.getTalkcontent() + "'" +
            ",talktime = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(talk.getTalktime()) + "'" +
            ",conclusion = " + "'" + talk.getConclusion() + "'" +
            ",evaluate = " + "'" + talk.getEvaluate() + "'" +
            ",deptid = " + "'" + talk.getDeptid() + "'" +
            ",imgurl = " + "'" + talk.getImgurl() + "'" +
            " " + "where id = " + "'" + talk.getId() + "'";
         //FtpUtil.sqlFileUpload(s1);
         myAsyncService.dataSync(s1);
      }
      return R.success("修改成功");
   }

   /**
@@ -145,6 +177,14 @@
   @ApiOperationSupport(order = 8)
   @ApiOperation(value = "删除", notes = "传入ids")
   public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
      //内网删除
      List<Long> list = Func.toLongList(ids);
      list.forEach(id -> {
         //内网同步
         String s1 = "delete from sys_talk where id = " + "'" + id + "'";
         //FtpUtil.sqlFileUpload(s1);
         myAsyncService.dataSync(s1);
      });
      return R.status(talkService.removeByIds(Func.toLongList(ids)));
   }