Filament page filter

[hazy burrow]

I have this code where I have tried to pass date filter in my filament page. I made one similar type of report few months ago which works with this similar approad but this one is not working. Even when I pass the date filter the data is not changing in the view but the date is passing through.

https://gist.github.com/Namrata199/b913be06177c0b1317d334180e3826ce

[thin hare]

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

[dire trout]

Use mount instead of construct

https://laravel-livewire.com/docs/2.x/lifecycle-hooks#class-hooks

[hazy burrow]

I used mount but it did not work. The problem is the data doesnot change even when I apply the date filter

[dire trout]

->modifyQueryUsing(fn () => $this->apiData)

?

[hazy burrow]

where do i do this ?

  protected function getTableQuery(): Builder
    {
        return Product::where('active', true)->publicDisplay()
            ->orderBy('orders_count', 'desc')->modifyQueryUsing(fn () => $this->apiData);
    }

this gives error

[dire trout]

are you using Filament v3?

[hazy burrow]

yes

[dire trout]

https://filamentphp.com/docs/3.x/tables/adding-a-table-to-a-livewire-component#adding-the-table

public function table(Table $table): Table
{
    return $table
        ->query(Product::query())
        ->modifyQueryUsing(fn () => $this->apiData)
        ...;
}

[hazy burrow]

Thanks a lot this solved the data issue but since I am returning a collection,

 private function getData($startDate, $endDate)
    {
        $cartItems = CartItem::where('order_id', '<>', 0)->where('created_at', '>=', $startDate)
            ->where('created_at', '<=', $endDate)
            ->selectRaw('product_id, count(*) as orders_count')
            ->groupBy('product_id')
            ->orderBy('orders_count', 'desc')
            ->get();

        return $cartItems->map(function ($cartItem) {
            return [
                'name' => $cartItem->product->name,
                'orders_count' => $cartItem->orders_count,
            ];
        });
    }

here the table part crashes.

[dire trout]

you can't
https://filamentphp.com/docs/3.x/support/overview#eloquent-models

[hazy burrow]

so there is no way ti get the data I want ? with my query ?

[dire trout]

If it returns an Eloquent Builder, it will work

[hazy burrow]

I changed it to retrun this

   private function getData($startDate, $endDate)
    {
        $cartItemsQuery = CartItem::where('order_id', '<>', 0)
            ->where('created_at', '>=', $startDate)
            ->where('created_at', '<=', $endDate)
            ->selectRaw('product_id, count(*) as orders_count')
            ->groupBy('product_id')
            ->orderBy('orders_count', 'desc');

        return $cartItemsQuery;
    }

[dire trout]

try product_id as id in the select

[hazy burrow]

gives this

[dire trout]

share the whole code

[hazy burrow]

public function table(Table $table)
    {
        return $table
            ->query(Product::query()->where('active', true)->publicDisplay())
            ->modifyQueryUsing(fn () => $this->apiData)
            ->columns([
                TextColumn::make('name'),
                TextColumn::make('orders_count'),
            ])->defaultSort('orders_count', 'desc')
            ->filters([
                Filter::make('filters')
                    ->form(
                        [
                            DatePicker::make('start_at')->default(now()),
                            DatePicker::make('end_at')->default(now()),
                        ]
                    )->columns(2)
                    ->columnSpan(2)
            ], \Filament\Tables\Enums\FiltersLayout::AboveContent)
            ->actions([
                // ...
            ])
            ->bulkActions([
                // ...
            ]);
    }

    public function updated($name): void
    {
        if (Str::of($name)->contains('tableFilters.filters')) {

            $startDate = data_get($this->tableFilters, 'filters.start_at');
            $endDate = data_get($this->tableFilters, 'filters.end_at');

            $this->apiData = $this->getData($startDate, $endDate);
        }
    }

    private function getData($startDate, $endDate)
    {
        $cartItemsQuery = CartItem::where('order_id', '<>', 0)
            ->where('created_at', '>=', $startDate)
            ->where('created_at', '<=', $endDate)
            ->selectRaw('product_id as id, count(*) as orders_count')
            ->groupBy('product_id')
            ->orderBy('orders_count', 'desc');

        return $cartItemsQuery;
    }

[dire trout]

try to share the whole code in gist please

[hazy burrow]

https://gist.github.com/Namrata199/b913be06177c0b1317d334180e3826ce this is the updated gist with my latest code

[dire trout]

try private $apiData = null;

[hazy burrow]

This worked !! thanks a lot !! Really appreciate this !!

[thin hare]

Thank you for marking this question as solved!

Learn more

https://answeroverflow.com