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
189
190
191
192
193
194
195
|
| "width":4000,
|
| "title":"标准销售流向",
|
| "pageSize":20,
|
| "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"]
| }
| ]
|
|
