小程序查询住户过滤

lin

2024-03-21 6136dc2a9550b71576267871228490b890c82852

小程序查询住户过滤

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

@@ -235,6 +235,10 @@
            <if test="household.houseCode!=null and household.houseCode !=''">
                and jh.house_code = #{household.houseCode}
            </if>

            <if test="household.communityCode!=null and household.communityCode !=''">
                and jg.community_code = #{household.communityCode}
            </if>
                <!-- 等于18 就是租户 -->
            <if test="household.relationship!=null and household.relationship == 18">
                and jh.relationship = #{household.relationship}