2025-10-17 11:28:14 +08:00
|
|
|
|
package com.cdzy.operations.mapper;
|
|
|
|
|
|
|
2025-11-07 17:04:22 +08:00
|
|
|
|
import com.cdzy.operations.model.dto.EbikeDto;
|
2025-10-17 11:28:14 +08:00
|
|
|
|
import com.mybatisflex.core.BaseMapper;
|
|
|
|
|
|
import com.cdzy.operations.model.entity.EbikeBikeInfo;
|
2025-10-22 16:21:07 +08:00
|
|
|
|
import org.apache.ibatis.annotations.Param;
|
2025-12-30 11:20:29 +08:00
|
|
|
|
import org.locationtech.jts.geom.Point;
|
|
|
|
|
|
import org.locationtech.jts.geom.Polygon;
|
2025-10-22 16:21:07 +08:00
|
|
|
|
|
|
|
|
|
|
import java.util.List;
|
2025-10-17 11:28:14 +08:00
|
|
|
|
|
|
|
|
|
|
/**
|
|
|
|
|
|
* 映射层。
|
|
|
|
|
|
*
|
|
|
|
|
|
* @author attiya
|
|
|
|
|
|
* @since 2025-10-17
|
|
|
|
|
|
*/
|
|
|
|
|
|
public interface EbikeBikeInfoMapper extends BaseMapper<EbikeBikeInfo> {
|
|
|
|
|
|
|
2025-10-22 16:21:07 +08:00
|
|
|
|
/**
|
|
|
|
|
|
* 查询多边形范围内的车辆
|
|
|
|
|
|
* @param polygon 多边形
|
|
|
|
|
|
* @return 列表
|
|
|
|
|
|
*/
|
2025-12-30 11:20:29 +08:00
|
|
|
|
List<EbikeBikeInfo> selectPolygonGeometry(@Param("polygon") Polygon polygon);
|
2025-10-22 16:21:07 +08:00
|
|
|
|
|
2025-11-07 17:04:22 +08:00
|
|
|
|
/**
|
|
|
|
|
|
* 查询半径范围内的车辆(带距离排序)
|
|
|
|
|
|
* @param centerPoint 中心点坐标
|
|
|
|
|
|
* @param radiusMeters 半径距离(米)
|
|
|
|
|
|
* @return 按距离排序的车辆列表
|
|
|
|
|
|
*/
|
2025-12-30 11:20:29 +08:00
|
|
|
|
List<EbikeDto> selectRadiusGeometryWithOrder(@Param("centerPoint") Point centerPoint,
|
2025-11-07 17:04:22 +08:00
|
|
|
|
@Param("radius") double radiusMeters);
|
|
|
|
|
|
|
2025-10-17 11:28:14 +08:00
|
|
|
|
}
|