From c32b4d0e5877c28aade98548889cc20f38249709 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期五, 16 九月 2022 14:38:17 +0800
Subject: [PATCH] #
---
src/main/resources/mapper/CstmrMapper.xml | 12 +++++++++++-
1 files changed, 11 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/CstmrMapper.xml b/src/main/resources/mapper/CstmrMapper.xml
index 038c761..a46f65c 100644
--- a/src/main/resources/mapper/CstmrMapper.xml
+++ b/src/main/resources/mapper/CstmrMapper.xml
@@ -62,7 +62,17 @@
and mc.host_id = #{hostId}
</if>
<if test="condition != null and condition != ''">
- and mc.name like concat('%',#{condition},'%')
+ and (
+ and mc.uuid like concat('%',#{condition},'%')
+ and mc.name like concat('%',#{condition},'%')
+ and mc.simple like concat('%',#{condition},'%')
+ and mc.rela like concat('%',#{condition},'%')
+ and mc.tel like concat('%',#{condition},'%')
+ and mc.contacts like concat('%',#{condition},'%')
+ and mc.remarks like concat('%',#{condition},'%')
+ and mc.director like concat('%',#{condition},'%')
+ and mc.addr like concat('%',#{condition},'%')
+ )
</if>
ORDER BY mc.create_time DESC
</select>
--
Gitblit v1.9.1