1.许可

tangzy

2021-12-04 ebb5012dc221db17bfad74c3bdfd91d46aa29c03

 src/main/java/org/springblade/modules/resource/endpoint/OssEndpoint.java

@@ -620,58 +620,11 @@
         attach.setNoticeId(noticeId);
      }
      attachService.save(attach);
      String[] split = bladeFile.getName().split("/");
      String ip = FtpConstant.ip+"/zhba/upload/picture/";
      String imgurl = ip + split[2];
      FtpUtil.uploadFile(ftpHost_dev, ftpPort, ftpUserName, ftpPassword, ftpPath, "/", split[2], in);
      //数据同步
      String s1 =
         "insert into blade_attach(id,tenant_id,link,domain,name,original_name,extension,attach_size,create_user,deptid," +
            "create_time,update_user,update_time,status,is_deleted,type,cardid";
      if (noticeId != null) {
         s1 += ",notice_id"+")" +"values(" + "'" + attach.getId() + "'" + "," +
            "'" + attach.getTenantId() + "'" + "," +
            "'" + imgurl + "'" + "," +
            "'" + ip + "'" + "," +
            "'" + split[2] + "'" + "," +
            "'" + attach.getOriginalName() + "'" + "," +
            "'" + attach.getExtension() + "'" + "," +
            "'" + attach.getAttachSize() + "'" + "," +
            "'" + attach.getCreateUser() + "'" + "," +
            "'" + attach.getDeptid() + "'" + "," +
            "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
            "'" + attach.getUpdateUser() + "'" + "," +
            "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
            "'" + attach.getStatus() + "'" + "," +
            "'" + attach.getIsDeleted() + "'" + "," +
            "'" + attach.getType() + "'" + "," +
            "'" + cardid + "'";
      } else {
         s1 += ") " +
            "values(" + "'" + attach.getId() + "'" + "," +
            "'" + attach.getTenantId() + "'" + "," +
            "'" + imgurl + "'" + "," +
            "'" + ip + "'" + "," +
            "'" + split[2] + "'" + "," +
            "'" + attach.getOriginalName() + "'" + "," +
            "'" + attach.getExtension() + "'" + "," +
            "'" + attach.getAttachSize() + "'" + "," +
            "'" + attach.getCreateUser() + "'" + "," +
            "'" + attach.getDeptid() + "'" + "," +
            "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
            "'" + attach.getUpdateUser() + "'" + "," +
            "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
            "'" + attach.getStatus() + "'" + "," +
            "'" + attach.getIsDeleted() + "'" + "," +
            "'" + attach.getType() + "'" + "," +
            "'" + cardid + "'";
      }
      if (noticeId != null) {
         s1 += ","+"'" + noticeId + "'" + ")";
      } else {
         s1 += ")";
      }
      FtpUtil.sqlFileUpload(s1);
      //String[] split = bladeFile.getName().split("/");
      //String ip = FtpConstant.ip+"/zhba/upload/picture/";
      //String imgurl = ip + split[2];
      //FtpUtil.uploadFile(ftpHost_dev, ftpPort, ftpUserName, ftpPassword, ftpPath, "/", split[2], in);
      //FtpUtil.sqlFileUpload(s1);
      return attach.getId();
   }