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'),
]);
}