<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2021/8/3
 * Time: 9:59
 */
 function exportWarehouseManagementToExcel()
{
    ini_set('max_execution_time', 300);// 设置PHP超时时间
    ini_set('memory_limit', '2048M');// 设置PHP临时允许内存大小
    $queryResult = [];
    for ($i=0;$i<100;$i++){
        $queryResult[$i][] = "ae123123";
        $queryResult[$i][] = "闽";
        $queryResult[$i][] = "深圳";
        $queryResult[$i][] = "on";
        $queryResult[$i][] = "03123";
    }
    //路径
    $fileName = '车管驻点业务寄递仓库管理所有数据' . date('Ymd_His') . '.csv';
    $filePath = 'excel/' . $fileName;
    $index = 0;
    $fp = fopen($filePath, 'w'); //生成临时文件
    chmod($filePath, 0777);//修改可执行权限
    // 将数据通过fputcsv写到文件句柄
    $header = array('车牌号码', '车牌类型', '所在区域', '状态', '入库时间');//设置表头
    fputcsv($fp, $header);
    //处理导出数据
    foreach ($queryResult as $key => &$val) {
        foreach ($val as $k => $v) {
            $val[$k] = $v . "\t";
            if ($index == 10000) { //每次写入1000条数据清除内存
                $index = 0;
                ob_flush();//清除内存
                flush();
            }
            $index++;
        }
        fputcsv($fp, $val);
    }
    if(ob_get_level()>0) ob_flush() ;
    fclose($fp);  //关闭句柄
    header("Cache-Control: max-age=0");
    header("Content-type:application/vnd.ms-excel;charset=UTF-8");
    header("Content-Description: File Transfer");
    header('Content-disposition: attachment; filename=' . basename($fileName));
    header("Content-Type: text/csv");
    header("Content-Transfer-Encoding: binary");
    header('Content-Length: ' . filesize($filePath));
    @readfile($filePath);//输出文件;
    unlink($filePath); //删除压缩包临时文件
    echo $filePath;
    return;
}


exportWarehouseManagementToExcel();