@foreach ($zatca_stores as $z) @php $total_checkout = $checkout_counts->where('ware_id', $z->warehouse_id)->sum('total_checkout'); $total_reported = $checkout_counts->where('ware_id', $z->warehouse_id)->sum('total_reported'); $total_not_reported = $total_checkout - $total_reported; $total_warning = $warning_counts->where('warehouse_id', $z->warehouse_id)->sum('total_warning'); @endphp @endforeach @php $total_checkout = $checkout_counts->sum('total_checkout'); $total_reported = $checkout_counts->sum('total_reported'); $total_not_reported = $total_checkout - $total_reported; $total_warning = $warning_counts->sum('total_warning'); @endphp

{{ __('obs.sl') }}	{{ __('obs.hotel') }}	{{ __('obs.connection_date') }}	{{ __('obs.check_out') }}	{{ __('obs.reported') }}	{{ __('obs.not_reported') }}	{{ __('obs.warning') }}
{{ $loop->iteration }}	{{ $z->getWarehouse->name_eng }}	{{ date('d-m-Y', strtotime($z->created_at)) }}	{{ $total_checkout }}	{{ $total_reported }}	{{ $total_not_reported }}	{{ $total_warning }}
{{ __('obs.total') }}			{{ $total_checkout }}	{{ $total_reported }}	{{ $total_not_reported }}	{{ $total_warning }}