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/service/LWhFormTransferServiceImpl.java | 23 +++++++++++++++++++++++
1 files changed, 23 insertions(+), 0 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java
index a9be7ec..6d6e87d 100644
--- a/consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java
@@ -499,4 +499,27 @@
return mapGenericPager;
}
+
+ public List<Map<String, Object>> queryDepartmentTransferOrder() {
+
+ String sql = "SELECT ft.id,\n"
+ + " ft.BUSINESS_FORM_CODE,\n"
+ + " gr.GOODS_TEMPLATE_NAME,\n"
+ + " gr.BASE_GOODS_TEMPLATE_ID goodsTemplateId,\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 where ft.BUSINESS_TYPE = 1 GROUP BY gr.BASE_GOODS_TEMPLATE_ID \n";
+ HashMap<String, Object> param = new HashMap<>();
+ List<Map<String, Object>> select = this.select(sql, param, new MapperUtil());
+ select.forEach(item -> {
+
+
+ });
+ return select;
+
+ }
}
--
Gitblit v1.9.1