From ab060213fe5b62ba8bf9b87c8a93ba7e9fea05db Mon Sep 17 00:00:00 2001
From: liuhaonan <konodioda2333@vip.qq.com>
Date: 星期六, 02 四月 2022 11:39:01 +0800
Subject: [PATCH] 单灯数据导出
---
ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightReportDataService.java | 16 ++++++++++++----
1 files changed, 12 insertions(+), 4 deletions(-)
diff --git a/ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightReportDataService.java b/ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightReportDataService.java
index 3239d23..54b4d4e 100644
--- a/ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightReportDataService.java
+++ b/ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightReportDataService.java
@@ -6,7 +6,9 @@
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.github.pagehelper.PageHelper;
+import com.sandu.common.file.FileUploadDto;
import com.sandu.common.file.config.FileProperties;
+import com.sandu.common.file.impl.AliOssFileServiceImpl;
import com.sandu.common.service.impl.BaseServiceImpl;
import com.sandu.common.util.ResUtils;
import com.sandu.ximon.admin.manager.iot.frame.inner.report.A5LightHeartbeatReportInnerFrame;
@@ -18,6 +20,7 @@
import org.springframework.beans.BeanUtils;
import org.springframework.core.io.ClassPathResource;
import org.springframework.stereotype.Service;
+import org.springframework.web.multipart.MultipartFile;
import java.io.File;
import java.util.List;
@@ -32,6 +35,7 @@
public class LightReportDataService extends BaseServiceImpl<LightReportDataMapper, LightReportData> {
private final FileProperties properties;
+ private final AliOssFileServiceImpl fileService;
/**
* 淇濆瓨涓婃姤鐨勭伅蹇冭烦鏁版嵁
@@ -72,7 +76,7 @@
PageHelper.startPage(pageNo, pageSize);
List<LightReportDataBo> list = baseMapper.listReportData(keyword, deviceCode);
- File file = new File(properties.getUploadRootPath() + "export" + File.separator + RandomUtil.randomString(12) + ".xlsx");
+ File file = new File("./" + RandomUtil.randomString(12) + ".xlsx");
// File file = new File(properties.getUploadRootPath() + "export" + File.separator + RandomUtil.randomString(12) + ".xlsx");
// ClassPathResource cpr = new ClassPathResource("public/exportOrder.xlsx");
// FileUtil.mkParentDirs(file);
@@ -82,9 +86,13 @@
// excelWriter.fill(list, writeSheet);
// excelWriter.finish();
- EasyExcel.write(file, LightReportDataBo.class).sheet("鍗曠伅鏁版嵁").doWrite(list);
- String url = file.getPath().replace(properties.getUploadRootPath(), "");
- return ResUtils.addPrefix(url);
+ EasyExcel.write(file, LightReportDataBo.class).sheet("妯＄増").doWrite(list);
+
+ FileUploadDto fileUploadDto = fileService.uploadFile(file);
+// String url = file.getPath().replace(properties.getUploadRootPath(), "");
+ String url = fileUploadDto.getFileUrl();
+ file.delete();
+ return url;
// return list;
}
--
Gitblit v1.9.3