/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { // this id will be article id, be careful $images = HomeImage::where('article_id', '=', $id)->get(); $categories = Category::all(); $article = Article::findOrFail($id); $articlesNumber = CategoriesController::getCategoryArticle(); /** * Need refactory */ $comments = DB::table('comments')->join('users', 'users.id', '=', 'comments.user_id')->where('article_id', '=', $id)->orderBy('comments.created_at', 'desc')->select('comments.*', 'users.name')->get(); // dd($images); return view('articles.show', compact('categories', 'article', 'comments', 'articlesNumber', 'images')); }
public function loadCategory() { $categories = Category::all(); $articles = Article::all(); // link the category id and the its related articles $articlesNumber = []; foreach ($categories as $category) { if (CategoriesController::getArticleNumber($category->id) != null) { $articlesNumber[$category->id] = CategoriesController::getArticleNumber($category->id)[0]->article_number; } else { $articlesNumber[$category->id] = '0'; } } if (User::getCurrentUser() != null) { $is_manager = User::getCurrentUser()->is_manager; } else { $is_manager = false; } return compact('categories', 'articles', 'articlesNumber', 'images', 'is_manager'); }
/** * @param $id * @return array */ public function loadCategoryWithId($id) { $categories = Category::all(); $category_list = Category::lists('name', 'id'); $article = Article::findOrFail($id); $top_list_articles = Article::where('is_top', '=', 2)->get(); // link the category id and the its related articles $articlesNumber = []; foreach ($categories as $category) { if (CategoriesController::getArticleNumber($category->id) != null) { $articlesNumber[$category->id] = CategoriesController::getArticleNumber($category->id)[0]->article_number; } else { $articlesNumber[$category->id] = '0'; } } if (User::getCurrentUser() != null) { $is_manager = User::getCurrentUser()->is_manager; } else { $is_manager = false; } //find image path $images = HomeImage::where('article_id', '=', $id)->get(); $comments = CommentsController::show($id); return compact('categories', 'category_list', 'article', 'top_list_articles', 'articlesNumber', 'is_manager', 'images', 'comments'); }
public function loadCategory() { $categories = Category::all(); $favorites_list = DB::table('favorite_articles')->join('articles', 'articles.id', '=', 'favorite_articles.article_id')->where('favorite_articles.user_id', '=', Auth::user()->id)->select('favorite_articles.*', 'articles.title')->get(); // link the category id and the its related articles $articlesNumber = []; foreach ($categories as $category) { if (CategoriesController::getArticleNumber($category->id) != null) { $articlesNumber[$category->id] = CategoriesController::getArticleNumber($category->id)[0]->article_number; } else { $articlesNumber[$category->id] = '0'; } } $is_manager = User::getCurrentUser()->is_manager; return compact('categories', 'favorites_list', 'articlesNumber', 'is_manager'); }