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