Laravel Eloquent not returning join table

Question

I have the following function that joins 2 models.

$listing = Game::where('status', '2')->whereHas('transaction', function ($query) use($id) {
    $query->where('status',1)->where('transaction_id', Crypt::decrypt($id));
})->get();

I have a Game model that has the following code.

protected $table = 'game_listings';
protected $primaryKey = 'id';
protected $fillable = ['user_id','asset_id','trade_id','market_name','name','picture','description','price','status','clicks'];
protected $dates = ['deleted_at'];

/*
|--------------------------------------------------------------------------
| RELATIONS
|--------------------------------------------------------------------------
*/
public function user()
{
    return $this->belongsTo('App\Models\User');
}

public function transaction()
{
     return $this->hasOne('App\Models\GameTransaction','listing_id','id');
}

I also have a GameTransaction model that has the following code.

protected $table = 'game_transactions';
protected $primaryKey = 'id';
protected $fillable = ['listing_id', 'transaction_id', 'payee_id'];
protected $dates = ['deleted_at'];

The problem I'm having is the $listing variable is only returning data from the game_listings table, and nothing from the game_transactions table.

Andriy Lozynskiy · Accepted Answer · 2017-08-14 23:54:06Z

3

whereHas doesn't load relations. You should use with for this. Try:

   Game::where('status', '2')->whereHas('transaction', function ($query) use($id) {
    $query->where('status',1)->where('transaction_id', Crypt::decrypt($id));
})->with('transaction')->get()

edited Aug 14, 2017 at 23:54

answered Aug 14, 2017 at 23:48

Andriy Lozynskiy

2,6142 gold badges23 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andriy Lozynskiy Over a year ago

@Curtis no problem

Collectives™ on Stack Overflow

Laravel Eloquent not returning join table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related