From e55b5aaddc111abc8ae61260eb20fddf6b089c07 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 21 三月 2024 14:09:10 +0800
Subject: [PATCH] 修改分类统计功能
---
src/main/java/com/lf/server/controller/data/DataCountController.java | 403 ++++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 378 insertions(+), 25 deletions(-)
diff --git a/src/main/java/com/lf/server/controller/data/DataCountController.java b/src/main/java/com/lf/server/controller/data/DataCountController.java
index 87af627..0c41db0 100644
--- a/src/main/java/com/lf/server/controller/data/DataCountController.java
+++ b/src/main/java/com/lf/server/controller/data/DataCountController.java
@@ -1,8 +1,9 @@
package com.lf.server.controller.data;
import com.lf.server.annotation.SysLog;
-import com.lf.server.controller.all.BaseQueryController;
+import com.lf.server.controller.all.BaseController;
import com.lf.server.entity.all.ResponseMsg;
+import com.lf.server.entity.ctrl.CountEntity;
import com.lf.server.entity.sys.ReportEntity;
import com.lf.server.entity.sys.UserEntity;
import com.lf.server.helper.StringHelper;
@@ -13,12 +14,12 @@
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
-import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
-import org.springframework.web.multipart.MultipartFile;
+import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
+import java.util.List;
/**
* 鏁版嵁缁熻
@@ -27,45 +28,130 @@
@Api(tags = "鏁版嵁绠＄悊\\鏁版嵁缁熻")
@RestController
@RequestMapping("/dataCount")
-public class DataCountController extends BaseQueryController {
- @Autowired
+public class DataCountController extends BaseController {
+ @Resource
ReportService reportService;
- @Autowired
+ @Resource
TokenService tokenService;
- @Autowired
+ @Resource
UploadAttachService uploadAttachService;
- private final static String TAB_NAME = "lf.sys_report";
-
@SysLog()
- @ApiOperation(value = "涓婁紶鏂囦欢")
- @ResponseBody
- @PostMapping(value = "/upload")
- public ResponseMsg<String> upload(@RequestParam("file") MultipartFile file, HttpServletRequest req) {
- UserEntity ue = tokenService.getCurrentUser(req);
+ @ApiOperation(value = "鍒嗛〉鏌ヨ骞惰繑鍥炶褰曟暟")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "name", value = "鍚嶇О", dataType = "String", paramType = "query", example = ""),
+ @ApiImplicitParam(name = "code", value = "缂栫爜", dataType = "String", paramType = "query", example = "countOperates"),
+ @ApiImplicitParam(name = "pageSize", value = "姣忛〉鏉℃暟", dataType = "Integer", paramType = "query", example = "10"),
+ @ApiImplicitParam(name = "pageIndex", value = "鍒嗛〉鏁帮紙浠�1寮�濮嬶級", dataType = "Integer", paramType = "query", example = "1")
+ })
+ @GetMapping(value = "/selectByPageAndCount")
+ public ResponseMsg<List<ReportEntity>> selectByPageAndCount(String name, String code, Integer pageSize, Integer pageIndex) {
+ try {
+ if (pageSize < 1 || pageIndex < 1) {
+ return fail("姣忛〉椤垫暟鎴栧垎椤垫暟灏忎簬1", null);
+ }
- return uploadAttachService.upload(ue, TAB_NAME, file, this);
+ int count = reportService.selectCount(name, code);
+ if (count == 0) {
+ return success(0, null);
+ }
+
+ List<ReportEntity> rs = reportService.selectByPage(name, code, pageSize, pageSize * (pageIndex - 1));
+
+ return success(count, rs);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
}
@SysLog()
- @ApiOperation(value = "涓嬭浇鏂囦欢")
- @ApiImplicitParams({
- @ApiImplicitParam(name = "guid", value = "闄勪欢Guid", dataType = "String", paramType = "body")
- })
- @GetMapping(value = "/download")
- public void download(String guid, HttpServletResponse res) {
- uploadAttachService.download(guid, res);
+ @ApiOperation(value = "鏌ヨ鏁版嵁閲忕粺璁�")
+ @GetMapping(value = "/selectCountSizes")
+ public ResponseMsg<Object> selectCountSizes() {
+ try {
+ List<CountEntity> list = reportService.countSizes();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夋枃浠剁被鍨嬬粺璁�")
+ @GetMapping(value = "/countSizesByType")
+ public ResponseMsg<Object> countSizesByType() {
+ try {
+ List<CountEntity> list = reportService.countSizesByType();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鏌ヨ鏈嶅姟璋冪敤閲忕粺璁�")
+ @GetMapping(value = "/selectCountServices")
+ public ResponseMsg<Object> selectCountServices() {
+ try {
+ List<CountEntity> list = reportService.countServices();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鏌ヨ鐢ㄦ埛娴侀噺缁熻")
+ @GetMapping(value = "/selectCountOperates")
+ public ResponseMsg<Object> selectCountOperates() {
+ try {
+ List<CountEntity> list = reportService.countOperates();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁℃暟鎹�")
+ @GetMapping(value = "/countSizesByPrj")
+ public ResponseMsg<Object> countSizesByPrj() {
+ try {
+ List<CountEntity> list = reportService.countSizesByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁￠捇瀛旀暟鎹�")
+ @GetMapping(value = "/countExplorationPoints")
+ public ResponseMsg<Object> countExplorationPoints() {
+ try {
+ List<CountEntity> list = reportService.countExplorationPoints();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
}
@SysLog()
@ApiOperation(value = "涓嬭浇鎶ュ憡")
@ApiImplicitParams({
- @ApiImplicitParam(name = "id", value = "鎶ュ憡ID", dataType = "Integer", paramType = "7")
+ @ApiImplicitParam(name = "id", value = "鎶ュ憡ID", dataType = "Integer", paramType = "query", example = "18"),
+ @ApiImplicitParam(name = "code", value = "鐩綍缂栫爜", dataType = "String", paramType = "query", example = "00"),
})
@GetMapping(value = "/downloadReport")
- public void downloadReport(Integer id, HttpServletRequest req, HttpServletResponse res) {
+ public void downloadReport(Integer id, String code, HttpServletRequest req, HttpServletResponse res) {
try {
if (null == id || id < 1) {
return;
@@ -78,9 +164,276 @@
UserEntity ue = tokenService.getCurrentUser(req);
- reportService.createReport(ue, re, res);
+ reportService.createReport(ue, re, code, res);
} catch (Exception ex) {
log.error(ex.getMessage(), ex);
}
}
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁℃暟瀛楅珮绋嬫ā鍨嬮潰绉�")
+ @GetMapping(value = "/countDemAreaByPrj")
+ public ResponseMsg<Object> countDemAreaByPrj() {
+ try {
+ List<CountEntity> list = reportService.countDemAreaByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁′笁缁村湴褰㈡ā鍨嬮潰绉�")
+ @GetMapping(value = "/countMptAreaByPrj")
+ public ResponseMsg<Object> countMptAreaByPrj() {
+ try {
+ List<CountEntity> list = reportService.countMptAreaByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁″�炬枩鎽勫奖妯″瀷闈㈢Н")
+ @GetMapping(value = "/countOsgbAreaByPrj")
+ public ResponseMsg<Object> countOsgbAreaByPrj() {
+ try {
+ List<CountEntity> list = reportService.countOsgbAreaByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁℃縺鍏夌偣浜戞ā鍨嬮潰绉�")
+ @GetMapping(value = "/countLasAreaByPrj")
+ public ResponseMsg<Object> countLasAreaByPrj() {
+ try {
+ List<CountEntity> list = reportService.countLasAreaByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁″嫎瀵熷伐鐐逛釜鏁�")
+ @GetMapping(value = "/countSurveyWorksiteByPrj")
+ public ResponseMsg<Object> countSurveyWorksiteByPrj() {
+ try {
+ List<CountEntity> list = reportService.countSurveyWorksiteByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁″嫎瀵熸姤鍛婁釜鏁�")
+ @GetMapping(value = "/countExplorationReportByPrj")
+ public ResponseMsg<Object> countExplorationReportByPrj() {
+ try {
+ List<CountEntity> list = reportService.countExplorationReportByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁″穿濉屼釜鏁�")
+ @GetMapping(value = "/countCollapseByPrj")
+ public ResponseMsg<Object> countCollapseByPrj() {
+ try {
+ List<CountEntity> list = reportService.countCollapseByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁℃偿鐭虫祦涓暟")
+ @GetMapping(value = "/countDebrisFlowByPrj")
+ public ResponseMsg<Object> countDebrisFlowByPrj() {
+ try {
+ List<CountEntity> list = reportService.countDebrisFlowByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁″湴闈㈠闄蜂釜鏁�")
+ @GetMapping(value = "/countGroundCollapseByPrj")
+ public ResponseMsg<Object> countGroundCollapseByPrj() {
+ try {
+ List<CountEntity> list = reportService.countGroundCollapseByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁￠珮闄¤竟鍧′釜鏁�")
+ @GetMapping(value = "/countHighSteepSlopeByPrj")
+ public ResponseMsg<Object> countHighSteepSlopeByPrj() {
+ try {
+ List<CountEntity> list = reportService.countHighSteepSlopeByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁℃粦鍧′釜鏁�")
+ @GetMapping(value = "/countLandSlideByPrj")
+ public ResponseMsg<Object> countLandSlideByPrj() {
+ try {
+ List<CountEntity> list = reportService.countLandSlideByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁′笉绋冲畾鏂滃潯涓暟")
+ @GetMapping(value = "/countUnstableSlopeByPrj")
+ public ResponseMsg<Object> countUnstableSlopeByPrj() {
+ try {
+ List<CountEntity> list = reportService.countUnstableSlopeByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁℃按姣佷釜鏁�")
+ @GetMapping(value = "/countWaterDamageByPrj")
+ public ResponseMsg<Object> countWaterDamageByPrj() {
+ try {
+ List<CountEntity> list = reportService.countWaterDamageByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁℃暟瀛楃嚎鍒掑浘闈㈢Н")
+ @GetMapping(value = "/countDlgAreaByPrj")
+ public ResponseMsg<Object> countDlgAreaByPrj() {
+ try {
+ List<CountEntity> list = reportService.countDlgAreaByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁℃暟瀛楁灏勫奖鍍忓浘闈㈢Н")
+ @GetMapping(value = "/countDomAreaByPrj")
+ public ResponseMsg<Object> countDomAreaByPrj() {
+ try {
+ List<CountEntity> list = reportService.countDomAreaByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁＄绾块暱搴�")
+ @GetMapping(value = "/countLineLength")
+ public ResponseMsg<Object> countLineLength() {
+ try {
+ List<CountEntity> list = reportService.countLineLength();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁″嫎鎺㈢偣涓暟")
+ @GetMapping(value = "/countExplorationPointByPrj")
+ public ResponseMsg<Object> countExplorationPointByPrj() {
+ try {
+ List<CountEntity> list = reportService.countExplorationPointByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁′笁缁村湴璐ㄦā鍨嬮潰绉�")
+ @GetMapping(value = "/countGeoModelAreaByPrj")
+ public ResponseMsg<Object> countGeoModelAreaByPrj() {
+ try {
+ List<CountEntity> list = reportService.countGeoModelAreaByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鎸夐」鐩粺璁″湴鐏剧偣涓暟")
+ @GetMapping(value = "/countGeologicHazardByPrj")
+ public ResponseMsg<Object> countGeologicHazardByPrj() {
+ try {
+ List<CountEntity> list = reportService.countGeologicHazardByPrj();
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "椤圭洰鏁版嵁鍒嗙被缁熻")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "code", value = "椤圭洰缂栫爜", dataType = "String", paramType = "query", example = "0B")
+ })
+ @GetMapping(value = "/countVariousDataByPrj")
+ public ResponseMsg<Object> countVariousDataByPrj(String code) {
+ try {
+ if (StringHelper.isEmpty(code)) {
+ return fail("椤圭洰缂栫爜涓嶈兘涓虹┖");
+ }
+
+ List<CountEntity> list = reportService.countVariousDataByPrj(code);
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
}
--
Gitblit v1.9.3