function post($id) { $data['post'] = Post::find($id); $data['comments'] = Comment::where('post_id', '=', $id)->with('user')->get(); //$data['comments'] = Comment::find($id); return view('blog/post', $data); }
/** * Display the specified resource. * * @param $guildSlug * @param $occurrenceId * @return \Illuminate\Http\Response */ public function show($guildSlug, $occurrenceId) { $guild = Guild::where('slug', $guildSlug)->firstOrFail(); $occurrence = EventOccurrence::with(['event', 'event.guild'])->whereHas('event.guild', function ($query) use($guild) { $query->where('id', $guild->id); })->findOrFail($occurrenceId); $event = $occurrence->event; $guild = $event->guild; $signups = Signup::where(['event_occurrence_id' => $occurrence->id])->orderBy('created_at')->get(); $comments = Comment::where(['event_occurrence_id' => $occurrence->id])->orderBy('created_at')->get(); $character = Character::whereHas('guilds', function ($query) use($guild) { $query->where('guilds.id', $guild->id); })->where(['user_id' => Auth::user()->id])->firstOrFail(); $ownSignup = null; $isSigned = false; foreach ($signups as $signup) { if ($signup->character_id == $character->id) { $ownSignup = $signup; $isSigned = true; } } if ($ownSignup == null) { $ownSignup = new Signup(); } $statistic = new \stdClass(); foreach (['YES', 'MAYBE', 'NO'] as $status) { $name = strtolower($status); $statistic->{$name} = $signups->filter(function ($signup) use($status) { return $signup->status == $status; })->count(); } return view('guilds.events.show', compact('occurrence', 'event', 'guild', 'signups', 'comments', 'ownSignup', 'isSigned', 'statistic')); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { // //$comments = DB::table('comments')->where('page_id', $id)->get(); $comments = Comment::where('page_id', $id)->get(); return view('admin.comments.show', ['comments' => $comments]); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $task = Task::findOrFail($id); $comments = Comment::where('tasks_id', '=', $id)->get(); return view('tasks.show', array('task' => $task, 'comments' => $comments)); // }
public function index(Comment $commentsModel) { // $comments = $commentsModel->getPublishedComments(); $comments = Comment::where('active', '=', 1)->where('published_at', '<=', Carbon::now())->latest('published_at')->simplePaginate(4); $comments->setPath('comments')->currentPage(); return view('comments.comments')->with('comments', $comments); }
public function show($intelligenceSlug, $tutorialId) { $intelligence = Intelligence::where('slug', $intelligenceSlug)->firstOrFail(); $tutorial = Tutorial::where('intelligence_id', $intelligence->id)->findOrFail($tutorialId); $comments = Comment::where('tutorial_id', $tutorial->id)->paginate(15); return view('intelligence.tutorial.show', compact('intelligence', 'tutorial', 'comments')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index($kdThread) { // $comment = Comment::where('kdThread', '=', $kdThread)->with('threadforum.student', 'threadforum.lecturer', 'student', 'lecturer')->get(); return view('threadforum.comment.index', compact('comment')); // return $comment->toJson(); }
/** * Shows the specific user. * @param string $username * @return Response */ public function show($username) { $post_upvotes = 0; $user = User::where('username', '=', $username)->firstOrFail(); $user_posts = Post::where('user_id', '=', $user->id)->take(3)->get(); foreach ($user_posts as $post) { $post->username = $user->username; $post->comment_count = Comment::where('post_id', '=', $post->id)->count(); $post->hub_name = Hub::where('id', '=', $post->hub_id)->firstOrFail()->name; $post_upvotes = $post_upvotes + (int) $post->upvotes; $hub = Hub::find($post->hub_id); if (in_array($post->user_id, explode(',', $hub->moderators))) { $post->user_is_mod = true; } else { $post->user_is_mod = false; } $user = User::find($post->user_id); if ($user->is_admin) { $post->user_is_admin = true; } else { $post->user_is_admin = false; } } $comment_upvotes = 0; $user_comments = Comment::where('user_id', '=', $user->id)->take(3)->get(); foreach ($user_comments as $comment) { $comment_upvotes = $comment_upvotes + (int) $comment->upvotes; $comment->email = md5($user->email); } return view('user.show', ['user' => $user, 'email' => md5($user->email), 'post_upvotes' => $post_upvotes, 'comment_upvotes' => $comment_upvotes, 'comments' => $user_comments, 'posts' => $user_posts]); }
/** * Show the application dashboard to the user. * * @return Response */ public function showProfile($id) { $user = User::find($id); $posts = Post::where("user_id", $id)->get(); $comments = Comment::where('user_id', $id)->get(); return view('user.profile', ['user' => $user, 'comments' => $comments, 'posts' => $posts]); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $adventure = Adventure::find($id); $comments = Comment::where('adventure_id', $id)->get(); $pictures = Picture::where('adventure_id', $id)->get(); return view('adventures.show', compact('adventure', 'comments'))->with('pictures', $pictures); }
public function showpost($id) { //display one post $article = Article::findOrFail($id); $comment = Comment::where('postid', '=', $id)->get(); //if (is_null($article)) { abort(404); } return view('articles.show', compact('article', 'comment')); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $pre_page = 6; $comments = Comment::where('status', '<>', 2)->paginate($pre_page); //return view('admin/article/index'); $comments->setPath('comment'); return view('admin/comment/index')->with('comments', $comments); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $commentid * @return \Illuminate\Http\Response */ public function update(Request $request, $commentid) { $reply = new \App\Reply(); $reply->create(['user_id' => \Auth::user()->id, 'comment_id' => $request['comment_id'], 'comment' => $request['comment']]); $comment = \App\Comment::where(['id' => $commentid])->get()->first(); $comment->reply = $reply; return redirect()->back(); }
public static function getByAdId($id) { $comments = Comment::where(['ad_id' => $id, 'answer_to' => null])->join('users', 'comments.author_id', '=', 'users.id')->select(['comments.*', 'users.name as author_name'])->orderBy('comments.created_at')->get(); foreach ($comments as $comment) { $comment->answers = Comment::where('answer_to', $comment->id)->join('users', 'comments.author_id', '=', 'users.id')->select(['comments.*', 'users.name as author_name'])->get(); } return $comments; }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $course = Course::where('id', $id)->orWhere('slug', $id)->firstOrFail(); $data = Data::where('courseId', $course->id)->where('extension', '!=', 'mp4')->accepted()->get(); $videos = Data::where('courseId', $course->id)->Where('extension', 'mp4')->accepted()->get(); $comments = Comment::where('courseId', $course->id)->get(); return view('courses.show', compact('course', 'comments', 'data', 'videos')); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $article = Article::find($id); // get all comments for this article // pass allComments varialbe to view $allcomments = Comment::where('article_id', $article->id)->get(); return view('articleviews.show', compact('article', 'allcomments')); }
public function delete() { $usr_id = Auth::user()->id; if (User::destroy($usr_id)) { Thread::where('user_id', '=', $usr_id)->delete(); Relation::where('user_id', '=', $usr_id)->delete(); Comment::where('user_id', '=', $usr_id)->delete(); } }
public static function countComments($id) { $comments = \App\Comment::where('id_location', '=', $id); $location = Location::find($id); $location->rating = ceil($comments->avg('rating') / 0.5) * 0.5; $location->voters = $comments->count(); $location->save(); return $avgRating; }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $comment = Comment::find($id); Comment::destroy($id); if (Comment::where('author', $comment->author)->count() < 1) { User::where('author', $comment->author)->delete(); } return response()->json(['success' => true]); }
public function DeleteComment($id) { $user = User::findOrFail(Auth::user()->id); if (Comment::where('id', '=', $id)->where('user_id', '=', $user->id)->delete()) { return Response::json(['response' => true]); } else { return Response::json(['response' => false]); } }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update(Request $request, $id) { $this->validate($request, ['nickname' => 'required', 'content' => 'required']); if (Comment::where('id', $id)->update(Input::except(['_method', '_token']))) { return Redirect::to('admin/comments'); } else { return Redirect::back()->withInput()->withErrors('更新失败!'); } }
public function deleteArticle($id) { $articles = Article::find($id); $articles->delete(); $comment = Comment::where('article', $id); $comment->delete(); //On supprimer les commentaires lié a cet article return redirect()->route('articles'); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $post = new Post(); $comment = new Comment(); $post = Post::find($id); //return view('frontend.blogview',compact('post')); $comment = Comment::where('post_id', $id)->get(); // $comment=Comment::find($id); return view('frontend.blogview', compact('post', 'comment')); }
public function getComments(Request $request, Moment $moment) { $check_result = $this->requestCheck($request, ['user_id' => 'required']); if (!$check_result['result']) { return $this->response->error($check_result['message'], 422); } $payload = $request->all(); $comments = Comment::where('moment_id', $moment->id)->orderBy('created_at', 'asc')->paginate(20); return $this->paginator($comments, new CommentTransformer($payload['user_id'])); }
public function deleteThreadById($id) { $user = User::findOrFail(Auth::user()->id); if (Thread::where('id', '=', $id)->where('user_id', '=', $user->id)->delete()) { Relation::where('thread_id', '=', $id)->delete(); Comment::where('thread_id', '=', $id)->delete(); return Response::json(['response' => true]); } else { return Response::json(['response' => false]); } }
public function showDetailDocument($id) { $user = Auth::user(); $document = Document::where(['id' => $id])->first(); $comments = Comment::where('document_id', $id); $comments = $comments->join('users', 'users.id', '=', 'boss_id'); $comments = $comments->select('comments.*', 'users.name as username'); $comments = $comments->orderBy('updated_at', 'desc'); $comments = $comments->get(); return view('document/detail', ['document' => $document, 'user' => $user, 'comments' => $comments]); }
public function actionDelete($id) { // Set logged in user to a variable. $authUser = Auth::user(); // Find comment in database. $comment = Comment::where('user_id', '=', $authUser->id)->findOrFail($id); // Delete comment from database. $comment->delete($comment); // Redirect with flash message. \Session::flash('flash_message', 'You have successfully deleted your comment.'); return redirect('/photos'); }
public function delComment(Request $request, $slug, $id) { $user = User::where('id', $request->user()->id)->first(); $post = Post::where('slug', $slug)->first(); $destroy = Comment::where('id', $id)->first(); if ($user && $post && $destroy && $post->id == $destroy->post_id && ($user->id == $destroy->user_id || $request->user()->is_admin())) { $destroy->deleted_at = new Carbon(); $destroy->save(); return redirect()->back()->withMessage('Комментарий удален.'); } else { return redirect()->route('home')->withError('Ошибка, свяжитесь с администратором.'); } }
public function show($post_id) { if (Request::ajax()) { //$comments = Comment::where('post_id', '=', $post_id)->where('parent_id', '=', null)->get(); //$count = Comment::findorFail(0)->childrens; //return $comments; /*public function hasNoParent () { }*/ /*$comments->children; $user_info = $comments['name'] = $user_info->name;*/ /*function find_parent ($tmp, $cur_id){ if($tmp[$cur_id][0]['parent_id']!=0){ return find_parent($tmp,$tmp[$cur_id][0]['parent_id']); } return (int)$tmp[$cur_id][0]['id']; }*/ //$result = ''; function build_tree($comments) { if ($comments) { $result = "<ul>\n"; foreach ($comments as $comment) { $result .= "<li>"; $result .= $comment->id; $result .= "</li>\n"; // $count = Comment::findorFail(2)->childrens; $children = Comment::findorFail($comment->id)->childrens; if (isset($children)) { $result .= build_tree($children); } $result .= "</li>\n"; } $result .= "</ul>"; return $result; } } $noparents = Comment::where('post_id', '=', $post_id)->where('parent_id', '=', null)->get(); //$treepart =''; /*foreach ($noparents as $noparent) { return build_tree($noparent); }*/ return build_tree($noparents); // return $comments; } return 'Is not an AJAX Request'; }
/** * Run the database seeds. * * @return void */ public function run() { $users = ['Jill' => ['great'], 'Jamal' => ['bad'], 'Jon macleod' => ['good']]; foreach ($users as $name => $comment) { # First get the user $user = \App\User::where('name', 'like', $name)->first(); # Now loop through each comment for this user, adding the pivot foreach ($comment as $commentName) { $comment = \App\Comment::where('comment', 'LIKE', $commentName)->first(); # Connect this comment to this user $user->comments()->save($comment); } } }