{{-- Report Header --}}

Moon Traders
Sales Settlements Report
@if($startDate || $endDate) Period: {{ \Carbon\Carbon::parse($startDate)->format('d-M-Y') }} to {{ \Carbon\Carbon::parse($endDate)->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'))->name ?? ''); if (request('filter.status')) $filtersText[] = 'Status: ' . ucfirst(request('filter.status')); @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) @foreach ($settlements as $index => $settlement) @php $netProfit = $settlement->gross_profit - $settlement->expenses_claimed; @endphp @endforeach

Sr#	Date	Settlement #	Goods Issue #	SM Salesman	CMV Vehicle	COGS COGS	Total Sales	Expenses	Net Profit	Status
{{ $index + 1 }}	{{ $settlement->settlement_date->format('d-m-y') }}	{{ 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->total_cogs, 2) }}	{{ number_format($settlement->total_sales_amount, 2) }}	{{ number_format($settlement->expenses_claimed, 2) }}	{{ number_format($netProfit, 2) }}	{{ $settlement->status === 'posted' ? 'Posted' : 'Draft' }}
Total ({{ $settlements->count() }}):						{{ 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