写入csv
//写入csv
$url_csv = WSING_ROOT . '/countall.csv';
if (file_exists($url_csv)) {
unlink($url_csv);
}
$fp = fopen($url_csv, 'ab');
$export_array = array(
iconv('utf-8', 'gbk', '日期'),
iconv('utf-8', 'gbk', '财富通充值金额'),
iconv('utf-8', 'gbk', '支付宝冲值金额'),
iconv('utf-8', 'gbk', '微信冲值金额'),
iconv('utf-8', 'gbk', 'ios内购冲值金额'),
iconv('utf-8', 'gbk', '全部金额'),
);
fputcsv($fp, $export_array);
if ($data !== 0) {
foreach ($data['data'] as $value) {
$export_array = array(
iconv('utf-8', 'gbk', "{$value['date']}\t"),
iconv('utf-8', 'gbk', "{$value['total_tenpay']}\t"), #\t 可以使参数原样输出
iconv('utf-8', 'gbk', "{$value['total_taobao']}\t"),
iconv('utf-8', 'gbk', "{$value['total_wxpay']}\t"),
iconv('utf-8', 'gbk', "{$value['total_ios']}\t"),
iconv('utf-8', 'gbk', "{$value['total_all']}\t"),
);
fputcsv($fp, $export_array);
}
}
fclose($fp);
下载
a标签指向这个地址
/**
*
* @return [type] [description]
*/
public function doExport()
{
$filename_url = WSING_ROOT . '/countall.csv';
$out_filename = 'countall.csv';
$filesize = filesize($filename_url);
header('Accept-Ranges: bytes');
header('Accept-Length: ' . $filesize);
// It will be called
header('Content-Transfer-Encoding: binary');
header('Content-type: application/octet-stream');
header('Content-Disposition: attachment; filename=' . $out_filename);
// The source is in filename
readfile($filename_url);
exit;
}