Laravel eloquent query building using OR

Question

This eloquent query filter:

return $this->games()
        ->where(function ($query) {
            $query->where('active_player_id', '=', $this->id)
                ->where('stage_name', '<>', 'setup');
        })
        ->orWhere(function ($query) {
            $query->where('active_player_id', '<>', $this->id)
                ->where('stage_name', '=', 'setup');
        });

Builds into SQL like this:

where `games_players`.`player_id` = '1' 
and (`active_player_id` = '1' and `stage_name` <> 'setup') 
or (`active_player_id` <> '1' and `stage_name` = 'setup')

How do I change the eloquent code to build this query (brackets around the OR):

where `games_players`.`player_id` = '1' 
and (
     (`active_player_id` = '1' and `stage_name` <> 'setup') 
  or (`active_player_id` <> '1' and `stage_name` = 'setup')
    )

Possible duplicate of Laravel Eloquent ORM - Complex where queries — Alex Blex
– Alex Blex, Commented Sep 5, 2017 at 8:36

Abd0m1nals · Accepted Answer · 2017-09-05 08:43:14Z

2

You can achieve that by doing this:

    ->where('active_player_id',1)
    ->where(function($q){
          $q->where([ ['active_player_id', 1],['stage_name','!=', 'setup'] ])
            ->orWhere([ ['active_player_id','!=', 1],['stage_name', 'setup'] ]
    })->get()

edited Sep 5, 2017 at 8:43

answered Sep 5, 2017 at 8:36

Abd0m1nals

2,48615 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bananaapple · Accepted Answer · 2017-09-05 08:36:48Z

0

I don't have an instance of Eloquent to hand to test against just now but would it now be something like this?

return $this->games()
    ->where(function ($query) {
        $query->where(function ($query) {
            $query->where('active_player_id', '=', $this->id)
                ->where('stage_name', '<>', 'setup');
        })
        ->orWhere(function ($query) {
            $query->where('active_player_id', '<>', $this->id)
                ->where('stage_name', '=', 'setup');
        })
    })
;

That is, you put the conditions to be grouped together into an anonymous function on where?

answered Sep 5, 2017 at 8:36

Bananaapple

3,1443 gold badges28 silver badges41 bronze badges

Comments

asimhashmi · Accepted Answer · 2017-09-05 08:41:56Z

0

Try moving your orWhere condition into the first anonymous function like this,

return $this->games()
        ->where(function ($query) {
            $query->where('active_player_id', '=', $this->id)
                ->where('stage_name', '<>', 'setup')
            ->orWhere(function ($query) {
                $query->where('active_player_id', '<>', $this->id)
                    ->where('stage_name', '=', 'setup');
        });
        })

answered Sep 5, 2017 at 8:41

asimhashmi

4,3861 gold badge17 silver badges34 bronze badges

Collectives™ on Stack Overflow

Laravel eloquent query building using OR

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related