@foreach (['company' => 'Company', 'whs' => 'Store', 'code' => 'Code', 'name' => 'Name'] as $column => $label) @endforeach @foreach (['salestotal' => 'Total Sales', 'stocknullcount' => 'Stock 0 Days', 'lostsales' => 'Lost Sales'] as $column => $label) @endforeach @foreach ($dates as $date) @endforeach @foreach ($dates as $date) @endforeach @php $subtotal_lostsales = 0; @endphp @foreach ($data as $item) @foreach ($dates as $date) @php $formattedDate = \Carbon\Carbon::parse($date)->format('ymd'); $salesColumn = 'sales' . $formattedDate; $stockColumn = 'stock' . $formattedDate; @endphp @endforeach @php $subtotal_lostsales += $item->lostsales; @endphp @endforeach @if (isset($dates) && count($dates) > 0) @endif @if (isset($dates) && count($dates) > 0) @endif

@if (!empty($filters[$column])) {{ count($filters[$column]) }} @endif Select All @if (isset($filterOptions[$column])) @foreach ($filterOptions[$column] as $option) {{ $option }} @endforeach @endif	@if (!is_null($filters_min[$column]) || !is_null($filters_max[$column])) • @endif Minimum value Maximum value Clear	{{ \Carbon\Carbon::parse($date)->format('j F Y') }}
		{{ __('Sales') }}	{{ __('Stock') }}
{{ Str::limit(strip_tags($item->company), 50) }}	{{ Str::limit(strip_tags($item->whs), 50) }}	{{ $item->code }}	{{ Str::limit(strip_tags($item->name), 50) }}	{{ number_format($item->salestotal) }}	{{ number_format($item->stocknullcount) }}	{{ number_format($item->lostsales) }}	{{ number_format($item->$salesColumn) }}	{{ number_format($item->$stockColumn) }}
SubTotal						{{ number_format($subtotal_lostsales) }}
Total						{{ number_format($total_lostsales) }}

@if ($data) @endif