From cc06e680134316be4655422d06056a916b8bd8e4 Mon Sep 17 00:00:00 2001
From: kaiyu <404897439@qq.com>
Date: Fri, 18 Jun 2021 09:01:43 +0800
Subject: [PATCH] screen-api 修改型号查询bug
---
screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java | 147 ++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 146 insertions(+), 1 deletions(-)
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java
index 8912001..562c462 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java
@@ -1,7 +1,9 @@
package com.moral.api.service.impl;
+import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.moral.api.entity.Device;
import com.moral.api.entity.DeviceAdjustValue;
import com.moral.api.entity.Sensor;
@@ -20,7 +22,10 @@
import org.springframework.web.context.request.ServletRequestAttributes;
import javax.servlet.http.HttpServletRequest;
+import java.sql.Time;
+import java.util.ArrayList;
import java.util.HashMap;
+import java.util.List;
import java.util.Map;
/**
@@ -79,11 +84,151 @@
deviceAdjustValueMapper.insert(deviceAdjustValue);
//������������������
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
- String content = "���������������:"+deviceAdjustValue+";";
+ String content = "���������"+deviceAdjustValue.getMac()+"������"+deviceAdjustValue.getSensorCode()+"���������"+deviceAdjustValue.getStartTime()+"���"+deviceAdjustValue.getEndTime()+"���������������:"+";";
logUtils.saveOperationForManage(request,content,Constants.INSERT_OPERATE_TYPE);
resultMap.put("code", ResponseCodeEnum.SUCCESS.getCode());
resultMap.put("msg", ResponseCodeEnum.SUCCESS.getMsg());
return resultMap;
}
+ @Override
+ public Map<String, Object> getDataByCondition(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<DeviceAdjustValue> page = new Page<>(current,size);
+ QueryWrapper<DeviceAdjustValue> wrapper_Condition = new QueryWrapper<>();
+ wrapper_Condition.eq("is_delete",Constants.NOT_DELETE);
+ if (!ObjectUtils.isEmpty(map.get("mac"))){
+ wrapper_Condition.eq("mac",map.get("mac"));
+ }
+ if (!ObjectUtils.isEmpty(map.get("sensor_code"))){
+ wrapper_Condition.eq("sensor_code",map.get("sensor_code"));
+ }
+ if (!ObjectUtils.isEmpty(map.get("orderType"))){
+ String orderType = map.get("orderType").toString();
+ if (orderType.equals(Constants.ORDER_ASC)){
+ wrapper_Condition.orderByAsc("start_time");
+ }else {
+ wrapper_Condition.orderByDesc("start_time");
+ }
+ }
+ Page resultPage = deviceAdjustValueMapper.selectPage(page,wrapper_Condition);
+ List<DeviceAdjustValue> deviceAdjustValues = resultPage.getRecords();
+ List<Map<String,Object>> deviceAdjustValueList = new ArrayList<>();
+ for (DeviceAdjustValue deviceAdjustValue:deviceAdjustValues) {
+ Map deviceAdjustValueMap = JSON.parseObject(JSON.toJSONString(deviceAdjustValue),Map.class);
+ Time startTime = new Time(Long.valueOf(Long.parseLong(deviceAdjustValueMap.get("startTime").toString())));
+ deviceAdjustValueMap.put("startTime",new Time(startTime.getTime()));
+ Time endTime = new Time(Long.valueOf(Long.parseLong(deviceAdjustValueMap.get("endTime").toString())));
+ deviceAdjustValueMap.put("endTime",new Time(endTime.getTime()));
+ deviceAdjustValueList.add(deviceAdjustValueMap);
+ }
+ resultMap.put("deviceAdjustValues",deviceAdjustValueList);
+ int totalNumber = deviceAdjustValueMapper.selectCount(wrapper_Condition);
+ resultMap.put("totalNumber",totalNumber);
+ resultMap.put("current",current);
+ resultMap.put("size",size);
+ int totalPageNumber = totalNumber/size;
+ if(totalNumber%size != 0){
+ totalPageNumber += 1;
+ }
+ resultMap.put("totalPageNumber",totalPageNumber);
+ return resultMap;
+ }
+
+ @Override
+ public Map<String, Object> updateOne(Map map) {
+ Map<String,Object> resultMap = new HashMap<>();
+ if (ObjectUtils.isEmpty(map.get("id"))||map.get("id").equals("")){
+ resultMap.put("code",ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode());
+ resultMap.put("msg",ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
+ return resultMap;
+ }
+ DeviceAdjustValue deviceAdjustValueOld = deviceAdjustValueMapper.selectById(Integer.parseInt(map.get("id").toString()));
+ deviceAdjustValueMapper.updateDeviceAdjustValue(map);
+ //������������������
+ HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
+ String content = "���������"+deviceAdjustValueOld.getMac()+"������"+deviceAdjustValueOld.getSensorCode()+"������������������������:"+";";
+ for (Object key:map.keySet()) {
+ if (key.toString().equals("start_time")&&map.get(key)!=null){
+ content = content+"������������:"+deviceAdjustValueOld.getStartTime()+"->"+map.get(key)+";";
+ }
+ if (key.toString().equals("end_time")&&map.get(key)!=null){
+ content = content+"������������:"+deviceAdjustValueOld.getEndTime()+"->"+map.get(key)+";";
+ }
+ if (key.toString().equals("value")&&map.get(key)!=null){
+ content = content+"������������:"+deviceAdjustValueOld.getValue()+"->"+map.get(key)+";";
+ }
+ }
+ logUtils.saveOperationForManage(request,content,Constants.UPDATE_OPERATE_TYPE);
+ resultMap.put("code",ResponseCodeEnum.SUCCESS.getCode());
+ resultMap.put("msg",ResponseCodeEnum.SUCCESS.getMsg());
+ return resultMap;
+ }
+
+ @Override
+ public Map<String, Object> deleteOne(Map map) {
+ Map<String,Object> resultMap = new HashMap<>();
+ if (ObjectUtils.isEmpty(map.get("id"))||map.get("id").equals("")){
+ resultMap.put("code",ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode());
+ resultMap.put("msg",ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
+ return resultMap;
+ }
+ QueryWrapper<DeviceAdjustValue> wrapper = new QueryWrapper<>();
+ wrapper.eq("is_delete",Constants.NOT_DELETE);
+ wrapper.eq("id",map.get("id"));
+ DeviceAdjustValue deviceAdjustValue = deviceAdjustValueMapper.selectOne(wrapper);
+ if (ObjectUtils.isEmpty(deviceAdjustValue)){
+ resultMap.put("code",ResponseCodeEnum.TARGET_IS_NULL.getCode());
+ resultMap.put("msg",ResponseCodeEnum.TARGET_IS_NULL.getMsg());
+ return resultMap;
+ }
+ Map<String,Object> deleteMap = new HashMap<>();
+ deleteMap.put("id",map.get("id"));
+ deleteMap.put("is_delete",Constants.DELETE);
+ deviceAdjustValueMapper.updateDeviceAdjustValue(deleteMap);
+ //������������������
+ HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
+ String content = "���������"+deviceAdjustValue.getMac()+"������"+deviceAdjustValue.getSensorCode()+"���������"+deviceAdjustValue.getStartTime()+"���"+deviceAdjustValue.getEndTime()+"���������������:"+";";
+ logUtils.saveOperationForManage(request,content,Constants.DELETE_OPERATE_TYPE);
+ resultMap.put("code",ResponseCodeEnum.SUCCESS.getCode());
+ resultMap.put("msg",ResponseCodeEnum.SUCCESS.getMsg());
+ return resultMap;
+ }
+
+ @Override
+ public Map<String, Object> getTimeSlot(Map map) {
+ Map<String,Object> resultMap = new HashMap<>();
+ if (ObjectUtils.isEmpty(map.get("sensor_code"))||map.get("sensor_code").equals("")){
+ resultMap.put("code",ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode());
+ resultMap.put("msg",ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
+ return resultMap;
+ }
+ if (ObjectUtils.isEmpty(map.get("mac"))||map.get("mac").equals("")){
+ resultMap.put("code",ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode());
+ resultMap.put("msg",ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
+ return resultMap;
+ }
+ QueryWrapper<DeviceAdjustValue> wrapper = new QueryWrapper<>();
+ wrapper.eq("is_delete",Constants.NOT_DELETE);
+ wrapper.eq("sensor_code",map.get("sensor_code"));
+ wrapper.eq("mac",map.get("mac"));
+ List<DeviceAdjustValue> deviceAdjustValues = deviceAdjustValueMapper.selectList(wrapper);
+ List<Map<String,Object>> timeSlotList = new ArrayList<>();
+ if (deviceAdjustValues.size()==0){
+ resultMap.put("timeSlotList",timeSlotList);
+ return resultMap;
+ }
+ for (DeviceAdjustValue deviceAdjustValue:deviceAdjustValues) {
+ Map timeSlotMap = new HashMap();
+ timeSlotMap.put("id",deviceAdjustValue.getId());
+ timeSlotMap.put("startTime",deviceAdjustValue.getStartTime());
+ timeSlotMap.put("endTime",deviceAdjustValue.getEndTime());
+ timeSlotList.add(timeSlotMap);
+ }
+ resultMap.put("timeSlotList",timeSlotList);
+ return resultMap;
+ }
+
}
--
Gitblit v1.8.0