订单列表
POST /app/order/orderListquery 传参**
| 字段 | 名称 | 类型 | 是否必须 |
| page | 页码 | int | 是 |
| pageSize | 每页数量 | int | 是 |
| order_sn | 订单编号 | ||
| pay_sn | 支付单号 | ||
| shipping_sn | 快递单号 | ||
| user_id | 用户id | ||
| nick_name | 用户昵称 | ||
| user_name | 用户名称 | ||
| user_mobile | 用户手机号 | ||
| status | 0待支付 1待发货 2待收货 3已完成,-1已关闭 5退换货 6已退款 | ||
| product_title | 商品名称 | string | |
| supplier_id | 供应商id | int | |
| gather_supplier_id | 供应链id | int | |
| pay_type_id | 支付方式id | int | |
| start_at | 下单开始时间 | datetime | |
| end_at | 下单结束时间 | datetime |
| 字段 | 名称 | 类型 |
| id | 订单id | int |
| created_at | 创建时间 | int |
| updated_at | 修改时间 | int |
| order_sn | 订单编号 | int |
| third_order_sn | 第三方订单号 | int |
| gather_supply_sn | 供应链订单号 | int |
| gather_supply_type | 供应链类型id | int |
| title | 标题 | int |
| status | 订单状态 | int |
| amount | 订单总金额(分) | int |
| refund_amount | 退款金额(分) | int |
| item_amount | 商品市场价(分) | int |
| supply_amount | 供货金额(分) | int |
| cost_amount | 成本金额(分) | int |
| freight | 运费(分) | int |
| service_fee | 服务费(分) | int |
| goods_count | 商品总数 | int |
| send_status | 发货状态 0待发货1部分发货2已发货 | int |
| remark | 买家留言 | string |
| note | 商家备注 | string |
| technical_services_fee | 技术服务费(分) | int |
| paid_at | 支付时间 | |
| sent_at | 发货时间 | |
| received_at | 完成时间 | |
| closed_at | 关闭时间 | |
| user_id | 会员id | |
| supplier_id | 供应商id | |
| gather_supply_id | 供应链id | |
| trade_id | 交易id | |
| pay_type_id | 支付方式id | |
| can_refund | 是否可以退货(1是0否) | |
| amount_detail | 订单支付明细 | array |
| options | 商品规格 | array |
| product | 商品详情 | 看商品部分API注释 |
| order_express | 配送信息 | array |
| user | 用户信息 | array |
| shipping_address | 收货信息 | array |
| supplier | 供应商信息 | array |
| gather_supply | 供应链信息 | array |
| pay_info | 支付信息 | array |
| button | 按钮组,可使用的功能 | array |
| shop_name | 店铺名称 | string |
| pay_type | 支付方式名称 | string |
| order_item | 子订单信息 | array |
amount_detail:
| 字段 | 名称 | 类型 | 是否必须 |
| title | 名称:订单总价 | ||
| amount | 价格 | ||
| qty | 数量 | ||
| amount_items | 费用详情 | array |
options
| 字段 | 名称 | 类型 | 是否必须 |
| spec_name | 规格名称 | ||
| spec_item_name | 属性名称 |
amount_items
| 字段 | 名称 | 类型 | 是否必须 |
| title | 名称:订单总价 | ||
| amount | 价格 | ||
| qty | 数量 | ||
| amount_items | 费用详情 | amount_items |
shipping_address
| 字段 | 名称 | 类型 | 是否必须 |
| realname | 真实姓名 | ||
| mobile | 联系方式 | ||
| province | 省 | ||
| city | 市 | ||
| county | 区 | ||
| town | 街道 | ||
| detail | 详情 |
user
| 字段 | 名称 | 类型 | 是否必须 |
| nickname | 昵称 | ||
| mobile | 手机号 | ||
| avatar | 头像 |
supplier
| 字段 | 名称 | 类型 | 是否必须 |
| name | 供应商名称 |
order_item
| 字段 | 名称 | 类型 | 是否必须 |
| id | 子订单ID | int | |
|
title |
string | 商品名称 | |
| sku_title | string | 商品sku名称 | |
| price | string | 售价 | |
| cost_amount | int | 成本 | |
| supply_amount | int | 供货金额 | |
| payment_amount | int | 均摊支付金额(分 | |
| amount | int | 总价 | |
| qty | int | 商品个数 | |
| freight | int | 运费 | |
| image_url | int | 商品图片 | |
| supplier | array | 门店数据 只有名称和logo | |
| gather_supply | array | 供应链数据 只有名称和logo | |
| options | array | 商品规格已选 | |
| user | array | 用户数据id和与会员等级 | |
| product_id | array | 商品id | |
| sku_id | array | 商品规格id | |
| amount_detail | array | 金额信息 |
{ "code": 0, "data": { "list": [ { "id": 725, "created_at": 1644565739, "updated_at": 1644574239, "order_sn": 180902232015, "third_order_sn": "", "gather_supply_sn": "", "gather_supply_type": 0, "key": "30-0-85-2", "title": "测试0918", "status": 1, "amount": 12120, "refund_amount": 0, "item_amount": 12000, "supply_amount": 12000, "cost_amount": 13000, "freight": 0, "service_fee": 0, "goods_count": 1, "send_status": 0, "refund_status": 0, "remark": "", "note": "", "technical_services_fee": 120, "paid_at": 1644574239, "sent_at": null, "received_at": null, "closed_at": null, "user_id": 70, "supplier_id": 30, "gather_supply_id": 0, "application_id": 0, "trade_id": 0, "pay_type_id": -1, "pay_info_id": 1451, "shipping_method_id": 2, "shipping_address_id": 661, "send_type_id": 0, "comment_status": 0, "can_refund": 0, "lock": 0, "amount_detail": { "title": "订单总价", "amount": 12120, "qty": 0, "desc": "", "amount_items": [ { "title": "商品总价", "amount": 12000, "qty": 0, "desc": "", "amount_items": null }, { "title": "技术服务费", "amount": 120, "qty": 0, "desc": "服务费比例100", "amount_items": null }, { "title": "总运费", "amount": 0, "qty": 0, "desc": "", "amount_items": null } ] }, "order_items": [ { "id": 871, "created_at": 1644565739, "updated_at": 1644574239, "key": "", "title": "测试 商品1", "sku_title": "默认", "unit": "", "qty": 1, "amount": 12000, "refund_amount": 0, "discount_amount": 0, "deduction_amount": 0, "cost_amount": 13000, "payment_amount": 12000, "supply_amount": 12000, "image_url": "http://localhost/static/upload/images/1/2020/11/iUmmmUDOkYNKhm3BbkENu3BkxOmdxU.jpg", "send_status": 0, "refund_status": 3, "trade_id": 0, "supplier_id": 30, "user_id": 70, "order_id": 725, "product_id": 1028372, "sku_id": 21187, "original_sku_id": 0, "order_express_id": 0, "can_refund": 1, "amount_detail": { "title": "", "amount": 0, "qty": 0, "desc": "", "amount_items": [ { "title": "商品等级优惠", "amount": 0, "qty": 0, "desc": "", "amount_items": [] }, { "title": "商品总价", "amount": 12000, "qty": 0, "desc": "", "amount_items": [] } ] }, "options": [ { "spec_name": "默认", "spec_item_name": "默认" } ], "sku": { "id": 0, "created_at": null, "updated_at": null, "title": "", "price": 0, "cost_price": 0, "origin_price": 0, "guide_price": 0, "activity_price": 0, "stock": 0, "weight": 0, "is_display": 0, "product_id": 0, "supplier_id": 0, "sn": "", "image_url": "", "options": null, "original_sku_id": 0, "describe": "" }, "product": { "id": 0, "created_at": null, "updated_at": null, "title": "", "origin_price": 0, "guide_price": 0, "price": 0, "cost_price": 0, "activity_price": 0, "stock": 0, "sales": 0, "feedback_rate": 0, "sn": "", "is_new": 0, "is_recommend": 0, "is_hot": 0, "is_promotion": 0, "is_display": 0, "single_option": 0, "desc": "", "image_url": "", "video_url": "", "unit": "", "barcode": "", "long": 0, "wide": 0, "high": 0, "volume": 0, "freight": 0, "freight_type": 0, "maxPrice": 0, "minPrice": 0, "gallery": null, "qualifications": null, "detail_images": "", "attrs": null, "supplier": { "id": 0, "name": "" }, "gather_supply": { "id": 0, "name": "" }, "brand_id": 0, "supplier_id": 0, "gather_supply_id": 0, "category1_id": 0, "category2_id": 0, "category3_id": 0, "freight_template_id": 0, "source": 0, "source_goods_id": 0, "freeze": 0, "shop_level": 0, "des_level": 0, "express_level": 0, "level": 0, "child_title": "" } } ], "order_express": { "id": 0, "created_at": null, "updated_at": null, "order_id": 0, "company_code": "", "express_no": "", "order_items": null, "is_empty": 0 }, "order_bill": { "id": 0, "created_at": null, "updated_at": null, "order_id": 0, "type": 0, "account_type": 0, "person_name": "", "mobile": "", "company_name": "", "company_code": "", "email": "", "sign_address": "", "sign_mobile": "", "opening_bank": "", "bank_account": "", "status": 0, "detail_type": 0, "amount": 0, "image": "" }, "user": { "id": 70, "nickname": "小i", "mobile": "", "avatar": "https://cube.elemecdn.com/3/7c/3ea6beec64369c2642b92c6726f1epng.png" }, "shipping_address": { "id": 661, "realname": "陈先生", "mobile": "15236598523", "country_id": 86, "province_id": 44, "city_id": 4401, "county_id": 440111, "town_id": 440111006, "province": "广东省", "city": "广州市", "county": "白云区", "town": "黄石街道", "detail": "机场路", "lng": "", "lat": "" }, "shipping_method": { "id": 0, "name": "", "code": "" }, "supplier": { "id": 30, "name": "测试0918", "supplier": "18249104358" }, "gather_supply": { "id": 0, "name": "", "logo": "" }, "pay_info": { "id": 1451, "pay_sn": "180903167631", "status": "1" }, "button": [ { "title": "确认发货", "url": "order/send" }, { "title": "全额退款", "url": "order/orderRefund" } ], "shop_name": "供应商:测试0918", "pay_type": "后台支付", "application": { "id": 0, "app_name": "" } }, { "id": 724, "created_at": 1644474382, "updated_at": 1644474395, "order_sn": 180892182634, "third_order_sn": "SN220210142664A643", "gather_supply_sn": "", "gather_supply_type": 0, "key": "35-0-94-0", "title": "release", "status": 1, "amount": 9828, "refund_amount": 0, "item_amount": 9450, "supply_amount": 18900, "cost_amount": 18900, "freight": 0, "service_fee": 0, "goods_count": 2, "send_status": 1, "refund_status": 0, "remark": "", "note": "", "technical_services_fee": 378, "paid_at": 1644474382, "sent_at": null, "received_at": null, "closed_at": null, "user_id": 35, "supplier_id": 35, "gather_supply_id": 0, "application_id": 6, "trade_id": 0, "pay_type_id": 2, "pay_info_id": 1447, "shipping_method_id": 0, "shipping_address_id": 660, "send_type_id": 0, "comment_status": 0, "can_refund": 0, "lock": 0, "amount_detail": { "title": "订单总价", "amount": 9828, "qty": 0, "desc": "", "amount_items": [ { "title": "商品总价", "amount": 9450, "qty": 0, "desc": "", "amount_items": null }, { "title": "技术服务费", "amount": 378, "qty": 0, "desc": "服务费比例400", "amount_items": null }, { "title": "总运费", "amount": 0, "qty": 0, "desc": "", "amount_items": null } ] }, "order_items": [ { "id": 869, "created_at": 1644474382, "updated_at": 1644474395, "key": "", "title": "发布商品测试", "sku_title": "默认", "unit": "", "qty": 1, "amount": 50, "refund_amount": 0, "discount_amount": 0, "deduction_amount": 0, "cost_amount": 100, "payment_amount": 50, "supply_amount": 100, "image_url": "https://test-1251768088.cosgz.myqcloud.com/images/3/2018/02/L6dCEjcee2lpE4hxelllZ6u2LZPHES.jpg", "send_status": 1, "refund_status": 3, "trade_id": 0, "supplier_id": 35, "user_id": 35, "order_id": 724, "product_id": 1030495, "sku_id": 31598, "original_sku_id": 0, "order_express_id": 282, "can_refund": 1, "amount_detail": { "title": "", "amount": 0, "qty": 0, "desc": "", "amount_items": [ { "title": "商品等级优惠", "amount": -50, "qty": 0, "desc": "", "amount_items": [] }, { "title": "商品总价", "amount": 50, "qty": 0, "desc": "", "amount_items": [] } ] }, "options": [ { "spec_name": "默认", "spec_item_name": "默认" } ], "sku": { "id": 0, "created_at": null, "updated_at": null, "title": "", "price": 0, "cost_price": 0, "origin_price": 0, "guide_price": 0, "activity_price": 0, "stock": 0, "weight": 0, "is_display": 0, "product_id": 0, "supplier_id": 0, "sn": "", "image_url": "", "options": null, "original_sku_id": 0, "describe": "" }, "product": { "id": 0, "created_at": null, "updated_at": null, "title": "", "origin_price": 0, "guide_price": 0, "price": 0, "cost_price": 0, "activity_price": 0, "stock": 0, "sales": 0, "feedback_rate": 0, "sn": "", "is_new": 0, "is_recommend": 0, "is_hot": 0, "is_promotion": 0, "is_display": 0, "single_option": 0, "desc": "", "image_url": "", "video_url": "", "unit": "", "barcode": "", "long": 0, "wide": 0, "high": 0, "volume": 0, "freight": 0, "freight_type": 0, "maxPrice": 0, "minPrice": 0, "gallery": null, "qualifications": null, "detail_images": "", "attrs": null, "supplier": { "id": 0, "name": "" }, "gather_supply": { "id": 0, "name": "" }, "brand_id": 0, "supplier_id": 0, "gather_supply_id": 0, "category1_id": 0, "category2_id": 0, "category3_id": 0, "freight_template_id": 0, "source": 0, "source_goods_id": 0, "freeze": 0, "shop_level": 0, "des_level": 0, "express_level": 0, "level": 0, "child_title": "" } }, { "id": 870, "created_at": 1644474382, "updated_at": 1644474382, "key": "", "title": "招商分红测试", "sku_title": "默认", "unit": "", "qty": 1, "amount": 9400, "refund_amount": 0, "discount_amount": 0, "deduction_amount": 0, "cost_amount": 18800, "payment_amount": 9400, "supply_amount": 18800, "image_url": "https://test-1251768088.cosgz.myqcloud.com/images/3/2018/02/XCo19OYQfCCSFZ3afgGQ7bahhqUsqH.png", "send_status": 0, "refund_status": 3, "trade_id": 0, "supplier_id": 35, "user_id": 35, "order_id": 724, "product_id": 1030496, "sku_id": 31599, "original_sku_id": 0, "order_express_id": 0, "can_refund": 1, "amount_detail": { "title": "", "amount": 0, "qty": 0, "desc": "", "amount_items": [ { "title": "商品等级优惠", "amount": -9400, "qty": 0, "desc": "", "amount_items": [] }, { "title": "商品总价", "amount": 9400, "qty": 0, "desc": "", "amount_items": [] } ] }, "options": [ { "spec_name": "默认", "spec_item_name": "默认" } ], "sku": { "id": 0, "created_at": null, "updated_at": null, "title": "", "price": 0, "cost_price": 0, "origin_price": 0, "guide_price": 0, "activity_price": 0, "stock": 0, "weight": 0, "is_display": 0, "product_id": 0, "supplier_id": 0, "sn": "", "image_url": "", "options": null, "original_sku_id": 0, "describe": "" }, "product": { "id": 0, "created_at": null, "updated_at": null, "title": "", "origin_price": 0, "guide_price": 0, "price": 0, "cost_price": 0, "activity_price": 0, "stock": 0, "sales": 0, "feedback_rate": 0, "sn": "", "is_new": 0, "is_recommend": 0, "is_hot": 0, "is_promotion": 0, "is_display": 0, "single_option": 0, "desc": "", "image_url": "", "video_url": "", "unit": "", "barcode": "", "long": 0, "wide": 0, "high": 0, "volume": 0, "freight": 0, "freight_type": 0, "maxPrice": 0, "minPrice": 0, "gallery": null, "qualifications": null, "detail_images": "", "attrs": null, "supplier": { "id": 0, "name": "" }, "gather_supply": { "id": 0, "name": "" }, "brand_id": 0, "supplier_id": 0, "gather_supply_id": 0, "category1_id": 0, "category2_id": 0, "category3_id": 0, "freight_template_id": 0, "source": 0, "source_goods_id": 0, "freeze": 0, "shop_level": 0, "des_level": 0, "express_level": 0, "level": 0, "child_title": "" } } ], "order_express": { "id": 282, "created_at": 1644474395, "updated_at": 1644474395, "order_id": 724, "company_code": "AOTSD", "express_no": "321321", "order_items": null, "is_empty": 0 }, "order_bill": { "id": 0, "created_at": null, "updated_at": null, "order_id": 0, "type": 0, "account_type": 0, "person_name": "", "mobile": "", "company_name": "", "company_code": "", "email": "", "sign_address": "", "sign_mobile": "", "opening_bank": "", "bank_account": "", "status": 0, "detail_type": 0, "amount": 0, "image": "" }, "user": { "id": 35, "nickname": "测试1", "mobile": "", "avatar": "https://supply-chain-yunzmall.oss-cn-beijing.aliyuncs.com/20211011/1633932497play.png" }, "shipping_address": { "id": 660, "realname": "3213", "mobile": "18249104358", "country_id": 0, "province_id": 44, "city_id": 4401, "county_id": 440104, "town_id": 0, "province": "广东省", "city": "广州市", "county": "越秀区", "town": "", "detail": "广东省广州市越秀区321321321", "lng": "", "lat": "" }, "shipping_method": { "id": 0, "name": "", "code": "" }, "supplier": { "id": 35, "name": "release", "supplier": "13163432028" }, "gather_supply": { "id": 0, "name": "", "logo": "" }, "pay_info": { "id": 1447, "pay_sn": "180892183357", "status": "1" }, "button": [ { "title": "确认发货", "url": "order/send" }, { "title": "全额退款", "url": "order/orderRefund" } ], "shop_name": "供应商:release", "pay_type": "站内余额", "application": { "id": 6, "app_name": "测试供应链-云仓使用-请勿更换密钥" } } ], "total": 723, "page": 1, "pageSize": 2, "next_url": "" }, "msg": "获取成功"}