34 lines
718 B
PHP
34 lines
718 B
PHP
<?php
|
|
|
|
namespace App\Exports;
|
|
|
|
|
|
use Maatwebsite\Excel\Concerns\FromCollection;
|
|
use Spatie\Permission\Models\Role;
|
|
|
|
class RolesExport implements FromCollection
|
|
{
|
|
|
|
protected $filters;
|
|
|
|
public function __construct($filters = [])
|
|
{
|
|
$this->filters = $filters;
|
|
}
|
|
|
|
/**
|
|
* @return \Illuminate\Support\Collection
|
|
*/
|
|
public function collection()
|
|
{
|
|
return Role::when(isset($request->search) , function ($query){
|
|
$query->where(function ($q) {
|
|
$q->where('name', 'LIKE', "%{$this->filters['search']}%")
|
|
->orWhere('label','LIKE', "%{$this->filters['search']}%");
|
|
});
|
|
})
|
|
->latest()
|
|
->get();
|
|
}
|
|
}
|