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 delete($id) { $product = Product::find($id); /** * Remove the product , all its linked categories and delete the thumbnail */ File::delete(public_path() . $product->thumbnail); CategoryProduct::whereProduct_id($id)->delete(); $product->delete(); return \Redirect::back(); }
public function edit_blog_post($id) { $product = Product::find($id); $this->data['product'] = $product; $this->data['categories'] = CategoryProduct::all(); $this->data['tags'] = Tag::all(); $this->data['owner_id'] = $this->user->id; return view('student.edit_blog_post', $this->data); }
public function news_feed_load_more(Request $request) { $limit = 15; $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); }
public function product_categories($domain) { $categories = CategoryProduct::all()->map(function ($c) { return ['value' => $c->id, 'text' => $c->name]; }); return $this->respond(['categories' => $categories]); }