| | |
| | | |
| | | List<MultipartFile> fileList = new ArrayList<>(); |
| | | //获取图片文件 |
| | | fileList = fileUtil.getSubFiles(desPath+File.separator+namePath,fileList); |
| | | fileList = fileUtil.getSubFiles(desPath,fileList); |
| | | for (MultipartFile multipartFile : fileList){ |
| | | if(multipartFile.getName().toLowerCase().endsWith(".png") || multipartFile.getName().toLowerCase().endsWith(".jpg")) { |
| | | String newName = "upload/picture/" + UUID.randomUUID().toString().replaceAll("-", "") + multipartFile.getName().substring(multipartFile.getName().lastIndexOf(".")); |
| | |
| | | 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(); |
| | | } |
| | | |