Datasource collection gives error on export.

[akulmehta]

Livewire PowerGrid version

v6.5.3

Livewire version

v3.6.4

Laravel version

v12.24.0

Which PHP version are you using?

PHP 8.4

Which Theme are you using?

Tailwind

Have you published the resource files and customized them? (php artisan vendor:publish)

No

What is the problem?

When creating a table with the datasource of collection and applying the code necessary to export the table as CSV or Excel, the export gives an error of Call to a member function whereIn() on array.

Here is the screenshot of the stacktrace.

Code snippets

I simply created a new PowerGrid table with the datasource of collection, I added the withExport trait and used it as per documentation and it gives me the error.

Here is the file I had:

<?php

namespace App\Livewire;

use Illuminate\Support\Carbon;
use Illuminate\Support\Collection;
use PowerComponents\LivewirePowerGrid\Column;
use PowerComponents\LivewirePowerGrid\PowerGridFields;
use PowerComponents\LivewirePowerGrid\Facades\PowerGrid;
use PowerComponents\LivewirePowerGrid\Traits\WithExport;
use PowerComponents\LivewirePowerGrid\PowerGridComponent;
use PowerComponents\LivewirePowerGrid\Components\SetUp\Exportable;

final class AnalysisResultTable extends PowerGridComponent
{
    use WithExport;

    public string $tableName = 'analysis-result-table-4anhir-table';

    public function datasource(): Collection
    {
        return collect([
            ['id' => 1, 'name' => 'Name 1', 'price' => 1.58, 'created_at' => now(),],
            ['id' => 2, 'name' => 'Name 2', 'price' => 1.68, 'created_at' => now(),],
            ['id' => 3, 'name' => 'Name 3', 'price' => 1.78, 'created_at' => now(),],
            ['id' => 4, 'name' => 'Name 4', 'price' => 1.88, 'created_at' => now(),],
            ['id' => 5, 'name' => 'Name 5', 'price' => 1.98, 'created_at' => now(),],
        ]);
    }

    public function setUp(): array
    {
        $this->showCheckBox();

        return [
            PowerGrid::exportable(fileName: 'analysis-result')
                ->type(Exportable::TYPE_XLS, Exportable::TYPE_CSV),
            PowerGrid::header()
                ->showSearchInput(),
            PowerGrid::footer()
                ->showPerPage()
                ->showRecordCount(),
        ];
    }

    public function fields(): PowerGridFields
    {
        return PowerGrid::fields()
            ->add('id')
            ->add('name')
            ->add('price')
            ->add('created_at_formatted', function ($entry) {
                return Carbon::parse($entry->created_at)->format('d/m/Y');
            });
    }

    public function columns(): array
    {
        return [
            Column::make('ID', 'id')
                ->searchable()
                ->sortable(),

            Column::make('Name', 'name')
                ->searchable()
                ->sortable(),

            Column::make('Price', 'price')
                ->sortable(),

            Column::make('Created', 'created_at_formatted'),

            Column::action('Action')
        ];
    }
}

How do you expect it to work?

I would like to be able to export a table as Excel and CSV for tables which have the datasource of collections.

Please confirm (incomplete submissions will not be addressed)

• I have provided easy and step-by-step instructions to reproduce the bug.
• I have provided code samples as text and NOT images.
• I understand my bug report will be removed if I haven't met the criteria above.

[luanfreitasdev]

Thank you @akulmehta . I've opened a Pull Request for this.

#1971

[akulmehta]

Thanks @luanfreitasdev - I can confirm that this fixes it.

[luanfreitasdev]

https://github.com/Power-Components/livewire-powergrid/releases/tag/v6.5.4