龚焕茏
2024-03-21 e17e3b7f70fa5abc8341e64f1ffce5813bae4bc3
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
package org.dromara.demo.service.impl;
 
import cn.hutool.core.date.DateUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import lombok.RequiredArgsConstructor;
import org.dromara.common.core.utils.MapstructUtils;
import org.dromara.common.core.utils.StringUtils;
import org.dromara.common.mybatis.core.page.PageQuery;
import org.dromara.common.mybatis.core.page.TableDataInfo;
import org.dromara.demo.domain.RsDangerTotal;
import org.dromara.demo.domain.bo.RsDangerTotalBo;
import org.dromara.demo.domain.vo.RsDangerTotalVo;
import org.dromara.demo.mapper.RsDangerTotalMapper;
import org.dromara.demo.service.IRsDangerTotalService;
import org.springframework.stereotype.Service;
 
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.util.Collection;
import java.util.Date;
import java.util.List;
import java.util.Map;
 
/**
 * 安全隐患统计Service业务层处理
 *
 * @author gonghl
 * @date 2024-02-29
 */
@RequiredArgsConstructor
@Service
public class RsDangerTotalServiceImpl implements IRsDangerTotalService {
 
    private final RsDangerTotalMapper baseMapper;
 
    /**
     * 查询安全隐患统计
     */
    @Override
    public RsDangerTotalVo queryById(String id){
        return baseMapper.selectVoById(id);
    }
 
    /**
     * 查询安全隐患统计列表
     */
    @Override
    public TableDataInfo<RsDangerTotalVo> queryPageList(RsDangerTotalBo bo, PageQuery pageQuery) {
        LambdaQueryWrapper<RsDangerTotal> lqw = buildQueryWrapper(bo);
        Page<RsDangerTotalVo> result = baseMapper.selectVoPage(pageQuery.build(), lqw);
        return TableDataInfo.build(result);
    }
 
    /**
     * 查询安全隐患统计列表
     */
    @Override
    public List<RsDangerTotalVo> queryList(RsDangerTotalBo bo) {
        LambdaQueryWrapper<RsDangerTotal> lqw = buildQueryWrapper(bo);
        return baseMapper.selectVoList(lqw);
    }
 
    private LambdaQueryWrapper<RsDangerTotal> buildQueryWrapper(RsDangerTotalBo bo) {
        Map<String, Object> params = bo.getParams();
        LambdaQueryWrapper<RsDangerTotal> lqw = Wrappers.lambdaQuery();
        lqw.like(StringUtils.isNotBlank(bo.getTownStreetName()), RsDangerTotal::getTownStreetName, bo.getTownStreetName());
        lqw.eq(bo.getPeriod() != null, RsDangerTotal::getPeriod, bo.getPeriod());
        lqw.eq(StringUtils.isNotBlank(bo.getPeriodDate()), RsDangerTotal::getPeriodDate, bo.getPeriodDate());
        lqw.eq(bo.getFindSecurityRisks() != null, RsDangerTotal::getFindSecurityRisks, bo.getFindSecurityRisks());
        lqw.eq(bo.getIssueNotice() != null, RsDangerTotal::getIssueNotice, bo.getIssueNotice());
        lqw.eq(bo.getDealWithSecurityRisks() != null, RsDangerTotal::getDealWithSecurityRisks, bo.getDealWithSecurityRisks());
        lqw.eq(bo.getStatus() != null, RsDangerTotal::getStatus, bo.getStatus());
        lqw.orderByDesc(RsDangerTotal::getCreateTime);
        return lqw;
    }
 
    /**
     * 新增安全隐患统计
     */
    @Override
    public Boolean insertByBo(RsDangerTotalBo bo) {
        RsDangerTotal add = MapstructUtils.convert(bo, RsDangerTotal.class);
        validEntityBeforeSave(add);
        boolean flag = baseMapper.insert(add) > 0;
        if (flag) {
            bo.setId(add.getId());
        }
        return flag;
    }
 
    /**
     * 修改安全隐患统计
     */
    @Override
    public Boolean updateByBo(RsDangerTotalBo bo) {
        RsDangerTotal update = MapstructUtils.convert(bo, RsDangerTotal.class);
        return baseMapper.updateById(update) > 0;
    }
 
    /**
     * 保存前的数据校验
     */
    private void validEntityBeforeSave(RsDangerTotal entity){
        // 创建时间
        if (entity.getCreateTime() == null) {
            entity.setCreateTime(new Date());
        }
    }
 
    /**
     * 批量删除安全隐患统计
     */
    @Override
    public Boolean deleteWithValidByIds(Collection<String> ids, Boolean isValid) {
        if(isValid){
            //TODO 做一些业务上的校验,判断是否需要校验
        }
        return baseMapper.deleteBatchIds(ids) > 0;
    }
 
    @Override
    public String importExcel(List<RsDangerTotal> list) {
        for (RsDangerTotal dangerTotal : list) {
            dangerTotal.setPeriod(dangerTotal.getPeriodDate().length() > 4 ? 1L : 2L);
            dangerTotal.setCreateTime(new Date());
            dangerTotal.setStatus(2L);
        }
        return baseMapper.insertBatch(list) ? "恭喜您,数据已全部导入成功!共"  + list.size() + "条!" : "很抱歉,导入失败!请检查数据格式!";
    }
}