Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $q->whereNotIn('order_stage_id',[99,4])
- ->orWhere(function($query) {
- $query->whereNotIn('order_stage_id',[99,4])
- ->orWhere('reference_number', 'like', '%'.$request->key.'%')
- ->orWhere('seller_remark', 'like', '%'.$request->key.'%')
- ->orWhere('companies.name', 'like', '%'.$request->key.'%')
- ->orWhere('users.name', 'like', '%'.$request->key.'%');
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement