XMPoleManager.git

			@@ -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;
			}