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
package com.moral.api.controller;
 
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
import com.moral.api.entity.Organization;
import com.moral.api.entity.ServicesScope;
import com.moral.api.mapper.OrganizationMapper;
import com.moral.api.pojo.form.ServiceScope.AddBoundaryBindDevice;
import com.moral.api.service.OrganizationService;
import com.moral.api.service.ServicesScopeService;
import com.moral.constant.Constants;
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.web.bind.annotation.*;
 
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.Map;
 
/**
 * @program: screen
 * @description: 服务范围
 * @author: lizijie
 * @create: 2022-01-12 15:42
 **/
@Slf4j
@Api(tags = {"服务范围"})
@RestController
@RequestMapping("/servicesScope")
public class ServicesScopeController {
 
    @Resource
    private OrganizationMapper organizationMapper;
 
    @Resource
    private OrganizationService organizationService;
 
    @Resource
    private ServicesScopeService servicesScopeService;
 
    @RequestMapping(value = "getDataByCondition", method = RequestMethod.GET)
    @ResponseBody
    public ResultMessage getDataByCondition(HttpServletRequest request){
        Map<String, Object> parameters = WebUtils.getParametersStartingWith(request,null);
        Object size = parameters.get("size");
        Object current = parameters.get("current");
        if (ObjectUtils.isEmpty(size) || ObjectUtils.isEmpty(current)){
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
        }
        Map<String, Object> resultMap = servicesScopeService.getDataByCondition(parameters);
        return ResultMessage.ok(resultMap);
    }
 
    @RequestMapping(value = "insert",method = RequestMethod.POST)
    @ResponseBody
    public ResultMessage insert(@RequestBody ServicesScope servicesScope){
        if (ObjectUtils.isEmpty(servicesScope.getName()) || ObjectUtils.isEmpty(servicesScope.getOrganizationId())){
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
        }
        QueryWrapper<Organization> organizationQueryWrapper = new QueryWrapper<>();
        organizationQueryWrapper.eq("id",servicesScope.getOrganizationId()).eq("is_delete",Constants.NOT_DELETE);
        Organization organization = organizationService.getOne(organizationQueryWrapper);
        if (ObjectUtils.isEmpty(organization)){
            return ResultMessage.fail(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getCode(), ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getMsg());
        }
        servicesScopeService.insert(servicesScope);
        return ResultMessage.ok();
    }
 
    @RequestMapping(value = "update",method = RequestMethod.POST)
    @ResponseBody
    public ResultMessage update(@RequestBody ServicesScope servicesScope){
        if (ObjectUtils.isEmpty(servicesScope.getId())){
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
        }
        QueryWrapper<ServicesScope> servicesScopeQueryWrapper = new QueryWrapper<>();
        servicesScopeQueryWrapper.eq("id",servicesScope.getId()).eq("is_delete",Constants.NOT_DELETE);
        ServicesScope servicesScopeRes = servicesScopeService.getOne(servicesScopeQueryWrapper);
        if (ObjectUtils.isEmpty(servicesScopeRes)){
            return ResultMessage.fail(ResponseCodeEnum.SERVICES_SCOPE_IS_NOT_EXIST.getCode(), ResponseCodeEnum.SERVICES_SCOPE_IS_NOT_EXIST.getMsg());
        }
        if (!ObjectUtils.isEmpty(servicesScope.getOrganizationId())){
            QueryWrapper<Organization> organizationQueryWrapper = new QueryWrapper<>();
            organizationQueryWrapper.eq("id",servicesScope.getOrganizationId()).eq("is_delete",Constants.NOT_DELETE);
            Organization organization = organizationService.getOne(organizationQueryWrapper);
            if (ObjectUtils.isEmpty(organization)){
                return ResultMessage.fail(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getCode(), ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getMsg());
            }
        }
        servicesScopeService.update(servicesScope);
        return ResultMessage.ok();
    }
 
    @RequestMapping(value = "delete",method = RequestMethod.POST)
    @ResponseBody
    public ResultMessage delete(@RequestBody Map map){
        if (ObjectUtils.isEmpty(map.get("id"))){
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
        }
        QueryWrapper<ServicesScope> servicesScopeQueryWrapper = new QueryWrapper<>();
        servicesScopeQueryWrapper.eq("id",Integer.parseInt(map.get("id").toString())).eq("is_delete",Constants.NOT_DELETE);
        ServicesScope servicesScopeRes = servicesScopeService.getOne(servicesScopeQueryWrapper);
        if (ObjectUtils.isEmpty(servicesScopeRes)){
            return ResultMessage.fail(ResponseCodeEnum.SERVICES_SCOPE_IS_NOT_EXIST.getCode(), ResponseCodeEnum.SERVICES_SCOPE_IS_NOT_EXIST.getMsg());
        }
        servicesScopeService.delete(Integer.parseInt(map.get("id").toString()));
        return ResultMessage.ok();
    }
 
    @RequestMapping(value = "addBoundaryBindDevice",method = RequestMethod.POST)
    @ResponseBody
    public ResultMessage addBoundaryBindDevice(@RequestBody AddBoundaryBindDevice addBoundaryBindDevice){
        if (ObjectUtils.isEmpty(addBoundaryBindDevice)){
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
        }
        QueryWrapper<ServicesScope> servicesScopeQueryWrapper = new QueryWrapper<>();
        servicesScopeQueryWrapper.eq("id",addBoundaryBindDevice.getServicesScope().getId()).eq("is_delete",Constants.NOT_DELETE);
        ServicesScope servicesScopeRes = servicesScopeService.getOne(servicesScopeQueryWrapper);
        if (ObjectUtils.isEmpty(servicesScopeRes)){
            return ResultMessage.fail(ResponseCodeEnum.SERVICES_SCOPE_IS_NOT_EXIST.getCode(), ResponseCodeEnum.SERVICES_SCOPE_IS_NOT_EXIST.getMsg());
        }
        /*if (!ObjectUtils.isEmpty(addBoundaryBindDevice.getServicesScope().getOrganizationId())){
            QueryWrapper<Organization> organizationQueryWrapper = new QueryWrapper<>();
            organizationQueryWrapper.eq("id",addBoundaryBindDevice.getServicesScope().getOrganizationId()).eq("is_delete",Constants.NOT_DELETE);
            Organization organization = organizationService.getOne(organizationQueryWrapper);
            if (ObjectUtils.isEmpty(organization)){
                return ResultMessage.fail(ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getCode(), ResponseCodeEnum.ORGANIZATION_NOT_EXIST.getMsg());
            }
        }*/
        servicesScopeService.addBoundaryBindDevice(addBoundaryBindDevice);
        return ResultMessage.ok();
    }
 
}