CODEWITHSUNDEEP
phplaraveleloquentpolymorphism
Andrew Willis
Andrew Willis

Reputation: 2349

Retrieving all morphedByMany relations in Laravel Eloquent

In the Laravel documentation, there is the following example for retrieving morphedByMany relations, which are many-to-many polymorphic relations.

Laravel Many to Many polymorphic relations documentation

namespace App;

use Illuminate\Database\Eloquent\Model;

class Tag extends Model
{
    /**
     * Get all of the posts that are assigned this tag.
    */
    public function posts()
    {
        return $this->morphedByMany('App\Post', 'taggable');
    }

    /**
     * Get all of the videos that are assigned this tag.
     */
    public function videos()
    {
        return $this->morphedByMany('App\Video', 'taggable');
    }
}

How would I get a list of all morphed relations in one query / collection, for instance, posts and videos, and then if I later added photos (or anything), that too?

Upvotes: 28

Views: 14935

Answers (3)

iPaat
iPaat

Reputation: 840

I use a trick here:

Create a Model Taggable for your connection table taggable and add a hasMany relation to the Tag model.

public function related()
{
    return $this->hasMany(Taggable::class);
}

Within your Taggable model create a morphedTo relation.

public function taggables()
{
    return $this->morphTo();
}

Now you can get all models which are using the tag by calling:

$tagged = Tag::with('related.taggables');

Upvotes: 27

Simone Cabrino
Simone Cabrino

Reputation: 931

Did you think to use the "union" function of the collections to merge all the different collection in order to retrieve all what you need?

class Tag extends Model
{
    [...]

    /**
     * Get all of.
     */
    public function morphed()
    {
        return $this->video->union($this->posts)->all();
    }
}

Upvotes: 3

KiaiFighter
KiaiFighter

Reputation: 667

You should be able to add a relationship on your Tag class as such

public function taggable()
{
    return $this->morphedTo();
}

That will use the taggable_id and taggable_type to get the relevant Model that it is tied to.

Upvotes: -2

Related Questions