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