select ST_AsText(geography) from mall_business

  "templateSql": {
        "message": {
          "delete": "删除:总数{0}条,成功{1}条,失败{2}条。",
          "update": "更新:总数{0}条,成功{1}条,失败{2}条。",
          "edit": "修改:总数{0}条,成功{1}条,失败{2}条。",
          "add": "新增:总数{0}条,成功{1}条,失败{2}条。",
          "batSave": "批量保存:总数{0}条,新增成功{1}条,新增失败{2}条,删除成功{3}条,删除失败{4}条,修改成功{5}条,修改失败{6}条。",
          "treeSave": "信息分配:总数{0}条,新增成功{1}条,新增失败{2}条,删除成功{3}条,删除失败{4}条,修改成功{5}条,修改失败{6}条。"
        },
        "updateSql": "update {table_name} set {u_column} where {primary_where_sql}",
        "deleteSql": "delete from {table_name} where {primary_where_sql}",
        "insertSql": "insert into {table_name} ({i_column}) values  ({i_column_value});",
        "insertSqlReturn": "{insertSql}",
        //"iterationSql": "with temp as (select {iteration_id} ID,{iteration_parent_id} PARENT_ID from {table_name} WHERE {iteration_id}=@{iteration_id_value} {where_sql}  UNION ALL select T0.{iteration_id} ID,T0.{iteration_parent_id} PARENT_ID from temp,{table_name} T0 WHERE temp.{iteration_id}=T0.{iteration_parent_id} {where_sql_t0}) select ID VALUE from temp;",
        "insertSort": "(select min(tb_sort.sort_id) from (select (IFNULL(min({insert_sort_name}),99999999)-3) sort_id from {table_name} where {insert_sort_name}>1000) tb_sort)",
        "clickSql": " update {table_name} set {u_column}=IFNULL({u_column},0)+1 where {primary_where_sql}",
        //特殊属性集成
        "dateDiffSort": "(case when TIMESTAMPDIFF(MINUTE,{date_diff_column},@_currentDate)<{date_diff_minute} then 0 else 1 end)",
        "dateDiffValue": "TIMESTAMPDIFF(MINUTE,{date_diff_column},@_currentDate)",
        "geographyFromText": "ST_GeomFromText(@stFromText)",
        "geographyAsText": "ST_AsText({st_col_name}) {st_col_name}",
        "geographySrid": 4326,
        "geographyWkid": 4326,
        "geographyPoint": "'POINT({st_lng} {st_lat})'",
        "geographyLine": "LINESTRING({st_line}))",
        "geographyPolygon": "POLYGON(({st_area}))",
        "geographyDistance": "ST_DISTANCE_SPHERE(ST_GeomFromText(@stStartLngLat),ST_GeomFromText(@stEndLngLat))",
        "geographyDbDistance": "ST_DISTANCE_SPHERE({st_geography},ST_GeomFromText(@stEndLngLat))",
        "geographyArea": "ST_Area(ST_GeomFromText(@stPolygon))",
        "geographyDbArea": "({st_geography})",
        "nullSql": "IFNULL({null_o},{null_new})"
      },
文档更新时间: 2022-01-12 11:59   作者:admin