From 315296e7735dc7403b263bb9dc3828199f6dd730 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Fri, 01 Dec 2023 10:10:46 +0800
Subject: [PATCH] 小区详情自定义查询新增
---
src/main/java/org/springblade/modules/district/vo/DistrictVO.java | 10 ++++++++++
src/main/java/org/springblade/modules/district/mapper/DistrictMapper.xml | 11 +++++++++++
src/main/java/org/springblade/modules/district/controller/DistrictController.java | 12 ++++++++++++
src/main/java/org/springblade/modules/district/mapper/DistrictMapper.java | 7 +++++++
src/main/java/org/springblade/modules/district/service/impl/DistrictServiceImpl.java | 11 +++++++++++
src/main/java/org/springblade/modules/district/service/IDistrictService.java | 7 +++++++
6 files changed, 58 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/district/controller/DistrictController.java b/src/main/java/org/springblade/modules/district/controller/DistrictController.java
index 322561c..bbf14f4 100644
--- a/src/main/java/org/springblade/modules/district/controller/DistrictController.java
+++ b/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));
+ }
+
/**
* 小区表 分页
*/
diff --git a/src/main/java/org/springblade/modules/district/mapper/DistrictMapper.java b/src/main/java/org/springblade/modules/district/mapper/DistrictMapper.java
index b315152..8a195c9 100644
--- a/src/main/java/org/springblade/modules/district/mapper/DistrictMapper.java
+++ b/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);
}
diff --git a/src/main/java/org/springblade/modules/district/mapper/DistrictMapper.xml b/src/main/java/org/springblade/modules/district/mapper/DistrictMapper.xml
index 985fc29..986b4d3 100644
--- a/src/main/java/org/springblade/modules/district/mapper/DistrictMapper.xml
+++ b/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>
diff --git a/src/main/java/org/springblade/modules/district/service/IDistrictService.java b/src/main/java/org/springblade/modules/district/service/IDistrictService.java
index f45ad2f..50c75dd 100644
--- a/src/main/java/org/springblade/modules/district/service/IDistrictService.java
+++ b/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);
}
diff --git a/src/main/java/org/springblade/modules/district/service/impl/DistrictServiceImpl.java b/src/main/java/org/springblade/modules/district/service/impl/DistrictServiceImpl.java
index f6dc98e..2974ce4 100644
--- a/src/main/java/org/springblade/modules/district/service/impl/DistrictServiceImpl.java
+++ b/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);
+ }
}
diff --git a/src/main/java/org/springblade/modules/district/vo/DistrictVO.java b/src/main/java/org/springblade/modules/district/vo/DistrictVO.java
index 73c1ea2..b7c6d02 100644
--- a/src/main/java/org/springblade/modules/district/vo/DistrictVO.java
+++ b/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;
+
}
--
Gitblit v1.9.3