From 1111a9b9baeaed10c2d2b6d6370b856f19a38c92 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 25 三月 2023 17:53:30 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/mapper/sys/AttachMapper.java | 8 +++++---
src/main/java/com/lf/server/service/sys/AttachService.java | 6 +++---
src/main/resources/mapper/sys/AttachMapper.xml | 14 ++++++++------
data/db_cx.sql | 8 +++-----
4 files changed, 19 insertions(+), 17 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 1207dfd..5758ee9 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -7,13 +7,11 @@
select concat(gb, '_', name) from bd.dlg_agnp limit 10;
select ST_AsText(geom) "geom", a.*, fn_get_fullname(a.depid, 1) depName, fn_get_fullname(a.dirid, 2) dirName, fn_uname(create_user) createName, fn_uname(update_user) updateName from lf.sys_publish a
-select * from lf.sys_fme_log order by id desc limit 10; -- 236
-select * from lf.sys_meta order by id desc limit 10; -- 1686 > 1696
+select * from lf.sys_fme_log order by id desc limit 10; -- 242 >
+select * from lf.sys_meta order by id desc limit 10; -- 1686 >
select * from lf.sys_fme_log
-where count > 0 and update_time is null and
-position(tcdm in 'bd.b_pac_hydrogeology,bd.b_pac_frozensoil,bd.b_pac_geologic_hazard,bd.b_pac_marine_meteorological,bd.b_pac_meteorological,bs.m_equipment_nameplate,bs.m_hydraulic_protection,bs.m_marker,bs.s_explorationpoint,bs.u_sectionline') > 0
- --and create_time > now()::timestamp + '-1 min'
+where count > 0 and update_time is null and create_time > now()::timestamp + '-1 min'
diff --git a/src/main/java/com/lf/server/mapper/sys/AttachMapper.java b/src/main/java/com/lf/server/mapper/sys/AttachMapper.java
index 76cfc9b..01f5b7b 100644
--- a/src/main/java/com/lf/server/mapper/sys/AttachMapper.java
+++ b/src/main/java/com/lf/server/mapper/sys/AttachMapper.java
@@ -157,10 +157,12 @@
public Integer updateFmeLog(Integer id);
/**
- * 鏍规嵁鍚嶇О鏌ヨ鍏冩暟鎹�
+ * 鏍规嵁鍏冩暟鎹悕绉版彃鍏ラ檮浠�
*
- * @param name
+ * @param metaName
+ * @param tab
+ * @param tabGuid
* @return
*/
- public MetaEntity selectMetaByName(String name);
+ public MetaEntity insertAttachByMeta(String metaName, String tab, String tabGuid);
}
diff --git a/src/main/java/com/lf/server/service/sys/AttachService.java b/src/main/java/com/lf/server/service/sys/AttachService.java
index 435064d..22f230c 100644
--- a/src/main/java/com/lf/server/service/sys/AttachService.java
+++ b/src/main/java/com/lf/server/service/sys/AttachService.java
@@ -128,8 +128,8 @@
}
@Override
- public MetaEntity selectMetaByName(String name) {
- return attachMapper.selectMetaByName(name);
+ public MetaEntity insertAttachByMeta(String metaName, String tab, String tabGuid) {
+ return attachMapper.insertAttachByMeta(metaName, tab, tabGuid);
}
/**
@@ -157,7 +157,7 @@
BaseEntity be = (BaseEntity) obj;
for (String name : names) {
- //
+ insertAttachByMeta(name, tab, be.getEventid());
}
}
}
diff --git a/src/main/resources/mapper/sys/AttachMapper.xml b/src/main/resources/mapper/sys/AttachMapper.xml
index 11b929e..25347bf 100644
--- a/src/main/resources/mapper/sys/AttachMapper.xml
+++ b/src/main/resources/mapper/sys/AttachMapper.xml
@@ -113,10 +113,12 @@
update lf.sys_fme_log set update_time = now() where id = #{id};
</update>
- <select id="selectMetaByName" resultType="com.lf.server.entity.data.MetaEntity">
- select * from lf.sys_meta
- where name = #{name} and create_time > now()::timestamp + '-10 min'
- order by id desc
- limit 1;
- </select>
+ <insert id="insertAttachByMeta">
+ insert into lf.sys_attach (name, guid, path, sizes, create_user, tab, tab_guid)
+ select name, guid, path, sizes, create_user, #{tab}, #{tabGuid}
+ from lf.sys_meta
+ where name = #{metaName} and create_time > now()::timestamp + '-10 min'
+ order by id desc
+ limit 1;
+ </insert>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3