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]);}

<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;}