商超名称为空排除

zhongrj

2024-01-08 c5694f6b5cb5c1c2a8d5e11767c34f01863113fb

商超名称为空排除

 src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml

@@ -431,6 +431,7 @@
        from jczz_place_rel jpl
        join jczz_place jp on jpl.place_id = jp.id and jp.is_deleted = 0
        where jpl.is_deleted = 0
        and doorplate_num!=''
        <if test="houseParam.communityName!=null and houseParam.communityName!=''">
            and community_name like concat('%',#{houseParam.communityName},'%')
        </if>