1.查询警情附近人员

tangzy

2021-03-13 e38e0b2daa190580066b8bfe714a479accb799d9

1.查询警情附近人员

 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));
    }

}

 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);

}

 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>

 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);
}

 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);
    }

}