laravel 假删除 where多子句 状态值变换

public function index(Request $request){
    if($request->isMethod('post')) {
        $name=$request->input('username');

        $orders = Order::leftJoin('shops', 'shops.id', '=', 'orders.shop_id')
            ->leftJoin('users', 'users.id', '=', 'orders.user_id')
            ->select('orders.*', 'users.name', 'shops.shop_name')
            ->where('orders.is_active','=','0')
            ->where(function($query)use($name){
                    $query ->where('name','like','%'. $name.'%')
                        ->orWhere(function ($query)use($name){
                            $query->where('order_num','like','%'. $name. '%');
                        });
            })->paginate(15);


        return view("admin.order",['orders'=>$orders,'name'=>$name]);
    }

    $name=$request->input('username');
    // 连表查询
    $orders = Order::leftJoin('shops', 'shops.id', '=', 'orders.shop_id')
        ->leftJoin('users', 'users.id', '=', 'orders.user_id')
        ->select('orders.*', 'users.name', 'shops.shop_name')
        ->where('orders.is_active','=','0')
        ->where(function($query)use($name){
            $query ->where('name','like','%'. $name.'%')
                ->orWhere(function ($query)use($name){
                    $query->where('order_num','like','%'. $name. '%');
                });
        })->paginate(15);

    return view("admin.order",['orders'=>$orders,'name'=>$name]);
}

 2，views

<td> {{--orders_id="{{$order->id}}--}}  
     <span class="formlist_handle">
      <a href="{{url('/admin/order/show',['orders_id'=>$order->id])}}" class="formlist_edit"> 查看</a>
      {{--{{url('admin/order/status')}}--}} 
     <span class="formlist_destory change"  is_show="{{$order->is_active}}" data-id="{{$order->id}}" > 删除
</span> </span> 
</td>

 

@section('js') 
<script type="text/javascript"> 

$(".change").click(function () { 
  var is_show = $(this).attr('is_show');  
  var mythis = $(this);  var id = $(this).data("id");  
  if(confirm("确定要删除吗?")){ 
            $.ajax({ url: '/admin/order/status' ,  
                     type:'post',  
                     data: {'is_show': is_show,'id':id},  
                     success: function (data) { location.reload();  } }); 
              } }); 
 </script> 

@endsection

/*  * @订单的删除====>假删除  */ 
public function status(Request $request){ 
   $is_show=$request->is_show;  
   $id = $request->id;  
   if($is_show==0){ 
          $is_show=1;  
   } 
   $res = Order::find($id)->update(['is_active' => $is_show]);   
   return $is_show; 
}