From 548bb8f71f595ecffb9ab7233f4a2fe709093abb Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期二, 28 二月 2023 11:52:40 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
data/db_cx.sql | 22 ++++++++++++++++++++--
1 files changed, 20 insertions(+), 2 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 512d829..1e58a1a 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -1,3 +1,4 @@
+st_length( st_geographyfromtext( st_astext( st_intersection( ST_MakeValid(a.geom), ST_MakeValid(b.geom) ) ) ) ) AS acrossLength;
---------------------------------------------------------------------------------------------- 00.鍒涘缓绌洪棿鎵╁睍
create extension postgis;
create extension pgrouting;
@@ -49,8 +50,6 @@
select pg_constraint.conname as pk_name,pg_attribute.attname as colname,pg_type.typname as typename from pg_constraint inner join pg_class
on pg_constraint.conrelid = pg_class.oid inner join pg_attribute on pg_attribute.attrelid = pg_class.oid and pg_attribute.attnum = pg_constraint.conkey[1]
inner join pg_type on pg_type.oid = pg_attribute.atttypid where pg_class.relname = 'sys_user' and pg_constraint.contype='p';
-
-st_length( st_geographyfromtext( st_astext( st_intersection( ST_MakeValid(a.geom), ST_MakeValid(b.geom) ) ) ) ) AS acrossLength
---------------------------------------------------------------------------------------------- 02.閫掑綊鏌ヨ
with recursive rs as(
select * from lf.sys_menu where cn_name='绠￠亾鍩虹澶ф暟鎹钩鍙�'
@@ -367,6 +366,25 @@
select * from lf.sys_menu where cn_name in ('鏁版嵁涓婁紶','淇℃伅绠＄悊','鍊煎煙绠＄悊','瀛楀吀绠＄悊','鏍峰紡绠＄悊','鏁版嵁鏌ヨ') order by order_num;
update lf.sys_menu set pid=86,level=3 where cn_name in ('鏁版嵁涓婁紶','淇℃伅绠＄悊','鍊煎煙绠＄悊','瀛楀吀绠＄悊','鏍峰紡绠＄悊','鏁版嵁鏌ヨ');
+select name,
+ (select count(b.id) from lf.sys_meta b where dircode similar to '(' || (select string_agg(code, '|') from lf.sys_dir c where c.name = a.name) || ')%') "count",
+ (select coalesce(sum(b.sizes), 0) from lf.sys_meta b where dircode similar to '(' || (select string_agg(code, '|') from lf.sys_dir c where c.name = a.name) || ')%') "sizes"
+from lf.sys_dir a
+where code like '01%' and name in ('鍩虹娴嬬粯', '鍩虹鍦扮伨', '鍩虹鍕樺療', '鍚堣鏁版嵁', '绠＄悊鏁版嵁', '娴嬮噺锛圗SV锛�', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�')
+group by name
+order by name;
+
+select modular1, count(*) from lf.sys_operate group by modular1;
+select modular1,modular2,count(*) from lf.sys_operate group by modular1,modular2 order by modular1;
+delete from lf.sys_operate where modular1 not in ('缁煎悎灞曠ず','鏁版嵁璐ㄦ','鏁版嵁绠＄悊','鏁版嵁浜ゆ崲','鏈嶅姟绠＄悊','绯荤粺瀵规帴','杩愮淮绠＄悊');
+
+select id,cn_name,elev from lf.sys_layer where cn_name in ('鐏溅绔�','鍦颁笅绠＄嚎','涓崼绔�','搴嗛槼绔�','鍦板眰绀轰緥');
+
+
+
+
+
+
--
Gitblit v1.9.3