{{ __('Admin') }}

{{ __('Reports') }}

{{ __('Table Assignment Summary for Breakfast Report') }}

Unassigned Plates Report - Breakfast

Breakfast Event Details @foreach($orders as $order) @if($order->items()->whereIn('item_id', [10,11])->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', [10,11])->get()->pluck('product.event_id'))->groupBy('user_id')->get() as $meal_user) @if($meal_user->total < $order->items()->whereIn('item_id', [10,11])->get()->sum('quantity')) @endif @empty @endforelse @endif @endforeach

User ID	Order ID	Name	Total
{{$order->user->id}}	{{$order->id}}	{{$order->user->full_name}} ({{$meal_user->total}})	{{$order->items()->whereIn('item_id', [10,11])->get()->sum('quantity') - $meal_user->total}}
{{$order->user->id}}	{{$order->id}}	{{$order->user->full_name}} (0)	{{$order->items()->whereIn('item_id', [10,11])->get()->sum('quantity')}}