php - backpack-for-laravel select2_multiple field with same pivot table but different fields on the same form

I-am in the process of making this project where I have two (or more) fields having the same pivot table and am using the relationship type on backpack-for-laravel. What i want to do is have these two fields work independently.

So let's say I want to have one field where the user selects thickness while in the other field the user can select shading suppose.

The issue is that these two fields have the same pivot table and the same relationship set up in the model and therefore only one of them would show up in the same form. I do know that HTML forms replace the fields with the same "name" attribute but I'd like to know how can i get around solving this issue and have the fields work independently maintaining the select2_multiple functionality.

Table structure (Collection has n-n relationship with Collection Attributes)

Collection:
 id
 collection_name
 .....

CollectionAttributes:
 id
 attribute_name
 attribute_value
 ...

CollectionAttrValues
 fk_col_id
 fk_attr_val_id

Copy code

Model relationship method:

public function collectionAttributeValues()
    {
        return $this->belongsToMany('App\Models\AttributeValue', 'collections_attr', 'fk_collection_id', 'fk_attr_val_id');
    }
Copy code

Controller fields code:

CRUD::addField([   // relationship
            'type' => "relationship",
            'name' => 'collectionAttributeValues', // the method on your model that defines the relationship
        
            // OPTIONALS:
            'label' => "Thickness",
            'attribute' => "attr_val", // foreign key attribute that is shown to user (identifiable attribute)
            'entity' => 'collectionAttributeValues', // the method that defines the relationship in your Model
            'model' => "App\Models\AttributeValue", // foreign key Eloquent model
            // 'placeholder' => "Select a category", // placeholder for the select2 input
            'options'   => (function ($query) {
                $thickness_id = \App\Models\Attribute::select('attr_id')
                ->where('fk_attr_category', 1)
                ->where('attr_type', 'collection')
                ->where('attr_name', 'Thickness')->get()->first()->attr_id;

                return $query->orderBy('attr_val', 'desc')->where('fk_attr_id', $thickness_id)->get();
            }),
         ]);

         CRUD::addField([   // relationship
            'type' => "relationship",
            'name' => 'collectionAttributeValues', // the method on your model that defines the relationship
        
            // OPTIONALS:
            'label' => "Shading",
            'attribute' => "attr_val", // foreign key attribute that is shown to user (identifiable attribute)
            'entity' => 'collectionAttributeValues', // the method that defines the relationship in your Model
            'model' => "App\Models\AttributeValue", // foreign key Eloquent model
            // 'placeholder' => "Select a category", // placeholder for the select2 input
            'options'   => (function ($query) {
                $shading = \App\Models\Attribute::select('attr_id')
                ->where('fk_attr_category', 1)
                ->where('attr_type', 'collection')
                ->where('attr_name', 'Shading')->get()->first()->attr_id;

                return $query->orderBy('attr_val', 'desc')->where('fk_attr_id', $shading)->get();
            }),
         ]);
Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.