From 2c9b2b31b726ac6764c76ea0b887665374a9088e Mon Sep 17 00:00:00 2001
From: zhouxiantao <1026371446@qq.com>
Date: Tue, 10 Sep 2024 18:01:47 +0800
Subject: [PATCH] 小程序地图坐标转换,和热点封面图

---
 dyh-service/dyh-base/src/main/java/cn/huge/base/common/utils/MapUtils.java              |  172 +++++++++++++++++++++++++++++++++++++++++++
 dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/domain/po/HotVideo.java            |    5 +
 dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/domain/po/HotNews.java             |    6 +
 dyh-service/dyh-base/src/main/java/cn/huge/base/common/utils/PointXY.java               |   18 ++++
 dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/dao/mapper/xml/HotNewsMapper.xml   |    2 
 dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/service/CaseInfoService.java |   10 +
 dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/dao/mapper/xml/HotVideoMapper.xml  |    2 
 7 files changed, 212 insertions(+), 3 deletions(-)

diff --git a/dyh-service/dyh-base/src/main/java/cn/huge/base/common/utils/MapUtils.java b/dyh-service/dyh-base/src/main/java/cn/huge/base/common/utils/MapUtils.java
new file mode 100644
index 0000000..2345e53
--- /dev/null
+++ b/dyh-service/dyh-base/src/main/java/cn/huge/base/common/utils/MapUtils.java
@@ -0,0 +1,172 @@
+package cn.huge.base.common.utils;
+
+
+import com.alibaba.fastjson.JSON;
+
+/**
+ * @author zhouxianta
+ * @create 2024-09-10 9:17
+ */
+public class MapUtils {
+    static double x_pi = 3.14159265358979324 * 3000.0 / 180.0;
+    // π
+    static double pi = 3.1415926535897932384626;
+    // 长半轴
+    static double a = 6378245.0;
+    // 扁率
+    static double ee = 0.00669342162296594323;
+    /**
+     * 百度坐标系(BD-09)转WGS坐标
+     *
+     * @param lng 百度坐标纬度
+     * @param lat 百度坐标经度
+     * @return WGS84坐标数组
+     */
+    public static PointXY bd09towgs84(double lng, double lat) {
+        PointXY gcj = bd09togcj02(lng, lat);
+        PointXY wgs84 = gcj02towgs84(gcj.getLon(), gcj.getLat());
+        return wgs84;
+    }
+    /**
+     * WGS坐标转百度坐标系(BD-09)
+     *
+     * @param lng WGS84坐标系的经度
+     * @param lat WGS84坐标系的纬度
+     * @return 百度坐标数组
+     */
+    public static PointXY wgs84tobd09(double lng, double lat) {
+        PointXY gcj = wgs84togcj02(lng, lat);
+        PointXY bd09 = gcj02tobd09(gcj.getLon(), gcj.getLat());
+        return bd09;
+    }
+    /**
+     * 火星坐标系(GCJ-02)转百度坐标系(BD-09)
+     * <p>
+     * 谷歌、高德——>百度
+     *
+     * @param lng 火星坐标经度
+     * @param lat 火星坐标纬度
+     * @return 百度坐标数组
+     */
+    public static PointXY gcj02tobd09(double lng, double lat) {
+        double z = Math.sqrt(lng * lng + lat * lat) + 0.00002 * Math.sin(lat * x_pi);
+        double theta = Math.atan2(lat, lng) + 0.000003 * Math.cos(lng * x_pi);
+        double bd_lng = z * Math.cos(theta) + 0.0065;
+        double bd_lat = z * Math.sin(theta) + 0.006;
+        return new PointXY(bd_lng, bd_lat);
+    }
+
+    /**
+     * 百度坐标系(BD-09)转火星坐标系(GCJ-02)
+     * <p>
+     * 百度——>谷歌、高德
+     *
+     * @param bd_lon 百度坐标纬度
+     * @param bd_lat 百度坐标经度
+     * @return 火星坐标数组
+     */
+    public static PointXY bd09togcj02(double bd_lon, double bd_lat) {
+        double x = bd_lon - 0.0065;
+        double y = bd_lat - 0.006;
+        double z = Math.sqrt(x * x + y * y) - 0.00002 * Math.sin(y * x_pi);
+        double theta = Math.atan2(y, x) - 0.000003 * Math.cos(x * x_pi);
+        double gg_lng = z * Math.cos(theta);
+        double gg_lat = z * Math.sin(theta);
+        return new PointXY(gg_lng, gg_lat);
+    }
+    /**
+     * WGS84转GCJ02(火星坐标系)
+     *
+     * @param lng WGS84坐标系的经度
+     * @param lat WGS84坐标系的纬度
+     * @return 火星坐标数组
+     */
+    public static PointXY wgs84togcj02(double lng, double lat) {
+        if (out_of_china(lng, lat)) {
+            return new PointXY(lng, lat);
+        }
+        double dlat = transformlat(lng - 105.0, lat - 35.0);
+        double dlng = transformlng(lng - 105.0, lat - 35.0);
+        double radlat = lat / 180.0 * pi;
+        double magic = Math.sin(radlat);
+        magic = 1 - ee * magic * magic;
+        double sqrtmagic = Math.sqrt(magic);
+        dlat = (dlat * 180.0) / ((a * (1 - ee)) / (magic * sqrtmagic) * pi);
+        dlng = (dlng * 180.0) / (a / sqrtmagic * Math.cos(radlat) * pi);
+        double mglat = lat + dlat;
+        double mglng = lng + dlng;
+        return new PointXY(mglng, mglat);
+    }
+    /**
+     * GCJ02(火星坐标系)转GPS84
+     *
+     * @param lng 火星坐标系的经度
+     * @param lat 火星坐标系纬度
+     * @return WGS84坐标数组
+     */
+    public static PointXY gcj02towgs84(double lng, double lat) {
+        if (out_of_china(lng, lat)) {
+            return new PointXY(lng, lat);
+        }
+        double dlat = transformlat(lng - 105.0, lat - 35.0);
+        double dlng = transformlng(lng - 105.0, lat - 35.0);
+        double radlat = lat / 180.0 * pi;
+        double magic = Math.sin(radlat);
+        magic = 1 - ee * magic * magic;
+        double sqrtmagic = Math.sqrt(magic);
+        dlat = (dlat * 180.0) / ((a * (1 - ee)) / (magic * sqrtmagic) * pi);
+        dlng = (dlng * 180.0) / (a / sqrtmagic * Math.cos(radlat) * pi);
+        double mglat = lat + dlat;
+        double mglng = lng + dlng;
+        return new PointXY(lng * 2 - mglng, lat * 2 - mglat);
+    }
+    /**
+     * 纬度转换
+     *
+     * @param lng
+     * @param lat
+     * @return
+     */
+    public static double transformlat(double lng, double lat) {
+        double ret = -100.0 + 2.0 * lng + 3.0 * lat + 0.2 * lat * lat + 0.1 * lng * lat + 0.2 * Math.sqrt(Math.abs(lng));
+        ret += (20.0 * Math.sin(6.0 * lng * pi) + 20.0 * Math.sin(2.0 * lng * pi)) * 2.0 / 3.0;
+        ret += (20.0 * Math.sin(lat * pi) + 40.0 * Math.sin(lat / 3.0 * pi)) * 2.0 / 3.0;
+        ret += (160.0 * Math.sin(lat / 12.0 * pi) + 320 * Math.sin(lat * pi / 30.0)) * 2.0 / 3.0;
+        return ret;
+    }
+    /**
+     * 经度转换
+     *
+     * @param lng
+     * @param lat
+     * @return
+     */
+    public static double transformlng(double lng, double lat) {
+        double ret = 300.0 + lng + 2.0 * lat + 0.1 * lng * lng + 0.1 * lng * lat + 0.1 * Math.sqrt(Math.abs(lng));
+        ret += (20.0 * Math.sin(6.0 * lng * pi) + 20.0 * Math.sin(2.0 * lng * pi)) * 2.0 / 3.0;
+        ret += (20.0 * Math.sin(lng * pi) + 40.0 * Math.sin(lng / 3.0 * pi)) * 2.0 / 3.0;
+        ret += (150.0 * Math.sin(lng / 12.0 * pi) + 300.0 * Math.sin(lng / 30.0 * pi)) * 2.0 / 3.0;
+        return ret;
+    }
+    /**
+     * 判断是否在国内,不在国内不做偏移
+     *
+     * @param lng
+     * @param lat
+     * @return
+     */
+    public static boolean out_of_china(double lng, double lat) {
+        if (lng < 72.004 || lng > 137.8347) {
+            return true;
+        } else if (lat < 0.8293 || lat > 55.8271) {
+            return true;
+        }
+        return false;
+    }
+
+    public static void main(String[] args) {
+        PointXY pointXY = MapUtils.gcj02tobd09(110.32941, 20.02971);
+        System.out.println(JSON.toJSONString(pointXY));
+    }
+
+}
diff --git a/dyh-service/dyh-base/src/main/java/cn/huge/base/common/utils/PointXY.java b/dyh-service/dyh-base/src/main/java/cn/huge/base/common/utils/PointXY.java
new file mode 100644
index 0000000..1118bd9
--- /dev/null
+++ b/dyh-service/dyh-base/src/main/java/cn/huge/base/common/utils/PointXY.java
@@ -0,0 +1,18 @@
+package cn.huge.base.common.utils;
+
+import lombok.Data;
+
+/**
+ * @author zhouxiantao
+ * @create 2023-12-29 9:18
+ */
+@Data
+public class PointXY {
+    private double lon;
+    private double lat;
+
+    public PointXY(double lon, double lat) {
+        this.lon = lon;
+        this.lat = lat;
+    }
+}
diff --git a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/service/CaseInfoService.java b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/service/CaseInfoService.java
index 0635f96..c5abb2e 100644
--- a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/service/CaseInfoService.java
+++ b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/service/CaseInfoService.java
@@ -1,9 +1,7 @@
 package cn.huge.module.cases.service;
 
 import cn.huge.base.common.exception.ServiceException;
-import cn.huge.base.common.utils.DateUtils;
-import cn.huge.base.common.utils.IdUtils;
-import cn.huge.base.common.utils.ObjectUtils;
+import cn.huge.base.common.utils.*;
 import cn.huge.module.cases.domain.dto.*;
 
 import cn.huge.module.cases.domain.po.CaseAgent;
@@ -553,6 +551,12 @@
             caseInfo.setUpdateTime(nowDate);
             caseInfo.setVisitTime(nowDate);
             caseInfo.setDeleteStatus(BaseConsts.DELETE_STATUS_0);
+            //坐标转换
+            if(ObjectUtils.isNotEmpty(caseInfo.getLat()) && ObjectUtils.isNotEmpty(caseInfo.getLng())){
+                PointXY pointXY = MapUtils.gcj02tobd09(Double.valueOf(caseInfo.getLng()), Double.valueOf(caseInfo.getLat()));
+                caseInfo.setLat(pointXY.getLat()+"");
+                caseInfo.setLng(pointXY.getLon()+"");
+            }
             //todo case_ref生成、case_title生成
             // 为了演示先兼容小程序没属地问题,写死属地
             if (caseInfo.getQueProvName() == null) {
diff --git a/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/dao/mapper/xml/HotNewsMapper.xml b/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/dao/mapper/xml/HotNewsMapper.xml
index 00603d3..3ba069d 100644
--- a/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/dao/mapper/xml/HotNewsMapper.xml
+++ b/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/dao/mapper/xml/HotNewsMapper.xml
@@ -17,6 +17,7 @@
             <result property="content" column="content"/>
             <result property="source" column="source"/>
             <result property="showUrl" column="show_url"/>
+            <result property="imageUrl" column="image_url"/>
             <result property="pushTime" column="push_time"/>
             <result property="playNum" column="play_num"/>
             <result property="goodNum" column="good_num"/>
@@ -35,6 +36,7 @@
         content,
         source,
         show_url,
+        image_url,
         push_time,
         play_num,
         good_num,
diff --git a/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/dao/mapper/xml/HotVideoMapper.xml b/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/dao/mapper/xml/HotVideoMapper.xml
index 1b6c3d7..c949c0e 100644
--- a/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/dao/mapper/xml/HotVideoMapper.xml
+++ b/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/dao/mapper/xml/HotVideoMapper.xml
@@ -14,6 +14,7 @@
             <result property="id" column="id"/>
             <result property="title" column="title"/>
             <result property="showUrl" column="show_url"/>
+            <result property="imageUrl" column="image_url"/>
             <result property="pushTime" column="push_time"/>
             <result property="playNum" column="play_num"/>
             <result property="goodNum" column="good_num"/>
@@ -29,6 +30,7 @@
         id,
         title,
         show_url,
+        image_url,
         push_time,
         play_num,
         good_num,
diff --git a/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/domain/po/HotNews.java b/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/domain/po/HotNews.java
index 88caecc..dcf8f6a 100644
--- a/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/domain/po/HotNews.java
+++ b/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/domain/po/HotNews.java
@@ -57,6 +57,12 @@
     private String showUrl;
 
     /**
+     * 封面连接
+     */
+    @TableField(value = "image_url")
+    private String imageUrl;
+
+    /**
     * 发布时间
     */
     @TableField(value = "push_time")
diff --git a/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/domain/po/HotVideo.java b/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/domain/po/HotVideo.java
index 8518675..ebb6a85 100644
--- a/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/domain/po/HotVideo.java
+++ b/dyh-service/dyh-sys/src/main/java/cn/huge/module/hot/domain/po/HotVideo.java
@@ -37,6 +37,11 @@
     */
     @TableField(value = "show_url")
     private String showUrl;
+    /**
+     * 封面连接
+     */
+    @TableField(value = "image_url")
+    private String imageUrl;
 
     /**
     * 发布时间

--
Gitblit v1.8.0