Eager loading with parameters - laravel

Question

I have Banks table and separate table with services

$bank = Banks::find(1);
echo $bank->service(1); // print bank with that service (serviceId 1)

It is posible to eager load all banks with service_id =1 ..somewhat like

Bank::with('service(1)')->get();

Thank you in advance

You mean to do like this **where service_id in (1)** inside model ? — Sulthan Allaudeen, Dec 25 '14 at 07:19

score 18 · Accepted Answer · answered Dec 25 '14 at 07:47

18

Sure! The with method accepts a closure to filter eager loading.

Bank::with(array('service' => function($query){
    $query->where('id', 1);
}))->get();

answered Dec 25 '14 at 07:47

lukasgeiter

6

You can add/pass your own parameter using "use" ` Bank::with(array('service' => function($query) use ($param){ $query->where('id', $param); }))->get(); ` – Tom Nov 29 '16 at 15:57
1

@Tom, you saved my day! I have been looking for this for one hour and until now I haven't found anyone who specifies how to pass a parameter here. Thanks!!! – Janbalik Jan 26 '21 at 12:28

score 0 · Answer 2 · answered Dec 25 '14 at 07:45

Use WhereIn to your Model and you shall pass any number inside the Array.

$Data = Banks::whereIn('service_id ', array(1, 2, 3))->get();
var_dump($Data);

I am using var_dump and you shall choose your own coloumn to get your need.

score 0 · Answer 3 · answered Sep 04 '20 at 06:58

0

You can use this

return User::with(['posts' => function($query){
              $query->whereNotIn('id',[1]);
            }])
           ->get();

answered Sep 04 '20 at 06:58

3 Answers3