From b10c50ce84e4c6020864bd9f79d12733635a9602 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期二, 16 三月 2021 14:02:51 +0800
Subject: [PATCH] #

---
 src/main/java/zy/cloud/wms/common/service/erp/ErpScheduler.java |  157 +++++++++++++++++++++++++++++++++++++++++----------
 1 files changed, 125 insertions(+), 32 deletions(-)

diff --git a/src/main/java/zy/cloud/wms/common/service/erp/ErpScheduler.java b/src/main/java/zy/cloud/wms/common/service/erp/ErpScheduler.java
index 6706377..a035a39 100644
--- a/src/main/java/zy/cloud/wms/common/service/erp/ErpScheduler.java
+++ b/src/main/java/zy/cloud/wms/common/service/erp/ErpScheduler.java
@@ -4,20 +4,25 @@
 import com.baomidou.mybatisplus.mapper.EntityWrapper;
 import com.core.common.Cools;
 import com.core.common.DateUtils;
+import com.core.exception.CoolException;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.scheduling.annotation.Scheduled;
 import org.springframework.stereotype.Component;
 import org.springframework.transaction.annotation.Transactional;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RestController;
 import zy.cloud.wms.common.service.erp.entity.GetBasisResult;
-import zy.cloud.wms.common.service.erp.entity.GetOrderResult;
+import zy.cloud.wms.common.service.erp.entity.GetOrderResult0;
+import zy.cloud.wms.common.service.erp.entity.GetOrderResultDetl0;
 import zy.cloud.wms.manager.entity.Cstmr;
 import zy.cloud.wms.manager.entity.CustOrder;
 import zy.cloud.wms.manager.entity.Mat;
-import zy.cloud.wms.manager.service.CstmrService;
-import zy.cloud.wms.manager.service.CustOrderService;
-import zy.cloud.wms.manager.service.LocDetlService;
-import zy.cloud.wms.manager.service.MatService;
+import zy.cloud.wms.manager.entity.Tag;
+import zy.cloud.wms.manager.mapper.TagMapper;
+import zy.cloud.wms.manager.service.*;
 import zy.cloud.wms.manager.utils.HttpHandler;
+import zy.cloud.wms.manager.utils.NodeUtils;
 
 import java.io.IOException;
 import java.util.Date;
@@ -32,6 +37,7 @@
  */
 @Slf4j
 @Component
+@RestController
 public class ErpScheduler {
 
     public static final String URI = "http://8.133.182.21:8080/api";
@@ -47,11 +53,16 @@
     private CstmrService cstmrService;
     @Autowired
     private LocDetlService locDetlService;
+    @Autowired
+    private TagService tagService;
+    @Autowired
+    private TagMapper tagMapper;
 
     /**
      * 鍟嗗搧涓嬭浇
      */
     //    @Scheduled(cron = "0/5 * * * * ? ")
+    @GetMapping("/test1")
 //    @PostConstruct
     public void getBasis1Execute(){
         try {
@@ -72,6 +83,7 @@
                     return;
                 }
                 List<GetBasisResult> list = JSON.parseArray(result.getData(), GetBasisResult.class);
+                Tag first = null;
                 for (GetBasisResult data : list) {
                     Mat mat = matService.selectByMatnr(data.getUserCode());
                     String modifyDate = data.getModifyDate();
@@ -79,19 +91,87 @@
                     if (!Cools.isEmpty(modifyDate)) {
                         updateTime = DateUtils.convert(data.getModifyDate());
                     }
+
+                    // 鍒嗙被
+                    Tag second = tagService.selectOne(new EntityWrapper<Tag>().eq("name", data.getYjfl()).eq("level", 2));
+                    if (second == null) {
+                        if (first == null) {
+                            first = tagService.selectOne(new EntityWrapper<Tag>().eq("level", 1));
+                            if (first == null) {
+                                throw new CoolException("鍏ㄩ儴鍒嗙被鍑洪敊");
+                            }
+                        }
+                        NodeUtils nodeUtils = new NodeUtils();
+                        nodeUtils.executePath(first.getId());
+                        second = new Tag(
+                                null,    // 缂栧彿
+                                data.getYjfl(),    // 鍚嶇О
+                                first.getId(),    // 鐖剁骇
+                                first.getName(),    // 鐖剁骇鍚嶇О
+                                nodeUtils.path.toString(),    // 鍏宠仈璺緞
+                                nodeUtils.pathName.toString(),    // 鍏宠仈璺緞鍚�
+                                0,    // 绫诲瀷
+                                null,    // 璐熻矗浜�
+                                null,    // 鍥剧墖
+                                null,    // 绠�瑕佹弿杩�
+                                null,    // 鏁伴噺
+                                2,    // 绛夌骇
+                                null,    // 鎺掑簭
+                                1,    // 鐘舵��
+                                now,    // 娣诲姞鏃堕棿
+                                null,    // 娣诲姞浜哄憳
+                                now,    // 淇敼鏃堕棿
+                                null,    // 淇敼浜哄憳
+                                null    // 澶囨敞
+                        );
+                        if (tagMapper.insert(second) == 0) {
+                            throw new CoolException("鎻掑叆鍒嗙被澶辫触");
+                        }
+                    }
+
+                    Tag third = tagService.selectOne(new EntityWrapper<Tag>().eq("level", 3).eq("name", data.getEjfl()).eq("parent_name", data.getYjfl()));
+                    if (third == null) {
+                        NodeUtils nodeUtils = new NodeUtils();
+                        nodeUtils.executePath(second.getId());
+                        third = new Tag(
+                                null,    // 缂栧彿
+                                data.getEjfl(),    // 鍚嶇О
+                                second.getId(),    // 鐖剁骇
+                                second.getName(),    // 鐖剁骇鍚嶇О
+                                nodeUtils.path.toString(),    // 鍏宠仈璺緞
+                                nodeUtils.pathName.toString(),    // 鍏宠仈璺緞鍚�
+                                0,    // 绫诲瀷
+                                null,    // 璐熻矗浜�
+                                null,    // 鍥剧墖
+                                null,    // 绠�瑕佹弿杩�
+                                null,    // 鏁伴噺
+                                3,    // 绛夌骇
+                                null,    // 鎺掑簭
+                                1,    // 鐘舵��
+                                now,    // 娣诲姞鏃堕棿
+                                null,    // 娣诲姞浜哄憳
+                                now,    // 淇敼鏃堕棿
+                                null,    // 淇敼浜哄憳
+                                null    // 澶囨敞
+                        );
+                        if (tagMapper.insert(third) == 0) {
+                            throw new CoolException("鎻掑叆鍒嗙被澶辫触");
+                        }
+                    }
+
                     if (null == mat) {
                         mat = new Mat(
                                 String.valueOf(data.getRec()),    // 缂栧彿
                                 null,    // 鎵�灞炲尯鍩�
-                                null,    // 鎵�灞炲綊绫�
+                                third.getId(),    // 鎵�灞炲綊绫�
                                 data.getUserCode(),    // 鍟嗗搧缂栧彿
                                 data.getFullName(),    // 鍟嗗搧鍚嶇О
                                 null,    // 鍚嶇О
-                                null,    // 瑙勬牸
+                                data.getStandard(),    // 瑙勬牸
                                 null,    // 鍨嬪彿
                                 null,    // 鎵瑰彿
-                                null,    // 鍗曚綅
-                                null,    // 鏉$爜
+                                data.getUnit3(),    // 鍗曚綅
+                                data.getBarcode(),    // 鏉$爜
                                 null,    // 鍗曟嵁绫诲瀷
                                 null,    // 鍗曟嵁缂栧彿
                                 null,    // 瀹㈡埛鍚嶇О
@@ -110,7 +190,10 @@
                         mat.setUuid(String.valueOf(data.getRec()));
                         mat.setMatnr(data.getUserCode());
                         mat.setMaktx(data.getFullName());
+                        mat.setSpecs(data.getStandard());
                         mat.setUpdateTime(updateTime);
+                        mat.setBarcode(data.getBarcode());
+                        mat.setUnit(data.getUnit3());
                         matService.updateById(mat);
                     }
                     log.info("====>> 鏇存柊鐗╂枡锛歿}", data.getUserCode());
@@ -187,12 +270,13 @@
     /**
      * 鎸佷箙鍖栭攢鍞鍗�
      */
-//    @Scheduled(cron = "0/3 * * * * ? ")
+    @Scheduled(cron = "0/5 * * * * ? ")
     @Transactional
+//    @PostConstruct
     public void getOrdersExecute(){
         try {
             Map<String, Object> json = new HashMap<>();
-            json.put("vchType", 41);
+            json.put("vchType", 151);
             String response = new HttpHandler.Builder()
                     .setUri(URI)
                     .setPath(GET_ORDERS)
@@ -206,32 +290,41 @@
                 if (result.getCode() != 1) {
                     return;
                 }
-                List<GetOrderResult> list = JSON.parseArray(result.getData(), GetOrderResult.class);
+                List<GetOrderResult0> list = JSON.parseArray(result.getData(), GetOrderResult0.class);
                 if (!Cools.isEmpty(list)) {
                     boolean complete = true;
-                    for (GetOrderResult data : list) {
-                        CustOrder custOrder = new CustOrder(
-                                data.getNumber(),    // 閿�鍞崟鍙�
-                                data.getBillDate(),    // 鍗曟嵁鏃ユ湡[闈炵┖]
-                                data.getBTypeID(),    // 瀹㈡埛缂栧彿
-                                data.getETypeID(),    // 缁忔墜浜虹紪鍙穂闈炵┖]
-                                data.getUserCode(),    // 鍟嗗搧缂栧彿
-                                data.getQty(),    // 鍟嗗搧鏁伴噺
-                                data.getPrice(),    // 鍟嗗搧鍗曚环
-                                data.getComment(),    // 鍟嗗搧澶囨敞[闈炵┖]
-                                0,    // 鐘舵��
-                                now,    // 娣诲姞鏃堕棿
-                                now,    // 淇敼鏃堕棿
-                                null    // 澶囨敞
-                        );
-                        boolean insert = custOrderService.insert(custOrder);
-                        if (!insert) {
-                            complete = false;
-                            log.error("淇濆瓨閿�鍞鍗曞け璐ワ紒");
+                    for (GetOrderResult0 data : list) {
+                        if (custOrderService.selectCount(new EntityWrapper<CustOrder>()
+                                .eq("number", data.getNumber())
+//                                .ne("bType_id", data.getBTypeID())
+                                ) > 0) {
+                            log.error("{}鍗曞彿宸插瓨鍦�", data.getNumber());
+                            continue;
+                        }
+                        for (GetOrderResultDetl0 detl0 : data.getDetail()) {
+                            CustOrder custOrder = new CustOrder(
+                                    data.getNumber(),    // 閿�鍞崟鍙�
+                                    data.getBillDate(),    // 鍗曟嵁鏃ユ湡[闈炵┖]
+                                    data.getBTypeID(),    // 瀹㈡埛缂栧彿
+                                    data.getETypeID(),    // 缁忔墜浜虹紪鍙穂闈炵┖]
+                                    detl0.getUserCode(),    // 鍟嗗搧缂栧彿
+                                    detl0.getQty(),    // 鍟嗗搧鏁伴噺
+                                    detl0.getPrice(),    // 鍟嗗搧鍗曚环
+                                    detl0.getComment(),    // 鍟嗗搧澶囨敞[闈炵┖]
+                                    0,    // 鐘舵��
+                                    now,    // 娣诲姞鏃堕棿
+                                    now,    // 淇敼鏃堕棿
+                                    data.getSummary()    // 澶囨敞
+                            );
+                            boolean insert = custOrderService.insert(custOrder);
+                            if (!insert) {
+                                complete = false;
+                                log.error("淇濆瓨閿�鍞鍗曞け璐ワ紒");
+                            }
                         }
                     }
                     if (complete) {
-                        List<String> collect = list.stream().map(GetOrderResult::getNumber).distinct().collect(Collectors.toList());
+                        List<String> collect = list.stream().map(GetOrderResult0::getNumber).distinct().collect(Collectors.toList());
                         for (String number : collect) {
                             custOrderService.updateStatus(number, 1);
                         }

--
Gitblit v1.9.1