Filament•13mo ago

Problems using JSON from Repeater and saving in mysql

I followed the documentation to use Repeater but was unsuccessful. Below is a printout of the code snippet! In mysql the columns are in JSON.

18 Replies

LeandroFerreira•13mo ago

read #✅┊rules before posting please

mysterOP•13mo ago

Leandro, I attached a printout of the code.

LeandroFerreira•13mo ago

mysterOP•13mo ago

It's very disorganized if you send it here. Look:

Section::make('Top produtos Vendidos')
                    ->icon('heroicon-m-fire')
                    ->description('A Vistune.ai quer priorizar a venda dos seus produtos mais vendidos!')
                    ->schema([
                        Repeater::make('')
                            ->schema([
                                TextInput::make('top_produto')
                                    ->hintIcon('heroicon-m-question-mark-circle', tooltip: 'Need some more information?')
                                    ->placeholder('Jon, Mary, Tom, Léo...')
                                    ->required()
                                    ->prefixIcon('heroicon-o-fire')
                                    ->label('Nome do Produto:'),
                                TextInput::make('link_top_produto')
                                    ->hintIcon('heroicon-m-question-mark-circle', tooltip: 'Need some more information?')
                                    ->placeholder('Jon, Mary, Tom, Léo...')
                                    ->url()
                                    ->prefixIcon('heroicon-o-fire')
                                    ->label('Link do Produto:')
                                    ->required(),
                            ])->columns(2)
                            ->addActionLabel('Adicionar Produto')
                    ])
                    ->collapsed(),

Section::make('Top produtos Vendidos')
                    ->icon('heroicon-m-fire')
                    ->description('A Vistune.ai quer priorizar a venda dos seus produtos mais vendidos!')
                    ->schema([
                        Repeater::make('')
                            ->schema([
                                TextInput::make('top_produto')
                                    ->hintIcon('heroicon-m-question-mark-circle', tooltip: 'Need some more information?')
                                    ->placeholder('Jon, Mary, Tom, Léo...')
                                    ->required()
                                    ->prefixIcon('heroicon-o-fire')
                                    ->label('Nome do Produto:'),
                                TextInput::make('link_top_produto')
                                    ->hintIcon('heroicon-m-question-mark-circle', tooltip: 'Need some more information?')
                                    ->placeholder('Jon, Mary, Tom, Léo...')
                                    ->url()
                                    ->prefixIcon('heroicon-o-fire')
                                    ->label('Link do Produto:')
                                    ->required(),
                            ])->columns(2)
                            ->addActionLabel('Adicionar Produto')
                    ])
                    ->collapsed(),

    protected $casts = [
        'top_produto' => 'array',
        'link_top_produto' => 'array'
    ];

    protected $casts = [
        'top_produto' => 'array',
        'link_top_produto' => 'array'
    ];

I believe the error is not in the code. Maybe there's something missing that I missed. In the database, the column is already formatted for JSON.

LeandroFerreira•13mo ago

não é que fica desorganizado, é que vc nao formatou o código pra inserir aqui, e nem adicionou a tag php no markdown O nome do seu repeater na verdade tem que ser a sua coluna... vc está declarando um repeater sem nome

mysterOP•13mo ago

putsss So in the repeater I add the column name and in TextInput the name of my json variable? Column: 'Product' {"variable":"value"} Something like?

LeandroFerreira•13mo ago

sim

mysterOP•13mo ago

If you could show me how to format it, please, next time I won't make the same mistake 😅

LeandroFerreira•13mo ago

https://filamentphp.com/docs/3.x/forms/fields/repeater#overview

Repeater - Form Builder - Filament

LeandroFerreira•13mo ago

copia exatamente como está no item 4

mysterOP•13mo ago

Beauty, thanks I put the name of the column in the Repeater and any names in the textinput. But it did not work. Do these names need to be real in the database?

Section::make('Top products sold')
                    ->icon('heroicon-m-fire')
                    ->description('Vistune.ai wants to prioritize the sale of its best-selling products!')
                    ->schema([
                        Repeater::make('top_produto')
                            ->schema([
                                TextInput::make('product')
                                    ->hintIcon('heroicon-m-question-mark-circle', tooltip: 'Need some more information?')
                                    ->placeholder('Jon, Mary, Tom, Léo...')
                                    ->required()
                                    ->prefixIcon('heroicon-o-fire')
                                    ->label('Product Name:'),
                                TextInput::make('link')
                                    ->hintIcon('heroicon-m-question-mark-circle', tooltip: 'Need some more information?')
                                    ->placeholder('Jon, Mary, Tom, Léo...')
                                    ->url()
                                    ->prefixIcon('heroicon-o-fire')
                                    ->label('Product Link:')
                                    ->required(),
                            ])->columns(2)
                            ->addActionLabel('Add Product')
                    ])
                    ->collapsed(),

Section::make('Top products sold')
                    ->icon('heroicon-m-fire')
                    ->description('Vistune.ai wants to prioritize the sale of its best-selling products!')
                    ->schema([
                        Repeater::make('top_produto')
                            ->schema([
                                TextInput::make('product')
                                    ->hintIcon('heroicon-m-question-mark-circle', tooltip: 'Need some more information?')
                                    ->placeholder('Jon, Mary, Tom, Léo...')
                                    ->required()
                                    ->prefixIcon('heroicon-o-fire')
                                    ->label('Product Name:'),
                                TextInput::make('link')
                                    ->hintIcon('heroicon-m-question-mark-circle', tooltip: 'Need some more information?')
                                    ->placeholder('Jon, Mary, Tom, Léo...')
                                    ->url()
                                    ->prefixIcon('heroicon-o-fire')
                                    ->label('Product Link:')
                                    ->required(),
                            ])->columns(2)
                            ->addActionLabel('Add Product')
                    ])
                    ->collapsed(),

LeandroFerreira•13mo ago

qual o nome da sua coluna no banco de dados?

mysterOP•13mo ago

top_product It's for JSON

LeandroFerreira•13mo ago

fillable também né?

mysterOP•13mo ago

yess I found the error, thanks for the help. The mount() function was not configured to show json columns. Add the mount() function to convert to array and it worked.

Dennis Koch•13mo ago

Hey guys, it's nice that you get personal help, but not everybody speaks your language.

mysterOP•13mo ago

Hey friend, you're right! I will put my lines in English!!

LeandroFerreira•13mo ago

#pt-br

Gaming

Programming

Problems using JSON from Repeater and saving in mysql