From afc33eae737255eb206e140a269fe7262d94cde2 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 29 六月 2023 13:38:42 +0800
Subject: [PATCH] 1
---
src/main/resources/mapper/all/BaseQueryMapper.xml | 2 +-
data/db_cx.sql | 14 ++++++++++++--
2 files changed, 13 insertions(+), 3 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index d51eef4..fc3cc5e 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -27,8 +27,6 @@
select * from lf.sys_meta order by id desc limit 100;
select * from lf.sys_fme_log order by id desc;
select * from lf.sys_pub_down order by id desc;
-select id, pid, name, code from lf.sys_dir order by code;
-select * from public.coal2000 order by gid limit 20;
select * from lf.sys_dir where pid = 0 order by id;
select * from lf.sys_dict order by id desc;
select * from lf.sys_meta where type in ('3dml');
@@ -51,6 +49,18 @@
select * from lf.sys_meta where type='xlsx' order by id desc limit 20;
select * from lf.sys_dict where tab_desc in('鍦拌〃褰㈠彉鏁版嵁鏃跺簭琛�','宕╁') order by id; -- m_surface_deformation_data_date
+select count(*) from bd.b_hy20w_s11 where 1=1 and (dirid like '0B%');
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/resources/mapper/all/BaseQueryMapper.xml b/src/main/resources/mapper/all/BaseQueryMapper.xml
index b64a4c6..9c2b957 100644
--- a/src/main/resources/mapper/all/BaseQueryMapper.xml
+++ b/src/main/resources/mapper/all/BaseQueryMapper.xml
@@ -26,7 +26,7 @@
<where>
field = #{field} and status = 0
<if test="tab != null">
- and upper(tab) like #{tab} or upper(tab_desc) like #{tab}
+ and (upper(tab) like #{tab} or upper(tab_desc) like #{tab})
</if>
<if test="typesFilter != null">
and (${typesFilter})
--
Gitblit v1.9.3