Movement Report

{{-- Filters --}}
{{-- Pivot Table --}}
{{-- Top header: movement type groups --}} @foreach($movementTypes as $mt) @endforeach {{-- Sub-header: Kg / Value --}} @foreach($movementTypes as $mt) @endforeach @forelse($rows as $row) @foreach($movementTypes as $mt) @endforeach @empty @endforelse @if($rows->count()) @foreach($movementTypes as $mt) @endforeach @endif
Code Product {{ $mt->code }} Total
Kg ValueKg Value
{{ $row['product']->code }} {{ $row['product']->name }} {{ $row['mt_' . $mt->code . '_kg'] != 0 ? number_format($row['mt_' . $mt->code . '_kg'], 2) : '—' }} {{ $row['mt_' . $mt->code . '_value'] != 0 ? number_format($row['mt_' . $mt->code . '_value'], 2) : '—' }} {{ number_format($row['grand_kg'], 2) }} {{ number_format($row['grand_value'], 2) }}
@if(!$dateFrom || !$dateTo) Select a date range to generate the report. @else No movements found for the selected period. @endif
Totals {{ number_format($rows->sum('mt_' . $mt->code . '_kg'), 2) }} {{ number_format($rows->sum('mt_' . $mt->code . '_value'), 2) }} {{ number_format($rows->sum('grand_kg'), 2) }} {{ number_format($rows->sum('grand_value'), 2) }}