Has many through many-to-many

by

If you want to have a custom relation, you can create your own extends to Relation abstract class. For example: BelongsToManyThought.

But if you don’t want to implement a Relation, I think that it can fulfill your needs :

In App\Deal.php, you can combine the solution of @thomas-van-der-veen

public function metrics()
{
    return Metric

    ::join('metric_product', 'metric.id', '=', 'metric_product.metric_id')

    ->join('products', 'metric_product.product_id', '=', 'products.id')

    ->join('deal_product', 'products.id', '=', 'deal_product.product_id')

    ->join('deals', 'deal_product.deal_id', '=', 'deal.id')

    ->where('deal.id', $this->id);

}


// you can access to $deal->metrics and use eager loading
public function getMetricsAttribute()
{
    if (!$this->relationLoaded('products') || !$this->products->first()->relationLoaded('metrics')) {
        $this->load('products.metrics');
    }

    return collect($this->products->lists('metrics'))->collapse()->unique();
}

You can refer to this post to see how you can simply use nested relations.

This solution can do the trick for querying relation with method and access to metrics attribute.

More Related Contents:

  1. Can Anyone Explain Laravel 5.2 Multi Auth with Example
  2. Laravel 5.6 – Passport JWT httponly cookie SPA authentication for self consuming API?
  3. How to protect image from public view in Laravel 5?
  4. Laravel – Route::resource vs Route::controller
  5. Laravel Redirect Back with() Message
  6. Persisting sessions across subdomains in Laravel 5
  7. How do I catch exceptions / missing pages in Laravel 5?
  8. Undefined variable: errors in Laravel
  9. Laravel Session always changes every refresh / request in Laravel 5.4
  10. Class ‘Illuminate\Html\HtmlServiceProvider’ not found Laravel 5
  11. Rollback one specific migration in Laravel
  12. Laravel Migration Change to Make a Column Nullable
  13. How to compare two Carbon Timestamps?
  14. Laravel 5.4^ – How to customize notification email layout?
  15. Laravel 5 – Manual pagination
  16. What is difference between use env(‘APP_ENV’), config(‘app.env’) or App::environment() to get app environment?
  17. What is the difference between queue:work –daemon and queue:listen
  18. How to select specific columns in laravel eloquent
  19. 404 Not Found, but route exist in Laravel 5.4
  20. “Please provide a valid cache path” error in laravel
  21. Including a css file in a blade template?
  22. Laravel 5 – artisan seed [ReflectionException] Class SongsTableSeeder does not exist
  23. There is no existing directory at /storage/logs and its not buildable: Permission denied
  24. I’m getting error “Class ‘Predis\Client’ not found” in Laravel 5.2
  25. How to pass multiple parameters to middleware with OR condition in Laravel 5.2
  26. How to insert big data on the laravel?
  27. Modify existing Authorization module (email to username)
  28. Laravel: how to set date format on model attribute casting?
  29. How to execute Stored Procedure from Laravel
  30. How to redirect back to form with input – Laravel 5

Leave a Comment