Laravel Eloquent - get last insert of related model

Question

I have a relationship between two models: Terminal and terminalRent.

A Terminal can have many terminalRents. I want to get the last Rent for a specific Terminal.

$lastRent = Terminal::with('terminalRent')->where('id', $id)->orderBy('id', 'desc')->first();

When using where() it will reflect those on the Modal hoewever I want to get the last record for terminalRent in relation to the specific terminal. $id is the Id of the terminal and the tables are connected like this:

Terminal
----
ID


terminalRent
-----
ID
terminal_id <--- this is the foreign key for the ID of the Terminal Table

Answer 1

If the relationship between Terminal and Terminal rent is hasMany you can do something like:

$lastRented = $lastRent->terminalRent->last();

Ensure you have the last rented via dd($lastRented);

Let me know how you get on

Edit: If this gives you the incorrect instance of terminalRent try first(); I can't remember how Eloquent orders eagerlaoded relationships by default.

Answer 2

@Parithiban Solution is very useful but this function run one query two times

for better performance try this

$lastRent =  Terminal::with(['terminalRent' => function ($query) { 
  return $query->orderBy('id', 'desc')->limit(1);
}]);