From 312e24f10492fdf99534946df068ba5b1a8331bd Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期一, 30 三月 2026 15:15:45 +0800
Subject: [PATCH] ERP单据对接
---
src/main/java/com/zy/asrs/task/handler/OrderSyncHandler.java | 374 +++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 349 insertions(+), 25 deletions(-)
diff --git a/src/main/java/com/zy/asrs/task/handler/OrderSyncHandler.java b/src/main/java/com/zy/asrs/task/handler/OrderSyncHandler.java
index e611ccf..750920d 100644
--- a/src/main/java/com/zy/asrs/task/handler/OrderSyncHandler.java
+++ b/src/main/java/com/zy/asrs/task/handler/OrderSyncHandler.java
@@ -2,25 +2,35 @@
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
+import com.core.common.Cools;
import com.core.common.DateUtils;
import com.core.exception.CoolException;
+import com.zy.asrs.entity.DocType;
import com.zy.asrs.entity.Order;
import com.zy.asrs.entity.OrderDetl;
+import com.zy.asrs.entity.u8.ReportU8Vo;
+import com.zy.asrs.entity.u8.U8ResultVo;
+import com.zy.asrs.mapper.OrderMapper;
+import com.zy.asrs.service.ApiLogService;
+import com.zy.asrs.service.DocTypeService;
import com.zy.asrs.service.OrderDetlService;
import com.zy.asrs.service.OrderService;
import com.zy.asrs.task.AbstractHandler;
import com.zy.asrs.task.core.ReturnT;
import com.zy.common.constant.MesConstant;
import com.zy.common.model.MesPakinParam;
+import com.zy.common.model.MesPakoutParam;
import com.zy.common.utils.HttpHandler;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
-import org.springframework.transaction.interceptor.TransactionAspectSupport;
-import java.util.List;
+import javax.annotation.Resource;
+import java.text.SimpleDateFormat;
+import java.util.*;
+import java.util.stream.Collectors;
/**
* Created by vincent on 2020/7/7
@@ -35,42 +45,356 @@
private OrderService orderService;
@Autowired
private OrderDetlService orderDetlService;
+ @Autowired
+ private ApiLogService apiLogService;
+ @Autowired
+ private DocTypeService docTypeService;
+
+ private static final String baseUrl = "127.0.0.1:8081/jsjwms/open/asrs";
+ private static final Map<String, String> pathMap = new HashMap<String, String>() {{
+ put("閲囪喘鍏ュ簱", "/purchasein_import");
+ put("閿�鍞嚭搴�", "/saleout_import");
+ put("浜ф垚鍝佸叆搴撳崟", "/productin_import");
+ put("鏉愭枡鍑哄簱鍗�", "/materialout_import");
+ put("鍏朵粬鍏ュ簱鍗�", "/otherin_import");
+ put("鍏朵粬鍑哄簱鍗�", "/otherout_import");
+ }};
+ @Resource
+ private OrderMapper orderMapper;
@Transactional
public ReturnT<String> start(Order order) {
- List<OrderDetl> orderDetls = orderDetlService.selectByOrderId(order.getId());
-
- MesPakinParam pakinParam = new MesPakinParam();
- pakinParam.setPakinTime(DateUtils.convert(order.getUpdateTime()));
- pakinParam.setLgortFrom("5008");
- pakinParam.setLgortTo("5006");
- for (OrderDetl orderDetl : orderDetls) {
- pakinParam.getList().add(new MesPakinParam.Detl(orderDetl.getMatnr(), orderDetl.getAnfme()));
+ DocType docType = docTypeService.selectById(order.getDocType());
+ if (null == docType) {
+ return SUCCESS;
}
-
- try {
- String response = new HttpHandler.Builder()
+ List<OrderDetl> orderDetls = orderDetlService.selectByOrderId(order.getId());
+ // 鍏ュ簱瀹屾垚涓婃姤
+ if (docType.getPakin() == 1) {
+ MesPakinParam pakinParam = new MesPakinParam();
+ pakinParam.setPakinTime(DateUtils.convert(order.getUpdateTime()));
+ pakinParam.setLgortFrom("5008");
+ pakinParam.setLgortTo("5006");
+ for (OrderDetl orderDetl : orderDetls) {
+ String serial = Cools.isEmpty(orderDetl.getBatch()) ? "" : orderDetl.getBatch();
+ pakinParam.getList().add(new MesPakinParam.Detl(orderDetl.getMatnr() + (Cools.isEmpty(serial) ? "" : "-" + serial), orderDetl.getAnfme()));
+ }
+ String response = "";
+ boolean success = false;
+ try {
+ response = new HttpHandler.Builder()
.setUri(MesConstant.URL)
.setPath(MesConstant.PAKIN_URL)
.setJson(JSON.toJSONString(pakinParam))
.build()
.doPost();
- JSONObject jsonObject = JSON.parseObject(response);
- if (jsonObject.getInteger("code").equals(200)) {
- // 淇敼璁㈠崟鐘舵�� 4.瀹屾垚 ===>> 6.宸蹭笂鎶�
- if (!orderService.updateSettle(order.getId(), 6L, null)) {
- throw new CoolException("鏈嶅姟鍣ㄥ唴閮ㄩ敊璇紝璇疯仈绯荤鐞嗗憳");
+ JSONObject jsonObject = JSON.parseObject(response);
+ if (jsonObject.getInteger("code").equals(200)) {
+ success = true;
+ // 淇敼璁㈠崟鐘舵�� 4.瀹屾垚 ===>> 6.宸蹭笂鎶�
+ if (!orderService.updateSettle(order.getId(), 6L, null)) {
+ throw new CoolException("鏈嶅姟鍣ㄥ唴閮ㄩ敊璇紝璇疯仈绯荤鐞嗗憳");
+ }
+ } else {
+ log.error("璇锋眰鎺ュ彛澶辫触锛侊紒锛乽rl锛歿}锛況equest锛歿}锛況esponse锛歿}", MesConstant.URL+MesConstant.PAKIN_URL, JSON.toJSONString(pakinParam), response);
+ throw new CoolException("涓婃姤mes绯荤粺澶辫触");
}
- } else {
- log.error("璇锋眰鎺ュ彛澶辫触锛侊紒锛乽rl锛歿}锛況equest锛歿}锛況esponse锛歿}", MesConstant.URL+MesConstant.PAKIN_URL, JSON.toJSONString(pakinParam), response);
- throw new CoolException("涓婃姤mes绯荤粺澶辫触");
+ } catch (Exception e) {
+ log.error("fail", e);
+// TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
+ return FAIL.setMsg(e.getMessage());
+ } finally {
+ try {
+ // 淇濆瓨鎺ュ彛鏃ュ織
+ apiLogService.save(
+ "鎴愬搧搴撳叆搴撲笂鎶�",
+ MesConstant.URL + MesConstant.PAKIN_URL,
+ null,
+ "127.0.0.1",
+ JSON.toJSONString(pakinParam),
+ response,
+ success
+ );
+ } catch (Exception e) { log.error("", e); }
}
- } catch (Exception e) {
- log.error("fail", e);
- TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
- return FAIL.setMsg(e.getMessage());
+ }
+ // 鍑哄簱瀹屾垚涓婃姤
+ if (docType.getPakout() == 1) {
+ MesPakoutParam pakoutParam = new MesPakoutParam();
+ pakoutParam.setTag(!order.getDocType$().equalsIgnoreCase("鎵嬪姩鍑哄簱鍗�"));
+ pakoutParam.setPakoutTime(DateUtils.convert(order.getUpdateTime()));
+ pakoutParam.setLgortFrom("5006");
+ pakoutParam.setLgortTo("1111");
+ if (!pakoutParam.isTag()) {
+ pakoutParam.setKunnr("C1000");
+ }
+ pakoutParam.setOrderNo(order.getOrderNo());
+ for (OrderDetl orderDetl : orderDetls) {
+ String serial = Cools.isEmpty(orderDetl.getBatch()) ? "" : orderDetl.getBatch();
+ pakoutParam.getList().add(new MesPakoutParam.Detl(orderDetl.getMatnr() + (Cools.isEmpty(serial) ? "" : "-" + serial), orderDetl.getAnfme()));
+ }
+ String response = "";
+ boolean success = false;
+ try {
+ response = new HttpHandler.Builder()
+ .setUri(MesConstant.URL)
+ .setPath(MesConstant.PAKOUT_URL)
+ .setJson(JSON.toJSONString(pakoutParam))
+ .build()
+ .doPost();
+ JSONObject jsonObject = JSON.parseObject(response);
+ if (jsonObject.getInteger("code").equals(200)) {
+ success = true;
+ // 淇敼璁㈠崟鐘舵�� 4.瀹屾垚 ===>> 6.宸蹭笂鎶�
+ if (!orderService.updateSettle(order.getId(), 6L, null)) {
+ throw new CoolException("鏈嶅姟鍣ㄥ唴閮ㄩ敊璇紝璇疯仈绯荤鐞嗗憳");
+ }
+ } else {
+ log.error("璇锋眰鎺ュ彛澶辫触锛侊紒锛乽rl锛歿}锛況equest锛歿}锛況esponse锛歿}", MesConstant.URL+MesConstant.PAKOUT_URL, JSON.toJSONString(pakoutParam), response);
+ throw new CoolException("涓婃姤mes绯荤粺澶辫触");
+ }
+ } catch (Exception e) {
+ log.error("fail", e);
+// TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
+ return FAIL.setMsg(e.getMessage());
+ } finally {
+ try {
+ // 淇濆瓨鎺ュ彛鏃ュ織
+ apiLogService.save(
+ "鎴愬搧搴撳嚭搴撲笂鎶�",
+ MesConstant.URL + MesConstant.PAKOUT_URL,
+ null,
+ "127.0.0.1",
+ JSON.toJSONString(pakoutParam),
+ response,
+ success
+ );
+ } catch (Exception e) { log.error("", e); }
+ }
}
return SUCCESS;
}
+ public void startNew(Map.Entry<String, List<Order>> orderMap) {
+ String docName = orderMap.getKey();
+ List<Order> value = orderMap.getValue();
+ String path = pathMap.get(docName);
+ if (path == null) {
+ log.info("鍗曟嵁绫诲瀷涓嶅瓨鍦細{}", docName);
+ return;
+ }
+ // 鏋勯�犺姹備綋
+ List<ReportU8Vo> requestBody = getRequestBody(docName, value);
+ String requestJson = JSONObject.toJSONString(requestBody);
+ String response = "";
+ boolean success = false;
+ String errorMsg = null;
+ String url = baseUrl + path;
+ String nameSpaces = "鍗曟嵁涓婃姤";
+ try {
+ response = new HttpHandler.Builder()
+ .setUri(baseUrl)
+ .setPath(path)
+ .setJson(requestJson)
+ .build()
+ .doPost();
+ List<U8ResultVo> list = JSON.parseArray(response, U8ResultVo.class);
+ if (list != null && list.size() != 0) {
+ List<String> successReceiptNos = list.stream().filter(u8ResultVo -> "T".equals(u8ResultVo.getResult())).map(U8ResultVo::getReceiptNo).collect(Collectors.toList());
+ if (!successReceiptNos.isEmpty()) {
+ orderMapper.batchUpdateSettleByOrderNos(successReceiptNos);
+ }
+ log.info("鍗曟嵁涓婃姤鎴愬姛锛屽崟鎹紪鍙凤細{}", successReceiptNos);
+ success = true;
+ } else {
+ errorMsg = response;
+ log.error(nameSpaces + "璋冪敤澶栭儴鎺ュ彛澶辫触锛寀rl锛歿}锛宺equest锛歿}锛宺esponse锛歿}", url, requestJson, response);
+ }
+ } catch (Exception e) {
+ errorMsg = e.getMessage();
+ log.error(nameSpaces + "璋冪敤澶栭儴鎺ュ彛寮傚父锛寀rl锛歿}锛宺equest锛歿}锛宺esponse锛歿}", url, requestJson, response, e);
+ } finally {
+ try {
+ apiLogService.save(
+ nameSpaces,
+ url,
+ null,
+ "127.0.0.1",
+ requestJson,
+ response,
+ success,
+ errorMsg
+ );
+ } catch (Exception e) {
+ log.error(nameSpaces + "淇濆瓨鎺ュ彛鏃ュ織澶辫触", e);
+ }
+ }
+ }
+
+ private List<ReportU8Vo> getRequestBody(String docName, List<Order> value) {
+ List<ReportU8Vo> list = new ArrayList<>();
+ String now = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
+ switch (docName) {
+ case "閲囪喘鍏ュ簱":
+ for (Order order : value) {
+ ReportU8Vo reportU8Vo = new ReportU8Vo();
+ reportU8Vo.setCaccid("001");
+ reportU8Vo.setCvouchcode(order.getOrderNo());
+ reportU8Vo.setDdate(now);
+ reportU8Vo.setCgltype(order.getDocType$());
+ reportU8Vo.setCwhcode("103");
+ reportU8Vo.setCrdcode("101");
+ reportU8Vo.setCmaker(order.getCreateBy$());
+ reportU8Vo.setChandler(order.getUpdateBy$());
+ List<ReportU8Vo.Item> itemList = new ArrayList<>();
+ List<OrderDetl> orderDetlList = orderDetlService.selectByOrderId(order.getId());
+ String docType$ = order.getDocType$();
+ for (OrderDetl orderDetl : orderDetlList) {
+ ReportU8Vo.Item item = new ReportU8Vo.Item();
+ item.setCinvcode(orderDetl.getMatnr());
+ item.setIquantity(orderDetl.getQty());
+ item.setAutoidPo(orderDetl.getSku());
+ item.setPoautoidcol(docType$.equals("閲囪喘璁㈠崟") ? "ID" : docType$.equals("閲囪喘鍒拌揣鍗�") || docType$.equals("濮斿鍒拌揣鍗�") ? "Autoid" :
+ docType$.equals("濮斿璁㈠崟") ? "MODetailsID" : "");
+ item.setCbatch(orderDetl.getBatch());
+ itemList.add(item);
+ }
+ reportU8Vo.setDetailList(itemList);
+ list.add(reportU8Vo);
+ }
+ break;
+ case "閿�鍞嚭搴�":
+ for (Order order : value) {
+ ReportU8Vo reportU8Vo = new ReportU8Vo();
+ reportU8Vo.setCaccid("001");
+ reportU8Vo.setCvouchcode(order.getOrderNo());
+ reportU8Vo.setDdate(now);
+ reportU8Vo.setCgltype(order.getDocType$());
+ reportU8Vo.setCwhcode("101");
+ reportU8Vo.setCrdcode("201");
+ reportU8Vo.setCmaker(order.getCreateBy$());
+ reportU8Vo.setChandler(order.getUpdateBy$());
+ List<ReportU8Vo.Item> itemList = new ArrayList<>();
+ List<OrderDetl> orderDetlList = orderDetlService.selectByOrderId(order.getId());
+ String docType$ = order.getDocType$();
+ for (OrderDetl orderDetl : orderDetlList) {
+ ReportU8Vo.Item item = new ReportU8Vo.Item();
+ item.setCinvcode(orderDetl.getMatnr());
+ item.setIquantity(orderDetl.getQty());
+ item.setAutoidSo(orderDetl.getSku());
+ item.setSoautoidcol(docType$.equals("鍙戣揣鍗�") ? "IDLSID" : "");
+ item.setCbatch(orderDetl.getBatch());
+ itemList.add(item);
+ }
+ reportU8Vo.setDetailList(itemList);
+ list.add(reportU8Vo);
+ }
+ break;
+ case "浜ф垚鍝佸叆搴撳崟":
+ for (Order order : value) {
+ ReportU8Vo reportU8Vo = new ReportU8Vo();
+ reportU8Vo.setCaccid("001");
+ reportU8Vo.setCvouchcode(order.getOrderNo());
+ reportU8Vo.setDdate(now);
+ reportU8Vo.setCgltype(order.getDocType$());
+ reportU8Vo.setCwhcode("101");
+ reportU8Vo.setCrdcode("201");
+ reportU8Vo.setCmaker(order.getCreateBy$());
+ reportU8Vo.setChandler(order.getUpdateBy$());
+ List<ReportU8Vo.Item> itemList = new ArrayList<>();
+ List<OrderDetl> orderDetlList = orderDetlService.selectByOrderId(order.getId());
+ for (OrderDetl orderDetl : orderDetlList) {
+ ReportU8Vo.Item item = new ReportU8Vo.Item();
+ item.setCinvcode(orderDetl.getMatnr());
+ item.setIquantity(orderDetl.getQty());
+ item.setAutoidMo(orderDetl.getSku());
+ item.setMoautoidcol("MODID");
+ item.setCbatch(orderDetl.getBatch());
+ itemList.add(item);
+ }
+ reportU8Vo.setDetailList(itemList);
+ list.add(reportU8Vo);
+ }
+ break;
+ case "鏉愭枡鍑哄簱鍗�":
+ for (Order order : value) {
+ ReportU8Vo reportU8Vo = new ReportU8Vo();
+ reportU8Vo.setCaccid("001");
+ reportU8Vo.setCvouchcode(order.getOrderNo());
+ reportU8Vo.setDdate(now);
+ reportU8Vo.setCgltype(order.getDocType$());
+ reportU8Vo.setCwhcode("5");
+ reportU8Vo.setCrdcode("202");
+ reportU8Vo.setCmaker(order.getCreateBy$());
+ reportU8Vo.setChandler(order.getUpdateBy$());
+ List<ReportU8Vo.Item> itemList = new ArrayList<>();
+ List<OrderDetl> orderDetlList = orderDetlService.selectByOrderId(order.getId());
+ String docType$ = order.getDocType$();
+ for (OrderDetl orderDetl : orderDetlList) {
+ ReportU8Vo.Item item = new ReportU8Vo.Item();
+ item.setCinvcode(orderDetl.getMatnr());
+ item.setIquantity(orderDetl.getQty());
+ item.setAutoidAll(orderDetl.getSku());
+ item.setAllcautoidcol(docType$.equals("鐢熶骇璁㈠崟") ? "AllocateId" : docType$.equals("濮斿璁㈠崟") ? "MOMaterialsID" :
+ docType$.equals("棰嗘枡鐢宠鍗�") ? "AutoID" : "");
+ item.setCbatch(orderDetl.getBatch());
+ itemList.add(item);
+ }
+ reportU8Vo.setDetailList(itemList);
+ list.add(reportU8Vo);
+ }
+ break;
+ case "鍏朵粬鍏ュ簱鍗�":
+ for (Order order : value) {
+ ReportU8Vo reportU8Vo = new ReportU8Vo();
+ reportU8Vo.setCaccid("001");
+ reportU8Vo.setCvouchcode(order.getOrderNo());
+ reportU8Vo.setDdate(now);
+ reportU8Vo.setCgltype(order.getDocType$());
+ reportU8Vo.setCwhcode("109");
+ reportU8Vo.setCrdcode("199");
+ reportU8Vo.setCmaker(order.getCreateBy$());
+ reportU8Vo.setChandler(order.getUpdateBy$());
+ List<ReportU8Vo.Item> itemList = new ArrayList<>();
+ List<OrderDetl> orderDetlList = orderDetlService.selectByOrderId(order.getId());
+ for (OrderDetl orderDetl : orderDetlList) {
+ ReportU8Vo.Item item = new ReportU8Vo.Item();
+ item.setCinvcode(orderDetl.getMatnr());
+ item.setIquantity(orderDetl.getQty());
+ item.setCbatch(orderDetl.getBatch());
+ itemList.add(item);
+ }
+ reportU8Vo.setDetailList(itemList);
+ list.add(reportU8Vo);
+ }
+ break;
+ case "鍏朵粬鍑哄簱鍗�":
+ for (Order order : value) {
+ ReportU8Vo reportU8Vo = new ReportU8Vo();
+ reportU8Vo.setCaccid("001");
+ reportU8Vo.setCvouchcode(order.getOrderNo());
+ reportU8Vo.setDdate(now);
+ reportU8Vo.setCgltype(order.getDocType$());
+ reportU8Vo.setCwhcode("109");
+ reportU8Vo.setCrdcode("299");
+ reportU8Vo.setCmaker(order.getCreateBy$());
+ reportU8Vo.setChandler(order.getUpdateBy$());
+ List<ReportU8Vo.Item> itemList = new ArrayList<>();
+ List<OrderDetl> orderDetlList = orderDetlService.selectByOrderId(order.getId());
+ for (OrderDetl orderDetl : orderDetlList) {
+ ReportU8Vo.Item item = new ReportU8Vo.Item();
+ item.setCinvcode(orderDetl.getMatnr());
+ item.setIquantity(orderDetl.getQty());
+ item.setCbatch(orderDetl.getBatch());
+ itemList.add(item);
+ }
+ reportU8Vo.setDetailList(itemList);
+ list.add(reportU8Vo);
+ }
+ break;
+ default:
+ }
+ return list;
+ }
+
}
--
Gitblit v1.9.1