public function query(Request $request) { $validator = Validator::make($request->all(), ['currentPage' => 'required', 'items_per_page' => 'required']); if ($validator->fails()) { return Response::json(array('result' => false, 'data' => 'Some parameter not found.')); } $status = $request->input('status'); $order = $request->input('order'); if ($status != null || $order != null) { return $this->search($request); } $parpage = $request->input('items_per_page'); $page = $request->input('currentPage'); $skip = ($page - 1) * $parpage; $order = Orders::orderBy('updated_at', 'desc')->skip($skip)->take($parpage)->get(); foreach ($order as $key => $value) { # code... $value->member = Member::where('id', $value->members_id)->first(); } //dd($order); $count = Orders::count(); return Response::json(array('result' => true, 'data' => $order, 'count' => $count, 'mode' => 'init', 'skip' => $skip)); }