| User ID |
Name |
Table |
Event |
# of Seats |
Total meals |
Veggie Meal Count |
@foreach($meal_users as $mu)
@if($mu->eventname)
| {{$mu->uid}} |
{{$mu->firstname}} {{$mu->lastname}} |
{{$mu->tablename}} |
{{$mu->eventname}} |
{{\App\Models\MealUser::where('user_id', $mu->uid)->where('dining_table_id', $mu->dining_table_id)->count()}}
|
@if($mu->eventid)
@php
if($mu->eventid == 6) {
$item_id = [7,88];
}elseif($mu->eventid == 42) {
$item_id = [8,9];
}elseif($mu->eventid == 46) {
$item_id = [10,11];
}
@endphp
{{$veggiecount = \App\Models\OrderItem::whereHas('order', function($q) use($mu){
$q->where('user_id', $mu->uid)->where('order_status_id', 1);
})->whereIn('item_id', $item_id)->sum('quantity');}}
@endif
|
@if($mu->eventid)
@php
if($mu->eventid == 6) {
$item_id = 7;
}elseif($mu->eventid == 42) {
$item_id = 8;
}elseif($mu->eventid == 46) {
$item_id = 10;
}
$veggiecount = \App\Models\OrderItem::whereHas('order', function($q) use($mu){
$q->where('user_id', $mu->uid)->where('order_status_id', 1);
})->where('item_id', $item_id)->sum('quantity');
@endphp
{{ $veggiecount > 0 ? $veggiecount : "" }}
@endif
|
@endif
@endforeach