public function init(Request $request) { $rules = array('page' => 'required', 'pageSize' => 'required'); $validator = \Validator::make($request->all(), $rules); if ($validator->fails()) { return \Response::json(array('result' => false, 'msg' => 'Please check your input again.')); } $pageSize = $request->input('pageSize'); $page = $request->input('page'); $skip = ($page - 1) * $pageSize; //$publisher_id = $request->input('publisher_id'); //$products_id = $request->input('products_id'); $keyword = $request->input('keyword'); $productsid = $request->input('productsid'); $count = 0; if ($keyword == null && $productsid == null) { $vol = Products_vol::orderBy('created_at', 'desc')->skip($skip)->take($pageSize)->get(); $count = Products_vol::count(); foreach ($vol as $key => $value) { # code... $value->product = Products::where('id', $value->products_id)->first(); } return \Response::json(array('result' => true, 'data' => $vol, 'total' => $count, 'mode' => 'init')); } else { //$products = \DB::table('v_search_product')->where('name' , 'LIKE' , '%'.$keyword.'%')->first(); $products_vol = Products_vol::where('products_id', $productsid)->skip($skip)->take($pageSize)->get(); $count = Products_vol::where('products_id', $productsid)->count(); foreach ($products_vol as $key => $value) { # code... $value->product = Products::where('id', $value->products_id)->first(); } return \Response::json(array('result' => true, 'data' => $products_vol, 'total' => $count, 'productsid' => $productsid)); } return \Response::json(array('result' => false, 'data' => $vol, 'total' => $count, 'mode' => 'false')); }