From d4dc39493e7427b86861e73b26ad436d61885ec8 Mon Sep 17 00:00:00 2001
From: lizijie <lzjiiie@163.com>
Date: Tue, 15 Jun 2021 13:39:53 +0800
Subject: [PATCH] device_adjust_value查询接口

---
 screen-manage/src/main/java/com/moral/api/controller/DeviceAdjustValueController.java    |   13 ++++++
 screen-manage/src/main/java/com/moral/api/service/DeviceAdjustValueService.java          |    2 +
 screen-manage/src/main/java/com/moral/api/service/impl/DeviceAdjustValueServiceImpl.java |   46 +++++++++++++++++++++++
 3 files changed, 61 insertions(+), 0 deletions(-)

diff --git a/screen-manage/src/main/java/com/moral/api/controller/DeviceAdjustValueController.java b/screen-manage/src/main/java/com/moral/api/controller/DeviceAdjustValueController.java
index 89f5557..b161a71 100644
--- a/screen-manage/src/main/java/com/moral/api/controller/DeviceAdjustValueController.java
+++ b/screen-manage/src/main/java/com/moral/api/controller/DeviceAdjustValueController.java
@@ -4,11 +4,13 @@
 import com.moral.api.entity.DeviceAdjustValue;
 import com.moral.api.service.DeviceAdjustValueService;
 import com.moral.constant.ResultMessage;
+import com.moral.util.WebUtils;
 import io.swagger.annotations.Api;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.web.bind.annotation.*;
 
 import javax.annotation.Resource;
+import javax.servlet.http.HttpServletRequest;
 import java.util.Map;
 
 @Slf4j
@@ -33,4 +35,15 @@
         return ResultMessage.fail(Integer.parseInt(resultMap.get("code").toString()),resultMap.get("msg").toString());
     }
 
+    @RequestMapping(value = "getDeviceAdjustValueByCondition", method = RequestMethod.GET)
+    @ResponseBody
+    public ResultMessage getDeviceAdjustValueByCondition(HttpServletRequest request) {
+        Map<String,Object> parameters = WebUtils.getParametersStartingWith(request,null);
+        Map<String,Object> resultMap = deviceAdjustValueService.getDataByCondition(parameters);
+        if (!resultMap.containsKey("code")){
+            return ResultMessage.ok(resultMap);
+        }
+        return ResultMessage.fail(Integer.parseInt(resultMap.get("code").toString()),resultMap.get("msg").toString());
+    }
+
 }
diff --git a/screen-manage/src/main/java/com/moral/api/service/DeviceAdjustValueService.java b/screen-manage/src/main/java/com/moral/api/service/DeviceAdjustValueService.java
index e906f7f..d7d12a6 100644
--- a/screen-manage/src/main/java/com/moral/api/service/DeviceAdjustValueService.java
+++ b/screen-manage/src/main/java/com/moral/api/service/DeviceAdjustValueService.java
@@ -20,4 +20,6 @@
     @Transactional
     Map<String, Object> insertOne(DeviceAdjustValue deviceAdjustValue);
 
+    Map<String,Object> getDataByCondition(Map map);
+
 }
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..e1c258b 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,9 @@
 import org.springframework.web.context.request.ServletRequestAttributes;
 
 import javax.servlet.http.HttpServletRequest;
+import java.util.ArrayList;
 import java.util.HashMap;
+import java.util.List;
 import java.util.Map;
 
 /**
@@ -86,4 +90,46 @@
         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);
+            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;
+    }
+
 }

--
Gitblit v1.8.0