package com.moral.api.service.impl;
|
|
import com.alibaba.fastjson.JSON;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.moral.api.entity.*;
|
import com.moral.api.mapper.OrganizationUnitAlarmMapper;
|
import com.moral.api.mapper.SensorMapper;
|
import com.moral.api.mapper.SysDictDataMapper;
|
import com.moral.api.mapper.VersionSensorUnitMapper;
|
import com.moral.api.service.SensorService;
|
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.TokenUtils;
|
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.util.ObjectUtils;
|
import org.springframework.web.context.request.RequestContextHolder;
|
import org.springframework.web.context.request.ServletRequestAttributes;
|
|
import javax.servlet.http.HttpServletRequest;
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author moral
|
* @since 2021-05-08
|
*/
|
@Service
|
@Transactional
|
public class SensorServiceImpl extends ServiceImpl<SensorMapper, Sensor> implements SensorService {
|
|
@Autowired(required = false)
|
private SensorMapper sensorMapper;
|
|
@Autowired(required = false)
|
private VersionSensorUnitMapper versionSensorUnitMapper;
|
|
@Autowired(required = false)
|
private SysDictDataMapper sysDictDataMapper;
|
|
@Autowired(required = false)
|
private OrganizationUnitAlarmMapper organizationUnitAlarmMapper;
|
|
|
@Autowired
|
RedisTemplate redisTemplate;
|
|
@Override
|
@Transactional
|
public Map<String, Object> insertOne(Sensor sensor) {
|
Map<String, Object> resultMap = new HashMap<>();
|
if (sensor.getName() == null || sensor.getCode() == null) {
|
resultMap.put("code", ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode());
|
resultMap.put("msg", ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
|
return resultMap;
|
}
|
QueryWrapper<Sensor> wrapper_name = new QueryWrapper<>();
|
wrapper_name.eq("name", sensor.getName());
|
wrapper_name.eq("is_delete", "0");
|
if (sensorMapper.selectCount(wrapper_name) != 0) {
|
resultMap.put("code", ResponseCodeEnum.SENSOR_IS_EXIST.getCode());
|
resultMap.put("msg", ResponseCodeEnum.SENSOR_IS_EXIST.getMsg());
|
return resultMap;
|
}
|
QueryWrapper<Sensor> wrapper_code = new QueryWrapper<>();
|
wrapper_code.eq("code", sensor.getCode());
|
wrapper_code.eq("is_delete", "0");
|
if (sensorMapper.selectCount(wrapper_code) != 0) {
|
resultMap.put("code", ResponseCodeEnum.SENSOR_KEY_IS_USED.getCode());
|
resultMap.put("msg", ResponseCodeEnum.SENSOR_KEY_IS_USED.getMsg());
|
return resultMap;
|
}
|
sensorMapper.insertOne(sensor);
|
//操作插入日志
|
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
|
String content = "添加因子:" + sensor.getName() + ";";
|
LogUtils.saveOperationForManage(request, content, Constants.INSERT_OPERATE_TYPE);
|
resultMap.put("code", ResponseCodeEnum.SUCCESS.getCode());
|
resultMap.put("msg", ResponseCodeEnum.SUCCESS.getMsg());
|
//刷新缓存
|
refreshCache();
|
return resultMap;
|
}
|
|
@Override
|
@Transactional
|
public Map<String, Object> updateSensor(Map<String, Object> updateSensorMap) {
|
Map<String, Object> resultMap = new HashMap<>();
|
if (ObjectUtils.isEmpty(updateSensorMap.get("id"))) {
|
resultMap.put("code", ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode());
|
resultMap.put("msg", ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
|
return resultMap;
|
}
|
if (updateSensorMap.get("name") == "") {
|
resultMap.put("code", ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode());
|
resultMap.put("msg", ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
|
return resultMap;
|
}
|
if (updateSensorMap.get("code") == "") {
|
resultMap.put("code", ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode());
|
resultMap.put("msg", ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
|
return resultMap;
|
}
|
Sensor oldSensor = sensorMapper.getSensorById(Integer.parseInt(updateSensorMap.get("id").toString()));
|
if (ObjectUtils.isEmpty(oldSensor)) {
|
resultMap.put("code", ResponseCodeEnum.SENSOR_IS_NOT_EXIST.getCode());
|
resultMap.put("msg", ResponseCodeEnum.SENSOR_IS_NOT_EXIST.getMsg());
|
return resultMap;
|
}
|
QueryWrapper<Sensor> wrapper_code = new QueryWrapper<>();
|
wrapper_code.eq("code", updateSensorMap.get("code"));
|
wrapper_code.eq("is_delete", "0");
|
List<Sensor> sensorList = sensorMapper.selectList(wrapper_code);
|
if (sensorList.size() != 0 && !sensorList.get(0).getId().toString().equals(updateSensorMap.get("id").toString())) {
|
resultMap.put("code", ResponseCodeEnum.SENSOR_KEY_IS_USED.getCode());
|
resultMap.put("msg", ResponseCodeEnum.SENSOR_KEY_IS_USED.getMsg());
|
return resultMap;
|
}
|
sensorMapper.updateSensor(updateSensorMap);
|
if (!ObjectUtils.isEmpty(updateSensorMap.get("code")) && !oldSensor.getCode().equals(updateSensorMap.get("code"))) {
|
QueryWrapper<OrganizationUnitAlarm> wrapper_OUA = new QueryWrapper<>();
|
wrapper_OUA.eq("is_delete", Constants.NOT_DELETE);
|
wrapper_OUA.eq("sensor_code", oldSensor.getCode());
|
OrganizationUnitAlarm organizationUnitAlarm = new OrganizationUnitAlarm();
|
organizationUnitAlarm.setSensorCode(updateSensorMap.get("code").toString());
|
organizationUnitAlarmMapper.update(organizationUnitAlarm, wrapper_OUA);
|
}
|
//刷新deviceInfo缓存
|
CacheUtils.refreshDeviceAlarmInfo();
|
CacheUtils.refreshSpecialDeviceAlarmInfo();
|
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
|
String content = "修改因子:" + oldSensor.getName() + ";";
|
for (Object key : updateSensorMap.keySet()) {
|
if (key.toString().equals("name") && updateSensorMap.get(key) != null) {
|
content = content + "因子名:" + oldSensor.getName() + "->" + updateSensorMap.get(key) + ";";
|
}
|
if (key.toString().equals("code") && updateSensorMap.get(key) != null) {
|
/*QueryWrapper<VersionSensorUnit> wrapper_Version = new QueryWrapper<>();
|
wrapper_Version.eq("sensor_code",oldSensor.getCode());
|
wrapper_Version.eq("is_delete","0");
|
VersionSensorUnit versionSensorUnit = new VersionSensorUnit();
|
versionSensorUnit.setSensorCode(updateSensorMap.get(key).toString());
|
versionSensorUnitMapper.update(versionSensorUnit,wrapper_Version);*/
|
content = content + "编号:" + oldSensor.getCode() + "->" + updateSensorMap.get(key) + ";";
|
}
|
if (key.toString().equals("desc") && updateSensorMap.get(key) != null) {
|
content = content + "备注:" + oldSensor.getDesc() + "->" + updateSensorMap.get(key) + ";";
|
}
|
if (key.toString().equals("upper") && updateSensorMap.get(key) != null) {
|
content = content + "上限:" + oldSensor.getDesc() + "->" + updateSensorMap.get(key) + ";";
|
}
|
if (key.toString().equals("lower") && updateSensorMap.get(key) != null) {
|
content = content + "下限:" + oldSensor.getDesc() + "->" + updateSensorMap.get(key) + ";";
|
}
|
if (key.toString().equals("default_unit_key") && updateSensorMap.get(key) != null) {
|
content = content + "默认单位:" + oldSensor.getDesc() + "->" + updateSensorMap.get(key) + ";";
|
}
|
}
|
LogUtils.saveOperationForManage(request, content, Constants.UPDATE_OPERATE_TYPE);
|
resultMap.put("code", ResponseCodeEnum.SUCCESS.getCode());
|
resultMap.put("msg", ResponseCodeEnum.SUCCESS.getMsg());
|
//刷新缓存
|
refreshCache();
|
return resultMap;
|
}
|
|
@Override
|
public Map<String, Object> getAllSensor(Map map) {
|
Map<String, Object> resultMap = new HashMap<>();
|
int current = Integer.parseInt(map.get("current").toString());
|
int size = Integer.parseInt(map.get("size").toString());
|
Page<Sensor> page = new Page(current, size);
|
QueryWrapper<Sensor> wrapper = new QueryWrapper();
|
wrapper.eq("is_delete", 0);
|
int totleNum = sensorMapper.selectCount(wrapper);
|
if (!ObjectUtils.isEmpty(map.get("orderType"))) {
|
String orderType = map.get("orderType").toString();
|
if (orderType.equals(Constants.ORDER_DESC)) {
|
wrapper.orderByDesc("update_time");
|
} else {
|
wrapper.orderByAsc("update_time");
|
}
|
}
|
Page resultPage = sensorMapper.selectPage(page, wrapper);
|
List<Sensor> sensors = resultPage.getRecords();
|
SimpleDateFormat SDF = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
List<Map<String, Object>> sensorList = new ArrayList<>();
|
for (Sensor sensor : sensors) {
|
Map sensorMap = JSON.parseObject(JSON.toJSONString(sensor), Map.class);
|
String createTime = SDF.format(sensor.getCreateTime());
|
String updateTime = SDF.format(sensor.getUpdateTime());
|
sensorMap.put("createTime", createTime);
|
sensorMap.put("updateTime", updateTime);
|
sensorMap.put("key", sensor.getId());
|
if (sensor.getDefaultUnitKey() != null && sensor.getDefaultUnitKey() != "") {
|
QueryWrapper<SysDictData> wrapper_VSU = new QueryWrapper();
|
wrapper_VSU.eq("is_delete", 0);
|
wrapper_VSU.eq("dataKey", sensor.getDefaultUnitKey());
|
wrapper_VSU.eq("dict_type_id", 14);
|
if (!ObjectUtils.isEmpty(sysDictDataMapper.selectOne(wrapper_VSU)) && !ObjectUtils.isEmpty(sysDictDataMapper.selectOne(wrapper_VSU).getDataValue())) {
|
sensorMap.put("default_unit_key", sysDictDataMapper.selectOne(wrapper_VSU).getDataValue());
|
}
|
}
|
sensorList.add(sensorMap);
|
}
|
resultMap.put("sensors", sensorList);
|
resultMap.put("totalNumber", totleNum);
|
resultMap.put("current", current);
|
int totalPageNumber = totleNum / size;
|
if (totleNum % size != 0) {
|
totalPageNumber += 1;
|
}
|
resultMap.put("totalPageNumber", totalPageNumber);
|
return resultMap;
|
}
|
|
@Override
|
public Map<String, Object> getAllSensorWithoutPage() {
|
Map<String, Object> resultMap = new HashMap<>();
|
QueryWrapper<Sensor> wrapper = new QueryWrapper();
|
wrapper.eq("is_delete", 0);
|
List<Sensor> sensors = sensorMapper.selectList(wrapper);
|
SimpleDateFormat SDF = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
List<Map<String, Object>> sensorList = new ArrayList<>();
|
for (Sensor sensor : sensors) {
|
Map sensorMap = JSON.parseObject(JSON.toJSONString(sensor), Map.class);
|
String createTime = SDF.format(sensor.getCreateTime());
|
String updateTime = SDF.format(sensor.getUpdateTime());
|
sensorMap.put("createTime", createTime);
|
sensorMap.put("updateTime", updateTime);
|
sensorMap.put("key", sensor.getId());
|
if (sensor.getDefaultUnitKey() != null && sensor.getDefaultUnitKey() != "") {
|
QueryWrapper<SysDictData> wrapper_VSU = new QueryWrapper();
|
wrapper_VSU.eq("is_delete", 0);
|
wrapper_VSU.eq("dataKey", sensor.getDefaultUnitKey());
|
wrapper_VSU.eq("dict_type_id", 14);
|
if (!ObjectUtils.isEmpty(sysDictDataMapper.selectOne(wrapper_VSU)) && !ObjectUtils.isEmpty(sysDictDataMapper.selectOne(wrapper_VSU).getDataValue())) {
|
sensorMap.put("default_unit_key", sysDictDataMapper.selectOne(wrapper_VSU).getDataValue());
|
}
|
}
|
sensorList.add(sensorMap);
|
}
|
resultMap.put("sensors", sensorList);
|
return resultMap;
|
}
|
|
@Override
|
@Transactional
|
public Map<String, Object> deleteSensor(Map map) {
|
Map<String, Object> resultMap = new HashMap<>();
|
QueryWrapper<Sensor> wrapper = new QueryWrapper<>();
|
wrapper.eq("id", map.get("id"));
|
wrapper.eq("is_delete", "0");
|
Sensor sensor = sensorMapper.selectOne(wrapper);
|
if (ObjectUtils.isEmpty(sensor)) {
|
resultMap.put("code", ResponseCodeEnum.SENSOR_IS_NOT_EXIST.getCode());
|
resultMap.put("msg", ResponseCodeEnum.SENSOR_IS_NOT_EXIST.getMsg());
|
return resultMap;
|
}
|
Sensor deleteSensor = new Sensor();
|
deleteSensor.setIsDelete(Constants.DELETE);
|
sensorMapper.update(deleteSensor, wrapper);
|
QueryWrapper<VersionSensorUnit> wrapper_Version = new QueryWrapper<>();
|
wrapper_Version.eq("sensor_code", sensor.getCode());
|
wrapper_Version.eq("is_delete", "0");
|
VersionSensorUnit versionSensorUnit = new VersionSensorUnit();
|
versionSensorUnit.setIsDelete(Constants.DELETE);
|
versionSensorUnitMapper.update(versionSensorUnit, wrapper_Version);
|
if (!ObjectUtils.isEmpty(sensor.getCode()) && !sensor.getCode().equals("")) {
|
QueryWrapper<OrganizationUnitAlarm> wrapper_OUA = new QueryWrapper<>();
|
wrapper_OUA.eq("is_delete", Constants.NOT_DELETE);
|
wrapper_OUA.eq("sensor_code", sensor.getCode());
|
OrganizationUnitAlarm organizationUnitAlarm = new OrganizationUnitAlarm();
|
organizationUnitAlarm.setIsDelete(Constants.DELETE);
|
organizationUnitAlarmMapper.update(organizationUnitAlarm, wrapper_OUA);
|
}
|
//操作插入日志
|
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
|
String content = "删除因子:" + sensor.getName() + ";";
|
LogUtils.saveOperationForManage(request, content, Constants.DELETE_OPERATE_TYPE);
|
resultMap.put("code", ResponseCodeEnum.SUCCESS.getCode());
|
resultMap.put("msg", ResponseCodeEnum.SUCCESS.getMsg());
|
//刷新缓存
|
refreshCache();
|
//注销token
|
TokenUtils.destoryToken(Integer.parseInt(map.get("id").toString()));
|
return resultMap;
|
}
|
|
@Override
|
public Map<String, Object> getSensorByFuzzy(Map map) {
|
Map<String, Object> resultMap = new HashMap<>();
|
int current = Integer.parseInt(map.get("current").toString());
|
int size = Integer.parseInt(map.get("size").toString());
|
Page<Sensor> page = new Page(current, size);
|
QueryWrapper<Sensor> wrapper = new QueryWrapper();
|
wrapper.eq("is_delete", Constants.NOT_DELETE);
|
wrapper.like("name", map.get("key")).or().like("code", map.get("key"));
|
int totleNum = sensorMapper.selectCount(wrapper);
|
String orderType = map.get("orderType").toString();
|
if (orderType.equals(Constants.ORDER_ASC)) {
|
wrapper.orderByAsc("update_time");
|
} else {
|
wrapper.orderByDesc("update_time");
|
}
|
Page resultPage = sensorMapper.selectPage(page, wrapper);
|
List<Sensor> sensors = resultPage.getRecords();
|
SimpleDateFormat SDF = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
List<Map<String, Object>> sensorList = new ArrayList<>();
|
for (Sensor sensor : sensors) {
|
Map sensorMap = JSON.parseObject(JSON.toJSONString(sensor), Map.class);
|
String createTime = SDF.format(sensor.getCreateTime());
|
String updateTime = SDF.format(sensor.getUpdateTime());
|
sensorMap.put("createTime", createTime);
|
sensorMap.put("updateTime", updateTime);
|
sensorMap.put("key", sensor.getId());
|
if (sensor.getDefaultUnitKey() != null && !sensor.getDefaultUnitKey().equals("")) {
|
QueryWrapper<SysDictData> wrapper_VSU = new QueryWrapper();
|
wrapper_VSU.eq("is_delete", 0);
|
wrapper_VSU.eq("dataKey", sensor.getDefaultUnitKey());
|
wrapper_VSU.eq("dict_type_id", 14);
|
sensorMap.put("default_unit_key", sysDictDataMapper.selectOne(wrapper_VSU).getDataValue());
|
}
|
sensorList.add(sensorMap);
|
}
|
resultMap.put("sensors", sensorList);
|
resultMap.put("totalNumber", totleNum);
|
resultMap.put("current", current);
|
int totalPageNumber = totleNum / size;
|
if (totleNum % size != 0) {
|
totalPageNumber += 1;
|
}
|
resultMap.put("totalPageNumber", totalPageNumber);
|
return resultMap;
|
}
|
|
@Override
|
public Map<String, Sensor> getAllSensorFromCache() {
|
Map<String, Sensor> sensors = redisTemplate.opsForHash().entries(RedisConstants.SENSOR_KEY);
|
if (ObjectUtils.isEmpty(sensors))
|
sensors = getAllSensorFromDB();
|
//刷新缓存
|
refreshCache(sensors);
|
return sensors;
|
}
|
|
@Override
|
public Sensor getSensorByCode(String code) {
|
if (code == null)
|
return null;
|
//从缓存中读取
|
Sensor sensor = (Sensor) redisTemplate.opsForHash().get(RedisConstants.SENSOR_KEY, code);
|
//如果缓存为空则从数据库读取
|
if (sensor == null) {
|
QueryWrapper<Sensor> wrapper = new QueryWrapper<>();
|
sensor = new Sensor();
|
sensor.setCode(code);
|
sensor.setIsDelete(Constants.NOT_DELETE);
|
wrapper.setEntity(sensor);
|
sensor = sensorMapper.selectOne(wrapper);
|
}
|
return sensor;
|
}
|
|
@Override
|
public void refreshCache() {
|
Map<String, Sensor> sensors = getAllSensorFromDB();
|
refreshCache(sensors);
|
}
|
|
private Map<String, Sensor> getAllSensorFromDB() {
|
QueryWrapper<Sensor> wrapper = new QueryWrapper<>();
|
wrapper.eq("is_delete", Constants.NOT_DELETE);
|
List<Sensor> sensors = sensorMapper.selectList(wrapper);
|
Map<String, Sensor> result = new HashMap<>();
|
for (Sensor sensor : sensors) {
|
result.put(sensor.getCode(), sensor);
|
}
|
return result;
|
}
|
|
private void refreshCache(Map<String, Sensor> sensors) {
|
//删除缓存
|
redisTemplate.delete(RedisConstants.SENSOR_KEY);
|
//添加缓存
|
redisTemplate.opsForHash().putAll(RedisConstants.SENSOR_KEY, sensors);
|
}
|
}
|
