Adding brackets in laravel query (laravel 5)

My query laravel is like this :

$customer = Customer::where('full_name', 'iLIKE', '%'.$param['keyword'].'%')
                                ->orWhere('mobile', 'iLIKE', '%'.$param['keyword'].'%')
                                ->orWhere('phone', 'iLIKE', '%'.$param['keyword'].'%')
                                ->where('published','1')
                                ->where('customer_status','N')
                                ->orderBy('full_name', 'ASC')->get();

If I print regular query use this :

DB::listen(function($sql, $bindings, $time) {
            \Log::info($sql);
            \Log::info(print_r($bindings,1));
            \Log::info($time);
        });

The result :

select * from "ss_customer" 
where "full_name" iLIKE '%ronaldo%' or "mobile" iLIKE '%ronaldo%' or "phone" iLIKE '%ronaldo%' and "published" = 1 and "customer_status" = 'N' 
order by "full_name" asc

I would like to add brackets so the query becomes like this :

select * from "ss_customer" 
where ("full_name" iLIKE '%ronaldo%' or "mobile" iLIKE '%ronaldo%' or "phone" iLIKE '%ronaldo%') and "published" = 1 and "customer_status" = 'N' 
order by "full_name" asc

How to add brackets in laravel query?

Thank you

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/1ZK4clf
via IFTTT