mapper_bs-user-address_sql__columns.json

{
  "columns": {
    //#region geography 经纬度 点 
    "geography": {
      "tableId": 1,
      "field": "geography",
      "dataType": "geography",
      "title": "地理位置",
      "name": "geography",
      "alias": "geography",
      "isData": true,
      "geography": {
        "type": "point",
        "geography": "geography",
        "outPut": "lnglat" //lnglat json 
      },
      "editPropertie": { "showMethod": "text" },
      "pagePropertie": { "showMethod": "text" },
      "maxLength": -1
    },
    "lng": {
      "extendAlias": "lng",
      "tableId": 1,
      "field": "lng",
      "dataType": "numeric",
      "title": "经度",
      "name": "lng",
      "alias": "lng",
      "maxLength": 18,
      "colDecimal": 15
    },
    "lat": {
      "extendAlias": "lat",
      "tableId": 1,
      "field": "lat",
      "dataType": "numeric",
      "title": "纬度",
      "name": "lat",
      "alias": "lat",
      "maxLength": 17,
      "colDecimal": 15
    },
    //#endregion geography 经纬度 点
  }
}

计算2点之间距离

    "map-poi": {
      // #region 计算2点之间距离 order必须至少2个字段
      "all": "{distance} distance,{distance_current} distance_current",
      "order": " {distance},modify_time",
      // #endregion 计算2点之间距离
      "extend": "ts",
      "original": "description",
      "pageSize": 10,
      "show": "{geography}",
      "where": "{where_sql} and DeleteMark=1)"
    },

 // #region 计算2点之间距离
    "distance": {
      "tableId": 1,
      "field": "distance",
      "dataType": "varchar",
      "title": "距离",
      "remark": "计算2点之间距离",
      "name": "distance",
      "alias": "distance",
      "isData": false,
      "geography": {
        "type": "point2point",
        "geography": "geography",
        "pointLng": null,
        "pointLat": null,
        "endLng": "@_userLng",
        "endLat": "@_userLat",
        "line": null,
        "polygon": null
      },
      "editPropertie": { "showMethod": "text" },
      "pagePropertie": {
        "showMethod": "text"
      },
      "maxLength": 36,
      "range": [
        {
          "min": 0,
          "max": 1000,
          "format": "f0",
          "unit": "m"
        },
        {
          "min": 1000,
          "format": "f2",
          "unit": "km",
          "divisor": 1000
        }
      ],
      "placeholder": "-"
    },
    // #endregion 计算2点之间距离


    // #region 当前距离
   "distanceCurrent":{
      "tableId": 1,
      "field": "distanceCurrent",
      "dataType": "varchar",
      "title": "当前距离",
      "remark": "计算2点之间距离",
      "name": "distance_current",
      "alias": "distance_current",
      "isData": false,
      "geography": {
        "type": "point2point",
        "geography": "geography",
        "pointLng": null,
        "pointLat": null,
        "endLng": "@_userLng",
        "endLat": "@_userLat",
        "line": null,
        "polygon": null
      },
      "editPropertie": { "showMethod": "text" },
      "pagePropertie": {
        "showMethod": "text"
      },
      "maxLength": 36,
      "range": [
        {
          "min": 0,
          "max": 1000,
          "format": "f0",
          "unit": "m"
        },
        {
          "min": 1000,
          "format": "f2",
          "unit": "km",
          "divisor": 1000
        }
      ],
      "placeholder": "-"
    },
    // #endregion 当前距离


    // #region 点数据
   "geography":{
      "tableId": 1,
      "field": "geography",
      "dataType": "varchar",
      "title": "点",
      "remark": "获取点数据",
      "name": "geography",
      "alias": "geography",
      "isData": true,
      "geography": {
        "type": "point",
        "geography": "geography"
      },
      "editPropertie": { "showMethod": "text" },
      "pagePropertie": {
        "showMethod": "text"
      },
      "maxLength": 36
    },
    // #endregion 点数据