ExportAsCsv quietly strips out dates and enums, no casting, no errors

[philsturgeon]

• Laravel Version: 10.37.3
• Nova Version: 4.32.10
• PHP Version: 8.2.13
• Database Driver & Version: image: 'mysql:8.0.28-oracle'
• Operating System and Version: sail-8.2/app
• Browser type and version: #.#
• Reproduction Repository:

Description:

I'm working with QueuedExportAsCsv which is an extension of ExportAsCsv and I believe the issue to be there as I've seen a few others truggling with this. I have a Nova resource using withFormat, and strangely only some of the fields are showing up in that CSV.

    public function actions(NovaRequest $request): array
    {
        return [
            QueuedExportAsCsv::make()
                ->withStorageDisk(env('FILESYSTEM_DISK'))
                ->withFormat(function (\Illuminate\Database\Eloquent\Model $model) {
                    return [
                        'ID' => $model->uuid,
                        'Unit Type' => $model->unit_type,
                        'Latitude' => $model->coordinates->latitude,
                        'Longitude' => $model->coordinates->longitude,
                        'What3Words' => $model->three_words,
                        'Site' => $model->site->name,
                        'Species' => $model->specie?->name,
                        'Planted On' => $model->planted_on,
                        'Created At' => $model->created_at,
                        'Updated At' => $model->updated_at,
                    ];
                })
        ];
    }

That produces this:

The complicated fields made it, with lat/lion being a MySQL GIS POINT() so if that was ok I am confused about what could be making the other fieldsd not show up. I tried with and without spaces and caps but the docs suggest that shouldnt matter anyhow.

Detailed steps to reproduce the issue on a fresh Nova installation:

Nova Resource

<?php

namespace App\Nova;

use App\Models\Enums\UnitType;
use App\Nova\Fields\PartOfPointField;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Storage;
use Intervention\Image\Facades\Image as InverventionImage;
use Laravel\Nova\Fields\BelongsTo;
use Laravel\Nova\Fields\Date;
use Laravel\Nova\Fields\DateTime;
use Laravel\Nova\Fields\ID;
use Laravel\Nova\Fields\Image;
use Laravel\Nova\Fields\Select;
use Laravel\Nova\Fields\Text;
use Laravel\Nova\Http\Requests\NovaRequest;
use NovaKit\NovaQueuedExportAsCsv\Actions\QueuedExportAsCsv;

class Unit extends Resource
{
    /**
     * The model the resource corresponds to.
     *
     * @var string
     */
    public static $model = \App\Models\Unit::class;

    /**
     * The single value that should be used to represent the resource when being displayed.
     *
     * @var string
     */
    public static $title = 'id';

    /**
     * The columns that should be searched.
     *
     * @var array
     */
    public static $search = [
        'id',
        'three_words',
        'external_id',
    ];

    public static $with = [
        'order.organization',
    ];

    /**
     * Get the fields displayed by the resource.
     */
    public function fields(NovaRequest $request): array
    {
        return [
            ID::make()->sortable(),

            Text::make('UUID')
                ->required()
                ->onlyOnDetail(),

            Select::make('Unit Type')
                ->required()
                ->filterable()
                ->displayUsingLabels()
                ->options([
                    UnitType::Tree->value => UnitType::Tree->name,
                    UnitType::Biodiversity->value => UnitType::Biodiversity->name,
                    UnitType::Hedgerow->value => UnitType::Hedgerow->name,
                ]),

            Image::make('Photo', 'photo_path')
                ->path('/tmp')
                ->prunable(),

            PartOfPointField::make('Latitude', 'coordinates', 'latitude')
                ->step('0.000001')
                ->onlyOnForms()
                ->rules('required'),

            PartOfPointField::make('Longitude', 'coordinates', 'longitude')
                ->step('0.000001')
                ->onlyOnForms()
                ->rules('required'),

            Text::make('Coordinates', fn () => $this->coordinates ? sprintf('%s, %s', $this->coordinates->latitude, $this->coordinates->longitude) : null)
                ->onlyOnDetail()
                ->rules('required'),

            Text::make('What3Words', 'three_words')
                ->rules('required'),

            BelongsTo::make('Species', 'specie')
                ->sortable()
                ->filterable()
                ->nullable(),

            BelongsTo::make('Site')
                ->sortable()
                ->filterable()
                ->rules('required'),

            BelongsTo::make('Supervisor')
                ->sortable()
                ->filterable()
                ->rules('required'),

            Date::make('Planted On')
                ->sortable()
                ->filterable()
                ->onlyOnIndex(),

            Date::make('Created At')
                ->sortable()
                ->filterable()
                ->onlyOnIndex(),

            Date::make('Updated At')
                ->sortable()
                ->filterable()
                ->onlyOnIndex(),

            DateTime::make('Planted On')
                ->sortable()
                ->filterable()
                ->onlyOnDetail(),

            DateTime::make('Created At')
                ->sortable()
                ->filterable()
                ->onlyOnDetail(),

            DateTime::make('Updated At')
                ->sortable()
                ->filterable()
                ->onlyOnDetail(),
        ];
    }

    /**
     * Get the cards available for the request.
     */
    public function cards(NovaRequest $request): array
    {
        return [];
    }

    /**
     * Get the filters available for the resource.
     */
    public function filters(NovaRequest $request): array
    {
        return [];
    }

    /**
     * Get the lenses available for the resource.
     */
    public function lenses(NovaRequest $request): array
    {
        return [];
    }

    /**
     * Get the actions available for the resource.
     */
    public function actions(NovaRequest $request): array
    {
        return [
            QueuedExportAsCsv::make()
                ->withStorageDisk(env('FILESYSTEM_DISK'))
                ->withFormat(function (\Illuminate\Database\Eloquent\Model $model) {
                    return [
                        'ID' => $model->uuid,
                        'Unit Type' => $model->unit_type,
                        'Latitude' => $model->coordinates->latitude,
                        'Longitude' => $model->coordinates->longitude,
                        'What3Words' => $model->three_words,
                        'Site' => $model->site->name,
                        'Species' => $model->specie?->name,
                        'Planted On' => $model->planted_on,
                        'Created At' => $model->created_at,
                        'Updated At' => $model->updated_at,
                    ];
                })
        ];
    }

}

Model

<?php

namespace App\Models;

use App\Models\Enums\UnitType;
use App\Support\HasUuids;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use MatanYadaev\EloquentSpatial\Objects\Point;
use MatanYadaev\EloquentSpatial\Traits\HasSpatial;

class Unit extends Model
{
    use HasFactory;
    use HasUuids;
    use HasSpatial;

    protected $attributes = [
        'three_words' => '',
    ];

    protected $casts = [
        'last_imported_at' => 'datetime',
        'planted_on' => 'datetime',
        'three_words' => 'string',
        'coordinates' => Point::class,
        'unit_type' => UnitType::class,
    ];

    protected $with = [
        'specie',
        'site',
        'order',
    ];

    public function specie()
    {
        return $this->belongsTo(Specie::class, 'species_id');
    }

    public function site()
    {
        return $this->belongsTo(Site::class);
    }

}

Schema

CREATE TABLE `units` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `species_id` bigint unsigned DEFAULT NULL,
  `site_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `planted_on` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `coordinates` point DEFAULT NULL,
  `three_words` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_type` enum('tree','biodiversity','hedgerow') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Oh yay figured it out half way through writing the issue, its things which arent actually strings:

                ->withFormat(function (\Illuminate\Database\Eloquent\Model $model) {
                    return [
                        'ID' => $model->uuid,
                        'Unit Type' => $model->unit_type->value,
                        'Latitude' => $model->coordinates->latitude,
                        'Longitude' => $model->coordinates->longitude,
                        'What3Words' => $model->three_words,
                        'Site' => $model->site->name,
                        'Species' => $model->specie?->name,
                        'Planted On' => (string) $model->planted_on->format('Y-m-d'),
                        'Created At' => (string) $model->created_at,
                        'Updated At' => (string) $model->updated_at,
                    ];
                })

Unit Type was an enum, so I had to pull the value. Dates were all objects and sileltnly being yoinked out, so either format or cast as string, either work.

This might need a bit more documentation, or could throw errors/warnings or something?