半径范围内车辆查询

ebike-operations/src/main/resources/mapper/EbikeBikeInfoMapper.xml

@@ -30,6 +30,8 @@
                       ST_SetSRID(ST_MakePoint(#{centerPoint.x}, #{centerPoint.y}), 4326)::geography,
                       #{radius}
               )
+        AND ebike_bike_info.status = 1
+        AND ebike_bike_info.usage_status =1
         ORDER BY distance ASC
     </select>
 </mapper>