bogus
bogus
PostsComments
FFilament
Created by bogus on 5/26/2024 in #❓┊help
Editable TextInputColumn with HasMany
Hello, Perhaps I want too much from filamentphp ... but anyway .. I have HasMany relaation 
    public function commissions(): HasMany
    {
        return $this->hasMany(Commission::class);
    }
    public function commissions(): HasMany
    {
        return $this->hasMany(Commission::class);
    }
and a simple table like this: 
    public static function table(Table $table): Table
    {
        $columns = [
            Tables\Columns\TextColumn::make('id')->searchable(),
            Tables\Columns\TextColumn::make('commissions.value'),
        ];

        foreach (range(0,3) as $id){
            $columns[] = Tables\Columns\TextInputColumn::make('commissions.'.$id.'.value')->label('commissions.'.$id.'.value');
        }

        return $table
            ->columns( $columns);
    }
    public static function table(Table $table): Table
    {
        $columns = [
            Tables\Columns\TextColumn::make('id')->searchable(),
            Tables\Columns\TextColumn::make('commissions.value'),
        ];

        foreach (range(0,3) as $id){
            $columns[] = Tables\Columns\TextInputColumn::make('commissions.'.$id.'.value')->label('commissions.'.$id.'.value');
        }

        return $table
            ->columns( $columns);
    }
Which displays the data correctly, but does not allow me to save .. Filament tries to execute the following SQL request: 
         update `my_table_name` set `commissions` = {"1":{"value":"222"}}, `cities`.`updated_at` = 2024-05-26 19:24:13 where `id` = 1
         update `my_table_name` set `commissions` = {"1":{"value":"222"}}, `cities`.`updated_at` = 2024-05-26 19:24:13 where `id` = 1
but this is wrong How can I make it so that the data can be saved?
Am I missing something or filament don't allow use TextInputColumn with HasMany relation ? Thanks
2 replies