1,控制器
/*
* @商品订单的首页
*/
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('name','like','%'. $name.'%')
->orWhere('order_num','like','%'. $name. '%')
->paginate(15);
return view("admin.order",['orders'=>$orders,'name'=>$name]);
}
$name=$request->input('name');
$orders = Order::leftJoin('shops', 'shops.id', '=', 'orders.shop_id')
->leftJoin('users', 'users.id', '=', 'orders.user_id')
->select('orders.*', 'users.name', 'shops.shop_name')
->where('name','like','%'. $name.'%')
->orWhere('order_num','like','%'. $name. '%')
->paginate(15);
return view("admin.order",['orders'=>$orders]);
}
1,view
<form action="{{url('admin/order/')}}" method="post">
<input type="text" placeholder="输入订单号或下单用户" name="username" value="">
</form>
<div class="boot_fenye">
<div class="boot_choose">
{{$orders->appends(array('name'=>@$name))->render()}}
</div>
</div>