I am working with laravel and I have these models (a summary) with the following relationships:
Table products
increment id;
string description;
Table materials
increment id;
string name;
Table material_product
increment id;
integer product_id;
integer material_id;
string dimension;
class Product extends Model
{
public function materials()
{
return $this->belongsToMany(Material::class)->withPivot('dimension');
}
}
class Material extends Model
{
public function products()
{
return $this->belongsToMany(Product::class)->withPivot('dimension');
}
}
I am using the attach (to save) and sync (to update) the data of my pivot table, the problem is that in my business model I need to be able to save repeated items, for example:
products
+-----+--------------+
| id | description |
|-----|--------------+
| 1 | dining table |
+-----+--------------+
materials
+-----+------+
| id | name |
|-----|------+
| 1 | wood |
+-----+------+
material_product
+-----+------------+-------------+-----------+
| id | product_id | material_id | dimension |
|-----|------------+-------------+-----------+
| 1 | 1 | 1 | 10 x 2 |
+-----+------------+-------------+-----------+
| 2 | 1 | 1 | 5 x 3 |
+-----+------------+-------------+-----------+
so none of these methods works for me since if I send more than 1 repeated material, only one is attached to my database, how can I do this? some idea?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire