From 13b0bad30ef1df53492cbab1c1b99dfc02dee63f Mon Sep 17 00:00:00 2001 From: haoyahui <2032914783@qq.com> Date: 星期二, 21 十一月 2023 17:51:16 +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