From 62b6a7fac3f2acde70b578431147c4a01f19c182 Mon Sep 17 00:00:00 2001
From: 黎星凯 <13949086503@163.com>
Date: 星期一, 15 四月 2024 09:07:05 +0800
Subject: [PATCH] bug修改

---
 consum-base/src/main/java/com/consum/base/service/LWhProcureModelService.java |   68 ++++++++++++++++++---------------
 1 files changed, 37 insertions(+), 31 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/service/LWhProcureModelService.java b/consum-base/src/main/java/com/consum/base/service/LWhProcureModelService.java
index 83e813c..d277ec3 100644
--- a/consum-base/src/main/java/com/consum/base/service/LWhProcureModelService.java
+++ b/consum-base/src/main/java/com/consum/base/service/LWhProcureModelService.java
@@ -1,42 +1,48 @@
 package com.consum.base.service;
 
-import com.consum.base.core.WhBusinessEnum;
-import com.consum.model.po.LWhProcureModel;
-import com.walker.jdbc.service.BaseServiceImpl;
-import org.springframework.stereotype.Service;
-
-import java.util.HashMap;
 import java.util.List;
+import java.util.Map;
 
-/**
- * @ClassName LWhProcureModelService
+import com.consum.base.core.WhBusinessEnum;
+import com.consum.base.pojo.dto.GoodModelInfoDTO;
+import com.consum.base.pojo.response.GoodsTemplateCountVO;
+import com.consum.model.po.LWhProcureModel;
+import com.walker.jdbc.service.BaseService;
 
- * @Date 2023/10/24
- * @Description
- * @Version 1.0
- **/
-@Service
-public class LWhProcureModelService extends BaseServiceImpl {
+public interface LWhProcureModelService extends BaseService {
 
-    private static String GET_MODEL_BY_FORM = "SELECT * FROM L_WH_PROCURE_MODEL WHERE 1=1 ";
+    List<LWhProcureModel> getModelByForm(WhBusinessEnum businessType, Long businessId);
+
+    List<Map<String, Object>> getFfOrderByGoodsIdAndDept(Long goodsTemplateId, Long departmentId);
+
+    List<Map<String, Object>> getGoodsUseInfoByFfOrderAndGoodId(Long goodsTemplateId, Long transBusinessId);
 
     /**
-     * 閫氳繃鍗曟嵁绫诲瀷 鍗曟嵁ID鏌ヨ璇ヨ鍗曞叧鑱旂殑璁惧鍨嬪彿浠ュ強鏁伴噺
-     *
+     * 缁熻鍟嗗搧鍨嬪彿鏁伴噺
+     * 
+     * @param businessId
      * @return
      */
-    public List<LWhProcureModel> getModelByForm(WhBusinessEnum businessType, Long businessId) {
-        StringBuilder sql = new StringBuilder(GET_MODEL_BY_FORM);
-        HashMap<String, Object> paramts = new HashMap<>();
-        //椤圭洰闃舵id
-        if (businessType != null) {
-            sql.append(" and BUSINESS_TYPE=:businessType ");
-            paramts.put("businessType", businessType.getValue());
-        }
-        if (businessId != null) {
-            sql.append(" and BUSINESS_ID=:businessId ");
-            paramts.put("businessId", businessId);
-        }
-        return this.select(sql.toString(), paramts, new LWhProcureModel());
-    }
+    List<GoodsTemplateCountVO> getGoodsTemplateCountByBusinessId(Long businessId);
+
+    /**
+     * 缁熻閲囪喘鍗曠墿鍝佸瀷鍙锋暟閲�
+     * 
+     * @param businessId
+     * @return
+     */
+    List<GoodsTemplateCountVO> getProcureCountByBusinessId(Long businessId);
+
+    /**
+     * 鏍规嵁涓氬姟id鏌ヨ鍨嬪彿淇℃伅鍒楄〃
+     *
+     * @param businessId
+     * @param procureGoodId
+     * @return
+     */
+    List<GoodModelInfoDTO> getGoodsModelListByBusinessId(Long businessId, Long procureGoodId);
+
+    List<LWhProcureModel> getModelByForm1(WhBusinessEnum whBusinessEnum, Long whFormProcureId);
+
+
 }

--
Gitblit v1.9.1