Pfthb

I have an app with which a user is able to view various posts.
In my model, I use boot method that will run again any query in that model so that only active posts are shown and all works so far.

protected static function boot()

 parent::boot();

 static::addGlobalScope('active', function (Builder $builder) 
 $builder->where('active', 1);
 );

But now it happens that when a user is in the app, it became mandatory that he should be able to block a post, so every-time he logs in the app, he will never see that post again.

I created a hidden posts table that receives post and user_id.

public function hide_post(Request $request, $post_id)

 $user = $this->getAuthorizedUser($request->header('X-User-Auth-Token'));
 $user = User::find(201);
 if (!$user) 
 return response()->json(['error' => true, 'code' => 401, 'message' => INVALID_AUTH_TOKEN], 401);
 

 $data = [
 'user_id' => $user->id,
 'post_id' => $post_id,
 'created_at' => now(),
 'updated_at' => now()
 ];

 $reported_post = DB::table('hidden_posts')->insert($data);

 return response()->json(['success' => true, 'code' => 200, 'message' => 'Posted successfully hidden'], 200);

So far the table is updated.

Is there a way I can amend my boot method to also ensure that the app does not show me posts that I did hide?

I tried this:

protected static function boot()

 parent::boot();

 $hidden = DB::table('hidden_posts')->whereUser(Auth::id())->pluck('post_id')->toArray();

 // A global scope is applied to all queries on this model
 // -> No need to specify 'active' restraints on every query

 static::addGlobalScope('active', function (Builder $builder) 
 $builder->whereNotIn('post_id', $hidden);
 $builder->where('active', 1);
 );

But when I try to view all my posts just for testing purposes, with a new endpoint I created, here comes the error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user' in 'where clause' (SQL: select `post_id` from `hidden_posts` where `user` is null)

I thought of adding if statement in the boot method, but that does not seem to work.

The boot function runs when the application is booted and only then. At that point you are collecting all hidden posts and hidding them using a global scope. However when you hide a post after the application has been booted it will not be reflected in the scope until you boot the application again. You can avoid this by having the scope get the hidden models when needed:

protected static function boot()

 parent::boot(); 
 static::addGlobalScope('active', function (Builder $builder) 
 $hidden = DB::table('hidden_posts')
 ->whereUserId(Auth::id())
 ->pluck('post_id')->toArray();
 $builder->whereNotIn('post_id', $hidden);
 $builder->where('active', 1);
 );

You might be able to save on some querying by doing :

protected static function boot()

 parent::boot(); 
 static::addGlobalScope('active', function (Builder $builder) 
 $builder->whereNotIn('post_id', function ($query) 
 $query->from('hidden_posts')
 ->whereUserId(Auth::id())
 ->select('post_id');
 );
 $builder->where('active', 1);
 );