device_adjust_value查询接口

lizijie

2021-06-15 d4dc39493e7427b86861e73b26ad436d61885ec8

device_adjust_value查询接口

 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());
    }

}

 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);

}

 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;
    }

}