Filament•10mo ago

error it cant see my table columns

It was working but now it doest works idk why.. when i create supplier it cant see brands and subbrands. there is my code also:

return $form
            ->schema([
                TextInput::make('name')
                    ->required()
                    ->maxLength(255)
                    ->minLength(2),
                Select::make('brand_id')
                    ->label('Brand')
                    ->multiple()
                    ->relationship('brand', 'name')
                    ->searchable()
                    ->required()
                    ->options(Brand::all()->pluck('name', 'id'))
                    ->preload()
                    ->createOptionForm([
                        TextInput::make('name')
                            ->required()
                            ->label('New Brand'),
                    ]),
                Select::make('subbrand_id')
                    ->label('Subbrand')
                    ->multiple()
                    ->relationship('subbrand', 'name')
                    ->searchable()
                    ->options(Subbrand::all()->pluck('name', 'id'))
                    ->columnSpan('full')
                    ->preload()
                    ->createOptionForm([
                        TextInput::make('name')
                            ->required()
                            ->label('New Subbrand'),
                    ]),
            ]);
    }

return $form
            ->schema([
                TextInput::make('name')
                    ->required()
                    ->maxLength(255)
                    ->minLength(2),
                Select::make('brand_id')
                    ->label('Brand')
                    ->multiple()
                    ->relationship('brand', 'name')
                    ->searchable()
                    ->required()
                    ->options(Brand::all()->pluck('name', 'id'))
                    ->preload()
                    ->createOptionForm([
                        TextInput::make('name')
                            ->required()
                            ->label('New Brand'),
                    ]),
                Select::make('subbrand_id')
                    ->label('Subbrand')
                    ->multiple()
                    ->relationship('subbrand', 'name')
                    ->searchable()
                    ->options(Subbrand::all()->pluck('name', 'id'))
                    ->columnSpan('full')
                    ->preload()
                    ->createOptionForm([
                        TextInput::make('name')
                            ->required()
                            ->label('New Subbrand'),
                    ]),
            ]);
    }

Supplier Model:

49 Replies

gigiloouuOP•10mo ago

any ideas?

ericmp•10mo ago

not sure, but an optimisation:

Brand::all()->pluck('name', 'id')

Brand::all()->pluck('name', 'id')

Brand::pluck('name', 'id')

Brand::pluck('name', 'id')

\Illuminate\Support\Benchmark::dd([
    fn () => Brand::all()->pluck('name', 'id'),
    fn () => Brand::pluck('name', 'id'),
]);

\Illuminate\Support\Benchmark::dd([
    fn () => Brand::all()->pluck('name', 'id'),
    fn () => Brand::pluck('name', 'id'),
]);

gigiloouuOP•10mo ago

where i should write this ?

\Illuminate\Support\Benchmark::dd([
    fn () => Brand::all()->pluck('name', 'id'),
    fn () => Brand::pluck('name', 'id'),
]);

\Illuminate\Support\Benchmark::dd([
    fn () => Brand::all()->pluck('name', 'id'),
    fn () => Brand::pluck('name', 'id'),
]);

ericmp•10mo ago

in tinker for example - php artisan tinker add \App\Models\ before the model name

gigiloouuOP•10mo ago

i should write it in model?

ericmp•10mo ago

no, i mean, like this:

\Illuminate\Support\Benchmark::dd([
    fn () => \App\Models\Brand::all()->pluck('name', 'id'),
    fn () => \App\Models\Brand::pluck('name', 'id'),
]);

\Illuminate\Support\Benchmark::dd([
    fn () => \App\Models\Brand::all()->pluck('name', 'id'),
    fn () => \App\Models\Brand::pluck('name', 'id'),
]);

gigiloouuOP•10mo ago

okay and where i should writ eit ? aa in terminal?

ericmp•10mo ago

if u do php artisan tinker u can execute arbitrary code yes thats an option

gigiloouuOP•10mo ago

i got it what is it ? 💀

ericmp•10mo ago

the benchmark results xd

gigiloouuOP•10mo ago

amm and its works or what? dd is it good ? ddd idk in web i have same result it cant read brand_ids and subbrand_ids

gigiloouuOP•10mo ago

its doest takes brand_id and subbrand_id literally yesterday it was working dd just i remove db and create again but in db everything is okay i think becouse by hand in db its works just there..

ericmp•10mo ago

in the 1st message i sent, literally the 2 first words are "not sure", which i meant idk what is happening with ur code. then i just wanted u to notice that Brand::all()->pluck('name', 'id') could be optimised. that is why i showed u the benchmark thing, so u can see the difference. that is it.

gigiloouuOP•10mo ago

aa thanks means second( ur way) is more fast? u mean that? idk i have form and model which i wrote

ericmp•10mo ago

yes. and just in case u think it doesnt matter for couple ms, u can just add a bunch of records and do the benchmark again

gigiloouuOP•10mo ago

and i have no idea why its not giving data

ericmp•10mo ago

not sure what u mean have u set the relationships in the models?

gigiloouuOP•10mo ago

yep i know that it does matte okay let me explane i have table

gigiloouuOP•10mo ago

like this and i have form also

return $form
            ->schema([
                TextInput::make('name')
                    ->required()
                    ->maxLength(255)
                    ->minLength(2),
                Select::make('brand_id')
                    ->label('Brand')
                    ->multiple()
                    ->relationship('brand', 'name')
                    ->searchable()
                    ->required()
                    ->options(Brand::all()->pluck('name', 'id'))
                    ->preload()
                    ->createOptionForm([
                        TextInput::make('name')
                            ->required()
                            ->label('New Brand'),
                    ]),
                Select::make('subbrand_id')
                    ->label('Subbrand')
                    ->multiple()
                    ->relationship('subbrand', 'name')
                    ->searchable()
                    ->options(Subbrand::all()->pluck('name', 'id'))
                    ->columnSpan('full')
                    ->preload()
                    ->createOptionForm([
                        TextInput::make('name')
                            ->required()
                            ->label('New Subbrand'),
                    ]),
            ]);
    }

return $form
            ->schema([
                TextInput::make('name')
                    ->required()
                    ->maxLength(255)
                    ->minLength(2),
                Select::make('brand_id')
                    ->label('Brand')
                    ->multiple()
                    ->relationship('brand', 'name')
                    ->searchable()
                    ->required()
                    ->options(Brand::all()->pluck('name', 'id'))
                    ->preload()
                    ->createOptionForm([
                        TextInput::make('name')
                            ->required()
                            ->label('New Brand'),
                    ]),
                Select::make('subbrand_id')
                    ->label('Subbrand')
                    ->multiple()
                    ->relationship('subbrand', 'name')
                    ->searchable()
                    ->options(Subbrand::all()->pluck('name', 'id'))
                    ->columnSpan('full')
                    ->preload()
                    ->createOptionForm([
                        TextInput::make('name')
                            ->required()
                            ->label('New Subbrand'),
                    ]),
            ]);
    }

this is my form where I save name brands and subbrands also

gigiloouuOP•10mo ago

This is model of this form

gigiloouuOP•10mo ago

any ideas?

developer•10mo ago

in your form schema Select::make('brand_id') you need to have only ONE of this: ->relationship() OR ->options() not both remove options()

gigiloouuOP•10mo ago

okay i remove options() but its not working same error idk it was working yesterday d.. I remove relationshop now and its works.. hmm but when I click to edit

developer•10mo ago

ok so the relationship is wrong

gigiloouuOP•10mo ago

now i have this eror.. yep and becouse of that I have error in edit

developer•10mo ago

change the relationship from belongsTo to hasOne

gigiloouuOP•10mo ago

same error..

developer•10mo ago

this error is self explanatory man you need to pass the value $name

gigiloouuOP•10mo ago

yep sure i get it but how or where 💀 i should do it in edit supplier? like this resource edit file ? yep i already did it

developer•10mo ago

https://laravel.com/docs/10.x/eloquent-mutators#mutating-multiple-attributes why you named the Attribute attribute ?

gigiloouuOP•10mo ago

where? I named Attribute

developer•10mo ago

in the supplier model

gigiloouuOP•10mo ago

    public function attribute(string $name): Attribute {
        return Attribute::make(
            get: fn($value) => explode(',', $value),
            set: fn($value) => implode(',', $value),
        );
    }

    public function attribute(string $name): Attribute {
        return Attribute::make(
            get: fn($value) => explode(',', $value),
            set: fn($value) => implode(',', $value),
        );
    }

Its Attribute

developer•10mo ago

not sure what you trying to do but try to use a different name also you expecting to pass a $name so...

gigiloouuOP•10mo ago

idk it was working yesterday why its not working idk like im using this becouse of brands and subbrands which i give is many to many like its 1,2,3,4 string so to take data and set im using this to split

developer•10mo ago

try to rename the attribute function i gotta go, you better use chatgpt to debug that shit 😆 and its not a filament-related problem tbh

gigiloouuOP•10mo ago

i try it but gpt is shit 😄 yep i think same becouse it was working yesterday.. i didnt remember should i use anything more like

public function brandId(): Attribute {
        return $this->attribute('brandId');
    }

public function brandId(): Attribute {
        return $this->attribute('brandId');
    }

I should use this brandId anywhere? 💀 fixed thanks

ericmp•10mo ago

what was the issue?

gigiloouuOP•10mo ago

its not important to give $name attribute so i made this

public function attribute(): Attribute {
        return Attribute::make(
            get: fn($value) => explode(',', $value),
            set: fn($value) => implode(',', $value),
        );
    }
    public function brandId(): Attribute {
        return $this->attribute();
    }

    public function subbrandId(): Attribute {
        return $this->attribute();
    }

public function attribute(): Attribute {
        return Attribute::make(
            get: fn($value) => explode(',', $value),
            set: fn($value) => implode(',', $value),
        );
    }
    public function brandId(): Attribute {
        return $this->attribute();
    }

    public function subbrandId(): Attribute {
        return $this->attribute();
    }

I just remove names

ericmp•10mo ago

hmm i dont understand this code u say u r doing it for what? -> https://discord.com/channels/883083792112300104/1214094864854290502/1214118779789905971

gigiloouuOP•10mo ago

in db i have many ids in one column like 1,2,3,4 so for split it and parse im using this code its many to mnay

ericmp•10mo ago

or i dont understand it or u r overcomplicating it. but yeah if works for u then its fine i guess

gigiloouuOP•10mo ago

yep its works so who gives a fuck d btw thanks for ur best advice about that and ur time also ❤️

ericmp•10mo ago

🙌 (:

Gaming

Programming

error it cant see my table columns