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