From 8fc8b4788ed8be27ff6aae1cdd3fe9a584972ae3 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期三, 22 十一月 2023 18:41:05 +0800
Subject: [PATCH] feat: 物品统计;库存预警模板下载、上传、下载异常文件

---
 consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java |   17 ++---------------
 1 files changed, 2 insertions(+), 15 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java b/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java
index cc8c3f9..a6acc2f 100644
--- a/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java
+++ b/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java
@@ -439,21 +439,8 @@
     public ResponseValue queryDepartmentTransferOrder(Long agencyId) {
 
         TransferInfoVO transferInfoVO = new TransferInfoVO();
-        String sql = "SELECT ft.id,\n"
-            + "       ft.BUSINESS_FORM_CODE,\n"
-            + "       gr.GOODS_TEMPLATE_NAME,\n"
-            + "       gr.BASE_GOODS_TEMPLATE_ID,\n"
-            + "       ft.CREATE_TIME\n"
-            + "\n"
-            + "FROM l_wh_form_transfer ft\n"
-            + "         LEFT JOIN L_WAREHOUSE_FLOW wf ON ft.id = wf.BUSINESS_FORM_ID\n"
-            + "         left join L_WH_GOODS_RECORD gr on gr.WAREHOUSE_FLOW_ID = wf.id\n"
-            + "         LEFT JOIN L_GOODS_WH_RECORD gwr on gwr.WAREHOUSE_FLOW_ID = wf.id\n"
-            + "         left join L_WH_GOODS g on g.id = gwr.WH_GOODS_ID\n"
-            + "\n"
-            + "\n"
-            + "\n"
-            + "\n";
+
+        lWhFormTransferService.queryDepartmentTransferOrder();
         return ResponseValue.success(transferInfoVO);
     }
 }

--
Gitblit v1.9.1