From a00d28306e1892e516e451fe060f2c019cb2f637 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Sat, 23 Dec 2023 15:59:13 +0800
Subject: [PATCH] 新增网格员详情查询
---
src/main/java/org/springblade/modules/grid/service/impl/GridmanServiceImpl.java | 8 ++++++++
src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.java | 5 +++++
src/main/java/org/springblade/modules/grid/service/IGridmanService.java | 5 +++++
src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.xml | 9 +++++++++
src/main/java/org/springblade/modules/grid/controller/GridmanController.java | 8 ++++++++
5 files changed, 35 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/grid/controller/GridmanController.java b/src/main/java/org/springblade/modules/grid/controller/GridmanController.java
index 75187a3..13d2f91 100644
--- a/src/main/java/org/springblade/modules/grid/controller/GridmanController.java
+++ b/src/main/java/org/springblade/modules/grid/controller/GridmanController.java
@@ -62,6 +62,14 @@
GridmanEntity detail = gridmanService.getOne(Condition.getQueryWrapper(gridman));
return R.data(GridmanWrapper.build().entityVO(detail));
}
+
+ /**
+ * 网格员表 自定义详情
+ */
+ @GetMapping("/getDetail")
+ public R<GridmanVO> getDetail(GridmanEntity gridman) {
+ return R.data(gridmanService.getDetail(gridman));
+ }
/**
* 网格员表 分页
*/
diff --git a/src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.java b/src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.java
index 439286f..b658a9d 100644
--- a/src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.java
+++ b/src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.java
@@ -51,4 +51,9 @@
Integer getGridStatistics(String code, Long userId);
Integer getCompanyStatistics(String code, Long userId);
+
+ /**
+ * 网格员表 自定义详情
+ */
+ GridmanVO getDetail(@Param("gridman") GridmanEntity gridman);
}
diff --git a/src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.xml b/src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.xml
index 85fed75..78a2697 100644
--- a/src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.xml
+++ b/src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.xml
@@ -103,4 +103,13 @@
</select>
+ <!--网格员表 自定义详情-->
+ <select id="getDetail" resultType="org.springblade.modules.grid.vo.GridmanVO">
+ select
+ jgm.*,jg.community_code communityCode
+ from jczz_gridman jgm
+ left join jczz_grid jg on jg.id = jgm.grid_id and jg.is_deleted = 0
+ where jgm.is_deleted = 0
+ and jgm.id = #{gridman.id}
+ </select>
</mapper>
diff --git a/src/main/java/org/springblade/modules/grid/service/IGridmanService.java b/src/main/java/org/springblade/modules/grid/service/IGridmanService.java
index 019c8a5..4ac16b0 100644
--- a/src/main/java/org/springblade/modules/grid/service/IGridmanService.java
+++ b/src/main/java/org/springblade/modules/grid/service/IGridmanService.java
@@ -64,4 +64,9 @@
List<GridmanVO> getGridmanList(GridmanVO gridman);
Object getGridStatistics(String code, String roleType);
+
+ /**
+ * 网格员表 自定义详情
+ */
+ GridmanVO getDetail(GridmanEntity gridman);
}
diff --git a/src/main/java/org/springblade/modules/grid/service/impl/GridmanServiceImpl.java b/src/main/java/org/springblade/modules/grid/service/impl/GridmanServiceImpl.java
index 3b5777b..375695b 100644
--- a/src/main/java/org/springblade/modules/grid/service/impl/GridmanServiceImpl.java
+++ b/src/main/java/org/springblade/modules/grid/service/impl/GridmanServiceImpl.java
@@ -195,4 +195,12 @@
}
return objectObjectHashMap;
}
+
+ /**
+ * 网格员表 自定义详情
+ */
+ @Override
+ public GridmanVO getDetail(GridmanEntity gridman) {
+ return baseMapper.getDetail(gridman);
+ }
}
--
Gitblit v1.9.3