示例#1
0
 /**
  * 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'));
 }
示例#2
0
 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');
 }
示例#3
0
 /**
  * @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');
 }