public function show($id) { $userId = \Auth::user()->id; $article = Article::findOrFail($id); if ($userId != $article->user_id) { //作者本人访问不增加文章浏览量 Article::where('id', $id)->increment('view'); //博主访客+1 $r = FlowTrace::where(['user_id' => $article->user_id, 'time' => substr(Carbon::now(), 0, 10)])->first(); if ($r) { $r->increment('daycount'); } else { FlowTrace::create(array('user_id' => $article->user_id, 'time' => substr(Carbon::now(), 0, 10), 'daycount' => 1)); } //博主积分+1 User::where('id', $article->user_id)->increment('score'); } $tags = Tag::where(['user_id' => \Auth::user()->id, 'article_id' => $id])->get(); $followAuthor = FollowAuthor::where(['my_id' => \Auth::user()->id, 'user_id' => $article->user_id])->first(); $recommend = false; $record = RecommendArticle::where(['user_id' => \Auth::user()->id, 'article_id' => $id])->first(); if ($record) { $recommend = true; } $collects = Collect::where('user_id', $userId)->get(); $collected = \Auth::user()->collectedArticle($article->id); // if(is_null($article)){ // abort(404); // } return view('member.articles.show', compact('userId', 'article', 'tags', 'followAuthor', 'recommend', 'collects', 'collected')); }
public function show($id) { $user = User::findOrFail($id); $tags = Tag::select('tag')->distinct()->where('user_id', $id)->get(); $articles = Article::where('user_id', $id)->orderby('published_at', 'desc')->get(); //博主访客加1 if (\Auth::user()->id != $id) { $r = FlowTrace::where(['user_id' => $id, 'time' => substr(Carbon::now(), 0, 10)])->first(); if ($r) { $r->increment('daycount'); } else { FlowTrace::create(array('user_id' => $id, 'time' => substr(Carbon::now(), 0, 10), 'daycount' => 1)); } User::where('id', $id)->increment('score'); } return view("member.users.show", compact('user', 'tags', 'articles')); }