From 553ffd71e38c1fcae9c678dae1106e820bbd5127 Mon Sep 17 00:00:00 2001
From: skyouc
Date: 星期三, 04 六月 2025 08:10:47 +0800
Subject: [PATCH] 任务执行优化修改

---
 rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/DeliveryItemServiceImpl.java |  172 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 171 insertions(+), 1 deletions(-)

diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/DeliveryItemServiceImpl.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/DeliveryItemServiceImpl.java
index 2e4ae68..7e59d53 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/DeliveryItemServiceImpl.java
+++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/DeliveryItemServiceImpl.java
@@ -1,12 +1,182 @@
 package com.vincent.rsf.server.manager.service.impl;
 
+import cn.afterturn.easypoi.excel.ExcelImportUtil;
+import cn.afterturn.easypoi.excel.entity.result.ExcelImportResult;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
+import com.vincent.rsf.framework.common.R;
+import com.vincent.rsf.framework.exception.CoolException;
+import com.vincent.rsf.server.common.utils.ExcelUtil;
+import com.vincent.rsf.server.manager.entity.*;
+import com.vincent.rsf.server.manager.entity.excel.AsnOrderTemplate;
+import com.vincent.rsf.server.manager.entity.excel.DeliveryTemplate;
+import com.vincent.rsf.server.manager.enums.CompanysType;
+import com.vincent.rsf.server.manager.enums.OrderType;
+import com.vincent.rsf.server.manager.enums.OrderWorkType;
+import com.vincent.rsf.server.manager.enums.QlyIsptResult;
 import com.vincent.rsf.server.manager.mapper.DeliveryItemMapper;
-import com.vincent.rsf.server.manager.entity.DeliveryItem;
+import com.vincent.rsf.server.manager.service.CompanysService;
 import com.vincent.rsf.server.manager.service.DeliveryItemService;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.vincent.rsf.server.manager.service.DeliveryService;
+import com.vincent.rsf.server.manager.service.MatnrService;
+import com.vincent.rsf.server.system.constant.SerialRuleCode;
+import com.vincent.rsf.server.system.utils.SerialRuleUtils;
+import org.apache.commons.lang3.StringUtils;
+import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
+import org.springframework.web.multipart.MultipartFile;
+
+import java.io.IOException;
+import java.text.SimpleDateFormat;
+import java.util.*;
+import java.util.stream.Collectors;
 
 @Service("deliveryItemService")
 public class DeliveryItemServiceImpl extends ServiceImpl<DeliveryItemMapper, DeliveryItem> implements DeliveryItemService {
 
+    @Autowired
+    private DeliveryService deliveryService;
+    @Autowired
+    private MatnrService matnrService;
+    @Autowired
+    private CompanysService companysService;
+    @Autowired
+    private DeliveryItemService deliveryItemService;
+
+//    private
+    /**
+     * excel DO鍗曞鍏�
+     *
+     * @param file
+     * @param hashMap
+     * @param loginUserId
+     * @return
+     */
+//    @Override
+//    public R excelImport(MultipartFile file, Map<String, Object> hashMap, Long loginUserId) throws Exception {
+//        ExcelImportResult result = ExcelImportUtil.importExcelMore(file.getInputStream(), DeliveryTemplate.class, ExcelUtil.getDefaultImportParams());
+//        if (result.getList().isEmpty()) {
+//            throw new CoolException("琛ㄦ牸鍐呭涓嶈兘涓虹┖锛侊紒");
+//        }
+//        List<DeliveryTemplate> resultList = result.getList();
+//        Map<String, List<DeliveryTemplate>> listMap = resultList.stream().collect(Collectors.groupingBy(DeliveryTemplate::getDoCode));
+//        StringBuffer sbFaild = new StringBuffer();
+//        for (String key : listMap.keySet()) {
+//            if (StringUtils.isBlank(key)) {
+//                throw new CoolException("鍗曞彿涓嶈兘涓虹┖锛侊紒");
+//            }
+//            DeliveryTemplate template = listMap.get(key).stream().findFirst().get();
+//            Delivery order = deliveryService.getOne(new LambdaQueryWrapper<Delivery>().eq(Delivery::getCode, key));
+//            if (!Objects.isNull(order)) {
+//                sbFaild.append(template.getDoCode()).append(",宸叉坊鍔狅紒锛�");
+//                throw new CoolException(sbFaild.toString());
+//            }
+//            order = new Delivery();
+//            SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
+//            Date date = dateFormat.parse(template.getArrTime());
+//            if (Objects.isNull(date)) {
+//                throw new CoolException("鏃堕棿鏍煎紡閿欒锛侊紒");
+//            }
+//            if (Objects.isNull((OrderType.getTypeVal(template.getType())))) {
+//                sbFaild.append(template.getDoCode()).append(",鍗曟嵁鐘舵�佷笉瀛樺湪锛侊紒");
+//                throw new CoolException(sbFaild.toString());
+//            }
+//            if (Objects.isNull((OrderWorkType.getWorkType(template.getWkType())))) {
+//                sbFaild.append(template.getDoCode()).append(",涓氬姟鐘舵�佷笉瀛樺湪锛侊紒");
+//                throw new CoolException(sbFaild.toString());
+//            }
+//
+//            order.setCode(template.getDoCode())
+//                    .setPoCode(template.getPoCode())
+//                    .setMemo(template.getMemo())
+//                    .setArrTime(date)
+//                    .setUpdateBy(loginUserId)
+//                    .setLogisNo(template.getLogicNo())
+//                    .setCreateBy(loginUserId)
+//                    .setType(OrderType.getTypeVal(template.getType()))
+//                    .setWkType(OrderWorkType.getWorkType(template.getWkType()));
+//            if (!deliveryService.save(order)) {
+//                throw new CoolException("鍗曟嵁淇濆瓨澶辫触锛侊紒");
+//            }
+//            List<DeliveryItem> items = new ArrayList<>();
+//            for (DeliveryTemplate orderTemplate : listMap.get(key)) {
+//                DeliveryItem orderItem = new DeliveryItem();
+//                if (StringUtils.isBlank(orderTemplate.getMatnrCode())) {
+//                    throw new CoolException(orderTemplate.getDoCode() + "锛氱墿鏂欑紪鐮佷笉鑳戒负绌猴紒锛�");
+//                }
+//                if (StringUtils.isBlank(orderTemplate.getAnfme())) {
+//                    throw new CoolException(orderTemplate.getDoCode() + "锛氭暟閲忎笉鑳戒负绌猴紒锛�");
+//                }
+//                if (StringUtils.isBlank(orderTemplate.getType())) {
+//                    throw new CoolException(orderTemplate.getDoCode() + "锛氬崟鎹被鍨嬩笉鑳戒负绌猴紒锛�");
+//                }
+//                if (StringUtils.isBlank(orderTemplate.getWkType())) {
+//                    throw new CoolException(orderTemplate.getDoCode() + "锛氫笟鍔$被鍨嬩笉鑳戒负绌猴紒锛�");
+//                }
+//
+//                Matnr matnr = matnrService.getOne(new LambdaQueryWrapper<Matnr>()
+//                        .eq(Matnr::getCode, orderTemplate.getMatnrCode()));
+//                if (Objects.isNull(matnr)) {
+//                    sbFaild.append(orderTemplate.getMatnrCode()).append("鐗╂枡涓嶅瓨鍦�");
+//                    throw new CoolException(sbFaild.toString());
+//                }
+//                String trackCode = SerialRuleUtils.generateRuleCode(SerialRuleCode.SYS_LABEL_CODE, matnr);
+//                orderItem.setDeliveryId(order.getId())
+//                        .setDeliveryCode(order.getCode())
+//                        .setSplrBatch(orderTemplate.getSplrBatch())
+//                        .setPlatItemId(orderTemplate.getPlatItemId())
+//                        .setAnfme(Double.parseDouble(orderTemplate.getAnfme()))
+//                        .setIsptResult(QlyIsptResult.getDescVal(orderTemplate.getIsptResult()))
+////                        .setTrackCode(trackCode)
+//                        .setBarcode(trackCode)
+//                        .setPlatOrderCode(orderTemplate.getPlatOrderCode())
+//                        .setPlatWorkCode(orderTemplate.getPlatWorkCode())
+//                        .setProjectCode(orderTemplate.getProjectCode())
+//                        .setPoCode(orderTemplate.getDoCode())
+//                        .setPurUnit(matnr.getUnit())
+//                        .setCreateBy(loginUserId)
+//                        .setUpdateBy(loginUserId)
+//                        .setSpec(matnr.getSpec())
+//                        .setModel(matnr.getModel())
+//                        .setMaktx(matnr.getName())
+//                        .setMatnrCode(matnr.getCode())
+//                        .setMatnrId(matnr.getId())
+//                        .setStockUnit(matnr.getUnit());
+//                if (!Objects.isNull(orderTemplate.getSplrCode())) {
+//                    Companys companys = companysService.getOne(new LambdaQueryWrapper<Companys>()
+//                            .eq(Companys::getType, CompanysType.COMPANYS_TYPE_SUPPLIER.val)
+//                            .eq(Companys::getCode, orderTemplate.getSplrCode()));
+//                    if (!Objects.isNull(companys)) {
+//                        orderItem.setSplrCode(companys.getCode()).setSplrName(companys.getName());
+//                    } else {
+//                        sbFaild.append("渚涘簲鍟�:" + orderTemplate.getSplrCode()).append("涓嶅瓨鍦�");
+//                        throw new CoolException(sbFaild.toString());
+//                    }
+//                } else {
+//                    continue;
+//                }
+//                items.add(orderItem);
+//
+//                if (!deliveryItemService.save(orderItem)) {
+//                    throw new CoolException("鍗曟嵁鏄庣粏淇濆瓨澶辫触锛侊紒");
+//                }
+//            }
+//            if (!items.isEmpty()) {
+////                double qty = items.stream().mapToDouble(AsnOrderItem::getQty).sum();
+//                double anfme = items.stream().mapToDouble(DeliveryItem::getAnfme).sum();
+//                if (!deliveryService.update(new LambdaUpdateWrapper<Delivery>()
+////                        .set(AsnOrder::getQty, qty)
+//                        .set(Delivery::getAnfme, anfme)
+//                        .eq(Delivery::getId, order.getId()))) {
+//                    throw new CoolException("鍗曟嵁鏁伴噺淇敼澶辫触锛侊紒");
+//                }
+//            }
+//
+//
+//        }
+//
+//
+//        return null;
+//    }
 }

--
Gitblit v1.9.1