public function show($id) { Article::whereNull('deleted_at')->findOrFail($id); $this->upView($id); $article = Article::find($id); $article->tag = explode(",", $article->tag); $article->last_reply = $article->comment->max('created_at'); return view('user.article.show')->with('article', $article)->with('tops', ArticleController::getTop10()); }
public function index() { $user_id = \Auth::user()->id; $articles = Article::with('comment')->select(['id', 'title', 'tag', 'view', 'introduction', 'updated_at', 'created_at'])->where('user_id', $user_id)->where('status', config('DbStatus.article.status'))->paginate(1); foreach ($articles as $v) { $v->tag = str_replace(',', ',', $v->tag); $v->last_reply = $v->comment->max('created_at'); } return view('user.user')->with('articles', $articles)->with('tops', ArticleController::getTop10()); }
public function cate($cate = null) { $cateId = DB::table('article_categories')->select('id')->where('title', $cate)->first(); if (is_null($cateId)) { return $this->tagList(); } if ($cate != null) { $articles = Article::with('comment')->select(['id', 'title', 'tag', 'view', 'introduction', 'updated_at', 'created_at'])->whereNull('deleted_at')->where('category_id', $cateId->id)->paginate(10); } else { return $this->tagList(); } $list = array(); foreach ($articles as $v) { $v->tag = str_replace(',', ',', $v->tag); $list = array_merge($list, explode(',', $v->tag)); $v->last_reply = $v->comment->max('created_at'); } $tags = array_unique($list); return view('home.cateList')->with('articles', $articles)->with('tags', $tags)->with('tops', ArticleController::getTop10()); }