| | |
| | | XpSystemSetting xpSystemSetting = xpSystemSettingMapper.selectOne(null); |
| | | orderDistance = xpSystemSetting.getNearPointDistance(); |
| | | } |
| | | |
| | | |
| | | List<XpPoint> list1 = list(new LambdaQueryWrapper<XpPoint>().eq(XpPoint::getOperationStatus, 2).eq(XpPoint::getPointType,1).isNotNull(XpPoint::getElectronicAreaId)); |
| | | if(list1.size()<2){ |
| | | return new NearestVo(); |
| | | } |
| | | // 获取所有的站点信息 |
| | | List<XpPoint> list = list(new LambdaQueryWrapper<XpPoint>().eq(XpPoint::getOperationStatus, 2).eq(XpPoint::getPointType,1).isNotNull(XpPoint::getElectronicAreaId) |
| | | // 添加距离计算字段 |
| | |
| | | import io.swagger.annotations.ApiModel; |
| | | import lombok.Data; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | |
| | | @Data |
| | | @ApiModel(value = "NearestNextVo对象", description = "附近站点vo") |
| | | public class NearestVo { |
| | | |
| | | private List<NearestNextVo> points; |
| | | private List<NearestNextVo> points=new ArrayList<>(); |
| | | |
| | | |
| | | private Integer total; |
| | | private Integer total=0; |
| | | } |
| | |
| | | */ |
| | | List<XpOrderHistoryListVO> getHistoryOrderList(@Param("page") Page<XpOrderHistoryListVO> page, @Param("query") XpHistoryOrderListQuery query, @Param("uid") Long uid); |
| | | |
| | | List<XpOrder> getHistoryStartPoints(@Param("uid") Long uid); |
| | | List<XpOrder> getHistoryStartPoints(@Param("uid") Long uid, @Param("areaId") Long areaId); |
| | | |
| | | |
| | | List<XpOrder> getHistoryEndPoints(@Param("uid") Long uid); |
| | | List<XpOrder> getHistoryEndPoints(@Param("uid") Long uid, @Param("areaId") Long areaId); |
| | | |
| | | |
| | | } |
| | |
| | | @Override |
| | | public List<XpHistoryStartPointsVo> getHistoryStartPoints(String uid, double lon, double lat,Long electronicAreaId) { |
| | | // |
| | | List<XpOrder> xpOrders = this.baseMapper.getHistoryStartPoints(Long.valueOf(uid)); |
| | | List<XpOrder> xpOrders = this.baseMapper.getHistoryStartPoints(Long.valueOf(uid),electronicAreaId); |
| | | // selectList(new LambdaQueryWrapper<XpOrder>().eq(XpOrder::getAppUserId, Long.parseLong(uid)).orderByDesc(BaseModel::getCreateTime).last("LIMIT 10")); |
| | | if (xpOrders.isEmpty()) { |
| | | return Collections.emptyList(); |
| | |
| | | @Override |
| | | public List<XpHistoryEndPointsVo> getHistoryEndPoints(String uid, double lon, double lat,Long electronicAreaId) { |
| | | // |
| | | List<XpOrder> xpOrders = this.baseMapper.getHistoryEndPoints(Long.valueOf(uid)); |
| | | List<XpOrder> xpOrders = this.baseMapper.getHistoryEndPoints(Long.valueOf(uid), electronicAreaId); |
| | | // selectList(new LambdaQueryWrapper<XpOrder>().eq(XpOrder::getAppUserId, Long.parseLong(uid)).orderByDesc(BaseModel::getCreateTime).last("LIMIT 10")); |
| | | if (xpOrders.isEmpty()) { |
| | | return Collections.emptyList(); |
| | |
| | | SELECT |
| | | start_point_id, |
| | | COUNT(*) AS num |
| | | FROM xp_order where app_user_id = #{uid} |
| | | FROM xp_order where app_user_id = #{uid} and xp_electronic_fence_area_id =#{areaId} |
| | | GROUP BY start_point_id |
| | | ORDER BY num DESC,create_time desc |
| | | </select> |
| | |
| | | SELECT |
| | | end_point_id, |
| | | COUNT(*) AS num |
| | | FROM xp_order where app_user_id = #{uid} |
| | | FROM xp_order where app_user_id = #{uid} and xp_electronic_fence_area_id =#{areaId} |
| | | GROUP BY end_point_id |
| | | ORDER BY num DESC,create_time desc |
| | | </select> |