HasManyThrough with one-to-many relationship

by

You can’t do it with builtin methods, hasManyThrough won’t work with many-to-many relation menus-pages.

However you can try a workaround like this:

public function getTranslationsAttribute()
{
    if ( ! array_key_exists('translations', $this->relations)) $this->loadTranslations();

    return $this->getRelation('translations');
}

protected function loadTranslations()
{
    $translations = Translation::join('menu_page', 'translations.page_id', '=', 'menu_page.page_id')
        ->where('menu_page.menu_id', $this->getKey())
        ->distinct()
        ->get(['translations.*','menu_id']);

    $hasMany = new Illuminate\Database\Eloquent\Relations\HasMany(Translation::query(), $this, 'menu_id', 'id');

    $hasMany->matchMany(array($this), $translations, 'translations');

    return $this;
}

Now you can do this:

$menu = Menu::find($id);
$menu->translations; // Eloquent Collection of Translation models

So basically just like you would use any relation. The only trouble is that you can’t eager load it.

More Related Contents:

  1. Laravel – Eloquent “Has”, “With”, “WhereHas” – What do they mean?
  2. Migration: Cannot add foreign key constraint
  3. Laravel Eloquent groupBy() AND also return count of each group
  4. Eloquent Collection: Counting and Detect Empty
  5. Eloquent eager load Order by
  6. Laravel Eloquent vs DB facade: Why use Eloquent and decrease performance? [closed]
  7. Laravel. Use scope() in models with relation
  8. Laravel Eloquent “WHERE NOT IN”
  9. Getting just the latest value on a joined table with Eloquent
  10. Laravel Migration Change to Make a Column Nullable
  11. Select Last Row in the Table
  12. How to get distinct values for non-key column fields in Laravel?
  13. How to select specific columns in laravel eloquent
  14. How to access model hasMany Relation with where condition?
  15. Eloquent push() and save() difference
  16. Laravel Eloquent – distinct() and count() not working properly together
  17. Laravel save / update many to many relationship
  18. First Or Create
  19. Laravel: Returning the namespaced owner of a polymorphic relation
  20. How to setup conditional relationship on Eloquent
  21. Polymorphic Eloquent relationships with namespaces
  22. Laravel Eloquent – Where In All
  23. Clone an Eloquent object including all relationships?
  24. How to fetch data from multiple table according to id by using query builder in laravel
  25. Laravel 5.6 – Passport JWT httponly cookie SPA authentication for self consuming API?
  26. Add new methods to a resource controller in Laravel
  27. How to keep Laravel Queue system running on server
  28. Laravel Fluent Query Builder Join with subquery
  29. How to Make Laravel Eloquent “IN” Query?
  30. Laravel Eloquent sort by relation table column

Leave a Comment