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); } } 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); } 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; } }