$data = Orders::join('order_details','order_details.orders_id','=','orders.id')
->join('users','users.id','=','orders.user_id')
->select('orders.*','order_details.total_pay','users.first_name','users.last_name')
->where(function($query) use ($user_name,$promotion_code,$status){
$query->orwhereRaw("concat(first_name, ' ', last_name) like '%$user_name%'")
->Where('promotion_code', $promotion_code)
->Where('status', $status);
});
1.When I search all three data at the same time it's ok . But why I input 1/3 data or 2/3 data it doesn't filter?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire