人员房屋查询修改

zhongrj

2024-01-05 570299edad5e17997b1d456775dc0887cac0f3f2

人员房屋查询修改

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

@@ -216,9 +216,9 @@
               jda.aoi_code        aoiCode,
               jh.relationship     relationship
        from jczz_household jh
                 left join jczz_doorplate_address jda on jh.house_code = jda.address_code
        where 1 = 1
          and associated_user_id = #{userId}
        left join jczz_doorplate_address jda on jh.house_code = jda.address_code
        where 1 = 1 and jh.is_deleted = 0
        and jh.associated_user_id = #{userId}
    </select>

    <!--查询房屋集合信息-->