belongsToMany, pivot table and multiple condition

In your user model you should set 2 relations.

• topicSent (hasMany)
• topicReceived (belongsToMany (i.e. Many-to-Many))

And then, load your 2 relations.

OK, got it.

And what would be the correct syntax to then get both in the same result?

$users = User::with('topicsSent')->with('topicsReceived')->get();

dd($users);

Something like that

Of course! "with" twice! Didn't think about that... THANKS!

or using a single with $users = User::with(['topicsSent', 'topicsReceived'])->get();

Execept I'm not looking for the users... but for the messages.

So it doesn't work.

So far, I get that working:

$receivedTopics = Messengertopic::whereHas('receiver', function ($query) use ($userId) { $query->where('id', $userId); })->get();

$sentTopics = MessengerTopic::where('sender_id', $userId)->orderBy('sent_at', 'desc')->get();

But I also need $topics, combining both results above ordered by date...

For a given "$userId = Auth::user()->id;" I'm trying to get:

So... what do you need ?

With the relation, you retrieve one user, and in the relation of the collection, all these messages.

For a given "$userId" I'm trying to get:

ALL the messages he sent ALL the messages he received

Actually, my problem can be recap as this:

HOW to combine those two things

$receivedTopics = Messengertopic::whereHas('receiver', function ($query) use ($userId) { $query->where('id', $userId); })->get();

$sentTopics = MessengerTopic::where('sender_id', $userId)->orderBy('sent_at', 'desc')->get();

$allTopics=???????;

$user = User::with('topicsSent')->with('topicsReceived')->find(Auth::id());

$receivedTopics = $user->topicsReceived;
$sentTopics = $user->sentTopics;
$allTopics = $receivedTopics->merge($sentTopics); //be carefull, I don't know if it will erase some data considered as duplicate.

Or ask the inverse relationship, something like :

$user_id = Auth::id(); //I'm not sure that Auth::id() is available in anonymous function... so just in case.
$allTopics = Topics::whereHas('receiver', function ($query) use ($user_id) {
        $query->where('receiver_id', '=', $user_id);
    })
    ->orWhereHas('sender', function ($query) use ($user_id) {
        $query->where('sender_id', '=', $user_id);
    })->get();

merge! That exactly what I was looking for :-)

Big thanks!

My pleasure.

Mark it at resolve to keep this forum clean.