How to convert the following Laravel (v8) Query to Eloquent? That is possible?
'house_id' => DB::table('houses') ->select('id') ->where('user_id', Auth::user()->id) ->orderByDesc('created_at')->value('id')
The current query is doing the job, but I'm curious to know if the same can be done with Eloquent. In other words, there's a more elegant way to do the same?
Sorry if my question doesn't make sense at all.
Thank you very much for any clarification.
Laravel has a latest() function on the query builder which orders results in descending order by created_at date. So you could simplify your query to as follows:
House::where('user_id', Auth::user()->id)->latest()->first()->id;
This might look confusing, latest()->first(), but latest() returns a collection so if you use first() to access the most recent record and then grab the id from the model.
If you find yourself using the above frequently, you could take it further and define a scope on your User model.
public function houses()
{
return $this->hasMany(House::class);
}
public function scopeLatestHouse(Builder $query) {
return $this->houses()->latest()->first();
}
Now all you need to do is:
$latestHouse = Auth::user()->latestHouse()->id;
If your model is called House : $house = House::query()->where('user_id', Auth::user()->getAuthIdentifier())->select('id')->orderBy('created_at', 'DESC')->get() or use ->first() if you want to get only one element. Then you can call $house->id.
select('id') only select the id of the house, you can also use ->first('id') instead of ->select('id) and ->get()DB::table('houses') ->select('id') ->where('user_id', Auth::user()->id) ->orderByDesc('created_at')->value('id'); Returns 50 (for instance) House::query()->where('user_id', Auth::user()->getAuthIdentifier())->orderBy('created_at', 'DESC')->first('id') Returns the follow: App\Models\House {#1442 ▼ #table: "houses" #guarded: [] #fillable: array:8 [▶] # ... #attributes: array:1 [▼ "id" => 50 ] How to grab the ID?