From d268f82d25c25ebdc7a1ea30614f6cda6d3a9ae3 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期四, 10 十月 2024 16:31:41 +0800
Subject: [PATCH] win库+大屏考核指标查询bug

---
 ycl-server/src/main/java/com/ycl/platform/service/impl/YwPointServiceImpl.java |   23 +++++++++++++++++------
 1 files changed, 17 insertions(+), 6 deletions(-)

diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/YwPointServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/YwPointServiceImpl.java
index 3210871..4a4cbb4 100644
--- a/ycl-server/src/main/java/com/ycl/platform/service/impl/YwPointServiceImpl.java
+++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/YwPointServiceImpl.java
@@ -33,6 +33,8 @@
 import com.ycl.thread.PointImportCallable;
 import com.ycl.utils.DateUtils;
 import com.ycl.utils.SecurityUtils;
+import com.ycl.utils.poi.EasyExcelImportUtils;
+import constant.PointHeaderConstant;
 import jakarta.servlet.http.HttpServletResponse;
 import lombok.RequiredArgsConstructor;
 import org.springframework.beans.BeanUtils;
@@ -250,12 +252,12 @@
         }
         //瀹氫箟琛ㄥご鍒楄〃
         LinkedHashSet<String> headers = new LinkedHashSet<>();
-        headers.add("鐐逛綅鍚嶇О(鍙慨鏀�)");
-        headers.add("鍥芥爣鐮�(涓嶅彲淇敼)");
-        headers.add("鐐逛綅IP(鍙慨鏀�)");
-        headers.add("鏄惁鐪佸巺鏍囩(鍙慨鏀�)");
-        headers.add("鏄惁閲嶇偣鎸囨尌鍥惧儚(鍙慨鏀�)");
-        headers.add("鏄惁閮ㄧ骇鏍囩(鍙慨鏀�)");
+        headers.add(PointHeaderConstant.Point_Name);
+        headers.add(PointHeaderConstant.Serial_Number);
+        headers.add(PointHeaderConstant.IP);
+        headers.add(PointHeaderConstant.Province_Tag);
+        headers.add(PointHeaderConstant.Impotrant_Command_Image);
+        headers.add(PointHeaderConstant.Dept_Tag);
         List<String> headersList = new LinkedList<>();
         if (!CollectionUtils.isEmpty(dynamicsHeaders)) {
             //浣跨敤閾捐〃淇濊瘉鍚庣画琛ュ厖鏁版嵁鏃惰幏鍙栨暟鎹『搴忎竴鑷�
@@ -306,6 +308,7 @@
     @Override
     public Result importData(MultipartFile file, Integer unitId, Date startTime, Date endTime, Boolean
             needUpdateUnit) throws IOException {
+//        List<Map<String,String>> list = EasyExcelImportUtils.makeData(file);
         Consumer<List<PointExport>> consumer = (dataList) -> {
             try {
                 this.updatePoint(dataList, unitId, startTime, endTime, needUpdateUnit);
@@ -316,6 +319,14 @@
             }
         };
         EasyExcel.read(file.getInputStream(), PointExport.class, new CurrencyDataListener(consumer)).headRowNumber(1).doReadAll();
+//        for (Map<String, String> map : list) {
+//            PointExport pointExport = new PointExport();
+//            pointExport.setPointName(map.get(PointHeaderConstant.Point_Name));
+//            pointExport.setPointIP(map.get(PointHeaderConstant.IP));
+//            pointExport.setSerialNumber(map.get(PointHeaderConstant.Serial_Number));
+//        }
+//        this.updatePoint(dataList, unitId, startTime, endTime, needUpdateUnit);
+//        System.out.println(list);
         return Result.ok();
     }
 

--
Gitblit v1.8.0