From 5be1aede02a2ec8fff2abb0e0387c87954e38dcd Mon Sep 17 00:00:00 2001
From: dougang <78125310@kidgrow.com>
Date: Fri, 27 Nov 2020 11:26:36 +0800
Subject: [PATCH] 增加keyWord字段,C端用于搜索使用

---
 kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/HospitalScreeningMapper.xml                 |    3 +++
 kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-api/src/main/java/com/kidgrow/oprationcenter/model/HospitalScreening.java |    5 +++++
 2 files changed, 8 insertions(+), 0 deletions(-)

diff --git a/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-api/src/main/java/com/kidgrow/oprationcenter/model/HospitalScreening.java b/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-api/src/main/java/com/kidgrow/oprationcenter/model/HospitalScreening.java
index 380586f..2de6bff 100644
--- a/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-api/src/main/java/com/kidgrow/oprationcenter/model/HospitalScreening.java
+++ b/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-api/src/main/java/com/kidgrow/oprationcenter/model/HospitalScreening.java
@@ -79,4 +79,9 @@
      * 微站首页中间位置图片
      */
     private String homePage;
+
+    /**
+     * 查询关键字
+     */
+    private String keyWord;
 }
diff --git a/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/HospitalScreeningMapper.xml b/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/HospitalScreeningMapper.xml
index a501e7e..8d86f78 100644
--- a/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/HospitalScreeningMapper.xml
+++ b/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/HospitalScreeningMapper.xml
@@ -63,6 +63,9 @@
             <if test="p.homePage != null and p.homePage !=''">
                 and home_page = #{p.homePage}
             </if>
+             <if test="p.keyWord != null and p.keyWord !=''">
+                and hospital_name like concat('%', #{p.keyWord}, '%')
+            </if>
         </where>
     </sql>
 

--
Gitblit v1.8.0