use Acun\Ui\DataTable\DataTable;

final class OrdersTable extends DataTable
{
    public string $title = 'Orders';

    protected function query(): Builder
    {
        return Order::query()->visibleTo(auth()->user())->select(['id', 'number', 'customer_name', 'is_paid']);
    }

    protected function columns(): array
    {
        return [
            Column::make('Order no.', 'number')->searchable()->sortable(),
            Column::make('Customer', 'customer_name')->searchable(SearchMode::Contains)->sortable(),
            Column::make('Paid', 'is_paid')->boolean(),
        ];
    }

    protected function authorizeTable(): void
    {
        $this->authorize('viewAny', Order::class);
    }
}

Column::make('Amount', 'total')->money('TRY')->align('right')->width('140px');
Column::make('Quantity', 'quantity')->number()->align('center');
Column::make('Delivery date', 'delivered_on')->date()->sortable()->priority(3);
Column::make('Created', 'created_at')->dateTime()->hidden();
Column::make('Customer', 'customer.name')->nowrap();
Column::make('Agent', 'agent_id')->renderUsing(fn ($row, $value) => $row->agent?->full_name ?? '—');
Column::make('Status', 'is_active')->view('tables.cells.status');

Column::make('Tax number', 'tax_number')->searchable(SearchMode::Exact);
Column::make('Code', 'custom_code')->searchable();                       // Prefix (default)
Column::make('Address', 'address')->searchable(SearchMode::Contains);
Column::make('Full name', 'first_name')->searchable('contains', column: 'full_name_search');

protected function searchFields(): array
{
    return [...parent::searchFields(), SearchField::make('email')];
}

protected function filters(): array
{
    return [
        Filter::select('Status', 'is_active')->options(['1' => 'Active', '0' => 'Inactive']),
        Filter::multiSelect('Region', 'region')->options(['east' => 'East', 'west' => 'West']),
        Filter::dateRange('Delivery date', 'delivered_on'),
        Filter::numberRange('Amount', 'total'),
        Filter::boolean('Gift wrapped', 'is_gift'),
        Filter::text('Customer', 'customer')
            ->applyUsing(fn (Builder $query, string $value) => $query->whereHas('customer', fn ($q) => $q->where('name', 'like', "%{$value}%"))),
    ];
}

protected function filters(): array
{
    return [
        Filter::select('Status', 'is_active')->options(['1' => 'Active', '0' => 'Inactive'])->inToolbar(),
        Filter::multiSelect('Region', 'region')->options(['east' => 'East', 'west' => 'West', 'south' => 'South'])->inToolbar(),
        Filter::dateRange('Delivery date', 'delivered_on'),   // stays in the panel
    ];
}

protected function actions(): array
{
    return [
        Action::make('Edit')
            ->icon('pencil-square')
            ->authorize(fn (Order $order) => auth()->user()->can('update', $order))
            ->action(fn (Order $order) => $this->redirectRoute('orders.edit', $order)),

        Action::make('Delete')
            ->icon('trash')
            ->style('danger')
            ->visible(fn (Order $order) => $order->isCancelled())
            ->authorize(fn (Order $order) => auth()->user()->can('delete', $order))
            ->action(fn (Order $order) => $order->delete()),
    ];
}

protected function bulkActions(): array
{
    return [
        BulkAction::make('Mark as shipped')
            ->icon('truck')
            ->authorize(fn () => auth()->user()->can('updateAny', Order::class))
            ->action(fn (Builder $query) => $query->update(['status' => OrderStatus::Shipped])),

        BulkAction::make('Delete')
            ->icon('trash')
            ->style('danger')
            ->authorize(fn () => auth()->user()->can('deleteAny', Order::class))
            ->authorizeRow(fn (Order $order) => auth()->user()->can('delete', $order))
            ->action(fn (Builder $query) => $query->delete()),
    ];
}

use Acun\Ui\DataTable\Actions\ExportAction;
use Acun\Ui\DataTable\Actions\TableAction;
use Acun\Ui\DataTable\Actions\UtilityAction;

protected function headerActions(): array
{
    return [
        TableAction::make('create')->label('New order')->icon('plus')
            ->url(fn () => route('orders.create'))
            ->can('create', Order::class)
            ->shortcut('mod+shift+n'),

        TableAction::make('sync')->label('Sync')->icon('arrow-path')->color('gray')
            ->action('syncOrders')                   // protected function syncOrders(): void
            ->confirm('Sync the orders?')
            ->loadingLabel('Syncing…')
            ->successMessage('Orders updated.'),
    ];
}

protected function exportActions(): array
{
    return [
        ExportAction::csv()->shortcut('mod+e'),
        ExportAction::pdf(),        // the print page → "Save as PDF" in the browser
        ExportAction::json()->can('export-json'),
        ExportAction::print(),
        ExportAction::copy(),       // current page or selection, as tab-separated text
    ];
}

protected function utilityActions(): array
{
    return [
        UtilityAction::refresh(),
        UtilityAction::columns(),
        UtilityAction::fullscreen(),
        UtilityAction::resetFilters(),
        UtilityAction::resetSorting(),
    ];
}

protected function defaultSort(): ?array
{
    return ['field' => 'created_at', 'direction' => 'desc'];
}

Column::make('Amount', 'amount')->money('TRY')->exportUsing(fn (Order $order) => $order->amount);
Column::make('Map', 'location')->view('cells.map')->exportable(false);
Column::make('Code', 'custom_code')->toggleable(false);     // cannot be hidden from the Columns menu

// Your own format: Contracts\ExportDriver (extension, mimeType, write)
ExportAction::make('xml')->label('XML')->icon('code-bracket')->driver(XmlExportDriver::class);

// Eager load relations into the export query
protected function exportQuery(ExportScope $scope): Builder
{
    return parent::exportQuery($scope)->with('customer');
}

use Acun\Ui\DataTable\Actions\BulkAction;
use Acun\Ui\DataTable\Actions\RowAction;

protected function bulkActions(): array
{
    return [
        BulkAction::make('ship')->label('Mark as shipped')->icon('truck')
            ->action(fn (Builder $query) => $query->update(['status' => OrderStatus::Shipped]))
            ->successMessage(':count orders marked as shipped.'),
        BulkAction::exportSelected('csv'),
        BulkAction::printSelected(),
        BulkAction::delete()->authorizeRow(fn (Order $order) => auth()->user()->can('delete', $order)),
    ];
}

protected function actions(): array
{
    return [
        RowAction::view(fn (Order $order) => route('orders.show', $order)),
        RowAction::edit(fn (Order $order) => route('orders.edit', $order))->can('update'),
        RowAction::make('archive')->label('Archive')->icon('archive-box')
            ->visible(fn (Order $order) => ! $order->isArchived())
            ->action(fn (Order $order) => $order->archive()),
        RowAction::delete()->can('delete'),
    ];
}

protected function emptyState(): array
{
    return $this->search !== '' || $this->activeFilterCount() > 0
        ? ['title' => 'No matching orders.', 'description' => 'Change the search or the filters.']
        : ['title' => 'No orders yet.', 'description' => 'Create the first order with the New order button.'];
}

final class BasicOrdersTable extends DataTable
{
    protected function query(): Builder
    {
        return Order::query();
    }

    protected function columns(): array
    {
        return [
            Column::make('Order no.', 'number')->searchable()->sortable(),
            Column::make('Customer', 'customer_name')->searchable('contains')->sortable(),
            Column::make('Amount', 'amount')->money('TRY')->align('right')->sortable(),
            Column::make('Order date', 'ordered_at')->dateTime()->sortable(),
        ];
    }
}

protected function columns(): array
{
    return [
        Column::make('Order no.', 'number')->sortable(),
        Column::make('Customer', 'customer_name'),
        Column::make('Status', 'status')->view('tables.cells.order-status')->priority(3),
        Column::make('Product', 'product')->priority(4),
        Column::make('City', 'city')->priority(4),
    ];
}

protected function rowDetails(): ?string
{
    return 'responsive';
}

protected function scrollX(): bool
{
    return true;
}

protected function scrollY(): ?string
{
    return '400px';   // '28rem', 'min(70vh, 42rem)' …
}

protected function query(): Builder
{
    return Order::query();   // search, filters, sorting and pagination are added to this
}

protected function filters(): array
{
    return [
        Filter::multiSelect('Status', 'status')->options(OrderStatus::options())->inToolbar(),
        Filter::dateRange('Order date', 'ordered_at'),
    ];
}

protected function fixedHeader(): bool
{
    return true;
}

protected function fixedColumns(): array
{
    return ['start' => 1, 'end' => true];
}

protected function scrollX(): bool
{
    return true;
}

protected function exportActions(): array
{
    return [ExportAction::csv(), ExportAction::pdf(), ExportAction::json(), ExportAction::print(), ExportAction::copy()];
}

protected function utilityActions(): array
{
    return [UtilityAction::refresh(), UtilityAction::columns()];
}

return [
    'datatable' => [
        'per_page' => [10, 25, 50, 100],
        'default_per_page' => 25,
        'search_debounce' => 400,      // ms
        'url_state' => true,           // search, sorting, filters, columns in the URL
        'sticky_header' => false,      // true: scrollY('min(70vh, 42rem)') on every table; per table, $stickyHeader
        'pagination' => 'paginate',    // paginate · simple · cursor

        'actions' => ['enabled' => true],
        'exports' => [
            'enabled' => true,
            'queue_threshold' => 5000,  // above this, a queued job
            'chunk_size' => 1000,
            'disk' => 'local',
            'directory' => 'exports',
            'queue' => null,
            'connection' => null,
            'expire_minutes' => 60,     // lifetime of the download link
            'poll_seconds' => 3,
            'cache_store' => null,      // cache shared with the worker
            'csv_delimiter' => ';',
            'copy_max_rows' => 1000,
        ],
        'print' => ['layout' => 'acun-ui-pro::components.data-table.print', 'max_rows' => 2000],   // PDF opens this page too
        'density' => ['default' => 'normal'],   // compact · normal · comfortable; a table changes it with density()
        'columns' => ['persist' => 'none'],                           // none · session
        'routes' => ['middleware' => ['web', 'auth'], 'prefix' => 'acun-ui/data-table'],
    ],
];