Customerwise Receipt Details

@if(!$is_pdf) @endif

@php $today = \Carbon\Carbon::now()->setTimezone('Asia/Kolkata')->toDateString(); @endphp
@php $groupedReceipts = collect($receipts) ->sortBy('trans_date') ->groupBy(function ($receipt) { return \Carbon\Carbon::parse($receipt->trans_date)->format('Y-m-d'); }) ->map(function ($dateGroup) { return $dateGroup->groupBy('customer_id'); }); $grandTotal = 0; @endphp @foreach($groupedReceipts as $date => $customers) {{-- DATE --}} @foreach($customers as $customerId => $customerReceipts) @php $customer = $customerReceipts->first(); $customerTotal = $customerReceipts->sum('pay_amount'); $grandTotal += $customerTotal; @endphp {{-- CUSTOMER --}} @php $totalAmountSum = 0; @endphp @foreach($customerReceipts as $receipt) @php $checks = $receipt->row_type ?? ''; @endphp @if($checks == 'Refund') @php $totalAmountSum -= $receipt->refund_amount; $grandTotal -= $receipt->refund_amount; @endphp @else @php $totalAmountSum += $receipt->pay_amount; @endphp @endif @endforeach {{-- CUSTOMER TOTAL --}} @endforeach

Receipt No	Order No	Invoice No	Order Date	Amount	Payment Mode	Details	Receipt Type	Order Status	Remark
{{ \Carbon\Carbon::parse($date)->format('d-M-Y') }}
{{ $customer->customer_display_name }}
{{ $receipt->refund_reference_no ?? '-' }}	{{ $receipt->order_code ?? '-' }}	{{ $receipt->invoice_no ?? '-' }}	@if(!empty($receipt->order_date)) {{ \Carbon\Carbon::parse($receipt->order_date)->format('d-M-Y') }} @else - @endif	-₹{{ number_format((float)$receipt->refund_amount, 2) }}	{{ $receipt->payment_mode ?? '-' }}	@if(!empty($receipt->bank_name)) Bank: {{ $receipt->bank_name }} @endif @if(!empty($receipt->account_number)) Ac No: {{ $receipt->account_number }} @endif @if(!empty($receipt->ifsc_code)) IFSC: {{ $receipt->ifsc_code }} @endif @if(!empty($receipt->reference_id)) Txn ID: {{ $receipt->reference_id }} @endif @if(!empty($receipt->cheque_number)) Cheque No: {{ $receipt->cheque_number }} @endif @if( empty($receipt->bank_name) && empty($receipt->reference_id) && empty($receipt->cheque_number) ) - @endif	{{ $receipt->receipt_type ?? '-' }}	{{ $receipt->order_status ?? '-' }}	{{ $receipt->remark ?? '-' }}	{{ $receipt->receipt_id ?? '-' }}	{{ $receipt->order_code ?? '-' }}	{{ $receipt->invoice_no ?? '-' }}	@if(!empty($receipt->order_date)) {{ \Carbon\Carbon::parse($receipt->order_date)->format('d-M-Y') }} @else - @endif	₹{{ number_format((float)$receipt->pay_amount, 2) }}	{{ $receipt->payment_mode ?? '-' }}	@if(!empty($receipt->bank_name)) Bank: {{ $receipt->bank_name }} @endif @if(!empty($receipt->account_number)) Ac No: {{ $receipt->account_number }} @endif @if(!empty($receipt->ifsc_code)) IFSC: {{ $receipt->ifsc_code }} @endif @if(!empty($receipt->reference_id)) Txn ID: {{ $receipt->reference_id }} @endif @if(!empty($receipt->cheque_number)) Cheque No: {{ $receipt->cheque_number }} @endif @if( empty($receipt->bank_name) && empty($receipt->reference_id) && empty($receipt->cheque_number) ) - @endif	{{ $receipt->receipt_type ?? '-' }}	{{ $receipt->order_status ?? '-' }}	{{ $receipt->remark ?? '-' }}
				₹{{ number_format((float)$totalAmountSum, 2) }}

@endforeach

Grand Total : ₹{{ number_format($grandTotal, 2) }}

@if(!$is_pdf) Download @endif