From 8ab1c69243e84ab283189621f89e808d6a83f588 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 20 三月 2023 17:26:23 +0800
Subject: [PATCH] 1
---
src/main/resources/mapper/show/ApplyMapper.xml | 4 ++--
src/main/resources/mapper/show/PublishMapper.xml | 8 ++++----
src/main/resources/mapper/show/PipelineMapper.xml | 2 +-
3 files changed, 7 insertions(+), 7 deletions(-)
diff --git a/src/main/resources/mapper/show/ApplyMapper.xml b/src/main/resources/mapper/show/ApplyMapper.xml
index 5ea910f..acf4a06 100644
--- a/src/main/resources/mapper/show/ApplyMapper.xml
+++ b/src/main/resources/mapper/show/ApplyMapper.xml
@@ -6,7 +6,7 @@
<where>
1 = 1
<if test="uname != null">
- and b.uname like #{uname}
+ and upper(b.uname) like #{uname}
</if>
<if test="status != null">
<if test="status == 0">
@@ -31,7 +31,7 @@
<where>
1 = 1
<if test="uname != null">
- and b.uname like #{uname}
+ and upper(b.uname) like #{uname}
</if>
<if test="status != null">
<if test="status == 0">
diff --git a/src/main/resources/mapper/show/PipelineMapper.xml b/src/main/resources/mapper/show/PipelineMapper.xml
index 2dec3d2..3e67c63 100644
--- a/src/main/resources/mapper/show/PipelineMapper.xml
+++ b/src/main/resources/mapper/show/PipelineMapper.xml
@@ -7,7 +7,7 @@
<where>
pipename is not null and not ST_IsEmpty(geom)
<if test="name != null">
- and (pipename like #{name} or segname like #{name})
+ and (upper(pipename) like #{name} or upper(segname) like #{name})
</if>
</where>
order by pipename, segname;
diff --git a/src/main/resources/mapper/show/PublishMapper.xml b/src/main/resources/mapper/show/PublishMapper.xml
index 5fadf18..87a99fd 100644
--- a/src/main/resources/mapper/show/PublishMapper.xml
+++ b/src/main/resources/mapper/show/PublishMapper.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>
@@ -38,7 +38,7 @@
and verid = #{verid}
</if>
<if test="name != null">
- and name like #{name}
+ and upper(name) like #{name}
</if>
</where>
order by id desc
@@ -49,7 +49,7 @@
select count(*) from lf.sys_publish
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name}
</if>
</where>
</select>
@@ -59,7 +59,7 @@
from lf.sys_publish a
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name}
</if>
</where>
order by id
--
Gitblit v1.9.3