jamesro Comments - Answer Overflow

jamesro

•Created by jamesro on 11/5/2024 in #❓┊help

Custom page with table and filters

seems in order to work so that the filters appear on my url when filters are applied, you need to add this on the page:

protected $queryString = [
        'tableSortColumn',
        'tableSortDirection',
        'tableSearchQuery' => ['except' => ''],
        'tableFilters',
    ];

protected $queryString = [
        'tableSortColumn',
        'tableSortDirection',
        'tableSearchQuery' => ['except' => ''],
        'tableFilters',
    ];

5 replies

FFilament

•Created by jamesro on 11/5/2024 in #❓┊help

Custom page with table and filters

@arnaudsf i do use the filters values in my query, but still, i don't see those filters applied in my browser url as they are normally showing for a resource page

5 replies

FFilament

•Created by lzx1996 on 6/20/2023 in #❓┊help

table builder unable to filter/paginate if using composite primary key

@Dennis Koch is this still not supported?

4 replies

FFilament

•Created by jamesro on 10/17/2024 in #❓┊help

Relation manager with pivot table doesn't show pivot table field values when edit

sorted, change the relation manager form to this:

public function form(Form $form): Form
    {
        return $form
            ->schema([
                Forms\Components\DateTimePicker::make('pivot_data_start')
                    ->label('Data start')
                    ->required(),
                Forms\Components\DateTimePicker::make('pivot_data_end')
                    ->required(),
                Forms\Components\Toggle::make('pivot_disabled')
                    ->mutateDehydratedStateUsing(function ($data) {
                        dd($data);
                    })
                    ->inline(false)
                    ->required(),
            ]);
    }

public function form(Form $form): Form
    {
        return $form
            ->schema([
                Forms\Components\DateTimePicker::make('pivot_data_start')
                    ->label('Data start')
                    ->required(),
                Forms\Components\DateTimePicker::make('pivot_data_end')
                    ->required(),
                Forms\Components\Toggle::make('pivot_disabled')
                    ->mutateDehydratedStateUsing(function ($data) {
                        dd($data);
                    })
                    ->inline(false)
                    ->required(),
            ]);
    }

and now edit works just fine

2 replies

FFilament

•Created by jamesro on 10/8/2024 in #❓┊help

HasManyThrough for select field

solved by changing relation to belongsToMany, hope is correctly:

  public function categorii()
    {
        return $this->belongsToMany(Categorii::class, 'necesare_categorii', 'id_necesar', 'id_categorie');
    }

  public function categorii()
    {
        return $this->belongsToMany(Categorii::class, 'necesare_categorii', 'id_necesar', 'id_categorie');
    }

3 replies

FFilament

•Created by jamesro on 10/2/2024 in #❓┊help

FileUpload on relation ( HasOne) extra parameters

@Dan Harrin any suggestion?

7 replies

FFilament

•Created by jamesro on 10/2/2024 in #❓┊help

FileUpload on relation ( HasOne) extra parameters

I'm expecting it to create the second relation only if I selected a file on that second field

7 replies

FFilament

•Created by jamesro on 10/2/2024 in #❓┊help

FileUpload on relation ( HasOne) extra parameters

 Fieldset::make('Adaugati un email')
                                            ->relationship('fisierEmail')
                                            ->mutateRelationshipDataBeforeCreateUsing(function ($data, Set $set, Get $get){
                                                //if($data['fisier_aditional'] !== null) {
                                                    $data['user_add'] = auth()->id();
                                                    $data['data_add'] = now();
                                                    $data['tip'] = 2;
                                                //}
                                                return $data;
                                            })
                                            ->schema([
                                                FileUpload::make('fisier_aditional')
                                                    ->acceptedFileTypes(['application/vnd.ms-outlook'])
                                                    ->hiddenLabel()
                                                    ->downloadable()
                                                    ->columnSpan('full')
                                                    ->directory('emails/comenzi')
                                                    ->visibility('public')
                                                    ->placeholder('Numai fisiere cu extensia .msg')
                                            ]),

 Fieldset::make('Adaugati un email')
                                            ->relationship('fisierEmail')
                                            ->mutateRelationshipDataBeforeCreateUsing(function ($data, Set $set, Get $get){
                                                //if($data['fisier_aditional'] !== null) {
                                                    $data['user_add'] = auth()->id();
                                                    $data['data_add'] = now();
                                                    $data['tip'] = 2;
                                                //}
                                                return $data;
                                            })
                                            ->schema([
                                                FileUpload::make('fisier_aditional')
                                                    ->acceptedFileTypes(['application/vnd.ms-outlook'])
                                                    ->hiddenLabel()
                                                    ->downloadable()
                                                    ->columnSpan('full')
                                                    ->directory('emails/comenzi')
                                                    ->visibility('public')
                                                    ->placeholder('Numai fisiere cu extensia .msg')
                                            ]),

7 replies

FFilament

•Created by jamesro on 10/2/2024 in #❓┊help

FileUpload on relation ( HasOne) extra parameters

What am I doing wrong here? why is filament trying to save my second upload field relation even if I don't selected a file in that field?

Fieldset::make('Adaugati un fisier')
                                            ->relationship('fisierAditional')
                                            ->mutateRelationshipDataBeforeCreateUsing(function ($data, Set $set, Get $get){
                                                $data['user_add'] = auth()->id();
                                                $data['data_add'] = now();
                                                $data['tip'] = 1;

                                                return $data;
                                            })
                                            ->schema([
                                                FileUpload::make('fisier_aditional')
                                                    ->hiddenLabel()
                                                    ->downloadable()
                                                    ->columnSpan('full')
                                                    ->directory('pdfs/comenzi')
                                                    ->visibility('public')
                                                    ->placeholder('Numai imagini sau fisiere de tip PDF.')
                                                    ->acceptedFileTypes(['application/pdf', 'image/*']),
                                            ]),

Fieldset::make('Adaugati un fisier')
                                            ->relationship('fisierAditional')
                                            ->mutateRelationshipDataBeforeCreateUsing(function ($data, Set $set, Get $get){
                                                $data['user_add'] = auth()->id();
                                                $data['data_add'] = now();
                                                $data['tip'] = 1;

                                                return $data;
                                            })
                                            ->schema([
                                                FileUpload::make('fisier_aditional')
                                                    ->hiddenLabel()
                                                    ->downloadable()
                                                    ->columnSpan('full')
                                                    ->directory('pdfs/comenzi')
                                                    ->visibility('public')
                                                    ->placeholder('Numai imagini sau fisiere de tip PDF.')
                                                    ->acceptedFileTypes(['application/pdf', 'image/*']),
                                            ]),

7 replies

FFilament

•Created by jamesro on 10/1/2024 in #❓┊help

Showing a modal with list of order products

Oky I found this on FilamentPhp documentation https://filamentphp.com/docs/3.x/tables/advanced#preventing-query-string-conflicts-with-the-pagination-page

public function table(Table $table): Table
{
    return $table
        ->queryStringIdentifier('orderProducts');
}

public function table(Table $table): Table
{
    return $table
        ->queryStringIdentifier('orderProducts');
}

i've set ->queryStringIdentifier('orderProducts'); and now all good

2 replies

FFilament

•Created by jamesro on 9/25/2024 in #❓┊help

Add roles / permissions per team for user

this is what I've ended doing:

Forms\Components\Select::make('roles')
                                ->preload()
                                ->label('Roluri')
                                ->relationship(name: 'roles', titleAttribute: 'name')
                                ->saveRelationshipsUsing(function ($record, $state, $get) use ($form) {
                                    setPermissionsTeamId($form->getRecord()->id);
                                    $record->roles()->syncWithPivotValues($state, [config('permission.column_names.team_foreign_key') => $form->getRecord()->id]);
                                })
                                ->multiple()
                                ->preload()
                                ->searchable(),

Forms\Components\Select::make('roles')
                                ->preload()
                                ->label('Roluri')
                                ->relationship(name: 'roles', titleAttribute: 'name')
                                ->saveRelationshipsUsing(function ($record, $state, $get) use ($form) {
                                    setPermissionsTeamId($form->getRecord()->id);
                                    $record->roles()->syncWithPivotValues($state, [config('permission.column_names.team_foreign_key') => $form->getRecord()->id]);
                                })
                                ->multiple()
                                ->preload()
                                ->searchable(),

33 replies

FFilament

•Created by jamesro on 9/25/2024 in #❓┊help

Add roles / permissions per team for user

managed to sort it in the end, even simpler :))

33 replies

FFilament

•Created by jamesro on 9/25/2024 in #❓┊help

Add roles / permissions per team for user

@CodeWithDennis @Lara Zeus i've managed to eliminate that TeamUser, the question i have is, I want to have a super admin panel, where you can see resources from all Teams, the problem I see rising is this Spatie Permission relation

public function roles(): BelongsToMany
    {
        $relation = $this->morphToMany(
            config('permission.models.role'),
            'model',
            config('permission.table_names.model_has_roles'),
            config('permission.column_names.model_morph_key'),
            app(PermissionRegistrar::class)->pivotRole
        );

        if (! app(PermissionRegistrar::class)->teams) {
            return $relation;
        }

        $teamsKey = app(PermissionRegistrar::class)->teamsKey;
        $relation->withPivot($teamsKey);
        $teamField = config('permission.table_names.roles').'.'.$teamsKey;

        return $relation->wherePivot($teamsKey, getPermissionsTeamId())
            ->where(fn ($q) => $q->whereNull($teamField)->orWhere($teamField, getPermissionsTeamId()));
    }

public function roles(): BelongsToMany
    {
        $relation = $this->morphToMany(
            config('permission.models.role'),
            'model',
            config('permission.table_names.model_has_roles'),
            config('permission.column_names.model_morph_key'),
            app(PermissionRegistrar::class)->pivotRole
        );

        if (! app(PermissionRegistrar::class)->teams) {
            return $relation;
        }

        $teamsKey = app(PermissionRegistrar::class)->teamsKey;
        $relation->withPivot($teamsKey);
        $teamField = config('permission.table_names.roles').'.'.$teamsKey;

        return $relation->wherePivot($teamsKey, getPermissionsTeamId())
            ->where(fn ($q) => $q->whereNull($teamField)->orWhere($teamField, getPermissionsTeamId()));
    }

as you se it relies on getPermissionsTeamId() which you normally set when you switch the team, any idea how I can make it work in super admin panel so it brings the correct things?

33 replies

FFilament

•Created by jamesro on 9/25/2024 in #❓┊help

Add roles / permissions per team for user

yeeye i think i sorted it, now it saves correctly my

->saveRelationshipsBeforeChildrenUsing(function ($component, $set, $get, $record) {
                        $record->load('users.roles');
                        $rolesArray = [];
                        foreach ($get('userss') as $userTeam) {

                            $rolesArray[$userTeam['id']] = $userTeam['roles'];
                        }

                        // Sync roles with team_id
                        $record->users()->each(function (TeamUser $teamUser) use ($rolesArray) {

                            $teamUser->roles()->syncWithPivotValues($rolesArray[$teamUser->id], ['team_id' => $teamUser->team_id, 'model_id' => $teamUser->id]);
                        });

                    })

->saveRelationshipsBeforeChildrenUsing(function ($component, $set, $get, $record) {
                        $record->load('users.roles');
                        $rolesArray = [];
                        foreach ($get('userss') as $userTeam) {

                            $rolesArray[$userTeam['id']] = $userTeam['roles'];
                        }

                        // Sync roles with team_id
                        $record->users()->each(function (TeamUser $teamUser) use ($rolesArray) {

                            $teamUser->roles()->syncWithPivotValues($rolesArray[$teamUser->id], ['team_id' => $teamUser->team_id, 'model_id' => $teamUser->id]);
                        });

                    })

replaced saveRelationshipsUsing with saveRelationshipsBeforeChildrenUsing

33 replies

FFilament

•Created by jamesro on 9/25/2024 in #❓┊help

Add roles / permissions per team for user

@CodeWithDennis @Lara Zeus any idea ? 😢

33 replies

FFilament

•Created by jamesro on 9/25/2024 in #❓┊help

Add roles / permissions per team for user

i tried this also

->saveRelationshipsUsing(function ($component, $set, $get, $record) {
                        $record->load('users.roles');
                        $rolesArray = [];

                        foreach ($get('userss') as $userTeam) {
                            $rolesArray[$userTeam['id']] = $userTeam['roles'];
                        }

                        // Sync roles with team_id
                        $record->users()->each(function (TeamUser $teamUser) use ($rolesArray) {
                            $teamUser->roles()->syncWithPivotValues($rolesArray[$teamUser->id], ['team_id' => $teamUser->team_id, 'model_id' => $teamUser->id]);
                        });

                    })

->saveRelationshipsUsing(function ($component, $set, $get, $record) {
                        $record->load('users.roles');
                        $rolesArray = [];

                        foreach ($get('userss') as $userTeam) {
                            $rolesArray[$userTeam['id']] = $userTeam['roles'];
                        }

                        // Sync roles with team_id
                        $record->users()->each(function (TeamUser $teamUser) use ($rolesArray) {
                            $teamUser->roles()->syncWithPivotValues($rolesArray[$teamUser->id], ['team_id' => $teamUser->team_id, 'model_id' => $teamUser->id]);
                        });

                    })

but no joy, somehow the model_has_roles is getting the values inserted without team_id before even to reach my each statement and I get sql duplicat id error

33 replies

FFilament

•Created by jamesro on 9/25/2024 in #❓┊help

Add roles / permissions per team for user

array:1 [▼ // app/Filament/Resources/TeamResource.php:73
  "record-68" => array:6 [▼
    "id" => 68
    "team_id" => 1
    "user_id" => 236
    "created_at" => "2024-09-26T09:15:09.000000Z"
    "updated_at" => "2024-09-26T09:15:09.000000Z"
    "roles" => array:1 [▼
      0 => "1"
    ]
  ]
]

array:1 [▼ // app/Filament/Resources/TeamResource.php:73
  "record-68" => array:6 [▼
    "id" => 68
    "team_id" => 1
    "user_id" => 236
    "created_at" => "2024-09-26T09:15:09.000000Z"
    "updated_at" => "2024-09-26T09:15:09.000000Z"
    "roles" => array:1 [▼
      0 => "1"
    ]
  ]
]

managed to catch something when I did

->saveRelationshipsUsing(function ($component, $set, $get, $record) {
dd($get('userss')); 
})

->saveRelationshipsUsing(function ($component, $set, $get, $record) {
dd($get('userss')); 
})

33 replies

FFilament

•Created by jamesro on 9/25/2024 in #❓┊help

Add roles / permissions per team for user

@Lara Zeus using saveRelationshipsUsing on the repeater, does nothing trying to place a dd right after

->saveRelationshipsUsing(function ($component, $set, $get, $record) { 
dd('die');
})

->saveRelationshipsUsing(function ($component, $set, $get, $record) { 
dd('die');
})

it goes by and inserts a value in model_has_roles with team_id missing

33 replies

FFilament

•Created by jamesro on 9/25/2024 in #❓┊help

Add roles / permissions per team for user

from what I see the problem starts here:

Forms\Components\Repeater::make('userss')
                    ->label(function () {
                        return 'Members';
                    })
                    ->columnSpan('2')
                    ->relationship('users') // Assuming there's a relationship for products
                    ->schema([
                        Forms\Components\Grid::make(3) // Defines a grid with 4 columns
                        ->schema([
                            Select::make('user_id')
                                ->label('Users')
                                ->relationship('user', 'nume')
                                ->required(),
                            Select::make('roles')
                                ->label('Roles')
                                ->multiple()
                                ->preload()
                                ->relationship('roles', 'name')
                        ])
                    ])

Forms\Components\Repeater::make('userss')
                    ->label(function () {
                        return 'Members';
                    })
                    ->columnSpan('2')
                    ->relationship('users') // Assuming there's a relationship for products
                    ->schema([
                        Forms\Components\Grid::make(3) // Defines a grid with 4 columns
                        ->schema([
                            Select::make('user_id')
                                ->label('Users')
                                ->relationship('user', 'nume')
                                ->required(),
                            Select::make('roles')
                                ->label('Roles')
                                ->multiple()
                                ->preload()
                                ->relationship('roles', 'name')
                        ])
                    ])

i saves me the roles in the model_has_roles table, but it doesn't insert the team_id value, which is actually the record->id that i'm currently editing..

33 replies

FFilament

•Created by jamesro on 9/25/2024 in #❓┊help

Add roles / permissions per team for user

do you guys think is oky this relation I have in my User mode?

    public function teams(): BelongsToMany
    {
        return $this->belongsToMany(Team::class, 'team_user')->using(TeamUser::class);
    }

    public function teams(): BelongsToMany
    {
        return $this->belongsToMany(Team::class, 'team_user')->using(TeamUser::class);
    }

do I really need that TeamUser ?

33 replies

Gaming

Programming