| | |
|---|
| | | + "FROM " + " com_act c " + " left join com_street as cs on cs.street_id = c.street_id " |
|---|
| | | + " HAVING distance >= 0 and distance <= #{communityDTO.distance} " + "ORDER BY " + " distance ASC") |
|---|
| | | List<CommunitySwitchAllAppletsVO> getCommunityListByNearby(@Param("communityDTO") SearchCommunityDTO communityDTO); |
|---|
| | | |
|---|
| | | @Select("select t.community_id,t.`name` from com_act t left join com_street t1 on t.street_id = t1.street_id where t.state = 0 and t1.street_id in (12,14,15,16,17,18)") |
|---|
| | | List<EventGridCommunityAdminVO> getWestCommunityLists(); |
|---|
| | | } |
|---|
