From 5bc3dba7aab3b5646cf158c343e5d48e8b90105a Mon Sep 17 00:00:00 2001
From: lizijie <lzjiiie@163.com>
Date: Fri, 18 Jun 2021 14:53:17 +0800
Subject: [PATCH] device_adjust_value新增、更新、删除接口刷新redis缓存
---
screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java | 88 ++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 85 insertions(+), 3 deletions(-)
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java
index cfb38aa..e22c1ea 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java
@@ -16,6 +16,7 @@
import com.moral.constant.Constants;
import com.moral.constant.ResponseCodeEnum;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.context.request.RequestContextHolder;
@@ -51,6 +52,9 @@
@Autowired
LogUtils logUtils;
+ @Autowired
+ RedisTemplate redisTemplate;
+
@Override
@Transactional
public Map<String, Object> insertOne(DeviceAdjustValue deviceAdjustValue) {
@@ -81,11 +85,13 @@
resultMap.put("msg",ResponseCodeEnum.SENSOR_IS_NOT_EXIST.getMsg());
return resultMap;
}
- deviceAdjustValueMapper.insert(deviceAdjustValue);
+ //deviceAdjustValueMapper.insert(deviceAdjustValue);
//������������������
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
- String content = "���������������:"+deviceAdjustValue+";";
- logUtils.saveOperationForManage(request,content,Constants.INSERT_OPERATE_TYPE);
+ String content = "���������"+deviceAdjustValue.getMac()+"������"+deviceAdjustValue.getSensorCode()+"���������"+deviceAdjustValue.getStartTime()+"���"+deviceAdjustValue.getEndTime()+"���������������:"+";";
+ //logUtils.saveOperationForManage(request,content,Constants.INSERT_OPERATE_TYPE);
+ //������������
+ refreshCache(deviceAdjustValue.getMac());
resultMap.put("code", ResponseCodeEnum.SUCCESS.getCode());
resultMap.put("msg", ResponseCodeEnum.SUCCESS.getMsg());
return resultMap;
@@ -162,6 +168,8 @@
}
}
logUtils.saveOperationForManage(request,content,Constants.UPDATE_OPERATE_TYPE);
+ //������������
+ refreshCache(deviceAdjustValueOld.getMac());
resultMap.put("code",ResponseCodeEnum.SUCCESS.getCode());
resultMap.put("msg",ResponseCodeEnum.SUCCESS.getMsg());
return resultMap;
@@ -192,9 +200,83 @@
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
String content = "���������"+deviceAdjustValue.getMac()+"������"+deviceAdjustValue.getSensorCode()+"���������"+deviceAdjustValue.getStartTime()+"���"+deviceAdjustValue.getEndTime()+"���������������:"+";";
logUtils.saveOperationForManage(request,content,Constants.DELETE_OPERATE_TYPE);
+ //������������
+ refreshCache(deviceAdjustValue.getMac());
resultMap.put("code",ResponseCodeEnum.SUCCESS.getCode());
resultMap.put("msg",ResponseCodeEnum.SUCCESS.getMsg());
return resultMap;
}
+ @Override
+ public Map<String, Object> getTimeSlot(Map map) {
+ Map<String,Object> resultMap = new HashMap<>();
+ if (ObjectUtils.isEmpty(map.get("sensor_code"))||map.get("sensor_code").equals("")){
+ resultMap.put("code",ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode());
+ resultMap.put("msg",ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
+ return resultMap;
+ }
+ if (ObjectUtils.isEmpty(map.get("mac"))||map.get("mac").equals("")){
+ resultMap.put("code",ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode());
+ resultMap.put("msg",ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
+ return resultMap;
+ }
+ QueryWrapper<DeviceAdjustValue> wrapper = new QueryWrapper<>();
+ wrapper.eq("is_delete",Constants.NOT_DELETE);
+ wrapper.eq("sensor_code",map.get("sensor_code"));
+ wrapper.eq("mac",map.get("mac"));
+ List<DeviceAdjustValue> deviceAdjustValues = deviceAdjustValueMapper.selectList(wrapper);
+ List<Map<String,Object>> timeSlotList = new ArrayList<>();
+ if (deviceAdjustValues.size()==0){
+ resultMap.put("timeSlotList",timeSlotList);
+ return resultMap;
+ }
+ for (DeviceAdjustValue deviceAdjustValue:deviceAdjustValues) {
+ Map timeSlotMap = new HashMap();
+ timeSlotMap.put("id",deviceAdjustValue.getId());
+ timeSlotMap.put("startTime",deviceAdjustValue.getStartTime());
+ timeSlotMap.put("endTime",deviceAdjustValue.getEndTime());
+ timeSlotList.add(timeSlotMap);
+ }
+ resultMap.put("timeSlotList",timeSlotList);
+ return resultMap;
+ }
+
+ private Map<String,Object> getDeviceAdjustValueFromDB(String mac){
+ QueryWrapper<DeviceAdjustValue> wapper_redis = new QueryWrapper<>();
+ wapper_redis.eq("mac",mac);
+ wapper_redis.eq("is_delete",Constants.NOT_DELETE);
+ List<DeviceAdjustValue> deviceAdjustValueList = deviceAdjustValueMapper.selectList(wapper_redis);
+ if (deviceAdjustValueList.size()==0){
+ return null;
+ }
+ Map<String, Object> deviceAdjustValueMap = new HashMap<>();
+ for (DeviceAdjustValue deviceAdjustValue:deviceAdjustValueList) {
+ String sensor_code = deviceAdjustValue.getSensorCode();
+ List<DeviceAdjustValue> timeSlotValueList = new ArrayList<>();
+ for (DeviceAdjustValue deviceAdjustValueIn:deviceAdjustValueList) {
+ if (deviceAdjustValueIn.getSensorCode().equals(sensor_code)){
+ Map<String, Object> timeSlot_value = new HashMap<>();
+ timeSlot_value.put("start_time",deviceAdjustValue.getStartTime());
+ timeSlot_value.put("end_time",deviceAdjustValue.getEndTime());
+ timeSlot_value.put("value",deviceAdjustValue.getValue());
+ timeSlotValueList.add(deviceAdjustValueIn);
+ }
+ }
+ deviceAdjustValueMap.put(sensor_code,timeSlotValueList);
+ }
+ return deviceAdjustValueMap;
+ }
+
+ private void refreshCache(String mac){
+ Map<String, Object> deviceAdjustValueMap = getDeviceAdjustValueFromDB(mac);
+ refreshCache(deviceAdjustValueMap,mac);
+ }
+
+ private void refreshCache(Map<String,Object> deviceAdjustValueMap,String mac){
+ //������������
+ redisTemplate.delete("adjust_"+mac);
+ //������������
+ redisTemplate.opsForHash().putAll("adjust_"+mac,deviceAdjustValueMap);
+ }
+
}
--
Gitblit v1.8.0