<?php

namespace Workbench\App\Livewire;

use Workbench\App\Models\Product;
use Workbench\App\Models\Category;

use Lightscale\LaralightTables\Columns\Column;
use Lightscale\LaralightTables\Toolbar;
use Lightscale\LaralightTables\Toolbar\Search;
use Lightscale\LaralightTables\Toolbar\PageSize;
use Lightscale\LaralightTables\Toolbar\ColumnSelect;
use Lightscale\LaralightTables\Toolbar\SelectFilter;

use Illuminate\Database\Eloquent\Builder;

class ProductsTable extends Table
{
    protected $model = Product::class;

    public function toolbar(): Toolbar
    {
        $categoryFilter = SelectFilter::make('category')
            ->placeholder(__('Filter category'))
            ->options(Category::pluck('name', 'id'))
            ->filter(
                fn(Builder $q, string $value) => $q->whereHas(
                    'category',
                    fn(Builder $q) => $q->where('id', $value)
                )
            );

        return parent::toolbar()
            ->appendStartItem(Search::make())
            ->appendStartItem($categoryFilter)
            ->appendEndItem(PageSize::make())
            ->appendEndItem(ColumnSelect::make());
    }

    public function query(): Builder
    {
        return parent::query()
            ->with('category');
    }

    protected function search(Builder $q, string $s): void
    {
        $q->search($s);
    }

    public function columns(): array
    {
        return [
            Column::make('id', 'ID')
                ->sortable(fn(Builder $q, string $dir) => $q->orderBy('id', $dir)),
            Column::make('name', 'Name')
                ->sortable(fn(Builder $q, string $dir) => $q->orderBy('name', $dir)),
            Column::make('category_name', 'Category')
                ->slot(fn($r) => $r->category->name),
            Column::make('price', 'Price')
                ->sortable(fn(Builder $q, string $dir) => $q->orderBy('price', $dir))
                ->slot(fn($r, $c) => "£{$r->{$c->name}}"),
            Column::make('stock', 'Stock')
                ->sortable(fn(Builder $q, string $dir) => $q->orderBy('stock', $dir)),
        ];
    }
}