From 3a2158fe78db763c72d5124a964d7fd7934b51ac Mon Sep 17 00:00:00 2001
From: lfd <1>
Date: 星期四, 26 三月 2026 10:44:45 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/lfdasrs' into lfdasrs
---
src/main/java/com/zy/ints/task/scheduler/LkDetTbScheduler.java | 14 ++++++++++----
1 files changed, 10 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/zy/ints/task/scheduler/LkDetTbScheduler.java b/src/main/java/com/zy/ints/task/scheduler/LkDetTbScheduler.java
index 2c347f3..e49159b 100644
--- a/src/main/java/com/zy/ints/task/scheduler/LkDetTbScheduler.java
+++ b/src/main/java/com/zy/ints/task/scheduler/LkDetTbScheduler.java
@@ -51,7 +51,7 @@
/**
* 涓婃姤鍏ュ嚭搴撳畬缁撹鍗曚俊鎭�
*/
- @Scheduled(cron = "${erp.refreshtime}")
+// @Scheduled(cron = "${erp.refreshtime}")
public void reportOrder() {
if (!erpEnabled) return;
String sqlSelectLkDetTb = "select bill_no as billNo,prd_no as prdNo,iokindid,add_id as addId,qty,prd_mark as prdMark,wh,billdate,status,temp1,temp2,temp3 from lk_det_tb where 1=1";
@@ -61,18 +61,23 @@
List<Order> orders = orderService.selectList(new EntityWrapper<Order>().eq("settle", 4L));
if (orders.size() > 0) {
for (Order order : orders) {
+
List<OrderDetl> orderDetls = orderDetlService.selectByOrderId(order.getId());
if (!Cools.isEmpty(orderDetls)) {
for (OrderDetl orderDetl : orderDetls) {
+ String orderNo = orderDetl.getOrderNo().split("---")[0];
+ Integer itm = Integer.getInteger(orderDetl.getOrderNo().split("---")[1]);
Date now = new Date();
List<LkDetTb> lkDetTbs = erpSqlServer.select(sqlSelectLkDetTb +
- " and bill_no='" + orderDetl.getOrderNo() + "'" +
+ " and bill_no='" + orderNo + "'" +
" and prd_no='" + orderDetl.getMatnr() + "'" +
+ " and ITM='" + itm + "'" +
" and prd_mark='" + orderDetl.getBatch() + "'"
, LkDetTb.class);
List<LkDetTbBak> lkDetTbBaks = erpSqlServer.select(sqlSelectLkDetTbBak +
- " and bill_no='" + orderDetl.getOrderNo() + "'" +
+ " and bill_no='" + orderNo + "'" +
" and prd_no='" + orderDetl.getMatnr() + "'" +
+ " and ITM='" + itm + "'" +
" and prd_mark='" + orderDetl.getBatch() + "'"
, LkDetTbBak.class);
if (lkDetTbs.size() == 1) {
@@ -90,8 +95,9 @@
} else {
String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(now);
HashMap<String, Object> condition = new HashMap<>();
- condition.put("bill_no", "'" + orderDetl.getOrderNo() + "'");
+ condition.put("bill_no", "'" + orderNo + "'");
condition.put("prd_no", "'" + orderDetl.getMatnr() + "'");
+ condition.put("itm", "'" + itm + "'");
DocType docType = docTypeService.selectById(order.getDocType());
if (!Cools.isEmpty(docType)) {
--
Gitblit v1.9.1