From 035d2ab3dae3b0ce20555a423b3bcabb4371543c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 20 二月 2023 19:08:10 +0800
Subject: [PATCH] 1
---
data/update.sql | 27 ++++++++++++++++++++-------
1 files changed, 20 insertions(+), 7 deletions(-)
diff --git a/data/update.sql b/data/update.sql
index cc1d584..860b6d4 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -216,6 +216,26 @@
select a.*,fn_uname(a.create_user) uname,fn_get_fullname(a.depcode, 1) depName,fn_ver(a.verid) verName,fn_get_fullname(a.dircode, 2) dirName
from lf.sys_meta a where a.dircode like (select code from lf.sys_dir where name='瑗挎皵涓滆緭鍥涚嚎澶╃劧姘旂閬撳伐绋嬶紙鍚愰瞾鐣�-涓崼锛夛紙00116DT02锛�') || '%';
+select * from lf.sys_report order by id
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-- 椤圭洰琛�
select a.*,st_astext(geom) from bs.bs_project a;
@@ -247,13 +267,6 @@
select name,code,(select count(*) from lf.sys_meta b where b.depcode like a.code || '%'),
(select count(sizes) from lf.sys_meta b where b.depcode like a.code || '%')
from lf.sys_dep a where name in ('娴嬬粯瀹�','鍕樺療瀹�','鍦扮伨涓撲笟','娲炲簱涓撲笟');
-
-
-
-
-
-
-
---------------------------------------------------------
-- 0100000000,02000000,030000,040100,0100000002,02000002,040102,0100000003,02000003,0100000001,02000001,040101,030001,01,02,02000001
select * from lf.sys_meta where dircode like '01%' or dircode like '02%' or dircode like '030000%'
--
Gitblit v1.9.3