From fae8a9349499cd045bc73e8fd22aeae52618a46c Mon Sep 17 00:00:00 2001
From: WangHan <wwh_work@126,com>
Date: 星期四, 19 十二月 2024 10:02:02 +0800
Subject: [PATCH] 采购明细查询修改，查询本级及以下
---
consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java | 29 ++++++++++++++++++++++++++++-
1 files changed, 28 insertions(+), 1 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java
index 49918fb..6e1fe58 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java
@@ -1,8 +1,17 @@
package com.consum.base.service.impl;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+
+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.response.GoodsTemplateCountVO;
import com.consum.base.service.UsingFormBackModelService;
import com.walker.jdbc.service.BaseServiceImpl;
-import org.springframework.stereotype.Service;
/**
* @author asus
@@ -13,4 +22,22 @@
@Service
public class UsingFormBackModelServiceImpl extends BaseServiceImpl implements UsingFormBackModelService {
+ @Override
+ public List<GoodsTemplateCountVO> getUsingCountByBusinessId(Long businessId) {
+ List<GoodsTemplateCountVO> goodsTemplateCount = Lists.newArrayList();
+ // 缁熻鍨嬪彿鏁伴噺
+ StringBuilder countSql =
+ new StringBuilder("SELECT ufbg.BASE_GOODS_TEMPLATE_NAME,sum(ufbm.COUNTS) count,ufbm.UNIT "
+ + "FROM using_form_back_goods ufbg "
+ + "LEFT JOIN using_form_back_model ufbm ON ufbg.ID = ufbm.USING_FORM_BACK_GOODS_ID "
+ + "where ufbg.USING_FORM_BACK_ID = :businessId group by ufbg.BASE_GOODS_TEMPLATE_ID ");
+ Map<String, Object> paramMap = new HashMap<>();
+ paramMap.put("businessId", businessId);
+ List<Map<String, Object>> procureModelList = this.select(countSql.toString(), paramMap, new MapperUtil());
+ for (Map<String, Object> map : procureModelList) {
+ GoodsTemplateCountVO goodsTemplateCountVO = MapUtils.convertMapToObj(map, GoodsTemplateCountVO.class);
+ goodsTemplateCount.add(goodsTemplateCountVO);
+ }
+ return goodsTemplateCount;
+ }
}
--
Gitblit v1.9.1