From d868e855827e36b8062718c86175058e24add7e6 Mon Sep 17 00:00:00 2001 From: DESKTOP-71BH0QO\L、ming <172680469@qq.com> Date: 星期五, 26 三月 2021 17:38:50 +0800 Subject: [PATCH] ADD:实有房屋管理接口 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComStreetDAO.java | 22 ---------------------- 1 files changed, 0 insertions(+), 22 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..91eb06e 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 @@ -21,26 +21,4 @@ @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); } -- Gitblit v1.7.1