Where conditions on eloquent relationship

posted 10 years ago

I have two tables auctions and bids and models for them are as follows

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

public function auction()
{
return $this->hasMany('\App\Bids');
}

on my controller I am doing

$details = Auction::where('operator','=',$operator)
        ->where('end_time','>=', $timenow)
        ->with('bid')
        ->get();

when I do this I get all the records for matching auction in the bids table, what i actually want is to get the highest bid fo the matching auction from the bids table

Last updated 3 years ago.

mengidd

replied 10 years ago

This is described in the documentation under Eloquent and querying relationships (whereHas). That's the first place you should look.

khanof89

replied 10 years ago

I did this

$details = Auction::where('operator','=',$operator)
        ->where('end_time','>=', $timenow)
        ->whereHas('bid', function($q)
        {
            $q->max('bid_amount');
        })
        /*->with('bid')*/
        ->paginate(12);

and this doesn't works

Moderators