withTrashed on hasManyThrough relation

Question

How can withTrashed be applied on a hasManyThrough relation ?

$this->hasManyThrough('App\Message', 'App\Deal')->withTrashed();

returns

Call to undefined method Illuminate\Database\Query\Builder::withTrashed()

when i'm doing:

$messages = Auth::user()->messages()->with('deal')->orderBy('created_at', 'DESC')->get();`

Here is my Deal model:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Deal extends Model
{

    use SoftDeletes;

    /* ... */

    protected $dates = ['deleted_at'];

    public function user() {
        return $this->belongsTo('App\User');
    }

    public function messages() {
        return $this->hasMany('App\Message'); // I've tried to put withTrashed() here, there is no error but it doesn't include soft deleting items.
    }
}

Answer 1

To all those coming to this late, there is now a native way of doing this with Laravel.

$this->hasManyThrough('App\Message', 'App\Deal')->withTrashedParents();

This is not well documented but can be found in Illuminate\Database\Eloquent\Relations\HasManyThrough

Answer 2

The error is thrown because you are requesting a messages with deleted ones without using SoftDelete trait in Message model.

After I check the hasManyThrough relation code I found that there is no way to do it in this way, you should play around.

Ex:

get the deals of user with messages instead

$deals = Auth::user()->deals()->withTrashed()->with('messages')->get();
foreach($deals as $deal) {
     //Do your logic here and you can access messages of deal with $deal->messages
}