From a7a6b5d7ed7b6e5b96866b24fd1cb7ba3dcc19d1 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期三, 22 十一月 2023 14:24:47 +0800
Subject: [PATCH] feat: 物品统计前后端
---
consum-base/src/main/java/com/consum/base/service/LWhWarningConfigServiceImpl.java | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/LWhWarningConfigServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LWhWarningConfigServiceImpl.java
index a5b8bda..f29fd2e 100644
--- a/consum-base/src/main/java/com/consum/base/service/LWhWarningConfigServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/LWhWarningConfigServiceImpl.java
@@ -46,7 +46,7 @@
paramts.put("warehouseType", param.getWarehouseType());
}
if (param.getBaseWarehouseId() != null) {
- sql.append(" AND wareConf.WAREHOUSE_ID = :warehouseId");
+ sql.append(" AND wareConf.BASE_WAREHOUSE_ID = :warehouseId");
paramts.put("warehouseId", param.getBaseWarehouseId());
}
//鐗╁搧鍚嶇О
@@ -54,6 +54,10 @@
sql.append(" AND goodsTemp.GOODS_NAME like :goodsTemplateName");
paramts.put("goodsTemplateName", StringUtils.CHAR_PERCENT + param.getGoodsTemplateName() + StringUtils.CHAR_PERCENT);
}
+ if (param.getBaseGoodsTemplateId() != null) {
+ sql.append(" AND wareConf.BASE_GOODS_TEMPLATE_ID=:baseGoodsTemplateId");
+ paramts.put("baseGoodsTemplateId", param.getBaseGoodsTemplateId());
+ }
//鍒嗙被
if (param.getCategoryId() != null) {
sql.append(" AND cate.id=:categoryId");
--
Gitblit v1.9.1