{{-- Report Header --}}

Moon Traders
Sales Settlements
@if(request('filter.settlement_date_from') || request('filter.settlement_date_to')) Period: {{ \Carbon\Carbon::parse(request('filter.settlement_date_from', now()))->format('d-M-Y') }} to {{ \Carbon\Carbon::parse(request('filter.settlement_date_to', now()))->format('d-M-Y') }} @endif @php $filtersText = []; if (request('filter.employee_id')) $filtersText[] = 'Employee: ' . ($employees->firstWhere('id', request('filter.employee_id'))->name ?? ''); if (request('filter.vehicle_id')) $filtersText[] = 'Vehicle: ' . ($vehicles->firstWhere('id', request('filter.vehicle_id'))->registration_number ?? ''); if (request('filter.warehouse_id')) $filtersText[] = 'Warehouse: ' . ($warehouses->firstWhere('id', request('filter.warehouse_id'))->warehouse_name ?? ''); if (request('filter.status')) $filtersText[] = 'Status: ' . ucfirst(request('filter.status')); if (request('filter.supplier_id')) $filtersText[] = 'Supplier: ' . ($suppliers->firstWhere('id', request('filter.supplier_id'))->supplier_name ?? ''); @endphp @if(count($filtersText) > 0)
{!! implode(' | ', $filtersText) !!} @endif
Printed by: {{ auth()->user()->name }} | {{ now()->format('d-M-Y h:i A') }}

@if($settlements->count() > 0) @role('super-admin|admin') @endrole @foreach ($settlements as $index => $settlement) @php // Use calculated net profit from accessor $netProfit = $settlement->calculated_net_profit; @endphp @role('super-admin|admin') @endrole @endforeach

Sr#	Date	Supplier	Settlement #	Goods Issue #	SM Salesman	CMV Vehicle	COGS COGS	Total Sales	Expenses	Net Profit	Created By	Status
{{ $settlements->firstItem() + $index }}	{{ $settlement->settlement_date->format('d-m-y') }}	{{ $settlement->supplier->supplier_name ?? '-' }}	{{ preg_replace('/^SETTLE-\d{2}(\d{2})-(\d+)$/', 'SI-$1-$2', $settlement->settlement_number) }} {{ preg_replace('/^SETTLE-\d{2}(\d{2})-(\d+)$/', 'SI-$1-$2', $settlement->settlement_number) }} ({{ str_replace(['Warehouse - I', 'Warehouse - II', 'Warehouse'], ['W-I', 'W-II', 'W'], $settlement->warehouse->warehouse_name) }})	@if($settlement->goodsIssue) {{ preg_replace('/^GI-\d{2}(\d{2})-(\d+)$/', 'GI-$1-$2', $settlement->goodsIssue->issue_number) }} {{ preg_replace('/^GI-\d{2}(\d{2})-(\d+)$/', 'GI-$1-$2', $settlement->goodsIssue->issue_number) }} @else - @endif	{{ $settlement->employee->name ?? 'N/A' }}	{{ $settlement->vehicle->registration_number ?? $settlement->vehicle->vehicle_number ?? 'N/A' }}	{{ number_format($settlement->calculated_total_cogs, 2) }}	{{ number_format($settlement->calculated_total_sales_amount, 2) }}	{{ number_format($settlement->calculated_total_expenses, 2) }}	{{ number_format($netProfit, 2) }}	{{ $settlement->creator->name ?? 'N/A' }}	{{ $settlement->status === 'posted' ? 'Posted' : 'Draft' }}
Total ({{ $settlements->total() }}):							{{ number_format($totals->total_cogs, 2) }}	{{ number_format($totals->total_sales_amount, 2) }}	{{ number_format($totals->total_expenses, 2) }}	{{ number_format($totals->total_net_profit, 2) }}

@else @endif