From f849c87a07300020dbef300c79d1eacfc1439f84 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期三, 06 三月 2024 15:41:58 +0800 Subject: [PATCH] 修改数据统计控制器 --- src/main/java/com/lf/server/controller/data/DataCountController.java | 291 ++++++++++++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 273 insertions(+), 18 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..c70fb78 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,10 @@ package com.lf.server.controller.data; import com.lf.server.annotation.SysLog; +import com.lf.server.controller.all.BaseController; import com.lf.server.controller.all.BaseQueryController; 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; @@ -15,10 +17,10 @@ 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.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; +import java.util.List; /** * 鏁版嵁缁熻 @@ -27,7 +29,7 @@ @Api(tags = "鏁版嵁绠$悊\\鏁版嵁缁熻") @RestController @RequestMapping("/dataCount") -public class DataCountController extends BaseQueryController { +public class DataCountController extends BaseController { @Autowired ReportService reportService; @@ -37,32 +39,116 @@ @Autowired 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") }) @GetMapping(value = "/downloadReport") public void downloadReport(Integer id, HttpServletRequest req, HttpServletResponse res) { @@ -83,4 +169,173 @@ 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); + } + } } -- Gitblit v1.9.3