From 209d9c6f60d96fc29fad0bd2f9dad8fe8424f91f Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期五, 17 十一月 2023 18:10:47 +0800
Subject: [PATCH] 调拨管理

---
 consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java |   57 ++++++++++++++++++++++++++++++++++++++-------------------
 1 files changed, 38 insertions(+), 19 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java b/consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java
index e53939c..1881d31 100644
--- a/consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java
+++ b/consum-base/src/main/java/com/consum/base/service/LWhGoodsService.java
@@ -3,13 +3,15 @@
 import com.consum.model.po.LWhGoods;
 import com.walker.infrastructure.utils.CollectionUtils;
 import com.walker.jdbc.service.BaseServiceImpl;
+import org.apache.commons.lang3.StringUtils;
+import org.springframework.stereotype.Service;
+
+import java.math.BigDecimal;
 import java.util.ArrayList;
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
 import java.util.stream.Collectors;
-import org.apache.commons.lang3.StringUtils;
-import org.springframework.stereotype.Service;
 
 /**
  * @ClassName LWhGoodsService
@@ -31,7 +33,7 @@
      */
     private static String query_Goods_Model_Num = "SELECT COUNT(1) from L_WH_GOODS where 1=1";
 
-    public int queryGoodsModelNum(Integer warehouseType, Long warehouseId, Long baseGoodsModelsId, Short states, Short buyType) {
+    public int queryGoodsModelNum(Integer warehouseType, Long warehouseId, Long baseGoodsModelsId, Integer states, Integer buyType) {
         StringBuilder sql = new StringBuilder(query_Goods_Model_Num);
         Map<String, Object> paramts = new HashMap<>();
 
@@ -71,8 +73,8 @@
      */
     private static String QUERY_OUT_GOODS_ID = "SELECT * FROM L_WH_GOODS WHERE 1=1";
 
-    public List<Map<String, Object>> queryOutGoods(Integer warehouseType, Long warehouseId, Long baseGoodsModelsId, Short states, Short buyType,
-        Integer goodsModelNum) {
+    public List<Map<String, Object>> queryOutGoods(Integer warehouseType, Long warehouseId, Long baseGoodsModelsId, Integer states, Integer buyType,
+                                                   Integer goodsModelNum) {
         StringBuilder sql = new StringBuilder(QUERY_OUT_GOODS_ID);
         Map<String, Object> paramts = new HashMap<>();
         if (warehouseType != null) {
@@ -109,13 +111,30 @@
      * @param goodsModelNum     鍙栧嚭鐨勬暟閲�
      * @return
      */
-    public List<Long> queryOutGoodsId(Integer warehouseType, Long warehouseId, Long baseGoodsModelsId, Short states, Short buyType, Integer goodsModelNum) {
+    public List<Long> queryOutGoodsId(Integer warehouseType, Long warehouseId, Long baseGoodsModelsId, Integer states, Integer buyType, Integer goodsModelNum) {
         List<Map<String, Object>> outGoods = queryOutGoods(warehouseType, warehouseId, baseGoodsModelsId, states, buyType, goodsModelNum);
         if (CollectionUtils.isEmpty(outGoods)) {
             return null;
         }
         List<Long> whGoodsIds = outGoods.stream().map(map -> (Long) map.get("id")).collect(Collectors.toList());
         return whGoodsIds;
+    }
+
+    private static String QUERY_GOODS_PRICE_BY_ID = "SELECT sum(PRICE)totalPrice from L_WH_GOODS goods where 1=1";
+
+    public long queryGoodsPriceById(List<Long> goodsIds) {
+        StringBuilder sql = new StringBuilder(QUERY_GOODS_PRICE_BY_ID);
+        Map<String, Object> paramts = new HashMap<>();
+        if (!CollectionUtils.isEmpty(goodsIds)) {
+            sql.append(" and id in(:goodsIds)");
+            paramts.put("goodsIds", goodsIds);
+        }
+        List<Map<String, Object>> map = this.select(sql.toString(), paramts);
+        if (CollectionUtils.isEmpty(map)) {
+            return 0;
+        }
+        BigDecimal totalPrice = (BigDecimal) map.get(0).get("totalPrice");
+        return totalPrice.longValue();
     }
 
 
@@ -137,12 +156,12 @@
     private static String QUERY_SCRAPPED_GOODS_END = " ORDER BY goods.PRICE DESC,goods.PROCURE_DATE ASC,goods.id";
 
     public List<Map<String, Object>> queryScrappedGoods(Integer warehouseType,
-        Long warehouseId,
-        Long transBusinessId,
-        String nowUserName,
-        Long baseGoodsModelsId,
-        Short states,
-        Integer goodsModelNum) {
+                                                        Long warehouseId,
+                                                        Long transBusinessId,
+                                                        String nowUserName,
+                                                        Long baseGoodsModelsId,
+                                                        Short states,
+                                                        Integer goodsModelNum) {
         if (warehouseType == null) {
             warehouseType = 0;
         }
@@ -192,14 +211,14 @@
      * @return
      */
     public List<Long> queryScrappedGoodsIds(Integer warehouseType,
-        Long warehouseId,
-        Long transBusinessId,
-        String nowUserName,
-        Long baseGoodsModelsId,
-        Short states,
-        Integer goodsModelNum) {
+                                            Long warehouseId,
+                                            Long transBusinessId,
+                                            String nowUserName,
+                                            Long baseGoodsModelsId,
+                                            Short states,
+                                            Integer goodsModelNum) {
         List<Map<String, Object>> outGoods = queryScrappedGoods(warehouseType, warehouseId, transBusinessId, nowUserName, baseGoodsModelsId, states,
-            goodsModelNum);
+                goodsModelNum);
         if (CollectionUtils.isEmpty(outGoods)) {
             return null;
         }

--
Gitblit v1.9.1