From 6f4e852b84c577454a4876f83c7085bd360fe4fb Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Tue, 17 Aug 2021 17:07:02 +0800
Subject: [PATCH] 特殊设备数据insert
---
screen-manage/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java | 312 +++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 307 insertions(+), 5 deletions(-)
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java
index d08d880..bfca277 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java
@@ -2,26 +2,34 @@
import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+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.*;
import com.moral.api.mapper.*;
+import com.moral.api.pojo.vo.device.DeviceVO;
import com.moral.api.service.SpecialDeviceService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.moral.api.util.CacheUtils;
+import com.moral.api.util.LogUtils;
import com.moral.constant.Constants;
import com.moral.constant.RedisConstants;
import com.moral.constant.ResponseCodeEnum;
+import com.moral.util.DateUtils;
import org.springframework.beans.BeanUtils;
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;
+import org.springframework.web.context.request.ServletRequestAttributes;
+import javax.servlet.http.HttpServletRequest;
+import java.beans.PropertyDescriptor;
+import java.lang.reflect.Field;
+import java.lang.reflect.Method;
import java.text.SimpleDateFormat;
-import java.util.ArrayList;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
/**
* <p>
@@ -54,6 +62,15 @@
@Autowired(required = false)
private RedisTemplate redisTemplate;
+
+ @Autowired(required = false)
+ private OrganizationUnitAlarmMapper organizationUnitAlarmMapper;
+
+ @Autowired(required = false)
+ private VersionSensorUnitMapper versionSensorUnitMapper;
+
+ @Autowired
+ private LogUtils logUtils;
/*
* ���redis������������������
@@ -245,13 +262,298 @@
BeanUtils.copyProperties(specialDevice,insertSpecialDeviceHistory);
if (ObjectUtils.isEmpty(specialDeviceHistory)){
specialDeviceHistoryMapper.insert(insertSpecialDeviceHistory);
+ //������������������
+ HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
+ StringBuilder content = new StringBuilder();
+ content.append("������������������������������������").append(insertSpecialDeviceHistory.getName()).append(":").append("mac���").append(insertSpecialDeviceHistory.getMac());
+ logUtils.saveOperationForManage(request, content.toString(), Constants.INSERT_OPERATE_TYPE);
}else {
/*UpdateWrapper<SpecialDeviceHistory> wrapper_insertSpecialDeviceHistory = new UpdateWrapper<>();
wrapper_specialDeviceHistory.eq("is_delete",Constants.NOT_DELETE);
wrapper_specialDeviceHistory.eq("mac",mac);
wrapper_specialDeviceHistory.eq("organization_id",organizationId);*/
specialDeviceHistoryMapper.update(insertSpecialDeviceHistory,wrapper_specialDeviceHistory);
+ //������������������
+ HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
+ StringBuilder content = new StringBuilder();
+ content.append("������������������������").append(specialDeviceHistory.getId()).append("���");
+ Field[] fields = SpecialDevice.class.getDeclaredFields();
+ for (Field field : fields) {
+ if (field.getName().equals("id")) {
+ continue;
+ }
+ if ("serialVersionUID".equals(field.getName())) {
+ continue;
+ }
+ String fieldName = field.getName();
+ PropertyDescriptor pd = null;
+ try {
+ pd = new PropertyDescriptor(fieldName, SpecialDeviceHistory.class);
+ Method method = pd.getReadMethod();
+ Object o1 = method.invoke(specialDeviceHistory);
+ Object o2 = method.invoke(insertSpecialDeviceHistory);
+ if (o2 != null) {
+ content.append(fieldName).append("���").append(o1).append("-->").append(o2).append(":");
+ }
+
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ }
+ logUtils.saveOperationForManage(request, content.toString(), Constants.UPDATE_OPERATE_TYPE);
}
- return null;
+ Map<String, Object> deviceInfo = selectDeviceInfoById(specialDevice.getId());
+ //���������������������������
+ insertOrganizationUnitAlarm(specialDevice.getOrganizationId(), specialDevice.getDeviceVersionId());
+ //������������������������redis
+ String mac1 = specialDevice.getMac();
+ //���redis���������������������
+ delDeviceInfoFromRedis(mac1);
+ //������������������redis
+ setDeviceInfoToRedis(mac1, deviceInfo);
+ //������deviceInfo������
+ CacheUtils.refreshSpecialDeviceAlarmInfo();
+ //������������������
+ HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
+ StringBuilder content = new StringBuilder();
+ content.append("������������������������").append(specialDevice.getName()).append(":").append("mac���").append(mac);
+ logUtils.saveOperationForManage(request, content.toString(), Constants.INSERT_OPERATE_TYPE);
+ resultMap.put("code", ResponseCodeEnum.SUCCESS.getCode());
+ resultMap.put("msg", ResponseCodeEnum.SUCCESS.getMsg());
+ return resultMap;
+ }
+
+ @Transactional
+ @Override
+ public void update(SpecialDevice specialDevice) {
+ Integer specialDeviceId = specialDevice.getId();
+ SpecialDevice oldSpecialDevice = specialDeviceMapper.selectById(specialDeviceId);
+ specialDeviceMapper.updateById(specialDevice);
+ SpecialDevice updateSpecialDevice = specialDeviceMapper.selectById(specialDeviceId);
+ String oleMac = oldSpecialDevice.getMac();
+ //���������������������������
+ Integer oldOrgId = oldSpecialDevice.getOrganizationId();
+ Integer newOrgId = updateSpecialDevice.getOrganizationId();
+ Integer oldVersionId = oldSpecialDevice.getDeviceVersionId();
+ Integer newVersionId = updateSpecialDevice.getDeviceVersionId();
+ if (!oldOrgId.equals(newOrgId) || !oldVersionId.equals(newVersionId)) {
+ deleteOrganizationUnitAlarm(oldOrgId, oldVersionId);
+ insertOrganizationUnitAlarm(newOrgId, newVersionId);
+ }
+ //���redis���������������������
+ delDeviceInfoFromRedis(oleMac);
+ Map<String, Object> deviceInfo = selectDeviceInfoById(specialDeviceId);
+ //������������������redis
+ setDeviceInfoToRedis(updateSpecialDevice.getMac(), deviceInfo);
+ //������deviceInfo������
+ CacheUtils.refreshSpecialDeviceAlarmInfo();
+ QueryWrapper<SpecialDeviceHistory> wrapper_specialDeviceHistory = new QueryWrapper<>();
+ wrapper_specialDeviceHistory.eq("is_delete",Constants.NOT_DELETE);
+ wrapper_specialDeviceHistory.eq("mac",updateSpecialDevice.getMac());
+ wrapper_specialDeviceHistory.eq("organization_id",updateSpecialDevice.getOrganizationId());
+ SpecialDeviceHistory specialDeviceHistory = specialDeviceHistoryMapper.selectOne(wrapper_specialDeviceHistory);
+ SpecialDeviceHistory updateSpecialDeviceHistory = new SpecialDeviceHistory();
+ BeanUtils.copyProperties(updateSpecialDevice,updateSpecialDeviceHistory);
+ updateSpecialDeviceHistory.setCreateTime(null);
+ updateSpecialDeviceHistory.setUpdateTime(null);
+ updateSpecialDeviceHistory.setIsDelete(null);
+ if (ObjectUtils.isEmpty(specialDeviceHistory)){
+ specialDeviceHistoryMapper.insert(updateSpecialDeviceHistory);
+ //������������������
+ HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
+ StringBuilder content = new StringBuilder();
+ content.append("������������������������������������").append(updateSpecialDeviceHistory.getName()).append(":").append("mac���").append(updateSpecialDeviceHistory.getMac());
+ logUtils.saveOperationForManage(request, content.toString(), Constants.INSERT_OPERATE_TYPE);
+ }else {
+ /*UpdateWrapper<SpecialDeviceHistory> wrapper_insertSpecialDeviceHistory = new UpdateWrapper<>();
+ wrapper_specialDeviceHistory.eq("is_delete",Constants.NOT_DELETE);
+ wrapper_specialDeviceHistory.eq("mac",mac);
+ wrapper_specialDeviceHistory.eq("organization_id",organizationId);*/
+ specialDeviceHistoryMapper.update(updateSpecialDeviceHistory,wrapper_specialDeviceHistory);
+ //������������������
+ HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
+ StringBuilder content = new StringBuilder();
+ content.append("������������������������").append(specialDeviceHistory.getId()).append("���");
+ Field[] fields = SpecialDevice.class.getDeclaredFields();
+ for (Field field : fields) {
+ if (field.getName().equals("id")) {
+ continue;
+ }
+ if ("serialVersionUID".equals(field.getName())) {
+ continue;
+ }
+ String fieldName = field.getName();
+ PropertyDescriptor pd = null;
+ try {
+ pd = new PropertyDescriptor(fieldName, SpecialDeviceHistory.class);
+ Method method = pd.getReadMethod();
+ Object o1 = method.invoke(specialDeviceHistory);
+ Object o2 = method.invoke(updateSpecialDeviceHistory);
+ if (o2 != null) {
+ content.append(fieldName).append("���").append(o1).append("-->").append(o2).append(":");
+ }
+
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ }
+ logUtils.saveOperationForManage(request, content.toString(), Constants.UPDATE_OPERATE_TYPE);
+ }
+ //������������������
+ HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
+ StringBuilder content = new StringBuilder();
+ content.append("������������������������").append(specialDeviceId).append("���");
+ Field[] fields = SpecialDevice.class.getDeclaredFields();
+ for (Field field : fields) {
+ if (field.getName().equals("id")) {
+ continue;
+ }
+ if ("serialVersionUID".equals(field.getName())) {
+ continue;
+ }
+ String fieldName = field.getName();
+ PropertyDescriptor pd = null;
+ try {
+ pd = new PropertyDescriptor(fieldName, SpecialDevice.class);
+ Method method = pd.getReadMethod();
+ Object o1 = method.invoke(oldSpecialDevice);
+ Object o2 = method.invoke(specialDevice);
+ if (o2 != null) {
+ content.append(fieldName).append("���").append(o1).append("-->").append(o2).append(":");
+ }
+
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ }
+ logUtils.saveOperationForManage(request, content.toString(), Constants.UPDATE_OPERATE_TYPE);
+ }
+
+ @Override
+ public void delete(Integer specialDeviceId) {
+ SpecialDevice specialDevice = specialDeviceMapper.selectById(specialDeviceId);
+ UpdateWrapper<SpecialDevice> updateWrapper = new UpdateWrapper<>();
+ updateWrapper.eq("id",specialDeviceId).set("is_delete",Constants.DELETE);
+ specialDeviceMapper.update(null,updateWrapper);
+ String mac = specialDevice.getMac();
+ //���redis���������������������
+ delDeviceInfoFromRedis(mac);
+ //���������������������������
+ Integer versionId = specialDevice.getDeviceVersionId();
+ Integer orgId = specialDevice.getOrganizationId();
+ deleteOrganizationUnitAlarm(orgId, versionId);
+ //������deviceInfo������
+ CacheUtils.refreshDeviceAlarmInfo();
+ //������������������
+ HttpServletRequest request = ((ServletRequestAttributes) Objects.requireNonNull(RequestContextHolder.getRequestAttributes())).getRequest();
+ StringBuilder content = new StringBuilder();
+ content.append("������������������").append(specialDevice.getName()).append(";").append("mac���").append(mac);
+ logUtils.saveOperationForManage(request, content.toString(), Constants.DELETE_OPERATE_TYPE);
+ }
+
+ @Override
+ public Map<String, Object> selectDeviceInfoById(Integer deviceId) {
+ String mac = specialDeviceMapper.selectById(deviceId).getMac();
+ Map<String, Object> specialDeviceInfo = getDeviceInfoFromRedis(mac);
+ //������redis������
+ if (specialDeviceInfo != null) {
+ return specialDeviceInfo;
+ }
+ specialDeviceInfo = new LinkedHashMap<>();
+ //DeviceVO device = deviceMapper.selectDeviceInfoById(deviceId);
+ SpecialDevice specialDevice = specialDeviceMapper.selectById(deviceId);
+ //������
+ specialDeviceInfo.put("id", specialDevice.getId());
+ specialDeviceInfo.put("name", specialDevice.getName());
+ specialDeviceInfo.put("mac", specialDevice.getMac());
+ specialDeviceInfo.put("createTime", DateUtils.dateToDateString(specialDevice.getCreateTime()));
+
+ //������������
+ //specialDeviceInfo.put("extend", device.getExtend());
+
+ //������
+ Map<String, Object> versionInfo = new LinkedHashMap<>();
+ Version version = versionMapper.selectById(specialDevice.getDeviceVersionId());
+ versionInfo.put("id", version.getId());
+ versionInfo.put("name", version.getName());
+ specialDeviceInfo.put("version", versionInfo);
+
+ //���������
+ List<Map<String, Object>> operatorsInfo = new ArrayList<>();
+ String operateIds = specialDevice.getOperateIds();
+ if (!ObjectUtils.isEmpty(operateIds)){
+ String[] operateIdArr = operateIds.split(",");
+ if (operateIdArr.length>0){
+ List<Integer> operateIdList = new ArrayList<>();
+ for (int i = 0; i < operateIdArr.length; i++){
+ operateIdList.add(Integer.parseInt(operateIdArr[i]));
+ }
+ QueryWrapper<ManageAccount> wapper_manageAccount = new QueryWrapper<>();
+ wapper_manageAccount.eq("is_delete",Constants.NOT_DELETE);
+ wapper_manageAccount.in("id",operateIdList);
+ List<ManageAccount> manageAccounts = manageAccountMapper.selectList(wapper_manageAccount);
+ for (ManageAccount manageAccount:manageAccounts) {
+ Map<String,Object> operateMap = new HashMap<>();
+ operateMap.put("id",manageAccount.getId());
+ operateMap.put("name",manageAccount.getUserName());
+ operatorsInfo.add(operateMap);
+ }
+ }
+ }
+ specialDeviceInfo.put("operators", operatorsInfo);
+
+ //������
+ Map<String, Object> orgInfo = new LinkedHashMap<>();
+ Organization organization = organizationMapper.selectById(specialDevice.getOrganizationId());
+ orgInfo.put("id", organization.getId());
+ orgInfo.put("name", organization.getName());
+ specialDeviceInfo.put("organization", orgInfo);
+
+ setDeviceInfoToRedis(mac, specialDeviceInfo);
+ return specialDeviceInfo;
+ }
+
+ private void insertOrganizationUnitAlarm(Integer orgId, Integer versionId) {
+ QueryWrapper<OrganizationUnitAlarm> queryOrganizationVersionWrapper = new QueryWrapper<>();
+ queryOrganizationVersionWrapper.eq("organization_id", orgId);
+ queryOrganizationVersionWrapper.eq("version_id", versionId);
+ queryOrganizationVersionWrapper.eq("is_delete", Constants.NOT_DELETE);
+ List<OrganizationUnitAlarm> organizationUnitAlarms = organizationUnitAlarmMapper.selectList(queryOrganizationVersionWrapper);
+ if (org.springframework.util.ObjectUtils.isEmpty(organizationUnitAlarms)) {
+ QueryWrapper<VersionSensorUnit> queryVersionSensorUnitWrapper = new QueryWrapper<>();
+ queryVersionSensorUnitWrapper.eq("version_id", versionId);
+ queryVersionSensorUnitWrapper.eq("is_delete", Constants.NOT_DELETE);
+ List<VersionSensorUnit> versionSensorUnits = versionSensorUnitMapper.selectList(queryVersionSensorUnitWrapper);
+ if (!org.springframework.util.ObjectUtils.isEmpty(versionSensorUnits)) {
+ for (VersionSensorUnit versionSensorUnit : versionSensorUnits) {
+ OrganizationUnitAlarm organizationUnitAlarm = new OrganizationUnitAlarm();
+ organizationUnitAlarm.setOrganizationId(orgId);
+ organizationUnitAlarm.setVersionId(versionId);
+ organizationUnitAlarm.setSensorCode(versionSensorUnit.getSensorCode());
+ organizationUnitAlarm.setUnitKey(versionSensorUnit.getUnitKey());
+ organizationUnitAlarm.setShowUnitKey(versionSensorUnit.getUnitKey());
+ organizationUnitAlarmMapper.insert(organizationUnitAlarm);
+ }
+ }
+ }
+ }
+
+ private void deleteOrganizationUnitAlarm(Integer orgId, Integer versionId) {
+ QueryWrapper<SpecialDevice> queryOrganizationVersionWrapper = new QueryWrapper<>();
+ queryOrganizationVersionWrapper.eq("organization_id", orgId);
+ queryOrganizationVersionWrapper.eq("device_version_id", versionId);
+ queryOrganizationVersionWrapper.eq("is_delete", Constants.NOT_DELETE);
+ List<SpecialDevice> specialDevices = specialDeviceMapper.selectList(queryOrganizationVersionWrapper);
+ if (org.springframework.util.ObjectUtils.isEmpty(specialDevices)) {//������������������������������������������������������
+ UpdateWrapper deleteWrapper = new UpdateWrapper();
+ deleteWrapper.eq("organization_id", orgId);
+ deleteWrapper.eq("version_id", versionId);
+ deleteWrapper.eq("is_delete", Constants.NOT_DELETE);
+ deleteWrapper.set("is_delete", Constants.DELETE);
+ organizationUnitAlarmMapper.update(null, deleteWrapper);
+ }
}
}
--
Gitblit v1.8.0