F
Filament•5mo ago
Pan

Filament Demo shop_category_product, how does it work?

I've checked out the migration files of the three tables "shop_categories", "shop_category_product" and "shop_products". I've noticed that in the "shop_products" & "shop_categories" there are no foreign id field for each other but instead in the model of those two tables, they have a BelongsToMany relationship with "shop_category_product". and at that table seems to be where magic happens where it foreign id to both the primary id of "shop_products" & "shop_categories" as its primary key. What I don't understand is how it seem to still perfectly all connected by showing the categories attached to the product while in the product table there's no categories field. Like how does the "shop_category_product" table updates when a new attachment of a category on a product is added and how it is shown in the Forms of of "ProductResource.php" This seem to be the magic of the code but I can't find out how it works playing around. 
                                Forms\Components\Select::make('categories')
  ->relationship('categories','name')
  ->multiple()
  ->required(),
                                Forms\Components\Select::make('categories')
  ->relationship('categories','name')
  ->multiple()
  ->required(),
2 Replies
Tieme
Tieme•5mo ago
See model code : https://github.com/filamentphp/demo/blob/20ee634df15aa0ea5e1bd26bb8442d72edf8f26d/app/Models/Shop/Product.php#L40C1-L43C6
GitHub
demo/app/Models/Shop/Product.php at 20ee634df15aa0ea5e1bd26bb8442d7...
Source code for the demo.filamentphp.com website. Contribute to filamentphp/demo development by creating an account on GitHub.
Tieme
Tieme•5mo ago
categories is the relation on product. In addition to customizing the name of the intermediate table, you may also customize the column names of the keys on the table by passing additional arguments to the belongsToMany method. The third argument is the foreign key name of the model on which you are defining the relationship, while the fourth argument is the foreign key name of the model that you are joining to
Want results from more Discord servers?
Add your server
More Posts
How to create a resource record from another resource?Hello, I'm creating a Booklet record from a modal in my Customer resource. The record is being saveAccess State on an in Edit FormThis ```php ->state(function (Model $record): float { return OrderItem::where("product_id", $recApply filters button + Filters as a slide-over2 questions really 1) I remember there was a PR that added an `Apply` button to filters so the tablHow to use FilamentPHP Fabricator Route on custom Livewire component?Hello, Please let me know how do I use FilamentPHP Fabricator Page route inside custom Livewire compRedirect to new slug after updating tenant nameHi. I have the below EditTenantProfile set up just like the docs: ```php //EditTeamProfile.php claHow to redirect to a custom Page on a resource from a Relational ManagerI created a custom page on a Resource that uses a Relation Manager. I have a custom Action on the ReFirst key of a form data doesn't updateHello guys, i have a form where the first value gets never updated.Checkbox - Dont want to save it in databaseThe use case is simple, i am creating a form where Shipping Address and Billing Address would be dif