Back

Laravel Query Joins with Condition

Copy Below Code View As A Text File Show Text Only Show API Edit Code
                            

$dataQ = $this->myModArr['model']::where($searchArr) ->select('pb_business.*','pb_business.id as busId') ->groupBy('busId'); if($email){ $dataQ->join('pb_users',function($join) use ($email){ $join->on('pb_business.id','=','pb_users.business_id') ->where('pb_users.email','=',$email); }); } if($phone){ $dataQ->join('pb_users',function($join) use ($phone){ $join->on('pb_business.id','=','pb_users.business_id') ->where('pb_users.phone','=',$phone); }); } if($package){ $dataQ->join('pb_payment_business_subscriptions',function($join) use ($package){ $join->on('pb_business.id','=','pb_payment_business_subscriptions.business_id') ->where('pb_payment_business_subscriptions.package_id','=',$package); }); }