Blame view

src/main/java/com/huaheng/api/general/service/ReceiptApiService.java 20.9 KB
pengcheng authored
1
2
package com.huaheng.api.general.service;
pengcheng authored
3
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
pengcheng authored
4
import com.huaheng.common.utils.Wrappers;
lihailong authored
5
import com.huaheng.api.general.domain.Receipt;
pengcheng authored
6
import com.huaheng.api.general.domain.ReceiptDomain;
7
import com.huaheng.common.constant.QuantityConstant;
pengcheng authored
8
import com.huaheng.common.exception.service.ServiceException;
9
import com.huaheng.common.utils.DataUtils;
pengcheng authored
10
import com.huaheng.common.utils.StringUtils;
11
import com.huaheng.common.utils.security.ShiroUtils;
pengcheng authored
12
import com.huaheng.framework.web.domain.AjaxResult;
pengcheng authored
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
import com.huaheng.pc.config.FilterConfigDetail.domain.FilterConfigDetail;
import com.huaheng.pc.config.FilterConfigDetail.service.FilterConfigDetailService;
import com.huaheng.pc.config.company.domain.Company;
import com.huaheng.pc.config.company.service.CompanyService;
import com.huaheng.pc.config.material.domain.Material;
import com.huaheng.pc.config.material.service.MaterialService;
import com.huaheng.pc.config.receiptType.domain.ReceiptType;
import com.huaheng.pc.config.receiptType.service.ReceiptTypeService;
import com.huaheng.pc.config.statusFlow.domain.StatusFlowHeader;
import com.huaheng.pc.config.statusFlow.service.StatusFlowHeaderService;
import com.huaheng.pc.config.supplier.domain.Supplier;
import com.huaheng.pc.config.supplier.service.SupplierService;
import com.huaheng.pc.config.warehouse.domain.Warehouse;
import com.huaheng.pc.config.warehouse.service.WarehouseService;
import com.huaheng.pc.receipt.receiptDetail.domain.ReceiptDetail;
import com.huaheng.pc.receipt.receiptDetail.service.ReceiptDetailService;
29
30
import com.huaheng.pc.receipt.receiptDetailHistory.domain.ReceiptDetailHistory;
import com.huaheng.pc.receipt.receiptDetailHistory.service.ReceiptDetailHistoryService;
pengcheng authored
31
32
import com.huaheng.pc.receipt.receiptHeader.domain.ReceiptHeader;
import com.huaheng.pc.receipt.receiptHeader.service.ReceiptHeaderService;
33
34
import com.huaheng.pc.receipt.receiptHeaderHistory.domain.ReceiptHeaderHistory;
import com.huaheng.pc.receipt.receiptHeaderHistory.service.ReceiptHeaderHistoryService;
35
import com.huaheng.pc.shipment.shipmentContainerDetail.domain.ShipmentContainerDetail;
pengcheng authored
36
37
38
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;
pengcheng authored
39
40
import javax.annotation.Resource;
import java.math.BigDecimal;
41
import java.util.ArrayList;
pengcheng authored
42
import java.util.List;
43
import java.util.stream.Collectors;
pengcheng authored
44
pengcheng authored
45
46
47
@Component
@Transactional
public class ReceiptApiService {
pengcheng authored
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
    @Resource
    private ReceiptHeaderService receiptHeaderService;
    @Resource
    private ReceiptDetailService receiptDetailService;
    @Resource
    private ReceiptTypeService receiptTypeService;
    @Resource
    private WarehouseService warehouseService;
    @Resource
    private CompanyService companyService;
    @Resource
    private MaterialService materialService;
    @Resource
    private SupplierService supplierService;
    @Resource
    private FilterConfigDetailService filterConfigDetailService;
    @Resource
    private StatusFlowHeaderService statusFlowHeaderService;
66
67
68
69
    @Resource
    private ReceiptHeaderHistoryService receiptHeaderHistoryService;
    @Resource
    private ReceiptDetailHistoryService receiptDetailHistoryService;
lector authored
70
pengcheng authored
71
72
    /**
     * 入库单下发
lector authored
73
     *
pengcheng authored
74
75
76
77
     * @param receipt 入库单
     * @return 是否下发成功
     */
    @Transactional(rollbackFor = Exception.class)
lector authored
78
    public AjaxResult receipt(ReceiptDomain receipt) {
pengcheng authored
79
80
81
82
83

        /* 0.step 获取入库头表,获取入库明细*/
        ReceiptHeader receiptHeader = receipt.getReceiptHeader();
        List<ReceiptDetail> receiptDetails = receipt.getReceiptDetails();
        /* 1.step 校验入库单是否为空*/
游杰 authored
84
85
86
87
88
        if (receiptHeader == null || receiptDetails == null) {
            return AjaxResult.error("入库主单或入库子单为空");
        }
        if(receiptDetails.isEmpty()) {
            return AjaxResult.error("入库子单为空");
pengcheng authored
89
        }
lihailong authored
90
pengcheng authored
91
92
        /* 4.step 计算入库明细总行数、总数量*/
        BigDecimal totalQty = new BigDecimal(0);
lector authored
93
        for (ReceiptDetail receiptDetail : receiptDetails) {
lihailong authored
94
//            totalQty = totalQty.add(receiptDetail.getTotalQty());
95
            totalQty = totalQty.add(receiptDetail.getUnitId1Qty());
pengcheng authored
96
97
98
99
        }
        receiptHeader.setTotalLines(receiptDetails.size());
        receiptHeader.setTotalQty(totalQty);
100
        List<ReceiptHeader> list = receiptHeaderService.list(new LambdaQueryWrapper<ReceiptHeader>().eq(ReceiptHeader::getReferCode,receiptHeader.getReferCode()));
pengcheng authored
101
102
        //如果有重复getReferCode的单据的话
lihailong authored
103
104
105
        if(list.size()>0){
            try {
                for (ReceiptHeader header : list) {
106
                    if (header.getFirstStatus()<=QuantityConstant.RECEIPT_HEADER_RECEIVING) {
107
108
109
110
111
112
113
114
115
116
                        header.setReferCode(receiptHeader.getReferCode());
                        header.setReferId(receiptHeader.getReferId());
                        header.setReceiptType(receiptHeader.getReceiptType());
                        header.setSupplierCode(receiptHeader.getSupplierCode());
                        receiptHeaderService.updateById(header);
                        LambdaQueryWrapper<ReceiptDetail> ReceiptDetailLQM = new LambdaQueryWrapper<ReceiptDetail>().eq(ReceiptDetail::getReceiptId, header.getId());
                        receiptDetailService.remove(ReceiptDetailLQM);
                        receiptHeader = receiptHeaderService.getById(header);
                    }else {
                        return AjaxResult.error("入库单已被使用,不能覆盖了");
lihailong authored
117
118
119
120
121
122
                    }
                }
            } catch (Exception e) {
                return AjaxResult.error(e.getMessage());
            }
        }else{
123
            //没有就创建入库单
lihailong authored
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
            try {
                String receiptCode = receiptHeaderService.createCode(receiptHeader.getReceiptType());
                receiptHeader.setCode(receiptCode);
                receiptHeader.setCreatedBy(QuantityConstant.PLATFORM_ERP);
                if(receiptHeader.getCreatedBy()!=null){
                    receiptHeader.setCreatedBy(receiptHeader.getCreatedBy());
                }
                receiptHeader.setFirstStatus(QuantityConstant.RECEIPT_HEADER_RECEIVING);
                receiptHeader.setLastStatus(QuantityConstant.RECEIPT_HEADER_RECEIVING);
                /* 2.step 检查入库头表合法性*/
                AjaxResult checkReceiptHeaderResult = checkReceiptHeader(receiptHeader);
                if (checkReceiptHeaderResult.hasErr()) {
                    return AjaxResult.error(checkReceiptHeaderResult.getMsg());
                }
                /* 3.step 检查入库明细合法性*/
                AjaxResult checkReceiptDetailResult = checkReceiptDetail(receiptDetails);
                if (checkReceiptDetailResult.hasErr()) {
                    return AjaxResult.error(checkReceiptDetailResult.getMsg());
                }
                receiptHeaderService.save(receiptHeader);
            } catch (Exception e) {
                return AjaxResult.error(e.getMessage());
            }
        }
pengcheng authored
148
        /* 6.step 保存入库明细*/
149
150
151
        receiptHeader = receiptHeaderService.getOne(new LambdaQueryWrapper<ReceiptHeader>()
                .eq(ReceiptHeader::getWarehouseCode, receiptHeader.getWarehouseCode())
                .eq(ReceiptHeader::getCode, receiptHeader.getCode()));
152
153

        Supplier supplier=null;
易文鹏 authored
154
        if ("CGRKD".equals(receiptHeader.getReceiptType())){
155
            List<Supplier> list1 = supplierService.list(new LambdaQueryWrapper<Supplier>().eq(Supplier::getCode, receiptHeader.getSupplierCode()));
易文鹏 authored
156
157
            if (list1.size()<1) {
                return AjaxResult.error("WMS没有此供应商"+receiptHeader.getSupplierCode()+",请找ERP同步供应商信息");
158
159
            }
            supplier = list1.get(0);
160
        }
161
162
        List<ReceiptDetail> receiptDetailList = new ArrayList<>();
pengcheng authored
163
164
165
166
        for (ReceiptDetail receiptDetail : receiptDetails) {
            receiptDetail.setReceiptId(receiptHeader.getId());
            receiptDetail.setReceiptCode(receiptHeader.getCode());
            receiptDetail.setWarehouseCode(receiptHeader.getWarehouseCode());
游杰 authored
167
            receiptDetail.setCompanyCode(receiptHeader.getCompanyCode());
168
            receiptDetail.setSupplierCode(receiptHeader.getSupplierCode());
169
            Material material = materialService.findAllByCode(receiptDetail.getMaterialCode(), receiptHeader.getWarehouseCode());
lihailong authored
170
            if(material==null){
171
                return AjaxResult.error("找不到物料编码:"+receiptDetail.getMaterialCode());
lihailong authored
172
            }
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
            //添加 电池类型判断
//            if("1".equals(material.getIsBattery())){
                String spec = material.getSpec();
                if(spec.contains("三元")){
                    receiptDetail.setBatteryModel("三元");
                }else if(spec.contains("磷酸铁锂")){
                    receiptDetail.setBatteryModel("磷酸铁锂");
                }else if(spec.contains("锰酸锂")){
                    receiptDetail.setBatteryModel("锰酸锂");
                }else if(spec.contains("镍氢")){
                    receiptDetail.setBatteryModel("镍氢");
                }else if(spec.contains("钴酸锂")){
                    receiptDetail.setBatteryModel("钴酸锂");
                }else if(spec.contains("超级电容器")){
                    receiptDetail.setBatteryModel("超级电容器");
                }else{
                    receiptDetail.setBatteryModel("其他");
                }
//            }
192
            receiptDetail.setInventorySts("good");
193
194
            receiptDetail.setOrderNo(receiptDetail.getOrderNo());
            receiptDetail.setTotalQty(receiptDetail.getUnitId1Qty());
lihailong authored
195
196
197
198
199
            receiptDetail.setUnitId1Qty(receiptDetail.getUnitId1Qty());
            receiptDetail.setUnitId2Qty(receiptDetail.getUnitId2Qty());
            receiptDetail.setMultiple(receiptDetail.getMultiple());
            receiptDetail.setUnitId1(receiptDetail.getUnitId1());
            receiptDetail.setUnitId2(receiptDetail.getUnitId2());
pengcheng authored
200
201
202
            receiptDetail.setMaterialName(material.getName());
            receiptDetail.setMaterialSpec(material.getSpec());
            receiptDetail.setMaterialUnit(material.getUnit());
pengcheng authored
203
            receiptDetail.setMaterialIsBattery(material.getIsBattery());
204
205
            if (supplier!=null) {
                receiptDetail.setAllCreditCode(supplier.getAllCreditCode());
206
                receiptDetail.setOldBatterySource(supplier.getName());
207
            }
208
209
210
211
212
213
            //电池类才生成电池包二维码
            String batteryPackTwoCode=receiptDetailService.findBatteryPackTwoCode(receiptDetail);
            receiptDetail.setBatteryPackTwoCode(batteryPackTwoCode);
            //过磅号
            String poundCode=receiptDetailService.findPoundCode(receiptDetail);
214
            receiptDetail.setPoundCode(poundCode);
215
lector authored
216
            if (!receiptDetailService.save(receiptDetail)) {
pengcheng authored
217
218
                throw new ServiceException("保存入库明细失败");
            }
游杰 authored
219
            receiptDetailList.add(receiptDetail);
220
pengcheng authored
221
        }
游杰 authored
222
        /* 7.step回传入库单和入库明细单 */
lector authored
223
        ReceiptDomain receiptDomain = new ReceiptDomain();
224
        receiptDomain.setReceiptHeader(receiptHeader);
游杰 authored
225
        receiptDomain.setReceiptDetails(receiptDetailList);
226
        return AjaxResult.success(receiptDomain);
pengcheng authored
227
228
229
230
    }

    /**
     * 检查入库头表合法性
lector authored
231
     *
pengcheng authored
232
233
234
     * @param receiptHeader 入库头表
     * @return 检查结果
     */
lector authored
235
    private AjaxResult checkReceiptHeader(ReceiptHeader receiptHeader) {
pengcheng authored
236
237
        /* 0.step 必填项是否为空*/
        if (StringUtils.isEmpty(receiptHeader.getCode()) || StringUtils.isEmpty(receiptHeader.getCompanyCode()) ||
lector authored
238
                StringUtils.isEmpty(receiptHeader.getWarehouseCode()) || StringUtils.isEmpty(receiptHeader.getReceiptType())) {
pengcheng authored
239
240
241
242
243
            return AjaxResult.error("入库主单字段有误");
        }

        /* 1.step 查询该单据编码是否已存在*/
        LambdaQueryWrapper<ReceiptHeader> receiptHeaderLambda = Wrappers.lambdaQuery(receiptHeader);
lector authored
244
245
        if (receiptHeaderService.getOne(receiptHeaderLambda) != null) {
            return AjaxResult.error("该单据已存在:" + receiptHeader.getCode());
pengcheng authored
246
247
248
249
250
251
        }


        /* 3.step 判断仓库是否存在*/
        LambdaQueryWrapper<Warehouse> warehouseLambda = Wrappers.lambdaQuery();
        warehouseLambda.eq(Warehouse::getCode, receiptHeader.getWarehouseCode());
lector authored
252
        if (warehouseService.getOne(warehouseLambda) == null) {
pengcheng authored
253
254
255
256
257
258
            return AjaxResult.error("该仓库不存在");
        }

        /* 4.step 判断货主是否存在*/
        LambdaQueryWrapper<Company> companyLambda = Wrappers.lambdaQuery();
        companyLambda.eq(Company::getCode, receiptHeader.getCompanyCode());
lector authored
259
        if (companyService.getOne(companyLambda) == null) {
pengcheng authored
260
261
262
            return AjaxResult.error("该货主不存在");
        }
263
264
265
266
267
268
269
270
271
        /* 2.step 判断入库类型是否匹配*/
        LambdaQueryWrapper<ReceiptType> receiptTypeLambda = Wrappers.lambdaQuery();
        receiptTypeLambda.eq(ReceiptType::getCode, receiptHeader.getReceiptType())
                .eq(ReceiptType::getWarehouseCode, receiptHeader.getWarehouseCode())
                .eq(ReceiptType::getCompanyCode, receiptHeader.getCompanyCode());
        if (receiptTypeService.getOne(receiptTypeLambda) == null) {
            return AjaxResult.error("没有对应的入库单类型");
        }
pengcheng authored
272
273
274
275
276
        return AjaxResult.success("");
    }

    /**
     * 检查入库明细合法性
lector authored
277
     *
pengcheng authored
278
279
280
     * @param receiptDetails 入库明细
     * @return 检查结果
     */
lector authored
281
    private AjaxResult checkReceiptDetail(List<ReceiptDetail> receiptDetails) {
pengcheng authored
282
lector authored
283
        for (ReceiptDetail receiptDetail : receiptDetails) {
pengcheng authored
284
            /* 0.step 判断必填字段是否为空且总数量不能为0*/
285
            if (receiptDetail.getMaterialCode() == null) {
pengcheng authored
286
287
                return AjaxResult.error("入库明细字段有误");
            }
易文鹏 authored
288
289
290
291
292
//            if (new BigDecimal(0).compareTo(receiptDetail.getTotalWeight() != null ?
//                    receiptDetail.getTotalWeight() : new BigDecimal(0)) == 0 && new BigDecimal(0).compareTo(receiptDetail.getUnitId2Qty() != null ?
//                    receiptDetail.getUnitId2Qty() : new BigDecimal(0)) == 0) {
//                return AjaxResult.error("重量或数量为空");
//            }
pengcheng authored
293
294

            /* 1.step 判断供应商是否存在*/
lector authored
295
            if (receiptDetail.getSupplierCode() != null) {
pengcheng authored
296
297
298
299
300
301
302
303
                LambdaQueryWrapper<Supplier> supplierLambda = Wrappers.lambdaQuery();
                supplierLambda.eq(Supplier::getCode, receiptDetail.getSupplierCode());
                if (supplierService.getOne(supplierLambda) == null) {
                    return AjaxResult.error("供应商不存在");
                }
            }

            /* 2.step 判断定位规则是否存在*/
lector authored
304
            if (receiptDetail.getLocatingRule() != null) {
pengcheng authored
305
306
307
308
309
                LambdaQueryWrapper<FilterConfigDetail> filterConfigDetailLambda = Wrappers.lambdaQuery();
                filterConfigDetailLambda.eq(FilterConfigDetail::getCode, receiptDetail.getLocatingRule())
                        .eq(FilterConfigDetail::getModuleType, "receipt")
                        .eq(FilterConfigDetail::getRecordType, "locationRule");
                FilterConfigDetail filterConfigDetail = filterConfigDetailService.getOne(filterConfigDetailLambda);
lector authored
310
311
                if (filterConfigDetail == null) {
                    return AjaxResult.error(receiptDetail.getLocatingRule() + "定位规则不存在");
pengcheng authored
312
313
314
315
                }
            }

            /* 3.step 判断流程编码是否存在*/
lector authored
316
            if (receiptDetail.getStatusFlowCode() != null) {
pengcheng authored
317
318
319
320
321
                LambdaQueryWrapper<StatusFlowHeader> statusFlowHeaderLambda = Wrappers.lambdaQuery();
                statusFlowHeaderLambda.eq(StatusFlowHeader::getCode, receiptDetail.getStatusFlowCode())
                        .eq(StatusFlowHeader::getModuleType, "receipt")
                        .eq(StatusFlowHeader::getRecordType, "receivingFlow");
                StatusFlowHeader statusFlowHeader = statusFlowHeaderService.getOne(statusFlowHeaderLambda);
lector authored
322
323
                if (statusFlowHeader == null) {
                    return AjaxResult.error(receiptDetail.getLocatingRule() + "该流程不存在");
pengcheng authored
324
325
                }
            }
lihailong authored
326
pengcheng authored
327
        }
pengcheng authored
328
329
330

        return AjaxResult.success("");
    }
331
332
333


    @Transactional
lector authored
334
335
336
337
338
339
340
    public AjaxResult remove(List<String> receiptCodeList) {
        LambdaQueryWrapper<ReceiptHeader> headerQueryWrapper;
        for (String receiptCode : receiptCodeList) {
            headerQueryWrapper = Wrappers.lambdaQuery();
            headerQueryWrapper.eq(ReceiptHeader::getCode,receiptCode);
            ReceiptHeader receiptHeader = receiptHeaderService.getOne(headerQueryWrapper);
            if (receiptHeader == null) {
341
342
                return AjaxResult.success("");
            }
lector authored
343
344
            if ((receiptHeader.getFirstStatus() >= QuantityConstant.RECEIPT_HEADER_POSTING && receiptHeader.getLastStatus() >= QuantityConstant.RECEIPT_HEADER_POSTING) ||
                    (receiptHeader.getFirstStatus() < QuantityConstant.RECEIPT_HEADER_POOL & receiptHeader.getLastStatus() < QuantityConstant.RECEIPT_HEADER_POOL)) {
345
346
347
348
                ReceiptHeaderHistory receiptHeaderHistory = new ReceiptHeaderHistory();
                List<ReceiptDetailHistory> receiptDetailHistoryList = new ArrayList<>();
                //查询入库单明细
                LambdaQueryWrapper<ReceiptDetail> lambdaQueryWrapper = Wrappers.lambdaQuery();
lector authored
349
                lambdaQueryWrapper.eq(ReceiptDetail::getReceiptCode, receiptCode);
350
                List<ReceiptDetail> list = receiptDetailService.list(lambdaQueryWrapper);
lector authored
351
352
353
354
355
356
357

                //复制到入库历史实体
                com.huaheng.common.utils.bean.BeanUtils.copyBeanProp(receiptHeaderHistory, receiptHeader);
                for (ReceiptDetail receiptDetail : list) {
                    ReceiptDetailHistory receiptDetailHistory = new ReceiptDetailHistory();
                    com.huaheng.common.utils.bean.BeanUtils.copyBeanProp(receiptDetailHistory, receiptDetail);
                    receiptDetailHistoryList.add(receiptDetailHistory);
358
359
                }
lector authored
360
361
                receiptHeaderHistory.setLastUpdatedBy(ShiroUtils.getLoginName());
lector authored
362
                if (!receiptHeaderService.removeById(receiptHeader.getId())) {
363
364
                    throw new ServiceException("删除头表失败");
                }
lector authored
365
                if (!receiptHeaderHistoryService.save(receiptHeaderHistory)) {
366
367
368
                    throw new ServiceException("新增历史入库单失败");
                }
                // 当存在明细时删除
lector authored
369
                if (list.size() != 0) {
370
371
                    //删除入库明细
                    List<Integer> receiptDetailIds = new ArrayList<>();
lector authored
372
                    for (int i = 0; i < receiptDetailHistoryList.size(); i++) {
373
374
375
376
377
378
379
                        receiptDetailHistoryList.get(i).setLastUpdatedBy(ShiroUtils.getLoginName());
                        receiptDetailHistoryList.get(i).setReceiptId(receiptHeaderHistory.getId());
                        receiptDetailIds.add(receiptDetailHistoryList.get(i).getId());
                    }
                    if (!receiptDetailService.removeByIds(receiptDetailIds)) {
                        throw new ServiceException("删除明细表失败");
                    }
lector authored
380
                    if (!receiptDetailHistoryService.saveBatch(receiptDetailHistoryList)) {
381
                        throw new ServiceException("新增明细失败");
lector authored
382
383
384
                    }
                }
            } else {
385
386
387
388
389
                return AjaxResult.success("入库单没有完成,无法删除");
            }
        }
        return AjaxResult.success("删除成功");
    }
lector authored
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412

    public AjaxResult search(String receiptCode, String companyCode, String warehouseCode) {
        if (companyCode == null) {
            return AjaxResult.error("货主编码不能为空");
        }
        if (warehouseCode == null) {
            return AjaxResult.error("仓库编码不能为空");
        }
        ReceiptDomain receiptDomain = new ReceiptDomain();
        LambdaQueryWrapper<ReceiptHeader> headerLambdaQuery = Wrappers.lambdaQuery();
        LambdaQueryWrapper<ReceiptDetail> detailLambdaQuery = Wrappers.lambdaQuery();
        headerLambdaQuery.eq(ReceiptHeader::getWarehouseCode, warehouseCode)
                .eq(ReceiptHeader::getCompanyCode, companyCode)
                .eq(ReceiptHeader::getCode, receiptCode);
        detailLambdaQuery.eq(ReceiptDetail::getWarehouseCode, warehouseCode)
                .eq(ReceiptDetail::getCompanyCode, companyCode)
                .eq(ReceiptDetail::getReceiptCode, receiptCode);
        ReceiptHeader receiptHeader = receiptHeaderService.getOne(headerLambdaQuery);
        List<ReceiptDetail> receiptDetailList = receiptDetailService.list(detailLambdaQuery);
        receiptDomain.setReceiptHeader(receiptHeader);
        receiptDomain.setReceiptDetails(receiptDetailList);
        return AjaxResult.success("查询成功", receiptDomain);
    }
pengcheng authored
413
}