relation manager for relation of NestedSet ancestors? E.g. relation Goods for all ancestors of a Category

[wivaku]

Package

Panel builder

Package Version

v3.2.135

How can we help you?

Let's say I have a Category that can have Goods.
So, I can have a CategoryResource and GoodsRelationManager.

In my case I am using NestedSet and would like to have a read-only Filament relation manager for CategoryResource that shows the goods for all the ancestors of that category. I would then want to group the table rows by the parent Category.

Can this be done in Filament? I believe Filament relation managers expect a real Laravel relation (e.g. HasMany).
So, I am not sure if/how it can be achieved.

A manual approach to get all the goods for each of the ancestor Categories would be:

Category::query()
  ->firstWhere('id', $id)
  ->ancestors
  ->pluck('goods')
  ->collapse()

This would get all of the goods, and includes pivot (with category_id) so that I can see which category had that good.
That's wanted, but also needed: Category X could have Good A, and Category Y could have Good A as well. This way Good A shows up twice.

If I use the example from the NestedSets documentation, then I only get the goods used by any of the categories (so: Good A is included, but only once and without reference to the Categories that use it):

$categories = $category->ancestors()->pluck('id');
$goods = Goods::whereIn('category_id', $categories)->get();

[wivaku]

I believe I can achieve this using this approach: #10667