From b2fce0dc7dc4ea5dec9792a2bc3ceb9d33d6e07b Mon Sep 17 00:00:00 2001 From: lidongdong <1459917685@qq.com> Date: 星期一, 04 九月 2023 13:59:52 +0800 Subject: [PATCH] 修改后台社区动态加载不出来 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComStreetDAO.java | 42 +++++++++--------------------------------- 1 files changed, 9 insertions(+), 33 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComStreetDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComStreetDAO.java index cf15dba..1a941fc 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComStreetDAO.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComStreetDAO.java @@ -1,18 +1,10 @@ package com.panzhihua.service_community.dao; -import com.baomidou.mybatisplus.core.mapper.BaseMapper; -import com.baomidou.mybatisplus.core.metadata.IPage; -import com.baomidou.mybatisplus.extension.plugins.pagination.Page; -import com.panzhihua.common.model.dtos.community.PageComActDTO; -import com.panzhihua.common.model.vos.community.ComActVO; -import com.panzhihua.service_community.model.dos.ComActDO; -import com.panzhihua.service_community.model.dos.ComStreetDO; import org.apache.ibatis.annotations.Mapper; -import org.apache.ibatis.annotations.Param; -import org.apache.ibatis.annotations.Select; -import org.apache.ibatis.annotations.Update; -import java.util.List; +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.panzhihua.service_community.model.dos.ComStreetDO; +import org.apache.ibatis.annotations.Param; /** * @author: llming @@ -21,26 +13,10 @@ @Mapper public interface ComStreetDAO extends BaseMapper<ComStreetDO> { - @Select("<script> " + - "SELECT\n" + - "c.community_id,\n" + - "c.`name`,\n" + - "ST_Distance_Sphere ( Point ( #{lng}, #{lat} ), Point ( c.lng, c.lat ) ) AS distance \n" + - "FROM\n" + - "com_act c \n" + - " <where>" + - "<if test='areaCode != null and areaCode.trim() != ""'>" + - "c.area_code = #{areaCode} \n" + - " </if> " + - " </where>" + - "ORDER BY\n" + - "distance ASC" + - "<if test='lng != null and lng.trim() != ""'>" + - " limit 10 " + - " </if> " + - "</script>") - List<ComActVO> listCommunity(ComActVO comActVO); - - @Select("select district_name from com_mng_struct_area_district where district_adcode=#{areaCode}") - String selectAreaName(String areaCode); + /** + * 获取行政区域 + * @param areaCode + * @return + */ + String retrieveRegions(@Param("areaCode") String areaCode); } -- Gitblit v1.7.1