From 4b4a35fc7cc56a8b304ca35f0a9ec0bdd2e0e036 Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Mon, 22 Apr 2024 11:41:48 +0800 Subject: [PATCH] fix:路径规划补充提交 --- screen-manage/src/main/java/com/moral/api/service/impl/SensorServiceImpl.java | 386 ++++++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 327 insertions(+), 59 deletions(-) diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/SensorServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/SensorServiceImpl.java index 04f093d..966c51d 100644 --- a/screen-manage/src/main/java/com/moral/api/service/impl/SensorServiceImpl.java +++ b/screen-manage/src/main/java/com/moral/api/service/impl/SensorServiceImpl.java @@ -1,14 +1,23 @@ package com.moral.api.service.impl; +import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; -import com.moral.api.entity.Sensor; +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; @@ -16,13 +25,15 @@ 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 @@ -35,100 +46,357 @@ @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 - LogUtils logUtils; + 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()); + 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()); + 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()); + 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()); + 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 - 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()); + @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.containsKey("name")){ - if (updateSensorMap.get("name")==null||updateSensorMap.get("name")==""){ - 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.containsKey("code")){ - if(ObjectUtils.isEmpty(updateSensorMap.get("code"))){ - 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()); + 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"); + wrapper_code.eq("code", updateSensorMap.get("code")); + wrapper_code.eq("is_delete", "0"); List<Sensor> sensorList = sensorMapper.selectList(wrapper_code); - System.out.println(sensorList.get(0)); - 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()); + 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")){ - content = content+"���������:"+oldSensor.getName()+"->"+updateSensorMap.get(key)+";"; + 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")){ - content = content+"������:"+oldSensor.getCode()+"->"+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")){ - content = content+"������:"+oldSensor.getDesc()+"->"+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) + ";"; } } - System.out.println(content); - logUtils.saveOperationForManage(request,content,Constants.UPDATE_OPERATE_TYPE); - resultMap.put("code",ResponseCodeEnum.SUCCESS.getCode()); - resultMap.put("msg",ResponseCodeEnum.SUCCESS.getMsg()); + 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); + } } -- Gitblit v1.8.0