From 9776eab0645b2dfbe787e9d035f94ce80314e7fd Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 27 二月 2023 18:36:26 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/controller/data/MetaController.java | 2 +-
data/db_cx.sql | 24 +++++++++++++++++++++++-
data/update.sql | 2 +-
3 files changed, 25 insertions(+), 3 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 922aaa7..512d829 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -342,8 +342,30 @@
where pid = 0 order by code;
select * from lf.sys_download where guid='a0eab5c60810301c6bc86a295be1435a'
-select * from lf.sys_download order by id desc
+select * from lf.sys_meta where id = 1208 order by id desc
+select * from lf.sys_meta where rows > 0 and type in ('xls', 'xlsx');
+--bs.m_geocontrolpoint,6,1208
+select * from lf.sys_dict where ns='bs' and tab='project'
+select * from lf.sys_meta where id=1208
+--ad22a117-037c-4e30-ba86-d754584d23cb,bs.m_geocontrolpoint
+select * from lf.sys_meta where tab='bs.m_geocontrolpoint'
+update lf.sys_meta set eventid='ad22a117-037c-4e30-ba86-d754584d23cb' where
+
+select * from bs.m_geocontrolpoint where parentid='ad22a117-037c-4e30-ba86-d754584d23cb'
+update bs.m_geocontrolpoint set parentid='ad22a117-037c-4e30-ba86-d754584d23cb' where parentid='11'
+select * from bs.m_geocontrolpoint order by parentid
+
+update lf.sys_menu set pid=35,level=3,order_num=43 where cn_name='鏁版嵁缁熻';
+select * from lf.sys_menu where cn_name in ('杩愮淮鐩戞帶','鏁版嵁缁熻','绯荤粺鐩戞帶');
+select * from lf.sys_menu where pid=35 order by order_num;
+
+select * from lf.sys_menu where cn_name in ('椤圭洰绠＄悊','鏁版嵁搴撶鐞�') -- 85,86 level=2
+select * from lf.sys_menu where cn_name in ('鐩綍绠＄悊','椤圭洰淇℃伅','鐗堟湰绠＄悊') order by order_num;
+update lf.sys_menu set pid=85,level=3 where cn_name in ('椤圭洰淇℃伅','淇℃伅绠＄悊','鐗堟湰绠＄悊');
+
+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 ('鏁版嵁涓婁紶','淇℃伅绠＄悊','鍊煎煙绠＄悊','瀛楀吀绠＄悊','鏍峰紡绠＄悊','鏁版嵁鏌ヨ');
diff --git a/data/update.sql b/data/update.sql
index 1306483..af140c1 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -107,7 +107,7 @@
update lf.sys_dict set type='integer' where field='updateuser' and type='text';
--------------------------------------------------------- 01 lf.sys_dep
-- alter sequence lf.sys_meta_id_seq restart with 1;
-update lf.sys_operate set modular2='鍏冩暟鎹鐞�' where modular2='婧愭暟鎹鐞�';
+update lf.sys_operate set modular2='淇℃伅绠＄悊' where modular2='鍏冩暟鎹鐞�';
select modular1,modular2 from lf.sys_operate group by modular1,modular2;
delete from lf.sys_dep where id = 59;
diff --git a/src/main/java/com/lf/server/controller/data/MetaController.java b/src/main/java/com/lf/server/controller/data/MetaController.java
index 6a99062..0012bcf 100644
--- a/src/main/java/com/lf/server/controller/data/MetaController.java
+++ b/src/main/java/com/lf/server/controller/data/MetaController.java
@@ -41,7 +41,7 @@
* 鍏冩暟鎹�
* @author WWW
*/
-@Api(tags = "鏁版嵁绠＄悊\\鍏冩暟鎹鐞�")
+@Api(tags = "鏁版嵁绠＄悊\\淇℃伅绠＄悊")
@RestController
@RequestMapping("/meta")
public class MetaController extends BaseController {
--
Gitblit v1.9.3