<?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;
?>