/**
*
* 导出Excel
*/
public function expUser(){
//导出Excel
$name=session('userName');
$uid=session('uId');
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=".$name.".xls");
$xlsData=D('Class')->looksort($uid,$classid,$time1,$time2);//根据分类,时间查询数据
$str = "分类\t收支\t金额\t时间\t备注\n";
foreach ($xlsData as $k => $v)
{
$xlsData[$k]['status']=$v['status']==1?'支出':'收入';
}
foreach ($xlsData as $val) {
$str .= $val['c_name'] . "\t" .$val['status'] . "\t" . $val['money'] . "\t".$val['b_time']."\t".$val['desc']."\n";
}
}
*
* 导出Excel
*/
public function expUser(){
//导出Excel
$name=session('userName');
$uid=session('uId');
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=".$name.".xls");
$xlsData=D('Class')->looksort($uid,$classid,$time1,$time2);//根据分类,时间查询数据
$str = "分类\t收支\t金额\t时间\t备注\n";
foreach ($xlsData as $k => $v)
{
$xlsData[$k]['status']=$v['status']==1?'支出':'收入';
}
foreach ($xlsData as $val) {
$str .= $val['c_name'] . "\t" .$val['status'] . "\t" . $val['money'] . "\t".$val['b_time']."\t".$val['desc']."\n";
}
// echo $str;
//防止出现乱码
echo iconv('utf-8', 'gbk',$str);
}