Zero effort export to csv for Eloquent models

Exportable.php

<?php

namespace App\Traits;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Str;
use ReflectionClass;

trait Exportable
{
    protected ?array $exportRows = null;

    protected array $exportTypes = ["bigint", "boolean", "date", "datetime", "decimal", "float", "guid", "integer",
        "smallint", "string"];

    public function toCsv()
    {
        $file = fopen(storage_path($this->getCsvFilename()), 'wb');

        fputcsv($file, $this->getExportKeys());

        $this->getExportQuery()->get()->each(fn($record) => fputcsv($file, $record->toArray()));

        fclose($file);
    }

    public function getExportQuery()
    {
        return static::query()->without($this->with)->select($this->getExportKeys());
    }

    public function getExportKeys(): array
    {
        if ($this->exportRows !== null) {
            return $this->exportRows;
        }

        $keys = [];

        foreach (array_keys(static::without($this->with)->first()->toArray()) as $col) {
            if (in_array(DB::getSchemaBuilder()->getColumnType($this->getTable(), $col), $this->exportTypes)) {
                $keys[] = $col;
            }
        }

        return $keys;
    }

    public function getCsvFilename(): string
    {
        return Str::plural((new ReflectionClass($this))->getShortName()) . ' ' . now()->format('Y-m-d') . '.csv';
    }
}