Sales vs Stock Report
Period : {{ $period }}

@foreach ($dates as $date) @endforeach @foreach ($dates as $date) @endforeach @php $total_losssales = 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 $total_losssales += $item->losssales; @endphp @endforeach

{{ __('Warehouse') }}	{{ __('ItemCode') }}	{{ __('CodeBars') }}	{{ __('ItemName') }}	{{ __('Lost Sales') }}	{{ \Carbon\Carbon::parse($date)->format('j F Y') }}
					{{ __('Sales') }}	{{ __('Stock') }}
{{ $item->whs }}	{{ $item->code }}	{{ $item->barcode }}	{{ $item->name }}	{{ number_format($item->losssales) }}	{{ number_format($item->$salesColumn) }}	{{ number_format($item->$stockColumn) }}
Total				{{ $total_losssales }}