MrShi
2026-04-03 699bdb5b821e87859f5900e4db1d1a2353c6f6a2
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.doumee.service.business.impl;
 
import com.doumee.core.constants.ResponseStatus;
import com.doumee.core.exception.BusinessException;
import com.doumee.core.model.LoginUserInfo;
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
import com.doumee.core.utils.Constants;
import com.doumee.core.utils.DateUtil;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.YwElectricalMapper;
import com.doumee.dao.business.model.YwElectrical;
import com.doumee.dao.business.model.YwGateway;
import com.doumee.service.business.YwElectricalService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.github.yulichang.wrapper.MPJLambdaWrapper;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;
 
import java.util.Date;
import java.util.List;
import java.util.Objects;
 
/**
 * 电表设备信息Service实现
 * @author renkang
 * @date 2026/04/03
 */
@Service
public class YwElectricalServiceImpl implements YwElectricalService {
 
    @Autowired
    private YwElectricalMapper ywElectricalMapper;
 
    @Override
    public Integer create(YwElectrical ywElectrical) {
        if (Objects.isNull(ywElectrical)
                || StringUtils.isBlank(ywElectrical.getName())
                || StringUtils.isBlank(ywElectrical.getCode())) {
            throw new BusinessException(ResponseStatus.BAD_REQUEST);
        }
        LoginUserInfo loginUserInfo = ywElectrical.getLoginUserInfo();
        // 校验表号唯一
        if (ywElectricalMapper.selectCount(new QueryWrapper<YwElectrical>().lambda()
                .eq(YwElectrical::getIsdeleted, Constants.ZERO)
                .eq(YwElectrical::getCode, ywElectrical.getCode())) > Constants.ZERO) {
            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "表号重复!");
        }
        ywElectrical.setCreateDate(new Date());
        ywElectrical.setCreator(loginUserInfo.getId());
        ywElectrical.setEditDate(new Date());
        ywElectrical.setEditor(loginUserInfo.getId());
        ywElectrical.setIsdeleted(Constants.ZERO);
        ywElectricalMapper.insert(ywElectrical);
        return ywElectrical.getId();
    }
 
    @Override
    public void deleteById(Integer id, LoginUserInfo user) {
        ywElectricalMapper.update(new UpdateWrapper<YwElectrical>()
                .lambda()
                .set(YwElectrical::getIsdeleted, Constants.ONE)
                .set(YwElectrical::getEditDate, DateUtil.getCurrDateTime())
                .set(YwElectrical::getEditor, user.getId())
                .eq(YwElectrical::getId, id)
        );
    }
 
    @Override
    public void deleteByIdInBatch(List<Integer> ids, LoginUserInfo user) {
        if (CollectionUtils.isEmpty(ids)) {
            return;
        }
        for (Integer id : ids) {
            this.deleteById(id, user);
        }
    }
 
    @Override
    public void updateById(YwElectrical ywElectrical) {
        if (Objects.isNull(ywElectrical)
                || Objects.isNull(ywElectrical.getId())
                || StringUtils.isBlank(ywElectrical.getName())
                || StringUtils.isBlank(ywElectrical.getCode())) {
            throw new BusinessException(ResponseStatus.BAD_REQUEST);
        }
        LoginUserInfo loginUserInfo = ywElectrical.getLoginUserInfo();
        // 校验表号唯一(排除自身)
        if (ywElectricalMapper.selectCount(new QueryWrapper<YwElectrical>().lambda()
                .eq(YwElectrical::getIsdeleted, Constants.ZERO)
                .eq(YwElectrical::getCode, ywElectrical.getCode())
                .ne(YwElectrical::getId, ywElectrical.getId())) > Constants.ZERO) {
            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "表号重复!");
        }
        ywElectrical.setEditDate(new Date());
        ywElectrical.setEditor(loginUserInfo.getId());
        ywElectricalMapper.updateById(ywElectrical);
    }
 
    @Override
    public YwElectrical findById(Integer id) {
        return ywElectricalMapper.selectJoinOne(YwElectrical.class,
                new MPJLambdaWrapper<YwElectrical>()
                        .selectAll(YwElectrical.class)
                        .selectAs(YwGateway::getName, YwElectrical::getGatewayName)
                        .leftJoin(YwGateway.class, YwGateway::getId, YwElectrical::getGatewayId)
                        .eq(YwElectrical::getId, id)
                        .last(" limit 1 ")
        );
    }
 
    @Override
    public PageData<YwElectrical> findPage(PageWrap<YwElectrical> pageWrap) {
        IPage<YwElectrical> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
        MPJLambdaWrapper<YwElectrical> queryWrapper = new MPJLambdaWrapper<>();
        Utils.MP.blankToNull(pageWrap.getModel());
        YwElectrical model = pageWrap.getModel();
        queryWrapper.selectAll(YwElectrical.class)
                .selectAs(YwGateway::getName, YwElectrical::getGatewayName)
                .leftJoin(YwGateway.class, YwGateway::getId, YwElectrical::getGatewayId)
                .and(Objects.nonNull(model) && StringUtils.isNotBlank(model.getName()),
                        i -> i.like(YwElectrical::getName, model.getName())
                             .or()
                             .like(YwElectrical::getCode, model.getName()))
                .eq(Objects.nonNull(model) && Objects.nonNull(model.getRunStatus()), YwElectrical::getRunStatus, model.getRunStatus())
                .eq(Objects.nonNull(model) && Objects.nonNull(model.getGatewayId()), YwElectrical::getGatewayId, model.getGatewayId())
                .eq(YwElectrical::getIsdeleted, Constants.ZERO)
                .orderByDesc(YwElectrical::getCreateDate);
        IPage<YwElectrical> iPage = ywElectricalMapper.selectJoinPage(page, YwElectrical.class, queryWrapper);
        return PageData.from(iPage);
    }
}