/**
  * Display a listing of the others borrow.
  *
  * @param Request $request
  * @return \Illuminate\Http\Response
  */
 public function index(Request $request)
 {
     // get length
     $length = $request->input('length') > 0 ? $request->input('length') : 10;
     $loan_type = Category::getCategoryId('loan.type', $request->input('type'));
     // get borrow query
     $borrow_query = Loan::with(['type', 'status'])->join('properties as pro_t', function ($query) {
         $query->on('pro_t.id', '=', 'property_id')->where('pro_t.category', '=', Category::getCategoryId('property', 'others'));
     })->where('user_id', '=', Auth::user()->id);
     // if loan type is set
     $borrow_query = $loan_type > 0 ? $borrow_query->where('type', '=', $loan_type) : $borrow_query;
     // get borrow list
     $borrow_list = $borrow_query->paginate($length, ['loans.*', 'pro_t.name as property_name']);
     return response()->json($borrow_list);
 }
 /**
  * Display a listing of the classroom borrow list.
  *
  * @param Request $request
  * @return Json
  */
 public function indexClassroomBorrow(Request $request)
 {
     // get length
     $length = $request->input('length') > 0 ? $request->input('length') : 10;
     $loan_type = Category::getCategoryId('loan.type', $request->input('type'));
     $loan_status = Category::getCategoryId('loan.status', $request->input('status'));
     // get borrow array
     $borrow_query = Loan::with(['user', 'type', 'status'])->join('properties as pro_t', function ($join) {
         $join->on('pro_t.id', '=', 'property_id')->where('pro_t.category', '=', Category::getCategoryId('property', 'classroom'));
     });
     // if loan type/status is set
     $borrow_query = $loan_type > 0 ? $borrow_query->where('type', '=', $loan_type) : $borrow_query;
     $borrow_query = $loan_status > 0 ? $borrow_query->where('loans.status', '=', $loan_status) : $borrow_query;
     // get borrow list
     $borrow_list = $borrow_query->paginate($length, ['loans.*', 'pro_t.name as property_name']);
     return response()->json($borrow_list);
 }