@push('header') @endpush
{{-- Report Header --}}

Moon Traders
Daily 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[] = 'Employee: ' . ($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

@foreach ($settlements as $index => $settlement) @endforeach @if($settlements->count() > 0) @endif
Sr# Date Setl # Salesman Vehicle Total Sales Rtn Net Sales Cash Credit Recovery Expense Shortage Net Profit Net Deposit
{{ $loop->iteration }} {{ $settlement->settlement_date->format('d-m-y') }} @if($settlement->status === 'posted') (P) {{ str_replace(['Warehouse - I', 'Warehouse - II', 'Warehouse'], ['W-I', 'W-II', 'W'], $settlement->warehouse->warehouse_name) }} @else (D) {{ str_replace(['Warehouse - I', 'Warehouse - II', 'Warehouse'], ['W-I', 'W-II', 'W'], $settlement->warehouse->warehouse_name) }} @endif {{ preg_replace('/^SETTLE-\d{4}-(\d+)$/', '$1', $settlement->settlement_number) }} {{ preg_replace('/^SETTLE-\d{2}(\d{2})-(\d+)$/', 'S$1$2', $settlement->settlement_number) }}
{{ $settlement->employee->name ?? 'N/A' }}
{{ $settlement->vehicle->vehicle_number ?? 'N/A' }}
{{ number_format($settlement->total_sales_amount, 2) }} {{ number_format($settlement->total_quantity_returned, 0) }} {{ number_format($settlement->net_sales_amount, 2) }} {{ number_format($settlement->cash_collected, 2) }} {{ number_format($settlement->credit_sales_amount, 2) }} {{ number_format($settlement->credit_recoveries, 2) }} {{ number_format($settlement->expenses_claimed, 2) }} {{ number_format($settlement->total_quantity_shortage, 2) }} {{ number_format($settlement->gross_profit - $settlement->expenses_claimed, 2) }} {{ number_format($settlement->cash_to_deposit, 2) }}
Page Total ({{ $settlements->count() }} rows): {{ number_format($settlements->sum('total_sales_amount'), 2) }} {{ number_format($settlements->sum('total_quantity_returned'), 0) }} {{ number_format($summary['total_sales'], 2) }} {{ number_format($summary['cash_collected'], 2) }} {{ number_format($summary['credit_sales'], 2) }} {{ number_format($summary['recoveries'], 2) }} {{ number_format($summary['expenses_claimed'], 2) }} {{ number_format($summary['total_quantity_shortage'], 2) }} {{ number_format($summary['gross_profit'] - $summary['expenses_claimed'], 2) }} {{ number_format($summary['cash_to_deposit'], 2) }}
@if($settlements->count() > 0)

Quantity Summary

Metric Value
Sold {{ number_format($summary['total_quantity_sold'], 2) }}
Returned {{ number_format($summary['total_quantity_returned'], 2) }}
Shortage {{ number_format($summary['total_quantity_shortage'], 2) }}

Cash Management

Metric Amount
Cash Coll. {{ number_format($summary['cash_collected'], 2) }}
Expenses {{ number_format($summary['expenses_claimed'], 2) }}
To Deposit {{ number_format($summary['cash_to_deposit'], 2) }}

Payment Methods

Method Amount
Cash {{ number_format($summary['cash_sales'], 2) }}
Credit {{ number_format($summary['credit_sales'], 2) }}
Recoveries {{ number_format($summary['recoveries'], 2) }}
Cheque {{ number_format($summary['cheque_sales'], 2) }}

Profitability

Metric Value
Total Sales {{ number_format($summary['total_sales'], 2) }}
Gross Profit {{ number_format($summary['gross_profit'], 2) }}
GP Margin {{ number_format($summary['gross_profit_margin'], 2) }}%
Net Profit {{ number_format($summary['gross_profit'] - $summary['expenses_claimed'], 2) }}
NP Margin @php $netProfit = $summary['gross_profit'] - $summary['expenses_claimed']; $netProfitMargin = $summary['total_sales'] > 0 ? ($netProfit / $summary['total_sales']) * 100 : 0; @endphp {{ number_format($netProfitMargin, 2) }}%
@endif
@push('scripts') @endpush