public function store_category_product(Request $request) { $name = $request->name; $id = $request->id; if ($id == null) { $category = new CategoryProduct(); } else { $category = CategoryProduct::find($id); } $category->name = $name; $category->save(); return redirect('manage/categories'); }
public function news_feed_load_more(Request $request) { $limit = 40; $page = $request->page; $class_name = $request->class_name; $category_id = $request->category_id; if ($class_name != null) { $class = DB::select("select * from classes where replace(name,' ','') like ?", [$class_name])[0]; $usersIdOfThisClass = StudyClass::find($class->id)->registers()->select(DB::raw('user_id'))->get()->pluck('user_id'); $products = Product::whereIn('author_id', $usersIdOfThisClass)->orderBy('created_at', 'desc')->skip($page * $limit)->take($limit)->get(); } else { if ($category_id != null) { $category = CategoryProduct::find($category_id); $products = $category->products()->orderBy('created_at', 'desc')->skip($page * $limit)->take($limit)->get(); } else { $type = $request->type; if ($type == 3) { $products = Product::orderBy('created_at', 'desc')->where('type', '=', 2)->skip($page * $limit)->take($limit)->get(); } else { if ($type == 2) { $products = Product::orderBy('rating', 'desc')->skip($page * $limit)->take($limit)->get(); } else { // $class = DB::select("select * from classes where replace(name,' ','') like ?", [$class_name])[0]; // $usersIdOfThisClass = StudyClass::find($class->id)->registers()->select(DB::raw('user_id'))->get()->pluck('user_id'); // $products = Product::whereIn('author_id', $usersIdOfThisClass)->orderBy('created_at', 'desc')->take($limit)->get(); $products = Product::orderBy('created_at', 'desc')->skip($page * $limit)->take($limit)->get(); } } } } $data['user'] = $this->user; $data['products'] = $products; return view('ajax.newsfeed_load_more', $data); }