@php $sumAantal = 0; $sumWeight = 0; $sumRecyclingbijdra = 0; $sumBijdrage = 0; $sumBTW = 0; $sumIncl = 0; $plus_or_minus_label = ''; @endphp @php $total_nl_kg = 0.00; $total_be_kg = 0.00; $total_de_kg = 0.00; $total_po_kg = 0.00; $total_turk_kg = 0.00; $total_import_kg = 0.00; @endphp @foreach ($listOfDeclareObject as $_declare) @foreach($listType as $key => $type) @if ($_declare->declaration_id == $type->id) @php // Safety: always use ?? 0 $totalM2 = (float) ($_declare->total_m2 ?? 0); $totalKg = (float) ($_declare->weight ?? 0); // Calculation mode and unit price from CMA logic $base = ($calcMode === 'kg') ? $totalKg * $unitPrice : $totalM2 * $unitPrice; $btw = $base * 0.21; $totalBtw = $base + $btw; if(!$_declare->unit_price){ $_declare->unit_price = 0; } // Totals for summary row $sumAantal += $totalM2; $sumWeight += $totalKg; $sumRecyclingbijdra += $unitPrice; $sumBijdrage += $base; $sumBTW += $btw; $sumIncl += $totalBtw; $fm = $_declare->fm ? json_decode($_declare->fm) : null; if($_declare->plus_or_minus == 'minus'){ $plus_or_minus_label = '-'; } if($_declare->plus_or_minus == 'plus'){ $plus_or_minus_label = '+'; } @endphp @endif @endforeach @endforeach

Glassoort	{{$aantal_label}}	Gewicht (optioneel)	Recyclingbijdrage per {{ $calcMode }}	Bijdrage excl. BTW in euro	BTW 21% in euro	Bijdrage incl. BTW in euro
{{$_declare->type_name}} <{{$_declare->category_name}}>	{{ $plus_or_minus_label }}{{ $calcMode === 'kg' ? ($_declare->weight ?? 0) : ($_declare->total_m2 ?? 0) }} {{ $calcMode }}	{{ $_declare->weight ?? 0 }} kg	€ {{ number_format($unitPrice, 4, ',', '.') }}	€ {{ $plus_or_minus_label }}{{ number_format($base, 2, ',', '.') }}	€ {{ $plus_or_minus_label }}{{ number_format($btw, 2, ',', '.') }}	€ {{ $plus_or_minus_label }}{{ number_format($totalBtw, 2, ',', '.') }}
Totaal	{{ $plus_or_minus_label }}{{ number_format($calcMode === 'kg' ? $sumWeight : $sumAantal, 2, ',', '.') }} {{ $calcMode }}	{{ number_format($sumWeight, 2, ',', '.') }} kg		€ {{ $plus_or_minus_label }}{{ number_format($sumBijdrage, 2, ',', '.') }}	€ {{ $plus_or_minus_label }}{{ number_format($sumBTW, 2, ',', '.') }}	€ {{ $plus_or_minus_label }}{{ number_format($sumIncl, 2, ',', '.') }}

@if($year >=2023) @endif @php $total_nl222 = 0.00; $total_be = 0.00; $total_de = 0.00; $total_po = 0.00; $total_turk = 0.00; $total_import = 0.00; @endphp @foreach ($listOfDeclareObject as $_declare) @foreach($listType as $key => $type) @if ($_declare->declaration_id == $type->id) @php $pro_nl222 = $_declare->pro_nl; $imp_be222 = $_declare->imp_be; $imp_de222 = $_declare->imp_de; $imp_po222 = $_declare->imp_po; $imp_turk222 = $_declare->imp_turk; $import222 = $_declare->import; if(!$pro_nl222){ $pro_nl222 = 0; } if(!$imp_be222){ $imp_be222 = 0; } if(!$imp_de222){ $imp_de222 = 0; } if(!$imp_po222){ $imp_po222 = 0; } if(!$imp_turk222){ $imp_turk222 = 0; } if(!$import222){ $import222 = 0; } $pro_nl_kg222 = $_declare->pro_nl_kg; $imp_be_kg222 = $_declare->imp_be_kg; $imp_de_kg222 = $_declare->imp_de_kg; $imp_po_kg222 = $_declare->imp_po_kg; $imp_turk_kg222 = $_declare->imp_turk_kg; $import_kg222 = $_declare->import_kg; if(!$pro_nl_kg222){ $pro_nl_kg222 = 0; } if(!$imp_be_kg222){ $imp_be_kg222 = 0; } if(!$imp_de_kg222){ $imp_de_kg222 = 0; } if(!$imp_po_kg222){ $imp_po_kg222 = 0; } if(!$imp_turk_kg222){ $imp_turk_kg222 = 0; } if(!$import_kg222){ $import_kg222 = 0; } $total_nl222 += $pro_nl222; $total_be += $imp_be222; $total_de += $imp_de222; $total_po += $imp_po222; $total_turk += $imp_turk222; $total_import += $import222; $total_nl_kg += $pro_nl_kg222; $total_be_kg += $imp_be_kg222; $total_de_kg += $imp_de_kg222; $total_po_kg += $imp_po_kg222; $total_turk_kg += $imp_turk_kg222; $total_import_kg += $import_kg222; $pro_nl22 = str_replace(".",",",$pro_nl222); $imp_be22 = str_replace(".",",",$imp_be222); $imp_de22 = str_replace(".",",",$imp_de222); $imp_po22 = str_replace(".",",",$imp_po222); $imp_turk22 = str_replace(".",",",$imp_turk222); $import22 = str_replace(".",",",$import222); $fm = $_declare->fm ? json_decode($_declare->fm) : null; @endphp @if($year >= 2023) @endif @endif @endforeach @endforeach @if($year >=2023) @endif

Glassoort	Productie in Nederland	Import Duitsland	Import België	Import Polen	Import Turkije	Import overige
{{ $_declare->type_name }}	{{$pro_nl222}} m2 {{$pro_nl_kg222}} kg	{{ $plus_or_minus_label }}{{$imp_de222}} m2 {{$imp_de_kg222}} kg	{{$imp_be222}} m2 {{$imp_be_kg222}} kg	{{$imp_po222}} m2 {{$imp_po_kg222}} kg	{{$imp_turk222}} m2 {{$imp_turk_kg222}} kg	{{$import222}} m2 {{$import_kg222}} kg
Totaal	{{$total_nl222}} m2 {{$total_nl_kg}} kg	{{ $plus_or_minus_label }}{{$total_de}} m2 {{$total_de_kg}} kg	{{$total_be}} m2 {{$total_be_kg}} kg	{{$total_po}} m2 {{$total_po_kg}} kg	{{$total_turk}} m2 {{$total_turk_kg}} kg	{{$total_import}} m2 {{$total_import_kg}} kg