From 4adb7e037599e4cbc3049a9a1ba965cfc7b05c38 Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Mon, 20 Dec 2021 10:06:19 +0800
Subject: [PATCH] deivce增加乡镇街道信息
---
screen-job/src/main/resources/mapper/DeviceMapper.xml | 1 +
screen-manage/src/main/java/com/moral/api/pojo/vo/device/DeviceVO.java | 6 +++++-
screen-manage/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java | 3 +++
screen-manage/src/main/resources/mapper/DeviceMapper.xml | 23 +++++++++++++++++++----
screen-api/src/main/java/com/moral/api/entity/Device.java | 5 +++++
screen-job/src/main/java/com/moral/api/entity/Device.java | 5 +++++
screen-manage/src/main/java/com/moral/api/entity/Device.java | 5 +++++
screen-api/src/main/resources/mapper/DeviceMapper.xml | 1 +
8 files changed, 44 insertions(+), 5 deletions(-)
diff --git a/screen-api/src/main/java/com/moral/api/entity/Device.java b/screen-api/src/main/java/com/moral/api/entity/Device.java
index beec53d..401ade5 100644
--- a/screen-api/src/main/java/com/moral/api/entity/Device.java
+++ b/screen-api/src/main/java/com/moral/api/entity/Device.java
@@ -135,6 +135,11 @@
*/
private String extend;
+ /**
+ * ���������������code
+ */
+ private Integer townCode;
+
/*
* ������������
* */
diff --git a/screen-api/src/main/resources/mapper/DeviceMapper.xml b/screen-api/src/main/resources/mapper/DeviceMapper.xml
index ce3522f..9108824 100644
--- a/screen-api/src/main/resources/mapper/DeviceMapper.xml
+++ b/screen-api/src/main/resources/mapper/DeviceMapper.xml
@@ -25,6 +25,7 @@
<result column="install_time" property="installTime"/>
<result column="is_delete" property="isDelete"/>
<result column="extend" property="extend"/>
+ <result column="town_code" property="townCode"/>
</resultMap>
<!--���������������������������-->
diff --git a/screen-job/src/main/java/com/moral/api/entity/Device.java b/screen-job/src/main/java/com/moral/api/entity/Device.java
index f055d6b..de3dc87 100644
--- a/screen-job/src/main/java/com/moral/api/entity/Device.java
+++ b/screen-job/src/main/java/com/moral/api/entity/Device.java
@@ -129,6 +129,11 @@
*/
private String extend;
+ /**
+ * ���������������code
+ */
+ private Integer townCode;
+
@Override
protected Serializable pkVal() {
diff --git a/screen-job/src/main/resources/mapper/DeviceMapper.xml b/screen-job/src/main/resources/mapper/DeviceMapper.xml
index a44b860..f3c46db 100644
--- a/screen-job/src/main/resources/mapper/DeviceMapper.xml
+++ b/screen-job/src/main/resources/mapper/DeviceMapper.xml
@@ -25,6 +25,7 @@
<result column="install_time" property="installTime"/>
<result column="is_delete" property="isDelete"/>
<result column="extend" property="extend"/>
+ <result column="town_code" property="townCode"/>
</resultMap>
</mapper>
\ No newline at end of file
diff --git a/screen-manage/src/main/java/com/moral/api/entity/Device.java b/screen-manage/src/main/java/com/moral/api/entity/Device.java
index c978a90..ccf7d28 100644
--- a/screen-manage/src/main/java/com/moral/api/entity/Device.java
+++ b/screen-manage/src/main/java/com/moral/api/entity/Device.java
@@ -135,6 +135,11 @@
*/
private String extend;
+ /**
+ * ���������������code
+ */
+ private Integer townCode;
+
/*
* ������������
* */
diff --git a/screen-manage/src/main/java/com/moral/api/pojo/vo/device/DeviceVO.java b/screen-manage/src/main/java/com/moral/api/pojo/vo/device/DeviceVO.java
index eb1404c..0c5f8d1 100644
--- a/screen-manage/src/main/java/com/moral/api/pojo/vo/device/DeviceVO.java
+++ b/screen-manage/src/main/java/com/moral/api/pojo/vo/device/DeviceVO.java
@@ -22,7 +22,6 @@
* */
private List<Map<String, Object>> professions;
-
/*
* ������
* */
@@ -63,5 +62,10 @@
* */
private List<ManageAccount> operators;
+ /*
+ * ������������
+ * */
+ private Map<String, Object> town;
+
}
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java
index aa34315..03a4812 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java
@@ -348,6 +348,9 @@
//������������
deviceInfo.put("extend", device.getExtend());
+ //������������������
+ deviceInfo.put("town", device.getTown());
+
//������
deviceInfo.put("professions", device.getProfessions());
diff --git a/screen-manage/src/main/resources/mapper/DeviceMapper.xml b/screen-manage/src/main/resources/mapper/DeviceMapper.xml
index 8e24faa..178e9d0 100644
--- a/screen-manage/src/main/resources/mapper/DeviceMapper.xml
+++ b/screen-manage/src/main/resources/mapper/DeviceMapper.xml
@@ -25,6 +25,7 @@
<result column="install_time" property="installTime"/>
<result column="is_delete" property="isDelete"/>
<result column="extend" property="extend"/>
+ <result column="town_code" property="townCode"/>
</resultMap>
<resultMap id="resultMap" type="com.moral.api.pojo.vo.device.DeviceVO" extends="BaseResultMap">
@@ -62,6 +63,12 @@
<association property="version" javaType="com.moral.api.entity.Version">
<result column="version_id" property="id"/>
<result column="version_name" property="name"/>
+ </association>
+
+ <!--������������-->
+ <association property="town" javaType="java.util.HashMap">
+ <result column="town_code" property="areaCode"/>
+ <result column="town_name" property="name"/>
</association>
<!--���������������-->
@@ -124,6 +131,8 @@
d.create_time,
d.install_time,
d.extend,
+ d.town_code,
+ sa.area_name town_name,
o.id org_id,
o.`name` org_name,
mp.id mp_id,
@@ -156,13 +165,16 @@
(
ma.id, (SELECT operate_ids FROM device WHERE id = d.id)
)
+ LEFT JOIN `sys_area` sa
+ ON d.town_code = sa.area_code
LEFT JOIN
(
SELECT sdt.`name`, sdd.dataKey, sdd.dataValue
FROM sys_dict_type sdt,
sys_dict_data sdd
WHERE sdt.id = sdd.dict_type_id
- AND sdt.`name` = 'profession'
+ AND sdt.`name` = 'profession'
+ AND sdd.is_delete = '0'
) profession
ON FIND_IN_SET
(
@@ -175,7 +187,8 @@
FROM sys_dict_type sdt,
sys_dict_data sdd
WHERE sdt.id = sdd.dict_type_id
- AND sdt.`name` = 'tech'
+ AND sdt.`name` = 'tech'
+ AND sdd.is_delete = '0'
) tech
ON d.tech = tech.dataKey
@@ -185,7 +198,8 @@
FROM sys_dict_type sdt,
sys_dict_data sdd
WHERE sdt.id = sdd.dict_type_id
- AND sdt.`name` = 'detector'
+ AND sdt.`name` = 'detector'
+ AND sdd.is_delete = '0'
) detector
ON d.detector = detector.dataKey
@@ -195,7 +209,8 @@
FROM sys_dict_type sdt,
sys_dict_data sdd
WHERE sdt.id = sdd.dict_type_id
- AND sdt.`name` = 'purchaser'
+ AND sdt.`name` = 'purchaser'
+ AND sdd.is_delete = '0'
) purchaser
ON d.purchaser = purchaser.dataKey
WHERE d.id = #{deviceId}
--
Gitblit v1.8.0