From 826f7359225f036663075546f50ea1126db568d3 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期二, 21 十一月 2023 10:57:14 +0800
Subject: [PATCH] --盘点管理

---
 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