function daochu(){
$sql = "SELECT order_id,order_sn,store_name,nickname,mobile,charge,pay_able,balance,pay_type,FROM_UNIXTIME(create_time,'%Y-%m-%d') as create_time,FROM_UNIXTIME(pay_time,'%Y-%m-%d') as pay_time,pay_status,status,free_status from `mxkj_v_order`";
$sql .= "";
$data = Db::query($sql);
$header = array('序号','订单号','店铺名称','用户昵称','联系方式','订单金额','支付金额','抵扣余额','支付方式','下单时间','支付时间','付款状态','核销状态','免单状态');
$filename = '订单列表'; //设置文件名
$this->export_csv($data,$header,$filename);
}
function export_csv($data=array(),$title=array(),$filename='report'){
header("Content-type:application/octet-stream");
header("Accept-Ranges:bytes");
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=".$filename.date("Y-m-d").".xls");
header("Pragma: no-cache");
header("Expires: 0");
//导出xls 开始
if (!empty($title)){
foreach ($title as $k => $v) {
$title[$k]= $v;
}
$title= implode("\t", $title);
echo "$title\n";
}
if (!empty($data)){
foreach($data as $key=>$val){
foreach ($val as $ck => $cv) {
$data[$key][$ck]= $cv;
}
$data[$key]=implode("\t", $data[$key]);
}
echo implode("\n",$data);
}
}
php导出数据
最新推荐文章于 2022-12-06 11:06:06 发布