hyperf 导出csv

CSV导出类

<?php
declare(strict_types=1);
/**
 * Created by PhpStorm.
 * User: xky
 * Date: 2020/7/28
 * Time: 10:24
 */

namespace App\Service;

use Hyperf\HttpMessage\Stream\SwooleStream;
use Hyperf\HttpServer\Response;

/**
 * csv导出
 * Class CSV
 * @package App\Service
 */
class CSV
{
    static function export(array $head,array $body,string $file_name)
    {
        $head_keys = array_keys($head);
        $head_values = array_values($head);
        $fileData = self::utfToGbk(implode(',',$head_values)) . "\n";

        if(strpos($file_name,'.') === false){
            $file_name .= '.csv';
        }

        foreach ($body as $value) {
            $temp_arr = [];
            foreach($head_keys as $key){
                $temp_arr[] = $value[$key] ?? '';
            }
            $fileData .= self::utfToGbk(implode(',',$temp_arr)) . "\n";
        }

        $response = new Response();
        $content_type = 'text/csv';
        return $response->withHeader('content-description', 'File Transfer')
            ->withHeader('content-type', $content_type)
            ->withHeader('content-disposition', "attachment; filename={$file_name}")
            ->withHeader('content-transfer-encoding', 'binary')
            ->withHeader('pragma', 'public')
            ->withBody(new SwooleStream($fileData));
    }

    /**
     * 字符转换(utf-8 => GBK)
     * @param $data
     * @return false|string
     */
    static function utfToGbk($data)
    {
        return iconv('utf-8', 'GBK', $data);
    }

}

控制器使用:

        $head = ['names'=>'名字','score'=>'得分'];
        $data = [
            ['name' => '张三', 'score' => '80'],
            ['name' => '李四', 'score' => '90'],
            ['name' => '王五', 'score' => '60'],
        ];

        return CSV::export($head,$data,'测试.csv');

 

  • 2
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值