John Davidson

Message:

I have the following tables:

orders:

- id

- date



item_order:

- order_id

- item_id



items:

- id

- desc

- price

Using Eloquent, how can I get all the items NOT included in a giving order (say, the order with id = 6)?

I'm trying to do relationships & subqueries, but without luck.

Thanks in advance.

---

My Answer:
You can achieve this by defining a relationship between the `orders` and `items` tables and then using Eloquent to query for all items that are not included in a specific order.

First, define the relationships in your models:

Order.php:
php
class Order extends Model
{
public function items()
{
return $this->belongsToMany(Item::class, 'item_order', 'order_id', 'item_id');
}
}


Item.php:
php
class Item extends Model
{
public function orders()
{
return $this->belongsToMany(Order::class, 'item_order', 'item_id', 'order_id');
}
}


Then, you can use Eloquent to query for all items that are not included in a specific order (e.g., order with id = 6):

php
$itemsNotInOrder = Item::whereDoesntHave('orders', function ($query) {
$query->where('order_id', 6);
})->get();


This query will return all items that are not included in the order with id = 6.