From 8e9a6b3013b877faa78bff87954dabe873e4eac7 Mon Sep 17 00:00:00 2001 From: kaiyu <404897439@qq.com> Date: Fri, 24 Sep 2021 10:44:33 +0800 Subject: [PATCH] screen-api 增加获取国控站接口 --- /dev/null | 36 ------------ screen-api/src/main/java/com/moral/api/entity/GovMonitorPoint.java | 9 +- screen-api/src/main/java/com/moral/api/service/MonitorPointService.java | 9 -- screen-api/src/main/java/com/moral/api/service/OrganizationService.java | 8 -- screen-api/src/main/java/com/moral/api/service/impl/OrganizationServiceImpl.java | 9 --- screen-api/src/main/java/com/moral/api/controller/GovMonitorPointController.java | 49 ++++++++++++++++ screen-api/src/main/java/com/moral/api/service/impl/GovMonitorPointServiceImpl.java | 28 +++++++++ screen-api/src/main/java/com/moral/api/service/GovMonitorPointService.java | 10 +++ screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java | 11 --- 9 files changed, 93 insertions(+), 76 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/controller/GovMonitorPointController.java b/screen-api/src/main/java/com/moral/api/controller/GovMonitorPointController.java new file mode 100644 index 0000000..565a897 --- /dev/null +++ b/screen-api/src/main/java/com/moral/api/controller/GovMonitorPointController.java @@ -0,0 +1,49 @@ +package com.moral.api.controller; + +import com.moral.api.entity.GovMonitorPoint; +import com.moral.api.service.GovMonitorPointService; +import com.moral.constant.ResponseCodeEnum; +import com.moral.constant.ResultMessage; +import io.swagger.annotations.Api; +import lombok.extern.slf4j.Slf4j; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.CrossOrigin; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; + +import java.util.List; + +/** + * @ClassName + * @Description TODO + * @Author ��������� + * @Date 2021/9/24 9:07 + * @Version TODO + **/ +@Slf4j +@Api(tags = {"���������"}) +@RestController +@CrossOrigin(origins = "*", maxAge = 3600) +@RequestMapping("/govMonitorPoint") +public class GovMonitorPointController { + + @Autowired + GovMonitorPointService govMonitorPointService; + + + /** + * @Description: ��������������������� + * @Param: [regionCode] + * @return: com.moral.constant.ResultMessage + * @Author: ��������� + * @Date: 2021/9/9 + */ + @GetMapping("queryStateControlStation") + public ResultMessage queryStateControlStation(Integer regionCode) { + + List<GovMonitorPoint> govMonitorPoints = govMonitorPointService.queryGovMonitorPointAndDataByRegionCode(regionCode); + + return new ResultMessage(ResponseCodeEnum.SUCCESS.getCode(), ResponseCodeEnum.SUCCESS.getMsg(), govMonitorPoints); + } +} diff --git a/screen-api/src/main/java/com/moral/api/entity/GovMonitorPoint.java b/screen-api/src/main/java/com/moral/api/entity/GovMonitorPoint.java index 62024c1..914fa40 100644 --- a/screen-api/src/main/java/com/moral/api/entity/GovMonitorPoint.java +++ b/screen-api/src/main/java/com/moral/api/entity/GovMonitorPoint.java @@ -1,10 +1,12 @@ package com.moral.api.entity; import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.extension.activerecord.Model; import com.baomidou.mybatisplus.annotation.TableId; import java.io.Serializable; import java.util.Date; +import java.util.Map; import lombok.Data; import lombok.EqualsAndHashCode; @@ -90,9 +92,8 @@ private String desc; - @Override - protected Serializable pkVal() { - return this.id; - } + @TableField(exist = false) + private String data; + } diff --git a/screen-api/src/main/java/com/moral/api/pojo/vo/monitorPoint/StateControllerStationVO.java b/screen-api/src/main/java/com/moral/api/pojo/vo/monitorPoint/StateControllerStationVO.java deleted file mode 100644 index ecb5dd5..0000000 --- a/screen-api/src/main/java/com/moral/api/pojo/vo/monitorPoint/StateControllerStationVO.java +++ /dev/null @@ -1,36 +0,0 @@ -package com.moral.api.pojo.vo.monitorPoint; - -import com.moral.api.entity.Device; -import com.moral.api.entity.MonitorPoint; -import com.moral.api.pojo.vo.device.DeviceVO; -import lombok.Data; - -import java.util.ArrayList; -import java.util.List; - -/** - * @ClassName StateControllerStationVO - * @Description TODO - * @Author ��������� - * @Date 2021/7/16 13:52 - * @Version TODO - **/ -@Data -public class StateControllerStationVO { - - private List<MonitorPointVO> stateControllerStations; - - public static StateControllerStationVO convert(List<MonitorPoint> monitorPoints){ - StateControllerStationVO stateControllerStationVO = new StateControllerStationVO(); - List<MonitorPointVO> stateControllerStations = new ArrayList<>(); - for (MonitorPoint monitorPoint : monitorPoints) { - MonitorPointVO monitorPointVO = new MonitorPointVO(); - monitorPointVO.setName(monitorPoint.getName()); - monitorPointVO.setLatitude(monitorPoint.getLatitude()); - monitorPointVO.setLongitude(monitorPoint.getLongitude()); - stateControllerStations.add(monitorPointVO); - } - stateControllerStationVO.setStateControllerStations(stateControllerStations); - return stateControllerStationVO; - } -} diff --git a/screen-api/src/main/java/com/moral/api/service/GovMonitorPointService.java b/screen-api/src/main/java/com/moral/api/service/GovMonitorPointService.java index 0231239..31add71 100644 --- a/screen-api/src/main/java/com/moral/api/service/GovMonitorPointService.java +++ b/screen-api/src/main/java/com/moral/api/service/GovMonitorPointService.java @@ -3,6 +3,8 @@ import com.moral.api.entity.GovMonitorPoint; import com.baomidou.mybatisplus.extension.service.IService; +import java.util.List; + /** * <p> * ��������� @@ -13,4 +15,12 @@ */ public interface GovMonitorPointService extends IService<GovMonitorPoint> { + /** + * @Description: ��������������������������������������������������� + * @Param: [regionCode] + * @return: java.util.List<com.moral.api.entity.GovMonitorPoint> + * @Author: ��������� + * @Date: 2021/9/24 + */ + List<GovMonitorPoint> queryGovMonitorPointAndDataByRegionCode(Integer regionCode); } diff --git a/screen-api/src/main/java/com/moral/api/service/MonitorPointService.java b/screen-api/src/main/java/com/moral/api/service/MonitorPointService.java index 9195454..7ffe237 100644 --- a/screen-api/src/main/java/com/moral/api/service/MonitorPointService.java +++ b/screen-api/src/main/java/com/moral/api/service/MonitorPointService.java @@ -25,13 +25,6 @@ */ List<MonitorPoint> queryByOrgIdAndRegionCode(MonitorPointQueryForm form); - /** - * @Description: ������������������������������������ - * @Param: [regionCode] - * @return: java.util.List<com.moral.api.entity.MonitorPoint> - * @Author: ��������� - * @Date: 2021/7/16 - */ - List<MonitorPoint> queryStateControlStationByRegionCode(Integer regionCode); + } diff --git a/screen-api/src/main/java/com/moral/api/service/OrganizationService.java b/screen-api/src/main/java/com/moral/api/service/OrganizationService.java index a200795..ddb13eb 100644 --- a/screen-api/src/main/java/com/moral/api/service/OrganizationService.java +++ b/screen-api/src/main/java/com/moral/api/service/OrganizationService.java @@ -24,12 +24,4 @@ */ List<Organization> getChildrenOrganizationsById(Integer id); - /** - * @Description: ��������������������� - * @Param: [] - * @return: com.moral.api.entity.Organization - * @Author: ��������� - * @Date: 2021/7/16 - */ - Organization getStateControlStation(); } diff --git a/screen-api/src/main/java/com/moral/api/service/impl/GovMonitorPointServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/GovMonitorPointServiceImpl.java index 7ad0cbe..e7d58e4 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/GovMonitorPointServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/GovMonitorPointServiceImpl.java @@ -1,10 +1,18 @@ package com.moral.api.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.moral.api.entity.GovMonitorPoint; import com.moral.api.mapper.GovMonitorPointMapper; import com.moral.api.service.GovMonitorPointService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.moral.constant.Constants; +import com.moral.constant.RedisConstants; +import com.moral.util.RegionCodeUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; + +import java.util.List; /** * <p> @@ -17,4 +25,24 @@ @Service public class GovMonitorPointServiceImpl extends ServiceImpl<GovMonitorPointMapper, GovMonitorPoint> implements GovMonitorPointService { + @Autowired + GovMonitorPointMapper govMonitorPointMapper; + @Autowired + RedisTemplate redisTemplate; + + @Override + public List<GovMonitorPoint> queryGovMonitorPointAndDataByRegionCode(Integer regionCode) { + String regionCodeStr = RegionCodeUtils.regionCodeConvertToName(regionCode); + QueryWrapper<GovMonitorPoint> wrapper = new QueryWrapper<>(); + wrapper.eq(regionCodeStr,regionCode); + wrapper.eq("is_delete", Constants.NOT_DELETE); + wrapper.select("guid","name","longitude","latitude","station_level"); + List<GovMonitorPoint> govMonitorPoints = govMonitorPointMapper.selectList(wrapper); + for (GovMonitorPoint govMonitorPoint : govMonitorPoints) { + Object data = redisTemplate.opsForHash().get(RedisConstants.AQI_DATA, govMonitorPoint.getGuid()); + if(data!=null) + govMonitorPoint.setData(String.valueOf(data)); + } + return govMonitorPoints; + } } diff --git a/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java index 8de6dc0..2222d8a 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java @@ -77,17 +77,6 @@ return monitorPoints; } - @Override - public List<MonitorPoint> queryStateControlStationByRegionCode(Integer regionCode) { - //��������������������� - Organization stateControlStationOrganization = organizationService.getStateControlStation(); - //��������������������������������������� - QueryWrapper<MonitorPoint> queryWrapper = new QueryWrapper<>(); - queryWrapper.eq("is_delete", Constants.NOT_DELETE); - queryWrapper.eq("organization_id", stateControlStationOrganization.getId()); - queryWrapper.eq(RegionCodeUtils.regionCodeConvertToName(regionCode), regionCode); - return monitorPointMapper.selectList(queryWrapper); - } } diff --git a/screen-api/src/main/java/com/moral/api/service/impl/OrganizationServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/OrganizationServiceImpl.java index 0d730ba..ca4669a 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/OrganizationServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/OrganizationServiceImpl.java @@ -35,15 +35,6 @@ return childrenOrganization; } - @Override - public Organization getStateControlStation() { - QueryWrapper<Organization> wrapper = new QueryWrapper<>(); - wrapper.select("id"); - wrapper.eq("name","���������"); - wrapper.eq("is_delete",Constants.NOT_DELETE); - Organization organization = organizationMapper.selectOne(wrapper); - return organization; - } /** * @Description: ���������������������������������������������������children��� -- Gitblit v1.8.0