SALES INVOICE

@php // Group items by connection type, maintaining insertion order $groupedItems = []; $connectionTypeOrder = []; $lastConnectionType = null; foreach ($invoice->items as $item) { $connectionTypeName = $item->connectionType ? $item->connectionType->name : 'No Connection Type'; // If this is a new connection type, create a new group if ($connectionTypeName !== $lastConnectionType) { if (!isset($groupedItems[$connectionTypeName])) { $groupedItems[$connectionTypeName] = []; $connectionTypeOrder[] = $connectionTypeName; } $lastConnectionType = $connectionTypeName; } // Add item to current group if (!isset($groupedItems[$connectionTypeName])) { $groupedItems[$connectionTypeName] = []; if (!in_array($connectionTypeName, $connectionTypeOrder)) { $connectionTypeOrder[] = $connectionTypeName; } } $groupedItems[$connectionTypeName][] = $item; } $rowNumber = 1; @endphp @foreach($connectionTypeOrder as $connectionTypeName) @if(isset($groupedItems[$connectionTypeName]) && count($groupedItems[$connectionTypeName]) > 0) @php // Get the first item's note for this connection type (all items should have same note) $connectionTypeNote = null; foreach ($groupedItems[$connectionTypeName] as $item) { if (!empty($item->note)) { $connectionTypeNote = $item->note; break; } } @endphp @if($connectionTypeNote) @endif @foreach($groupedItems[$connectionTypeName] as $item) @php $rowNumber++; @endphp @endforeach @endif @endforeach

#	Item Description	Unit	Quantity	Rate	VAT %	VAT Amount	Period	Total
{{ $connectionTypeNote }}
{{ $rowNumber }}	{{ $item->item_name ?? 'Custom Item' }} @if($item->description) {{ $item->description }} @endif	{{ $item->unit ?? '-' }}	{{ number_format($item->quantity, 2) }}	BDT {{ number_format($item->rate, 2) }}	{{ number_format($item->vat_percentage, 2) }}%	BDT {{ number_format($item->total_vat, 2) }}	@if($item->from_date && $item->to_date) {{ \Carbon\Carbon::parse($item->from_date)->format('M d') }} - {{ \Carbon\Carbon::parse($item->to_date)->format('M d, Y') }} @elseif($item->from_date) From {{ \Carbon\Carbon::parse($item->from_date)->format('M d, Y') }} @elseif($item->to_date) Until {{ \Carbon\Carbon::parse($item->to_date)->format('M d, Y') }} @else - @endif	BDT {{ number_format($item->total_amount, 2) }}