From ac20dc99bf1f463365dba071973e08fffbd294b4 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期五, 14 七月 2023 14:12:21 +0800 Subject: [PATCH] 1 --- src/main/java/com/lf/server/entity/data/LayerEntity.java | 10 ++++++++++ src/main/resources/mapper/data/LayerMapper.xml | 4 +++- 2 files changed, 13 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/lf/server/entity/data/LayerEntity.java b/src/main/java/com/lf/server/entity/data/LayerEntity.java index 0f3bbbd..c1631f0 100644 --- a/src/main/java/com/lf/server/entity/data/LayerEntity.java +++ b/src/main/java/com/lf/server/entity/data/LayerEntity.java @@ -54,6 +54,8 @@ private Integer isProject; + private String json; + public LayerEntity() { } @@ -232,4 +234,12 @@ public void setIsProject(Integer isProject) { this.isProject = isProject; } + + public String getJson() { + return json; + } + + public void setJson(String json) { + this.json = json; + } } diff --git a/src/main/resources/mapper/data/LayerMapper.xml b/src/main/resources/mapper/data/LayerMapper.xml index 45c9b88..7af9a3d 100644 --- a/src/main/resources/mapper/data/LayerMapper.xml +++ b/src/main/resources/mapper/data/LayerMapper.xml @@ -22,7 +22,9 @@ </select> <select id="selectAll" resultType="com.lf.server.entity.data.LayerEntity"> - select (select ns from lf.sys_dict b where b.field = 'gid' and b.tab = a.en_name) "ns", a.* + select a.*, + (select ns from lf.sys_dict b where b.field = 'gid' and b.tab = a.en_name) "ns", + (select json from lf.sys_publish c where c.id = a.pubid) from lf.sys_layer a order by id; </select> -- Gitblit v1.9.3