From b2dc3088b63fae558c80d91f16b146cf26eb6809 Mon Sep 17 00:00:00 2001
From: zhanghua <314079846@qq.com>
Date: 星期三, 11 一月 2023 15:34:00 +0800
Subject: [PATCH] Merge branch 'master' of http://42.193.1.25:9521/r/sccg_server

---
 ycl-platform/src/main/java/com/ycl/controller/intelligentPatrol/StatisticsController.java |   36 ++++++++++++++++++++++++++++++++----
 ycl-platform/src/main/java/com/ycl/dto/statistics/UnlawfulDto.java                        |   12 ++++++++++++
 ycl-platform/src/main/java/com/ycl/dto/statistics/UnlawfulShopDto.java                    |    9 +++++++++
 3 files changed, 53 insertions(+), 4 deletions(-)

diff --git a/ycl-platform/src/main/java/com/ycl/controller/intelligentPatrol/StatisticsController.java b/ycl-platform/src/main/java/com/ycl/controller/intelligentPatrol/StatisticsController.java
index 2bfb1af..084a6b8 100644
--- a/ycl-platform/src/main/java/com/ycl/controller/intelligentPatrol/StatisticsController.java
+++ b/ycl-platform/src/main/java/com/ycl/controller/intelligentPatrol/StatisticsController.java
@@ -5,16 +5,17 @@
 import com.ycl.annotation.LogSave;
 import com.ycl.api.CommonResult;
 import com.ycl.controller.BaseController;
+import com.ycl.dto.caseHandler.QueryForViolationParam;
 import com.ycl.dto.statistics.UnlawfulDto;
 import com.ycl.dto.statistics.UnlawfulShopDto;
+import com.ycl.utils.EasyExcelUtils;
+import com.ycl.vo.casePool.QueryForViolationVO;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
 import org.springframework.format.annotation.DateTimeFormat;
-import org.springframework.web.bind.annotation.GetMapping;
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.RequestParam;
-import org.springframework.web.bind.annotation.RestController;
+import org.springframework.web.bind.annotation.*;
 
+import javax.servlet.http.HttpServletResponse;
 import java.time.LocalDateTime;
 import java.util.ArrayList;
 import java.util.Arrays;
@@ -129,4 +130,31 @@
         return CommonResult.success(page);
     }
 
+    @PostMapping("/export/unlawful")
+    @ApiOperation("鎸夊悇绉嶇粺璁℃柟寮�-瀵煎嚭")
+    public void export(HttpServletResponse response) {
+        String sheetName = "鎸夌粺璁℃柟寮�";
+        EasyExcelUtils.export(response, sheetName, UnlawfulDto.class, ls);
+    }
+
+    @PostMapping("/export/shop")
+    @ApiOperation("闂ㄥ墠涓夊寘-瀵煎嚭")
+    public void exportShop(HttpServletResponse response) {
+        List<UnlawfulShopDto> ls = new ArrayList<>();
+        ls.add(new UnlawfulShopDto("搴楅摵1", 100, 10, 1, 20, 5, 20, 0.6));
+        ls.add(new UnlawfulShopDto("搴楅摵2", 100, 10, 1, 20, 5, 20, 0.6));
+        ls.add(new UnlawfulShopDto("搴楅摵3", 100, 10, 1, 20, 5, 20, 0.6));
+        ls.add(new UnlawfulShopDto("搴楅摵4", 100, 10, 1, 20, 5, 20, 0.6));
+        ls.add(new UnlawfulShopDto("搴楅摵5", 100, 10, 1, 20, 5, 20, 0.6));
+        ls.add(new UnlawfulShopDto("搴楅摵6", 100, 10, 1, 20, 5, 20, 0.6));
+        ls.add(new UnlawfulShopDto("搴楅摵7", 100, 10, 1, 20, 5, 20, 0.6));
+        ls.add(new UnlawfulShopDto("搴楅摵8", 100, 10, 1, 20, 5, 20, 0.6));
+        ls.add(new UnlawfulShopDto("搴楅摵9", 100, 10, 1, 20, 5, 20, 0.6));
+        ls.add(new UnlawfulShopDto("搴楅摵10", 100, 10, 1, 20, 5, 20, 0.6));
+        ls.add(new UnlawfulShopDto("搴楅摵11", 100, 10, 1, 20, 5, 20, 0.7));
+        ls.add(new UnlawfulShopDto("搴楅摵12", 100, 10, 1, 20, 5, 20, 0.8));
+        ls.add(new UnlawfulShopDto("搴楅摵13", 100, 10, 1, 20, 5, 20, 0.9));
+        String sheetName = "闂ㄥ墠涓夊寘";
+        EasyExcelUtils.export(response, sheetName, UnlawfulShopDto.class, ls);
+    }
 }
diff --git a/ycl-platform/src/main/java/com/ycl/dto/statistics/UnlawfulDto.java b/ycl-platform/src/main/java/com/ycl/dto/statistics/UnlawfulDto.java
index 705bcce..bcd8e99 100644
--- a/ycl-platform/src/main/java/com/ycl/dto/statistics/UnlawfulDto.java
+++ b/ycl-platform/src/main/java/com/ycl/dto/statistics/UnlawfulDto.java
@@ -1,5 +1,6 @@
 package com.ycl.dto.statistics;
 
+import com.alibaba.excel.annotation.ExcelProperty;
 import lombok.AllArgsConstructor;
 import lombok.Data;
 import lombok.NoArgsConstructor;
@@ -20,55 +21,66 @@
     /**
      * 绫诲瀷鍚嶇О
      */
+    @ExcelProperty(value = "绫诲瀷鍚嶇О", index = 0)
     private String name;
 
     /**
      * 浜嬩欢鎬绘暟
      */
+    @ExcelProperty(value = "浜嬩欢鎬绘暟", index = 1)
     private Integer count;
 
     /**
      * 鍗犳瘮
      */
+    @ExcelProperty(value = "鍗犳瘮", index = 2)
     private Double ratio;
 
     /**
      * 绔嬫
      */
+    @ExcelProperty(value = "绔嬫", index = 3)
     private Integer register;
 
     /**
      * 鏆備笉绔嬫
      */
+    @ExcelProperty(value = "鏆備笉绔嬫", index = 4)
     private Integer notRegister;
 
     /**
      * 缁撴
      */
+    @ExcelProperty(value = "缁撴", index = 5)
     private Integer closing;
 
     /**
      * 鍐嶅涔�
      */
+    @ExcelProperty(value = "鍐嶅涔�", index = 6)
     private Integer relearn;
 
     /**
      * 宸插鏍�
      */
+    @ExcelProperty(value = "宸插鏍�", index = 7)
     private Integer checked;
 
     /**
      * 瀹℃牳鐜�
      */
+    @ExcelProperty(value = "瀹℃牳鐜�", index = 8)
     private Double checkedRatio;
 
     /**
      * 绔嬫鐜�
      */
+    @ExcelProperty(value = "绔嬫鐜�", index = 9)
     private Double registerRatio;
 
     /**
      * 鍑嗙‘鐜�
      */
+    @ExcelProperty(value = "鍑嗙‘鐜�", index = 10)
     private Double accuracyRatio;
 }
diff --git a/ycl-platform/src/main/java/com/ycl/dto/statistics/UnlawfulShopDto.java b/ycl-platform/src/main/java/com/ycl/dto/statistics/UnlawfulShopDto.java
index 008bc80..2bc9b9e 100644
--- a/ycl-platform/src/main/java/com/ycl/dto/statistics/UnlawfulShopDto.java
+++ b/ycl-platform/src/main/java/com/ycl/dto/statistics/UnlawfulShopDto.java
@@ -1,5 +1,6 @@
 package com.ycl.dto.statistics;
 
+import com.alibaba.excel.annotation.ExcelProperty;
 import lombok.AllArgsConstructor;
 import lombok.Data;
 import lombok.NoArgsConstructor;
@@ -20,42 +21,50 @@
     /**
      * 鍟嗘埛鍚嶇О
      */
+    @ExcelProperty(value = "鍟嗘埛鍚嶇О", index = 0)
     private String name;
 
     /**
      * 浜嬩欢鎬绘暟
      */
+    @ExcelProperty(value = "浜嬩欢鎬绘暟", index = 1)
     private Integer count;
 
     /**
      * 鍖呭崼鐢�
      */
+    @ExcelProperty(value = "鍖呭崼鐢�", index = 2)
     private Integer sanitation;
 
     /**
      * 鍖呯З缁�
      */
+    @ExcelProperty(value = "鍖呯З缁�", index = 3)
     private Integer orderliness;
 
     /**
      * 鍖呰鏂�
      */
+    @ExcelProperty(value = "鍖呰鏂�", index = 4)
     private Integer facility;
 
     /**
      * 绔嬫
      */
+    @ExcelProperty(value = "绔嬫", index = 5)
     private Integer register;
 
     /**
      * 宸插鏍�
      */
+    @ExcelProperty(value = "宸插鏍�", index = 6)
     private Integer checked;
 
 
     /**
      * 绔嬫鐜�
      */
+    @ExcelProperty(value = "绔嬫鐜�", index = 7)
     private Double registerRatio;
 
 }

--
Gitblit v1.8.0