跳到主要内容
版本:v2.0

查询订单

按订单号、手机号、营种、营期、状态等条件查询订单列表。返回字段与 订单变更通知 中的订单快照基本一致,可用于主动同步或核对回调数据。

POST/api/catOrder

请求参数

名称类型描述是否必填默认值备注
tokenString身份校验令牌必填-获取访问令牌 获得
phoneString会员手机号非必填--
order_idNumber订单 ID非必填--
ordernumString订单号(模糊)非必填--
ordernum_listString订单号列表非必填-多个用英文逗号分隔,精确匹配
pidNumber营种 ID非必填-获取营种列表
period_idNumber营期 ID非必填--
product_nameString营种名称非必填-模糊搜索
statusNumber订单状态非必填-见下表
staff_idNumber员工 ID非必填--
remarksString订单备注关键词非必填--
pageNumNumber分页页码非必填1-
pageSizeNumber每页条数非必填10-
period_starttimeString开营时间起非必填-2023/01/01
period_endtimeString开营时间止非必填-2023/02/01
time_startString下单时间起非必填-2023/01/01
time_endString下单时间止非必填-2023/02/01

status 订单状态

含义
1待支付
2已支付
4已结营
5已取消
6已退款
11待支付尾款
12退款中
13换营中

CURL

curl --location --request POST 'https://open.xinduobang.cn/api/catOrder' \
--header 'Content-Type: application/json' \
--data-raw '{
"token": "YOUR_TOKEN",
"ordernum": "NO20230511203452547280",
"pageNum": 1,
"pageSize": 10
}'

成功响应

精简示例

{
"code": 0,
"msg": "success",
"totalnum": 1,
"data": [
{
"order_id": 1111,
"ordernum": "NO20230511203452547280",
"pid": 1,
"period_id": 2,
"product_name": "营种名称",
"period": "2023/05/18-2023/05/19",
"status": "已支付",
"number": "2",
"user_phone": "13683106368",
"user_name": "张三",
"have_pay": 1200,
"students": [
{
"name": "吴念一",
"phone": "139571411111",
"idcard_type": "1",
"idcard": "330105201******"
}
]
}
]
}
完整响应示例(含拼团、拆单、换营、连报等)
{
"code": 0,
"msg": "success",
"totalnum": 1,
"data": [
{
"order_id": 1111,
"pid": 1,
"period_id": 2,
"extra_product_id": 11111,
"ordernum": "NO20230511203452547280",
"user_phone": "13683106368",
"user_name": "哈哈",
"user_idcard": "412723198902186826",
"unionid": "oXXXX",
"product_name": "营种名称",
"current_product_name": "最新营种名称",
"sign_pdf_title": "测试电子签章",
"sign_pdf_url": "https://signature.cdn.xinduobang.cn/sign20250908115156342589177199.pdf",
"team_id": 1222,
"team_status": 2,
"team_order_list": [
{ "order_id": "38461", "number": "2", "ordernum": "NO202509281057510542711" }
],
"cut_order_info": {
"master_order_id": 0,
"cut_order_id": 0,
"order_num": "NO202509281057510542711"
},
"merge_order_info": {
"master_order_id": "38656",
"be_merge_order_id": "38651",
"order_num": "NO202509281057510542711"
},
"sku_str": "默认规格",
"period": "2023/05/18-2023/05/19",
"createtime": "2023-05-11 20:34:52",
"number": "2",
"status": "已支付",
"unit_price": "600.00",
"order_price": 1200,
"have_pay": 1200,
"have_pay_moneycard": "800.00",
"students": [
{
"name": "吴念一",
"phone": "139571411111",
"idcard_type": "1",
"idcard": "330105201******",
"height": "150",
"weight": "47.00",
"birthday": "2015-12-26",
"size": "100"
}
],
"exchenge_list": [
{
"old_pid": "345",
"old_period_id": "714",
"old_pname": "2026夏·少年常青藤夏校",
"old_period": "2026/07/18-2026/07/27",
"new_pid": "345",
"new_period_id": "727",
"new_pname": "2026夏·少年常青藤夏校",
"new_period": "延期",
"addtime": "2026-07-08 15:47:50"
}
],
"remarks_list": [
{ "content": "备注内容", "addtime": "2023-05-15 10:23:17" }
],
"refund_list": [
{
"team_id": 0,
"addtime": "2023-05-11 20:34:52",
"money": "0.00",
"moneycard": "800.00",
"refund_types": "全部退营",
"refund_id": 111,
"desc": "退款原因"
}
],
"pay_list": [
{
"addtime": "2023-05-11 20:34:52",
"money": "0.00",
"moneycard": "800.00",
"tranction_id": "1111111"
}
],
"cut_group_info": {
"team_name": "1团",
"team_nick_name": "背提2期",
"group_name": "19组",
"group_id": "513"
},
"more_count": 2,
"more_all_pay": "0.01",
"more_all_pay_moneycard": "0.01",
"more_info_list": [
{
"order_id": "38109",
"ordernum": "NO20250729133708420538",
"pname": "xmw测试-暑假集训营(多期)",
"period": "2025/08/11-2025/08/18",
"have_pay": "0.01"
}
]
}
]
}

响应字段

顶层:codemsgtotalnum(总条数)、data(订单数组)。

data[] 字段分组说明见 订单变更通知 的「请求体结构」:订单基础信息、拼团、拆单/合并、营员 students[]、换营 exchenge_list[]、支付/退款/备注、团组 cut_group_info、连报等。

本接口额外常见字段:

字段类型说明
small_number / big_numberNumber大小营人数(若有)
per_nameString场次名称,如「下午场」
type_listArray营种分类,元素含 idname
out_remarks_listArray外部订单备注(类型为外部备注的子集)
size(students[] 内)String尺码(若有)

失败响应

HTTP状态码错误码描述排查建议
200非 0业务错误请检查 codemsg,确认筛选条件与 token

相关接口