php 快速输出excel报表

最新推荐文章于 2021-03-10 11:58:17 发布

6大少

最新推荐文章于 2021-03-10 11:58:17 发布

阅读量343

点赞数

分类专栏： php 文章标签： php

本文链接：https://blog.csdn.net/varius/article/details/78454257

版权

php 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

此代码仅供参考

function outputReport(){	
		if($_GET['start']&&$_GET['end']){
			$start = strtotime($_GET['start']);
			$end   = strtotime($_GET['end']);
			$deals = $GLOBALS["db"]->getAll("select 
			d.user_id,dd.name,d.user_name,AES_DECRYPT(u.real_name_encrypt,'".AES_DECRYPT_KEY."') as real_name,d.money,d.create_time,dd.repay_time,u.pid
			from ".DB_PREFIX."xxx d
			LEFT JOIN ".DB_PREFIX."xxx u on d.user_id = u.id
			LEFT JOIN ".DB_PREFIX."xxx dd on d.deal_id = dd.id 
			where d.is_has_loans = 1 and (d.create_time between $start and $end)
			order by d.deal_id asc");
			$content = "名,人,金额,时间,期限,推荐 \n";
			//组织数据
			foreach($deals as $k=>$v){ 
				$v['create_time'] = date("Y-m-d H:i:s",$v['create_time']);
				$v['user_name'] = $v['user_name'].'['.$v['real_name'].']';
				//删除无用数组
				unset($v['real_name']); 
				$content .= implode(",", $v) . "\n";
			}
			//输出 excel
			header("Content-Disposition: attachment; filename=load_bills_list.csv"); 
			echo $content;
		}
	}