How to make two WHERE clauses inside a nested WITH

Question

I have the following code snippet

$sectors = Sector::where('company_id', $id)
                 ->where('status', '0')
                 ->with('charges.levels')
                 ->get();

and need 3 conditions

• Status of sector be it 0
• Status of cartoons be it 0
• Status of levels be it 0

So I’d like to know:

• How do I use a WHERE that searches for Charge 0 status and level 0 status being that they are in a nested with: ->with('charges.levels')

The code follows the hierarchy that:

• A sector has one or more positions and a position belongs to one sector only.
• A post has one or more levels and a level belongs to one post only.

Taking into account that I want to bring all levels where the level is status 0, the status 0 position and the status 0 sector

Answer 1

A very clear example on the site is that you can use in advance charge conditions, example:

$users = App\User::with(['posts' => function ($query) {
    $query->where('title', 'like', '%first%');
}])->get();

in your code would be like this:

$sectors = Sector::where('company_id', $id)
             ->with(['charges' => function ($query) {
                   $query->where('status', 0);
                  },'charges.levels' => function($query) {
                    $query->where('status', 0);
                  }])
             ->get();

Ref. Eloquent: Relationships - Constraining Eager Loads

Answer 2

I believe that what you seek is something similar to this, try the following:

$sector = Sector::whereHas('charges', function ($query) use ($search) {
         $query->where('levels', $search);
    })->with('charges.levels')->where('company_id', $id)->get();

I hope I’ve helped.

Answer 3

you can use passed as array:

$query->where([
    ['column_1', '=', 'value_1'],
    ['column_2', '<>', 'value_2'],
    [COLUMN, OPERATOR, VALUE],
    ...
])

Conditions using Array:

$users = User::where([
       'column1' => value1,
       'column2' => value2,
       'column3' => value3
])->get();

Will produce query as below:

SELECT * FROM TABLE WHERE column1=value1 and column2=value2 and column3=value3