2 天以前 684e4306a08feeae188070f264148e6765da8dcf
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
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
package com.ruoyi.outsourcing.service.impl;
 
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.account.mapper.PaymentRecordMapper;
import com.ruoyi.account.pojo.PaymentRecord;
import com.ruoyi.basic.enums.ApplicationTypeEnum;
import com.ruoyi.basic.enums.RecordTypeEnum;
import com.ruoyi.basic.utils.FileUtil;
import com.ruoyi.common.exception.ServiceException;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.outsourcing.dto.OutsourcingPartnerDto;
import com.ruoyi.outsourcing.excel.OutsourcingPartnerExcelDto;
import com.ruoyi.outsourcing.mapper.OutsourcingPartnerMapper;
import com.ruoyi.outsourcing.mapper.OutsourcingOrderMapper;
import com.ruoyi.outsourcing.pojo.OutsourcingOrder;
import com.ruoyi.outsourcing.pojo.OutsourcingPartner;
import com.ruoyi.outsourcing.service.IOutsourcingPartnerService;
import com.ruoyi.outsourcing.vo.OutsourcingPartnerTransactionsDetailsVo;
import com.ruoyi.outsourcing.vo.OutsourcingPartnerTransactionsVo;
import com.ruoyi.outsourcing.vo.OutsourcingPartnerVo;
import jakarta.servlet.http.HttpServletResponse;
import lombok.RequiredArgsConstructor;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;
import org.springframework.web.multipart.MultipartFile;
 
import java.time.LocalDate;
import java.util.List;
import java.util.stream.Collectors;
 
/**
 * 委外合作商档案 Service 实现
 */
@Service
@RequiredArgsConstructor
public class OutsourcingPartnerServiceImpl extends ServiceImpl<OutsourcingPartnerMapper, OutsourcingPartner>
        implements IOutsourcingPartnerService {
 
    private final OutsourcingPartnerMapper partnerMapper;
    private final OutsourcingOrderMapper outsourcingOrderMapper;
    private final PaymentRecordMapper paymentRecordMapper;
    private final FileUtil fileUtil;
 
    @Override
    @Transactional(rollbackFor = Exception.class)
    public Long savePartner(OutsourcingPartnerDto dto) {
        if (dto.getPartnerName() == null || dto.getPartnerName().trim().isEmpty()) {
            throw new ServiceException("请填写合作商名称");
        }
        checkPartnerNameDuplicate(dto.getPartnerName(), null);
 
        OutsourcingPartner partner = new OutsourcingPartner();
        BeanUtils.copyProperties(dto, partner);
        partner.setId(null);
        partner.setTenantId(null);
        partner.setDeptId(null);
        partner.setCreateUser(null);
        partner.setCreateTime(null);
        partner.setUpdateTime(null);
        if (partner.getMaintainTime() == null) {
            partner.setMaintainTime(LocalDate.now());
        }
        if (partner.getMaintainUserId() == null) {
            partner.setMaintainUserId(SecurityUtils.getUserId());
        }
        partnerMapper.insert(partner);
 
        fileUtil.saveStorageAttachment(ApplicationTypeEnum.FILE, RecordTypeEnum.OUTSOURCING_PARTNER,
                partner.getId(), dto.getStorageBlobDTOS());
        return partner.getId();
    }
 
    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean updatePartner(OutsourcingPartnerDto dto) {
        if (dto.getId() == null) {
            throw new ServiceException("合作商id不能为空");
        }
        if (partnerMapper.selectById(dto.getId()) == null) {
            throw new ServiceException("合作商不存在");
        }
        checkPartnerNameDuplicate(dto.getPartnerName(), dto.getId());
 
        OutsourcingPartner partner = new OutsourcingPartner();
        BeanUtils.copyProperties(dto, partner);
        // 租户、创建信息由系统维护,置空后 MyBatis-Plus 不会更新这些列
        partner.setTenantId(null);
        partner.setDeptId(null);
        partner.setCreateUser(null);
        partner.setCreateTime(null);
        partner.setUpdateTime(null);
        boolean updated = partnerMapper.updateById(partner) > 0;
 
        if (updated) {
            fileUtil.saveStorageAttachment(ApplicationTypeEnum.FILE, RecordTypeEnum.OUTSOURCING_PARTNER,
                    dto.getId(), dto.getStorageBlobDTOS());
        }
        return updated;
    }
 
    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean delPartner(List<Long> ids) {
        if (CollectionUtils.isEmpty(ids)) {
            throw new ServiceException("请选择至少一条数据");
        }
        Long orderCount = outsourcingOrderMapper.selectCount(Wrappers.<OutsourcingOrder>lambdaQuery()
                .in(OutsourcingOrder::getPartnerId, ids));
        if (orderCount != null && orderCount > 0) {
            throw new ServiceException("合作商已存在委外订单,不允许删除");
        }
        Long paymentCount = paymentRecordMapper.selectCount(Wrappers.<PaymentRecord>lambdaQuery()
                .eq(PaymentRecord::getPartyType, 3)
                .in(PaymentRecord::getPartyId, ids));
        if (paymentCount != null && paymentCount > 0) {
            throw new ServiceException("合作商已存在往来收付款记录,不允许删除");
        }
 
        fileUtil.deleteStorageAttachmentsByApplicationAndRecordTypeAndRecordIds(
                ApplicationTypeEnum.FILE, RecordTypeEnum.OUTSOURCING_PARTNER, ids);
        return this.removeByIds(ids);
    }
 
    @Override
    public OutsourcingPartnerVo partnerDetail(Long id) {
        OutsourcingPartner partner = partnerMapper.selectById(id);
        if (partner == null) {
            throw new ServiceException("合作商不存在");
        }
        OutsourcingPartnerVo vo = new OutsourcingPartnerVo();
        BeanUtils.copyProperties(partner, vo);
        vo.setStorageBlobVOS(fileUtil.getStorageBlobVOsByApplicationAndRecordTypeAndRecordId(
                ApplicationTypeEnum.FILE, RecordTypeEnum.OUTSOURCING_PARTNER, id));
        return vo;
    }
 
    @Override
    public IPage<OutsourcingPartnerDto> partnerListPage(Page page, OutsourcingPartnerDto dto) {
        return partnerMapper.partnerListPage(page, dto);
    }
 
    @Override
    public void partnerExport(HttpServletResponse response, OutsourcingPartnerDto dto) {
        List<OutsourcingPartnerExcelDto> list = partnerMapper.partnerExportList(dto);
        ExcelUtil<OutsourcingPartnerExcelDto> util = new ExcelUtil<>(OutsourcingPartnerExcelDto.class);
        util.exportExcel(response, list, "合作商档案");
    }
 
    @Override
    public Boolean importData(MultipartFile file) {
        try {
            ExcelUtil<OutsourcingPartnerExcelDto> util = new ExcelUtil<>(OutsourcingPartnerExcelDto.class);
            List<OutsourcingPartnerExcelDto> list = util.importExcel(file.getInputStream());
            if (CollectionUtils.isEmpty(list)) {
                return false;
            }
            List<OutsourcingPartner> partners = list.stream().map(excel -> {
                OutsourcingPartner partner = new OutsourcingPartner();
                BeanUtils.copyProperties(excel, partner);
                partner.setMaintainUserId(SecurityUtils.getUserId());
                partner.setMaintainTime(LocalDate.now());
                return partner;
            }).collect(Collectors.toList());
            return this.saveOrUpdateBatch(partners);
        } catch (Exception e) {
            throw new ServiceException("合作商导入失败:" + e.getMessage());
        }
    }
 
    @Override
    public List<OutsourcingPartner> options() {
        return partnerMapper.selectList(new LambdaQueryWrapper<OutsourcingPartner>()
                .select(OutsourcingPartner::getId, OutsourcingPartner::getPartnerName)
                .orderByDesc(OutsourcingPartner::getId));
    }
 
    @Override
    public IPage<OutsourcingPartnerTransactionsVo> partnerTransactions(Page page, String partnerName) {
        return partnerMapper.partnerTransactions(page, partnerName);
    }
 
    @Override
    public IPage<OutsourcingPartnerTransactionsDetailsVo> partnerTransactionsDetails(Page page, Long partnerId) {
        return partnerMapper.partnerTransactionsDetails(page, partnerId);
    }
 
    /**
     * 合作商名称在租户内唯一
     */
    private void checkPartnerNameDuplicate(String partnerName, Long excludeId) {
        if (partnerName == null || partnerName.trim().isEmpty()) {
            return;
        }
        Long tenantId = SecurityUtils.getLoginUser().getTenantId();
        LambdaQueryWrapper<OutsourcingPartner> wrapper = Wrappers.<OutsourcingPartner>lambdaQuery()
                .eq(tenantId != null, OutsourcingPartner::getTenantId, tenantId)
                .isNull(tenantId == null, OutsourcingPartner::getTenantId)
                .eq(OutsourcingPartner::getPartnerName, partnerName)
                .ne(excludeId != null, OutsourcingPartner::getId, excludeId);
        if (partnerMapper.selectCount(wrapper) > 0) {
            throw new ServiceException("合作商已存在");
        }
    }
}