<?php

namespace App\Filament\Resources\Cashboxes\Tables;

use Filament\Actions\BulkActionGroup;
use Filament\Actions\DeleteBulkAction;
use Filament\Actions\EditAction;
use Filament\Actions\DeleteAction;
use Filament\Tables\Columns\IconColumn;
use Filament\Tables\Columns\TextColumn;
use Filament\Tables\Columns\Summarizers\Summarizer;
use Filament\Tables\Table;
use Illuminate\Database\Query\Builder;

class CashboxesTable
{
    public static function configure(Table $table): Table
    {
        return $table
            ->columns([
                TextColumn::make('name')
                    ->label(__('filament/admin/cashbox_resource.name'))
                    ->searchable()
                    ->sortable(),
                TextColumn::make('currency')
                    ->label(__('filament/admin/cashbox_resource.currency'))
                    ->searchable()
                    ->toggleable(isToggledHiddenByDefault: false),
                TextColumn::make('opening_balance')
                    ->label(__('filament/admin/cashbox_resource.opening_balance'))
                    ->money('EGP')
                    ->sortable()
                    ->summarize([
                        \Filament\Tables\Columns\Summarizers\Sum::make()
                            ->label(__('filament/admin/cashbox_resource.total_opening')),
                    ]),
                TextColumn::make('total_deposits')
                    ->label('إجمالي الإيداعات')
                    ->money('EGP')
                    ->state(fn($record) => $record->total_deposits)
                    ->summarize(
                        Summarizer::make()
                            ->label('إجمالي الإيداعات')
                            ->using(fn($query) => \App\Models\Cashbox::all()->sum('total_deposits'))
                    ),
                TextColumn::make('total_withdrawals')
                    ->label('إجمالي المصروفات')
                    ->money('EGP')
                    ->state(fn($record) => $record->total_withdrawals)
                    ->summarize(
                        Summarizer::make()
                            ->label('إجمالي المصروفات')
                            ->using(fn($query) => \App\Models\Cashbox::all()->sum('total_withdrawals'))
                    ),
                TextColumn::make('calculated_current_balance')
                    ->label(__('filament/admin/cashbox_resource.current_balance'))
                    ->money('EGP')
                    ->state(fn($record) => $record->calculated_current_balance)
                    ->summarize(
                        Summarizer::make()
                            ->label('إجمالي الرصيد')
                            ->using(fn($query) => \App\Models\Cashbox::all()->sum('calculated_current_balance'))
                    ),
                IconColumn::make('is_active')
                    ->label(__('filament/admin/cashbox_resource.is_active'))
                    ->boolean()
                    ->sortable(),
                TextColumn::make('created_at')
                    ->label(__('filament/admin/cashbox_resource.created_at'))
                    ->dateTime()
                    ->sortable()
                    ->toggleable(isToggledHiddenByDefault: true),
                TextColumn::make('updated_at')
                    ->label(__('filament/admin/cashbox_resource.updated_at'))
                    ->dateTime()
                    ->sortable()
                    ->toggleable(isToggledHiddenByDefault: true),
            ])
            ->filters([
                //
            ])
            ->recordActions([
                EditAction::make(),
                DeleteAction::make()
                    ->requiresConfirmation(),
            ])
            ->toolbarActions([
                BulkActionGroup::make([
                    DeleteBulkAction::make(),
                ]),
            ]);
    }
}