Pu Zhibing
2025-04-22 7feb722a12e26f5572c7df9ccc1ce8c1e26b9f94
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
package com.stylefeng.guns.modular.system.dao;
 
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.stylefeng.guns.modular.system.model.TOrderTaxi;
import org.apache.ibatis.annotations.Param;
 
import java.util.List;
import java.util.Map;
 
/**
 * <p>
 * 订单-出租车 Mapper 接口
 * </p>
 *
 * @author 吕雪
 * @since 2020-06-08
 */
public interface TOrderTaxiMapper extends BaseMapper<TOrderTaxi> {
 
    /**
     * 根据条件查询出租车订单列表
     * @return
     */
    List<Map<String,Object>> getTaxiOrderList(@Param("page") Page<Map<String, Object>> page,
                                               @Param("beginTime") String beginTime,
                                               @Param("endTime") String endTime,
                                              @Param("roleType") Integer roleType,
                                              @Param("nowUserId") Integer nowUserId,
                                               @Param("orderNum") String orderNum,
                                               @Param("orderSource") Integer orderSource,
                                               @Param("userName") String userName,
                                               @Param("userPhone") String userPhone,
                                               @Param("passengers") String passengers,
                                               @Param("passengersPhone") String passengersPhone,
                                               @Param("driver") String driver,
                                               @Param("state") Integer state);
 
    /**
     * 根据出租车订单ID获取出租车订单详情
     * @param orderId
     * @return
     */
    Map<String,Object> getTaxiOrderDetailById(@Param("orderId") Integer orderId);
 
    /**
     * 根据条件查询可被选择的出租车司机列表
     * @return
     */
    List<Map<String,Object>> getCanSelectTaxiDriverList(@Param("page") Page<Map<String, Object>> page,
                                                        @Param("companyId") Integer companyId,
                                                        @Param("name") String name,
                                                        @Param("phone") String phone);
 
    /**
     * 查询所有订单条数
     * @param companyId
     * @return
     */
    Integer getAllOrderNum(@Param("companyId") Integer companyId,@Param("beginTime") String beginTime,@Param("endTime") String endTime);
 
    /**
     * 查询所有总交易金额
     * @param companyId
     * @param beginTime
     * @param endTime
     * @return
     */
    Double getAllTradeMoney(@Param("companyId") Integer companyId,@Param("beginTime") String beginTime,@Param("endTime") String endTime);
 
    /**
     * 查询所有总收益
     * @param companyId
     * @param beginTime
     * @param endTime
     * @return
     */
    Double getAllIncomeMoney(@Param("companyId") Integer companyId,@Param("beginTime") String beginTime,@Param("endTime") String endTime);
    
    
    /**
     * 获取支付订单统计
     * @param page
     * @param paymentCode
     * @param orderCode
     * @param userPhone
     * @param driverPhone
     * @param createTimeStart
     * @param createTimeEnd
     * @param paymentTimeStart
     * @param paymentTimeEnd
     * @return
     */
    List<Map<String, Object>> paymentOrderStatisticsList(Page<Map<String, Object>> page, @Param("paymentCode") String paymentCode,
                                                         @Param("orderCode") String orderCode, @Param("userPhone") String userPhone,
                                                         @Param("driverPhone") String driverPhone, @Param("createTimeStart") String createTimeStart,
                                                         @Param("createTimeEnd") String createTimeEnd, @Param("paymentTimeStart") String paymentTimeStart,
                                                         @Param("paymentTimeEnd") String paymentTimeEnd);
    
    
    /**
     * 获取线下订单统计
     * @param page
     * @param orderCode
     * @param userPhone
     * @param driverPhone
     * @param createTimeStart
     * @param createTimeEnd
     * @param orderSource
     * @return
     */
    List<Map<String, Object>> offlineOrderStatisticsList(Page<Map<String, Object>> page, @Param("orderCode") String orderCode,
                                                         @Param("userPhone") String userPhone, @Param("driverPhone") String driverPhone,
                                                         @Param("createTimeStart") String createTimeStart, @Param("createTimeEnd") String createTimeEnd,
                                                         @Param("orderSource") Integer orderSource);
}