From a0912fe376f382cf7056e9ff3bc87a607681c981 Mon Sep 17 00:00:00 2001
From: zhanghua <314079846@qq.com>
Date: 星期二, 21 三月 2023 11:35:41 +0800
Subject: [PATCH] 驾驶舱接口优化
---
ycl-platform/src/main/java/com/ycl/controller/intelligentPatrol/StatisticsController.java | 190 +++++++++++++++++++++++++++++++++++++++++------
1 files changed, 165 insertions(+), 25 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 7a62da9..5fcdd02 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,18 +5,20 @@
import com.ycl.annotation.LogSave;
import com.ycl.api.CommonResult;
import com.ycl.controller.BaseController;
-import com.ycl.dto.statistics.UnlawfulTypeDto;
-import com.ycl.vo.equipment.HandheldTerminalVo;
+import com.ycl.dto.statistics.UnlawfulDto;
+import com.ycl.service.unlawful.UnlawfulService;
+import com.ycl.utils.EasyExcelUtils;
+import com.ycl.vo.cockpit.CockpitVO;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
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.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
import java.time.LocalDateTime;
-import java.util.ArrayList;
+import java.time.format.DateTimeFormatter;
import java.util.List;
/**
@@ -31,32 +33,170 @@
@Api(tags = "杩濈珷-杩濇硶缁熻")
public class StatisticsController extends BaseController {
+// List<UnlawfulDto> ls = new ArrayList<>(Arrays.asList(
+// new UnlawfulDto("甯傚満鐩戠", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("鍏畨", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("鑷劧璧勬簮", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("鐢熸�佺幆澧�", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("鍦版柟绔嬫硶", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("鍦伴渿", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("鏁欒偛", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("缁忎俊", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("鏋椾笟", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("鍐滄潙鐜鍗敓", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("姘旇薄", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("浜洪槻", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("姘磋鏀�", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("搴旀�ョ鐞�", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0),
+// new UnlawfulDto("鍏朵粬", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9, 0.0))
+// );
+
+ @Autowired
+ private UnlawfulService unlawfulService;
+
@GetMapping("/unlawful/type")
@ApiOperation("鎸夎繚瑙勭被鍨嬬粺璁�")
@LogSave(operationType = "鎸夎繚瑙勭被鍨嬬粺璁�", contain = "鏌ヨ")
- public CommonResult<IPage<UnlawfulTypeDto>> searchByType(@RequestParam(required = true) Integer currentPage,
+ public CommonResult<IPage<UnlawfulDto>> searchByType(@RequestParam(required = true) Integer currentPage,
+ @RequestParam(required = true) Integer pageSize,
+ @RequestParam(required = false) String beginTime,
+ @RequestParam(required = false) String endTime) {
+
+ IPage<UnlawfulDto> page = unlawfulService.getUnlawfulByType(currentPage, pageSize, beginTime, endTime);
+
+ return CommonResult.success(page);
+ }
+
+ @GetMapping("/unlawful/point")
+ @ApiOperation("鎸夌偣浣嶇粺璁�")
+ @LogSave(operationType = "鎸夌偣浣嶇粺璁�", contain = "鏌ヨ")
+ public CommonResult<IPage<UnlawfulDto>> searchByPoint(@RequestParam(required = true) Integer currentPage,
+ @RequestParam(required = true) Integer pageSize,
+ @RequestParam(required = false) String beginTime,
+ @RequestParam(required = false) String endTime) {
+
+ IPage<UnlawfulDto> page = unlawfulService.getUnlawfulByPoint(currentPage, pageSize, beginTime, endTime);
+
+ return CommonResult.success(page);
+ }
+
+ @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) String beginTime,
+ @RequestParam(required = false) String endTime) {
+
+ IPage<UnlawfulDto> page = unlawfulService.getUnlawfulByTime(currentPage, pageSize, beginTime, endTime);
+
+ return CommonResult.success(page);
+ }
+
+ @GetMapping("/unlawful/area")
+ @ApiOperation("鎸夊尯鍩熺粺璁�")
+ @LogSave(operationType = "鎸夊尯鍩熺粺璁�", contain = "鏌ヨ")
+ public CommonResult<IPage<UnlawfulDto>> searchByArea(@RequestParam(required = true) Integer currentPage,
+ @RequestParam(required = true) Integer pageSize,
+ @RequestParam(required = false) String beginTime,
+ @RequestParam(required = false) String endTime) {
+ IPage<UnlawfulDto> page = unlawfulService.getUnlawfulByStreet(currentPage, pageSize, beginTime, endTime);
+
+ return CommonResult.success(page);
+ }
+
+ /*@GetMapping("/unlawful/shop")
+ @ApiOperation("闂ㄥ墠涓夊寘缁熻")
+ @LogSave(operationType = "闂ㄥ墠涓夊寘缁熻", contain = "鏌ヨ")
+ public CommonResult<IPage<UnlawfulShopDto>> searchByShop(@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) {
- IPage<UnlawfulTypeDto> page = new Page<>();
- List<UnlawfulTypeDto> ls = new ArrayList<>();
- ls.add(new UnlawfulTypeDto("甯傚満鐩戠", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("鍏畨", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("鑷劧璧勬簮", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("鐢熸�佺幆澧�", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("鍦版柟绔嬫硶", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("鍦伴渿", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("鏁欒偛", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("缁忎俊", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("鏋椾笟", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("鍐滄潙鐜鍗敓", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("姘旇薄", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("浜洪槻", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("姘磋鏀�", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("搴旀�ョ鐞�", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
- ls.add(new UnlawfulTypeDto("鍏朵粬", 100, 0.6, 10, 1, 20, 5, 20, 0.6, 0.9));
+ IPage<UnlawfulShopDto> page = new Page<>();
+ 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));
page.setTotal(ls.size());
page.setRecords(ls);
return CommonResult.success(page);
+ }*/
+
+// @PostMapping("/export/unlawful")
+// @ApiOperation("鎸夊悇绉嶇粺璁℃柟寮�-瀵煎嚭")
+// public void export(HttpServletResponse response) {
+// List<UnlawfulDto> unlawfulByTypeExport = unlawfulService.getUnlawfulByTypeExport();
+// String sheetName = "鎸夌粺璁℃柟寮�";
+// EasyExcelUtils.export(response, sheetName, UnlawfulDto.class, unlawfulByTypeExport);
+// }
+
+ @PostMapping("/export/unlawful/type")
+ @ApiOperation("鎸夌被鍨嬬粺璁℃柟寮�-瀵煎嚭")
+ public void exportType(HttpServletResponse response,
+ @RequestBody CockpitVO vo) {
+ IPage<UnlawfulDto> page = unlawfulService.getUnlawfulByType(1, 500, vo.getBeginTime(), vo.getEndTime());
+ String sheetName = "鎸夌粺璁℃柟寮�";
+ EasyExcelUtils.export(response, sheetName, UnlawfulDto.class, page.getRecords());
}
+
+ @PostMapping("/export/unlawful/street")
+ @ApiOperation("鎸夊尯鍩熺粺璁℃柟寮�-瀵煎嚭")
+ public void exportStreet(HttpServletResponse response,
+ @RequestBody CockpitVO vo) {
+ IPage<UnlawfulDto> page = unlawfulService.getUnlawfulByStreet(1, 500, vo.getBeginTime(), vo.getEndTime());
+
+ String sheetName = "鎸夊尯鍩熺粺璁℃柟寮�";
+ EasyExcelUtils.export(response, sheetName, UnlawfulDto.class, page.getRecords());
+ }
+
+ @PostMapping("/export/unlawful/site")
+ @ApiOperation("鎸夋姤璀︾偣浣嶇粺璁℃柟寮�-瀵煎嚭")
+ public void exportSite(HttpServletResponse response,
+ @RequestBody CockpitVO vo) {
+ IPage<UnlawfulDto> page = unlawfulService.getUnlawfulByPoint(1, 500, vo.getBeginTime(), vo.getEndTime());
+
+ String sheetName = "鎸夋姤璀︾偣浣嶇粺璁℃柟寮�";
+ EasyExcelUtils.export(response, sheetName, UnlawfulDto.class, page.getRecords());
+ }
+
+ @PostMapping("/export/unlawful/time")
+ @ApiOperation("鎸夋姤璀︾偣浣嶇粺璁℃柟寮�-瀵煎嚭")
+ public void exportTime(HttpServletResponse response,
+ @RequestBody CockpitVO vo) {
+ IPage<UnlawfulDto> page = unlawfulService.getUnlawfulByTime(1, 500, vo.getBeginTime(), vo.getEndTime());
+
+ String sheetName = "鎸夋姤璀︾偣浣嶇粺璁℃柟寮�";
+ EasyExcelUtils.export(response, sheetName, UnlawfulDto.class, page.getRecords());
+ }
+
+ /*@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);
+ }*/
}
--
Gitblit v1.8.0