@php
use App\Enums\DateTimeFormats;
use Carbon\Carbon;
@endphp
Collection Report PDF
SL
Shop Name
Shop Code
Customer Name
Customer Mobile Number
Guarantor Mobile Number
Product
Order
Sale
Product Price
Payment Received
Outstanding
Due Amount (TK)
Status
Date
Number
Date
Bill Number
No of Inst.
Inst. Amount (TK)
Down Payment
Security Money
EMI
@foreach($productOrders as $productOrder)
{{ $loop->iteration }}
{{ $productOrder?->dealerDetail?->shop_name }}
{{ $productOrder?->dealerDetail?->dealer_code }}
{{ $productOrder?->customerDetail?->cust_nid_name_en }}
{{ $productOrder?->customerDetail?->user?->mobile_number }}
{{ $productOrder?->guarantor->pluck('guar_mobile_number')->implode(', ') }}
{{ $productOrder?->product?->product_name }}
{{ $productOrder?->created_at?->format(DateTimeFormats::CLIENT_DATE) }}
{{ $productOrder?->order_number }}
{{ $productOrder?->delivery_date ? Carbon::parse($productOrder?->delivery_date)?->format(DateTimeFormats::CLIENT_DATE) : null }}
{{ explode('.', $productOrder?->bill_number)[3] ?? '-' }}
{{ $productOrder?->tenure_months }}
{{ $productOrder?->installment_amount }}
{{ $productOrder?->total_price }}
{{ $productOrder?->down_payment }}
{{ $productOrder?->security_money }}
{{ $productOrder?->collected_emi_amount }}
{{ $productOrder->outstanding_amount }}
{{ $productOrder->due_amount }}
{{$productOrder->due_days }}
@endforeach
Total
{{ $productOrders->sum('total_price') }}
{{ $productOrders->sum('down_payment') }}
{{ $productOrders->sum('security_money') }}
{{ $productOrders->sum('collected_emi_amount') }}
{{ $productOrders->sum('outstanding_amount') }}
{{ $productOrders->sum('due_amount') }}