From 18ef42f5a89babf01bdce096d05fbb6471763f68 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 07 四月 2023 09:54:16 +0800
Subject: [PATCH] 1
---
src/main/resources/mapper/show/ApplyMapper.xml | 12 ++++++------
说明.txt | 3 ++-
data/db_cx.sql | 24 ++++++++++++++++++++++++
3 files changed, 32 insertions(+), 7 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 2fa9c30..ea60882 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -25,6 +25,30 @@
select * from lf.sys_download order by id desc limit 20; --downid
select * from lf.sys_apply order by id desc;
+select case a.userid when 2 then guid else null end "guid", a.* from lf.sys_apply a order by id desc
+
+select c.relname "tab", cast(obj_description(c.oid) as varchar) "desc", a.attnum "num",
+a.attname "col", t.typname "type", d.description "bak" from pg_attribute a left join pg_description d
+on d.objoid = a.attrelid and d.objsubid = a.attnum left join pg_class c on a.attrelid = c.oid left join pg_type t
+on a.atttypid = t.oid where a.attnum >= 0 and reltype>0 and relnamespace in (5424908) and c.relname='pl_pipelinepoint_f' and position('pg.dropped' in a.attname) = 0
+order by c.relname desc, a.attnum asc
+
+select * from bs.s_explorationpointstratum where exppointid in ('HJXK20')
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/resources/mapper/show/ApplyMapper.xml b/src/main/resources/mapper/show/ApplyMapper.xml
index d25f661..b1be783 100644
--- a/src/main/resources/mapper/show/ApplyMapper.xml
+++ b/src/main/resources/mapper/show/ApplyMapper.xml
@@ -86,17 +86,17 @@
</selectKey>
insert into lf.sys_apply
- (userid,depids,tabs,entities,wkt,pwd,status,count,descr,create_user,create_time,depcode,dircodes,gids,filters)
+ (userid,depids,tabs,entities,wkt,pwd,status,count,descr,create_user,create_time,depcode,dircodes,gids,filters,guid)
values
- (#{userid},#{depids},#{tabs},#{entities},#{wkt},#{pwd},#{status},#{count},#{descr},#{createUser},now(),#{depcode},#{dircodes},#{gids},#{filters})
+ (#{userid},#{depids},#{tabs},#{entities},#{wkt},#{pwd},#{status},#{count},#{descr},#{createUser},now(),#{depcode},#{dircodes},#{gids},#{filters},#{guid})
</insert>
<insert id="inserts">
insert into lf.sys_apply
- (userid,depids,tabs,entities,wkt,pwd,status,count,descr,create_user,create_time,depcode,dircodes,gids,filters)
+ (userid,depids,tabs,entities,wkt,pwd,status,count,descr,create_user,create_time,depcode,dircodes,gids,filters,guid)
values
<foreach collection="list" item="item" index="index" separator=",">
- (#{item.userid},#{item.depids},#{item.tabs},#{item.entities},#{item.wkt},#{item.pwd},#{item.status},#{item.count},#{item.descr},#{item.createUser},now(),#{item.depcode},#{item.dircodes},#{item.gids},#{item.filters})
+ (#{item.userid},#{item.depids},#{item.tabs},#{item.entities},#{item.wkt},#{item.pwd},#{item.status},#{item.count},#{item.descr},#{item.createUser},now(),#{item.depcode},#{item.dircodes},#{item.gids},#{item.filters},#{item.guid})
</foreach>
</insert>
@@ -113,7 +113,7 @@
<update id="update">
update lf.sys_apply
- set userid=#{userid},depids=#{depids},tabs=#{tabs},entities=#{entities},wkt=#{wkt},pwd=#{pwd},status=#{status},count=#{count},descr=#{descr},update_user=#{updateUser},update_time=now(),depcode=#{depcode},dircodes=#{dircodes},gids=#{gids},filters=#{filters}
+ set userid=#{userid},depids=#{depids},tabs=#{tabs},entities=#{entities},wkt=#{wkt},pwd=#{pwd},status=#{status},count=#{count},descr=#{descr},update_user=#{updateUser},update_time=now(),depcode=#{depcode},dircodes=#{dircodes},gids=#{gids},filters=#{filters},guid=#{guid}
where id=#{id}
</update>
@@ -121,7 +121,7 @@
<foreach collection="list" item="item" index="index" separator=";">
update lf.sys_apply
<set>
- userid=#{item.userid},depids=#{item.depids},tabs=#{item.tabs},entities=#{item.entities},wkt=#{item.wkt},pwd=#{item.pwd},status=#{item.status},count=#{item.count},descr=#{item.descr},update_user=#{item.updateUser},update_time=now(),depcode=#{item.depcode},dircodes=#{item.dircodes},gids=#{item.gids},filters=#{item.filters}
+ userid=#{item.userid},depids=#{item.depids},tabs=#{item.tabs},entities=#{item.entities},wkt=#{item.wkt},pwd=#{item.pwd},status=#{item.status},count=#{item.count},descr=#{item.descr},update_user=#{item.updateUser},update_time=now(),depcode=#{item.depcode},dircodes=#{item.dircodes},gids=#{item.gids},filters=#{item.filters},guid=#{item.guid}
</set>
where id = #{item.id}
</foreach>
diff --git "a/\350\257\264\346\230\216.txt" "b/\350\257\264\346\230\216.txt"
index a9302fc..394d986 100644
--- "a/\350\257\264\346\230\216.txt"
+++ "b/\350\257\264\346\230\216.txt"
@@ -1,8 +1,9 @@
-------------------------------------------------------------------------------
Access锛歨ttps://blog.csdn.net/weixin_43407520/article/details/122165848
GDAL锛歨ttps://www.cnblogs.com/unlockth/p/14062076.html
-
E:\terrait\TianJin\Zip\release-1928-x64-dev\release-1928-x64\bin
+
+https://start.spring.io -> https://start.aliyun.com
-------------------------------------------------------------------------------
mklink /d "C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\geoserver\data\data\tiles" E:\TaiRui\LFData\2d\tiles
--
Gitblit v1.9.3