小区详情自定义查询新增

zhongrj

2023-12-01 315296e7735dc7403b263bb9dc3828199f6dd730

小区详情自定义查询新增

 src/main/java/org/springblade/modules/district/controller/DistrictController.java

@@ -60,6 +60,18 @@
        DistrictEntity detail = districtService.getOne(Condition.getQueryWrapper(district));
        return R.data(DistrictWrapper.build().entityVO(detail));
    }


    /**
     * 小区表 自定义获取详情
     * @param district
     * @return
     */
    @GetMapping("/getDetail")
    public R<DistrictVO> getDetail(DistrictVO district) {
        return R.data(districtService.getDetail(district));
    }

    /**
     * 小区表 分页
     */

 src/main/java/org/springblade/modules/district/mapper/DistrictMapper.java

@@ -49,4 +49,11 @@
     */
    @MapKey(value = "id")
    Map<String, TreeStringNode> getDistrictTree(@Param("district") DistrictVO district);

    /**
     * 小区表 自定义获取详情
     * @param district
     * @return
     */
    DistrictVO getDetail(@Param("district") DistrictVO district);
}

 src/main/java/org/springblade/modules/district/mapper/DistrictMapper.xml

@@ -49,5 +49,16 @@
        )
    </select>

    <!--小区自定义获取详情查询-->
    <select id="getDetail" resultType="org.springblade.modules.district.vo.DistrictVO">
        SELECT
        jd.*,
        jda.nei_code as communityCode,jda.nei_name as communityName
        FROM jczz_district jd
        left join jczz_doorplate_address jda on jda.aoi_code = jd.aoi_code
        where jd.is_deleted = 0
        and jda.address_code = #{district.houseCode}
    </select>


</mapper>

 src/main/java/org/springblade/modules/district/service/IDistrictService.java

@@ -46,4 +46,11 @@
     * @return
     */
    Object getDistrictTree(DistrictVO district);

    /**
     * 小区表 自定义获取详情
     * @param district
     * @return
     */
    DistrictVO getDetail(DistrictVO district);
}

 src/main/java/org/springblade/modules/district/service/impl/DistrictServiceImpl.java

@@ -68,4 +68,15 @@
            node.setChildren(null);
        }
    }

    /**
     * 小区表 自定义获取详情
     * @param district
     * @return
     */
    @Override
    public DistrictVO getDetail(DistrictVO district) {
        // 小区自定义获取详情查询并返回
        return baseMapper.getDetail(district);
    }
}

 src/main/java/org/springblade/modules/district/vo/DistrictVO.java

@@ -32,4 +32,14 @@
public class DistrictVO extends DistrictEntity {
    private static final long serialVersionUID = 1L;

    /**
     * 地址门牌编号
     */
    private String houseCode;

    /**
     * 居委会名称
     */
    private String communityName;

}