Moon Traders
Salesman Wise Sales Report
Period: {{ \Carbon\Carbon::parse($startDate)->format('d-M-Y') }} to
{{ \Carbon\Carbon::parse($endDate)->format('d-M-Y') }}
@php
$filters = [];
if ($employeeId)
$filters[] = 'Salesman: ' . ($employees->firstWhere('id', $employeeId)->name ?? '');
if ($vehicleId)
$filters[] = 'Vehicle: ' . ($vehicles->firstWhere('id', $vehicleId)->vehicle_number ?? '');
if ($warehouseId)
$filters[] = 'Warehouse: ' . ($warehouses->firstWhere('id', $warehouseId)->warehouse_name ?? '');
@endphp
@if(count($filters) > 0)
{!! implode(' | ', $filters) !!}
@endif
| Sr# | Salesman | Vehicle | Sets | Sold Qty | Rtn Qty | Short Qty | Net Sales | Gross Profit | Expense | Net Profit | NP % |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {{ $loop->iteration }} | {{ $salesman->employee_name }} | {{ $salesman->vehicle_number }} | {{ $salesman->settlement_count }} | {{ number_format($salesman->total_quantity_sold, 0) }} | {{ number_format($salesman->total_returned, 0) }} | {{ number_format($salesman->total_shortage, 0) }} | {{ number_format($salesman->total_sales, 2) }} | {{ number_format($salesman->gross_profit, 2) }} | {{ number_format($salesman->expenses_claimed, 2) }} | {{ number_format($salesman->net_profit, 2) }} | @php $npMargin = $salesman->total_sales > 0 ? ($salesman->net_profit / $salesman->total_sales) * 100 : 0; @endphp {{ number_format($npMargin, 2) }}% |
| Total ({{ $salesmanPerformance->count() }} Rows): | {{ $totals['settlement_count'] }} | {{ number_format($totals['total_quantity_sold'], 0) }} | {{ number_format($totals['total_returned'], 0) }} | {{ number_format($totals['total_shortage'], 0) }} | {{ number_format($totals['total_sales'], 2) }} | {{ number_format($totals['gross_profit'], 2) }} | {{ number_format($totals['expenses_claimed'], 2) }} | {{ number_format($totals['net_profit'], 2) }} | @php $totalNpMargin = $totals['total_sales'] > 0 ? ($totals['net_profit'] / $totals['total_sales']) * 100 : 0; @endphp {{ number_format($totalNpMargin, 2) }}% | ||