From d6428820434c9a54eb4063b74ece253924708ede Mon Sep 17 00:00:00 2001
From: kaiyu <404897439@qq.com>
Date: Sun, 26 Sep 2021 09:29:30 +0800
Subject: [PATCH] screen-api 增加查询组织下所有站点id以及name接口
---
screen-api/src/main/java/com/moral/api/service/impl/GovMonitorPointServiceImpl.java | 31 +++++++++++++++++++++++++++++++
1 files changed, 31 insertions(+), 0 deletions(-)
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..273408b 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,20 @@
package com.moral.api.service.impl;
+import com.alibaba.fastjson.JSON;
+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;
+import java.util.Map;
/**
* <p>
@@ -17,4 +27,25 @@
@Service
public class GovMonitorPointServiceImpl extends ServiceImpl<GovMonitorPointMapper, GovMonitorPoint> implements GovMonitorPointService {
+ @Autowired
+ GovMonitorPointMapper govMonitorPointMapper;
+ @Autowired
+ RedisTemplate redisTemplate;
+
+ @Override
+ public List<GovMonitorPoint> queryGovMonitorPointAndDataByRegionCode(Integer regionCode,String sensorCode) {
+ 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());
+ Map<String,Object> dataMap = (Map<String, Object>) data;
+ if(data!=null&&dataMap.get(sensorCode)!=null)
+ govMonitorPoint.setData(String.valueOf(dataMap.get(sensorCode)));
+ }
+ return govMonitorPoints;
+ }
}
--
Gitblit v1.8.0