CSV分页导出压缩包

CSV导出

public function export()
{
   $new_info = '数据库查询语句默认第一页';
   $csv_title=array('序号','操作人','类型','采购时间','操作时间','批次号','供应商','仓库','合计(种)','金额','备注');
   if($page == 1){
        $keys = uniqid();
    }else{
        $keys = $content['keys'];
    }
    $name = './Uploads/purchase/'.$keys;
    $this->put_csv($new_info,$csv_title,$name);
    if(count($info) < 100){
        $res = array(
            'status'=>1,
            'type'=>2,
            'name'=>$name,
            'page'=>++$page,
            'keys'=>$keys
        );
    }else{
        $res = array(
            'status'=>1,
            'type'=>1,
            'page'=>++$page,
            'keys'=>$keys
        );
    }
    $this->ajaxReturn($res);
}
//directory_name    路径
public function put_csv($list,$title,$directory_name){
        $file_name="CSV".date("Y-m-d",time()).".csv";
        header ( 'Content-Type: application/vnd.ms-excel' );
        header ( 'Content-Disposition: attachment;filename='.$file_name );
        header ( 'Cache-Control: max-age=0' );
        $mi = uniqid();
        if (!is_dir($directory_name)) {
            $temp = ltrim($directory_name, './');
            $arr = explode('/', $temp);
            $str = './';
            foreach ($arr as $key => $sv) {
                if (!is_dir("{$str}/{$sv}")) {
                    mkdir("{$str}/{$sv}", 0777);
                }
                $str = "{$str}/{$sv}";
            }
        }
        $file = fopen($directory_name.'/'.$mi.'.csv',"a");
        foreach ($title as $v){
//           $tit[]=iconv('UTF-8', 'GB2312//IGNORE',$v);
            $tit[]=$v;
        }
        fputcsv($file,$tit);
        foreach ($list as $v){
            foreach ($v as $t){
        //      $tarr[]=iconv('UTF-8', 'GB2312//IGNORE',$t);
              $tarr[]=$t;
            }
            fputcsv($file,$tarr);
            unset($tarr);
        }
        ob_flush();
        flush();
        unset($list);
        fclose($file);
    }
        private function addFileToZip($path, $zip)
    {
        $handler = opendir($path); //打开当前文件夹由$path指定。
        while (($filename = readdir($handler)) !== false) {
            if ($filename != "." && $filename != "..") {//文件夹文件名字为'.'和‘..'，不要对他们进行操作
                if (is_dir($path . "/" . $filename)) {// 如果读取的某个对象是文件夹，则递归
                    $this->addFileToZip($path . "/" . $filename, $zip);
                } else { //将文件加入zip对象
                    $zip->addFile($path . "/" . $filename, $filename);
                }
            }
        }
        @closedir($path);
    }
    //下载压缩包
    public function ces()
    {
        $directory_name = I('get.directory_name');
        $zip = new \ZipArchive();
        $dir = ltrim($directory_name, './');
        $arr = explode('/', $dir);
        unset($arr[count($arr) - 1]);
        $zipName = implode('/', $arr);
        $url = $directory_name . '.zip';
        if ($zip->open($url, \ZipArchive::CREATE) === TRUE) {
            $this->addFileToZip($dir, $zip); //调用方法，对要打包的根目录进行操作，并将ZipArchive的对象传递给方法
            $zip->close(); //关闭处理的zip文件
            if (!file_exists($url)) {  //判断文件是否存在
                echo "文件不存在";
                exit();
            }
            $file = fopen($url, "r");
            Header("Content-type:application/octet-stream");
            header("Accept-Ranges: bytes");
            header("Accept-Length: " . filesize($url));
            header("Content-Disposition: attachment; filename=采购单" . date('Y-m-d_H:i:s') . ".zip");
            echo fread($file, filesize($url));
            fclose($file);
        }
    }