@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 if(!$_declare->total_m2){ $_declare->total_m2 = 0; } if(!$_declare->weight){ $_declare->weight = 0; } if(!$_declare->unit_price){ $_declare->unit_price = 0; } if(!$_declare->total){ $_declare->total = 0; } if(!$_declare->btw){ $_declare->btw = 0; } if(!$_declare->total_btw){ $_declare->total_btw = 0; } $sumAantal += $_declare->total_m2; $sumWeight += $_declare->weight; $sumRecyclingbijdra += $_declare->unit_price; $sumBijdrage += $_declare->total; $sumBTW += $_declare->btw; $sumIncl += $_declare->total_btw; $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 m2	Bijdrage excl. BTW in euro	BTW 21% in euro	Bijdrage incl. BTW in euro
{{$_declare->type_name}} <{{$_declare->category_name}}>	{{ $plus_or_minus_label }}{{$_declare->total_m2}} m2	{{$_declare->weight}} kg	€ {{$_declare->unit_price}}	€ {{ $plus_or_minus_label }}{{$_declare->total}}	€ {{ $plus_or_minus_label }}{{$_declare->btw}}	€ {{ $plus_or_minus_label }}{{$_declare->total_btw}}
Totaal	{{ $plus_or_minus_label }}{{$sumAantal}} m2	{{$sumWeight}} kg		€ {{ $plus_or_minus_label }}{{$sumBijdrage}}	€ {{ $plus_or_minus_label }}{{$sumBTW}}	€ {{ $plus_or_minus_label }}{{$sumIncl}}

@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