exprot-excel-conf.js
1.85 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
const exportExcelConfs = {
shopBill: {
apiUrl: '/erp/queryShopBillList',
conf: {
cols: [
{
caption: '账务ID',
type: 'number',
},
{
caption: '结算时间',
type: 'string',
},
{
caption: '订单号',
type: 'string',
},
{
caption: 'SKU',
type: 'string',
},
{
caption: '数量',
type: 'number',
},
{
caption: '商品名称',
type: 'string',
},
{
caption: '账务类型',
type: 'string',
},
{
caption: '业务描述',
type: 'string',
},
{
caption: '成交价/优惠价',
type: 'number',
},
{
caption: '商家应收/分摊比例',
type: 'number',
},
{
caption: '商家应收',
type: 'number',
},
{
caption: '提现服务费',
type: 'number',
},
{
caption: '商家实收',
type: 'number',
},
{
caption: '提现状态',
type: 'string',
},
{
caption: '可提现日期',
type: 'string',
},
{
caption: '提现申请日期',
type: 'string',
},
],
rows: [
'id',
'businessTime',
'orderCode',
'productSku',
'quantity',
'productName',
'billTypeDesc',
'clearingTypeName',
'lastPrice',
'clearingDiscount',
'shopDeserveAmount',
'withdrawServiceAmount',
'shopNetAmount',
'statusName',
'withdrawalTime',
'withdrawApplyTime',
],
},
},
};
module.exports = exportExcelConfs;