laravel-admin 添加Excel导出功能

Laravel  /  管理员 发布于 1年前   1044

laravel-admin 添加Excel导出功能，需要导入功能的文章id174需要的自行搜。

导出功能laravel-admin官方手册上还是写的比较详细的，我这里导出的方法稍作整合了一下，

传入不同的参数导出不同的数据源/表，直接上代码了

laravel-admin手册中介绍有两种方法 (我这里直接用的第二种)

1. 是内置的csv格式文件的导出

2. laravel-Excel
   

安装步骤自行去手册查看，我这里直接贴代码 (我的版本laravel-Excel2.1)

控制器：

//头部use
use App\Admin\Extensions\ExcelExporter;

//grid() 方法中添加导出按钮
$grid->exporter(new ExcelExporter('cardnews'));

导出方法类 (新建自定义导出类路径：app/Admin/Extensions/ExcelExpoter.php)

type = $type;
    }
    //导出方法
    public function export()
    {
        $filename = $this->type.'('.date("Y_m_d_H_i_s",time()).')';

        Excel::create($filename, function($excel) {
            $excel->sheet('Sheet1', function(LaravelExcelWorksheet $sheet) {

                $this->chunk(function ($records) use ($sheet) {
                    $rows = [];
                    //根据不同的参数导出不用的表
                    switch ($this->type){
                        case 'cardnews':
                            $fields = ['id','class','title','subtitle','seotitle','keywords','description','source','tags','bank','content','status','thumb','image','dt'];
                            $rows = $records->map(function ($item) use ($fields) {
                                $item->class = $item->category->title;
                                $item->load('bank');
                                $item->status = $item->status == 0 ? '是' : '否';
                                $item->load('tags');
                                $itemArray = $item->toArray();
                                $itemArray['bank'] = $itemArray['bank']['zt_typename'];
                                $itemArray['tags']= implode(',', array_pluck($itemArray['tags'],'name'));
                                return array_only($itemArray, $fields);
                            });
                            break;
                        case 'loansnews':
                            $fields = ['id','class','title','subtitle','seotitle','keywords','description','source','tags','bank','content','status','thumb','image','dt'];
                            $rows = $records->map(function ($item) use ($fields) {
                                $item->class = $item->category->title;
                                $item->load('bank');
                                $item->status = $item->status == 0 ? '是' : '否';
                                $item->load('tags');
                                $itemArray = $item->toArray();
                                $itemArray['bank'] = $itemArray['bank']['zt_typename'];
                                $itemArray['tags']= implode(',', array_pluck($itemArray['tags'],'name'));
                                return array_only($itemArray, $fields);
                            });
                            break;
                        default:
                            break;
                    }

                    $result = [];
                    foreach($rows as $k=>$v){
                        $arr = [];
                        foreach($fields as $field){
                            $arr[$field] = $v[$field];
                        }
                        $result[] = $arr;
                    }
                    $result = array_prepend($result,$fields);
                    $sheet->rows($result);
                });
            });
        })->export('xlsx');
    }
}