Laravel-admin 自定义导出表单
laravel-admin 自带的导出 excel 会导出与此模型关联的其他数据。所以参考官方文档调整代码
B表:id,user_id,start,start_time[时间戳],address,province,city,district,created_at
A表:id,username
模型
//文章模型关联用户
public function user(){
return $this->belongsTo(User::class, 'user_id', 'id');
}
扩展
//ExcelExporter.php
<?php
namespace App\Admin\Extensions;
use Encore\Admin\Grid;
use Encore\Admin\Grid\Exporters\AbstractExporter;
use Maatwebsite\Excel\Facades\Excel;
class ExcelExpoter extends AbstractExporter
{
protected $head = [];
protected $body = [];
public function setAttr($head, $body){
$this->head = $head;
$this->body = $body;
}
public function export()
{
Excel::create('Filename', function($excel) {
$excel->sheet('Sheetname', function($sheet) {
// 这段逻辑是从表格数据中取出需要导出的字段
$head = $this->head;
$body = $this->body;
$bodyRows = collect($this->getData())->map(function ($item)use($body) {
foreach ($body as $keyName){
switch ($keyName) {
case 'start_time' :
$arr[] = date('Y-m-d H:i:s', array_get($item, $keyName));
break;
case 'start' :
$start = array_get($item, $keyName);
switch ($start) {
case 1 :
$start = "已发布";
break;
default:
$start = "未发布";
break;
}
$arr[] = $start;
break;
case 'address' ://组装多条件
$arr[] = array_get($item, 'province').array_get($item, 'city').array_get($item, 'district').array_get($item, 'address');
break;
case 'province' : break;//过滤掉不处理参数
case 'city' : break;//过滤掉不处理参数
case 'district' : break;//过滤掉不处理参数
default:
$arr[] = array_get($item, $keyName);
break;
}
}
return $arr;
});
$rows = collect([$head])->merge($bodyRows);
$sheet->rows($rows);
});
})->export('xls');//.xls .csv ...
}
}
实例
use App\Admin\Extensions\ExcelExpoter;
.
.
.
$excel = new ExcelExpoter();
$excel->setAttr(['id', '用户','发布时间','时间','状态','详细地址'], ['id', 'user.username','created_at','start_time','start','address']);
$grid->exporter($excel);
本作品采用《CC 协议》,转载必须注明作者和本文链接
推荐文章: