package com.xiaopeng.map.mapper;
|
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.xiaopeng.api.dto.operation.PointMapQuery;
|
import com.xiaopeng.api.model.operation.XpPoint;
|
import com.xiaopeng.api.query.operation.PointListQuery;
|
import com.xiaopeng.api.query.operation.PointPageListListQuery;
|
import com.xiaopeng.api.vo.order.XpPointsListVo;
|
import com.xiaopeng.common.core.web.page.PageInfo;
|
import com.xiaopeng.map.query.PointByNameQuery;
|
import com.xiaopeng.map.vo.FenceAndStationVo;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
|
/**
|
* <p>
|
* 点位管理 Mapper 接口
|
* </p>
|
*
|
* @author liu
|
* @author WuGuanFengYue
|
* @since 2026-02-03
|
*/
|
public interface XpPointMapper extends BaseMapper<XpPoint> {
|
|
List<FenceAndStationVo> findListFenceAndStation();
|
|
List<XpPoint> pointMap(@Param("query") PointMapQuery query);
|
|
List<XpPoint> listAll(@Param("query") PointListQuery query);
|
|
List<XpPointsListVo> queryPointByName(@Param("query") PointByNameQuery query);
|
|
List<XpPoint> pageList(@Param("pageInfo") PageInfo<XpPoint> pageInfo, @Param("query") PointPageListListQuery query);
|
|
@Select("SELECT point_number FROM xp_point WHERE point_number LIKE CONCAT(#{cityPrefix}, '-', #{bizType}, '-%') ORDER BY point_number DESC LIMIT 1")
|
String selectMaxPointNumber(@Param("cityPrefix") String cityPrefix, @Param("bizType") String bizType);
|
}
|
