xieb
2023-07-20 5908336cd6ac5d54c6acb9c8e53631256a736f43
测站经纬度范围查询
2 files modified
19 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/AttStBase.java 17 ●●●●● patch | view | raw | blame | history
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttStBaseMapper.xml 2 ●●● patch | view | raw | blame | history
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/AttStBase.java
@@ -76,18 +76,35 @@
    @ApiModelProperty(value = "站点详细地点")
    @TableField("\"station_location\"")
    private String stationLocation;
    /**
     * 站点经度
     */
    @ApiModelProperty(value = "站点经度")
    @TableField("\"station_longitude\"")
    private String stationLongitude;
    /**
     * 站点纬度
     */
    @ApiModelProperty(value = "站点纬度")
    @TableField("\"station_latitude\"")
    private String stationLatitude;
    /**
     * 站点经度
     */
    @ApiModelProperty(value = "水库经度")
    @TableField("\"center_long\"")
    private String centerLong;
    /**
     * 站点纬度
     */
    @ApiModelProperty(value = "水库纬度")
    @TableField("\"center_lat\"")
    private String centerLat;
    /**
     * 基面名称
     */
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttStBaseMapper.xml
@@ -4,7 +4,7 @@
    <select id="selectAttStBaseRadius" resultType="cn.gistack.sm.sjztmd.entity.AttStBase">
        select *
        from (select a.*,
        from (select a.*,b."center_lat", b."center_long",
                     Get_Distance(a."station_latitude", a."station_longitude", #{attStBase.stationLatitude}, #{attStBase.stationLongitude}) * 2.2 as radius,
                     Get_Distance(b."center_lat", b."center_long", #{attStBase.stationLatitude}, #{attStBase.stationLongitude}) * 2.2 as sk_radius
              from "att_st_base" a