From 8a2bfef1ebf3a1e24f770d3481ff82856f14d9e0 Mon Sep 17 00:00:00 2001
From: aijinhui <aijinhui>
Date: 星期五, 24 十一月 2023 15:47:42 +0800
Subject: [PATCH] 设备运行状态

---
 ard-work/src/main/java/com/ruoyi/alarmpoints/well/controller/ArdAlarmpointsWellController.java |   96 ++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 92 insertions(+), 4 deletions(-)

diff --git a/ard-work/src/main/java/com/ruoyi/alarmpoints/well/controller/ArdAlarmpointsWellController.java b/ard-work/src/main/java/com/ruoyi/alarmpoints/well/controller/ArdAlarmpointsWellController.java
index 79aa9f5..9b44f0b 100644
--- a/ard-work/src/main/java/com/ruoyi/alarmpoints/well/controller/ArdAlarmpointsWellController.java
+++ b/ard-work/src/main/java/com/ruoyi/alarmpoints/well/controller/ArdAlarmpointsWellController.java
@@ -3,11 +3,26 @@
 
 import javax.annotation.Resource;
 import javax.servlet.http.HttpServletResponse;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
 import com.ruoyi.alarmpoints.well.domain.ArdAlarmpointsWell;
+import com.ruoyi.alarmpoints.well.domain.ArdAlarmpointsWellParam;
 import com.ruoyi.alarmpoints.well.service.IArdAlarmpointsWellService;
+import com.ruoyi.common.core.domain.entity.SysUser;
+import com.ruoyi.common.utils.SecurityUtils;
 import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.system.service.ISysDeptService;
+import com.ruoyi.system.service.ISysUserService;
+import com.ruoyi.utils.data.Query;
+import com.ruoyi.utils.pagehelper.JpaPageInfo;
+import com.ruoyi.utils.result.Results;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.dao.DuplicateKeyException;
+import org.springframework.http.HttpStatus;
+import org.springframework.http.ResponseEntity;
 import org.springframework.security.access.prepost.PreAuthorize;
 import org.springframework.web.bind.annotation.GetMapping;
 import org.springframework.web.bind.annotation.PostMapping;
@@ -23,6 +38,7 @@
 import com.ruoyi.common.enums.BusinessType;
 import com.ruoyi.common.core.page.TableDataInfo;
 import org.springframework.web.multipart.MultipartFile;
+
 import java.util.ArrayList;
 import java.util.HashMap;
 import java.util.List;
@@ -41,6 +57,12 @@
     @Resource
     private IArdAlarmpointsWellService ardAlarmpointsWellService;
 
+    @Autowired
+    private ISysUserService sysUserService;
+
+    @Autowired
+    private ISysDeptService sysDeptService;
+
     /**
      * 鏌ヨ浜曠鐞嗗垪琛�
      */
@@ -51,6 +73,14 @@
         startPage();
         List<ArdAlarmpointsWell> list = ardAlarmpointsWellService.selectArdAlarmpointsWellList(ardAlarmpointsWell);
         return getDataTable(list);
+    }
+
+    @PreAuthorize("@ss.hasPermi('alarmpoints:well:list')")
+    @GetMapping("/nonPageList")
+    @ApiOperation("鏌ヨ浜曞垪琛�-涓嶅垎椤�")
+    public AjaxResult nonPageList(ArdAlarmpointsWell ardAlarmpointsWell) {
+        List<ArdAlarmpointsWell> list = ardAlarmpointsWellService.selectArdAlarmpointsWellList(ardAlarmpointsWell);
+        return success(list);
     }
 
     /**
@@ -84,7 +114,11 @@
     @PostMapping
     @ApiOperation("鏂板浜�")
     public AjaxResult add(@RequestBody ArdAlarmpointsWell ardAlarmpointsWell) {
-        return toAjax(ardAlarmpointsWellService.insertArdAlarmpointsWell(ardAlarmpointsWell));
+        try {
+            return toAjax(ardAlarmpointsWellService.insertArdAlarmpointsWell(ardAlarmpointsWell));
+        } catch (Exception e) {
+            return AjaxResult.error(e.getMessage());
+        }
     }
 
     /**
@@ -95,7 +129,11 @@
     @PutMapping
     @ApiOperation("淇敼浜�")
     public AjaxResult edit(@RequestBody ArdAlarmpointsWell ardAlarmpointsWell) {
-        return toAjax(ardAlarmpointsWellService.updateArdAlarmpointsWell(ardAlarmpointsWell));
+        try {
+            return toAjax(ardAlarmpointsWellService.updateArdAlarmpointsWell(ardAlarmpointsWell));
+        } catch (Exception e) {
+            return AjaxResult.error(e.getMessage());
+        }
     }
 
     /**
@@ -115,9 +153,9 @@
     @ApiOperation("瀵煎叆浜�")
     public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception {
         ExcelUtil<ArdAlarmpointsWell> util = new ExcelUtil<ArdAlarmpointsWell>(ArdAlarmpointsWell.class);
-        List<ArdAlarmpointsWell> userList = util.importExcel(file.getInputStream());
+        List<ArdAlarmpointsWell> wellList = util.importExcel(file.getInputStream());
         String operName = getUsername();
-        String message = ardAlarmpointsWellService.importUser(userList, updateSupport, operName);
+        String message = ardAlarmpointsWellService.importWell(wellList, updateSupport, operName);
         return success(message);
     }
 
@@ -145,4 +183,54 @@
         }
         return options;
     }
+
+    @GetMapping("/wellById/{id}")
+    @ApiOperation("鏌ヨ鍗曟潯鍏磋叮鐐�")
+    public Results wellById(@PathVariable String id) {
+        return Results.succeed(ardAlarmpointsWellService.wellById(id));
+    }
+
+    @PostMapping("/wellList")
+    @ApiOperation("鏌ヨ鏉冮檺涓嬫墍鏈夊叴瓒g偣")
+    public Results wellList() {
+        String usersId = SecurityUtils.getUserId();
+        //鏍规嵁userId鏌ヨ閮ㄩ棬Id
+        SysUser sysUser = sysUserService.selectUserById(usersId);
+        //鏍规嵁褰撳墠deptId鎴栬�呭綋鍓嶅強鎵�灞炰笅绾х殑鎵�鏈塪eptId
+        List<Long> deptList = sysDeptService.deptIdBySub(sysUser.getDeptId());
+        //鏍规嵁deptId鑾峰彇瀵瑰簲鍏磋叮鐐规暟鎹�
+        List<ArdAlarmpointsWell> list = ardAlarmpointsWellService.wellList(deptList);
+        return Results.succeed(list);
+    }
+
+    @PostMapping("/conditionList")
+    @ApiOperation("鏌ヨ骞剁瓫閫夋潈闄愪笅鎵�鏈夊叴瓒g偣")
+    public Results conditionList(ArdAlarmpointsWellParam ardAlarmpointsWellParam) {
+        String usersId = SecurityUtils.getUserId();
+        //鏍规嵁userId鏌ヨ閮ㄩ棬Id
+        SysUser sysUser = sysUserService.selectUserById(usersId);
+        //鏍规嵁褰撳墠deptId鎴栬�呭綋鍓嶅強鎵�灞炰笅绾х殑鎵�鏈塪eptId
+        List<Long> deptList = sysDeptService.deptIdBySub(sysUser.getDeptId());
+        ardAlarmpointsWellParam.setDeptList(deptList);
+        //鏍规嵁deptId鑾峰彇瀵瑰簲鍏磋叮鐐规暟鎹�
+        return Results.succeed(ardAlarmpointsWellService.conditionList(ardAlarmpointsWellParam));
+    }
+
+    @PostMapping("/getNearbyWells")
+    @ApiOperation("鏌ヨ闄勮繎鐨勬墍鏈変簳")
+    public AjaxResult getNearbyWells(Double longitude,Double latitude, Long deptId, Integer pageNum, Integer pageSize) {
+        JpaPageInfo jpaPageInfo = new JpaPageInfo();
+        jpaPageInfo.setPageNum(pageNum);
+        jpaPageInfo.setPageSize(pageSize);
+        List<ArdAlarmpointsWell> nearbyWellList = ardAlarmpointsWellService.getNearbyWellList(longitude,latitude, deptId, 1000);
+        jpaPageInfo.doPage(nearbyWellList);
+        return AjaxResult.success(jpaPageInfo);
+    }
+
+    @GetMapping("/getRTUDataYJ8")
+    @ApiOperation("鏌ヨ璁惧杩愯鐘舵��")
+    public AjaxResult getRTUDataYJ8(String wellId){
+        return AjaxResult.success(Query.getRTUDataYJ8(wellId));
+    }
+
 }

--
Gitblit v1.9.3