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

View post

Replies for: Hi, First of all thanks for your easy and great solution. I found many solutions for eloquent search filters, but this is discrete :). I felt that...

Fouladgar.dev • Feb 8 '20

Thanks you for your kind words ;)

It was an interesting example.

Thank you for sharing.

Farrukh • Feb 8 '20

Thanks for your appreciation.

Farrukh • Feb 12 '20

Hi,
Can we do sorting for eloquent relations?

Fouladgar.dev • Feb 15 '20

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

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

Farrukh • Feb 18 '20

Thanks a lot for your reply.

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

Regards

Farrukh • Feb 18 '20

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

Fouladgar.dev • Feb 18 '20

Hi,

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

Good luck

Farrukh • Feb 18 '20

Thanks a lot dear

Farrukh • Feb 8 '20 • 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);
}

}

Fouladgar.dev • Feb 9 '20

Nice.

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

Thanks Dear @Farrukh