From 1b8db0473522c886428767f7eeaaf7f52d47ce42 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期三, 20 十二月 2023 15:30:41 +0800
Subject: [PATCH] 1.盘带人级联 2.盘点物品为仓库内物品
---
consum-base/src/main/java/com/consum/base/service/impl/LWhFormInventoryServiceImpl.java | 20 +++++++++++++++-----
1 files changed, 15 insertions(+), 5 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/LWhFormInventoryServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/LWhFormInventoryServiceImpl.java
index 3cf6f64..9393423 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/LWhFormInventoryServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/LWhFormInventoryServiceImpl.java
@@ -342,19 +342,29 @@
return null;
}
Long warehouseId = inventory.getWarehouseId();
- Integer warehouseType = inventory.getWarehouseType();
formInventoryVO.setBusinessFormCode(inventory.getBusinessFormCode());
formInventoryVO.setBusinessFormName(inventory.getBusinessFormName());
formInventoryVO.setWarehouseId(warehouseId);
formInventoryVO.setWarehouseName(inventory.getWarehouseName());
+ // 缁熻浠撳簱鍐呯殑鐗╁搧
String sql =
- "select bgt.id baseGoodsTemplateId,bgm.id baseGoodsModelId,bgt.GOODS_NAME goodsTemplateName,bgm.MODEL_NAME baseGoodsModelsName,bgt.CLASSIFICATION type,bgm.UNIT "
- + "from base_goods_models bgm left join base_goods_template bgt on bgm.GOODS_TEMPLATES_ID = bgt.id "
- + "where bgt.AGENCY_ID = :agencyId";
+ "SELECT distinct bgt.id baseGoodsTemplateId,bgm.id baseGoodsModelId,bgt.GOODS_NAME goodsTemplateName,bgm.MODEL_NAME baseGoodsModelsName,"
+ + "bgt.CLASSIFICATION TYPE,bgm.UNIT FROM l_wh_goods g "
+ + "LEFT JOIN base_goods_template bgt ON g.BASE_GOODS_TEMPLATE_ID = bgt.ID "
+ + "LEFT JOIN base_goods_models bgm ON bgm.GOODS_TEMPLATES_ID = bgt.id WHERE "
+ + "WAREHOUSE_ID = :warehouseId ";
HashMap<String, Object> param = new HashMap<>();
- param.put("agencyId", inventory.getAgencyId());
+ param.put("warehouseId", warehouseId);
+
+ // String sql =
+ // "select bgt.id baseGoodsTemplateId,bgm.id baseGoodsModelId,bgt.GOODS_NAME goodsTemplateName,bgm.MODEL_NAME
+ // baseGoodsModelsName,bgt.CLASSIFICATION type,bgm.UNIT "
+ // + "from base_goods_models bgm left join base_goods_template bgt on bgm.GOODS_TEMPLATES_ID = bgt.id "
+ // + "where bgt.AGENCY_ID = :agencyId";
+ // HashMap<String, Object> param = new HashMap<>();
+ // param.put("agencyId", inventory.getAgencyId());
List<Map<String, Object>> result = this.select(sql, param, new MapperUtil());
List<FormInventoryGoodsVO> goodsVOList = Lists.newArrayList();
result.forEach(item -> {
--
Gitblit v1.9.1