查询订单
按订单号、手机号、营种、营期、状态等条件查询订单列表。返回字段与 订单变更通知 中的订单快照基本一致,可用于主动同步或核对回调数据。
POST/api/catOrder
请求参数
| 名称 | 类型 | 描述 | 是否必填 | 默认值 | 备注 |
|---|---|---|---|---|---|
| token | String | 身份校验令牌 | 必填 | - | 由 获取访问令牌 获得 |
| phone | String | 会员手机号 | 非必填 | - | - |
| order_id | Number | 订单 ID | 非必填 | - | - |
| ordernum | String | 订单号(模糊) | 非必填 | - | - |
| ordernum_list | String | 订单号列表 | 非必填 | - | 多个用英文逗号分隔,精确匹配 |
| pid | Number | 营种 ID | 非必填 | - | 见 获取营种列表 |
| period_id | Number | 营期 ID | 非必填 | - | - |
| product_name | String | 营种名称 | 非必填 | - | 模糊搜索 |
| status | Number | 订单状态 | 非必填 | - | 见下表 |
| staff_id | Number | 员工 ID | 非必填 | - | - |
| remarks | String | 订单备注关键词 | 非必填 | - | - |
| pageNum | Number | 分页页码 | 非必填 | 1 | - |
| pageSize | Number | 每页条数 | 非必填 | 10 | - |
| period_starttime | String | 开营时间起 | 非必填 | - | 如 2023/01/01 |
| period_endtime | String | 开营时间止 | 非必填 | - | 如 2023/02/01 |
| time_start | String | 下单时间起 | 非必填 | - | 如 2023/01/01 |
| time_end | String | 下单时间止 | 非必填 | - | 如 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"
}
]
}
]
}
响应字段
顶层:code、msg、totalnum(总条数)、data(订单数组)。
data[] 字段分组说明见 订单变更通知 的「请求体结构」:订单基础信息、拼团、拆单/合并、营员 students[]、换营 exchenge_list[]、支付/退款/备注、团组 cut_group_info、连报等。
本接口额外常见字段:
| 字段 | 类型 | 说明 |
|---|---|---|
| small_number / big_number | Number | 大小营人数(若有) |
| per_name | String | 场次名称,如「下午场」 |
| type_list | Array | 营种分类,元素含 id、name |
| out_remarks_list | Array | 外部订单备注(类型为外部备注的子集) |
| size(students[] 内) | String | 尺码(若有) |
失败响应
| HTTP状态码 | 错误码 | 描述 | 排查建议 |
|---|---|---|---|
| 200 | 非 0 | 业务错误 | 请检查 code 与 msg,确认筛选条件与 token |