orWhereHas - parameter grouping on Eloquent query - how do I do this in Laravel?

Question

In an eloquent query I am building, I am placing a constraint on a `has` relationship using Laravel 4.1's `whereHas` and `orWhereHas` methods. In the example soccer application, I wish to place a constraint on the `homeClub` and `awayClub` relationships so that I can the result set will select where the homeClub = Arsenal OR awayClub = Arsenal. This issue has evolved from an earlier question It seems that when using the `orWhereHas` method - the resulting sql doesn't group the `or` constraint. The query (relevant excerpt that is placing the constraints): ``` $ret ->where( function( $subquery ) use ( $ret ){ $ret->whereHas('homeClub', function ( $query ){ $query->where('name','Arsenal' ); })->orWhereHas('awayClub',function ( $query ){ $query->where('name','Arsenal' ); }); }) ->where( function ( $subquery ) use ( $ret, $parameterValues ){ $ret->whereHas('season', function ($query) use ( $parameterValues ){ $query->where('name', $parameterValues['season_names'] ); }); } ) ->whereHas('ter…

Accepted Answer

You need to reference the query passed through to the where closure. Otherwise you are adding the grouped where clauses to the main query bypassing any groupings:

```
$ret
->where( function( $query ){
    $query->whereHas('homeClub', function ( $subquery ){
        $subquery->where('name','Arsenal' );
    })
    ->orWhereHas('awayClub',function ( $subquery ){
        $subquery->where('name','Arsenal' );
    });
})
->where( function ( $query ) use ( $parameterValues ){
    $query->whereHas('season', function ($subquery) use ( $parameterValues ){
        $subquery->where('name', $parameterValues['season_names'] );
    });
})
->whereHas('territory',function( $query ) use ( $parameterValues ){     
    $query->where('region','Australia');
})
->get();
```

orWhereHas - parameter grouping on Eloquent query - how do I do this in Laravel?

Solution

Problem

Related problems