| | |
|---|
| | | @Select("SELECT c.community_id, c.`name`, c.street_id, cs.`name` as streetName," + |
|---|
| | | "round( ST_Distance_Sphere ( Point ( #{communityDTO.longitude}, #{communityDTO.latitude} ), Point ( c.lng, c.lat ) )/ 1000, 2 ) AS distance " + |
|---|
| | | "FROM com_act c left join com_street as cs on cs.street_id = c.street_id " + |
|---|
| | | "where cs.area_code = #{areaCode} " + |
|---|
| | | "where cs.area_code = #{communityDTO.areaCode} " + |
|---|
| | | "HAVING distance >= 0 and distance <= #{communityDTO.distance} ORDER BY distance ASC") |
|---|
| | | List<CommunitySwitchAllAppletsVO> getCommunityListByNearby(@Param("communityDTO") SearchCommunityDTO communityDTO); |
|---|
| | | |
|---|
| | | @Select("select community_id,name,lng,lat from com_act where state = 0 <if test='areaCode !=null'> and area_code = #{areaCode} </if> ") |
|---|
| | | @Select("<script> select community_id,name,lng,lat from com_act where state = 0 <if test='areaCode !=null'> and area_code = #{areaCode} </if> </script>") |
|---|
| | | List<EventGridCommunityAdminVO> getWestCommunityLists(@Param("areaCode") String areCode); |
|---|
| | | |
|---|
| | | @Select("select account,plaintext_password as password from com_act where community_id = ${communityId}") |
|---|
