/*
|
* Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
|
*
|
* Redistribution and use in source and binary forms, with or without
|
* modification, are permitted provided that the following conditions are met:
|
*
|
* Redistributions of source code must retain the above copyright notice,
|
* this list of conditions and the following disclaimer.
|
* Redistributions in binary form must reproduce the above copyright
|
* notice, this list of conditions and the following disclaimer in the
|
* documentation and/or other materials provided with the distribution.
|
* Neither the name of the dreamlu.net developer nor the names of its
|
* contributors may be used to endorse or promote products derived from
|
* this software without specific prior written permission.
|
* Author: Chill 庄骞 (smallchill@163.com)
|
*/
|
package org.springblade.modules.resource.endpoint;
|
|
import io.minio.*;
|
import io.minio.errors.*;
|
import io.swagger.annotations.Api;
|
import lombok.AllArgsConstructor;
|
import lombok.SneakyThrows;
|
import org.apache.commons.lang3.StringUtils;
|
import org.springblade.common.config.FileConfig;
|
import org.springblade.common.config.FtpConfig;
|
import org.springblade.common.utils.FileUtil;
|
import org.springblade.core.launch.constant.AppConstant;
|
import org.springblade.core.log.exception.ServiceException;
|
import org.springblade.core.oss.model.BladeFile;
|
import org.springblade.core.oss.model.OssFile;
|
import org.springblade.core.secure.annotation.PreAuth;
|
import org.springblade.core.tenant.annotation.NonDS;
|
import org.springblade.core.tool.api.R;
|
import org.springblade.core.tool.constant.RoleConstant;
|
import org.springblade.core.tool.utils.Func;
|
import org.springblade.modules.FTP.FtpUtil;
|
import org.springblade.modules.apply.entity.Apply;
|
import org.springblade.modules.apply.entity.ExamPayment;
|
import org.springblade.modules.apply.service.ExamPaymentService;
|
import org.springblade.modules.exam.service.ExamPaperService;
|
import org.springblade.modules.exam.vo.ExamPaperVO;
|
import org.springblade.modules.resource.builder.oss.OssBuilder;
|
import org.springblade.modules.resource.entity.Attach;
|
import org.springblade.modules.resource.service.IAttachService;
|
import org.springblade.modules.system.entity.User;
|
import org.springblade.modules.system.service.IUserService;
|
import org.springblade.modules.system.service.MyAsyncService;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
import java.io.File;
|
import java.io.FileInputStream;
|
import java.io.IOException;
|
import java.io.InputStream;
|
import java.security.InvalidKeyException;
|
import java.security.NoSuchAlgorithmException;
|
import java.text.SimpleDateFormat;
|
import java.util.*;
|
import java.util.concurrent.atomic.AtomicBoolean;
|
import java.util.regex.Pattern;
|
import static org.springblade.common.config.FtpConfig.*;
|
|
/**
|
* 对象存储端点
|
*
|
* @author Chill
|
*/
|
@NonDS
|
@RestController
|
@AllArgsConstructor
|
@Api(value = "对象存储端点", tags = "对象存储端点")
|
@RequestMapping(AppConstant.APPLICATION_RESOURCE_NAME + "/oss/endpoint")
|
public class OssEndpoint {
|
|
/**
|
* 对象存储构建类
|
*/
|
private final OssBuilder ossBuilder;
|
|
/**
|
* 附件表服务
|
*/
|
private final IAttachService attachService;
|
|
|
private final IUserService userService;
|
|
|
private final ExamPaperService examPaperService;
|
|
private final ExamPaymentService examPaymentService;
|
private final MyAsyncService myAsyncService;
|
|
/**
|
* 创建存储桶
|
*
|
* @param bucketName 存储桶名称
|
* @return Bucket
|
*/
|
@SneakyThrows
|
@PostMapping("/make-bucket")
|
@PreAuth(RoleConstant.HAS_ROLE_ADMIN)
|
public R makeBucket(@RequestParam String bucketName) {
|
ossBuilder.template().makeBucket(bucketName);
|
return R.success("创建成功");
|
}
|
|
/**
|
* 创建存储桶
|
*
|
* @param bucketName 存储桶名称
|
* @return R
|
*/
|
@SneakyThrows
|
@PostMapping("/remove-bucket")
|
@PreAuth(RoleConstant.HAS_ROLE_ADMIN)
|
public R removeBucket(@RequestParam String bucketName) {
|
ossBuilder.template().removeBucket(bucketName);
|
return R.success("删除成功");
|
}
|
|
/**
|
* 拷贝文件
|
*
|
* @param fileName 存储桶对象名称
|
* @param destBucketName 目标存储桶名称
|
* @param destFileName 目标存储桶对象名称
|
* @return R
|
*/
|
@SneakyThrows
|
@PostMapping("/copy-file")
|
public R copyFile(@RequestParam String fileName, @RequestParam String destBucketName, String destFileName) {
|
ossBuilder.template().copyFile(fileName, destBucketName, destFileName);
|
return R.success("操作成功");
|
}
|
|
/**
|
* 获取文件信息
|
*
|
* @param fileName 存储桶对象名称
|
* @return InputStream
|
*/
|
@SneakyThrows
|
@GetMapping("/stat-file")
|
public R<OssFile> statFile(@RequestParam String fileName) {
|
return R.data(ossBuilder.template().statFile(fileName));
|
}
|
|
/**
|
* 获取文件相对路径
|
*
|
* @param fileName 存储桶对象名称
|
* @return String
|
*/
|
@SneakyThrows
|
@GetMapping("/file-path")
|
public R<String> filePath(@RequestParam String fileName) {
|
return R.data(ossBuilder.template().filePath(fileName));
|
}
|
|
|
/**
|
* 获取文件外链
|
*
|
* @param fileName 存储桶对象名称
|
* @return String
|
*/
|
@SneakyThrows
|
@GetMapping("/file-link")
|
public R<String> fileLink(@RequestParam String fileName) {
|
return R.data(ossBuilder.template().fileLink(fileName));
|
}
|
|
/**
|
* 上传文件
|
*
|
* @param file 文件
|
* @return ObjectStat
|
*/
|
@SneakyThrows
|
@PostMapping("/put-file")
|
public R<BladeFile> putFile(@RequestParam MultipartFile file) {
|
BladeFile bladeFile = ossBuilder.template().putFile(file.getOriginalFilename(), file.getInputStream());
|
return R.data(bladeFile);
|
}
|
|
/**
|
* 上传文件
|
*
|
* @param file 文件
|
* @return ObjectStat
|
*/
|
@SneakyThrows
|
@PostMapping("/put-file-user-avatar")
|
public R putFileUserAvatar(@RequestParam MultipartFile file) {
|
//填写你文件上传的地址以及相应信息
|
String url = "http://61.131.136.25:2081";
|
String access = "zhbaadmin";
|
String secret = "zhbapassword";
|
String bucket = "zhba";
|
MinioClient minioClient =
|
MinioClient.builder()
|
.endpoint(url)
|
.credentials(access, secret)
|
.build();
|
// 检查存储桶是否已经存在
|
boolean isExist = minioClient.bucketExists(BucketExistsArgs.builder().bucket(bucket).build());
|
if (!isExist) {
|
// 创建一个名为zip的存储桶，用于zip文件。
|
minioClient.makeBucket(MakeBucketArgs.builder().bucket(bucket).build());
|
minioClient.setBucketPolicy(SetBucketPolicyArgs.builder().bucket(bucket).build());
|
}
|
String fileName = file.getOriginalFilename();
|
String newName = "upload/picture/" + UUID.randomUUID().toString().replaceAll("-", "")
|
+ fileName.substring(fileName.lastIndexOf("."));
|
InputStream in = file.getInputStream();
|
String[] split = newName.split("/");
|
//创建头部信息
|
Map<String, String> headers = new HashMap<>(1 << 2);
|
//添加自定义内容类型
|
headers.put("Content-Type", "application/octet-stream");
|
//上传
|
minioClient.putObject(
|
PutObjectArgs.builder().bucket(bucket).object(newName).stream(
|
in, in.available(), -1)
|
.headers(headers)
|
.build());
|
InputStream inputStream = file.getInputStream();
|
FtpUtil.uploadFile(FtpConfig.ftpHost, ftpPort, FtpConfig.ftpUserName, ftpPassword, ftpPath, "/", "f"+split[2], inputStream);
|
in.close();
|
String urls = "http://61.131.136.25:2081/zhba/" + newName;
|
//数据封装
|
Map<String, Object> map = new HashMap<>(2);
|
map.put("name", newName);
|
map.put("url", urls);
|
//返回
|
return R.data(map);
|
}
|
|
|
/**
|
* app 文件上传
|
*
|
* @param file 图片对象
|
*/
|
@PostMapping("put-file-app")
|
public R putFileApp(@RequestParam MultipartFile file) throws IOException, ServerException, InsufficientDataException, InternalException, InvalidResponseException, InvalidKeyException, NoSuchAlgorithmException, XmlParserException, ErrorResponseException {
|
//填写你文件上传的地址以及相应信息
|
String url = "http://61.131.136.25:2081";
|
String access = "zhbaadmin";
|
String secret = "zhbapassword";
|
String bucket = "zhba";
|
MinioClient minioClient =
|
MinioClient.builder()
|
.endpoint(url)
|
.credentials(access, secret)
|
.build();
|
// 检查存储桶是否已经存在
|
boolean isExist = minioClient.bucketExists(BucketExistsArgs.builder().bucket(bucket).build());
|
if (!isExist) {
|
// 创建一个名为zip的存储桶，用于zip文件。
|
minioClient.makeBucket(MakeBucketArgs.builder().bucket(bucket).build());
|
minioClient.setBucketPolicy(SetBucketPolicyArgs.builder().bucket(bucket).build());
|
}
|
String fileName = file.getOriginalFilename();
|
String newName = "upload/picture/" + UUID.randomUUID().toString().replaceAll("-", "")
|
+ fileName.substring(fileName.lastIndexOf("."));
|
InputStream in = file.getInputStream();
|
String[] split = newName.split("/");
|
//创建头部信息
|
Map<String, String> headers = new HashMap<>(1 << 2);
|
//添加自定义内容类型
|
headers.put("Content-Type", "application/octet-stream");
|
//上传
|
minioClient.putObject(
|
PutObjectArgs.builder().bucket(bucket).object(newName).stream(
|
in, in.available(), -1)
|
.headers(headers)
|
.build());
|
InputStream inputStream = file.getInputStream();
|
FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, ftpPath, "/","f"+split[2], inputStream);
|
in.close();
|
String urls = "http://61.131.136.25:2081/zhba/" + newName;
|
return R.data(urls);
|
}
|
|
|
/**
|
* 文件上传,自定义上传
|
*
|
* @param file 图片对象
|
*/
|
@PostMapping("put-files")
|
public R putFiles(@RequestParam MultipartFile file) throws IOException, ServerException, InsufficientDataException, InternalException, InvalidResponseException, InvalidKeyException, NoSuchAlgorithmException, XmlParserException, ErrorResponseException {
|
//填写你文件上传的地址以及相应信息
|
String url = "http://61.131.136.25:2081";
|
String access = "zhbaadmin";
|
String secret = "zhbapassword";
|
String bucket = "zhba";
|
MinioClient minioClient =
|
MinioClient.builder()
|
.endpoint(url)
|
.credentials(access, secret)
|
.build();
|
// 检查存储桶是否已经存在
|
boolean isExist = minioClient.bucketExists(BucketExistsArgs.builder().bucket(bucket).build());
|
if (!isExist) {
|
// 创建一个名为zip的存储桶，用于zip文件。
|
minioClient.makeBucket(MakeBucketArgs.builder().bucket(bucket).build());
|
minioClient.setBucketPolicy(SetBucketPolicyArgs.builder().bucket(bucket).build());
|
}
|
String fileName = file.getOriginalFilename();
|
String newName = "upload/picture/" + UUID.randomUUID().toString().replaceAll("-", "")
|
+ fileName.substring(fileName.lastIndexOf("."));
|
InputStream in = file.getInputStream();
|
String[] split = newName.split("/");
|
//创建头部信息
|
Map<String, String> headers = new HashMap<>(1 << 2);
|
//添加自定义内容类型
|
headers.put("Content-Type", "application/octet-stream");
|
//上传
|
minioClient.putObject(
|
PutObjectArgs.builder().bucket(bucket).object(newName).stream(
|
in, in.available(), -1)
|
.headers(headers)
|
.build());
|
InputStream inputStream = file.getInputStream();
|
FtpUtil.uploadFile(FtpConfig.ftpHost, ftpPort, FtpConfig.ftpUserName, ftpPassword, ftpPath, "/", "f"+split[2], inputStream);
|
in.close();
|
String urls = "http://61.131.136.25:2081/zhba/" + newName;
|
//数据封装
|
Map<String, Object> map = new HashMap<>(2);
|
map.put("name", newName);
|
map.put("url", urls);
|
//返回
|
return R.data(map);
|
}
|
|
|
/**
|
* 文件上传,zip
|
*
|
* @param file 图片对象
|
*/
|
@PostMapping("put-file-zip")
|
public R putFileZip(@RequestParam MultipartFile file) throws Exception {
|
Map<String, Object> map = new HashMap<>(1);
|
//填写你文件上传的地址以及相应信息
|
String url = "http://61.131.136.25:2081";
|
String access = "zhbaadmin";
|
String secret = "zhbapassword";
|
String bucket = "zhba";
|
MinioClient minioClient =
|
MinioClient.builder()
|
.endpoint(url)
|
.credentials(access, secret)
|
.build();
|
// 检查存储桶是否已经存在
|
boolean isExist = minioClient.bucketExists(BucketExistsArgs.builder().bucket(bucket).build());
|
if (!isExist) {
|
// 创建一个名为zip的存储桶，用于zip文件。
|
minioClient.makeBucket(MakeBucketArgs.builder().bucket(bucket).build());
|
minioClient.setBucketPolicy(SetBucketPolicyArgs.builder().bucket(bucket).build());
|
}
|
String fileName = file.getOriginalFilename();
|
String namePath = fileName.substring(0,fileName.lastIndexOf("."));
|
String fileType = fileName.substring(fileName.lastIndexOf(".") + 1).toLowerCase(Locale.US);
|
//判断文件是不是zip类型
|
if(!fileType.equals("zip")){
|
// map.put("data","上传文件类型不符!");
|
// return R.data(map);
|
throw new ServiceException("上传文件类型不符!必须是 zip 压缩文件格式!");
|
}
|
//FileConfig.localtion是配置文件和config类生产的，测试demo可以直接把FileConfig.localtion替换成D:/test
|
String uuid = UUID.randomUUID().toString();
|
String desPath = FileConfig.localtion + File.separator + uuid.replaceAll("-", "");
|
// String desPath = "D:/test" + File.separator + uuid.replaceAll("-", "");
|
|
//遗漏了这个代码，在本地测试环境不会出问题，在服务器上一定会报没有找到文件的错误
|
String savePath = FileConfig.localtion + File.separator;
|
FileUtil fileUtil = new FileUtil();
|
//解压zip文件
|
FileUtil.unZip(file, desPath,savePath);
|
|
List<MultipartFile> fileList = new ArrayList<>();
|
//获取图片文件
|
// fileList = fileUtil.getSubFiles(desPath+File.separator+namePath,fileList);
|
fileList = fileUtil.getSubFiles(desPath,fileList);
|
//将不能导入的保安员账号存起来
|
List<String> errorList = new ArrayList<>();
|
//导入状态，默认为true ,如果有一个出现问题则为 false
|
AtomicBoolean status = new AtomicBoolean(true);
|
//遍历
|
for (MultipartFile multipartFile : fileList){
|
long size = multipartFile.getSize();
|
if (size<30*1024 || size>500*1024){
|
status.set(false);
|
//取出身份证号,查询用户信息，更新用户信息
|
String pictrueName = multipartFile.getName().substring(0, multipartFile.getName().lastIndexOf("."));
|
String regex ="[\u4e00-\u9fa5]";
|
Pattern compile = Pattern.compile(regex);
|
String idCardNo = compile.matcher(pictrueName).replaceAll("");
|
//加入集合
|
errorList.add(idCardNo);
|
|
}
|
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("."));
|
InputStream in = multipartFile.getInputStream();
|
String[] split = newName.split("/");
|
//创建头部信息
|
Map<String, String> headers = new HashMap<>(1 << 2);
|
//添加自定义内容类型
|
headers.put("Content-Type", "application/octet-stream");
|
//上传
|
minioClient.putObject(
|
PutObjectArgs.builder().bucket(bucket).object(newName).stream(
|
in, in.available(), -1)
|
.headers(headers)
|
.build());
|
|
String urls = "http://61.131.136.25:2081/zhba/" + newName;
|
//内网
|
String inUrl = FtpConfig.ip + "/zhba/" + newName;
|
//取出身份证号,查询用户信息，更新用户信息
|
String pictrueName = multipartFile.getName().substring(0, multipartFile.getName().lastIndexOf("."));
|
// String regex ="([1-9]\\d{5}(18|19|20)\\d{2}((0[1-9])|(10|11|12))(([0-2][1-9])|10|20|30|31)\\d{3}[0-9Xx])|([1-9]\\d{5}\\d{2}((0[1-9])|(10|11|12))(([0-2][1-9])|10|20|30|31)\\d{3})";
|
String regex ="[\u4e00-\u9fa5]";
|
Pattern compile = Pattern.compile(regex);
|
String idCardNo = compile.matcher(pictrueName).replaceAll("");
|
User user = userService.getUserInfoByIdCardNo(idCardNo);
|
//设置用户头像url
|
if (null!=user){
|
// user.setAvatar(urls);
|
// user.setAvatar("");
|
//更新用户信息
|
// userService.updateById(user);
|
|
//内网数据推送
|
//数据推送
|
String s = "update blade_user set avatar = " + "'" + inUrl + "'" + "where id = " + "'" + user.getId() + "'";
|
//FtpUtil.sqlFileUpload(s);
|
myAsyncService.FTP(s);
|
|
//文件推送
|
InputStream inputStream = multipartFile.getInputStream();
|
FtpUtil.uploadFile(FtpConfig.ftpHost, ftpPort, FtpConfig.ftpUserName, ftpPassword, ftpPath, "/", "f"+split[2], inputStream);
|
in.close();
|
}
|
}
|
}
|
//最后要删除文件
|
FileUtil.clearFiles(FileConfig.localtion + File.separator + file.getOriginalFilename());
|
FileUtil.clearFiles(desPath);
|
//数据封装
|
map.put("data", "上传成功!");
|
if (!status.get()) {
|
String errorAccount = StringUtils.join(errorList, "\\\n");
|
throw new ServiceException("用户:[" + errorAccount + "]照片导入失败!照片不能小于30KB,且不能大于500KB!!");
|
}
|
//返回
|
return R.data(map);
|
}
|
|
/**
|
* 文件上传,zip(保安员头像上传)
|
*
|
* @param file 图片对象
|
*/
|
@PostMapping("put-file-zips")
|
public R putFileZips(@RequestParam MultipartFile file) throws Exception {
|
Map<String, Object> map = new HashMap<>(1);
|
//填写你文件上传的地址以及相应信息
|
String url = "http://61.131.136.25:2081";
|
String access = "zhbaadmin";
|
String secret = "zhbapassword";
|
String bucket = "zhba";
|
MinioClient minioClient =
|
MinioClient.builder()
|
.endpoint(url)
|
.credentials(access, secret)
|
.build();
|
// 检查存储桶是否已经存在
|
boolean isExist = minioClient.bucketExists(BucketExistsArgs.builder().bucket(bucket).build());
|
if (!isExist) {
|
// 创建一个名为zip的存储桶，用于zip文件。
|
minioClient.makeBucket(MakeBucketArgs.builder().bucket(bucket).build());
|
minioClient.setBucketPolicy(SetBucketPolicyArgs.builder().bucket(bucket).build());
|
}
|
String fileName = file.getOriginalFilename();
|
String namePath = fileName.substring(0,fileName.lastIndexOf("."));
|
String fileType = fileName.substring(fileName.lastIndexOf(".") + 1).toLowerCase(Locale.US);
|
//判断文件是不是zip类型
|
if(!fileType.equals("zip")){
|
// map.put("data","上传文件类型不符!");
|
// return R.data(map);
|
throw new ServiceException("上传文件类型不符!必须是 zip 压缩文件格式!");
|
}
|
//FileConfig.localtion是配置文件和config类生产的，测试demo可以直接把FileConfig.localtion替换成D:/test
|
String uuid = UUID.randomUUID().toString();
|
String desPath = FileConfig.localtion + File.separator + uuid.replaceAll("-", "");
|
// String desPath = "D:/test" + File.separator + uuid.replaceAll("-", "");
|
|
//遗漏了这个代码，在本地测试环境不会出问题，在服务器上一定会报没有找到文件的错误
|
String savePath = FileConfig.localtion + File.separator;
|
FileUtil fileUtil = new FileUtil();
|
//解压zip文件
|
FileUtil.unZip(file, desPath,savePath);
|
|
List<MultipartFile> fileList = new ArrayList<>();
|
//获取图片文件
|
// fileList = fileUtil.getSubFiles(desPath+File.separator+namePath,fileList);
|
fileList = fileUtil.getSubFiles(desPath,fileList);
|
//将不能导入的保安员账号存起来
|
List<String> errorList = new ArrayList<>();
|
List<String> picList = new ArrayList<>();
|
//导入状态，默认为true ,如果有一个出现问题则为 false
|
AtomicBoolean pic = new AtomicBoolean(true);
|
AtomicBoolean status = new AtomicBoolean(true);
|
//遍历
|
for (MultipartFile multipartFile : fileList){
|
long size = multipartFile.getSize();
|
if (size<30*1024 || size>500*1024){
|
status.set(false);
|
//取出身份证号,查询用户信息，更新用户信息
|
String pictrueName = multipartFile.getName().substring(0, multipartFile.getName().lastIndexOf("."));
|
String regex ="[\u4e00-\u9fa5]";
|
Pattern compile = Pattern.compile(regex);
|
String idCardNo = compile.matcher(pictrueName).replaceAll("");
|
//加入集合
|
errorList.add(idCardNo);
|
|
}
|
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("."));
|
InputStream in = multipartFile.getInputStream();
|
String[] split = newName.split("/");
|
//创建头部信息
|
Map<String, String> headers = new HashMap<>(1 << 2);
|
//添加自定义内容类型
|
headers.put("Content-Type", "application/octet-stream");
|
//上传
|
minioClient.putObject(
|
PutObjectArgs.builder().bucket(bucket).object(newName).stream(
|
in, in.available(), -1)
|
.headers(headers)
|
.build());
|
|
String urls = "http://61.131.136.25:2081/zhba/" + newName;
|
//内网
|
String inUrl = FtpConfig.ip + "/zhba/" + newName;
|
//取出身份证号,查询用户信息，更新用户信息
|
String pictrueName = multipartFile.getName().substring(0, multipartFile.getName().lastIndexOf("."));
|
// String regex ="([1-9]\\d{5}(18|19|20)\\d{2}((0[1-9])|(10|11|12))(([0-2][1-9])|10|20|30|31)\\d{3}[0-9Xx])|([1-9]\\d{5}\\d{2}((0[1-9])|(10|11|12))(([0-2][1-9])|10|20|30|31)\\d{3})";
|
String regex ="[\u4e00-\u9fa5]";
|
Pattern compile = Pattern.compile(regex);
|
String idCardNo = compile.matcher(pictrueName).replaceAll("");
|
User user = userService.getById(idCardNo);
|
//设置用户头像url
|
if (null!=user){
|
// user.setAvatar(urls);
|
// user.setAvatar("");
|
// //更新用户信息
|
// userService.updateById(user);
|
|
//内网数据推送
|
//数据推送
|
String s = "update blade_user set avatar = " + "'" + inUrl + "'" + "where id = " + "'" + user.getId() + "'";
|
//FtpUtil.sqlFileUpload(s);
|
myAsyncService.FTP(s);
|
|
//文件推送
|
InputStream inputStream = multipartFile.getInputStream();
|
FtpUtil.uploadFile(FtpConfig.ftpHost, ftpPort, FtpConfig.ftpUserName, ftpPassword, ftpPath, "/", "f"+split[2], inputStream);
|
in.close();
|
}else {
|
pic.set(false);
|
picList.add(idCardNo);
|
}
|
}
|
}
|
//最后要删除文件
|
FileUtil.clearFiles(FileConfig.localtion + File.separator + file.getOriginalFilename());
|
FileUtil.clearFiles(desPath);
|
//数据封装
|
map.put("data", "上传成功!");
|
//如果所有数据导入有一个异常
|
StringBuilder errorBuilder = new StringBuilder();
|
if (!status.get()) {
|
String errorAccount = StringUtils.join(errorList, "\\\n");
|
errorBuilder.append("用户:[" + errorAccount + "]照片导入失败!照片不能小于30KB,且不能大于500KB!!");
|
}
|
|
if (!pic.get()){
|
String errorAccount = StringUtils.join(picList, "\\\n");
|
errorBuilder.append("用户:[" + errorAccount + "]导入失败!编号不存在，请检查核对后再上传!");
|
}
|
//抛出异常
|
if (errorBuilder.length()>0){
|
throw new ServiceException(errorBuilder.toString());
|
}
|
//返回
|
return R.data(map);
|
}
|
|
|
/**
|
* 文件上传,zip , 缴费凭证
|
*
|
* @param file 图片对象
|
*/
|
@PostMapping("put-file-exam-payment-zip")
|
public R putFileExamPaymentZip(@RequestParam MultipartFile file) throws Exception {
|
Map<String, Object> map = new HashMap<>(1);
|
//填写你文件上传的地址以及相应信息
|
String url = "http://61.131.136.25:2081";
|
String access = "zhbaadmin";
|
String secret = "zhbapassword";
|
String bucket = "zhba";
|
MinioClient minioClient =
|
MinioClient.builder()
|
.endpoint(url)
|
.credentials(access, secret)
|
.build();
|
// 检查存储桶是否已经存在
|
boolean isExist = minioClient.bucketExists(BucketExistsArgs.builder().bucket(bucket).build());
|
if (!isExist) {
|
// 创建一个名为zip的存储桶，用于zip文件。
|
minioClient.makeBucket(MakeBucketArgs.builder().bucket(bucket).build());
|
minioClient.setBucketPolicy(SetBucketPolicyArgs.builder().bucket(bucket).build());
|
}
|
String fileName = file.getOriginalFilename();
|
String namePath = fileName.substring(0,fileName.lastIndexOf("."));
|
String fileType = fileName.substring(fileName.lastIndexOf(".") + 1).toLowerCase(Locale.US);
|
//判断文件是不是zip类型
|
if(!fileType.equals("zip")){
|
// map.put("data","上传文件类型不符!");
|
// return R.data(map);
|
throw new ServiceException("上传文件类型不符!必须是 zip 压缩文件格式!");
|
}
|
//FileConfig.localtion是配置文件和config类生产的，测试demo可以直接把FileConfig.localtion替换成D:/test
|
String uuid = UUID.randomUUID().toString();
|
String desPath = FileConfig.localtion + File.separator + uuid.replaceAll("-", "");
|
|
//遗漏了这个代码，在本地测试环境不会出问题，在服务器上一定会报没有找到文件的错误
|
String savePath = FileConfig.localtion + File.separator;
|
FileUtil fileUtil = new FileUtil();
|
//解压zip文件
|
FileUtil.unZip(file, desPath,savePath);
|
|
List<MultipartFile> fileList = new ArrayList<>();
|
//获取图片文件
|
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("."));
|
InputStream in = multipartFile.getInputStream();
|
String[] split = newName.split("/");
|
//创建头部信息
|
Map<String, String> headers = new HashMap<>(1 << 2);
|
//添加自定义内容类型
|
headers.put("Content-Type", "application/octet-stream");
|
//上传
|
minioClient.putObject(
|
PutObjectArgs.builder().bucket(bucket).object(newName).stream(
|
in, in.available(), -1)
|
.headers(headers)
|
.build());
|
|
String urls = "http://61.131.136.25:2081/zhba/" + newName;
|
//内网
|
String inUrl = FtpConfig.ip +"/zhba/"+ newName;
|
//取出身份证号,查询用户信息，更新用户信息
|
String pictrueName = multipartFile.getName().substring(0, multipartFile.getName().lastIndexOf("."));
|
// String regex ="([1-9]\\d{5}(18|19|20)\\d{2}((0[1-9])|(10|11|12))(([0-2][1-9])|10|20|30|31)\\d{3}[0-9Xx])|([1-9]\\d{5}\\d{2}((0[1-9])|(10|11|12))(([0-2][1-9])|10|20|30|31)\\d{3})";
|
String regex ="[\u4e00-\u9fa5]";
|
Pattern compile = Pattern.compile(regex);
|
String idCardNo = compile.matcher(pictrueName).replaceAll("");
|
User user = userService.getUserInfoByIdCardNo(idCardNo);
|
//设置用户头像url
|
if (null!=user){
|
ExamPayment examPayment = new ExamPayment();
|
examPayment.setWorkerId(user.getId().toString());
|
examPayment.setPaymentStatus(3);
|
examPayment.setCertificateUrl(urls);
|
examPayment.setType(1);
|
examPayment.setPaymentTime(new Date());
|
//查询当前人员的报名信息
|
List<Apply> applyList = examPaperService.getApplyDetail(user.getId().toString());
|
//有且只有一条信息
|
if (applyList.size()==1){
|
examPayment.setApplyCode(applyList.get(0).getId().toString());
|
}
|
//新增
|
examPaymentService.save(examPayment);
|
|
//数据推送
|
String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPayment.getPaymentTime());
|
String s = "insert into sys_exam_payment(id,type,payment_time,worker_id,payment_status,certificate_url) " +
|
"values(" + "'" + examPayment.getId() + "'" +
|
"," + "'" + examPayment.getType() + "'" +
|
"," + "'" + formatStr + "'" +
|
"," + "'" + examPayment.getWorkerId() + "'" +
|
"," + "'" + examPayment.getPaymentStatus() + "'" +
|
"," +"'" + inUrl + "'" + ")";
|
//FtpUtil.sqlFileUpload(s);
|
myAsyncService.FTP(s);
|
|
//文件推送
|
InputStream inputStream = multipartFile.getInputStream();
|
FtpUtil.uploadFile(FtpConfig.ftpHost, ftpPort, FtpConfig.ftpUserName, ftpPassword, ftpPath, "/", "f"+split[2], inputStream);
|
in.close();
|
}
|
}
|
}
|
//最后要删除文件
|
FileUtil.clearFiles(FileConfig.localtion + File.separator + file.getOriginalFilename());
|
FileUtil.clearFiles(desPath);
|
//数据封装
|
map.put("data", "上传成功!");
|
//返回
|
return R.data(map);
|
}
|
|
|
/**
|
* 文件上传,个人头像上传
|
*
|
* @param file 图片对象
|
*/
|
@PostMapping("put-files-talk")
|
public R putFilestak(@RequestParam MultipartFile file) throws IOException, ServerException, InsufficientDataException, InternalException, InvalidResponseException, InvalidKeyException, NoSuchAlgorithmException, XmlParserException, ErrorResponseException {
|
//填写你文件上传的地址以及相应信息
|
String url = "http://61.131.136.25:2081";
|
String access = "zhbaadmin";
|
String secret = "zhbapassword";
|
String bucket = "zhba";
|
MinioClient minioClient =
|
MinioClient.builder()
|
.endpoint(url)
|
.credentials(access, secret)
|
.build();
|
// 检查存储桶是否已经存在
|
boolean isExist = minioClient.bucketExists(BucketExistsArgs.builder().bucket(bucket).build());
|
if (!isExist) {
|
// 创建一个名为zip的存储桶，用于zip文件。
|
minioClient.makeBucket(MakeBucketArgs.builder().bucket(bucket).build());
|
minioClient.setBucketPolicy(SetBucketPolicyArgs.builder().bucket(bucket).build());
|
}
|
String fileName = file.getOriginalFilename();
|
String newName = "upload/picture/" + UUID.randomUUID().toString().replaceAll("-", "")
|
+ fileName.substring(fileName.lastIndexOf("."));
|
InputStream in = file.getInputStream();
|
String[] split = newName.split("/");
|
//创建头部信息
|
Map<String, String> headers = new HashMap<>(1 << 2);
|
//添加自定义内容类型
|
headers.put("Content-Type", "application/octet-stream");
|
//上传
|
minioClient.putObject(
|
PutObjectArgs.builder().bucket(bucket).object(newName).stream(
|
in, in.available(), -1)
|
.headers(headers)
|
.build());
|
|
//文件推送
|
InputStream inputStream = file.getInputStream();
|
FtpUtil.uploadFile(FtpConfig.ftpHost, ftpPort, FtpConfig.ftpUserName, ftpPassword, ftpPath, "/", "f"+split[2], inputStream);
|
in.close();
|
String urls = "http://61.131.136.25:2081/zhba/" + newName;
|
//数据封装
|
Map<String, Object> map = new HashMap<>(2);
|
map.put("name", newName);
|
map.put("url", urls);
|
//返回
|
return R.data(map);
|
}
|
|
/**
|
* 上传文件
|
*
|
* @param fileName 存储桶对象名称
|
* @param file 文件
|
* @return ObjectStat
|
*/
|
@SneakyThrows
|
@PostMapping("/put-file-by-name")
|
public R<BladeFile> putFile(@RequestParam String fileName, @RequestParam MultipartFile file) {
|
BladeFile bladeFile = ossBuilder.template().putFile(fileName, file.getInputStream());
|
return R.data(bladeFile);
|
}
|
|
/**
|
* 上传文件并保存至附件表
|
*
|
* @param file 文件
|
* @return ObjectStat
|
*/
|
@SneakyThrows
|
@PostMapping("/put-file-attach")
|
public R<BladeFile> putFileAttach(@RequestParam MultipartFile file, String deptid, String type, Long noticeId, String cardid) {
|
String fileName = file.getOriginalFilename();
|
BladeFile bladeFile = ossBuilder.template().putFile(fileName, file.getInputStream());
|
InputStream inputStream = file.getInputStream();
|
Long attachId = buildAttach(fileName, file.getSize(), bladeFile, deptid, type, noticeId, cardid, inputStream);
|
bladeFile.setAttachId(attachId);
|
return R.data(bladeFile);
|
}
|
|
/**
|
* 上传文件并保存至附件表
|
*
|
* @param fileName 存储桶对象名称
|
* @param file 文件
|
* @return ObjectStat
|
*/
|
@SneakyThrows
|
@PostMapping("/put-file-attach-by-name")
|
public R<BladeFile> putFileAttach(@RequestParam String fileName, @RequestParam MultipartFile file, String deptid, String type, Long noticeId, String cardid) {
|
BladeFile bladeFile = ossBuilder.template().putFile(fileName, file.getInputStream());
|
Long attachId = buildAttach(fileName, file.getSize(), bladeFile, deptid, type, noticeId, cardid, file.getInputStream());
|
bladeFile.setAttachId(attachId);
|
return R.data(bladeFile);
|
}
|
|
/**
|
* 构建附件表
|
*
|
* @param fileName 文件名
|
* @param fileSize 文件大小
|
* @param bladeFile 对象存储文件
|
* @return attachId
|
*/
|
private Long buildAttach(String fileName, Long fileSize, BladeFile bladeFile, String deptid, String type, Long noticeId, String cardid, InputStream in) throws Exception {
|
//BladeUser user = AuthUtil.getUser();
|
String fileExtension = org.springblade.core.tool.utils.FileUtil.getFileExtension(fileName);
|
Attach attach = new Attach();
|
attach.setDomain(bladeFile.getDomain());
|
attach.setTenantId("000000");
|
attach.setLink(bladeFile.getLink());
|
attach.setName(bladeFile.getName());
|
attach.setOriginalName(bladeFile.getOriginalName());
|
attach.setAttachSize(fileSize);
|
attach.setExtension(fileExtension);
|
attach.setDeptid(deptid);
|
attach.setCardid(cardid);
|
attach.setType(type);
|
if (null != noticeId) {
|
attach.setNoticeId(noticeId);
|
}
|
attachService.save(attach);
|
String[] split = bladeFile.getName().split("/");
|
String ip = FtpConfig.ip+"/zhba/upload/picture/";
|
String imgurl = ip + split[2];
|
FtpUtil.uploadFile(FtpConfig.ftpHost, ftpPort, FtpConfig.ftpUserName, ftpPassword, ftpPath, "/", "f"+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);
|
myAsyncService.FTP(s1);
|
return attach.getId();
|
}
|
|
/**
|
* 删除文件
|
*
|
* @param fileName 存储桶对象名称
|
* @return R
|
*/
|
@SneakyThrows
|
@PostMapping("/remove-file")
|
@PreAuth(RoleConstant.HAS_ROLE_ADMIN)
|
public R removeFile(@RequestParam String fileName) {
|
ossBuilder.template().removeFile(fileName);
|
return R.success("操作成功");
|
}
|
|
/**
|
* 批量删除文件
|
*
|
* @param fileNames 存储桶对象名称集合
|
* @return R
|
*/
|
@SneakyThrows
|
@PostMapping("/remove-files")
|
@PreAuth(RoleConstant.HAS_ROLE_ADMIN)
|
public R removeFiles(@RequestParam String fileNames) {
|
ossBuilder.template().removeFiles(Func.toStrList(fileNames));
|
return R.success("操作成功");
|
}
|
|
}
|
