How to get the pivot value of parent row?

[qcol]

I have 2 tables, products and products_items.
In products_items I have columns product_id, parent_product_id, qty.

My tree:

Lev1_item (pivot_qty = 12)
  lev2_item 1 (pivot_qty = 7)
  lev2_item 2 (pivot_qty = 6)
  lev2_item 3 (pivot_qty = 2)
      Lev3_item1 (pivot_qty = 1)
      Lev3_item2 (pivot_qty = 8)
      Lev3_item3 (pivot_qty = 22)

My code:

$products = Product::find(self::$id)->descendants()->depthFirst()->get();
foreach ($products as $product) {
// I have all row data with pivot_qty here, but 
// how to get the **parent's** pivot_qty here? 
// for example, when row = Lev3_item3, I need information about parent too, so:  lev2_item 3 (pivot_qty = 2)

}

[staudenmeir]

Hi @qcol,
Please share your Product model.

[qcol]

Hi!

Model

class Product extends Model
{
    use HasFactory;
    use SoftDeletes;
    use HasGraphRelationships;

    public function enableCycleDetection(): bool
    {
        return true;
    }

      public function getPivotTableName(): string
    {
        return 'product_items';
    }

    public function getParentKeyName(): string
    {
        return 'parentproduct_id';
    }

    public function getChildKeyName(): string
    {
        return 'product_id';
    }

    public function getPivotColumns(): array
    {
        return ['qty'];
    }

[staudenmeir]

For descendants on level 2+ (e.g. Lev3_item3 if Product::find(self::$id) is Lev1_item), you can find the parent inside $products:

foreach ($products as $product) {
    $parent = $products->where('id', $product->pivot->parentproduct_id)->first();

    if ($parent) {
        dump($parent->pivot->qty);
    }
}

This doesn't work for direct children (e.g. lev2_item 3) as their parents aren't part of $products. Do you also need to get the parent in these cases?

[qcol]

Oh yeah, I didn't think of that :)
Thank you very much @staudenmeir ! - it works!