DEV Community

loading...

Discussion on: Making the advanced search query with Eloquent-Builder in Laravel

Collapse
mohammadfouladgar profile image
Fouladgar.dev Author

Thanks you for your kind words ;)

It was an interesting example.

Thank you for sharing.

Collapse
farrukh_uet profile image
Farrukh

Thanks for your appreciation.

Thread Thread
farrukh_uet profile image
Farrukh

Hi,
Can we do sorting for eloquent relations?

Thread Thread
mohammadfouladgar profile image
Fouladgar.dev Author

Yes,you can.
EloquentBuilder return an instance of Builder:

return EloquentBuilder::to(Blog::class,$filters)->with('latestPost')->OrderByDesc('latestPost.created_at')->get();
Thread Thread
farrukh_uet profile image
Farrukh

Thanks a lot for your reply.

I did not try it yet. Hope it will work as I wish.

Regards

Thread Thread
farrukh_uet profile image
Farrukh

Hi,

I used laravel debugger, when I used Eloquent Builder it shows me a (lot) number of queries.

is it normal or there is some method to reduce that

Regards
Farrukh

Thread Thread
mohammadfouladgar profile image
Fouladgar.dev Author

Hi,

The EloquentBuilder reduces the complexity of the queries and conditions of the code.Number of queries is not related to it.

Good luck

Thread Thread
farrukh_uet profile image
Farrukh

Thanks a lot dear

Collapse
farrukh_uet profile image
Farrukh • Edited

Also if you want to implement a filter for a columns against multiple values.
For example following is the array you mentioned in example, but with gender filter as an array.

[
'age_more_than' => '25',
'gender' => ['male','female','custom']
'has_published_post' => 'true',
]

class GenderFilter extends Filter
{

public function apply(Builder $builder, $value): Builder
{

    if(is_array($value)){
        return $builder->whereIn('gender', $value);
    }

    return $builder->where('gender', '=', $value);
}

}

Thread Thread
mohammadfouladgar profile image
Fouladgar.dev Author

Nice.

Type of the value parameter is mixed and you can set it to any value based on your requirement.

Thanks Dear @Farrukh