From 4bf16941466d36d2b46b15aad52edbad79528b30 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Fri, 25 Jun 2021 17:54:38 +0800
Subject: [PATCH] 客户列表查询接口修改，修改为模糊查询
---
blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.xml | 10 +++++-----
blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.java | 3 ++-
2 files changed, 7 insertions(+), 6 deletions(-)
diff --git a/blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.java b/blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.java
index eee3815..6ee5985 100644
--- a/blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.java
+++ b/blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.java
@@ -18,6 +18,7 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.apache.ibatis.annotations.Param;
import org.springblade.system.entity.Tenant;
import org.springblade.system.vo.TenantVo;
@@ -38,7 +39,7 @@
* @param tenant
* @return
*/
- List<TenantVo> selectTenantPage(IPage page, Tenant tenant);
+ List<TenantVo> selectTenantPage(IPage page, @Param("tenant") Tenant tenant);
List<Map<String, Object>> selectListTe(String type);
int inserts(String dj, String had, String ht, String ctime,String content,String hn);
void updateInfoy(String dj, String had, String ht, String ctime,String content,String hn);
diff --git a/blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.xml b/blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.xml
index c24f113..3530e01 100644
--- a/blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.xml
+++ b/blade-service/blade-system/src/main/java/org/springblade/system/mapper/TenantMapper.xml
@@ -40,19 +40,19 @@
AND bt.tenant_id != 000000
<if test="tenant.tenantName!=null and tenant.tenantName!=''">
- and tenant_name=#{tenant.tenantName}
+ and bt.tenant_name like concat('%',#{tenant.tenantName},'%')
</if>
<if test="tenant.linkman!=null and tenant.linkman!=''">
- and tenant.linkman=#{tenant.linkman}
+ and bt.linkman like concat('%',#{tenant.linkman},'%')
</if>
<if test="tenant.province!=null and tenant.province!=''">
- and tenant.province=#{tenant.province}
+ and bt.province=#{tenant.province}
</if>
<if test="tenant.city!=null and tenant.city!=''">
- and tenant.city=#{tenant.city}
+ and bt.city=#{tenant.city}
</if>
<if test="tenant.district!=null and tenant.district!=''">
- and tenant.district=#{tenant.district}
+ and bt.district=#{tenant.district}
</if>
</select>
--
Gitblit v1.9.3