From f56957785bc3fc4babad6b1d9c8ca69c95518e28 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Fri, 03 Nov 2023 13:44:09 +0800
Subject: [PATCH] 门牌详情查询
---
src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml | 12 ++++++++++++
src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java | 3 +++
src/main/java/org/springblade/modules/doorplateAddress/service/IDoorplateAddressService.java | 2 ++
src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java | 8 ++++++++
src/main/java/org/springblade/modules/doorplateAddress/controller/DoorplateAddressController.java | 10 ++++++++++
src/main/java/org/springblade/modules/doorplateAddress/vo/DoorplateAddressVO.java | 4 ++++
6 files changed, 39 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/doorplateAddress/controller/DoorplateAddressController.java b/src/main/java/org/springblade/modules/doorplateAddress/controller/DoorplateAddressController.java
index 4743f59..5352ef5 100644
--- a/src/main/java/org/springblade/modules/doorplateAddress/controller/DoorplateAddressController.java
+++ b/src/main/java/org/springblade/modules/doorplateAddress/controller/DoorplateAddressController.java
@@ -168,4 +168,14 @@
return R.data(list);
}
+ /**
+ * 根据参数获取地址详情
+ * @return
+ */
+ @GetMapping("/getDoorplateAddressDetail")
+ public R getDoorplateAddressDetail(DoorplateAddressVO doorplateAddressVO){
+ DoorplateAddressVO detail = doorplateAddressService.getDoorplateAddressDetail(doorplateAddressVO);
+ return R.data(detail);
+ }
+
}
diff --git a/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java b/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java
index e86d8ce..face952 100644
--- a/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java
+++ b/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java
@@ -18,6 +18,7 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
+import liquibase.pro.packaged.P;
import org.apache.ibatis.annotations.Param;
import org.springblade.common.node.TreeNode;
import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
@@ -115,4 +116,6 @@
* @return
*/
List<FuncNode> getDoorplateNameList(@Param("name") String name,@Param("code") String code);
+
+ DoorplateAddressVO getDoorplateAddressDetail(@Param("vo") DoorplateAddressVO doorplateAddressVO);
}
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 71bf634..1188774 100644
--- a/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml
+++ b/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml
@@ -175,5 +175,17 @@
and nei_code = #{name}
and aoi_code is null
</select>
+ <select id="getDoorplateAddressDetail"
+ resultType="org.springblade.modules.doorplateAddress.vo.DoorplateAddressVO">
+
+ SELECT * FROM jczz_doorplate_address
+ WHERE 1=1
+ <if test="vo.stdId != null and vo.stdId != ''">
+ AND address_code = #{vo.stdId}
+ </if>
+ <if test="vo.buildingCode != null and vo.buildingCode !='' ">
+ AND building_code = #{vo.buildingCode}
+ </if>
+ </select>
</mapper>
diff --git a/src/main/java/org/springblade/modules/doorplateAddress/service/IDoorplateAddressService.java b/src/main/java/org/springblade/modules/doorplateAddress/service/IDoorplateAddressService.java
index 7a28aa9..cc28812 100644
--- a/src/main/java/org/springblade/modules/doorplateAddress/service/IDoorplateAddressService.java
+++ b/src/main/java/org/springblade/modules/doorplateAddress/service/IDoorplateAddressService.java
@@ -65,4 +65,6 @@
Object getHouseRentInfo(String code);
List<DoorplateAddressVOTree> getDoorplateAddressList(String code, String type);
+
+ DoorplateAddressVO getDoorplateAddressDetail(DoorplateAddressVO doorplateAddressVO);
}
diff --git a/src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java b/src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java
index 7c2927b..0f43fca 100644
--- a/src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java
+++ b/src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java
@@ -304,4 +304,12 @@
return list;
}
+
+ @Override
+ public DoorplateAddressVO getDoorplateAddressDetail(DoorplateAddressVO doorplateAddressVO) {
+
+ DoorplateAddressVO detail = baseMapper.getDoorplateAddressDetail(doorplateAddressVO);
+
+ return detail;
+ }
}
diff --git a/src/main/java/org/springblade/modules/doorplateAddress/vo/DoorplateAddressVO.java b/src/main/java/org/springblade/modules/doorplateAddress/vo/DoorplateAddressVO.java
index ad1cd1e..d651e97 100644
--- a/src/main/java/org/springblade/modules/doorplateAddress/vo/DoorplateAddressVO.java
+++ b/src/main/java/org/springblade/modules/doorplateAddress/vo/DoorplateAddressVO.java
@@ -24,4 +24,8 @@
private List<HouseholdVO> householdList = new ArrayList<>();
+ //对应address_code 或者 doorplate_address_code
+ private String stdId;
+
+
}
--
Gitblit v1.9.3