| Order ID |
User ID |
Name |
Total |
Table # |
Plates |
User Comments |
Admin Comments |
@foreach($orders as $o)
@foreach($o->user->orders()->whereHas('items', function($q){
$q->whereIn('item_id', [10,11]);
})->where('order_status_id', 1)->get() as $order)
@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('dining_table_id')->get() as $meal_user)
| {{$order->id}} |
{{$order->user->id}} |
{{$order->user->full_name}} |
{{$order->items()->whereIn('item_id', [10,11])->get()->sum('quantity')}} |
{{$meal_user->dining_table?->name}} |
{{$meal_user->total}} |
{{ $order->comments }} |
{{ $order->admin_comments }} |
@empty
| {{$order->id}} |
{{$order->user->id}} |
{{$order->user->full_name}} |
{{$order->items()->whereIn('item_id', [10,11])->get()->sum('quantity')}} |
{{ $order->comments }} |
{{ $order->admin_comments }} |
|
|
@endforelse
@endforeach
@endforeach