/** * Display a listing of the resource. * * @return Response */ public function index(Request $request) { $borrow = Borrow::with('book'); $borrow->orderBy('borrow_id', 'DESC'); if ($request->username != "") { $borrow->where('username', 'like', "%" . $request->username . "%"); } if ($request->book_press != "") { $borrow->where('userno', 'like', "%" . $request->userno . "%"); } $lists = $borrow->paginate(15); return view('borrowlist', array('borrows' => $lists->toArray(), 'pages' => $lists->render(), 'request' => $request)); }