From ed6c6350015d52ea1cb033c7558f72b721ece84a Mon Sep 17 00:00:00 2001 From: WangHan <wwh_work@126,com> Date: 星期四, 19 十二月 2024 19:58:55 +0800 Subject: [PATCH] 打包名称修改,去除错误输出 --- 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