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

---
 src/main/java/zy/cloud/wms/common/service/erp/ErpScheduler.java |  261 ++++++++++++++++++++++++++++++----------------------
 1 files changed, 150 insertions(+), 111 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 d013ee5..e2a33c2 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
@@ -9,11 +9,13 @@
 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.*;
+import zy.cloud.wms.common.utils.VersionUtils;
 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;
@@ -28,8 +30,8 @@
  * Created by vincent on 2020/11/27
  */
 @Slf4j
-//@Component
-//@RestController
+@Component
+@RestController
 public class ErpScheduler {
 
     public static final String URI = "http://8.133.182.21:8080/api";
@@ -41,8 +43,6 @@
     public static final String UPLOAD_CANCEL_RESULT = "cM/basis/cancelOrders";
 
     @Autowired
-    private CustOrderService custOrderService;
-    @Autowired
     private MatService matService;
     @Autowired
     private CstmrService cstmrService;
@@ -53,7 +53,9 @@
     @Autowired
     private TagMapper tagMapper;
     @Autowired
-    private CustOrderMapper custOrderMapper;
+    private OrderService orderService;
+    @Autowired
+    private OrderDetlService orderDetlService;
     @Autowired
     private SnowflakeIdWorker snowflakeIdWorker;
 
@@ -296,44 +298,81 @@
                     boolean complete = true;
                     Set<String> existNumbers = new HashSet<>();
                     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;
+                        if (orderService.selectByOrderNo(data.getNumber()) != null) {
                             existNumbers.add(data.getNumber());
                             continue;
                         }
+                        Cstmr cstmr = cstmrService.selectByUuid(data.getBTypeID());
+                        Order order = new Order(
+                                String.valueOf(snowflakeIdWorker.nextId()),    // 缂栧彿[闈炵┖]
+                                data.getNumber(),    // 璁㈠崟缂栧彿
+                                data.getBillDate(),    // 鍗曟嵁鏃ユ湡
+                                11L,    // 鍗曟嵁绫诲瀷
+                                null,    // 椤圭洰缂栧彿
+                                null,   // 椤圭洰鍚嶇О
+                                null,    // 璋冩嫧椤圭洰缂栧彿
+                                null,    // 鍒濆绁ㄦ嵁鍙�
+                                String.valueOf(data.getVchcode()),    // 绁ㄦ嵁鍙�
+                                null,    // 瀹㈡埛缂栧彿
+                                cstmr==null?data.getBTypeID():cstmr.getName(),    // 瀹㈡埛
+                                data.getBTypeID(),    // 鑱旂郴鏂瑰紡 *
+                                null,    // 鎿嶄綔浜哄憳
+                                null,    // 鍚堣閲戦
+                                null,    // 浼樻儬鐜�
+                                null,    // 浼樻儬閲戦
+                                null,    // 閿�鍞垨閲囪喘璐圭敤鍚堣
+                                null,    // 瀹炰粯閲戦
+                                null,    // 浠樻绫诲瀷
+                                data.getETypeID(),    // 涓氬姟鍛� *
+                                null,    // 缁撶畻澶╂暟
+                                null,    // 閭垂鏀粯绫诲瀷
+                                null,    // 閭垂
+                                null,    // 浠樻鏃堕棿
+                                null,    // 鍙戣揣鏃堕棿
+                                null,    // 鐗╂祦鍚嶇О
+                                null,    // 鐗╂祦鍗曞彿
+                                1L,    // 璁㈠崟鐘舵��
+                                1,    // 鐘舵��
+                                9527L,    // 娣诲姞浜哄憳
+                                now,    // 娣诲姞鏃堕棿
+                                9527L,    // 淇敼浜哄憳
+                                now,    // 淇敼鏃堕棿
+                                data.getSummary()    // 澶囨敞
+                        );
+                        if (!orderService.insert(order)) {
+                            throw new CoolException("淇濆瓨璁㈠崟琛ㄥご澶辫触锛�");
+                        }
                         for (GetOrderResultDetl0 detl0 : data.getDetail()) {
-                            CustOrder custOrder = new CustOrder(
-                                    data.getNumber(),    // 閿�鍞崟鍙�
-                                    data.getBillDate(),    // 鍗曟嵁鏃ユ湡[闈炵┖]
-                                    data.getBTypeID(),    // 瀹㈡埛缂栧彿
-                                    data.getETypeID(),    // 缁忔墜浜虹紪鍙穂闈炵┖]
-                                    data.getVchcode(),  // 鍗曟嵁鑷ID
-                                    detl0.getUserCode(),    // 鍟嗗搧缂栧彿
-                                    detl0.getQty(),    // 鍟嗗搧鏁伴噺
-                                    detl0.getQty(),    // 鎬绘暟閲�
-                                    detl0.getPrice(),    // 鍟嗗搧鍗曚环
-                                    detl0.getRowNo(),       // 鍟嗗搧鏄庣粏琛屽彿
-                                    detl0.getComment(),    // 鍟嗗搧澶囨敞[闈炵┖]
-                                    0,    // 鐘舵��
-                                    now,    // 娣诲姞鏃堕棿
-                                    now,    // 淇敼鏃堕棿
-                                    data.getSummary()    // 澶囨敞
-                            );
-                            if (!custOrderService.insert(custOrder)) {
+                            Mat mat = matService.selectByMatnr(detl0.getUserCode());
+                            if (mat == null) {
+                                log.error("{}鍟嗗搧涓嶅瓨鍦ㄣ��", detl0.getUserCode());
+                                continue;
+                            }
+                            OrderDetl orderDetl = new OrderDetl();
+                            VersionUtils.setOrderDetl(orderDetl, mat);
+                            orderDetl.setName(String.valueOf(detl0.getRowNo())); // 鍟嗗搧鏄庣粏琛屽彿
+                            orderDetl.setOrderId(order.getId());                 // 璁㈠崟鍐呯爜
+                            orderDetl.setAnfme(detl0.getQty());                  // 鍟嗗搧鏁伴噺
+                            orderDetl.setCount(detl0.getQty());                  // 鎬绘暟閲� *
+                            orderDetl.setUnitPrice(detl0.getPrice());            // 鍟嗗搧鍗曚环
+                            orderDetl.setCreateBy(9527L);
+                            orderDetl.setCreateTime(now);
+                            orderDetl.setUpdateBy(9527L);
+                            orderDetl.setUpdateTime(now);
+                            orderDetl.setStatus(1);
+                            orderDetl.setMemo(detl0.getComment());
+                            if (!orderDetlService.insert(orderDetl)) {
                                 complete = false;
                                 log.error("淇濆瓨閿�鍞鍗曞け璐ワ紒");
                             }
+
                         }
                     }
                     if (complete) {
                         List<String> collect = list.stream().map(GetOrderResult0::getNumber).distinct().collect(Collectors.toList());
                         for (String number : collect) {
                             if (!existNumbers.contains(number)) {
-                                custOrderService.updateStatus(number, 1);
+                                orderService.updateSettle(number, 1L);
                             }
                         }
                     }
@@ -355,37 +394,34 @@
 //    @PostConstruct
     public void finishOrdersExecute(){
         try {
-            List<CustOrder> custOrders = custOrderService.selectList(new EntityWrapper<CustOrder>().eq("status", 4).isNotNull("vch_code"));
-            if (!Cools.isEmpty(custOrders)) {
-                List<String> numbers = custOrders.stream().map(CustOrder::getNumber).distinct().collect(Collectors.toList());
-                for (String number : numbers) {
+            List<Order> orders = orderService.selectList(new EntityWrapper<Order>().eq("settle", 4).isNotNull("number"));
+            if (!Cools.isEmpty(orders)) {
+                List<String> orderNos = orders.stream().map(Order::getOrderNo).distinct().collect(Collectors.toList());
+                for (Order order : orders) {
                     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("瀹忔尯浠撳簱");
-                                getOrderResult0.setVchcode(custOrder.getVchcode());
-                            }
-                            // 琛ㄤ綋
-                            GetOrderResultDetl0 detl0 = new GetOrderResultDetl0();
-                            detl0.setUserCode(custOrder.getUserCode());
-                            detl0.setQty(custOrder.getTotal());
-                            detl0.setPrice(custOrder.getPrice());
-                            detl0.setComment(custOrder.getComment());
-                            detl0.setRowNo(custOrder.getRowNo());
-                            list.add(detl0);
-                            iterator.remove();
-                        }
+
+
+                    // 澶�
+                    getOrderResult0.setNumber(order.getOrderNo());
+                    getOrderResult0.setVchType(11); // todo:luxiaotao
+                    getOrderResult0.setBillDate(order.getOrderTime());
+                    getOrderResult0.setBTypeID(order.getTel());
+                    getOrderResult0.setKTypeID("瀹忔尯浠撳簱");
+                    getOrderResult0.setVchcode(Integer.parseInt(order.getNumber()));
+
+
+                    // 浣�
+                    List<OrderDetl> orderDetls = orderDetlService.selectByOrderNo(order.getOrderNo());
+                    for (OrderDetl orderDetl : orderDetls) {
+                        GetOrderResultDetl0 detl0 = new GetOrderResultDetl0();
+                        detl0.setUserCode(orderDetl.getMatnr());
+                        detl0.setQty(orderDetl.getCount());
+                        detl0.setPrice(orderDetl.getUnitPrice());
+                        detl0.setComment(orderDetl.getMemo());
+                        detl0.setRowNo(Integer.parseInt(orderDetl.getName()));
+                        list.add(detl0);
                     }
 
                     System.out.println(JSON.toJSONString(getOrderResult0));
@@ -401,16 +437,19 @@
                         log.warn(response);
                         Result result = JSON.parseObject(response, Result.class);
                         if (result.getCode() != 1) {
-                            return;
+                            continue;
                         }
-                        // 杞巻鍙叉。
-                        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());
+                        if (!orderService.updateSettle(getOrderResult0.getNumber(), 6L)) {
+                            throw new CoolException("淇敼璁㈠崟鐘舵�佸け璐�");
                         }
+//                        // 杞巻鍙叉。
+//                        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());
+//                        }
                     }
 
                 }
@@ -502,7 +541,7 @@
                     Set<String> existNumbers = new HashSet<>();
 
                     String cancelNumber = "";
-                    if (!custOrderService.updateStatus(cancelNumber, 5)) {
+                    if (!orderService.updateSettle(cancelNumber, 5L)) {
                         throw new CoolException("淇敼璁㈠崟鐘舵�佸け璐�");
                     }
 
@@ -523,49 +562,49 @@
     @Transactional
 //    @PostConstruct
     public void uploadCancelOrdersExecute(){
-        try {
-            List<CustOrder> custOrders = custOrderService.selectList(new EntityWrapper<CustOrder>().eq("status", 3).isNotNull("vch_code"));
-            if (Cools.isEmpty(custOrders)) {
-                return;
-            }
-            Map<String, Object> json = new HashMap<>();
-            List<UploadCancelResult> list = new ArrayList<>();
-            for (CustOrder custOrder : custOrders) {
-                UploadCancelResult result = new UploadCancelResult();
-                result.setNumber(custOrder.getNumber());
-                result.setUserCode(custOrder.getUserCode());
-                result.setQty(custOrder.getTotal());
-                result.setStatus(1);
-                list.add(result);
-            }
-            json.put("data", list);
-            String response = new HttpHandler.Builder()
-                    .setUri(URI)
-                    .setPath(UPLOAD_CANCEL_RESULT)
-                    .setJson(JSON.toJSONString(json))
-                    .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;
-                }
-                for (UploadCancelResult result1 : list) {
-                    // 杞巻鍙叉。
-                    int save = custOrderMapper.saveLog(result1.getNumber(), result1.getUserCode());
-                    if (save > 0) {
-                        if (custOrderMapper.delete(new EntityWrapper<CustOrder>().eq("number", result1.getNumber()).eq("user_code", result1.getUserCode())) == 0) {
-                            throw new CoolException("鍒犻櫎閿�鍞鍗曞け璐�");
-                        }
-                    }
-                }
-            }
-        } catch (IOException e) {
-            e.printStackTrace();
-            throw new RuntimeException(e.getMessage());
-        }
+//        try {
+//            List<Order> orders = orderService.selectList(new EntityWrapper<Order>().eq("settle", 3).isNotNull("number"));
+//            if (Cools.isEmpty(orders)) {
+//                return;
+//            }
+//            Map<String, Object> json = new HashMap<>();
+//            List<UploadCancelResult> list = new ArrayList<>();
+//            for (CustOrder custOrder : custOrders) {
+//                UploadCancelResult result = new UploadCancelResult();
+//                result.setNumber(custOrder.getNumber());
+//                result.setUserCode(custOrder.getUserCode());
+//                result.setQty(custOrder.getTotal());
+//                result.setStatus(1);
+//                list.add(result);
+//            }
+//            json.put("data", list);
+//            String response = new HttpHandler.Builder()
+//                    .setUri(URI)
+//                    .setPath(UPLOAD_CANCEL_RESULT)
+//                    .setJson(JSON.toJSONString(json))
+//                    .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;
+//                }
+//                for (UploadCancelResult result1 : list) {
+//                    // 杞巻鍙叉。
+//                    int save = custOrderMapper.saveLog(result1.getNumber(), result1.getUserCode());
+//                    if (save > 0) {
+//                        if (custOrderMapper.delete(new EntityWrapper<CustOrder>().eq("number", result1.getNumber()).eq("user_code", result1.getUserCode())) == 0) {
+//                            throw new CoolException("鍒犻櫎閿�鍞鍗曞け璐�");
+//                        }
+//                    }
+//                }
+//            }
+//        } catch (IOException e) {
+//            e.printStackTrace();
+//            throw new RuntimeException(e.getMessage());
+//        }
 
     }
 

--
Gitblit v1.9.1