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
| 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 | settlement_number }}')"> {{ 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) }} | ||||
| 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) }} |
| 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) }} |
| 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) }} |
| 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) }}% |