From 3b55584efb14459e4343972253080f90f9084154 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 26 二月 2024 11:31:35 +0800
Subject: [PATCH] 按项目统计钻孔数据

---
 src/main/java/com/lf/server/controller/data/DataCountController.java |  120 +++++++++++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 103 insertions(+), 17 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..0c2248e 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,26 +39,110 @@
     @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()

--
Gitblit v1.9.3