zhongrj
2024-11-13 288b3680bb69d0931fa7503b09b920832d73a1ac
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
package org.springblade.modules.yw.service.impl;
 
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.apache.logging.log4j.util.Strings;
import org.springblade.core.tool.utils.BeanUtil;
import org.springblade.modules.yw.entity.FacilityEntity;
import org.springblade.modules.yw.entity.FirmInfo;
import org.springblade.modules.yw.excel.FacilityExcel;
import org.springblade.modules.yw.service.IFirmInfoService;
import org.springblade.modules.yw.vo.FacilityVO;
import org.springblade.modules.yw.mapper.FacilityMapper;
import org.springblade.modules.yw.service.IFacilityService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
import java.util.Objects;
 
/**
 * 设施表 服务实现类
 *
 * @author BladeX
 * @since 2024-11-13
 */
@Service
public class FacilityServiceImpl extends ServiceImpl<FacilityMapper, FacilityEntity> implements IFacilityService {
 
    @Autowired
    private IFirmInfoService firmInfoService;
 
    /**
     * 自定义分页查询
     * @param page
     * @param facility
     * @return
     */
    @Override
    public IPage<FacilityVO> selectFacilityPage(IPage<FacilityVO> page, FacilityVO facility) {
        return page.setRecords(baseMapper.selectFacilityPage(page, facility));
    }
 
    /**
     * 导入设施信息
     * @param data
     * @param isCovered
     * @return
     */
    @Override
    public String importFacility(List<FacilityExcel> data, boolean isCovered) {
        for (FacilityExcel facilityExcel : data) {
            // 拷贝数据
            FacilityEntity facilityEntity = Objects.requireNonNull(BeanUtil.copy(facilityExcel, FacilityEntity.class));
            // 设置防线类型
            if(!Strings.isBlank(facilityExcel.getFacLevel())){
                facilityEntity.setFacLevel(Integer.parseInt(facilityExcel.getFacLevel()));
            }
            // 设置企业id
            setFirm(facilityExcel,facilityEntity);
            // 判断是否已保存
            Long id = isSave(facilityEntity);
            // 覆盖更新
            if (null!=id){
                facilityEntity.setId(id);
                updateById(facilityEntity);
                continue;
            }
            // 保存
            save(facilityEntity);
        }
        return null;
    }
 
 
    /**
     * 判断是否保存入库
     * @param facilityEntity
     * @return
     */
    private Long isSave(FacilityEntity facilityEntity) {
        QueryWrapper<FacilityEntity> wrapper = new QueryWrapper<>();
        wrapper.eq("name",facilityEntity.getName())
            .eq("firm_id",facilityEntity.getFirmId())
            .eq("is_deleted",0);
        FacilityEntity one = getOne(wrapper);
        if (null!=one){
            return one.getId();
        }
        return null;
    }
 
    /**
     * 设置企业信息
     * @param firmExcel
     * @param facilityEntity
     */
    private void setFirm(FacilityExcel firmExcel,FacilityEntity facilityEntity) {
        QueryWrapper<FirmInfo> wrapper = new QueryWrapper<>();
        wrapper.eq("name",firmExcel.getFirmName())
            .eq("is_deleted",0);
        FirmInfo firmInfo = firmInfoService.getOne(wrapper);
        if (null!=firmInfo){
            facilityEntity.setFirmId(firmInfo.getId());
        }
    }
}