排除住户名称为空的

zhongrj

2024-01-08 f4caaf6b9026c9500a4443baadf2b495f201634b

排除住户名称为空的

 src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml

@@ -709,6 +709,7 @@
                and CONCAT(jh.name,jh.phone_number) like CONCAT ('%', #{household.searchKey},'%')
            </if>
            and jh.is_deleted = 0
            and jh.name != '' and jh.name is not null
            order by jh.create_time desc,jh.id desc
            <if test="household.limit!=null">
                limit #{household.limit}