Exportable.php

<?php

namespace App\Traits;

use App\Exports\ExcelExport;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Facades\Excel;

trait Exportable
{
    public string $exportExtension = '.xlsx';

    public function whenExport(): bool
    {
        if (request()->has('export_excel') && request('export_excel') == "pdf" ){
            $this->exportExtension = '.pdf';
        }
        return request('export_excel') ?? false;
    }

    public function handleCollectionExport(Collection $collection, array $fields, object $model)
    {
        return Excel::download(
            new ExcelExport($collection, $fields),
            $this->getExportFileNameFormat(class_basename($model), NULL),
            $this->getExportFormat()
        );
    }

    public function handleExport(Builder $queryBuilder, array $fields, string $export_file_name = NULL)
    {
        return Excel::download(
            new ExcelExport($queryBuilder->get(), $fields),
            $this->getExportFileNameFormat(class_basename($queryBuilder->getModel()), $export_file_name),
            $this->getExportFormat()
        );
    }

    protected function getExportFileNameFormat(string $class_basename, ?string $export_file_name): string
    {
        $fileName = $export_file_name ?? $class_basename . 's_' . today()->format('Y-m-d');

        $fileName .= $this->exportExtension;

        return $fileName;
    }

    protected function getExportFormat(){
        return $this->exportExtension == '.pdf' ? \Maatwebsite\Excel\Excel::DOMPDF : \Maatwebsite\Excel\Excel::XLSX;
    }
}