我正试图在帖子的评论列表上实现授权门。我想我已经把它做好了,因为它是有效的。
如果用户是评论的所有者,或者是发布评论的reddit的版主,那么他可以编辑它。如果没有,他将无法看到编辑链接(我使用X-Editable内联编辑)
在我提交新评论之前,一切都运行良好,然后我得到以下错误。但是评论被提交到数据库因为我可以在刷新时看到它
未定义变量:isModerator on comment_list.blade.php
很明显,我需要将isModerator
变量传递给视图,所以我做了
$isModerator = $post->subreddit->moderators->where('user_id', Auth::id())->exists();
在页面加载时抛出这个错误,整个post页面崩溃
调用未定义方法Illuminate'Database'Eloquent'Collection::exists()
CommentController::view_data()在PostsController.php第90行
这是我的Gate
授权。请注意,update-post
和update-sub
工作没有故障。
public function boot(GateContract $gate)
{
parent::registerPolicies($gate);
$gate->define('update-comment', function($user, $comment, $isModerator) {
if($user->id === $comment->user_id) {
return true;
}
if ($isModerator) {
return true;
}
});
$gate->define('update-post', function ($user, $post, $isModerator) {
if ($user->id === $post->subreddit->user->id) {
return true;
}
if ($user->id === $post->user_id) {
return true;
}
if ($isModerator) {
return true;
}
return false;
});
$gate->define('update-sub', function($user, $subreddit) {
if($user->id === $subreddit->user->id) {
return true;
}
return false;
});
}
CommentController
view_data()
方法public static function view_data(Request $request, Post $post) {
$instance = new Self;
$per_page = session('per_page')?session('per_page'):config('constants.per_page');
$post = Post::with('user.votes')->with('subreddit.moderators')->with('comments')->where('id', $post->id)->first();
$comment = $post->comments;
$user = User::where('id', '=', Auth::id())->get();
$isModerator = $post->subreddit->moderators->where('user_id', Auth::id())->exists();
$result['per_page'] = $per_page;
$result['comments'] = $instance->comment_list($per_page, $request, $post, $comment, $user, $isModerator);
$result['total_comments'] = $instance->total_comments($post);
return $result;
}
视图的编辑部分如下所示
@can('update-comment', [$each_comment, $isModerator])
<p>
<a href="#" class="testedit" data-pk="{{ $each_comment->id }}" data-url="{{ url($each_comment->post_id . '/comment/update') }}">
{!! $each_comment->comment !!}
</a>
</p>
@else
<p>
{!! $each_comment->comment !!}
</p>
@endcan
这是PostsController
show()
方法public function show(Post $post, User $user, Request $request, Comment $comment)
{
$post = Post::with('user.votes')->with('subreddit.moderators')->findOrFail($post->id);
$ids = $post->subreddit;
$isModerator = $ids->moderators()->where('user_id', Auth::id())->exists(); // this is line 90
$modList = Moderator::where('subreddit_id', '=', $post->subreddit->id)->get();
$view_data = CommentController::view_data($request, $post, $comment, $isModerator);
return view('post/show', $view_data)->with('post', $post)
->with('modList', $modList)
->with('isModerator', $isModerator);
}
Comment
模型
public function posts() {
return $this->belongsTo('App'Post');
}
public function user() {
return $this->belongsTo('App'User');
}
public function commentvotes() {
return $this->hasMany('App'CommentVote');
}
Post
模型
public function user() {
return $this->belongsTo('App'User');
}
public function subreddit() {
return $this->belongsTo('App'Subreddit');
}
public function votes() {
return $this->hasMany('App'Vote');
}
public function moderators() {
return $this->hasMany('App'Moderator');
}
public function comments() {
return $this->hasMany('App'Comment');
}
Subreddit
模型
public function user() {
return $this->belongsTo('App'User');
}
public function posts() {
return $this->hasMany('App'Post');
}
public function moderators() {
return $this->hasMany('App'Moderator');
}
Moderator
模型
public function subreddit() {
return $this->belongsTo('App'Subreddit');
}
public function user() {
return $this->belongsTo('App'User', 'user_id');
}
public function posts() {
return $this->belongsTo('App'Post');
}
由于我不知道->exists()
的用法,但基本的前提是简单地检查当前用户是否是特定Subreddit
的Moderator
,您可以简单地执行以下操作:
$check = $ids->moderators()->where('user_id', Auth::id())->first();
$isModerator = $check != NULL ? true : false;
// If $check doesn't return NULL (ie returns a Moderator object) then you are a moderator.
我认为你的$isModerator = $ids->moderators()->where('user_id', Auth::id())
返回NULL而不是集合对象。所以你不能使用->exists()
方法。您是否尝试使用whereHas ' has方法而不是->where('user_id', Auth::id())
?