<?php

namespace App\Filament\Widgets;

use Filament\Tables;
use Filament\Tables\Table;
use Filament\Tables\Columns\TextColumn;
use Filament\Tables\Actions\ExportAction;

use Filament\Widgets\TableWidget as BaseWidget;

use Filament\Widgets\Concerns\InteractsWithPageFilters;

use App\Models\UserActivity;
use App\Models\Group;
use App\Models\Activity;

use Illuminate\Support\Facades\DB;

use App\Filament\Exports\GroupsReportExporter;


class GroupsReportTable extends BaseWidget
{

    use InteractsWithPageFilters;

    public function table(Table $table): Table
    {

        $group_id_filter = $this->filters['group_id_filter'] ?? null;
        $activity_id_filter = $this->filters['activity_id_filter'] ?? null;

        if($group_id_filter == null) {
            $group_id_filter = Group::all()->pluck('id')->toArray();
        }

        if($activity_id_filter == null) {
            $activity_id_filter = Activity::all()->pluck('id')->toArray(); 
        }

        return $table
            ->query(Group::query()
                ->select("groups.*",
                         DB::raw("get_group_points(groups.id, '".implode(",", $activity_id_filter)."') AS point")
                        )
                ->whereIn("id", $group_id_filter)
            )
            ->columns([
                TextColumn::make('desc'),
                TextColumn::make('point'),
            ]);
    }
}

<?php

namespace App\Filament\Widgets;

use Filament\Tables;
use Filament\Tables\Table;
use Filament\Tables\Columns\TextColumn;
use Filament\Tables\Actions\ExportAction;

use Filament\Widgets\TableWidget as BaseWidget;

use Filament\Widgets\Concerns\InteractsWithPageFilters;

use App\Models\UserActivity;
use App\Models\Group;
use App\Models\Activity;

use Illuminate\Support\Facades\DB;

use App\Filament\Exports\GroupsReportExporter;


class GroupsReportTable extends BaseWidget
{

    use InteractsWithPageFilters;

    public function table(Table $table): Table
    {

        $group_id_filter = $this->filters['group_id_filter'] ?? null;
        $activity_id_filter = $this->filters['activity_id_filter'] ?? null;

        if($group_id_filter == null) {
            $group_id_filter = Group::all()->pluck('id')->toArray();
        }

        if($activity_id_filter == null) {
            $activity_id_filter = Activity::all()->pluck('id')->toArray(); 
        }

        return $table
            ->query(Group::query()
                ->select("groups.*",
                         DB::raw("get_group_points(groups.id, '".implode(",", $activity_id_filter)."') AS point")
                        )
                ->whereIn("id", $group_id_filter)
            )
            ->columns([
                TextColumn::make('desc'),
                TextColumn::make('point'),
            ]);
    }
}

public function table(Table $table): Table
    {

        $filtro = $this->filters['filtro'] ?? 0;

        return $table
            ->query(UserActivity::query()
                ->join("activity_group", "user_activities.activity_id" ,"=", "activity_group.activity_id")
                ->join("groups", "groups.id" ,"=", "activity_group.group_id")  
                ->select("user_activities.*", "groups.descrizione AS groups_descrizione")             
            )
            ->columns([
                TextColumn::make('id'),
                TextColumn::make('groups_descrizione'),
            ]);
    }

public function table(Table $table): Table
    {

        $filtro = $this->filters['filtro'] ?? 0;

        return $table
            ->query(UserActivity::query()
                ->join("activity_group", "user_activities.activity_id" ,"=", "activity_group.activity_id")
                ->join("groups", "groups.id" ,"=", "activity_group.group_id")  
                ->select("user_activities.*", "groups.descrizione AS groups_descrizione")             
            )
            ->columns([
                TextColumn::make('id'),
                TextColumn::make('groups_descrizione'),
            ]);
    }

<x-filament-panels::page>

    @if (method_exists($this, 'filtersForm'))
        {{ $this->filtersForm }}
    @endif

    @livewire(\App\Filament\Widgets\DemoWidget::class, (property_exists($this, 'filters') ? ['filters' => $this->filters] : []))

</x-filament-panels::page>

<x-filament-panels::page>

    @if (method_exists($this, 'filtersForm'))
        {{ $this->filtersForm }}
    @endif

    @livewire(\App\Filament\Widgets\DemoWidget::class, (property_exists($this, 'filters') ? ['filters' => $this->filters] : []))

</x-filament-panels::page>

<?php

namespace App\Filament\Pages;

//use Filament\Pages\Page;
use Filament\Pages\Dashboard as BaseDashboard;

use Filament\Forms\Form;
use Filament\Forms\Components\TextInput;
use Filament\Forms\Components\Section;

use Filament\Pages\Dashboard\Concerns\HasFiltersForm;

use App\Models\Activity;

class ReportActivities extends BaseDashboard
{
    use HasFiltersForm;

    protected static string $routePath = 'finance';
    
    protected static ?int $navigationSort = 1;
    protected static ?string $navigationIcon = 'heroicon-o-chart-bar';
    protected static ?string $navigationLabel = 'Report Attività - Dashboard';
    protected static ?string $navigationGroup = 'Report';

    //protected static string $view = 'filament.pages.report-activities';

    public function filtersForm(Form $form): Form
    {
        return $form
            ->schema([
                Section::make()
                    ->schema([
                        TextInput::make('test_filtro'),
                    ])
                    ->columns(3),
            ]);
    }
    
}

<?php

namespace App\Filament\Pages;

//use Filament\Pages\Page;
use Filament\Pages\Dashboard as BaseDashboard;

use Filament\Forms\Form;
use Filament\Forms\Components\TextInput;
use Filament\Forms\Components\Section;

use Filament\Pages\Dashboard\Concerns\HasFiltersForm;

use App\Models\Activity;

class ReportActivities extends BaseDashboard
{
    use HasFiltersForm;

    protected static string $routePath = 'finance';
    
    protected static ?int $navigationSort = 1;
    protected static ?string $navigationIcon = 'heroicon-o-chart-bar';
    protected static ?string $navigationLabel = 'Report Attività - Dashboard';
    protected static ?string $navigationGroup = 'Report';

    //protected static string $view = 'filament.pages.report-activities';

    public function filtersForm(Form $form): Form
    {
        return $form
            ->schema([
                Section::make()
                    ->schema([
                        TextInput::make('test_filtro'),
                    ])
                    ->columns(3),
            ]);
    }
    
}