| User ID |
Order ID |
Name |
Total |
@foreach($orders as $order)
@if($order->items()->whereIn('item_id', [7,88])->get()->sum('quantity') > 0)
@forelse($order->user->meal_users()->select('*', \DB::raw('COUNT(*) as total'))->whereIn('event_id', $order->items()->with('product')->whereIn('item_id', [7,88])->get()->pluck('product.event_id'))->groupBy('dining_table_id')->get() as $meal_user)
@if($meal_user->total < $order->items()->whereIn('item_id', [7,88])->get()->sum('quantity'))
| {{$order->user->id}} |
{{$order->id}} |
{{$order->user->full_name}} ({{$meal_user->total}}) |
{{$order->items()->whereIn('item_id', [7,88])->get()->sum('quantity') - $meal_user->total}} |
@endif
@empty
| {{$order->user->id}} |
{{$order->id}} |
{{$order->user->full_name}} (0) |
{{$order->items()->whereIn('item_id', [7,88])->get()->sum('quantity')}} |
@endforelse
@endif
@endforeach