Eloquent Object - Method Chaining

Question

I have the following Laravel Eloquent code, where there will be a lot of method chaining:

$foo = EloquentFoo::orderBy('xyz');

if(true)
{
    $foo->whereHas('eloquentModel',function($q){
        return $q->where('name','=','john');
    });
}

Given complex conditions, i need to instantiate the Eloquent Query Builder without using 'orderBy' or any other static methods.

I tried using the following, which fails miserably(don't know why):

$foo = new EloquentFoo;

http://stackoverflow.com/a/23599775/358906 and the other answer below it. — Nabil Kadimi, Nov 18 '14 at 12:50

score 3 · Accepted Answer · answered Nov 18 '14 at 13:49

3

// get the query
$fooQuery = EloquentFoo::query();

// chain methods    
if (whatever) $fooQuery->whateverMethod();

// execute
$fooQuery->get();

answered Nov 18 '14 at 13:49

Jarek Tkaczyk

78,987
25
159
157

Answer is spot on :) Thanks! – Mysteryos Nov 18 '14 at 15:25

score 0 · Answer 2 · answered Nov 18 '14 at 13:25

A simple way around: I compare my primary key to something non-existing (not an OPTIMAL solution), would be interested to see the other solutions, though I thought this could help:

$foo = EloquentFoo::where('id','!=','0'); // id is the primary key and there is no row with value 0
// so basically above I am searching everything
// Perform Chaining Operation 
if(true)
{
    $foo->whereHas('eloquentModel',function($q){
        return $q->where('name','=','john');
    });
}

Note: You can use id as many times in the chain as you want and it would still work:

EloquentFoo::where('id','!=','0')->where('id','!=','0')->get()

Hopefully it helps ( I know it is not at all OPTIMAL).

Hehe, i added a `whereNull('deleted_at')` to go around the problem. Jarek gave the proper way to do it above :) — Mysteryos, Nov 18 '14 at 15:26
Yea, the answer looks more promising..thanks a lot for the question :) — Chintan Parekh, Nov 22 '14 at 11:42

Eloquent Object - Method Chaining

2 Answers2