report.php
30.6 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
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
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
if (PHP_SAPI == 'cli') {
die('This example should only be run from a Web Browser');
}
require_once IA_ROOT .'/addons/wwx_fxxt/class/phpexcel/PHPExcel.php';
ini_set('memory_limit', '350M');
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator('微无限分销') ->setLastModifiedBy('微无限分销') ->setTitle('Office 2007 XLSX Test Document') ->setSubject('Office 2007 XLSX Test Document') ->setDescription('Test document for Office 2007 XLSX, generated using PHP classes.') ->setKeywords('office 2007 openxml php') ->setCategory('report file');
if ($report == 'salereport01') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '月份')->setCellValue('B1', '交易量')->setCellValue('C1', '比例');
$i = 2;
foreach ($list as $v) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $v['month'])->setCellValue('B' . $i, $v['count'])->setCellValue('C' . $i, $v['persent'] . '%');
$i++;
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D' . $i, '总' . ($radioMonthForSaleType == 1 ? '交易额' : '交易量'))->setCellValue('E' . $i, $allcount);
$i++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D' . $i, '最高峰' . ($radioMonthForSaleType == 1 ? '交易额' : '交易量'))->setCellValue('E' . $i, $topcount);
$objPHPExcel->getActiveSheet()->getStyle('A1:C1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12);
$objPHPExcel->getActiveSheet()->setTitle('零售生意报告_按月统计');
}
if ($report == 'salereport02') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '日期')->setCellValue('B1', '交易量')->setCellValue('C1', '比例');
$i = 2;
foreach ($list as $v) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $v['day'])->setCellValue('B' . $i, $v['count'])->setCellValue('C' . $i, $v['persent'] . '%');
$i++;
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D' . $i, '总' . ($radiodayForSaleType == 1 ? '交易额' : '交易量'))->setCellValue('E' . $i, $dayallcount);
$i++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D' . $i, '最高峰' . ($radiodayForSaleType == 1 ? '交易额' : '交易量'))->setCellValue('E' . $i, $daytopcount);
$objPHPExcel->getActiveSheet()->getStyle('A1:C1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12);
$objPHPExcel->getActiveSheet()->setTitle('零售生意报告_按日统计');
}
if ($report == 'orderstatistics') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '订单ID')->setCellValue('B1', '订单号')->setCellValue('C1', '下单时间')->setCellValue('D1', '支付时间')->setCellValue('E1', '订单总额')->setCellValue('F1', '运费')->setCellValue('G1', '付款方式')->setCellValue('H1','状态')->setCellValue('I1', '用户名')->setCellValue('J1', '收货人')->setCellValue('K1', '收货地址')->setCellValue('L1', '收货电话')->setCellValue('M1', '分类编号')->setCellValue('N1', '分类名称')->setCellValue('O1', '产品名称')->setCellValue('P1', '规格')->setCellValue('Q1', '商品单价')->setCellValue('R1', '购买数量')->setCellValue('S1', '商品总价');
$i = 2;
$index = 0;
$countmoney1 = 0;
$countmoney2 = 0;
$countmoney3 = 0;
foreach ($list as $item) {
//只统计已完成的
if($item['status']==3)
$countmoney1 = $countmoney1 + $item['price'];
$priceother = '';
if($item['status']==3)
$index++;
if (!empty($item['dispatchprice']) && $item['dispatchprice'] > 0) {
$priceother = $item['dispatchprice'];
} else {
$priceother = '0';
}
$paytype = '';
if ($item['paytype'] == 1) {
$paytype = '余额支付';
}
if ($item['paytype'] == 2) {
$paytype = '在线支付';
}
if ($item['paytype'] == 3) {
$paytype = '货到付款';
}
if (empty($item['zhifutime'])) {
$zhifutime = '尚未支付';
} else {
$zhifutime = date('Y-m-d H:i:s', $item['zhifutime']);
}
if($item['status'] == 3){
$order_status='已完成';
}elseif($item['status'] == -6){
$order_status='已退款';
}elseif($item['status'] == -5){
$order_status='已退货';
}else{
$order_status='未知状态';
}
if($item['status']==3)
$countmoney2 = $countmoney2 + $priceother;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $item['id'])->setCellValue('B' . $i, $item['ordersn'])->setCellValue('C' . $i, date('Y-m-d H:i:s', $item['createtime']))->setCellValue('D' . $i, $zhifutime)->setCellValue('E' . $i, $item['price'])->setCellValue('F' . $i, $priceother)->setCellValue('G' . $i, $paytype)->setCellValue('H' . $i, $order_status)->setCellValue('I' . $i, $item['realnamestr'])->setCellValue('J' . $i, $item['tdrealname'])->setCellValue('K' . $i, $item['tdaddress'])->setCellValue('L' . $i, $item['tdmobile']);
$styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$itemdatas = array();
$itemdline = 0;
foreach ($item['ordergoods'] as $itemgoods) {
if ($itemdline == 0) {
$itemdatas['categorysn'] = '';
$itemdatas['categoryname'] = '';
$itemdatas['title'] = '';
$itemdatas['optionname'] = '';
$itemdatas['price'] = '';
$itemdatas['total'] = '';
$itemdatas['goodstotal'] = '';
$sline = '';
} else {
$sline = '+';
}
$itemdatas['categorysn'] = $itemdatas['categorysn'] . $sline . $itemgoods['categorysn'];
$itemdatas['categoryname'] = $itemdatas['categoryname'] . $sline . $itemgoods['categoryname'];
$itemdatas['title'] = $itemdatas['title'] . $sline . $itemgoods['title'];
$itemdatas['optionname'] = $itemdatas['optionname'] . $sline . $itemgoods['optionname'];
$itemdatas['price'] = $itemdatas['price'] . $sline . $itemgoods['price'];
$itemdatas['total'] = $itemdatas['total'] . $sline . $itemgoods['total'];
$itemdatas['goodstotal'] = $itemdatas['goodstotal'] . $sline . round($itemgoods['total'] * $itemgoods['price'], 2);
if($item['status']==3)
$countmoney3 = $countmoney3 + round($itemgoods['total'] * $itemgoods['price'], 2);
$itemdline = $itemdline + 1;
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('M' . $i, $itemdatas['categorysn'])->setCellValue('N' . $i, $itemdatas['categoryname'])->setCellValue('O' . $i, $itemdatas['title'])->setCellValue('P' . $i, $itemdatas['optionname'])->setCellValue('Q' . $i, $itemdatas['price'])->setCellValue('R' . $i, $itemdatas['total'])->setCellValue('S' . $i, $itemdatas['goodstotal']);
$objPHPExcel->getActiveSheet()->getStyle('B' . $i . ':S' . $i)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('M' . $i . ':S' . $i)->getAlignment()->setWrapText(true);
$objBorderA5 = $objPHPExcel->getActiveSheet()->getStyle('B' . $i . ':T' . $i)->getBorders();
$objBorderA5->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objBorderA5->getTop()->getColor()->setARGB('FFFF0000');
$objBorderA5->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objBorderA5->getBottom()->getColor()->setARGB('FFFF0000');
$objPHPExcel->getActiveSheet()->getStyle('B' . $i . ':S' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$i++;
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $i, '共计' . $index . '单')->setCellValue('C' . $i, '订单总额：')->setCellValue('E' . $i, '' . $countmoney1)->setCellValue('G' . $i, '运费：' . $countmoney2)->setCellValue('Q' . $i, '商品总价：')->setCellValue('S' . $i, '' . $countmoney3);
$objPHPExcel->getActiveSheet()->getStyle('B' . $i . ':S' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('B1:S1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(18);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(65);
$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(10);
$objPHPExcel->getActiveSheet()->setTitle('订单统计');
}
if ($report == 'memberstatistics') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '会员标识')->setCellValue('B1', '会员昵称')->setCellValue('C1', '真实姓名')->setCellValue('D1', '电话')->setCellValue('E1', '微信标识')->setCellValue('F1', '余额')->setCellValue('G1', '积分')->setCellValue('H1', '注册时间')->setCellValue('I1', '是否关注')->setCellValue('J1', '性别')->setCellValue('K1', '国籍')->setCellValue('L1', '省份')->setCellValue('M1', '城市');
$i = 2;
$index = 0;
$countmoney = 0;
foreach ($list as $item) {
if ($item['gender'] == 0) {$gender = '保密';} elseif ($item['gender'] == 1) {$gender = '男';} else {$gender = '女';}
if ($item['follow'] == 1) {$follow = '已关注';} else {$follow = '未关注';}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $item['flagid'])->setCellValue('B' . $i, $item['nickname'])->setCellValue('C' . $i, $item['realname'])->setCellValue('D' . $i, $item['mobile'])->setCellValue('E' . $i, $item['from_user'])->setCellValue('F' . $i, $item['credit2'])->setCellValue('G' . $i, $item['credit1'])->setCellValue('H' . $i, date('Y-m-d H:i:s', $item['createtime']))->setCellValue('I' . $i, $follow)->setCellValue('J' . $i, $gender)->setCellValue('K' . $i, $item['nationality'])->setCellValue('L' . $i, $item['resideprovince'])->setCellValue('M' . $i, $item['residecity']);
$i++;
$index++;
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $i, '共计' . $index . '位');
$objPHPExcel->getActiveSheet()->getStyle('B' . $i . ':N' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('A1:N1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(33);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(20);
$objPHPExcel->getActiveSheet()->setTitle('会员详细信息');
}
if ($report == 'fansstatistics') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '代理ID')->setCellValue('B1', '代理昵称')->setCellValue('C1', '真实姓名')->setCellValue('D1', '性别')->setCellValue('E1', '是否关注')->setCellValue('F1', '电话')->setCellValue('G1', '微信标识')->setCellValue('H1', '银行名称')->setCellValue('I1', '银行卡号')->setCellValue('J1', '支付宝')->setCellValue('K1', '微信号')->setCellValue('L1', '余额')->setCellValue('M1', '积分')->setCellValue('N1', '注册时间')->setCellValue('O1', '成为代理时间')->setCellValue('P1', '上级代理ID')->setCellValue('Q1', '上级代理姓名')->setCellValue('R1', '状态')->setCellValue('S1', '点击数')->setCellValue('T1', '已结佣金')->setCellValue('U1', '已打佣金')->setCellValue('V1', '本人累计销售总额')->setCellValue('W1', '一级团队人数')->setCellValue('X1', '一级团队累计销售总额')->setCellValue('Y1', '国籍')->setCellValue('Z1', '省份')->setCellValue('AA1', '城市');
$i = 2;
$index = 0;
$countmoney = 0;
foreach ($list as $item) {
if ($item['gender'] == 0) {$gender = '保密';} elseif ($item['gender'] == 1) {$gender = '男';} else {$gender = '女';}
if ($item['follow'] == 1) {$follow = '已关注';} else {$follow = '未关注';}
if ($item['flag'] == 1) {$flag = '正式代理';} else {$flag = '普通会员';}
if (empty($item['sharprice'])) {$sharprice = 0;} else {$sharprice = $item['sharprice'];}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $item['id'])->setCellValue('B' . $i, $item['nickname'])->setCellValue('C' . $i, $item['realname'])->setCellValue('D' . $i, $gender)->setCellValue('E' . $i, $follow)->setCellValue('F' . $i, $item['mobile'])->setCellValue('G' . $i, $item['from_user'])->setCellValue('H' . $i, $item['banktype'])->setCellValue('I' . $i, $item['bankcard'])->setCellValue('J' . $i, $item['alipay'])->setCellValue('K' . $i, $item['wxhao'])->setCellValue('L' . $i, $item['creditmany'])->setCellValue('M' . $i, $item['credit1'])->setCellValue('N' . $i, date('Y-m-d H:i:s', $item['createtime']))->setCellValue('O' . $i, date('Y-m-d H:i:s', $item['flagtime']))->setCellValue('P' . $i, $item['shareid'])->setCellValue('Q' . $i, $item['sharname'])->setCellValue('R' . $i, $flag)->setCellValue('S' . $i, $item['clickcount'])->setCellValue('T' . $i, $item['commission'])->setCellValue('U' . $i, $item['zhifu'])->setCellValue('V' . $i, $sharprice)->setCellValue('W' . $i, $item['zhituisum'])->setCellValue('X' . $i, $item['tuanxiaoshou'])->setCellValue('Y' . $i, $item['nationality'])->setCellValue('Z' . $i, $item['resideprovince'])->setCellValue('AA' . $i, $item['residecity']);
$i++;
$index++;
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $i, '共计' . $index . '位');
$objPHPExcel->getActiveSheet()->getStyle('B' . $i . ':AB' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('A1:AB1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(8);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(33);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('V')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('W')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('X')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setWidth(20);
$objPHPExcel->getActiveSheet()->setTitle('代理详细信息');
}
if ($report == 'sharestatistics') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '代理ID')->setCellValue('B1', '代理等级')->setCellValue('C1', '上级代理ID')->setCellValue('D1', '上级代理姓名')->setCellValue('E1', '代理昵称')->setCellValue('F1', '真实姓名')->setCellValue('G1', '性别')->setCellValue('H1', '是否关注')->setCellValue('I1', '电话')->setCellValue('J1', '微信标识')->setCellValue('K1', '银行名称')->setCellValue('L1', '银行卡号')->setCellValue('M1', '支付宝')->setCellValue('N1', '微信号')->setCellValue('O1', '余额')->setCellValue('P1', '积分')->setCellValue('Q1', '注册时间')->setCellValue('R1', '成为代理时间')->setCellValue('S1', '状态')->setCellValue('T1', '点击数')->setCellValue('U1', '已结佣金')->setCellValue('V1', '已打佣金')->setCellValue('W1', '店中店模式')->setCellValue('X1', '店中店标题')->setCellValue('Y1', '店中店话术')->setCellValue('Z1', '国籍')->setCellValue('AA1', '省份')->setCellValue('AB1', '城市');
$i = 2;
$index = 0;
$countmoney = 0;
foreach ($list as $item) {
if ($item['gender'] == 0) {$gender = '保密';} elseif ($item['gender'] == 1) {$gender = '男';} else {$gender = '女';}
if ($item['follow'] == 1) {$follow = '已关注';} else {$follow = '未关注';}
if ($item['member']['flag'] == 1) {$flag = '正式代理';} else {$flag = '普通会员';}
if ($item['level'] == 1) {$level = '一级代理';} elseif ($item['level'] == 2) {$level = '二级代理';} elseif ($item['level'] == 3) {$level = '三级代理';}
if (empty($item['member']['dzdflag'])) {$dzdflag = '关闭';} else {$dzdflag = '开启中';}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $item['member']['id'])->setCellValue('B' . $i, $level)->setCellValue('C' . $i, $item['member']['shareid'])->setCellValue('D' . $i, $item['sharname'])->setCellValue('E' . $i, $item['nickname'])->setCellValue('F' . $i, $item['realname'])->setCellValue('G' . $i, $gender)->setCellValue('H' . $i, $follow)->setCellValue('I' . $i, $item['mobile'])->setCellValue('J' . $i, $item['openid'])->setCellValue('K' . $i, $item['member']['banktype'])->setCellValue('L' . $i, $item['member']['bankcard'])->setCellValue('M' . $i, $item['member']['alipay'])->setCellValue('N' . $i, $item['member']['wxhao'])->setCellValue('O' . $i, $item['credit2'])->setCellValue('P' . $i, $item['credit1'])->setCellValue('Q' . $i, date('Y-m-d H:i:s', $item['createtime']))->setCellValue('R' . $i, date('Y-m-d H:i:s', $item['member']['flagtime']))->setCellValue('S' . $i, $flag)->setCellValue('T' . $i, $item['member']['clickcount'])->setCellValue('U' . $i, $item['member']['commission'])->setCellValue('V' . $i, $item['member']['zhifu'])->setCellValue('W' . $i, $dzdflag)->setCellValue('X' . $i, $item['member']['dzdtitle'])->setCellValue('Y' . $i, $item['member']['dzdsendtext'])->setCellValue('Z' . $i, $item['nationality'])->setCellValue('AA' . $i, $item['resideprovince'])->setCellValue('AB' . $i, $item['residecity']);
$i++;
$index++;
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $i, '共计' . $index . '位');
$objPHPExcel->getActiveSheet()->getStyle('B' . $i . ':AC' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('A1:AC1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(8);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(33);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('V')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('W')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('X')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setWidth(20);
$objPHPExcel->getActiveSheet()->setTitle('代理旗下所有会员信息');
}
if ($report == 'shangpinstatistics') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '订单ID')->setCellValue('B1', '订单编号')->setCellValue('C1', '订单级别')->setCellValue('D1', '收货人姓名')->setCellValue('E1', '联系电话')->setCellValue('F1', '状态')->setCellValue('G1', '支付方式')->setCellValue('H1', '总价')->setCellValue('I1', '运费')->setCellValue('J1', '下单时间')->setCellValue('K1', '付款时间')->setCellValue('L1', '一级代理ID')->setCellValue('M1', '一级佣金')->setCellValue('N1', '二级代理ID')->setCellValue('O1', '二级佣金')->setCellValue('P1', '三级代理ID')->setCellValue('Q1', '三级佣金');
$i = 2;
$index = 0;
$countmoney = 0;
foreach ($list as $item) {
if ($item['shareid'] == $profile['id']) {$shareid = '1级订单';} elseif ($item['shareid2'] == $profile['id']) {$shareid = '2级订单';} elseif ($item['shareid3'] == $profile['id']) {$shareid = '3级订单';}
if ($item['status'] == 0) {$status = '待付款';} elseif ($item['status'] == 1) {$status = '待发货';} elseif ($item['status'] == 2) {$status = '待收货';} elseif ($item['status'] == 3) {$status = '已完成';} elseif ($item['status'] == -1) {$status = '已关闭';} elseif ($item['status'] == -2) {$status = '退款中';} elseif ($item['status'] == -3) {$status = '换货中';} elseif ($item['status'] == -4) {$status = '退货中';} elseif ($item['status'] == -5) {$status = '已退货';} elseif ($item['status'] == -6) {$status = '已退款';}
if ($item['paytype'] == 1) {$paytype = '余额支付';} elseif ($item['paytype'] == 2) {$paytype = '在线支付';} elseif ($item['paytype'] == 3) {$paytype = '货到付款';}
if (empty($item['zhifutime'])) {$zhifutime = '尚未支付';} else {$zhifutime = date('Y-m-d H:i:s', $item['zhifutime']);}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $item['id'])->setCellValue('B' . $i, $item['ordersn'])->setCellValue('C' . $i, $shareid)->setCellValue('D' . $i, $address[$item['addressid']]['realname'])->setCellValue('E' . $i, $address[$item['addressid']]['mobile'])->setCellValue('F' . $i, $status)->setCellValue('G' . $i, $paytype)->setCellValue('H' . $i, $item['price'])->setCellValue('I' . $i, $item['dispatchprice'])->setCellValue('J' . $i, date('Y-m-d H:i:s', $item['createtime']))->setCellValue('K' . $i, $zhifutime)->setCellValue('L' . $i, $item['shareopen1'])->setCellValue('M' . $i, $item['commission'])->setCellValue('N' . $i, $item['shareopen2'])->setCellValue('O' . $i, $item['commission2'])->setCellValue('P' . $i, $item['shareopen3'])->setCellValue('Q' . $i, $item['commission3']);
$i++;
$index++;
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $i, '共计' . $index . '单');
$objPHPExcel->getActiveSheet()->getStyle('B' . $i . ':R' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('A1:R1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(10);
$objPHPExcel->getActiveSheet()->setTitle('代理旗下所有订单');
}
if ($report == 'saledetails') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '订单号')->setCellValue('B1', '商品名称')->setCellValue('C1', '数量')->setCellValue('D1', '价格')->setCellValue('E1', '成交时间');
$i = 2;
$index = 0;
$countmoney = 0;
foreach ($list as $item) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $item['ordersn'])->setCellValue('B' . $i, $item['titles'])->setCellValue('C' . $i, $item['total'])->setCellValue('D' . $i, $item['price'])->setCellValue('E' . $i, date('Y-m-d H:i:s', $item['createtime']));
$i++;
}
$objPHPExcel->getActiveSheet()->getStyle('A1:F1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
$objPHPExcel->getActiveSheet()->setTitle('商品销售明细');
}
if ($report == 'productsaleranking') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '排行')->setCellValue('B1', '商品名称')->setCellValue('C1', '销售量')->setCellValue('D1', '销售额');
$i = 2;
$index = 1;
$countmoney = 0;
foreach ($list as $item) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $index)->setCellValue('B' . $i, $item['title'])->setCellValue('C' . $i, $item['salescount'] == 0 ? 0 : $item['salescount'])->setCellValue('D' . $i, $item['salesmoney'] == 0 || empty($item['salesmoney']) ? 0 : $item['salesmoney']);
$i++;
$index++;
}
$objPHPExcel->getActiveSheet()->getStyle('A1:F1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
$objPHPExcel->getActiveSheet()->setTitle('商品销售排行');
}
if ($report == 'memberranking') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '排行')->setCellValue('B1', '会员')->setCellValue('C1', '订单数')->setCellValue('D1', '消费金额');
$i = 2;
$index = 1;
$countmoney = 0;
foreach ($list as $item) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $index)->setCellValue('B' . $i, $item['realname'])->setCellValue('C' . $i, $item['ordercount'])->setCellValue('D' . $i, $item['ordermoney'] == 0 || empty($item['ordermoney']) ? 0 : $item['ordermoney']);
$i++;
$index++;
}
$objPHPExcel->getActiveSheet()->getStyle('A1:F1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
$objPHPExcel->getActiveSheet()->setTitle('会员消费排行');
}
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="report_' . time() . '.xlsx"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
die;
?>