Laravel Eloquent : with query parameters

Question

I've finally worked out how to put together a complex query to get related models.

This is what my query currently looks like...

    $campaign = Campaign::find($campaign_id);
    $buyers = $campaign->buyers()->with('notes')->with(['emails' => function($q){
        $q->where('campaign_id', '13');
    }])->get();

The complex part is I'm trying to get entries from emails that have both a matching buyer_id & campaign_id. This query achieves exactly what I'm after in a pretty efficient way...

BUT... I can't work out how to pass in parameters to the with closure. At the moment I've hard coded the id 13 into the where query in the closure but I want it to be equal to $campaign_id passed in to the original function.

How do I do this?

markstewie · Accepted Answer · 2014-11-11 02:55:16Z

23

Worked it out if anyone has same problem... need to use use statement

    $campaign = Campaign::find($campaign_id);
    $buyers = $campaign->buyers()->with('notes')->with(['emails' => function($q) use ($campaign_id){
        $q->where('campaign_id', $campaign_id);
    }])->get();

Is this documented anywhere?

answered Nov 11, 2014 at 2:55

markstewie

9,74710 gold badges52 silver badges73 bronze badges

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

2 Comments

ceejayoz Over a year ago

It's a core PHP feature. I doubt it's in the Laravel docs for that reason.

markstewie Over a year ago

Ha.. really!? Shows what a PHP rookie I am. Thanks

Jasim Juwel · Accepted Answer · 2017-12-07 07:08:20Z

TRY With This

$mainQuery=StockTransactionLog::with(['supplier','customer','warehouse','stockInDetails'=>function($query) use ($productId){
            $query->with(['product'])->where('product_stock_in_details.product_id',$productId);
        },'stockOutDetails'=>function($query) use ($productId){
            $query->with(['product'])->where('product_stock_out_details.product_id',$productId);
        },'stockDamage'=>function($query) use ($productId){
            $query->with(['product'])->where('product_damage_details.product_id',$productId);
        },'stockReturn'=>function($query) use ($productId){
            $query->select('id','return_id','product_id');
            $query->with(['product'])->where('product_return_details.product_id',$productId);
        }]);

JayminLimbachiya · Accepted Answer · 2017-06-10 11:22:34Z

1

$latitude = $request->input('latitude', '44.4562319000');
$longitude = $request->input('longitude', '26.1003480000');
$radius = 1000000;

$locations = Locations::selectRaw("id, name, address, latitude, longitude, image_path, rating, city_id, created_at, active,
                     ( 6371 * acos( cos( radians(?) ) *
                       cos( radians( latitude ) )
                       * cos( radians( longitude ) - radians(?)
                       ) + sin( radians(?) ) *
                       sin( radians( latitude ) ) )
                     ) AS distance", [$latitude, $longitude, $latitude])
    ->where('active', '1')
    ->having("distance", "<", $radius)
    ->orderBy("distance")
    ->get();

answered Jun 10, 2017 at 11:22

JayminLimbachiya

1,0061 gold badge14 silver badges19 bronze badges

Comments

Akbar Noto · Accepted Answer · 2020-06-26 23:29:40Z

0

$fpr = FPR::with([
  'detail','of_permintaan.detail', 
  'of_permintaan.detail.pembelian'=>function($q)use($id){
       return $q->where('pembelian_id',$id);}
])->findOrFail($id);

Well, in case u need to pass it on its child-child relation, but i don't recomend it

answered Jun 26, 2020 at 23:29

Akbar Noto

6197 silver badges13 bronze badges

Collectives™ on Stack Overflow

Laravel Eloquent : with query parameters

4 Answers 4

2 Comments

TRY With This

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

TRY With This

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related