Searching from model and related model in laravel5

Question

I want to keyword search from a table and its all related table using Elequent in Laravel5. My controller is

 $clients = Client::with('contacts', 'paymentTerm', 'addressInfo');
    if ($q = Request::input("q")) {
        $clients->where("clients.name", 'LIKE', "%$q%");
        $clients->where("address_info.email", 'LIKE', "%$q%");//This is not working,I want to search from both client and client address_info
    }
    return $clients->paginate(10);

Client Model ,

 public function addressInfo() {
    return $this->hasOne('App\Model\ClientAddressInfo');
}

Client Address info,

public function client() {
        return $this->belongsTo('App\Model\Client');
    }

how can I apply keyword search here?

score 2 · Accepted Answer · answered Mar 08 '15 at 15:19

2

You can use whereHas to filter by a related model:

$clients->whereHas('addressInfo', function($query) use ($q){
    $query->where("email", 'LIKE', "%$q%");
});

answered Mar 08 '15 at 15:19

lukasgeiter

147,337
26
332
270

Thank you for answer and it is working,but the problem is two conditions are joining here with "and", how it make "or" ? – gsk Mar 08 '15 at 15:33
Simply use `orWhereHas` instead of `whereHas` (it works the same as with two "normal" `where`s) – lukasgeiter Mar 08 '15 at 15:35
How can i sort from related model `$clients->orderBy('addressInfo.email');`? – gsk Mar 08 '15 at 16:22
Unfortunately that's just possible if you use a join. [See this](http://stackoverflow.com/q/23530051/1903366) – lukasgeiter Mar 08 '15 at 16:33
So I need to change Elequent method to db method ? – gsk Mar 08 '15 at 16:37
You can still use Eloquent but not the relation – lukasgeiter Mar 08 '15 at 16:41

Searching from model and related model in laravel5

1 Answers1