fix：sql查询时间调整

cjl

2025-01-06 8490eb11583ffdc586436f165860de5cfc39f915

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
package com.moral.api.controller;
 
import com.moral.api.entity.DeviceAdjustValue;
import com.moral.api.pojo.form.adjust.AdjustForm;
import com.moral.api.service.DeviceAdjustValueService;
import com.moral.constant.ResponseCodeEnum;
import com.moral.constant.ResultMessage;
import com.moral.util.WebUtils;
import io.swagger.annotations.Api;
import lombok.extern.slf4j.Slf4j;
import org.springframework.util.ObjectUtils;
import org.springframework.web.bind.annotation.*;
 
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.List;
import java.util.Map;
 
@Slf4j
@Api(tags = {"校准值"})
@RestController
@RequestMapping("/deviceAdjustValue")
public class DeviceAdjustValueController {
 
    @Resource
    private DeviceAdjustValueService deviceAdjustValueService;
 
    @RequestMapping(value = "insertOneDeviceAdjustValue", method = RequestMethod.POST)
    @ResponseBody
    public ResultMessage insertOneDeviceAdjustValue(@RequestBody DeviceAdjustValue deviceAdjustValue) {
        //DeviceAdjustValue deviceAdjustValue = JSON.parseObject(JSON.toJSONString(parameters), DeviceAdjustValue.class);
        Map<String,Object> resultMap = deviceAdjustValueService.insertOne(deviceAdjustValue);
        String msg = resultMap.get("msg").toString();
        int code = Integer.parseInt(resultMap.get("code").toString());
        if (code == 0){
            return ResultMessage.ok(msg);
        }
        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());
    }
 
    @RequestMapping(value = "getTimeSlot", method = RequestMethod.GET)
    @ResponseBody
    public ResultMessage getTimeSlot(HttpServletRequest request) {
        Map<String,Object> parameters = WebUtils.getParametersStartingWith(request,null);
        Map<String,Object> resultMap = deviceAdjustValueService.getTimeSlot(parameters);
        if (!resultMap.containsKey("code")){
            return ResultMessage.ok(resultMap);
        }
        return ResultMessage.fail(Integer.parseInt(resultMap.get("code").toString()),resultMap.get("msg").toString());
    }
 
    @RequestMapping(value = "updateOneDeviceAdjustValue", method = RequestMethod.POST)
    @ResponseBody
    public ResultMessage updateOneDeviceAdjustValue(@RequestBody Map<String, Object> parameters) {
        Map<String,Object> resultMap = deviceAdjustValueService.updateOne(parameters);
        String msg = resultMap.get("msg").toString();
        int code = Integer.parseInt(resultMap.get("code").toString());
        if (code == 0){
            return ResultMessage.ok(msg);
        }
        return ResultMessage.fail(Integer.parseInt(resultMap.get("code").toString()),resultMap.get("msg").toString());
    }
 
    @RequestMapping(value = "deleteOneDeviceAdjustValue", method = RequestMethod.POST)
    @ResponseBody
    public ResultMessage deleteOneDeviceAdjustValue(@RequestBody Map<String, Object> parameters) {
        Map<String,Object> resultMap = deviceAdjustValueService.deleteOne(parameters);
        String msg = resultMap.get("msg").toString();
        int code = Integer.parseInt(resultMap.get("code").toString());
        if (code == 0){
            return ResultMessage.ok(msg);
        }
        return ResultMessage.fail(Integer.parseInt(resultMap.get("code").toString()),resultMap.get("msg").toString());
    }
 
    @RequestMapping(value = "refreshRedis", method = RequestMethod.POST)
    @ResponseBody
    public ResultMessage refreshRedis() {
        Map<String,Object> resultMap = deviceAdjustValueService.refreshRedis();
        String msg = resultMap.get("msg").toString();
        int code = Integer.parseInt(resultMap.get("code").toString());
        if (code == 0){
            return ResultMessage.ok(msg);
        }
        return ResultMessage.fail(Integer.parseInt(resultMap.get("code").toString()),resultMap.get("msg").toString());
    }
 
    /**
     * 批量查询校准值
     * @param parameters
     * @return
     */
    @PostMapping("getAllAdjust")
    public ResultMessage getAllAdjust(@RequestBody Map<String, Object> parameters){
        if (!parameters.containsKey("id")|| !parameters.containsKey("code")){
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(),
                    ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
        }
        List<Map<String, Object>> allAdjust = deviceAdjustValueService.getAllAdjust(parameters);
        if (ObjectUtils.isEmpty(allAdjust)){
            return ResultMessage.fail(ResponseCodeEnum.TARGET_IS_NULL.getCode(),
                    ResponseCodeEnum.TARGET_IS_NULL.getMsg());
        }
        return ResultMessage.ok(allAdjust);
    }
 
    /**
     * 批量修改校准值
     * @return
     */
    @PostMapping("updateAllAdjust")
    public ResultMessage updateAllAdjust( @RequestBody Map<String, List<AdjustForm>> parameters){
        List<AdjustForm> o = parameters.get("AdjustForm");
        if (ObjectUtils.isEmpty(o)){
            return ResultMessage.fail(ResponseCodeEnum.TARGET_IS_NULL.getCode(),
                    ResponseCodeEnum.TARGET_IS_NULL.getMsg());
        }
        Map<String, Object> map = deviceAdjustValueService.updateAllAdjust(o);
        int code = Integer.parseInt(map.get("code").toString());
        if (code != 0){
            return ResultMessage.fail(ResponseCodeEnum.FAIL.getCode(),ResponseCodeEnum.FAIL.getMsg());
        }
        return ResultMessage.fail(ResponseCodeEnum.SUCCESS.getCode(),ResponseCodeEnum.SUCCESS.getMsg());
 
//        return ResultMessage.ok(map);
    }
 
 
}