From dc1800d4d2d252b7b37d80d9f54285200c94ff3c Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期三, 15 十一月 2023 19:34:40 +0800
Subject: [PATCH] 出库单管理

---
 consum-base/src/main/java/com/consum/base/controller/BaseGoodsTemplateController.java |   61 ++++++++++++++++++++++++++++--
 1 files changed, 56 insertions(+), 5 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/controller/BaseGoodsTemplateController.java b/consum-base/src/main/java/com/consum/base/controller/BaseGoodsTemplateController.java
index a9747e1..27c9099 100644
--- a/consum-base/src/main/java/com/consum/base/controller/BaseGoodsTemplateController.java
+++ b/consum-base/src/main/java/com/consum/base/controller/BaseGoodsTemplateController.java
@@ -1,17 +1,29 @@
 package com.consum.base.controller;
 
 import com.consum.base.BaseController;
+import com.consum.base.core.utils.MapUtils;
+import com.consum.base.core.utils.MapperUtil;
 import com.consum.base.pojo.BaseGoodsTemplateParam;
+import com.consum.base.pojo.response.GoodsTemplateVO;
 import com.consum.base.service.BaseGoodsTemplateServiceImpl;
+import com.consum.base.service.BaseWarehouseServiceImpl;
+import com.consum.base.service.LWhGoodsService;
 import com.consum.model.po.BaseGoodsModels;
 import com.consum.model.po.BaseGoodsTemplate;
-import com.consum.model.po.S_dict_data;
+import com.consum.model.po.BaseWarehouse;
+import com.consum.model.po.SDictData;
 import com.consum.model.vo.BaseGoodsTemplateVo;
 import com.iplatform.model.po.S_user_core;
 import com.walker.db.page.GenericPager;
 import com.walker.infrastructure.utils.StringUtils;
 import com.walker.web.ResponseValue;
+import io.swagger.annotations.ApiImplicitParam;
+import io.swagger.annotations.ApiImplicitParams;
+import io.swagger.annotations.ApiOperation;
+import java.util.HashMap;
 import java.util.List;
+import java.util.Map;
+import org.apache.commons.compress.utils.Lists;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.util.CollectionUtils;
 import org.springframework.web.bind.annotation.DeleteMapping;
@@ -32,6 +44,12 @@
 
     @Autowired
     private BaseGoodsTemplateServiceImpl baseGoodsTemplateService;
+
+    @Autowired
+    private LWhGoodsService lWhGoodsService;
+
+    @Autowired
+    private BaseWarehouseServiceImpl baseWarehouseService;
 
     /**
      * @Description 鏂板鐗╁搧妯℃澘
@@ -151,7 +169,7 @@
      */
     @GetMapping("/select/classificationCode")
     public ResponseValue queryClassificationCode() {
-        List<S_dict_data> list = this.baseGoodsTemplateService.queryClassificationCode();
+        List<SDictData> list = this.baseGoodsTemplateService.queryClassificationCode();
         return ResponseValue.success(list);
     }
 
@@ -168,9 +186,6 @@
 
     @GetMapping("/query/goodsTemplate")
     public ResponseValue queryGoodsTemplateByCategoryId(Long agencyId, Long categoryId) {
-//        if (agencyId == null) {
-//            return ResponseValue.error("鏈烘瀯id涓虹┖");
-//        }
         List<BaseGoodsTemplate> list = this.baseGoodsTemplateService.queryGoodsTemplateByCategoryId(agencyId, categoryId);
         if (list == null) {
             return ResponseValue.error("鏌ヨ澶辫触锛�");
@@ -179,5 +194,41 @@
     }
 
 
+    @ApiOperation(value = "鏌ヨ鏈烘瀯涓嬮粯璁や粨搴撲笅鐨勫垎绫绘ā鏉夸俊鎭�", notes = "鏌ヨ鏈烘瀯涓嬮粯璁や粨搴撲笅鐨勫垎绫绘ā鏉夸俊鎭�")
+    @ApiImplicitParams({
+        @ApiImplicitParam(name = "agencyId", value = "鐖剁骇鏈烘瀯id", required = true, dataType = "Long", paramType = "query"),
+        @ApiImplicitParam(name = "categoryId", value = "鍒嗙被id", required = true, dataType = "Long", paramType = "query")
+    })
+    @GetMapping("/query/warehouse/goods")
+    public ResponseValue queryWarehouseGoods(Long agencyId, Long categoryId) {
+
+        Map<String, Object> map = new HashMap<>();
+        map.put("categoryId", categoryId);
+
+        List<BaseWarehouse> baseWarehouseList = baseWarehouseService.getByAgencyId(agencyId);
+        baseWarehouseList.forEach(baseWarehouse -> {
+            Integer isDefault = baseWarehouse.getIsDefault();
+            if (isDefault == 1) {
+                map.put("warehouseId", baseWarehouse.getId());
+            }
+        });
+
+        String sql = "SELECT DISTINCT bgt.id,bgt.GOODS_NAME FROM l_wh_goods g LEFT JOIN base_goods_template bgt ON g.BASE_GOODS_TEMPLATE_ID = bgt.id "
+            + "WHERE WAREHOUSE_TYPE = 0 "
+            + "AND WAREHOUSE_ID = :warehouseId "
+            + "AND CATEGORY_ID = :categoryId "
+            // 1:闆嗛噰,2:鑷��璐�
+            + "AND BUY_TYPE =1";
+
+        List<GoodsTemplateVO> resultList = Lists.newArrayList();
+        List<Map<String, Object>> goodsTemplateList = lWhGoodsService.select(sql, map, new MapperUtil());
+        goodsTemplateList.forEach(item -> {
+            GoodsTemplateVO goodsTemplateVO = MapUtils.convertMapToObj(item, GoodsTemplateVO.class);
+            resultList.add(goodsTemplateVO);
+        });
+        return ResponseValue.success("鏌ヨ鎴愬姛!", resultList);
+    }
+
+
 }
 

--
Gitblit v1.9.1