From 0362fcddcf08663680063f8be1a71aacc0491e05 Mon Sep 17 00:00:00 2001 From: lizijie <lzjiiie@163.com> Date: Wed, 16 Jun 2021 17:23:03 +0800 Subject: [PATCH] device_adjust_value删除接口 --- screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java | 111 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 111 insertions(+), 0 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..cfb38aa 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; /** @@ -86,4 +91,110 @@ 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; + } + } -- Gitblit v1.8.0