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]);
}
