From f6fe0d19ee37b337c5dcd464e234996f382ecdba Mon Sep 17 00:00:00 2001 From: cuijian <cuijian@xalxzn.com> Date: 星期三, 28 五月 2025 10:23:14 +0800 Subject: [PATCH] 入库申请sql调整 --- lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundDetailServiceImpl.java | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundDetailServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundDetailServiceImpl.java index c40515c..fa7dd8c 100644 --- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundDetailServiceImpl.java +++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/InboundDetailServiceImpl.java @@ -40,6 +40,11 @@ if (StringUtils.isNotBlank(inboundOrderId)) { queryWrapper.eq("t1.in_storehouse_id", inboundOrderId); } + String classifyId = query.get("classifyId"); + if (StringUtils.isNotBlank(classifyId)) { + queryWrapper.eq("t6.id", classifyId); + } + queryWrapper.eq("t2.order_status", "3"); // 鎺掑簭鍐欐硶 List<OrderItem> orderItems = new ArrayList<>(); orderItems.add(OrderItem.desc("t1.create_time")); -- Gitblit v1.9.3