From d80dd0abcb56aacf30bc32e424ff398f7ccce730 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期五, 26 三月 2021 13:17:00 +0800
Subject: [PATCH] #

---
 src/main/java/zy/cloud/wms/common/service/erp/ErpScheduler.java |  256 +++++++++++++++++++++++++++++++-------------------
 1 files changed, 157 insertions(+), 99 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 5c2099e..d92385d 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,29 +4,25 @@
 import com.baomidou.mybatisplus.mapper.EntityWrapper;
 import com.core.common.Cools;
 import com.core.common.DateUtils;
+import com.core.common.SnowflakeIdWorker;
 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.manager.entity.Cstmr;
-import zy.cloud.wms.manager.entity.CustOrder;
-import zy.cloud.wms.manager.entity.Mat;
-import zy.cloud.wms.manager.entity.Tag;
+import zy.cloud.wms.common.service.erp.entity.*;
+import zy.cloud.wms.manager.entity.*;
+import zy.cloud.wms.manager.mapper.CustOrderMapper;
 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;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
 import java.util.stream.Collectors;
 
 /**
@@ -41,6 +37,7 @@
     public static final String URI = "http://8.133.182.21:8080/api";
     public static final String GET_ORDERS = "cM/basis/getOrders";
     public static final String GET_BASIS = "cM/basis/getBasis";
+    public static final String UPLOAD_BILL = "cM/basis/uploadBill";
     public static final String UPLOAD_STOCK = "cM/basis/uploadStock";
 
     @Autowired
@@ -55,6 +52,10 @@
     private TagService tagService;
     @Autowired
     private TagMapper tagMapper;
+    @Autowired
+    private CustOrderMapper custOrderMapper;
+    @Autowired
+    private SnowflakeIdWorker snowflakeIdWorker;
 
     /**
      * 鍟嗗搧涓嬭浇
@@ -200,6 +201,7 @@
             }
         } catch (Exception e) {
             e.printStackTrace();
+            throw new RuntimeException(e.getMessage());
         }
     }
 
@@ -262,18 +264,20 @@
             }
         } catch (Exception e) {
             e.printStackTrace();
+            throw new RuntimeException(e.getMessage());
         }
     }
 
     /**
      * 鎸佷箙鍖栭攢鍞鍗�
      */
-//    @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)
@@ -281,41 +285,49 @@
                     .build()
                     .doPost();
             if (!Cools.isEmpty(response)) {
-                log.info(response);
+//                log.info(response);
                 Date now = new Date();
                 Result result = JSON.parseObject(response, Result.class);
                 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) {
-                        if (custOrderService.selectCount(new EntityWrapper<CustOrder>().eq("number", data.getNumber()).ne("bType_id", data.getBTypeID())) > 0) {
-                            throw new CoolException("鎶辨瓑鍗曞彿宸插瓨鍦紝璇蜂慨鏀瑰崟鍙凤細" + data.getNumber());
-                        }
-                        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) {
+                    for (GetOrderResult0 data : list) {
+                        if (custOrderService.selectCount(new EntityWrapper<CustOrder>()
+                                .eq("number", data.getNumber())
+//                                .ne("bType_id", data.getBTypeID())
+                                ) > 0) {
+//                            log.error("{}鍗曞彿宸插瓨鍦�", data.getNumber());
                             complete = false;
-                            log.error("淇濆瓨閿�鍞鍗曞け璐ワ紒");
+                            continue;
+                        }
+                        for (GetOrderResultDetl0 detl0 : data.getDetail()) {
+                            CustOrder custOrder = new CustOrder(
+                                    data.getNumber(),    // 閿�鍞崟鍙�
+                                    data.getBillDate(),    // 鍗曟嵁鏃ユ湡[闈炵┖]
+                                    data.getBTypeID(),    // 瀹㈡埛缂栧彿
+                                    data.getETypeID(),    // 缁忔墜浜虹紪鍙穂闈炵┖]
+                                    detl0.getUserCode(),    // 鍟嗗搧缂栧彿
+                                    detl0.getQty(),    // 鍟嗗搧鏁伴噺
+                                    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);
                         }
@@ -325,82 +337,128 @@
             }
         } catch (IOException e) {
             e.printStackTrace();
+            throw new RuntimeException(e.getMessage());
         }
 
     }
 
+    /**
+     * 瀹屾垚閿�鍞鍗�
+     */
+//    @Scheduled(cron = "0/10 * * * * ? ")
+    @Transactional
+//    @PostConstruct
+    public void finishOrdersExecute(){
+        try {
+            List<CustOrder> custOrders = custOrderService.selectList(new EntityWrapper<CustOrder>().eq("status", 4));
+            if (!Cools.isEmpty(custOrders)) {
+                List<String> numbers = custOrders.stream().map(CustOrder::getNumber).distinct().collect(Collectors.toList());
+                for (String number : numbers) {
+                    GetOrderResult0 getOrderResult0 = new GetOrderResult0();
+                    List<GetOrderResultDetl0> list = new ArrayList<>();
+                    getOrderResult0.setDetail(list);
+                    // 閬嶅巻閫掑噺
+                    Iterator<CustOrder> iterator = custOrders.iterator();
+                    while (iterator.hasNext()) {
+                        CustOrder custOrder = iterator.next();
+                        if (custOrder.getNumber().equals(number)) {
+                            // 琛ㄥご
+                            if (Cools.isEmpty(getOrderResult0.getNumber())) {
+                                getOrderResult0.setNumber(number);
+                                getOrderResult0.setVchType(11); // todo:luxiaotao
+                                getOrderResult0.setBillDate(custOrder.getBillDate());
+                                getOrderResult0.setBTypeID(custOrder.getBTypeId());
+                                getOrderResult0.setKTypeID("瀹忔尯浠撳簱");
+                            }
+                            // 琛ㄤ綋
+                            GetOrderResultDetl0 detl0 = new GetOrderResultDetl0();
+                            detl0.setUserCode(custOrder.getUserCode());
+                            detl0.setQty(custOrder.getTotal());
+                            detl0.setPrice(custOrder.getPrice());
+                            detl0.setComment(custOrder.getComment());
+                            list.add(detl0);
+                            iterator.remove();
+                        }
+                    }
+
+                    System.out.println(JSON.toJSONString(getOrderResult0));
+
+
+                    String response = new HttpHandler.Builder()
+                            .setUri(URI)
+                            .setPath(UPLOAD_BILL)
+                            .setJson(JSON.toJSONString(getOrderResult0))
+                            .build()
+                            .doPost();
+                    if (!Cools.isEmpty(response)) {
+                        log.warn(response);
+                        Result result = JSON.parseObject(response, Result.class);
+                        if (result.getCode() != 1) {
+                            return;
+                        }
+                        // 杞巻鍙叉。
+                        int save = custOrderMapper.saveLog(getOrderResult0.getNumber());
+                        if (save > 0) {
+                            if (custOrderMapper.delete(new EntityWrapper<CustOrder>().eq("number", getOrderResult0.getNumber())) == 0) {
+                                throw new CoolException("鍒犻櫎閿�鍞鍗曞け璐�");
+                            }
+                            log.info("{}閿�鍞鍗曟嫞璐х粨鏉�", getOrderResult0.getNumber());
+                        }
+                    }
+
+                }
+            }
+
+
+        } catch (Exception e) {
+            e.printStackTrace();
+            throw new RuntimeException(e.getMessage());
+        }
+
+    }
 
     /**
-     * 鏇存柊搴撳瓨
+     * 搴撳瓨涓婁紶
      */
-//    @Scheduled(cron = "0/3 * * * * ? ")
+//    @Scheduled(cron = "0/15 * * * * ? ")
+    @GetMapping("test2")
     public void uploadStockExecute(){
         try {
 
-//            locDetlService
-
-            Map<String, Object> param = new HashMap<>();
-            param.put("rec", 0);
-            param.put("Flag", 1);
-            String response = new HttpHandler.Builder()
-                    .setUri(URI)
-                    .setPath(GET_BASIS)
-                    .setJson(JSON.toJSONString(param))
-                    .build()
-                    .doPost();
-            if (!Cools.isEmpty(response)) {
-                log.info(response);
-                Date now = new Date();
-                Result result = JSON.parseObject(response, Result.class);
-                if (result.getCode() != 1) {
-                    return;
-                }
-                List<GetBasisResult> list = JSON.parseArray(result.getData(), GetBasisResult.class);
-                for (GetBasisResult data : list) {
-                    Mat mat = matService.selectByMatnr(data.getUserCode());
-                    String modifyDate = data.getModifyDate();
-                    Date updateTime = null;
-                    if (!Cools.isEmpty(modifyDate)) {
-                        updateTime = DateUtils.convert(data.getModifyDate());
-                    }
-                    if (null == mat) {
-                        mat = new Mat(
-                                String.valueOf(data.getRec()),    // 缂栧彿
-                                null,    // 鎵�灞炲尯鍩�
-                                null,    // 鎵�灞炲綊绫�
-                                data.getUserCode(),    // 鍟嗗搧缂栧彿
-                                data.getFullName(),    // 鍟嗗搧鍚嶇О
-                                null,    // 鍚嶇О
-                                null,    // 瑙勬牸
-                                null,    // 鍨嬪彿
-                                null,    // 鎵瑰彿
-                                null,    // 鍗曚綅
-                                null,    // 鏉$爜
-                                null,    // 鍗曟嵁绫诲瀷
-                                null,    // 鍗曟嵁缂栧彿
-                                null,    // 瀹㈡埛鍚嶇О
-                                null,    // 鍝侀」鏁�
-                                null,    // 搴撳瓨浣欓噺
-                                null,    // 閲嶉噺
-                                1,    //
-                                null,    // 娣诲姞浜哄憳
-                                now,    // 娣诲姞鏃堕棿
-                                null,    // 淇敼浜哄憳
-                                updateTime,    // 淇敼鏃堕棿
-                                null    // 澶囨敞
-                        );
-                        matService.insert(mat);
-                    } else {
-                        mat.setUuid(String.valueOf(data.getRec()));
-                        mat.setMatnr(data.getUserCode());
-                        mat.setMaktx(data.getFullName());
-                        mat.setUpdateTime(updateTime);
-                        matService.updateById(mat);
-                    }
-                    log.info("====>> 鏇存柊鐗╂枡锛歿}", data.getUserCode());
+            List<LocDetl> statis = locDetlService.getLocDetlStatis();
+            if (!Cools.isEmpty(statis)) {
+                UploadStock uploadStock = new UploadStock();
+                uploadStock.setNumber(String.valueOf(snowflakeIdWorker.nextId()));
+                uploadStock.setVchType(89);
+                uploadStock.setBillDate(DateUtils.convert(new Date(), DateUtils.yyyyMMdd_F));
+                uploadStock.setDataSize(statis.size());
+                List<UploadStockDtel> detail = new ArrayList<>();
+                uploadStock.setDetail(detail);
+                for (LocDetl locDetl : statis) {
+                    Mat mat = matService.selectByMatnr(locDetl.getMatnr());
+                    if (mat == null) {continue;}
+                    UploadStockDtel detl = new UploadStockDtel();
+                    detl.setUserCode(mat.getMatnr());
+                    detl.setQty(locDetl.getAnfme());
+//                    detl.setPrice(Double.parseDouble());
+                    detl.setComment(mat.getMemo());
+                    detail.add(detl);
                 }
 
+                String response = new HttpHandler.Builder()
+                        .setUri(URI)
+                        .setPath(UPLOAD_STOCK)
+                        .setJson(JSON.toJSONString(uploadStock))
+                        .build()
+                        .doPost();
+                if (!Cools.isEmpty(response)) {
+                    log.info("涓婃姤搴撳瓨鏄庣粏缁熻 ======>> \nrequest:{} \nresponse:{}", JSON.toJSONString(uploadStock), response);
+                    Result result = JSON.parseObject(response, Result.class);
+                    if (result.getCode() != 1) {
+                    }
+                }
             }
+
         } catch (Exception e) {
             e.printStackTrace();
         }

--
Gitblit v1.9.1