From d666793c93e91026e129f00bae414217690635ae Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Thu, 27 May 2021 13:20:34 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/dev' into dev_ --- screen-manage/src/main/java/com/moral/api/pojo/vo/sensor/SensorVO.java | 5 - /dev/null | 26 -------- screen-manage/src/main/java/com/moral/api/controller/SystemController.java | 22 +------ screen-manage/src/main/java/com/moral/api/service/impl/SysDictDataServiceImpl.java | 32 +++++----- screen-manage/src/main/java/com/moral/api/controller/SysDictController.java | 23 +------ screen-manage/src/main/java/com/moral/api/entity/Sensor.java | 6 -- screen-manage/src/main/java/com/moral/api/service/impl/SysDictTypeServiceImpl.java | 1 screen-manage/src/main/java/com/moral/api/entity/VersionSensorUnit.java | 8 +- screen-manage/src/main/java/com/moral/api/pojo/vo/Version/VersionQueryVO.java | 6 +- screen-manage/src/main/resources/mapper/VersionMapper.xml | 9 +- screen-manage/src/main/java/com/moral/api/pojo/form/sysDictData/SysDictDataUpdateForm.java | 4 - screen-manage/src/main/java/com/moral/api/service/impl/SensorServiceImpl.java | 6 +- 12 files changed, 39 insertions(+), 109 deletions(-) diff --git a/screen-manage/src/main/java/com/moral/api/controller/SysDictController.java b/screen-manage/src/main/java/com/moral/api/controller/SysDictController.java index 149c423..f1e9d44 100644 --- a/screen-manage/src/main/java/com/moral/api/controller/SysDictController.java +++ b/screen-manage/src/main/java/com/moral/api/controller/SysDictController.java @@ -9,9 +9,6 @@ import com.moral.api.pojo.form.sysDictType.SysDictTypeDeleteForm; import com.moral.api.pojo.form.sysDictType.SysDictTypeInsertForm; import com.moral.api.pojo.form.sysDictType.SysDictTypeUpdateForm; -import com.moral.api.pojo.vo.sysDictData.SysDictDataDeleteVO; -import com.moral.api.pojo.vo.sysDictData.SysDictDataInsertVO; -import com.moral.api.pojo.vo.sysDictData.SysDictDataUpdateVO; import com.moral.api.pojo.vo.sysDictType.SysDictTypeDeleteVO; import com.moral.api.pojo.vo.sysDictType.SysDictTypeInsertVO; import com.moral.api.pojo.vo.sysDictType.SysDictTypeQueryVO; @@ -71,10 +68,7 @@ //������������������ SysDictDataDTO dto = sysDictDataService.insertData(form); - //������������������������ - SysDictDataInsertVO vo = SysDictDataInsertVO.convert(dto); - - return new ResultMessage(dto.getCode(), dto.getMsg(), vo); + return new ResultMessage(dto.getCode(), dto.getMsg(), null); } @PostMapping("data/update") @@ -87,10 +81,7 @@ //������������������ SysDictDataDTO dto = sysDictDataService.updateData(form); - //������������������������ - SysDictDataUpdateVO vo = SysDictDataUpdateVO.convert(dto); - - return new ResultMessage(dto.getCode(), dto.getMsg(), vo); + return new ResultMessage(dto.getCode(), dto.getMsg(), null); } @PostMapping("data/delete") @@ -103,10 +94,7 @@ //������������������ SysDictDataDTO dto = sysDictDataService.deleteData(form); - //������������������������ - SysDictDataDeleteVO vo = SysDictDataDeleteVO.convert(dto); - - return new ResultMessage(dto.getCode(), dto.getMsg(), vo); + return new ResultMessage(dto.getCode(), dto.getMsg(), null); } @GetMapping("type/query") @@ -131,10 +119,7 @@ //������������������ SysDictTypeDTO dto = sysDictTypeService.insertType(form); - //������������������������ - SysDictTypeInsertVO vo = SysDictTypeInsertVO.convert(dto); - - return new ResultMessage(dto.getCode(), dto.getMsg(), vo); + return new ResultMessage(dto.getCode(), dto.getMsg(),null); } @PostMapping("type/update") diff --git a/screen-manage/src/main/java/com/moral/api/controller/SystemController.java b/screen-manage/src/main/java/com/moral/api/controller/SystemController.java index debe6d4..78b959c 100644 --- a/screen-manage/src/main/java/com/moral/api/controller/SystemController.java +++ b/screen-manage/src/main/java/com/moral/api/controller/SystemController.java @@ -2,28 +2,12 @@ import com.moral.api.entity.SysArea; import com.moral.api.pojo.dto.manageLog.ManageLogQueryDTO; -import com.moral.api.pojo.dto.sysDictData.SysDictDataDTO; -import com.moral.api.pojo.dto.sysDictType.SysDictTypeDTO; -import com.moral.api.pojo.dto.sysDictType.SysDictTypeQueryDTO; -import com.moral.api.pojo.form.sysDictData.SysDictDataDeleteForm; -import com.moral.api.pojo.form.sysDictData.SysDictDataInsertForm; -import com.moral.api.pojo.form.sysDictData.SysDictDataUpdateForm; -import com.moral.api.pojo.form.sysDictType.SysDictTypeDeleteForm; -import com.moral.api.pojo.form.sysDictType.SysDictTypeInsertForm; -import com.moral.api.pojo.form.sysDictType.SysDictTypeUpdateForm; + import com.moral.api.pojo.form.manageLog.*; -import com.moral.api.pojo.vo.sysDictData.SysDictDataDeleteVO; -import com.moral.api.pojo.vo.sysDictData.SysDictDataInsertVO; -import com.moral.api.pojo.vo.sysDictData.SysDictDataUpdateVO; -import com.moral.api.pojo.vo.sysDictType.SysDictTypeDeleteVO; -import com.moral.api.pojo.vo.sysDictType.SysDictTypeInsertVO; -import com.moral.api.pojo.vo.sysDictType.SysDictTypeQueryVO; -import com.moral.api.pojo.vo.sysDictType.SysDictTypeUpdateVO; import com.moral.api.pojo.vo.manageLog.*; import com.moral.api.service.ManageLogService; import com.moral.api.service.SysAreaService; -import com.moral.api.service.SysDictDataService; -import com.moral.api.service.SysDictTypeService; + import com.moral.constant.ResponseCodeEnum; import com.moral.constant.ResultMessage; import lombok.extern.slf4j.Slf4j; @@ -31,7 +15,7 @@ import org.springframework.web.bind.annotation.*; import java.util.List; -import java.util.Map; + /** * @ClassName SystemController diff --git a/screen-manage/src/main/java/com/moral/api/entity/Sensor.java b/screen-manage/src/main/java/com/moral/api/entity/Sensor.java index c7bf6a6..7d9b70f 100644 --- a/screen-manage/src/main/java/com/moral/api/entity/Sensor.java +++ b/screen-manage/src/main/java/com/moral/api/entity/Sensor.java @@ -84,10 +84,4 @@ @TableField(exist = false) private String unitKey; - @TableField(exist = false) - private Integer maxValue; - - @TableField(exist = false) - private Integer minValue; - } diff --git a/screen-manage/src/main/java/com/moral/api/entity/VersionSensorUnit.java b/screen-manage/src/main/java/com/moral/api/entity/VersionSensorUnit.java index a4432ec..0802b5c 100644 --- a/screen-manage/src/main/java/com/moral/api/entity/VersionSensorUnit.java +++ b/screen-manage/src/main/java/com/moral/api/entity/VersionSensorUnit.java @@ -36,9 +36,9 @@ private Integer versionId; /** - * ������code + * ������Id */ - private String sensorCode; + private Integer sensorId; /** * ������������key @@ -48,12 +48,12 @@ /* * ��������� * */ - private Integer maxValue; + private Double upper; /* * ��������� * */ - private Integer minValue; + private Double lower; /** * ������������ diff --git a/screen-manage/src/main/java/com/moral/api/pojo/form/sysDictData/SysDictDataUpdateForm.java b/screen-manage/src/main/java/com/moral/api/pojo/form/sysDictData/SysDictDataUpdateForm.java index 3c252c3..4dc4ba7 100644 --- a/screen-manage/src/main/java/com/moral/api/pojo/form/sysDictData/SysDictDataUpdateForm.java +++ b/screen-manage/src/main/java/com/moral/api/pojo/form/sysDictData/SysDictDataUpdateForm.java @@ -21,9 +21,7 @@ private String value; public boolean valid() { - if (ObjectUtils.isEmpty(id) || - ObjectUtils.isEmpty(key) || - ObjectUtils.isEmpty(value)) + if (ObjectUtils.isEmpty(id)) return false; return true; } diff --git a/screen-manage/src/main/java/com/moral/api/pojo/vo/Version/VersionQueryVO.java b/screen-manage/src/main/java/com/moral/api/pojo/vo/Version/VersionQueryVO.java index 81d74c7..85d4ae1 100644 --- a/screen-manage/src/main/java/com/moral/api/pojo/vo/Version/VersionQueryVO.java +++ b/screen-manage/src/main/java/com/moral/api/pojo/vo/Version/VersionQueryVO.java @@ -87,10 +87,10 @@ private static SensorVO convertToSensorVO(Sensor sensor) { SensorVO vo = new SensorVO(); vo.setName(sensor.getName()); - vo.setCode(sensor.getCode()); + vo.setId(sensor.getId()); vo.setUnit(sensor.getUnit()); - vo.setMaxValue(sensor.getMaxValue()); - vo.setMinValue(sensor.getMinValue()); + vo.setUpper(sensor.getUpper()); + vo.setLower(sensor.getLower()); vo.setUnitKey(sensor.getUnitKey()); return vo; } diff --git a/screen-manage/src/main/java/com/moral/api/pojo/vo/sensor/SensorVO.java b/screen-manage/src/main/java/com/moral/api/pojo/vo/sensor/SensorVO.java index ae9e4e8..8509cf8 100644 --- a/screen-manage/src/main/java/com/moral/api/pojo/vo/sensor/SensorVO.java +++ b/screen-manage/src/main/java/com/moral/api/pojo/vo/sensor/SensorVO.java @@ -11,7 +11,6 @@ * @Version TODO **/ @Data -@JsonInclude(JsonInclude.Include.NON_EMPTY) public class SensorVO { private Integer id; @@ -31,8 +30,8 @@ private String unitKey; - private Integer maxValue; + private Double upper; - private Integer minValue; + private Double lower; } diff --git a/screen-manage/src/main/java/com/moral/api/pojo/vo/sysDictData/SysDictDataDeleteVO.java b/screen-manage/src/main/java/com/moral/api/pojo/vo/sysDictData/SysDictDataDeleteVO.java deleted file mode 100644 index 8719800..0000000 --- a/screen-manage/src/main/java/com/moral/api/pojo/vo/sysDictData/SysDictDataDeleteVO.java +++ /dev/null @@ -1,27 +0,0 @@ -package com.moral.api.pojo.vo.sysDictData; - - -import com.moral.api.entity.SysDictData; -import com.moral.api.pojo.dto.sysDictData.SysDictDataDTO; -import com.moral.constant.ResponseCodeEnum; - -/** - * @ClassName SysDictDataDeleteVO - * @Description TODO - * @Author ��������� - * @Date 2021/4/16 13:46 - * @Version TODO - **/ -public class SysDictDataDeleteVO extends SysDictDataVO{ - - public static SysDictDataDeleteVO convert(SysDictDataDTO dto){ - if (dto.getCode() != ResponseCodeEnum.SUCCESS.getCode()) - return null; - SysDictDataDeleteVO vo = new SysDictDataDeleteVO(); - SysDictData data = dto.getSysDictData(); - vo.setId(data.getId()); - vo.setKey(data.getDataKey()); - vo.setValue(data.getDataValue()); - return vo; - } -} diff --git a/screen-manage/src/main/java/com/moral/api/pojo/vo/sysDictData/SysDictDataInsertVO.java b/screen-manage/src/main/java/com/moral/api/pojo/vo/sysDictData/SysDictDataInsertVO.java deleted file mode 100644 index 6e8c7c8..0000000 --- a/screen-manage/src/main/java/com/moral/api/pojo/vo/sysDictData/SysDictDataInsertVO.java +++ /dev/null @@ -1,30 +0,0 @@ -package com.moral.api.pojo.vo.sysDictData; - -import com.moral.api.entity.SysDictData; -import com.moral.api.entity.SysDictType; -import com.moral.api.pojo.dto.sysDictData.SysDictDataDTO; -import com.moral.constant.ResponseCodeEnum; - -/** - * @ClassName SysDictDataInsertVO - * @Description TODO - * @Author ��������� - * @Date 2021/4/16 10:31 - * @Version TODO - **/ -public class SysDictDataInsertVO extends SysDictDataVO { - - public static SysDictDataInsertVO convert(SysDictDataDTO dto){ - if (dto.getCode() != ResponseCodeEnum.SUCCESS.getCode()) - return null; - SysDictDataInsertVO vo = new SysDictDataInsertVO(); - SysDictData data = dto.getSysDictData(); - SysDictType type = dto.getSysDictType(); - vo.setId(data.getId()); - vo.setKey(data.getDataKey()); - vo.setValue(data.getDataValue()); - vo.setTypeId(type.getId()); - vo.setTypeName(type.getName()); - return vo; - } -} diff --git a/screen-manage/src/main/java/com/moral/api/pojo/vo/sysDictData/SysDictDataUpdateVO.java b/screen-manage/src/main/java/com/moral/api/pojo/vo/sysDictData/SysDictDataUpdateVO.java deleted file mode 100644 index a6c9e57..0000000 --- a/screen-manage/src/main/java/com/moral/api/pojo/vo/sysDictData/SysDictDataUpdateVO.java +++ /dev/null @@ -1,26 +0,0 @@ -package com.moral.api.pojo.vo.sysDictData; - -import com.moral.api.entity.SysDictData; -import com.moral.api.pojo.dto.sysDictData.SysDictDataDTO; -import com.moral.constant.ResponseCodeEnum; - -/** - * @ClassName SysDictDataUpdateVO - * @Description TODO - * @Author ��������� - * @Date 2021/4/16 11:48 - * @Version TODO - **/ -public class SysDictDataUpdateVO extends SysDictDataVO{ - - public static SysDictDataUpdateVO convert(SysDictDataDTO dto){ - if (dto.getCode() != ResponseCodeEnum.SUCCESS.getCode()) - return null; - SysDictDataUpdateVO vo = new SysDictDataUpdateVO(); - SysDictData data = dto.getSysDictData(); - vo.setId(data.getId()); - vo.setKey(data.getDataKey()); - vo.setValue(data.getDataValue()); - return vo; - } -} 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 8e0b503..0bf6dc0 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 @@ -138,12 +138,12 @@ content = content+"���������:"+oldSensor.getName()+"->"+updateSensorMap.get(key)+";"; } if (key.toString().equals("code")&&updateSensorMap.get(key)!=null){ - QueryWrapper<VersionSensorUnit> wrapper_Version = new QueryWrapper<>(); + /*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); + versionSensorUnitMapper.update(versionSensorUnit,wrapper_Version);*/ content = content+"������:"+oldSensor.getCode()+"->"+updateSensorMap.get(key)+";"; } if (key.toString().equals("desc")&&updateSensorMap.get(key)!=null){ @@ -234,7 +234,7 @@ deleteSensor.setIsDelete(Constants.DELETE); sensorMapper.update(deleteSensor,wrapper); QueryWrapper<VersionSensorUnit> wrapper_Version = new QueryWrapper<>(); - wrapper_Version.eq("sensor_code",sensor.getCode()); + wrapper_Version.eq("sensor_id",sensor.getId()); wrapper_Version.eq("is_delete","0"); VersionSensorUnit versionSensorUnit = new VersionSensorUnit(); versionSensorUnit.setIsDelete(Constants.DELETE); diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/SysDictDataServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/SysDictDataServiceImpl.java index 7f49f18..78aaf42 100644 --- a/screen-manage/src/main/java/com/moral/api/service/impl/SysDictDataServiceImpl.java +++ b/screen-manage/src/main/java/com/moral/api/service/impl/SysDictDataServiceImpl.java @@ -51,7 +51,7 @@ SysDictDataDTO dto = new SysDictDataDTO(); //������ Integer id = form.getId(); - //������������������ + //��������������������������������������������� QueryWrapper existWrapper = new QueryWrapper(); existWrapper.eq("is_delete", Constants.NOT_DELETE); existWrapper.eq("id", id); @@ -64,7 +64,6 @@ //������������ CacheUtils.clearDictionariesCache(); //������������������ - dto.setSysDictData(existData); dto.setCode(ResponseCodeEnum.SUCCESS.getCode()); dto.setMsg(ResponseCodeEnum.SUCCESS.getMsg()); return dto; @@ -82,22 +81,23 @@ SysDictData existData = sysDictDataMapper.selectOne(existWrapper); //������key������������ String key = sysDictData.getDataKey(); - QueryWrapper<SysDictData> wrapper = new QueryWrapper<>(); - wrapper.eq("is_delete", Constants.NOT_DELETE); - wrapper.eq("dataKey", key); - wrapper.eq("dict_type_id", existData.getDictTypeId()); - SysDictData existKeyData = sysDictDataMapper.selectOne(wrapper); - if (!ObjectUtils.isEmpty(existKeyData)) { - dto.setCode(ResponseCodeEnum.DICTDATA_KEY_EXIST.getCode()); - dto.setMsg(ResponseCodeEnum.DICTDATA_KEY_EXIST.getMsg()); - return dto; + if (!ObjectUtils.isEmpty(key)) { + QueryWrapper<SysDictData> wrapper = new QueryWrapper<>(); + wrapper.eq("is_delete", Constants.NOT_DELETE); + wrapper.eq("dataKey", key); + wrapper.eq("dict_type_id", existData.getDictTypeId()); + SysDictData existKeyData = sysDictDataMapper.selectOne(wrapper); + if (!ObjectUtils.isEmpty(existKeyData)) { + dto.setCode(ResponseCodeEnum.DICTDATA_KEY_EXIST.getCode()); + dto.setMsg(ResponseCodeEnum.DICTDATA_KEY_EXIST.getMsg()); + return dto; + } } //������������ sysDictDataMapper.updateById(sysDictData); //������������ CacheUtils.clearDictionariesCache(); //������������������ - dto.setSysDictData(sysDictData); dto.setCode(ResponseCodeEnum.SUCCESS.getCode()); dto.setMsg(ResponseCodeEnum.SUCCESS.getMsg()); return dto; @@ -115,7 +115,7 @@ SysDictDataDTO dto = new SysDictDataDTO(); //������ SysDictData sysDictData = form.formConvertEntity(); - //������������������������ + //������������������������������������ SysDictType type = sysDictTypeService.getDictTypeById(sysDictData.getDictTypeId()); if (ObjectUtils.isEmpty(type)) { dto.setCode(ResponseCodeEnum.DICTTYPE_NOT_EXIST.getCode()); @@ -139,8 +139,6 @@ //������������ CacheUtils.clearDictionariesCache(); //������������������ - dto.setSysDictData(sysDictData); - dto.setSysDictType(type); dto.setCode(ResponseCodeEnum.SUCCESS.getCode()); dto.setMsg(ResponseCodeEnum.SUCCESS.getMsg()); return dto; @@ -149,7 +147,7 @@ /** * @Description: ��������������������������������������������� * @Param: [typeName] - * @return: java.util.Map<java.lang.String , java.lang.Object> + * @return: java.util.Map<java.lang.String , java.lang.Object> * @Author: ��������� * @Date: 2021/4/16 */ @@ -194,7 +192,7 @@ /** * @Description: ������������������������������������������������������������Map Key��������������� value��������������� * @Param: [] - * @return: java.util.Map<java.lang.String , java.util.List < com.moral.api.entity.sysDictData>> + * @return: java.util.Map<java.lang.String , java.util.List < com.moral.api.entity.sysDictData>> * @Author: ��������� * @Date: 2021/4/14 */ diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/SysDictTypeServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/SysDictTypeServiceImpl.java index 88f87d2..07a42ce 100644 --- a/screen-manage/src/main/java/com/moral/api/service/impl/SysDictTypeServiceImpl.java +++ b/screen-manage/src/main/java/com/moral/api/service/impl/SysDictTypeServiceImpl.java @@ -134,7 +134,6 @@ //������������ CacheUtils.clearDictionariesCache(); //������������������ - dto.setSysDictType(sysDictType); dto.setCode(ResponseCodeEnum.SUCCESS.getCode()); dto.setMsg(ResponseCodeEnum.SUCCESS.getMsg()); return dto; diff --git a/screen-manage/src/main/resources/mapper/VersionMapper.xml b/screen-manage/src/main/resources/mapper/VersionMapper.xml index b8f5a8b..5df3891 100644 --- a/screen-manage/src/main/resources/mapper/VersionMapper.xml +++ b/screen-manage/src/main/resources/mapper/VersionMapper.xml @@ -22,17 +22,16 @@ <collection property="sensors" column="id" ofType="com.moral.api.entity.Sensor"> <id property="id" column="sid"></id> <result property="name" column="sname"></result> - <result property="code" column="scode"></result> <result property="unitKey" column="dataKey"></result> <result property="unit" column="dataValue"></result> - <result property="maxValue" column="max_value"></result> - <result property="minValue" column="min_value"></result> + <result property="upper" column="vupper"></result> + <result property="lower" column="vlower"></result> </collection> </resultMap> <select id="queryVersionsAndSensorUnitByIds" resultMap="VersionSensorUnitMap"> SELECT - v.`id`,v.`name`,v.`desc`,v.`create_time`,v.`update_time`,s.`id` AS sid,s.`code` as scode,s.`name` AS sname ,u.dataKey,u.dataValue,vsu.`max_value` ,vsu.`min_value` + v.`id`,v.`name`,v.`desc`,v.`create_time`,v.`update_time`,s.`id` AS sid,s.`name` AS sname ,u.dataKey,u.dataValue,vsu.`upper` AS vupper ,vsu.`lower` AS vlower FROM `version` v LEFT JOIN @@ -42,7 +41,7 @@ LEFT JOIN sensor s ON - s.`code` = vsu.`sensor_code` AND s.`is_delete` = 0 + s.`id` = vsu.`sensor_id` AND s.`is_delete` = 0 LEFT JOIN ( SELECT -- Gitblit v1.8.0