物业公司关联查询修改

zhongrj

2023-12-26 94e4f8d2e416d7d6f1089535b683542555346580

物业公司关联查询修改

 src/main/java/org/springblade/modules/property/mapper/PropertyCompanyDistrictMapper.xml

@@ -29,7 +29,7 @@
        jpcd.*,
        jd.name as districtName
        from jczz_property_company_district jpcd
        left join jczz_district jd on jd.id = jpca.district_id and jd.is_deleted = 0
        left join jczz_district jd on jd.id = jpcd.district_id and jd.is_deleted = 0
        where jpcd.is_deleted = 0
        <if test="propertyCompanyDistrict.propertyCompanyId!=null">
            and jpcd.property_company_id = #{propertyCompanyDistrict.propertyCompanyId}