文档
测试

流水查询导出Excel

POST
/admin/members/money/api/export

请求头

参数名
类型
描述
必填
Cookie
String
必填
Content-Type
application/json
必填

请求参数

参数名
类型
描述
必填
uid
string
筛选条件uid
可选
keywords
string
筛序条件--会员,支持手机(mobile),昵称(nickname),姓名(realname)模糊查询
可选
ordertype
string
筛序条件--业务类型(发生的订单类型),tuijian-收益,tixian-提现,edit-调整,subsidy_fuwufei-商家服务费,subsidy_wuliu-物流补贴,other-其它
可选
startTime
string
筛序条件--时间范围-----开始时间
可选
endTime
string
筛序条件--时间范围-----结束时间
可选
_cols
array
数据列表
必填
field
string
Excel当前列参数取值字段,示例:uid
必填
title
string
Excel当前列标题,示例:UID
必填
width
int
Excel当前列边框厚度,示例:100
必填
sort
boolean
排序,示例:true, 貌似没啥用
必填
key
string
Excel当前列坐标数字,示例:0-0--第一列,0-1--第二列,0-2--第三列,以此类推.....
必填
hide
boolean
示例:false
必填
type
string
示例:normal
必填
_header
string
Excel文件首行,示例:会员帐单清单
必填

响应参数

参数名
类型
描述
必填
result
int
0--成功,其他--失败
必填
data
object
数据字典
必填
allCount
int
成功导出流水条数,示例:178
可选
url
string
Excel存放的url,示例:/uploads/export/2021/07/21/202107211716258032.xls
可选
msg
string
提示信息,示例:Success
必填

说明 / 示例

请求参数示例: ``` { "uid": "", "keywords": "", "ordertype": "", "startTime": "", "endTime": "", "_cols": [ { "field": "uid", "title": "UID", "width": 100, "sort": true, "key": "0-0", "hide": false, "type": "normal" }, { "field": "nickname", "title": "昵称", "width": 120, "key": "0-1", "hide": false, "type": "normal" }, { "field": "realname", "title": "姓名", "width": 100, "key": "0-2", "hide": false, "type": "normal" }, { "field": "mobile", "title": "手机", "width": 120, "key": "0-3", "hide": false, "type": "normal" }, { "field": "tradetime", "title": "发生时间", "width": 180, "sort": true, "key": "0-4", "hide": false, "type": "normal" }, { "field": "money", "title": "本次金额", "width": 100, "sort": true, "key": "0-5", "hide": false, "type": "normal" }, { "field": "service_fee", "title": "手续费", "width": 100, "align": "right", "key": "0-6", "hide": false, "type": "normal" }, { "field": "balance", "title": "余额", "width": 100, "align": "right", "key": "0-7", "hide": false, "type": "normal" }, { "field": "ordertype", "title": "业务类型", "width": 120, "key": "0-8", "hide": false, "type": "normal" }, { "field": "orderno", "title": "业务单号", "width": 120, "key": "0-9", "hide": false, "type": "normal" }, { "field": "remark", "title": "备注", "width": 400, "key": "0-10", "hide": false, "type": "normal" } ], "_header": "会员帐单清单" } ``` 返回参数示例: ``` { "result": 0, "data": { "allCount": 178, "url": "/uploads/export/2021/07/21/202107211716258032.xls" }, "msg": "Success" } ```