数据统计需要,导出数据表格,本人使用的PHPExcel扩展
<?php
require_once "PHPExcel.php";
require_once 'PHPExcel/IOFactory.php';
require_once 'PHPExcel/Writer/Excel5.php';
public function actionGetExport() {
$resultPHPExcel = new PHPExcel();
$resultPHPExcel->getActiveSheet()->setCellValue('A1', "要导出的表格的名称");
$resultPHPExcel->getActiveSheet()->mergeCells('A1:H1');
//设置参数
$resultPHPExcel->getActiveSheet()->setCellValue('A2', '名称');
$resultPHPExcel->getActiveSheet()->setCellValue('B2', '下单笔数');
$resultPHPExcel->getActiveSheet()->setCellValue('C2', '成功笔数');
$resultPHPExcel->getActiveSheet()->setCellValue('D2', '成功总金额(元)');
$resultPHPExcel->getActiveSheet()->setCellValue('E2', '充值成功率');
$resultPHPExcel->getActiveSheet()->setCellValue('F2', '下单笔数占比');
$resultPHPExcel->getActiveSheet()->setCellValue('G2', '充值金额占比');
$resultPHPExcel->getActiveSheet()->setCellValue('H2', '平均充值金额(元)');
$data = '从库中查询的数据';
$i = 3;
foreach($data as &$item) {
$resultPHPExcel->getActiveSheet()->setCellValue('A' . $i, $payments[$item['payment_id']]);
$resultPHPExcel->getActiveSheet()->setCellValue('B' . $i, $item['count']);
$resultPHPExcel->getActiveSheet()->setCellValue('C' . $i, $item['count_succeed']);
$resultPHPExcel->getActiveSheet()->setCellValue('D' . $i, $item['amount']);
$resultPHPExcel->getActiveSheet()->setCellValue('E' . $i, (number_format($item['count_succeed'] / $item['count'], 4, '.', '') * 100) . '%');
$resultPHPExcel->getActiveSheet()->setCellValue('F' . $i, (number_format($item['count'] / $totalCount, 4, '.', '') * 100) . '%');
$resultPHPExcel->getActiveSheet()->setCellValue('G' . $i, (number_format($item['amount'] / $totalMoney, 4, '.', '') * 100) . '%');
$resultPHPExcel->getActiveSheet()->setCellValue('H' . $i, 0);
$i ++;
}
$outputFileName = 'total_'.date('Y/m/d H:i:s').'.xls';
$xlsWriter = new PHPExcel_Writer_Excel5($resultPHPExcel);
header('Content-type:application/vnd.ms-excel');
header('Content-Disposition:inline;filename="'.$outputFileName.'"');
$xlsWriter->save( "php://output" );
}
?>