package com.moral.api.service.impl;
|
|
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.extension.plugins.pagination.Page;
|
import com.moral.api.config.mybatis.wrapper.NullFilterWrapper;
|
import com.moral.api.entity.Sensor;
|
import com.moral.api.entity.SysDictData;
|
import com.moral.api.entity.UnitConversion;
|
import com.moral.api.mapper.UnitConversionMapper;
|
import com.moral.api.pojo.dto.unitConversion.UnitConversionDTO;
|
import com.moral.api.pojo.dto.unitConversion.UnitConversionQueryDTO;
|
import com.moral.api.pojo.form.unitConversion.UnitConversionDeleteForm;
|
import com.moral.api.pojo.form.unitConversion.UnitConversionInsertForm;
|
import com.moral.api.pojo.form.unitConversion.UnitConversionQueryForm;
|
import com.moral.api.pojo.form.unitConversion.UnitConversionUpdateForm;
|
import com.moral.api.service.SensorService;
|
import com.moral.api.service.SysDictDataService;
|
import com.moral.api.service.UnitConversionService;
|
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.ConvertUtils;
|
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 java.util.ArrayList;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* <p>
|
* 单位转换表 服务实现类
|
* </p>
|
*
|
* @author moral
|
* @since 2021-05-11
|
*/
|
@Service
|
public class UnitConversionServiceImpl extends ServiceImpl<UnitConversionMapper, UnitConversion> implements UnitConversionService {
|
|
@Autowired
|
UnitConversionMapper unitConversionMapper;
|
@Autowired
|
SysDictDataService sysDictDataService;
|
@Autowired
|
RedisTemplate redisTemplate;
|
@Autowired
|
SensorService sensorService;
|
|
|
@Override
|
@Transactional
|
public UnitConversionDTO insertUnitConversion(UnitConversionInsertForm form) {
|
//创建返回对象
|
UnitConversionDTO dto = new UnitConversionDTO();
|
//取参
|
UnitConversion unitConversion = form.formConvertEntity();
|
//判断原单位和目标单位计算公式是否已经存在于数据库
|
QueryWrapper<UnitConversion> existWrapper = new QueryWrapper();
|
existWrapper.eq("original_unit_key", unitConversion.getOriginalUnitKey());
|
existWrapper.eq("target_unit_key", unitConversion.getTargetUnitKey());
|
existWrapper.eq("is_delete", Constants.NOT_DELETE);
|
List<UnitConversion> unitConversions = unitConversionMapper.selectList(existWrapper);
|
if (ObjectUtils.isEmpty(unitConversion.getSensorCode())) {
|
if (!ObjectUtils.isEmpty(unitConversions)) {
|
dto.setCode(ResponseCodeEnum.UNIT_CONVERSION_EXIST.getCode());
|
dto.setMsg(ResponseCodeEnum.UNIT_CONVERSION_EXIST.getMsg());
|
return dto;
|
}
|
}
|
if (!ObjectUtils.isEmpty(unitConversion.getSensorCode())) {
|
for (UnitConversion conversion : unitConversions) {
|
if (ObjectUtils.isEmpty(conversion.getSensorCode())||conversion.getSensorCode().equals(unitConversion.getSensorCode())) {
|
dto.setCode(ResponseCodeEnum.UNIT_CONVERSION_EXIST.getCode());
|
dto.setMsg(ResponseCodeEnum.UNIT_CONVERSION_EXIST.getMsg());
|
return dto;
|
}
|
}
|
}
|
//插入数据
|
unitConversionMapper.insert(unitConversion);
|
//刷新缓存
|
refreshCache();
|
//插入日志
|
insertLog(unitConversion);
|
//封装返回数据
|
dto.setCode(ResponseCodeEnum.SUCCESS.getCode());
|
dto.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
|
return dto;
|
}
|
|
@Override
|
public UnitConversionQueryDTO queryUnitConversion(UnitConversionQueryForm form) {
|
//创建返回对象
|
UnitConversionQueryDTO dto = new UnitConversionQueryDTO();
|
//取参
|
Integer page = form.getPage();
|
Integer size = form.getSize();
|
String order = form.getOrder();
|
String orderType = form.getOrderType();
|
Integer isDelete = form.getIsDelete();
|
Integer originalUnitKey = form.getOriginalUnitKey();
|
Integer targetUnitKey = form.getTargetUnitKey();
|
//组装查询条件
|
Page<UnitConversion> queryPage = new Page<>(page, size);
|
NullFilterWrapper<UnitConversion> wrapper = new NullFilterWrapper<>();
|
wrapper.eq("original_unit_key", originalUnitKey);
|
wrapper.eq("target_unit_key", targetUnitKey);
|
//排序顺序条件构造
|
if (!ObjectUtils.isEmpty(order) && !ObjectUtils.isEmpty(orderType)) {
|
if (orderType.equals(Constants.ORDER_ASC))
|
wrapper.orderByAsc(ConvertUtils.toLine(order));
|
else
|
wrapper.orderByDesc(ConvertUtils.toLine(order));
|
}
|
//逻辑删除条件构造
|
if (!ObjectUtils.isEmpty(isDelete))
|
wrapper.eq("is_delete", isDelete);
|
else
|
wrapper.eq("is_delete", Constants.NOT_DELETE);
|
//查询结果
|
Page<UnitConversion> resultPage = unitConversionMapper.selectPage(queryPage, wrapper);
|
List<UnitConversion> records = resultPage.getRecords();
|
//查询每条数据对应的原单位对象和目标单位对象
|
Map<String, SysDictData> dictDatas = sysDictDataService.getDictDatasByType(Constants.SYSTEM_DICT_TYPE_UNIT);
|
List<UnitConversionDTO> dtos = new ArrayList<>();
|
for (UnitConversion record : records) {
|
UnitConversionDTO unitConversionDTO = new UnitConversionDTO();
|
SysDictData originalUnit = dictDatas.get(record.getOriginalUnitKey());
|
SysDictData targetUnit = dictDatas.get(record.getTargetUnitKey());
|
unitConversionDTO.setUnitConversion(record);
|
unitConversionDTO.setOriginalUnit(originalUnit);
|
unitConversionDTO.setTargetUnit(targetUnit);
|
dtos.add(unitConversionDTO);
|
}
|
//封装返回对象
|
dto.setUnitConversionDTOs(dtos);
|
dto.setCurrent(resultPage.getCurrent());
|
dto.setPages(resultPage.getPages());
|
dto.setSize(resultPage.getSize());
|
dto.setTotal(resultPage.getTotal());
|
dto.setCode(ResponseCodeEnum.SUCCESS.getCode());
|
dto.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
|
return dto;
|
}
|
|
@Override
|
@Transactional
|
public UnitConversionDTO updateUnitConversion(UnitConversionUpdateForm form) {
|
//创建返回对象
|
UnitConversionDTO dto = new UnitConversionDTO();
|
//取参
|
UnitConversion unitConversion = form.formConvertEntity();
|
//查找要更新的公式 用于插入日志
|
QueryWrapper<UnitConversion> oldWrapper = new QueryWrapper<>();
|
UnitConversion oldUnitConversion = new UnitConversion();
|
oldUnitConversion.setId(unitConversion.getId());
|
oldUnitConversion.setIsDelete(Constants.NOT_DELETE);
|
oldWrapper.setEntity(oldUnitConversion);
|
oldUnitConversion = unitConversionMapper.selectOne(oldWrapper);
|
//更新
|
unitConversionMapper.updateById(unitConversion);
|
//刷新缓存
|
refreshCache();
|
//操作插入日志
|
updateLog(oldUnitConversion,form.getFormula());
|
//封装返回结果
|
dto.setCode(ResponseCodeEnum.SUCCESS.getCode());
|
dto.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
|
return dto;
|
}
|
|
@Override
|
@Transactional
|
public UnitConversionDTO deleteUnitConversion(UnitConversionDeleteForm form) {
|
//创建返回对象
|
UnitConversionDTO dto = new UnitConversionDTO();
|
//取参
|
Integer id = form.getId();
|
//查询要删除的公式用于插入日志
|
QueryWrapper<UnitConversion> oldWrapper = new QueryWrapper<>();
|
UnitConversion oldUnitConversion = new UnitConversion();
|
oldUnitConversion.setId(id);
|
oldUnitConversion.setIsDelete(Constants.NOT_DELETE);
|
oldWrapper.setEntity(oldUnitConversion);
|
oldUnitConversion = unitConversionMapper.selectOne(oldWrapper);
|
//执行逻辑删除
|
UpdateWrapper deleteWrapper = new UpdateWrapper();
|
deleteWrapper.set("is_delete", Constants.DELETE);
|
deleteWrapper.eq("id", id);
|
unitConversionMapper.update(null, deleteWrapper);
|
//刷新缓存
|
refreshCache();
|
//操作插入日志
|
deleteLog(oldUnitConversion);
|
//封装返回对象
|
dto.setCode(ResponseCodeEnum.SUCCESS.getCode());
|
dto.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
|
return dto;
|
}
|
|
/*刷新缓存*/
|
@Override
|
public void refreshCache(){
|
//刷新设备缓存
|
CacheUtils.refreshDeviceAlarmInfo();
|
redisTemplate.delete((RedisConstants.UNIT_CONVERSION));
|
QueryWrapper<UnitConversion> queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("is_delete",Constants.NOT_DELETE);
|
List<UnitConversion> unitConversions = unitConversionMapper.selectList(queryWrapper);
|
if(!ObjectUtils.isEmpty(unitConversions))
|
redisTemplate.opsForList().leftPushAll(RedisConstants.UNIT_CONVERSION,unitConversions);
|
}
|
|
/**
|
* @Description: 插入操作插入日志
|
* @Param: [unitConversion]
|
* @return: void
|
* @Author: 陈凯裕
|
* @Date: 2021/8/26
|
*/
|
private void insertLog(UnitConversion unitConversion){
|
//获取单位字典数据
|
Map<String, SysDictData> units = sysDictDataService.getDictDatasByType("unit");
|
String originalUnitKey = unitConversion.getOriginalUnitKey();
|
String targetUnitKey = unitConversion.getTargetUnitKey();
|
SysDictData originalData = units.get(originalUnitKey);
|
SysDictData targetData = units.get(targetUnitKey);
|
String formula = unitConversion.getFormula();
|
//公式转换格式
|
formula = formula.replace(Constants.FORMULA_PLACEHOLDER, "源单位");
|
formula = "目标单位"+" = "+formula;
|
String sensorCode = unitConversion.getSensorCode();
|
StringBuilder content = new StringBuilder();
|
content.append("添加了单位转换数据;");
|
content.append("源单位："+originalData.getDataValue()+";");
|
content.append("目标单位："+targetData.getDataValue()+";");
|
content.append("转换公式："+formula+";");
|
if(sensorCode!=null){
|
Sensor sensor = sensorService.getSensorByCode(sensorCode);
|
if(sensor!=null)
|
content.append("针对因子："+sensor.getName()+";");
|
}
|
|
LogUtils.saveOperationForManage(content.toString(),Constants.INSERT_OPERATE_TYPE);
|
}
|
|
/**
|
* @Description: 删除操作插入日志
|
* @Param: [unitConversion]
|
* @return: void
|
* @Author: 陈凯裕
|
* @Date: 2021/8/26
|
*/
|
private void deleteLog(UnitConversion unitConversion){
|
//获取单位字典数据 源单位 目标单位名称
|
Map<String, SysDictData> units = sysDictDataService.getDictDatasByType("unit");
|
String originalUnitKey = unitConversion.getOriginalUnitKey();
|
String targetUnitKey = unitConversion.getTargetUnitKey();
|
SysDictData originalData = units.get(originalUnitKey);
|
SysDictData targetData = units.get(targetUnitKey);
|
//公式转换格式
|
String formula = unitConversion.getFormula();
|
formula = formula.replace(Constants.FORMULA_PLACEHOLDER, "源单位");
|
formula = "目标单位"+" = "+formula;
|
|
StringBuilder content = new StringBuilder("删除了转换公式;");
|
content.append("源单位："+originalData.getDataValue()+";");
|
content.append("目标单位："+targetData.getDataValue()+";");
|
content.append("转换公式："+formula+";");
|
//如果有针对因子则获取针对因子名称
|
String sensorCode = unitConversion.getSensorCode();
|
if(sensorCode!=null){
|
Sensor sensor = sensorService.getSensorByCode(sensorCode);
|
if(sensor!=null)
|
content.append("针对因子："+sensor.getName()+";");
|
}
|
LogUtils.saveOperationForManage(content.toString(),Constants.DELETE_OPERATE_TYPE);
|
}
|
|
/**
|
* @Description: 更新操作插入日志
|
* @Param: [unitConversion]
|
* @return: void
|
* @Author: 陈凯裕
|
* @Date: 2021/8/26
|
*/
|
private void updateLog(UnitConversion oldUnitConversion,String newFormular){
|
StringBuilder content = new StringBuilder("修改了单位转换公式;");
|
//获取单位字典数据 源单位 目标单位名称
|
Map<String, SysDictData> units = sysDictDataService.getDictDatasByType("unit");
|
String originalUnitKey = oldUnitConversion.getOriginalUnitKey();
|
String targetUnitKey = oldUnitConversion.getTargetUnitKey();
|
SysDictData originalData = units.get(originalUnitKey);
|
SysDictData targetData = units.get(targetUnitKey);
|
//新公式转换格式
|
newFormular = newFormular.replace(Constants.FORMULA_PLACEHOLDER, "源单位");
|
newFormular = "目标单位"+" = "+newFormular;
|
//旧公式转换
|
String oldFormula = oldUnitConversion.getFormula();
|
oldFormula = oldFormula.replace(Constants.FORMULA_PLACEHOLDER, "源单位");
|
oldFormula = "目标单位"+" = "+oldFormula;
|
|
content.append("源单位："+originalData.getDataValue()+";");
|
content.append("目标单位："+targetData.getDataValue()+";");
|
content.append("转换公式："+oldFormula+"->"+newFormular+";");
|
//如果有针对因子则获取针对因子名称
|
String sensorCode = oldUnitConversion.getSensorCode();
|
if(sensorCode!=null){
|
Sensor sensor = sensorService.getSensorByCode(sensorCode);
|
if(sensor!=null)
|
content.append("针对因子："+sensor.getName()+";");
|
}
|
LogUtils.saveOperationForManage(content.toString(),Constants.UPDATE_OPERATE_TYPE);
|
}
|
}
|
