| | |
|---|
| | | " where id in ( " + |
|---|
| | | " select ii.member_id from identity_info ii where ii.AUDIT_STATUS = 2 and type = #{orderType} " + |
|---|
| | | " and ( CONVERT( ST_Distance_Sphere ( POINT ( ii.lgt, ii.lat ), POINT ( #{lgt}, #{lat} )) /1000,DECIMAL(15,2))) < 100 " + |
|---|
| | | " )" + |
|---|
| | | " ) and RELEASE_MEMBER_ID != #{releaseMemberId} " + |
|---|
| | | " order by level , score desc , distance asc ") |
|---|
| | | List<Member> getList(@Param("lgt") BigDecimal lgt, @Param("lat") BigDecimal lat, @Param("orderType") Integer orderType); |
|---|
| | | List<Member> getList(@Param("lgt") BigDecimal lgt, @Param("lat") BigDecimal lat, @Param("orderType") Integer orderType, @Param("releaseMemberId") Integer releaseMemberId); |
|---|
| | | |
|---|
| | | } |
|---|
