From 069f8e1f07cdcf0ac09f215468fdb812d3fc8225 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期日, 03 九月 2023 10:49:28 +0800
Subject: [PATCH] 添加根据发布ID查询元数据、插入元数据发布类
---
src/main/java/com/moon/server/service/data/PublishService.java | 11 +++
src/main/java/com/moon/server/mapper/data/PublishMapper.java | 17 +++++
src/main/java/com/moon/server/entity/data/MetaPubEntity.java | 86 ++++++++++++++++++++++++++++
src/main/resources/mapper/data/PublishMapper.xml | 18 ++++++
4 files changed, 132 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/moon/server/entity/data/MetaPubEntity.java b/src/main/java/com/moon/server/entity/data/MetaPubEntity.java
new file mode 100644
index 0000000..06675de
--- /dev/null
+++ b/src/main/java/com/moon/server/entity/data/MetaPubEntity.java
@@ -0,0 +1,86 @@
+package com.moon.server.entity.data;
+
+import java.io.Serializable;
+import java.sql.Timestamp;
+
+/**
+ * 鍏冩暟鎹彂甯冪被
+ * @author WWW
+ * @date 2023-09-03
+ */
+public class MetaPubEntity implements Serializable {
+ private static final long serialVersionUID = 161951681197440703L;
+
+ private Integer id;
+
+ private Integer metaid;
+
+ private Integer pubid;
+
+ private Integer createUser;
+
+ private Timestamp createTime;
+
+ private Integer updateUser;
+
+ private Timestamp updateTime;
+
+ public MetaPubEntity() {
+ }
+
+ public Integer getId() {
+ return id;
+ }
+
+ public void setId(Integer id) {
+ this.id = id;
+ }
+
+ public Integer getMetaid() {
+ return metaid;
+ }
+
+ public void setMetaid(Integer metaid) {
+ this.metaid = metaid;
+ }
+
+ public Integer getPubid() {
+ return pubid;
+ }
+
+ public void setPubid(Integer pubid) {
+ this.pubid = pubid;
+ }
+
+ public Integer getCreateUser() {
+ return createUser;
+ }
+
+ public void setCreateUser(Integer createUser) {
+ this.createUser = createUser;
+ }
+
+ public Timestamp getCreateTime() {
+ return createTime;
+ }
+
+ public void setCreateTime(Timestamp createTime) {
+ this.createTime = createTime;
+ }
+
+ public Integer getUpdateUser() {
+ return updateUser;
+ }
+
+ public void setUpdateUser(Integer updateUser) {
+ this.updateUser = updateUser;
+ }
+
+ public Timestamp getUpdateTime() {
+ return updateTime;
+ }
+
+ public void setUpdateTime(Timestamp updateTime) {
+ this.updateTime = updateTime;
+ }
+}
diff --git a/src/main/java/com/moon/server/mapper/data/PublishMapper.java b/src/main/java/com/moon/server/mapper/data/PublishMapper.java
index 207a84f..a1b8a43 100644
--- a/src/main/java/com/moon/server/mapper/data/PublishMapper.java
+++ b/src/main/java/com/moon/server/mapper/data/PublishMapper.java
@@ -1,6 +1,7 @@
package com.moon.server.mapper.data;
import com.moon.server.entity.data.MetaEntity;
+import com.moon.server.entity.data.MetaPubEntity;
import com.moon.server.entity.data.PublishEntity;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
@@ -60,6 +61,14 @@
public List<PublishEntity> selectByIds(String ids);
/**
+ * 鏍规嵁鍙戝竷ID鏌ヨ鍏冩暟鎹�
+ *
+ * @param pubid 鍙戝竷ID
+ * @return 鍏冩暟鎹泦鍚�
+ */
+ public List<MetaEntity> selectMetasByPubid(Integer pubid);
+
+ /**
* 鏍规嵁鐩綍鏌ヨDOM鍜孌EM鐨勭紪鐮�
*
* @param dircode 鐩綍
@@ -95,6 +104,14 @@
public Integer insertPubDown(Integer pubid, Integer downid, Integer createUser);
/**
+ * 鎻掑叆鍏冩暟鎹彂甯冪被
+ *
+ * @param mp 鍏冩暟鎹彂甯冪被
+ * @return 褰卞搷琛屾暟
+ */
+ public Integer insertMetaPub(MetaPubEntity mp);
+
+ /**
* 鍒犻櫎涓�鏉�
*
* @param id
diff --git a/src/main/java/com/moon/server/service/data/PublishService.java b/src/main/java/com/moon/server/service/data/PublishService.java
index c74c104..91a86bc 100644
--- a/src/main/java/com/moon/server/service/data/PublishService.java
+++ b/src/main/java/com/moon/server/service/data/PublishService.java
@@ -5,6 +5,7 @@
import com.moon.server.entity.all.StaticData;
import com.moon.server.entity.ctrl.PubEntity;
import com.moon.server.entity.data.MetaEntity;
+import com.moon.server.entity.data.MetaPubEntity;
import com.moon.server.entity.data.PublishEntity;
import com.moon.server.helper.RestHelper;
import com.moon.server.helper.StringHelper;
@@ -67,6 +68,11 @@
}
@Override
+ public List<MetaEntity> selectMetasByPubid(Integer pubid) {
+ return publishMapper.selectMetasByPubid(pubid);
+ }
+
+ @Override
public List<String> selectCodesForDir(String dircode, Integer isDom) {
return publishMapper.selectCodesForDir(dircode, isDom);
}
@@ -87,6 +93,11 @@
}
@Override
+ public Integer insertMetaPub(MetaPubEntity mp) {
+ return publishMapper.insertMetaPub(mp);
+ }
+
+ @Override
public Integer delete(int id) {
return publishMapper.delete(id);
}
diff --git a/src/main/resources/mapper/data/PublishMapper.xml b/src/main/resources/mapper/data/PublishMapper.xml
index 8dfb4f1..582575d 100644
--- a/src/main/resources/mapper/data/PublishMapper.xml
+++ b/src/main/resources/mapper/data/PublishMapper.xml
@@ -94,6 +94,14 @@
select * from lf.sys_publish where id in (${ids}) order by id desc;
</select>
+ <select id="selectMetasByPubid" resultType="com.moon.server.entity.data.MetaEntity">
+ select a.*
+ from lf.sys_meta a
+ inner join lf.sys_meta_pub b
+ on a.id = b.metaid
+ where b.pubid = #{pubid};
+ </select>
+
<select id="selectCodesForDir" resultType="java.lang.String">
select code
from lf.sys_dir
@@ -114,6 +122,10 @@
</select>
<insert id="insert" parameterType="com.moon.server.entity.data.PublishEntity">
+ <selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="id">
+ select currval('lf.sys_publish_id_seq'::regclass) as id
+ </selectKey>
+
insert into lf.sys_publish
(layerid,serviceid,name,url,path,type,status,dirid,depid,min,max,json,create_user,create_time,geom,bak)
values
@@ -123,6 +135,12 @@
<insert id="insertPubDown">
insert into lf.sys_pub_down (pubid, downid, create_user) values (#{pubid}, #{downid}, #{createUser})
</insert>
+
+ <insert id="insertMetaPub" parameterType="com.moon.server.entity.data.MetaPubEntity">
+ insert into lf.sys_meta_pub(metaid, pubid, create_user, create_time)
+ values
+ (#{metaid}, #{pubid}, #{createUser}, now());
+ </insert>
<insert id="inserts">
insert into lf.sys_publish
--
Gitblit v1.9.3