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