Trying to use sortBy() or sortByDesc() gives error and last() as well.

This:

            $lastbill = Bill::where('project_id', $project->id)->where('bill_type', 'p')->sortByDesc('created_at')->first();

produces error:

Call to undefined method Illuminate\Database\Eloquent\Builder::sortByDesc()

This:

$lastbill = Bill::where('project_id', $project->id)->where('bill_type', 'p')->last();

produces error:

Call to undefined method Illuminate\Database\Eloquent\Builder::last()

I know the record is there because when I do:

dd(Bill::where('project_id', $project->id)->where('bill_type', 'p')->count());

I get:

Nakov

5 years ago

Level 73

You are trying to use Collection methods on a Eloquent Builder instance.

so this:

 $lastbill = Bill::where('project_id', $project->id)->where('bill_type', 'p')
    ->get() // this should give you collection
    ->sortByDesc('created_at')->first();

same here:

$lastbill = Bill::where('project_id', $project->id)->where('bill_type', 'p')->get()->last();

1 like

MichalOravec

5 years ago

Best Answer

Level 75

Use orderBy, orderByDesc or latest.

$lastbill = Bill::where('project_id', $project->id)
    ->where('bill_type', 'p')
    ->orderByDesc('created_at')
    ->first();

Documentation: https://laravel.com/docs/7.x/queries#ordering-grouping-limit-and-offset

Please or to participate in this conversation.