From d91ac5a381bc7013644081ab0f2591a2cb450452 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Sat, 11 Nov 2023 22:10:25 +0800
Subject: [PATCH] 网格数据查询完善
---
src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml | 5 +++++
src/main/java/org/springblade/modules/grid/vo/GridVO.java | 4 ++++
src/main/java/org/springblade/modules/grid/mapper/GridMapper.xml | 5 ++++-
3 files changed, 13 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml b/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml
index a04fcaa..e987cc5 100644
--- a/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml
+++ b/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml
@@ -252,4 +252,9 @@
</if>
</select>
+ <!--查询社区信息-->
+ <select id="getAllDoorplateAddress" resultType="org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity">
+ select * from jczz_doorplate_address where nei_name = #{name}
+ </select>
+
</mapper>
diff --git a/src/main/java/org/springblade/modules/grid/mapper/GridMapper.xml b/src/main/java/org/springblade/modules/grid/mapper/GridMapper.xml
index 6efeabd..3f07461 100644
--- a/src/main/java/org/springblade/modules/grid/mapper/GridMapper.xml
+++ b/src/main/java/org/springblade/modules/grid/mapper/GridMapper.xml
@@ -9,8 +9,11 @@
<!--根据地址编号查询网格数据-->
<select id="getGridDetailByHouseCode" resultType="org.springblade.modules.grid.vo.GridVO">
- select jg.* from jczz_grid jg
+ select jg.id,jg.grid_name,jg.community_name,
+ bu.real_name as realName,bu.phone as gridPhone
+ from jczz_grid jg
left join jczz_grid_range jgr on jg.id = jgr.grid_id
+ left join blade_user bu on bu.id = jg.user_id and bu.is_deleted = 0
where jg.is_deleted = 0
and jgr.house_code = #{houseCode}
</select>
diff --git a/src/main/java/org/springblade/modules/grid/vo/GridVO.java b/src/main/java/org/springblade/modules/grid/vo/GridVO.java
index 0e3e11a..8b0f314 100644
--- a/src/main/java/org/springblade/modules/grid/vo/GridVO.java
+++ b/src/main/java/org/springblade/modules/grid/vo/GridVO.java
@@ -32,4 +32,8 @@
public class GridVO extends GridEntity {
private static final long serialVersionUID = 1L;
+ private String realName;
+
+ private String gridPhone;
+
}
--
Gitblit v1.9.3