Combinations of filters can be optional laravel eloquent relationships

Question

I want to filter replies based on query parameter passed, query parameters can be post_id, comment_id and array of reply_ids all can be optional and can be used as combination

 $query = Post::where('user_id', auth()->id());
    if ( isset($data['reply_ids']) ) {
        $query = $query->with('posts.comments.replies')->whereHas('posts.comments.replies', function($query) use ($data){
            $query->whereIn('id', $data['reply_ids']);
        });
    }

Now, if I want to filter again with comment authors, that is on comments table, if I want to add filters of post author, that will be on posts table, how I can add those conditional, and still that will be optional?

score 0 · Answer 1 · answered Sep 30 '19 at 13:16

0

Just add another if statements below. Those will be optional, sice you define your $query before your first filtering action.

answered Sep 30 '19 at 13:16

Norbert Jurga

204
4
14

Out side closer it is User model, so I can not filter post author or comment author. – Prafulla Kumar Sahu Sep 30 '19 at 13:58

score 0 · Accepted Answer · answered Oct 01 '19 at 07:56

I needed to use another eager loading with so that the query will be build on all the combination selected, so the final code will be something like

$query = Post::where('user_id', auth()->id());
if ( isset($data['reply_ids']) ) {
    $query = $query->with('posts.comments.replies')->whereHas('posts.comments.replies', function($query) use ($data){
        $query->whereIn('id', $data['reply_ids']);
    });
}
$query = $query->with(['posts' => function($query){ $query->where('status', 'pending'); }])

$query->get()

Combinations of filters can be optional laravel eloquent relationships

2 Answers2