From b268fd73f060108b8214ed1afcbbf03480435f3a Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期五, 15 十二月 2023 17:27:41 +0800
Subject: [PATCH] 1.出库手续回显 2.调拨申请时库存查询更换接口 3.调拨出库时从已有物品所在的仓库中选择
---
consum-base/src/main/java/com/consum/base/service/impl/LWhGoodsServiceImpl.java | 23 +++++++++++++++++++++--
1 files changed, 21 insertions(+), 2 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 caeb70c..ca7e7f4 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
@@ -5,6 +5,7 @@
import java.util.HashMap;
import java.util.List;
import java.util.Map;
+import java.util.Set;
import java.util.stream.Collectors;
import org.apache.commons.compress.utils.Lists;
@@ -13,6 +14,7 @@
import com.consum.base.core.utils.MapUtils;
import com.consum.base.core.utils.MapperUtil;
+import com.consum.base.pojo.dto.GoodsInfoDTO;
import com.consum.base.pojo.dto.GoodsModelCountDTO;
import com.consum.base.service.LWhGoodsService;
import com.walker.infrastructure.utils.CollectionUtils;
@@ -38,7 +40,7 @@
private static String query_Goods_Model_Num = "SELECT COUNT(1) from L_WH_GOODS where 1=1";
@Override
- public int queryGoodsModelNum(Integer warehouseType, Long warehouseId, Long baseGoodsModelsId, Integer states,
+ public int queryGoodsModelNum(Integer warehouseType, List<Long> warehouseId, Long baseGoodsModelsId, Integer states,
Integer buyType) {
StringBuilder sql = new StringBuilder(query_Goods_Model_Num);
Map<String, Object> paramts = new HashMap<>();
@@ -48,7 +50,7 @@
paramts.put("warehouseType", warehouseType);
}
if (warehouseId != null) {
- sql.append(" and WAREHOUSE_ID=:warehouseId");
+ sql.append(" and WAREHOUSE_ID in (:warehouseId)");
paramts.put("warehouseId", warehouseId);
}
if (baseGoodsModelsId != null) {
@@ -350,4 +352,21 @@
return null;
}
+
+ @Override
+ public List<GoodsInfoDTO> queryGoodsInfo(Set<Long> baseModelIds) {
+
+ 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");
+ Map<String, Object> param = new HashMap<>();
+ param.put("baseGoodsModelsIds", baseModelIds);
+ List<Map<String, Object>> result = this.select(sql.toString(), param, new MapperUtil());
+ result.forEach(item -> {
+ GoodsInfoDTO goodsInfoDTO = MapUtils.convertMapToObj(item, GoodsInfoDTO.class);
+ goodsInfoDTOS.add(goodsInfoDTO);
+ });
+ return goodsInfoDTOS;
+ }
}
--
Gitblit v1.9.1