查询商旅订单

请求地址

https://api.es.xiaojukeji.com/api-gateway/order/getList

返回数据格式

JSON

请求方式

GET

是否需要登录

是 关于登录授权，参见 如何登录授权

访问授权限制

暂无

请求参数

注意事项

1、查询条件优先级 订单号 > 审批单号 > 日期，即传了订单号，其他查询条件失效

2、查询日期定义 酒店：订单的已提交、已提交预定、预定成功、已入住、已完成（离店）、取消订单、取消预定、预定未到时间在start_date和end_date之间可以查到(左闭右开) 机票：订单的下单、支付、发起审批、审批成功、审批驳回、审批超时、取消、关闭、出票、发起改签、改签成功、发起退票、退票成功时间在start_date和end_date之间可以查到(左闭右开) 火车票：订单的下单、支付、取消、出票、发起改签、改签成功、发起退票、退票成功时间在start_date和end_date之间可以查到(左闭右开)

3、日期查询规则如下： 开始日期、结束日期均填写，在开始结束日期范围必须在7天内 只填写开始日期，则查询日期范围为开始时间往后7天，如start_date = 2021-12-01，则可以查询到2021-12-01 ~ 2021-12-08（包含12.01不包含12.08）的订单 只填写结束日期，则查询日期范围为结束时间往前7天，如end_date = 2021-12-10， 则可以查询到2021-12-03 ~ 2021-12-10（包含12.03不包含12.10）的订单 开始日期结束日期未填写，则查询当前日期前7天的订单，如今天是2021-12-28，则可以查询到2021-12-21 ~ 2021-12-28（包含12.21不包含12.28）的订单

4、当单品类查询结果数据条数超过100时，会直接报错，错误码为50019，此时需要通过订单号查询接口查到订单号后根据订单号查询订单信息。

请求示例

curl -X GET -H "Content-Type: application/x-www-form-urlencoded" https://api.es.xiaojukeji.com/api-gateway/order/getList?client_id=client_id_test&access_token=141ea31466478eab2f1c1ddcca2675b989a16552&timestamp=1566764837&company_id=12345678980&sign=091cf244ad5ab16935cfe44fc698bc58

请求返回参数

机票订单返回参数

data.flight_data.order_list元素结构(机票订单)

data.flight_data.order_list.order_info结构(订单信息)

data.flight_data.order_list.ticket_list元素结构(票信息)

data.flight_data.order_list.ticket_list[0].ticket_info(机票信息)

data.flight_data.order_list.ticket_list[0].change_info(改签信息)

data.flight_data.order_list.ticket_list[0].refund_info(退票信息)

data.flight_data.order_list.ticket_list[0].rc_info(管控信息)

酒店订单返回参数

data.hotel_data.order_list(酒店订单)

data.hotel_data.order_list[0].order_info(订单信息)

data.hotel_data.order_list[0].fee_info(费用信息)注：小数点后保留两位

data.hotel_data.order_list[0].fee_info.details_amount元素格式(价格)

data.hotel_data.order_list[0].base_info(酒店基本信息)

data.hotel_data.order_list[0].base_info.rc_info(管控信息)

data.hotel_data.order_list[0].room_list元素结构(入住房间列表)

火车票订单返回参数

data.train_data.order_list （火车票订单）数据格式

data.train_data.order_list.order_info(订单信息)

data.train_data.order_list.ticket_list[0].tikcet_info(火车票信息)

data.train_data.order_list.ticket_list[0].change_info(改签信息)

data.train_data.order_list.ticket_list[0].refund_info(退票信息)

data.train_data.order_list.ticket_list[0].rc_info(管控信息)

返回示例

{
    "errno":0,
    "errmsg":"SUCCESS",
    "data":{
        "flight_data":{
            "order_list":[
                {
                    "order_info":{
                        "group_id":"1125902119592306",
                        "order_status":503,
                        "approval_id":"1125913455816048",
                        "book_phone":"13269536690",
                        "cancel_time":"",
                        "company_id":"1125901785377166",
                        "book_name":"小明",
                        "is_refund":1,
                        "flight_travel_type":"国内",
                        "institution_id":"1125913455825889",
                        "out_approval_id":"0",
                        "order_id":"1125914409333663",
                        "flight_type":1,
                        "pay_type":0,
                        "is_pay":1,
                        "create_time":"2022-02-24 11:26:59",
                        "pay_time":"2022-02-24 11:27:20"
                    },
                    "ticket_list":[
                        {
                            "ticket_info":{
                                "passenger_card_type":1,
                                "budget_center_name":"",
                                "main_airline_code":"CA",
                                "is_account_price":0,
                                "passenger_name":"小明",
                                "passenger_segment_status":0,
                                "cabin_type":4,
                                "departure_arrival_airport_name":"二里半机场-首都机场T2",
                                "real_fee":"980",
                                "main_flight_number":"",
                                "supplier_ticket_number":"999-5894012953",
                                "discount":"",
                                "service_fee":"0",
                                "passenger_card_number":"51382*******48135",
                                "flight_number":"CA1121",
                                "stop_airport":"",
                                "stopTime ":"",
                                "issue_success_time":"2022-02-24 11:30:41",
                                "departure_time":"2022-03-31 09:55:00",
                                "departure_arrival_city_name":"北京-包头",
                                "airline_code":"CA",
                                "departure_arrival_airport_code":"PEK-BAV",
                                "supplier_order_id":"ci3ygw3d04fu3jd41zf",
                                "flight_type":1,
                                "fuel_fee":"10",
                                "arrival_time":"2022-03-31 11:30:00",
                                "pnr_number":"JFPKFL",
                                "stop_city":"",
                                "passenger_phone":"11100011709",
                                "construction_fee":"0",
                                "sale_fee":"970"
                            },
                            "change_info":{
                                "departure_arrival_airport_name":"",
                                "change_up_cabin_fee":"",
                                "change_reason":"",
                                "change_rc_reason":"",
                                "change_success_time":"",
                                "main_airline_code":"",
                                "supplier_ticket_number":"",
                                "is_account_price":0,
                                "stop_city":"",
                                "change_service_fee":"",
                                "flight_number":"",
                                "airline_code":"",
                                "pnr_number":"",
                                "stopTime ":"",
                                "change_total_fee":"",
                                "stop_airport":"",
                                "change_submit_times":0,
                                "departure_time":"",
                                "arrival_time":"",
                                "main_flight_number":"",
                                "departure_arrival_airport_code":"",
                                "cabin_type":0,
                                "discount":0,
                                "change_handle_fee":""
                            },
                            "refund_info":{
                                "refund_handle_fee":"",
                                "refund_user_fee":"",
                                "refund_service_fee":"",
                                "refund_success_time":"",
                                "refund_type":""
                            },
                            "rc_info":{
                                "rc_id":"1125914409322366",
                                "rc_tank":"未按指定舱等/折扣预订",
                                "rc_tank_reason":"机型、路线、航班周期不被接受",
                                "rc_low_reason":"",
                                "rc_book":"",
                                "rc_approver_name":"郭奎",
                                "rc_low":"",
                                "rc_book_reason":"",
                                "rc_status":3
                            }
                        }
                    ]
                }
            ]
        },
        "hotel_data":{
            "order_list":[
                {
                    "room_list":[
                        {
                            "person_name":"小明",
                            "passenger_phone":"13581879100",
                            "passenger_member_id":"1125905751609633",
                            "budget_center_name":""
                        }
                    ],
                    "order_info":{
                        "company_id":"4441232560273757550",
                        "institution_id":"1125920499360063",
                        "is_early_checkout":0,
                        "is_refund":0,
                        "order_status":5,
                        "book_phone":"13581879100",
                        "group_id":"1125905831767840",
                        "approval_id":"1125920499794830",
                        "order_id":"1125920646064824",
                        "member_id":"1125905751609633",
                        "book_name":"小明",
                        "out_approval_id":"TA01173964_D31891",
                        "pay_type":0,
                        "is_pay":1
                    },
                    "fee_info":{
                        "total_amount":1034,
                        "company_pay":"1034.00",
                        "company_real_pay":"1034.00",
                        "company_real_refund":"0.00",
                        "personal_pay":"0.00",
                        "personal_real_pay":"0.00",
                        "personal_real_refund":"0.00",
                        "details_amount":[
                            {
                                "date":"2023-05-25",
                                "amount":366
                            },
                            {
                                "date":"2023-05-26",
                                "amount":334
                            },
                            {
                                "date":"2023-05-27",
                                "amount":334
                            }
                        ]
                    },
                    "base_info":{
                        "refund_time":"",
                        "city_id":82,
                        "room_num":1,
                        "rc_info":{
                            "rc_approver_name":"",
                            "rc_id":"",
                            "rc_rate":"",
                            "rc_book_reason":"",
                            "rc_status":0,
                            "rc_approval_status":-1,
                            "expense_standard":350,
                            "rc_rate_reason":"",
                            "rc_star":"",
                            "rc_star_reason":"",
                            "rc_book":"",
                            "rc_agreement":"",
                            "rc_agreement_reason":""
                        },
                        "create_time":"2023-05-25 14:50:26",
                        "pay_time":"2023-05-25 14:50:28",
                        "confirm_time":"2023-05-25 14:50:31",
                        "checkout_time":"",
                        "checkout_date":"2023-05-28",
                        "complete_time":"",
                        "checkin_time":"2023-05-25 16:17:28",
                        "city_name":"贵阳",
                        "room_night":3,
                        "checkin_date":"2023-05-25",
                        "cancel_time":"",
                        "hotel_name":"维也纳酒店（贵阳北站梦想城店）",
                        "room_name":"豪华大床房"
                    }
                }
            ]
        },
        "train_data":{
            "order_list":[
                {
                    "order_info":{
                        "id":"1125918769692054",
                        "company_id":"1125910319468282",
                        "booker_name":"小明",
                        "pay_type":0,
                        "pay_time":"2023-02-24 18:55:22",
                        "cancel_time":"",
                        "status":4,
                        "institution_id":"1125918769217047",
                        "booker_phone":"155****3587",
                        "supplier_order_id":"T23022498F931ED0288504EE90879E0568E9696CB31",
                        "group_id":"1125910319516973",
                        "is_pay":1,
                        "create_time":"2023-02-24 18:54:56",
                        "out_approval_id":"",
                        "is_refund":1,
                        "requisition_id":"1125918769274835"
                    },
                    "ticket_list":[
                        {
                            "ticket_info":{
                                "order_id":"1125918769692054",
                                "arrive_time":"2023-03-09 06:30:00",
                                "issue_time":"2023-02-24 18:55:36",
                                "supplier_ticket_no":"EH71502326104001C",
                                "from_city_id":"1",
                                "budget_center_name":"",
                                "passenger_name":"小明",
                                "from_station_name":"北京南",
                                "company_pay":"54.50",
                                "company_real_pay":"54.50",
                                "from_city_name":"北京市",
                                "id":"1125918769803083",
                                "passenger_id_no":"1305***********918",
                                "seat_type":"O",
                                "e_reverse_fee":"0.00",
                                "to_city_name":"天津市",
                                "personal_real_pay":"0.00",
                                "passenger_id_type":1,
                                "real_user_cost":"0.00",
                                "passenger_phone":"000****4237",
                                "passenger_member_id":"1125910319486427",
                                "status":9,
                                "to_station_name":"天津",
                                "start_time":"2023-03-09 06:00:00",
                                "train_code":"C2551",
                                "seat_no":"001C",
                                "to_city_id":"7",
                                "sale_cost":"54.50",
                                "personal_pay":"0.00"
                            },
                            "rc_info":{
                                "rc_status":0,
                                "rc_tank": "超标原因",
                                "rc_tank_reason": "超标说明"
                            },
                            "change_info":{
                                "supplier_ticket_no":"EH71502326208007A",
                                "confirm_time":"2023-02-24 18:58:05",
                                "change_reason":"购票信息错误",
                                "pre_ticket_id":"1125918769803083",
                                "from_city_id":"1",
                                "to_city_id":"7",
                                "to_station_name":"天津",
                                "seat_no":"007A",
                                "from_city_name":"北京市",
                                "to_city_name":"天津市",
                                "id":"1125918769805309",
                                "pre_order_id":"1125918769692054",
                                "start_time":"2023-03-10 06:00:00",
                                "train_code":"C2551",
                                "seat_type":"O",
                                "order_id":"1125918769739806",
                                "arrive_time":"2023-03-10 06:30:00",
                                "from_station_name":"北京南",
                                "change_handing_fee":"0.00",
                                "change_service_fee":"0.00"
                            },
                            "refund_info":{
                                "refund_time":"2023-02-24 19:04:22",
                                "e_refund_fee":"0.00",
                                "handing_fee":"0.00",
                                "user_refund":"54.50",
                                "reason":"",
                                "id":"1125918769805309",
                                "order_id":"1125918769739806"
                            }
                        }
                    ]
                }
            ]
        }
    }
}