当前位置: 首页 > 后端技术 > PHP

phpexportExcel无需安装插件,开启配置

时间:2023-03-29 19:26:52 PHP

functionexport_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');标题('过期:0');header('Pragma:public');回声$数据;}//csv导出/**导出Excel*/publicfunctionoutput(){$org=Db::name('organization')->select();$list['one']=Db::name('transfer_flow')->order('add_timedesc')->select();foreach($list['one']as$k=>$v){foreach($orgas$kk=>$vv){if($v['org_id']==$vv['id']){$list['one'][$k]['org_id']=$vv['name'];}}if($v['pay_type']==='WX'){$list['one'][$k]['pay_type']='微信';}elseif($v['pay_type']==='A'){$list['one'][$k]['pay_type']='支付宝';}else{$list['one'][$k]['pay_type']='银行转账';}}$str="订单号、加盟商、金额、支付方式、加入时间\n";$str=iconv('utf-8','gb2312',$str);foreach($list['one']as$k=>$v){$order_no=iconv('utf-8','gb2312',$v['order_no']);$org_id=iconv('utf-8','gb2312',$v['org_id']);$pay_type=iconv('utf-8','gb2312',$v['pay_type']);$str.=$order_no。','。$组织编号。','。$v['金钱']。','。$支付类型。','。$v['添加时间']。"\n";}$filename='财务管理_'.date('Ymd').'.csv';//设置文件名$this->export_csv($filename,$str);//导出}导出csv