php 封装原生数据导出的方法

    /**
     * 导出数据
     * @return [type] [description]
     */
    public function actionIncome()
    {
        //二维数组简写 例如:$data数据结构
        // [
        //     [
        //         'data'=>'20170501',
        //         'channel_id'=>'1',
        //         'game_id'=>'6',
        //         'fee'=>'10.00',
        //     ]
        //  ]

        $csvData = '日期,渠道id,游戏名称,渠道收入' . "\n";
        foreach ($data as $record) {
            $tmp = array(
                    $record['date'],
                    $record['channel_id'],
                    $record['game_id'],
                    $record['fee'],
                );

            $csvData .= implode(',', $tmp) . "\n";
        }
        $this->exportCsv('渠道充值统计.csv', $csvData);
    }


    /**
     * 导出csv文件
     * @param  [type] $filename [description]
     * @param  [type] $data     [description]
     * @return [type]           [description]
     */
    public  function exportCsv($filename, $data)
    {
        header("Content-type:text/csv");
        header("Content-Disposition:attachment;filename=".$filename);
        header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
        header('Expires:0');
        header('Pragma:public');
        echo iconv("UTF-8", "GBK//TRANSLIT", $data);
        exit();
    }
更多相关文章

随机推荐
