From 81eb0a971422c081550a1458c8aebcba6d3259a2 Mon Sep 17 00:00:00 2001
From: Junjie <540245094@qq.com>
Date: 星期四, 01 八月 2024 16:15:28 +0800
Subject: [PATCH] #
---
zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/MatFieldMapper.java | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/MatFieldMapper.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/MatFieldMapper.java
index 12e52e9..133a840 100644
--- a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/MatFieldMapper.java
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/MatFieldMapper.java
@@ -18,6 +18,10 @@
@SelectProvider(type = SqlProvider.class, method = "createViewSql")
void createView(@Param("list") List<MatField> list);
+
+ @SelectProvider(type = SqlProvider.class, method = "createLocDetlView")
+ void createLocDetlView();
+
class SqlProvider {
public String createViewSql(Map<String, Object> params) {
List<MatField> list = (List<MatField>) params.get("list");
@@ -33,6 +37,17 @@
return sql.toString();
}
+
+ public String createLocDetlView() {
+ StringBuilder sql = new StringBuilder();
+
+ sql.append(" CREATE OR REPLACE VIEW view_man_loc_detl AS \n");
+ sql.append(" select * from man_loc_detl ld ");
+ sql.append(" left join view_man_loc_detl_field ldf ");
+ sql.append(" on ld.id = ldf.detl_id ");
+
+ return sql.toString();
+ }
}
}
--
Gitblit v1.9.1