From 1b75a7c4197d7e778f0edc132f58c7166b0cc849 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期三, 06 十二月 2023 14:39:05 +0800
Subject: [PATCH] 部门物品使用人修改
---
consum-base/src/main/java/com/consum/base/service/impl/LWhProcureModelServiceImpl.java | 20 ++++++++++++++++++++
1 files changed, 20 insertions(+), 0 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/LWhProcureModelServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/LWhProcureModelServiceImpl.java
index e2564bd..64bc8de 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/LWhProcureModelServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/LWhProcureModelServiceImpl.java
@@ -10,6 +10,7 @@
import com.consum.base.core.WhBusinessEnum;
import com.consum.base.core.utils.MapUtils;
import com.consum.base.core.utils.MapperUtil;
+import com.consum.base.pojo.dto.GoodModelInfoDTO;
import com.consum.base.pojo.response.GoodsTemplateCountVO;
import com.consum.base.service.LWhProcureModelService;
import com.consum.model.po.LWhProcureModel;
@@ -137,4 +138,23 @@
}
return goodsTemplateCount;
}
+
+ @Override
+ public List<GoodModelInfoDTO> getGoodsModelListByBusinessId(Long businessId) {
+ // 鏌ヨ鍨嬪彿鍒楄〃淇℃伅
+ List<GoodModelInfoDTO> goodsModelList = Lists.newArrayList();
+ String sql =
+ "SELECT bgt.id baseGoodsTemplateId,pm.id,CATEGORY_ID,CATEGORY_NAME,GOODS_NAME baseGoodsName,pm.BASE_GOODS_MODELS_NAME,bgm.UNIT,COUNTS,total_amount "
+ + "FROM l_wh_procure_model pm LEFT JOIN base_goods_models bgm ON bgm.id = pm.BASE_GOODS_MODELS_ID "
+ + "LEFT JOIN base_goods_template bgt ON bgt.id = bgm.GOODS_TEMPLATES_ID "
+ + "WHERE pm.BUSINESS_ID = :businessId";
+ Map<String, Object> paramMap = new HashMap<>();
+ paramMap.put("businessId", businessId);
+ List<Map<String, Object>> modelList = select(sql, paramMap, new MapperUtil());
+ modelList.forEach(item -> {
+ GoodModelInfoDTO goodsModelVO = MapUtils.convertMapToObj(item, GoodModelInfoDTO.class);
+ goodsModelList.add(goodsModelVO);
+ });
+ return goodsModelList;
+ }
}
--
Gitblit v1.9.1