| | |
| | | if (da == null && db == null) return 0; |
| | | if (da == null) return 1; // a 在后面 |
| | | if (db == null) return -1; // b 在后面 |
| | | return db.compareTo(da); // 都不为空,再按时间倒序 |
| | | return da.compareTo(db); // 按时间正序(升序)排列 |
| | | }); |
| | | // 将经纬度转换为城市并设置到数据中 |
| | | if (list != null && !list.isEmpty()) { |
| | |
| | | */ |
| | | private List<TripOrderVo> queryOrdersByTypeAndIds(Integer userId, Integer orderType, List<Integer> orderIds) throws InvocationTargetException, IllegalAccessException { |
| | | List<TripOrderVo> orderList = new ArrayList<>(); |
| | | |
| | | List<Integer> states = Arrays.asList(8, 9); |
| | | // 根据订单类型查询对应表的订单 |
| | | switch (orderType) { |
| | | case 1: |
| | | EntityWrapper<OrderPrivateCar> wrapper = new EntityWrapper<>(); |
| | | wrapper.in("id", orderIds); |
| | | wrapper.in("state", states); |
| | | List<OrderPrivateCar> orderPrivateCars = orderPrivateCarService.selectList(wrapper); |
| | | for (OrderPrivateCar orderPrivateCar : orderPrivateCars) { |
| | | TripOrderVo vo = new TripOrderVo(); |
| | |
| | | case 2: |
| | | EntityWrapper<OrderTaxi> wrapper2 = new EntityWrapper<>(); |
| | | wrapper2.in("id", orderIds); |
| | | wrapper2.in("state", states); |
| | | List<OrderTaxi> orderTaxis = orderTaxiService.selectList(wrapper2); |
| | | for (OrderTaxi orderTaxi : orderTaxis) { |
| | | TripOrderVo vo = new TripOrderVo(); |
| | |
| | | case 3: |
| | | EntityWrapper<OrderCrossCity> wrapper3 = new EntityWrapper<>(); |
| | | wrapper3.in("id", orderIds); |
| | | wrapper3.in("state", states); |
| | | List<OrderCrossCity> orderCrossCities = orderCrossCityService.selectList(wrapper3); |
| | | for (OrderCrossCity orderCrossCity : orderCrossCities) { |
| | | TripOrderVo vo = new TripOrderVo(); |
| | |
| | | if (da == null && db == null) return 0; |
| | | if (da == null) return 1; // a 在后面 |
| | | if (db == null) return -1; // b 在后面 |
| | | return db.compareTo(da); // 都不为空,再按时间倒序 |
| | | return da.compareTo(db); // 按时间正序(升序)排列 |
| | | }); |
| | | |
| | | |
| | |
| | | select |
| | | id as orderId, |
| | | DATE_FORMAT(insertTime, '%Y-%m-%d %H:%i') as orderTime, |
| | | DATE_FORMAT(travelTime, '%m月?d日?%H:%i') as time, |
| | | DATE_FORMAT(travelTime, '%m月?d日 %H:%i') as time, |
| | | startAddress as startAddress, |
| | | endAddress as endAddress, |
| | | driverId as driverId, |
| | |
| | | boardingTime, |
| | | boardingLon, |
| | | boardingLat |
| | | from t_order_cross_city where userId = #{uid} order by insertTime desc limit #{pageNum}, #{size} |
| | | from t_order_cross_city where userId = #{uid} and state in (8, 9) order by insertTime desc limit #{pageNum}, #{size} |
| | | </select> |
| | | |
| | | <select id="queryMyTripListAll" resultType="map"> |
| | | select |
| | | id as orderId, |
| | | DATE_FORMAT(insertTime, '%Y-%m-%d %H:%i') as orderTime, |
| | | DATE_FORMAT(travelTime, '%m月?d日?%H:%i') as time, |
| | | DATE_FORMAT(travelTime, '%m月?d日 %H:%i') as time, |
| | | startAddress as startAddress, |
| | | endAddress as endAddress, |
| | | driverId as driverId, |
| | |
| | | boardingTime, |
| | | boardingLon, |
| | | boardingLat |
| | | from t_order_cross_city where userId = #{uid} order by insertTime desc |
| | | from t_order_cross_city where userId = #{uid} and state in (8, 9) order by insertTime desc |
| | | </select> |
| | | </mapper> |
| | |
| | | id as orderId, |
| | | rideType as rideType, |
| | | DATE_FORMAT(insertTime, '%Y-%m-%d %H:%i') as orderTime, |
| | | DATE_FORMAT(travelTime, '%m月?d日?%H:%i') as time, |
| | | DATE_FORMAT(travelTime, '%m月?d日 %H:%i') as time, |
| | | startAddress as startAddress, |
| | | endAddress as endAddress, |
| | | driverId as driverId, |
| | |
| | | boardingTime, |
| | | boardingLon, |
| | | boardingLat |
| | | from t_order_private_car where userId = #{uid} order by insertTime desc limit #{pageNum}, #{size} |
| | | from t_order_private_car where userId = #{uid} and state in (8, 9) order by insertTime desc limit #{pageNum}, #{size} |
| | | </select> |
| | | <select id="queryMyTripListAll" resultType="map"> |
| | | select |
| | | id as orderId, |
| | | rideType as rideType, |
| | | DATE_FORMAT(insertTime, '%Y-%m-%d %H:%i') as orderTime, |
| | | DATE_FORMAT(travelTime, '%m月?d日?%H:%i') as time, |
| | | DATE_FORMAT(travelTime, '%m月?d日 %H:%i') as time, |
| | | startAddress as startAddress, |
| | | endAddress as endAddress, |
| | | driverId as driverId, |
| | |
| | | boardingTime, |
| | | boardingLon, |
| | | boardingLat |
| | | from t_order_private_car where userId = #{uid} order by insertTime desc |
| | | from t_order_private_car where userId = #{uid} and state in (8, 9) order by insertTime desc |
| | | </select> |
| | | </mapper> |
| | |
| | | // 首先定义SimpleDateFormat(可以是类的静态成员) |
| | | SimpleDateFormat DATE_FORMATTER = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | |
| | | // 然后修改格式化代码 |
| | | String tripTimeStart = first.getBoardingTime() != null |
| | | ? DATE_FORMATTER.format(first.getBoardingTime()) : "N/A"; |
| | | String tripTimeEnd = last.getBoardingTime() != null |
| | |
| | | boardingTime, |
| | | boardingLon, |
| | | boardingLat |
| | | from t_order_taxi where userId = #{uid} order by insertTime desc limit #{pageNum}, #{size} |
| | | from t_order_taxi where userId = #{uid} and state in (8, 9) order by insertTime desc limit #{pageNum}, #{size} |
| | | </select> |
| | | |
| | | <select id="queryMyTripListAll" resultType="map"> |
| | |
| | | boardingTime, |
| | | boardingLon, |
| | | boardingLat |
| | | from t_order_taxi where userId = #{uid} order by insertTime desc |
| | | from t_order_taxi where userId = #{uid} and state in (8, 9) order by insertTime desc |
| | | </select> |
| | | </mapper> |