lng和lat双字段

查看 distance 和 lng 、lat

{
  "responseField": {
    "view": {
      // #region 计算2点之间距离 {geography},
      "all": "{distance} distance",
      "order": " {distance},area_code",
      // #endregion 计算2点之间距离 
      "showExtand": "null lng_lat",
      // min_lng,min_lat,max_lng,max_lat,remark,modify_time
      "show": "area_code,parent_code,area_name,short_name,lng,lat,full_name,province_code,city_code,district_code,town_code,village_code,level_type,pin_yin,jian_pin,first_char,zip_code,area_type,city_village_code",
      "original": "",
      "viewCountClosed": true,
      "where": " {where_sql} and is_enabled=1"
    },
    "view_detail": {
      // #region 计算2点之间距离
      "all": "{distance} distance",
      "order": " {distance},area_code",
      // #endregion 计算2点之间距离
      "showExtand": "null lng_lat",
      "show": "area_code,parent_code,area_name,short_name,lng,lat,full_name,province_code,city_code,district_code,town_code,village_code,level_type,pin_yin,jian_pin,first_char,zip_code,area_type,city_village_code",
      "primaryWhere": " {s-if:areaCode}{op-neq:999999} area_code=@areaCode {op-neq:999999}{e-if:areaCode} {s-if:mercId}{op-eq:999999} is_enabled=1 {op-eq:999999}{e-if:areaCode}",
      "original": "",
      "viewCountClosed": false
    }
  },
  "columns": {
    // #region 计算2点之间距离
    "distance": {
      "tableId": 1,
      "field": "distance",
      "dataType": "varchar",
      "title": "距离",
      "remark": "计算2点之间距离",
      "name": "distance",
      "alias": "distance",
      "isData": false,
      "geography": {
        "type": "point2point",
        //"geography": "geography",
        "pointLng": "lng",
        "pointLat": "lat",
        "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点之间距离
  }
}