组织机构新增，修改内网数据同步

Administrator

2021-11-29 b30f65004f5c4b925175884b62006fafeb7cdc40

 src/main/java/org/springblade/modules/system/controller/DeptController.java

@@ -47,6 +47,7 @@
import springfox.documentation.annotations.ApiIgnore;

import javax.validation.Valid;
import java.util.Arrays;
import java.util.List;
import java.util.Map;

@@ -224,12 +225,46 @@
   @ApiOperation(value = "新增或修改", notes = "传入dept")
   public R submit(@Valid @RequestBody Dept dept) {
   //   Information information = new Information();
      //Integer isDeleted = 0;
      boolean type = false;
      //如果为修改
      if (null!=dept.getId()){
         type = true;
      }
      if (deptService.submit(dept)) {
         CacheUtil.clear(SYS_CACHE);
         // 返回懒加载树更新节点所需字段
         Kv kv = Kv.create().set("id", String.valueOf(dept.getId())).set("tenantId", dept.getTenantId())
            .set("deptCategoryName", DictCache.getValue(DictEnum.ORG_CATEGORY, dept.getDeptCategory()));
         if (!type) {
            Integer isDeleted = 0;
            //内网同步新增
            String ss = "insert into blade_dept(id,parent_id,tenant_id,dept_name,ancestors,dept_category,full_name,sort,remark,is_deleted) values("
               + "'" + dept.getId() + "'" + ","
               + "'" + dept.getParentId() + "'" + ","
               + "'" + dept.getTenantId() + "'" +
               "," + "'" + dept.getDeptName() + "'" +
               "," + "'" + dept.getAncestors() + "'" +
               "," + "'" + dept.getDeptCategory() + "'" +
               "," + "'" + dept.getFullName() + "'" +
               "," + "'" + dept.getSort() + "'" +
               "," + "'" + dept.getRemark() + "'" +
               "," + "'" + isDeleted + "'" + ")";
            FtpUtil.sqlFileUpload(ss);
         }else {
            //修改
            //内网同步
            String s1 =
               "update blade_dept set parent_id = " + "'" + dept.getParentId() + "'"
                  + ",dept_name = " + "'" + dept.getDeptName() + "'"
                  + ",ancestors = " + "'" + dept.getAncestors() + "'"
                  + ",dept_category = " + "'" + dept.getDeptCategory() + "'"
                  + ",full_name = " + "'" + dept.getFullName() + "'"
                  + ",sort = " + "'" + dept.getSort() + "'"
                  + ",remark = " + "'" + dept.getRemark() + "'"
                  + ",is_deleted = " + "'" + dept.getIsDeleted() + "'"
                  + " " + "where id = " + "'" + dept.getId() + "'";
            FtpUtil.sqlFileUpload(s1);
         }
//         String id = kv.get("id").toString();
//         information.setDepartmentid(id);
//         information.setEnterprisename(dept.getDeptName());
@@ -244,13 +279,6 @@
//         "," + "'" + information.getDepartmentid() + "'" +
//         "," + "'" + information.getStats() + "'"+ ")";
//      FtpUtil.sqlFileUpload(s);
//      String ss = "insert into blade_dept(id,parent_id,tenant_id,dept_name,ancestors,dept_category,is_deleted) values(" + "'" + dept.getId() + "'" + "," + "'" + dept.getParentId() + "'" + ","
//         + "'" + dept.getTenantId() + "'" +
//         "," + "'" + information.getEnterprisename() + "'" +
//         "," + "'" + dept.getAncestors() + "'" +
//         "," + "'" + dept.getDeptCategory() + "'" +
//         "," + "'" + isDeleted + "'" + ")";
//      FtpUtil.sqlFileUpload(ss);
      return R.fail("操作失败");
   }

@@ -262,6 +290,12 @@
   @ApiOperation(value = "删除", notes = "传入ids")
   public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
      CacheUtil.clear(SYS_CACHE);
      List<String> list = Arrays.asList(ids.split(","));
      list.forEach(id -> {
         //内网同步
         String s1 = "update blade_dept set is_deleted = 1 where id = " + "'" + id + "'";
         FtpUtil.sqlFileUpload(s1);
      });
      return R.status(deptService.removeDept(ids));
   }