From 4087fb78773b31b432bb08bb77a102e7d1ccd214 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 25 三月 2023 12:45:07 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/entity/bs/SexplorationpointEntity.java | 10 ++++++++++
data/db_fn.sql | 34 +++++++++++++++++++++++++++++++++-
2 files changed, 43 insertions(+), 1 deletions(-)
diff --git a/data/db_fn.sql b/data/db_fn.sql
index 2940c00..b21de5f 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -320,6 +320,10 @@
begin
update lf.sys_meta set tab = new.pg_ns || '.' || new.tcdm, layer = new.tcmc, rows = new.count where eventid = new.parentid;
+ if new.count > 0 and position(new.tcdm in 'b_pac_hydrogeology,b_pac_frozensoil,b_pac_geologic_hazard,b_pac_marine_meteorological,b_pac_meteorological,m_equipment_nameplate,m_hydraulic_protection,m_marker,s_explorationpoint,u_sectionline') > 0 then
+ select fn_auto_attach(new.id);
+ end if;
+
return new;
end;
$$ language plpgsql;
@@ -355,8 +359,36 @@
return new;
end;
$$ language plpgsql;
+----------------------------------------------------------------------------------------------------- 18.鍚屾闄勪欢鍑芥暟
+-- drop function fn_auto_attach(integer);
+create or replace function fn_auto_attach(sid integer) returns void as $$
+ declare
------------------------------------------------------------------------------------------------------ 18.璺緞鍒嗘瀽
+ begin
+ select * from lf.sys_fme_log a where a.id = sid limit 1;
+
+ --return 0;
+ end;
+$$ language plpgsql;
+
+
+
+select fn_auto_attach(143)
+
+
+select position('s_pac_hydrogeology' in 'b_pac_hydrogeology,bd.b_pac_frozensoil,bd.b_pac_geologic_hazard')
+select parentid, pg_ns, tcdm, count from lf.sys_fme_log where id = 143;
+select * from lf.sys_meta where eventid = '1caa28e2-b911-40e1-bfc5-4959a927cdd1';
+select * from bs.m_marker where parentid = '1caa28e2-b911-40e1-bfc5-4959a927cdd1';
+
+select * from lf.sys_meta a inner join lf.sys_fme_log b on a.eventid= b.parentid
+
+
+select * from lf.sys_attach;
+insert into lf.sys_attach (name, guid, path, create_user, tab, tab_guid, sizes);
+
+
+----------------------------------------------------------------------------------------------------- 19.璺緞鍒嗘瀽
-- 鍒犻櫎宸插瓨鍦ㄧ殑鍑芥暟
-- drop function pgr_fromAtoB(varchar, double precision, double precision, double precision, double precision);
diff --git a/src/main/java/com/lf/server/entity/bs/SexplorationpointEntity.java b/src/main/java/com/lf/server/entity/bs/SexplorationpointEntity.java
index b435307..792f188 100644
--- a/src/main/java/com/lf/server/entity/bs/SexplorationpointEntity.java
+++ b/src/main/java/com/lf/server/entity/bs/SexplorationpointEntity.java
@@ -56,6 +56,8 @@
private String photono;
+ private String workno;
+
public SexplorationpointEntity() {
}
@@ -202,4 +204,12 @@
public void setPhotono(String photono) {
this.photono = photono;
}
+
+ public String getWorkno() {
+ return workno;
+ }
+
+ public void setWorkno(String workno) {
+ this.workno = workno;
+ }
}
--
Gitblit v1.9.3