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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
| "columns":[[
| {"field":"ck","checkbox":true},
| {"field": "bizdate", "title":"销售日期", "width": 200,"align": "center","sortable":true},
| {"field": "distributorcode", "title": "经销商编码", "width": 150,"align": "center","sortable":true},
| {"field": "distributorname", "title": "经销商名称", "width": 400,"align": "left","sortable":true},
| {"field": "distributorlevel", "title": "经销商级别", "width": 150,"align":"center","sortable":true},
| {"field": "ascriptioncode", "title": "所属一级编码", "width": 150,"align": "center","sortable":true},
| {"field": "ascriptionname", "title": "所属一级名称", "width": 350,"align": "left","sortable":true},
| {"field": "customercode", "title": "客户编码", "width": 150,"align": "center","sortable":true},
| {"field": "customername", "title": "客户名称", "width": 350,"align": "left","sortable":true},
| {"field": "family", "title": "客户母公司", "width": 350,"align": "left","sortable":true},
| {"field": "customertype", "title": "客户类型", "width": 150,"align":"left","sortable":true},
| {"field": "productcode", "title": "产品代码", "width": 150,"align": "right","sortable":true},
| {"field": "productname", "title": "产品名称", "width": 450,"align": "left","sortable":true},
| {"field": "producttype", "title": "产品类型", "width": 150,"align": "left","sortable":true},
| {"field": "quantity", "title": "产品数量", "width": 150,"align": "right","sortable":true},
| {"field": "price", "title": "DNP采购单价", "width": 350,"align": "right","sortable":true},
| {"field": "amount", "title": "DNP销售额", "width": 250,"align": "right","sortable":true},
| {"field": "rawprice", "title": "实际销售单价（不含税）", "width": 250,"right": "right","sortable":true},
| {"field": "rawamount", "title": "实际销售金额", "width": 250,"align": "right","sortable":true},
| {"field": "customerprovince", "title": "客户省", "width": 200,"align": "center","sortable":true},
| {"field": "customercity", "title": "客户市", "width": 200,"align": "center","sortable":true},
| {"field": "specification", "title": "产品规格", "width": 100,"align": "left","sortable":true},
| {"field": "lotno", "title": "批号", "width": 100,"align": "left","sortable":true},
| {"field": "unitname", "title": "单位", "width": 100,"align":"center","sortable":true},
| {"field": "manufacturer", "title": "生产厂家", "width": 270,"align": "left","sortable":true},
| {"field": "customeraddress", "title": "客户地址", "width": 270,"align": "left","sortable":true},
| {"field": "rawspecification", "title": "原始产品规格", "width": 350,"align": "left","sortable":true}
| ]],
| "filters" :[
| {
| field: 'bizdate',
| type: 'datebox',
| options: { precision: 1 },
| op: ['dateequal']
| },
| {
| field: 'distributorcode',
| type: 'numberbox',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'distributorname',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'distributorlevel',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'ascriptioncode',
| type: 'numberbox',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'ascriptionname',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'customercode',
| type: 'numberbox',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'customername',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'family',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'customertype',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'productcode',
| type: 'numberbox',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'productname',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'producttype',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'quantity',
| type: 'numberbox',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'price',
| type: 'text',
| options: { precision: 1 },
| op: ['numequal','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'amount',
| type: 'text',
| options: { precision: 1 },
| op: ['numequal','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'rawprice',
| type: 'numberbox',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'rawamount',
| type: 'numberbox',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'customerprovince',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'customercity',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'specification',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'lotno',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
|
| {
| field: 'unitname',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'manufacturer',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'customeraddress',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| },
| {
| field: 'rawspecification',
| type: 'text',
| options: { precision: 1 },
| op: ['contains','equal', 'notequal', 'less', 'greater']
| }
| ];
|
|
