From 58a518f8bc23ed382f4da2a86b09024b063a620c Mon Sep 17 00:00:00 2001
From: 黎星凯 <13949086503@163.com>
Date: 星期一, 13 五月 2024 15:40:47 +0800
Subject: [PATCH] 20240511修改: 分发单优化， 分类，物品，分发单明细，采购单明细数据导入
---
consum-base/src/main/java/com/consum/base/service/impl/LWhFormScrappedGoodsServiceImpl.java | 27 +++++++++++++++++++++++++++
1 files changed, 27 insertions(+), 0 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/LWhFormScrappedGoodsServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/LWhFormScrappedGoodsServiceImpl.java
index e4b228f..d113f5e 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/LWhFormScrappedGoodsServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/LWhFormScrappedGoodsServiceImpl.java
@@ -1,9 +1,16 @@
package com.consum.base.service.impl;
+import java.util.HashMap;
import java.util.List;
+import java.util.Map;
+import java.util.Objects;
+import org.apache.commons.compress.utils.Lists;
import org.springframework.stereotype.Service;
+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.service.LWhFormScrappedGoodsService;
import com.consum.model.po.LWhFormScrappedGoods;
import com.walker.jdbc.service.BaseServiceImpl;
@@ -23,9 +30,29 @@
* @Author 鍗㈠簡闃�
* @Date 2023/11/2
*/
+ @Override
public List<LWhFormScrappedGoods> getByFormScrappedId(Long id) {
LWhFormScrappedGoods scrappedGoods = new LWhFormScrappedGoods();
scrappedGoods.setFormScrappedId(id);
return this.select(scrappedGoods);
}
+
+ @Override
+ public List<GoodModelInfoDTO> getScrappedGoodsByScrappedId(Long scrappedId) {
+ String sql =
+ "select fsg.id,CATEGORY_NAME,fsg.GOODS_TEMPLATE_NAME baseGoodsName,fsg.BASE_GOODS_MODELS_NAME,fsg.BASE_GOODS_TEMPLATE_ID,"
+ + "fsg.UNIT,fsg.COUNTS,SCRAPPED_NAME from l_wh_form_scrapped_goods fsg left join base_goods_template bgt on "
+ + "fsg.BASE_GOODS_TEMPLATE_ID = bgt.id where form_scrapped_id =:scrappedId ";
+ Map<String, Object> param = new HashMap<>();
+ param.put("scrappedId", scrappedId);
+ List<Map<String, Object>> select = this.select(sql, param, new MapperUtil());
+ List<GoodModelInfoDTO> goodModelInfoList = Lists.newArrayList();
+ select.forEach(item -> {
+ GoodModelInfoDTO goodModelInfoDTO = MapUtils.convertMapToObj(item, GoodModelInfoDTO.class);
+ if (Objects.nonNull(goodModelInfoDTO)) {
+ goodModelInfoList.add(goodModelInfoDTO);
+ }
+ });
+ return goodModelInfoList;
+ }
}
--
Gitblit v1.9.1