From 8235bb3cebd773ba6fe29719cba7706858bbc2ee Mon Sep 17 00:00:00 2001
From: liuhaonan <konodioda2333@vip.qq.com>
Date: 星期五, 01 四月 2022 14:20:09 +0800
Subject: [PATCH] 订单
---
ximon-admin/src/main/java/com/sandu/ximon/admin/service/LightReportDataService.java | 45 ++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 40 insertions(+), 5 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 3ce83ab..dfe8f31 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
@@ -1,16 +1,25 @@
package com.sandu.ximon.admin.service;
+import cn.hutool.core.io.FileUtil;
+import cn.hutool.core.util.RandomUtil;
+import com.alibaba.excel.EasyExcel;
+import com.alibaba.excel.ExcelWriter;
+import com.alibaba.excel.write.metadata.WriteSheet;
import com.github.pagehelper.PageHelper;
+import com.sandu.common.file.config.FileProperties;
import com.sandu.common.service.impl.BaseServiceImpl;
-import com.sandu.ximon.admin.dto.LightDataDto;
+import com.sandu.common.util.ResUtils;
import com.sandu.ximon.admin.manager.iot.frame.inner.report.A5LightHeartbeatReportInnerFrame;
-import com.sandu.ximon.dao.bo.LightBo;
import com.sandu.ximon.dao.bo.LightReportDataBo;
import com.sandu.ximon.dao.domain.LightReportData;
import com.sandu.ximon.dao.mapper.LightReportDataMapper;
+import lombok.AllArgsConstructor;
+import lombok.SneakyThrows;
import org.springframework.beans.BeanUtils;
+import org.springframework.core.io.ClassPathResource;
import org.springframework.stereotype.Service;
+import java.io.File;
import java.util.List;
/**
@@ -19,8 +28,10 @@
* 鐏笂鎶ユ暟鎹� service
*/
@Service
+@AllArgsConstructor
public class LightReportDataService extends BaseServiceImpl<LightReportDataMapper, LightReportData> {
+ private final FileProperties properties;
/**
* 淇濆瓨涓婃姤鐨勭伅蹇冭烦鏁版嵁
@@ -37,6 +48,7 @@
/**
* 鑾峰彇鎸囧畾璁惧鐮佹渶鏂扮殑涓�澶╀笂鎶ユ暟鎹�
+ *
* @param deviceCodeList 璁惧鐮佸垪琛�
* @return 涓婃姤鏁版嵁
*/
@@ -46,11 +58,34 @@
/**
* 鑾峰彇涓婃姤鏁版嵁
- * @param keyword 鍏抽敭璇�
+ *
+ * @param keyword 鍏抽敭璇�
* @param deviceCode 璁惧鐮�
*/
public List<LightReportDataBo> listReportData(int pageNo, int pageSize, String keyword, String deviceCode) {
- PageHelper.startPage(pageNo,pageSize);
- return baseMapper.listReportData(keyword,deviceCode);
+ PageHelper.startPage(pageNo, pageSize);
+ return baseMapper.listReportData(keyword, deviceCode);
+ }
+
+ @SneakyThrows
+ public String exportList(int pageNo, int pageSize, String keyword, String deviceCode) {
+ 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(properties.getUploadRootPath() + "export" + File.separator + RandomUtil.randomString(12) + ".xlsx");
+// ClassPathResource cpr = new ClassPathResource("public/exportOrder.xlsx");
+// FileUtil.mkParentDirs(file);
+//
+// ExcelWriter excelWriter = EasyExcel.write(file).withTemplate(cpr.getInputStream()).build();
+// WriteSheet writeSheet = EasyExcel.writerSheet().build();
+// 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);
+
+ // return list;
}
}
--
Gitblit v1.9.3