From 6cfff55d44314e88fefd6e3adb290ec16b303f89 Mon Sep 17 00:00:00 2001
From: 黎星凯 <13949086503@163.com>
Date: 星期五, 05 一月 2024 10:42:53 +0800
Subject: [PATCH] 1、供产品导数据临时用(用户，机构，部门，仓库，库管员 可删) 2、选择库管员增加过滤参数
---
consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java | 13 ++++++++++---
1 files changed, 10 insertions(+), 3 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java
index ca7e7f4..6c21f27 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java
@@ -354,14 +354,21 @@
}
@Override
- public List<GoodsInfoDTO> queryGoodsInfo(Set<Long> baseModelIds) {
+ public List<GoodsInfoDTO> queryGoodsInfo(Set<Long> baseModelIds, Set<Long> wareHouseIds,Integer buyType) {
List<GoodsInfoDTO> goodsInfoDTOS = Lists.newArrayList();
StringBuilder sql = new StringBuilder(
"SELECT distinct WAREHOUSE_ID,WAREHOUSE_NAME from L_WH_GOODS where base_goods_models_id in (:baseGoodsModelsIds) "
- + "and WAREHOUSE_TYPE =0 and BUY_TYPE =1 and states =1");
+ + "and WAREHOUSE_TYPE =0 and states =1 and WAREHOUSE_ID in (:wareHouseIds) ");
Map<String, Object> param = new HashMap<>();
- param.put("baseGoodsModelsIds", baseModelIds);
+ if (!CollectionUtils.isEmpty(baseModelIds)) {
+ param.put("baseGoodsModelsIds", baseModelIds);
+ }
+ if (buyType != null) {
+ sql.append("and BUY_TYPE =:buyType ");
+ param.put("buyType", buyType);
+ }
+ param.put("wareHouseIds", wareHouseIds);
List<Map<String, Object>> result = this.select(sql.toString(), param, new MapperUtil());
result.forEach(item -> {
GoodsInfoDTO goodsInfoDTO = MapUtils.convertMapToObj(item, GoodsInfoDTO.class);
--
Gitblit v1.9.1