From bcc6047ef19e2bd7a83c7f6e6abcb2cd1d8107cc Mon Sep 17 00:00:00 2001
From: baizonghao <1719256278@qq.com>
Date: 星期五, 24 二月 2023 17:51:36 +0800
Subject: [PATCH] 按照报警时间统计

---
 ycl-platform/src/main/java/com/ycl/controller/intelligentPatrol/StatisticsController.java |   36 +++++++++++++++++++++---------------
 1 files changed, 21 insertions(+), 15 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 f37dedc..86f2ecf 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,12 +5,9 @@
 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.service.unlawful.UnlawfulService;
 import com.ycl.utils.EasyExcelUtils;
-import com.ycl.vo.casePool.QueryForViolationVO;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -20,8 +17,6 @@
 import javax.servlet.http.HttpServletResponse;
 import java.time.LocalDateTime;
 import java.time.format.DateTimeFormatter;
-import java.util.ArrayList;
-import java.util.Arrays;
 import java.util.List;
 
 /**
@@ -106,18 +101,29 @@
         return CommonResult.success(page);
     }
 
-    /*@GetMapping("/unlawful/time")
+    @GetMapping("/unlawful/time")
     @ApiOperation("鎸夋椂闂寸粺璁�")
     @LogSave(operationType = "鎸夋椂闂寸粺璁�", contain = "鏌ヨ")
     public CommonResult<IPage<UnlawfulDto>> searchByTime(@RequestParam(required = true) Integer currentPage,
                                                          @RequestParam(required = true) Integer pageSize,
                                                          @RequestParam(required = false) @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") LocalDateTime beginTime,
                                                          @RequestParam(required = false) @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") LocalDateTime endTime) {
+        DateTimeFormatter fmt = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
+        String startTime = null;
+        String endTime1 = null;
+        if (beginTime != null){
+            startTime = beginTime.format(fmt);
+        }
+        if (endTime != null){
+            endTime1 = beginTime.format(fmt);
+        }
         IPage<UnlawfulDto> page = new Page<>();
-        page.setTotal(ls.size());
-        page.setRecords(ls);
+        List<UnlawfulDto> unlawfulByType = unlawfulService.getUnlawfulByTime((currentPage - 1) * pageSize, pageSize, startTime, endTime1);
+
+        page.setTotal(unlawfulByType.size());
+        page.setRecords(unlawfulByType);
         return CommonResult.success(page);
-    }*/
+    }
 
     @GetMapping("/unlawful/area")
     @ApiOperation("鎸夊尯鍩熺粺璁�")
@@ -179,26 +185,26 @@
     }
 
     @PostMapping("/export/unlawful/type")
-    @ApiOperation("鎸夊悇绉嶇粺璁℃柟寮�-瀵煎嚭")
+    @ApiOperation("鎸夌被鍨嬬粺璁℃柟寮�-瀵煎嚭")
     public void exportType(HttpServletResponse response) {
         List<UnlawfulDto> unlawfulByTypeExport = unlawfulService.getUnlawfulByTypeExport();
-        String sheetName = "鎸夌粺璁℃柟寮�";
+        String sheetName = "鎸夌被鍨嬬粺璁℃柟寮�";
         EasyExcelUtils.export(response, sheetName, UnlawfulDto.class, unlawfulByTypeExport);
     }
 
     @PostMapping("/export/unlawful/street")
-    @ApiOperation("鎸夊悇绉嶇粺璁℃柟寮�-瀵煎嚭")
+    @ApiOperation("鎸夊尯鍩熺粺璁℃柟寮�-瀵煎嚭")
     public void exportStreet(HttpServletResponse response) {
         List<UnlawfulDto> unlawfulByStreetExport = unlawfulService.getUnlawfulByStreetExport();
-        String sheetName = "鎸夌粺璁℃柟寮�";
+        String sheetName = "鎸夊尯鍩熺粺璁℃柟寮�";
         EasyExcelUtils.export(response, sheetName, UnlawfulDto.class, unlawfulByStreetExport);
     }
 
     @PostMapping("/export/unlawful/site")
-    @ApiOperation("鎸夊悇绉嶇粺璁℃柟寮�-瀵煎嚭")
+    @ApiOperation("鎸夋姤璀︾偣浣嶇粺璁℃柟寮�-瀵煎嚭")
     public void exportSite(HttpServletResponse response) {
         List<UnlawfulDto> unlawfulBySiteExport = unlawfulService.getUnlawfulBySiteExport();
-        String sheetName = "鎸夌粺璁℃柟寮�";
+        String sheetName = "鎸夋姤璀︾偣浣嶇粺璁℃柟寮�";
         EasyExcelUtils.export(response, sheetName, UnlawfulDto.class, unlawfulBySiteExport);
     }
 

--
Gitblit v1.8.0