From a1474d8f0ad09128aa4a1f43b36917c1d699842d Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 25 五月 2023 10:53:38 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 15 +++++++++++++++
src/main/resources/mapper/show/OneMapMapper.xml | 12 +++++++++---
2 files changed, 24 insertions(+), 3 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index a0ec2dc..1404512 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -12,6 +12,7 @@
--delete from bs.s_explorationpointstratum where parentid in (select eventid from lf.sys_meta where name='鍕樻帰鐐瑰湴灞傝〃.xlsx');
select * from lf.sys_meta where type = 'tif' or type = 'tiff' or lower(name) in ('骞抽潰鍥剧储寮曟枃浠�.xlsx', '绌胯法瓒婂湴褰㈠浘.dwg', '涓嚎鎴愭灉琛�.xlsx', '绂绘暎鐐�.xlsx', '鎺у埗鐐�.xlsx', '鍦伴潰绾�.xlsx');
+set autocommit off;
-- delete from lf.sys_apply where id > 47; delete from lf.sys_flow where applyid > 47;
select * from lf.sys_layer where position('SG' in url) > 0 order by id desc;
select * from lf.sys_layer order by id desc;
@@ -29,7 +30,21 @@
select * from lf.sys_dict order by id desc;
select * from lf.sys_meta where type in ('3dml');
select * from lf.sys_ars;
+
+-- ALL -> 560, type=2 -> 442, WMS -> 340, url=null -> 77, type=2 & url -> 25, .json -> 17
select serve_type from lf.sys_layer group by serve_type;
+update lf.sys_layer set serve_type = null where type = 2;
+update lf.sys_layer set serve_type = 'WMS' where type = 2 and position('LF:' in url) > 0;
+update lf.sys_layer set serve_type = '3DML' where type = 2 and serve_type is null and position('b3dm' in url) > 0;
+update lf.sys_layer set serve_type = 'Tileset' where type = 2 and serve_type is null and position('.json' in url) > 0;
+update lf.sys_layer set serve_type = 'TMS' where type = 2 and serve_type is null and position('.png' in url) > 0;
+update lf.sys_layer set serve_type = 'Mpt' where type = 2 and serve_type is null and position('.mpt' in url) > 0;
+update lf.sys_layer set serve_type = 'DEM' where type = 2 and serve_type is null and position('terrain/' in url) > 0;
+
+select id, pid, cn_name, en_name, url, serve_type, data_type, elev, pubid, is_project, bak
+from lf.sys_layer
+where type = 2 and serve_type is not null
+order by id;
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
index a27e53b..3803030 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -191,14 +191,20 @@
</select>
<!-- 缁熻鍏ㄥ浗绠＄綉鍥捐緭閫佷粙璐ㄩ暱搴� -->
- <select id="countZhPipeMapLenByMed" resultType="java.util.Map">
+ <!--select id="countZhPipeMapLenByMed" resultType="java.util.Map">
SELECT medium AS type,count(*) AS count,sum(length)AS length FROM bs.m_pipesegment GROUP BY medium ;
+ </select-->
+ <select id="countZhPipeMapLenByMed" resultType="java.util.Map">
+ select case medium when 'CO' then '鍘熸补' when 'RP' then '鎴愬搧娌�' when 'GS' then '澶╃劧姘�' else '鍏跺畠' end "type",
+ count(*) "count", round(sum(ST_Length(geom)::numeric), 2) "length"
+ from bs.m_pipeline
+ group by medium;
</select>
- <!-- 缁熻鍏ㄥ浗绔欏満搴ф暟銆侀榾瀹ゃ�佺閬撴暟绛� -->
+ <!-- 缁熻鍏ㄥ浗绔欏満搴ф暟銆侀榾瀹ゃ�佺閬撴暟閲� -->
<select id="countZhPipeStations" resultType="java.util.Map">
select
- case medium when 'CPY' then '鎴愬搧娌�' when 'TRQ' then '澶╃劧姘�' when 'YY' then '鍘熸补' else '鍏跺畠' end "杈撻�佷粙璐�",
+ case medium when 'CO' then '鍘熸补' when 'RP' then '鎴愬搧娌�' when 'GS' then '澶╃劧姘�' else '鍏跺畠' end "杈撻�佷粙璐�",
round(sum(st_length(geom))::numeric, 2) "鎬婚噷绋�",
count(*) "绠￠亾鏁伴噺",
(select count(*) from bs.m_sitepoint b inner join bs.m_pipeline c on b.pipename = c.pipename where c.medium = a.medium) "绔欏満鏁伴噺",
--
Gitblit v1.9.3