• 小程序实现定位城市切换且城市根据首字母A-Z排序后端数据实现逻辑

    场景：

    话不多说后端提供数据实现步骤：

    1.controller层

    1. @Api(tags = {"[地区]-城市相关接口"})
    2. @RestController
    3. @RequestMapping("region")
    4. @Slf4j
    5. public class RegionController extends BaseController {
    6.  
    7.     @Resource
    8.     private RegionService regionService;
    9.  
    10. 	@ApiOperation("城市列表[A-Z]")
    11.     @ApiImplicitParams({
    12.             @ApiImplicitParam(name = "condition", value = "城市名称", required = false, paramType = "query")})
    13.     @GetMapping("cityList")
    14.     public JsonResult> cityList(@RequestParam(value = "condition", required = false) String condition) {
    15.         return JsonResult.ok(this.regionService.smallProgramCityDisplayList(condition));
    16.     }
    17.  
    18. 	@ApiOperation("城市列表")
    19.     @ApiImplicitParams({
    20.             @ApiImplicitParam(name = "condition", value = "城市名称", required = false, paramType = "query")})
    21.     @GetMapping("queryCityList")
    22.     public JsonResult> queryCityList(@RequestParam(value = "condition", required = false) String condition) {
    23.         return JsonResult.ok(this.regionService.queryCityList(condition));
    24.     }
    25.  
    26.     @Resource
    27.     private TencentMapUtil tencentMapUtil;
    28.  
    29.     @ApiOperation("根据经纬度查询地址")
    30.     @GetMapping("tencent/map/reGeoCoder")
    31.     public JsonResult reGeoCoder(String lat, String lng) {
    32.         AssertUtil.notBlank(lat, "纬度不能为空");
    33.         AssertUtil.notBlank(lng, "经度不能为空");
    34.         JSONObject jsonObject = tencentMapUtil.reGeoCoder(lat, lng);
    35.         if (EntityConstant.INVALID != jsonObject.getInteger("status")) {
    36.             log.error("定位授权失败 , errorMsg = {}", jsonObject.getString("message"));
    37.             throw SimpleException.getInstance("定位授权失败");
    38.         }
    39.         JSONObject adInfo = jsonObject.getJSONObject("result").getJSONObject("ad_info");
    40.         String city_code = adInfo.getString("city_code");
    41.         String nation_code = adInfo.getString("nation_code");
    42.         jsonObject.getJSONObject("result").getJSONObject("ad_info").put("cityCode", city_code.replaceAll(nation_code, ""));
    43.         return JsonResult.ok(jsonObject);
    44.     }
    45. }

    2.service层

    1. @Service
    2. @Slf4j
    3. @Primary
    4. public class RegionServiceImpl extends BaseApplicationService implements RegionService {
    5.  
    6.     @Resource
    7.     private RegionMapper regionMapper;
    8.  
    9.  
    10.     private static final char[] alphabet = new char[26];
    11.  
    12.     static {
    13.         // 使用循环填充数组元素
    14.         for (int i = 0; i < alphabet.length; i++) {
    15.             alphabet[i] = (char) ('A' + i);
    16.         }
    17.     }
    18.  
    19.     @Override
    20.     public List smallProgramCityDisplayList(String condition) {
    21.         List regionList = this.regionMapper.selectByExample(
    22.                 new ExampleLambda<>(Region.class)
    23.                         .andEqualTo(Region::getStatus, EntityConstant.NORMAL)
    24.                         .andEqualTo(Region::getLevel, 2)
    25.                         .andLike(Objects.nonNull(condition), Region::getName, condition)
    26.                         .end()
    27.         );
    28.         Map> cityMap = regionList.stream().collect(Collectors.groupingBy(Region::getInitial));
    29.         List cityListVOList = new ArrayList<>(this.alphabet.length);
    30.         for (char c : this.alphabet) {
    31.             List tempList = cityMap.containsKey(String.valueOf(c)) ? cityMap.get(String.valueOf(c)).stream().map(item -> {
    32.                 AppletCityListVO.CityItem cityItem = new AppletCityListVO.CityItem();
    33.                 cityItem.setCode(item.getCode());
    34.                 cityItem.setName(item.getName());
    35.                 return cityItem;
    36.             }).collect(Collectors.toList()) : new ArrayList<>(0);
    37.             cityListVOList.add(AppletCityListVO.builder().initial(String.valueOf(c)).itemList(tempList).build());
    38.         }
    39.         return cityListVOList;
    40.     }
    41.  
    42.     @Override
    43.     public List queryCityList(String condition) {
    44.         List regionList = this.regionMapper.selectByExample(
    45.                 new ExampleLambda<>(Region.class)
    46.                         .andEqualTo(Region::getStatus, EntityConstant.NORMAL)
    47.                         .andEqualTo(Region::getLevel, 2)
    48.                         .andLike(Objects.nonNull(condition), Region::getName, condition)
    49.                         .end()
    50.         );
    51.         return regionList.stream().map(item -> {
    52.             AppletCityListVO.CityItem cityItem = new AppletCityListVO.CityItem();
    53.             cityItem.setCode(item.getCode());
    54.             cityItem.setName(item.getName());
    55.             return cityItem;
    56.         }).collect(Collectors.toList());
    57.     }
    58.  
    59. }
    60.  
    61.  
    62. @Builder
    63. @Data
    64. public class AppletCityListVO  implements Serializable {
    65.  
    66.     @ApiModelProperty(value = "首字母")
    67.     private String initial;
    68.     @ApiModelProperty(value = "城市列表")
    69.     private List itemList;
    70.  
    71.     @Data
    72.     public static class CityItem {
    73.  
    74.         @ApiModelProperty(value = "code")
    75.         private String code;
    76.  
    77.         @ApiModelProperty(value = "名称")
    78.         private String name;
    79.  
    80.         public CityItem(String code, String name) {
    81.             this.code = code;
    82.             this.name = name;
    83.         }
    84.  
    85.         public CityItem() {
    86.  
    87.         }
    88.     }
    89.  
    90. }

    3.mapper层

    1. public interface RegionMapper extends CrudMapper {
    2.  
    3.  
    4. }


    4.实体类

    1. @Table(name = "`region`")
    2. @Data
    3. public class Region extends BaseEntity implements Serializable {
    4.  
    5.     private static final long serialVersionUID = 1L;
    6.  
    7.     /**
    8.      * Id
    9.      */
    10.     @Id
    11.     @GeneratedValue(strategy = GenerationType.IDENTITY)
    12.     private Long id;
    13.     /**
    14.      * 1
    15.      */
    16.     @Column(name = "level")
    17.     private Integer level;
    18.     /**
    19.      * code
    20.      */
    21.     @Column(name = "code")
    22.     private String code;
    23.     /**
    24.      * 父级code
    25.      */
    26.     @Column(name = "parent_code")
    27.     private String parentCode;
    28.     /**
    29.      * 名称
    30.      */
    31.     @Column(name = "name")
    32.     private String name;
    33.     /**
    34.      * 名称拼音
    35.      */
    36.     @Column(name = "pinyin")
    37.     private String pinyin;
    38.     /**
    39.      * 首字母
    40.      */
    41.     @Column(name = "initial")
    42.     private String initial;
    43.     /**
    44.      * 状态
    45.      */
    46.     @Column(name = "status")
    47.     private Integer status;
    48.     /**
    49.      * 创建时间
    50.      */
    51.     @Column(name = "gmt_created")
    52.     @JsonFormat(locale = "zh", pattern = "yyyy-MM-dd HH:mm:ss")
    53.     private Date gmtCreated;
    54.     /**
    55.      * ModifyUser
    56.      */
    57.     @Column(name = "modify_user")
    58.     private String modifyUser;
    59.     /**
    60.      * CreateUser
    61.      */
    62.     @Column(name = "create_user")
    63.     private String createUser;
    64.     /**
    65.      * 更新时间
    66.      */
    67.     @Column(name = "gmt_modified")
    68.     @JsonFormat(locale = "zh", pattern = "yyyy-MM-dd HH:mm:ss")
    69.     private Date gmtModified;
    70.     /**
    71.      * 是否删除
    72.      */
    73.     @Column(name = "deleted")
    74.     private Integer deleted;
    75. }


    5.腾讯地图处理工具类

    1. import cn.hutool.http.HttpUtil;
    2. import cn.hutool.json.JSONObject;
    3. import cn.hutool.json.JSONUtil;
    4. import lombok.extern.slf4j.Slf4j;
    5. import org.apache.commons.lang.StringUtils;
    6. import org.springframework.stereotype.Component;
    7.  
    8. import java.util.HashMap;
    9. import java.util.Objects;
    10.  
    11. @Slf4j
    12. @Component
    13. public class TencentMapUtil {
    14.  
    15.     private String qqAk = "xxxxx-xxxxx-xxxxx-xxxxx-xxxxx-xxxxx";
    16.     private String geoCoder = "https://apis.map.qq.com/ws/geocoder/v1/";
    17.     private String distance = "https://apis.map.qq.com/ws/distance/v1/";
    18.     private String translate = "https://apis.map.qq.com/ws/coord/v1/translate";
    19.     private String reGeoCoder = "https://apis.map.qq.com/ws/geocoder/v1/?location=";
    20.  
    21.     /**
    22.      * 通过地址查询经纬度
    23.      *
    24.      * @param addr 地址
    25.      * @return
    26.      */
    27.     public String geoCoder(String addr) {
    28.         JSONObject jsonObject = geoCoderRequest(addr);
    29.         if (null == jsonObject) {
    30.             return null;
    31.         }
    32.         JSONObject location = JSONUtil.parseObj(JSONUtil.toJsonStr(jsonObject.get("location")));
    33.         if (Objects.nonNull(location) && Objects.nonNull(location.get("lat")) && Objects.nonNull(location.get("lng"))) {
    34.             return location.get("lat").toString() + "," + location.get("lng").toString();
    35.         }
    36.         return null;
    37.     }
    38.  
    39.     public JSONObject geoCoderRequest(String addr) {
    40.         try {
    41.             if (StringUtils.isNotEmpty(addr)) {
    42.                 String url = geoCoder +
    43.                         "?address=" + addr +
    44.                         "&key=" + qqAk;// 腾讯地图ak
    45.                 String resultStr = HttpUtil.get(url);
    46.                 JSONObject tencentGeo = JSONUtil.parseObj(resultStr);
    47.                 log.info("地址转坐标响应结果：" + JSONUtil.toJsonStr(tencentGeo));
    48.                 if (Objects.nonNull(tencentGeo) && Objects.equals(0, tencentGeo.get("status"))) {
    49.                     return JSONUtil.parseObj(JSONUtil.toJsonStr(tencentGeo.get("result")));
    50.                 }
    51.             }
    52.         } catch (Exception e) {
    53.             log.error("地址转坐标失败，地址：" + addr + ", e: " + e);
    54.         }
    55.         return null;
    56.     }
    57.  
    58.     /**
    59.      * 根据经纬度查询地址
    60.      *
    61.      * @param lat 纬度
    62.      * @param lng 经度
    63.      * @return
    64.      */
    65.     public JSONObject reGeoCoder(String lat, String lng) {
    66.         StringBuilder url = new StringBuilder(reGeoCoder)
    67.                 .append(lat).append(",").append(lng)
    68.                 .append("&key=").append(qqAk);
    69.         String resultStr = HttpUtil.get(url.toString());
    70.         return JSONUtil.parseObj(resultStr);
    71.     }
    72.  
    73.     /**
    74.      * 将微信小程序经纬度转换成腾讯地图经纬度
    75.      *
    76.      * @param lat 纬度
    77.      * @param lng 经度
    78.      * @return
    79.      */
    80.     public JSONObject translate(String lat, String lng) {
    81.         StringBuilder url = new StringBuilder(translate)
    82.                 .append("?key=").append(qqAk)// 腾讯地图ak
    83.                 .append("&type=1")// 1.GPS坐标 2.sogou经纬度 3.baidu经纬度 4.mapbar经纬度 5.[默认]腾讯、google、高德坐标 6.sogou墨卡托
    84.                 .append("&&locations=").append(lat).append(",").append(lng);
    85.         String resultStr = HttpUtil.get(url.toString());
    86.         return JSONUtil.parseObj(resultStr);
    87.     }
    88.  
    89. }
    6.region.sql文件 

     链接: https://pan.baidu.com/s/1m1WEgQPGXbUzgZ4qusvegQ 提取码: ztr6 复制这段内容后打开百度网盘手机App，操作更方便哦

     

  • 相关阅读:
    RTOS那些你得知道的事儿（一）
    Nest.js项目小结1
    win11系统中nginx简单的代理配置
    pycharm运行os.system出现�����ڲ����ⲿ���Ҳ���ǿ����еij��� ���������ļ���
    民办二本计算机毕业以后
    java的包装类
    GRE MGRE原理与配置
    基于springboot+vue的社区医院管理服务系统
    matlab实现神经网络算法,人工神经网络matlab代码
    C++征途 --- STL常用算法（上）
  • 原文地址：https://blog.csdn.net/qq_40083897/article/details/136363980