springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml
@@ -244,7 +244,7 @@ LEFT JOIN com_mng_population_community_tags AS cmpct ON cmp.id = cmpct.population_id LEFT JOIN event_grid_data as egd on egd.grid_community_id = cmpct.community_id WHERE egd.id = #{populationListDTO.gridId} cmpct.community_id = #{populationListDTO.communityId} <if test = 'populationListDTO.keyWord != null and populationListDTO.keyWord != ""' > AND (cmp.`name` LIKE concat (#{populationListDTO.keyWord},'%') or cmp.card_no_str like concat (#{populationListDTO.keyWord},'%')) </if>