From 5d745c2c8854d2c1e94e5ee9004d5219681f6d7c Mon Sep 17 00:00:00 2001 From: 石广澎 <shiguangpeng@163.com> Date: 星期五, 29 十二月 2023 11:02:50 +0800 Subject: [PATCH] 增加图片验证码和登录日志 --- consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java | 9 ++++++--- 1 files changed, 6 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..7155ab3 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,17 @@ } @Override - public List<GoodsInfoDTO> queryGoodsInfo(Set<Long> baseModelIds) { + public List<GoodsInfoDTO> queryGoodsInfo(Set<Long> baseModelIds, Set<Long> wareHouseIds) { 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 BUY_TYPE =1 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); + } + 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