From 5912cb4e4705b60875a2b1aa4beb1f7c94fc72e1 Mon Sep 17 00:00:00 2001
From: lizijie <lzjiiie@163.com>
Date: Thu, 23 Sep 2021 17:41:51 +0800
Subject: [PATCH] 通过组织id获取政府站点列表

---
 screen-manage/src/main/java/com/moral/api/service/GovMonitorPointService.java          |    9 ++++
 screen-manage/src/main/java/com/moral/api/service/impl/GovMonitorPointServiceImpl.java |   31 +++++++++++++++
 screen-manage/src/main/java/com/moral/api/controller/GovMonitorPoionController.java    |   21 ++++++++++
 3 files changed, 61 insertions(+), 0 deletions(-)

diff --git a/screen-manage/src/main/java/com/moral/api/controller/GovMonitorPoionController.java b/screen-manage/src/main/java/com/moral/api/controller/GovMonitorPoionController.java
index 0757047..7999b4e 100644
--- a/screen-manage/src/main/java/com/moral/api/controller/GovMonitorPoionController.java
+++ b/screen-manage/src/main/java/com/moral/api/controller/GovMonitorPoionController.java
@@ -3,7 +3,9 @@
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
 import com.moral.api.entity.GovMonitorPoint;
+import com.moral.api.entity.Organization;
 import com.moral.api.mapper.GovMonitorPointMapper;
+import com.moral.api.mapper.OrganizationMapper;
 import com.moral.api.service.GovMonitorPointService;
 import com.moral.constant.Constants;
 import com.moral.constant.ResponseCodeEnum;
@@ -40,6 +42,9 @@
 
     @Resource
     private GovMonitorPointMapper govMonitorPointMapper;
+
+    @Resource
+    private OrganizationMapper organizationMapper;
 
     @RequestMapping(value = "getGovMonitorPointByCondition", method = RequestMethod.GET)
     @ResponseBody
@@ -119,4 +124,20 @@
         List<Map<String, Object>> response = govMonitorPointService.selectGovMonitorPoints(regionCode);
         return ResultMessage.ok(response);
     }
+
+    @RequestMapping(value = "getGovMonitorPointsByOrgId", method = RequestMethod.GET)
+    @ResponseBody
+    public ResultMessage getGovMonitorPointsByOrgId(HttpServletRequest request){
+        Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+        Object orgid = parameters.get("organization_id");
+        if (ObjectUtils.isEmpty(orgid)){
+            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
+        }
+        Organization organization = organizationMapper.selectById(Integer.parseInt(orgid.toString()));
+        if (ObjectUtils.isEmpty(organization)){
+            return ResultMessage.fail(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getCode(), ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getMsg());
+        }
+        List<GovMonitorPoint> govMonitorPoints = govMonitorPointService.selectGovMonitorPointsByOrgid(parameters);
+        return  ResultMessage.ok(govMonitorPoints);
+    }
 }
diff --git a/screen-manage/src/main/java/com/moral/api/service/GovMonitorPointService.java b/screen-manage/src/main/java/com/moral/api/service/GovMonitorPointService.java
index 4f55fb7..be3353a 100644
--- a/screen-manage/src/main/java/com/moral/api/service/GovMonitorPointService.java
+++ b/screen-manage/src/main/java/com/moral/api/service/GovMonitorPointService.java
@@ -68,4 +68,13 @@
     //���������������������������������
     List<Map<String, Object>> selectGovMonitorPoints(String regionCode);
 
+    /**
+      *@Description: ������������id������������������������
+      *@Param: [map]
+      *@return: java.util.List<java.util.Map<java.lang.String,java.lang.Object>> 
+      *@Author: lizijie
+      *@Date: 2021/9/23 15:32
+     **/
+    List<GovMonitorPoint> selectGovMonitorPointsByOrgid(Map map);
+
 }
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/GovMonitorPointServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/GovMonitorPointServiceImpl.java
index add7e7a..632382e 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/GovMonitorPointServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/GovMonitorPointServiceImpl.java
@@ -5,12 +5,17 @@
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
 import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.moral.api.entity.Device;
 import com.moral.api.entity.GovMonitorPoint;
+import com.moral.api.entity.Organization;
 import com.moral.api.entity.SysArea;
+import com.moral.api.mapper.DeviceMapper;
 import com.moral.api.mapper.GovMonitorPointMapper;
 import com.moral.api.mapper.SysAreaMapper;
+import com.moral.api.service.DeviceService;
 import com.moral.api.service.GovMonitorPointService;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.moral.api.service.OrganizationService;
 import com.moral.api.util.LogUtils;
 import com.moral.constant.Constants;
 import com.moral.constant.RedisConstants;
@@ -24,10 +29,12 @@
 import org.springframework.web.context.request.RequestContextHolder;
 import org.springframework.web.context.request.ServletRequestAttributes;
 
+import javax.annotation.Resource;
 import javax.servlet.http.HttpServletRequest;
 
 import java.text.SimpleDateFormat;
 import java.util.*;
+import java.util.stream.Collectors;
 
 /**
  * <p>
@@ -51,6 +58,12 @@
 
     @Autowired
     private LogUtils logUtils;
+
+    @Resource
+    private OrganizationService organizationService;
+
+    @Autowired(required = false)
+    private DeviceMapper deviceMapper;
 
     /*
      * ���redis������������������
@@ -232,4 +245,22 @@
         }
         return govMonitorPointMapper.selectMaps(queryWrapper);
     }
+
+    @Override
+    public List<GovMonitorPoint> selectGovMonitorPointsByOrgid(Map map) {
+        //������������id���������������
+        List<Organization> organizations = organizationService.getAllChildrenOrganization(Integer.parseInt(map.get("organization_id").toString()));
+        Set<Integer> organization_ids = organizations.stream().map(organization -> organization.getId()).collect(Collectors.toSet());
+        //������������������������������
+        QueryWrapper<Device> wrapper_device = new QueryWrapper<>();
+        wrapper_device.in("organization_id",organization_ids).eq("is_delete",Constants.NOT_DELETE);
+        List<Device> devices = deviceMapper.selectList(wrapper_device);
+        //������������������������������id
+        Set<String> guids = devices.stream().map(device -> device.getGuid()).collect(Collectors.toSet());
+        //������������������������������
+        QueryWrapper<GovMonitorPoint> wrapper_govMonitorPoint = new QueryWrapper<>();
+        wrapper_govMonitorPoint.eq("is_delete",Constants.NOT_DELETE).in("guid",guids);
+        List<GovMonitorPoint> govMonitorPointList = govMonitorPointMapper.selectList(wrapper_govMonitorPoint);
+        return govMonitorPointList;
+    }
 }

--
Gitblit v1.8.0