From 52bb9f2a447abcd960a744ecad0dc082c4b412ca Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 20 三月 2023 17:17:13 +0800
Subject: [PATCH] 1
---
src/main/resources/mapper/data/DirMapper.xml | 2 +-
src/main/resources/mapper/data/DownloadMapper.xml | 8 ++++----
src/main/resources/mapper/data/StyleMapper.xml | 4 ++--
src/main/resources/mapper/all/BaseQueryMapper.xml | 10 +++++-----
src/main/resources/mapper/data/DomainMapper.xml | 4 ++--
src/main/resources/mapper/data/VerMapper.xml | 4 ++--
src/main/resources/mapper/data/DictMapper.xml | 6 +++---
src/main/resources/mapper/data/MetaMapper.xml | 16 ++++++++--------
8 files changed, 27 insertions(+), 27 deletions(-)
diff --git a/src/main/resources/mapper/all/BaseQueryMapper.xml b/src/main/resources/mapper/all/BaseQueryMapper.xml
index 3ab7312..2fdb0d4 100644
--- a/src/main/resources/mapper/all/BaseQueryMapper.xml
+++ b/src/main/resources/mapper/all/BaseQueryMapper.xml
@@ -5,7 +5,7 @@
select id,uname "name" from lf.sys_user
<where>
<if test="name != null">
- uname like #{name}
+ upper(uname) like #{name}
</if>
</where>
order by uname limit 10
@@ -15,7 +15,7 @@
select id,name from lf.sys_dep
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name}
</if>
</where>
order by order_num limit 10
@@ -26,7 +26,7 @@
<where>
field = #{field} and status = 0
<if test="tab != null">
- and tab like #{tab} or tab_desc like #{tab}
+ and upper(tab) like #{tab} or upper(tab_desc) like #{tab}
</if>
</where>
</select>
@@ -37,7 +37,7 @@
<where>
field = #{field} and status = 0
<if test="tab != null">
- and (tab like #{tab} or tab_desc like #{tab})
+ and (upper(tab) like #{tab} or upper(tab_desc) like #{tab})
</if>
</where>
order by id
@@ -73,7 +73,7 @@
<where>
name in ('鍩虹娴嬬粯', '鍩虹鍦扮伨', '鍩虹鍕樺療', '鍚堣鏁版嵁', '绠＄悊鏁版嵁', '娴嬮噺锛圗SV锛�', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�')
<if test="name != null">
- and name like #{name}
+ and upper(name) like #{name}
</if>
</where>
group by name
diff --git a/src/main/resources/mapper/data/DictMapper.xml b/src/main/resources/mapper/data/DictMapper.xml
index d74add0..b8be40f 100644
--- a/src/main/resources/mapper/data/DictMapper.xml
+++ b/src/main/resources/mapper/data/DictMapper.xml
@@ -9,7 +9,7 @@
and ns = #{ns}
</if>
<if test="tab != null">
- and tab like #{tab}
+ and upper(tab) like #{tab}
</if>
</where>
</select>
@@ -22,7 +22,7 @@
and ns = #{ns}
</if>
<if test="tab != null">
- and tab like #{tab}
+ and upper(tab) like #{tab}
</if>
</where>
order by ns,tab,id
@@ -39,7 +39,7 @@
<where>
field = #{field} and status = 0
<if test="name != null">
- and (tab like #{name} or tab_desc like #{name})
+ and (upper(tab) like #{name} or upper(tab_desc) like #{name})
</if>
</where>
order by id;
diff --git a/src/main/resources/mapper/data/DirMapper.xml b/src/main/resources/mapper/data/DirMapper.xml
index bd54f2b..2a09256 100644
--- a/src/main/resources/mapper/data/DirMapper.xml
+++ b/src/main/resources/mapper/data/DirMapper.xml
@@ -22,7 +22,7 @@
<where>
pid = 0
<if test="name != null">
- and name like #{name}
+ and upper(name) like #{name}
</if>
</where>
order by order_num;
diff --git a/src/main/resources/mapper/data/DomainMapper.xml b/src/main/resources/mapper/data/DomainMapper.xml
index 792f0e9..ef43900 100644
--- a/src/main/resources/mapper/data/DomainMapper.xml
+++ b/src/main/resources/mapper/data/DomainMapper.xml
@@ -11,7 +11,7 @@
and b.tab = #{tab}
</if>
<if test="name != null">
- and (dom_desc like #{name} or dom_name like #{name})
+ and (upper(dom_desc) like #{name} or upper(dom_name) like #{name})
</if>
</select>
@@ -25,7 +25,7 @@
and b.tab = #{tab}
</if>
<if test="name != null">
- and (dom_desc like #{name} or dom_name like #{name})
+ and (upper(dom_desc) like #{name} or upper(dom_name) like #{name})
</if>
order by b.tab,a.dom_name,a.dom_code
limit #{limit} offset #{offset}
diff --git a/src/main/resources/mapper/data/DownloadMapper.xml b/src/main/resources/mapper/data/DownloadMapper.xml
index 63d9c2d..da81a01 100644
--- a/src/main/resources/mapper/data/DownloadMapper.xml
+++ b/src/main/resources/mapper/data/DownloadMapper.xml
@@ -5,7 +5,7 @@
select count(*) from lf.sys_download
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name} or upper(descr) like #{name}
</if>
</where>
</select>
@@ -14,7 +14,7 @@
select * from lf.sys_download
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name} or upper(descr) like #{name}
</if>
</where>
order by id desc
@@ -26,7 +26,7 @@
<where>
create_user = #{createUser} and type = #{type}
<if test="name != null">
- and name like #{name}
+ and (upper(name) like #{name} or upper(descr) like #{name})
</if>
</where>
</select>
@@ -36,7 +36,7 @@
<where>
create_user = #{createUser} and type = #{type}
<if test="name != null">
- and name like #{name}
+ and (upper(name) like #{name} or upper(descr) like #{name})
</if>
</where>
order by id desc
diff --git a/src/main/resources/mapper/data/MetaMapper.xml b/src/main/resources/mapper/data/MetaMapper.xml
index de68515..b2db861 100644
--- a/src/main/resources/mapper/data/MetaMapper.xml
+++ b/src/main/resources/mapper/data/MetaMapper.xml
@@ -15,7 +15,7 @@
and verid = #{verid}
</if>
<if test="name != null">
- and name like #{name}
+ and upper(name) like #{name}
</if>
</where>
</select>
@@ -35,7 +35,7 @@
and verid = #{verid}
</if>
<if test="name != null">
- and name like #{name}
+ and upper(name) like #{name}
</if>
</where>
order by id desc
@@ -53,7 +53,7 @@
and (${dirs})
</if>
<if test="name != null">
- and name like #{name}
+ and upper(name) like #{name}
</if>
</where>
</select>
@@ -73,7 +73,7 @@
and (${dirs})
</if>
<if test="name != null">
- and name like #{name}
+ and upper(name) like #{name}
</if>
</where>
order by id desc
@@ -88,7 +88,7 @@
and type in (${types})
</if>
<if test="name != null">
- and name like #{name}
+ and upper(name) like #{name}
</if>
</where>
</select>
@@ -102,7 +102,7 @@
and type in (${types})
</if>
<if test="name != null">
- and name like #{name}
+ and upper(name) like #{name}
</if>
</where>
order by id desc
@@ -114,7 +114,7 @@
<where>
metaid = #{metaid}
<if test="name != null">
- and name like #{name}
+ and upper(name) like #{name}
</if>
</where>
</select>
@@ -125,7 +125,7 @@
<where>
metaid = #{metaid}
<if test="name != null">
- and name like #{name}
+ and upper(name) like #{name}
</if>
</where>
order by id desc
diff --git a/src/main/resources/mapper/data/StyleMapper.xml b/src/main/resources/mapper/data/StyleMapper.xml
index 207531e..66c5522 100644
--- a/src/main/resources/mapper/data/StyleMapper.xml
+++ b/src/main/resources/mapper/data/StyleMapper.xml
@@ -5,7 +5,7 @@
select count(*) from lf.sys_style
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name}
</if>
</where>
</select>
@@ -15,7 +15,7 @@
from lf.sys_style a
<where>
<if test="name != null">
- a.name like #{name}
+ upper(a.name) like #{name}
</if>
</where>
order by a.id desc
diff --git a/src/main/resources/mapper/data/VerMapper.xml b/src/main/resources/mapper/data/VerMapper.xml
index 2aab88f..f2fbcd4 100644
--- a/src/main/resources/mapper/data/VerMapper.xml
+++ b/src/main/resources/mapper/data/VerMapper.xml
@@ -10,7 +10,7 @@
and a.dirid = ANY(fn_rec_array(#{dirid}, 'dir'))
</if>
<if test="name != null">
- and a.name like #{name}
+ and upper(a.name) like #{name}
</if>
</where>
</select>
@@ -24,7 +24,7 @@
and a.dirid = ANY(fn_rec_array(#{dirid}, 'dir'))
</if>
<if test="name != null">
- and a.name like #{name}
+ and upper(a.name) like #{name}
</if>
</where>
order by id desc
--
Gitblit v1.9.3