@php $payments = \App\Models\InvoicePayment::whereDate('date','>=',$start_date)->whereDate('date','<=',$end_date)->latest(); if($branch != '') { $payments->where('created_by',$branch); } if($payment_mode != '') { $payments->where('payment_mode',$payment_mode); } $payments = $payments->orderBy('voucher_no','asc')->get(); @endphp

Customer Payment Report

@if($branch != '') @php $branchUser = \App\Models\User::where('id',$branch)->first(); @endphp

[{{ $branchUser->name; }}]

@endif

{{$lang->data['start_date'] ?? 'Start Date'}}: {{ \Carbon\Carbon::parse($start_date)->format('d/m/Y') }}

{{$lang->data['end_date'] ?? 'End Date'}}: {{ \Carbon\Carbon::parse($end_date)->format('d/m/Y') }}

@foreach ($payments as $item) @if($item->payment_type == 1) @elseif($item->payment_type == 2) @elseif($item->payment_type == 3) @endif @endforeach

Voucher No	Date	Customer	Paid Amount	Payment Method	{{$lang->data['payment_type']??'Payment Type'}}	Branch
#{{$item->voucher_no}}	{{$item->date->format('d/m/Y')}}	[{{$item->customer->file_number ?? ''}}] {{$item->customer->first_name ?? ''}}	{{getFormattedCurrency($item->paid_amount)}}	{{getPaymentMode($item->payment_mode)}}	{{$lang->data['invoice']??'Invoice'}} #{{$item->invoice->invoice_number ?? ''}}	{{$lang->data['opening_balance']??'Opening Balance'}}	{{$lang->data['cash_receipt']??'Cash Receipt'}}	{{$item->createdBy->name ?? ''}}

Total Payments: {{$payments->count()}}

Total Amount Received: {{getFormattedCurrency($payments->sum('paid_amount'))}}