From e38e0b2daa190580066b8bfe714a479accb799d9 Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Sat, 13 Mar 2021 15:32:09 +0800
Subject: [PATCH] 1.查询警情附近人员

---
 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/mapper/PositionMapper.xml             |   16 ++++++++++++++++
 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/service/IPositionService.java         |    1 +
 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/mapper/PositionMapper.java            |    1 +
 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/controller/PositionController.java    |   10 ++++++++++
 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/service/impl/PositionServiceImpl.java |    5 +++++
 5 files changed, 33 insertions(+), 0 deletions(-)

diff --git a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/controller/PositionController.java b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/controller/PositionController.java
index fb14449..deb3db0 100644
--- a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/controller/PositionController.java
+++ b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/controller/PositionController.java
@@ -210,4 +210,14 @@
 
 	}
 
+	/**
+	 * 通过警情位置查询附近安保人员
+	 * @return
+	 */
+	@PostMapping("/selectfj")
+	@ApiOperation(value = "通过警情位置查询附近安保人员", notes = "经纬度")
+	public R selectry(String jd,String wd) {
+		return R.data(positionService.selectfj(jd, wd));
+	}
+
 }
diff --git a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/mapper/PositionMapper.java b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/mapper/PositionMapper.java
index f5085a2..cdb66a2 100644
--- a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/mapper/PositionMapper.java
+++ b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/mapper/PositionMapper.java
@@ -48,5 +48,6 @@
 	int selectc(String snumber);
 
 	List<Map<String, Object>> selectry(String coordinate);
+	List<Map<String, Object>> selectfj(String jd,String wd);
 
 }
diff --git a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/mapper/PositionMapper.xml b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/mapper/PositionMapper.xml
index 24c9ff8..2831804 100644
--- a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/mapper/PositionMapper.xml
+++ b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/mapper/PositionMapper.xml
@@ -62,4 +62,20 @@
         SELECT count(*) FROM sys_position WHERE snumber=#{snumber}
     </select>
 
+    <select id="selectfj" resultType="java.util.HashMap">
+        SELECT
+        snumber, `sname`,(
+        6371 * acos (
+        cos ( radians(wd) )
+        * cos( radians(#{wd}) )
+        * cos( radians(jd) - radians(#{jd}) )
+        + sin ( radians(#{wd}) )
+        * sin( radians(wd))
+        )
+        ) AS distance
+        FROM sys_position
+        HAVING distance &lt;=5
+        ORDER BY distance
+    </select>
+
 </mapper>
diff --git a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/service/IPositionService.java b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/service/IPositionService.java
index 55484f7..214c83d 100644
--- a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/service/IPositionService.java
+++ b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/service/IPositionService.java
@@ -47,4 +47,5 @@
 	List<Map<String, Object>> selectry(String coordinate);
 	void updateb(String snumber, String sname, String jd, String wd, String stime);
 	int selectc(String snumber);
+	List<Map<String, Object>> selectfj(String jd,String wd);
 }
diff --git a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/service/impl/PositionServiceImpl.java b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/service/impl/PositionServiceImpl.java
index 395d9d9..a3b1884 100644
--- a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/service/impl/PositionServiceImpl.java
+++ b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/position/service/impl/PositionServiceImpl.java
@@ -71,4 +71,9 @@
 		return baseMapper.selectc(snumber);
 	}
 
+	@Override
+	public List<Map<String, Object>> selectfj(String jd, String wd) {
+		return baseMapper.selectfj(jd, wd);
+	}
+
 }

--
Gitblit v1.9.3