/PHP/Laravel/Show user only those products which he hasn't buyed laravel eloquent

Show user only those products which he hasn't buyed laravel eloquent

$user_id = auth()->user()->id;

Product::where('status', 'active')
  ->whereNotIn('id', function($query) use ($user_id) {
    $query->select('product_id')->from((new OrderProduct)->getTable())
      ->where('user_id', $user_id)->where('status', 'delivered')
		->pluck('product_id')->toArray();
  });

Similar codes

5 votes261 views3 answers
Merge collections laravel
PHP Laravel
0 vote263 views1 answer
Undefined offset: 0 at laravel\framework\src\Illuminate\Routing\Router.php
PHP Laravel
3 votes226 views2 answers
Laravel validate telephone number
PHP Laravel
0 vote245 views1 answer
Laravel allow null records relationship
PHP Laravel
0 vote218 views2 answers
Laravel query where and
PHP Laravel
0 vote237 views1 answer
How to remove updated_at or use only created_at laravel eloquent ORM
PHP Laravel
-1 vote286 views1 answer
Validate rule if row exist laravel
PHP Laravel
39 votes240 views3 answers
Add column in laravel migration cmnd
PHP Laravel
0 vote238 views1 answer
How to display image from aws s3 in laravel blade
PHP Laravel
0 vote237 views1 answer
Get data from model in chunks laravel
PHP Laravel