订单列表 按订单查看
订单按商品查看
station/order/order_sku_list
Method:Get
Class: TransportOrdersQueryView
请求:
query_type O int 时间查询类型
start_date O date 开始时间,query_type=1必传
end_date O date 结束时间,query_type=1必传
cycle_start_time O date 周期开始时间,query_type=2必传
cycle_end_time O date 周期结束时间,query_type=2必传
time_config_id O str 服务时间id,query_type=2必传
receive_start_date O date 收货开始时间,query_type=3必传
receive_end_date O date 收货结束时间,query_type=3必传
client O int 客户端类型
status O int 业务状态
pay_status O int 支付状态
has_remark O int 是否有备注,1有备注
inspect_status O int 装车状态
stock_type O int 出库状态
is_print O int 是否打印
search_area O str 地理标签
salemenu_id O str 报价单id
search_text O str 搜索框
sort_type O str 排序方式
driver_id O int 司机id
carrier_id O int 承运商id
route_id O int 线路id
receive_way O int 收货方式
pick_up_st_id O int 自提点id
offset
limit
响应:
code M int 返回码,0表示成功,其他表示错误
msg M string 错误信息
data M dict
pagination M dict
count M int
offset M int
limit M int
total_sale_money_with_freight O float 所有订单的总价格
in_query O bool 是否在这个查询条件里,默认false在这次搜索,true表示不在这个搜索标记内。反了
list M list<dict>
id M str 订单id
sort_id M int 分拣序号
station_id M str 站点id
create_user M str 创建用户
total_price M str 下单价
origin_total_price M str 原下单价
real_money M str 出库金额
abnormal_money M str 异常金额
refund_money M str 退货金额
refund_kind M int 是否有退货
sale_money M str 销售价格
sale_money_with_freight M str 销售价格+运费
freight M str 运费
date_time M float 下单时间
date_time_str M str 下单时间str类型
status M int 业务状态
pay_status M int 支付状态
print_times M int 打印次数
client M int 哪个客户端下的单
client_desc M str 客户端描述
freeze M int 锁定状态
settle_way M int 先款后货,还是先货后款
customer M dict 商户信息
id M str user_id账户id
address_id M str 店铺id
receiver_name M str 收货人
receiver_phone M str 收货人手机号
address M str 店铺地址
extender M str 店铺名
new_consumer M int
station_id M str 站点
salemenu_id M str 销售单
receive_way M int 收货方式
pick_up_st_name M str 自提点名称
route_name M str 线路名
remark M str 备注
order_tax M float 订单税额
sale_money_without_tax M str 订单不含税额
receive_begin_time M str 收货开始时间
receive_end_time M str 收货结束时间
driver_id M int 司机id
driver_name M str 司机名
salemenu_ids M list<str> 销售单id
coupon_amount M float 优惠券金额
inspect_status M int 装车状态
outstock_status M int 出库状态
time_config_info M dict
service_time_creator M str 服务时间创建者
final_distribute_time M str 配送时间
final_distribute_time_span M int 配送前后天
task_begin_time M str 任务开始时间
desc M str
type M int
name M str
_id M int
order_time_limit M dict 下单限制时间
end M str
e_span_time M int
start M str
receive_time_limit M dict 收货限制时间
end M str
start M str
e_span_time M int
receiveTimeSpan M str
weekdays M int
receiveEndSpan M int
s_span_time M int
details M list<dict>
detail_tax O str 税率
id M str 商品id
sync_origin_id M str 商品id
version M int 商品版本
total_item_price M str 下单金额
sale_price M str 售价
unit_price M str 售价(基本单位)
real_item_price M str 出库金额
total_item_pay M str 需支付价格
quantity M float 数量
real_quantity M float 出库数
accept_quantity M float 收到的数量
spu_id M float
spu_remark M float 订单备注
exc_quantity M float 异常金额
real_refund_quantity M float 退货金额
request_refund_quantity M float 请求退货金额
tax_rate M float 税率
具体看示例:
{
"code": 0,
"msg": "ok",
"data": {
"total_sale_money_with_freight": "130.00",
"in_query": false,
"list": [
{
"real_money": "130.00",
"abnormal_money": "0.00",
"time_config_info": {
"service_time_creator": "T7442",
"final_distribute_time": "23:30",
"final_distribute_time_span": 0,
"desc": "",
"order_time_limit": {
"end": "23:30",
"e_span_time": 0,
"start": "03:30",
},
"receive_time_limit": {
"end": "09:30",
"start": "09:30",
"e_span_time": 1,
"receiveTimeSpan": "15",
"weekdays": 127,
"receiveEndSpan": 1,
"s_span_time": 0,
},
"task_begin_time": "09:30",
"type": 2,
"name": "预售运营时间",
"_id": "ST662",
},
"create_user": "qucaigou01",
"receive_end_time": "2019-07-30 09:30",
"freeze": 0,
"inspect_status": 1,
"client": 1,
"order_tax": "0.00",
"total_price": "130.00",
"refund_kind": 0,
"remark": null,
"settle_way": 1,
"client_desc": "后台下单",
"date_time_str": "2019-07-29 17:40:47",
"receive_begin_time": "2019-07-29 17:45",
"customer": {
"pick_up_st_name": null,
"new_consumer": 0,
"salemenu_id": "",
"address_id": "67356",
"id": "73254",
"receive_way": 1,
"station_id": "",
"receiver_phone": "13530615249",
"address": "广东省深圳市福田区华富街道深圳中心公园",
"receiver_name": "ceshi033",
"extender": {"order_pay_method": 2, "resname": "ceshi033"},
},
"freight": "0.00",
"outstock_status": 1,
"salemenu_ids": ["S6436"],
"sale_money_without_tax": "130.00",
"driver_id": null,
"print_times": 0,
"pay_status": 1,
"station_id": "T7442",
"origin_total_price": "130.00",
"coupon_amount": "0.00",
"sale_money_with_freight": "130.00",
"route_name": "线路1",
"sale_money": "130.00",
"sort_id": null,
"driver_name": null,
"id": "PL7605075",
"status": 1,
"refund_money": "0.00",
"details": [
{
"exc_quantity": 0,
"tax_rate": 0,
"spu_id": "C964785",
"unit_price": "10.00",
"total_item_price": "130.00",
"sync_origin_id": "D9512480",
"accept_quantity": 13.0,
"real_item_price": "130.00",
"real_quantity": 13.0,
"total_item_pay": "130.00",
"id": "D9512480",
"version": 24,
"detail_tax": "0.00",
"request_refund_quantity": 0,
"sale_price": "10.00",
"spu_remark": "",
"quantity": 13.0,
"real_refund_quantity": 0,
}
],
"date_time": 1564393247.0,
}
],
"pagination": {"limit": 20, "offset": 0, "count": 1},
},
}
station/sales_analysis/orderdetail 订单导出
Method:Get
Class: DailySalesOrderDetailView
请求:
query_type O int 时间查询类型
start_date O date 开始时间,query_type=1必传
end_date O date 结束时间,query_type=1必传
cycle_start_time O date 周期开始时间,query_type=2必传
cycle_end_time O date 周期结束时间,query_type=2必传
time_config_id O str 服务时间id,query_type=2必传
receive_start_date O date 收货开始时间,query_type=3必传
receive_end_date O date 收货结束时间,query_type=3必传
format M str
status O int 业务状态
pay_status O int 支付状态
search_area O str 地理标签
salemenu_id O str 报价单id
search_text O str 搜索框
driver_id O int 司机id
carrier_id O int 承运商id
route_id O int 线路id
is_print O int 是否打印
receive_way O int 收货方式
pick_up_st_id O int 自提点id
pick_up_st_id O int 自提点id
has_remark O int 是否有备注,1有备注
is_print O int 是否打印
响应:
code M int 返回码,0表示成功,其他表示错误
msg M string 错误信息
data M dict
async M int 是否异步
task_url M str 异步连接
filename M str 名字
yongyou M list 用友格式
orders M list<dict> 订单
products M list<dict> 商品
响应示例:
{
"data": {
"task_url": null,
"orders": [
{
"receive_way": 1,
"freight": 0.0,
"driver_name": null,
"time_config_name": "测试24小时",
"pay_status": "未支付",
"is_print": "未打印",
"remark": null,
"receiver_name": "巴巴",
"address_sign_name2": "南山中心区",
"order_tax": 0.0,
"salemenu_ids": "S12731",
"route_name": "R",
"address_sign_name1": "南山区",
"date_time": "2019-08-03",
"station_name": "喵喵总仓",
"total_pay": 345.0,
"real_price": 345.0,
"abnormal_money": 0.0,
"sales": 345.0,
"order_time": "13:25:41",
"sort_id": null,
"total_price": 345.0,
"sid": "S086562",
"station_id": "T7936",
"receipt_time": "2019-08-14 00:00~2019-08-14 11:00",
"refund_money": 0.0,
"sale_money_without_tax": 345.0,
"sales_employee": "喵神1",
"distribute_time": "2019-08-14",
"client_cn": "后台下单",
"pick_up_st_name": null,
"id": "PL7710588",
"receipt_address": "南山大道12号",
"resname": "八合里(深圳总店)",
"salemenu_names": "自售单不许删",
"coupon_amount": 0.0,
"receive_date": "2019-08-14",
"receiver_phone": "233",
"order_status": "等待分拣",
"receive_time_frame": "00:00-11:00",
},
],
"products": [
{
"salemenu_name": "自售单不许删",
"category2_name": "叶菜",
"total_item_price": 333.0,
"time_config_name": "测试24小时",
"sale_unit_name": "袋",
"spu_id": "C1355555",
"abnormal_amount": 0,
"salemenu_id": "S12731",
"quantity_base_unit": 999.0,
"category2_id": "B48867",
"route_name": "R",
"category1_name": "蔬菜",
"order_id": "PL7710588",
"std_sale_price": 0.33,
"std_unit_name": "斤",
"abnormal_money": 0.0,
"refund_money": 0.0,
"date_time": "2019-08-03",
"real_quantity": 333.0,
"order_time": "13:25:41",
"quantity": 333.0,
"ref_price": 4.0,
"station_name": "喵喵总仓",
"sale_ratio": "3.0斤/袋",
"sid": "S086562",
"station_id": "T7936",
"unit_name": "元/斤",
"refund_amount": 0,
"distribute_time": "2019-08-14",
"sales": 333.0,
"category1_id": "A3978",
"sku_name": "广州白菜",
"receive_date": "2019-08-14",
"resname": "八合里(深圳总店)",
"remark": "",
"sort_id": null,
"outer_id": "",
"real_std_count": 999.0,
"real_item_price": 333.0,
"sku_id": "D7608692",
"receive_time_frame": "00:00-11:00",
"sale_price": 1.0,
},
],
"async": 0,
"filename": "订单列表_按订单查看_按下单日期_2019-08-03_2019-08-03.xlsx",
"yongyou": [],
},
"code": 0,
"msg": "",
}
station/order/set_status 修改订单状态
Method:Post
Class: TransportOrdersQueryView
请求:
order_ids M list 订单id列表
status M int 状态
batch_remark O str 分拣备注 默认空
响应:
code M int 返回码,0表示成功,其他表示错误
msg M string 错误信息
data M dict
count M int
响应实例:
{"data": {"count": 1}, "code": 0, "msg": "ok"}
station/order/update/status/preconfig 修改预设数
Method: POST
Class: PreconfigUpdateStatusView
参数:
start_date date O 下单开始日期
end_date date O 下单截止日期
time_config_id string O 时间配置ID
start_cycle_time string O 开始时间周期
end_cycle_time string O 截止时间周期
receive_begin_date string O 开始收货日期
receive_end_date string O 截止收货日期
from_status int O 原来的订单状态
search_text string O 搜索的商户名、商户ID或订单ID
count string M 修改全部时为all,修改指定数量时传数量
to_status int M 目标订单状态
batch_remark string O 分拣备注
count O str
响应:
code int M 0表示成功,非0表示失败;
msg string M 消息
data json M 修改结果统计数据,多少个成功和失败;
示例:
Request:
参数:
start_date:2017-03-27
end_date:2017-04-01
from_status:1
search_text:吉野家
count:90
to_status:5
batch_remark:test_batch_remark
Response:
{
"code": 0,
"msg": "ok",
"data":{
"success": 30,
"failed": 10
}
}
station/order/update/status/child_station 修复分仓订单
Method:POST
class:PreconfigUpdateStatusView
参数:
time_config_id string M 服务时间ID
cycle_start_time string M 周期开始时间
status int M 目标订单状态
batch_remark string O 分拣备注
响应:
code int M 0表示成功,非0表示失败;
msg string M 消息
data json M 修改结果统计数据,多少个成功和失败
示例:
Request:
参数:
time_config_id:ST002
cycle_start_time:2017-04-01-06-00-00
status:5
batch_remark:1
Response:
{
"code": 0;
"msg": "ok",
"data":{
"success": 30,
"failed": 10
}
}
station/user 用户信息
Method:POST
class:UserInfoView
参数:
无
响应:
code int M 0表示成功,非0表示失败;
msg string M 消息
data json M 修改结果统计数据,多少个成功和失败
profile M dict
station_id M str
user_permission M list
group_id M int
type M int
username M str
name M str
station_name M str
id M int
示例:
{
"data": {
"profile": {
"sorting_product_code_type": 2,
"weigh_stock_in": 1,
"weigh_check": 1,
},
"station_id": "T7936",
"user_permission": [],
"group_id": 356,
"type": 0,
"username": "miaomiao",
"name": "喵喵",
"station_name": "喵喵总仓",
"id": 3876,
},
"code": 0,
"msg": "ok",
}