Back

CUSTOMER MONTHLY REPORT

{{ $customer->name }}

{{ $reportPeriod }}

Generated on {{ now()->format('d M Y H:i') }}

Phone: {{ $customer->phone }}
Email: {{ $customer->email ?? '-' }}
Address: {{ $customer->address ?? '-' }}
City: {{ $customer->city ?? '-' }}{{ $customer->state ? ', ' . $customer->state : '' }}
Total SKUs
{{ $totalSkus }}
Total Qty
{{ number_format($totalQty) }}
Total Orders
{{ $totalOrders }}
Total Value
RM {{ number_format($totalValue, 2) }}

PRODUCT SUMMARY

@if($products->count() > 0) @foreach($products as $index => $product) @endforeach
No. SKU Product Name Quantity Avg Price Total Value
{{ $index + 1 }} {{ $product->sku }} {{ $product->product_name }} {{ number_format($product->total_qty) }} RM {{ number_format($product->avg_price, 2) }} RM {{ number_format($product->total_value, 2) }}
TOTAL: {{ number_format($totalQty) }} RM {{ number_format($totalValue, 2) }}
@else
No products purchased during this period.
@endif

ORDERS BREAKDOWN

@if($orderBreakdown->count() > 0) @foreach($orderBreakdown as $index => $order) @endforeach
No. Invoice No. Date Total Paid Status
{{ $index + 1 }} {{ $order->invoice_number }} {{ \Carbon\Carbon::parse($order->invoice_date)->format('d M Y') }} RM {{ number_format($order->total, 2) }} RM {{ number_format($order->amount_paid, 2) }} {{ ucfirst($order->payment_status) }}
TOTAL: RM {{ number_format($totalValue, 2) }} RM {{ number_format($totalPaid, 2) }}
@else
No orders found during this period.
@endif

Prepared By:

{{ auth()->user()->name ?? 'User' }}

Name & Signature

Acknowledged By:

______________________

Customer Signature

Printed on {{ now()->format('d M Y H:i:s') }} | {{ \App\Models\SystemSetting::getCompany('name', 'Company') }}

This is a computer-generated document. No signature is required unless specified.