Filament Repeater nested under Repeater Issue.

Hi everyone,

I am creating an ecommerce website where products can have multiple Variations with Attributes and terms.

For Variations I created an repeater field which is storing data in the product_variations table.

In the variations I would like to record different attributes and terms. for this I created a attribute_product_variation table.

  Schema::create('attribute_product_variation', function (Blueprint $table) {
            $table->id();
            $table->foreignId('product_variation_id')->constrained()->onDelete('cascade');
            $table->foreignId('attribute_id')->constrained()->onDelete('cascade');
            $table->foreignId('term_id')->constrained()->onDelete('cascade');
            $table->timestamps();
        });

My repeater field is working fine, but nested attribute and terms are not saving in the attribute_product_variation table.

Also the UI is working fine, just not able to store Attributes and terms.

Product Model

  public function variations()
    {
        return $this->hasMany(ProductVariation::class);
    }

ProductVariation Model

  public function product()
    {
        return $this->belongsTo(Product::class);
    }
 public function terms()
    {
        return $this->belongsToMany(Term::class);
    }

    public function attributes()
    {
        return $this->belongsToMany(Attribute::class, 'attribute_product_variation')
                    ->withPivot('term_id')
                    ->withTimestamps();
    }

Attribute Model

   public function terms()
    {
        return $this->hasMany(Term::class);
    }

    public function user()
    {
        return $this->belongsTo(User::class);
    }


    public function productVariations()
    {
        return $this->belongsToMany(ProductVariation::class, 'attribute_product_variation')
                    ->withPivot('term_id')
                    ->withTimestamps();
    }

Product Resource

Forms\Components\Repeater::make('variations')
                    ->relationship('variations')
                    ->schema([
                        Forms\Components\TextInput::make('market_price')
                            ->numeric()
                            ->required()
                            ->label('Market Price'),

                        Forms\Components\TextInput::make('sale_price')
                            ->numeric()
                            ->required()
                            ->label('Sale Price'),

                        Forms\Components\TextInput::make('stock')
                            ->numeric()
                            ->required()
                            ->label('Stock'),

                        Forms\Components\FileUpload::make('image')
                            ->image()
                            ->disk('public')
                            ->directory('product-images')
                            ->nullable()
                            ->label('Image'),

                        Forms\Components\Textarea::make('short_description')
                            ->maxLength(65535)
                            ->nullable()
                            ->label('Short Description'),

                        Forms\Components\Repeater::make('attributes')
                            ->schema([
                                Forms\Components\Select::make('attribute_id')
                                    ->options(Attribute::all()->pluck('name', 'id'))
                                    ->required()
                                    ->label('Attribute')
                                    ->reactive()
                                    ->afterStateUpdated(function (callable $set, $state) {
                                        // Update terms based on selected attribute
                                        $terms = Term::where('attribute_id', $state)->pluck('name', 'id');
                                        $set('term_options', $terms); // Update the term options
                                    }),

                                Forms\Components\Select::make('term_id')
                                    ->options(function (callable $gfile:///C:/Users/think/Downloads/Screenshot%202024-09-11%20at%2012-48-22%20Edit%20Product%20-%20ThinkNCode.pnget) {
                                        $attributeId = $get('attribute_id');
                                        if ($attributeId) {
                                            return Term::where('attribute_id', $attributeId)->pluck('name', 'id');
                                        }
                                        return [];
                                    })
                                    ->required()
                                    ->label('Term'),
                            ])
                            ->createItemButtonLabel('Add Attribute'),

LaryAI

1 year ago

Level 58

To address the issue of nested attributes and terms not being saved in the attribute_product_variation table, you need to ensure that the nested repeater data is being properly handled and saved. Here’s a step-by-step solution:

Ensure Relationships are Defined Correctly: Make sure your models have the correct relationships defined. From your provided code, it looks like you have set up the relationships correctly.
Update the Product Resource: You need to ensure that the nested repeater data is being saved correctly. This involves handling the saving process in the ProductResource class.
Handle Saving Nested Data: You need to override the saved method in your ProductResource to handle saving the nested attributes and terms.

Here’s how you can do it:

ProductResource

use Filament\Forms;
use Filament\Resources\Form;
use Filament\Resources\Resource;
use App\Models\Product;
use App\Models\Attribute;
use App\Models\Term;

class ProductResource extends Resource
{
    protected static ?string $model = Product::class;

    public static function form(Form $form): Form
    {
        return $form
            ->schema([
                Forms\Components\Repeater::make('variations')
                    ->relationship('variations')
                    ->schema([
                        Forms\Components\TextInput::make('market_price')
                            ->numeric()
                            ->required()
                            ->label('Market Price'),

                        Forms\Components\TextInput::make('sale_price')
                            ->numeric()
                            ->required()
                            ->label('Sale Price'),

                        Forms\Components\TextInput::make('stock')
                            ->numeric()
                            ->required()
                            ->label('Stock'),

                        Forms\Components\FileUpload::make('image')
                            ->image()
                            ->disk('public')
                            ->directory('product-images')
                            ->nullable()
                            ->label('Image'),

                        Forms\Components\Textarea::make('short_description')
                            ->maxLength(65535)
                            ->nullable()
                            ->label('Short Description'),

                        Forms\Components\Repeater::make('attributes')
                            ->schema([
                                Forms\Components\Select::make('attribute_id')
                                    ->options(Attribute::all()->pluck('name', 'id'))
                                    ->required()
                                    ->label('Attribute')
                                    ->reactive()
                                    ->afterStateUpdated(function (callable $set, $state) {
                                        // Update terms based on selected attribute
                                        $terms = Term::where('attribute_id', $state)->pluck('name', 'id');
                                        $set('term_options', $terms); // Update the term options
                                    }),

                                Forms\Components\Select::make('term_id')
                                    ->options(function (callable $get) {
                                        $attributeId = $get('attribute_id');
                                        if ($attributeId) {
                                            return Term::where('attribute_id', $attributeId)->pluck('name', 'id');
                                        }
                                        return [];
                                    })
                                    ->required()
                                    ->label('Term'),
                            ])
                            ->createItemButtonLabel('Add Attribute'),
                    ])
                    ->createItemButtonLabel('Add Variation'),
            ]);
    }

    public static function saved($record, $data)
    {
        foreach ($data['variations'] as $variationData) {
            $variation = $record->variations()->updateOrCreate(
                ['id' => $variationData['id'] ?? null],
                $variationData
            );

            if (isset($variationData['attributes'])) {
                $variation->attributes()->sync([]);
                foreach ($variationData['attributes'] as $attributeData) {
                    $variation->attributes()->attach($attributeData['attribute_id'], ['term_id' => $attributeData['term_id']]);
                }
            }
        }
    }
}

Explanation:

Form Schema:
- The form schema defines the structure of the form, including the nested repeaters for variations and attributes.
Saved Method:
- The saved method is overridden to handle the saving of nested attributes and terms.
- For each variation, it updates or creates the variation record.
- It then syncs the attributes for each variation, ensuring that the attribute_product_variation table is updated with the correct attribute_id and term_id.

This should ensure that your nested attributes and terms are saved correctly in the attribute_product_variation table.

tisuchi

1 year ago

Level 70

@anibabbar You can give it a try with the saved method that @laryai suggested. It seems it's correct.

anibabbar

1 year ago

Level 2

@tisuchi, it was a typo. Sorted, thanks!

Please or to participate in this conversation.