$str = "用户ID,用户昵称,可提收入,已提收入,总收入,越狱,邀请用户数量,试玩应用数量\n";
$str = iconv('utf-8', 'gb2312', $str);
/** 列表项 */
foreach ($res as $key => $row) {
$row['id'] = iconv('utf-8', 'gb2312', $row['id']); //中文转码
$row['nick'] = iconv('utf-8', 'gb2312', $row['nick']);
$v = $row['income'] - $row['spend'];
$v = iconv('utf-8', 'gb2312', $v);
$row['spend'] = iconv('utf-8', 'gb2312', $row['spend']);
$row['income'] = iconv('utf-8', 'gb2312', $row['income']);
$row['escape'] = iconv('utf-8', 'gb2312', $row['escape']);
$row['invited_user_num'] = iconv('utf-8', 'gb2312', $row['invited_user_num']);
$row['download_num'] = iconv('utf-8', 'gb2312', $row['download_num']);
$str .= $row['id'] . "," . $row['nick'] . "," . $v . "," . $row['spend'] . "," . $row['income'] . "," . $row['escape'] . "," . $row['invited_user_num'] . "," . $row['download_num'] . "\n"; //用引文逗号分开
}
$filename = date('Ymd') . '.csv'; //设置文件名
$this->mUser->export_csv($filename, $str);
$str = iconv('utf-8', 'gb2312', $str);
/** 列表项 */
foreach ($res as $key => $row) {
$row['id'] = iconv('utf-8', 'gb2312', $row['id']); //中文转码
$row['nick'] = iconv('utf-8', 'gb2312', $row['nick']);
$v = $row['income'] - $row['spend'];
$v = iconv('utf-8', 'gb2312', $v);
$row['spend'] = iconv('utf-8', 'gb2312', $row['spend']);
$row['income'] = iconv('utf-8', 'gb2312', $row['income']);
$row['escape'] = iconv('utf-8', 'gb2312', $row['escape']);
$row['invited_user_num'] = iconv('utf-8', 'gb2312', $row['invited_user_num']);
$row['download_num'] = iconv('utf-8', 'gb2312', $row['download_num']);
$str .= $row['id'] . "," . $row['nick'] . "," . $v . "," . $row['spend'] . "," . $row['income'] . "," . $row['escape'] . "," . $row['invited_user_num'] . "," . $row['download_num'] . "\n"; //用引文逗号分开
}
$filename = date('Ymd') . '.csv'; //设置文件名
$this->mUser->export_csv($filename, $str);
exit; //导出
public function export_csv($filename, $data)
{
header("Content-type:text/csv");
header("Content-Disposition:attachment;filename=" . $filename);
header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
header('Expires:0');
header('Pragma:public');
echo $data;
}