laravel Maatwebsite3.1

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromCollection;

use Maatwebsite\Excel\Concerns\Exportable;

use Maatwebsite\Excel\Concerns\WithEvents;

use Maatwebsite\Excel\Concerns\WithHeadings;

use Maatwebsite\Excel\Events\AfterSheet;

class UserExport implements FromCollection, WithHeadings, WithEvents

{

use Exportable;

 

private $data;

private $headings;

//数据注入

public function __construct($data, $headings)

{

$this->data = $data;

$this->headings = $headings;

}

//实现FromCollection接口

public function collection()

{

return collect($this->data);

}

//实现WithHeadings接口

public function headings(): array

{

return $this->headings;

}

public function registerEvents(): array

{

return [

AfterSheet::class => function (AfterSheet $sheet) {

$sheet->getDelegate()->getColumnDimension('A')->setWidth(20);

$sheet->getDelegate()->getColumnDimension('B')->setWidth(20);

$sheet->getDelegate()->getColumnDimension('C')->setWidth(20);

$sheet->getDelegate()->getColumnDimension('D')->setWidth(20);

$sheet->getDelegate()->getColumnDimension('E')->setWidth(20);

$sheet->getDelegate()->getColumnDimension('F')->setWidth(20);

$sheet->getDelegate()->getColumnDimension('G')->setWidth(20);

$sheet->getDelegate()->getColumnDimension('H')->setWidth(20);

$sheet->getDelegate()->getColumnDimension('I')->setWidth(20);

}

];

}

}

 

//控制器

<?php

namespace App\Http\Controllers\Admin;

use Validator;

use Illuminate\Http\Request;

use App\Http\Controllers\Controller;

use App\Models\User;

use Maatwebsite\Excel\Facades\Excel;

use App\Exports\UserExport;

class UserController extends Controller

{

public function __construct(User $model)

{

$this->model = $model;

}

 

public function export(Request $request)

{

$search = $request->only('k2', 'keys');

if (!empty($search)) {

if (isset($search['k2']) && $search['k2'] != null) {

$search_time = explode(' - ', $search['k2']);

$this->model = $this->model->whereBetween('created_at', [strtotime($search_time[0]), strtotime($search_time[1])]);

}

if (isset($search['keys']) && $search['keys'] != null) {

$this->model = $this->model->where('uid', 'like', '%' . $search['keys'] . '%')->orWhere('name', 'like', '%' . $search['keys'] . '%')->orWhere('mobile', 'like', '%' . $search['keys'] . '%');

}

}

$data = $this->model->with('userLevel:id,title')->get(['uid', 'name', 'mobile', 'pid', 'level_id', 'shop_money', 'integral', 'commission', 'created_at']);

$array = [];

if ($data->isNotEmpty()) {

foreach ($data as $key => $value) {

$array[$key] = [

'uid' => $value->uid,

'pid' => $value->pid == 0 ? '无推荐人' : User::where('id', $value->pid)->value('uid'),

'name' => $value->name,

'mobile' => $value->mobile,

'level_id' => $value->userLevel->title,

'shop_money' => $value->shop_money,

'integral' => $value->integral,

'commission' => $value->commission,

'created_at' => $value->created_at,

];

}

}

$headings = [

'账号',

'推荐人',

'姓名',

'电话',

'等级',

'余额',

'积分',

'佣金',

'注册',

];

return Excel::download(new UserExport($array, $headings), 'users.xlsx');

}

}

转载于:https://www.cnblogs.com/ssx314/p/11350649.html