@php $total_payable_amount = $total_received_amount = $total_balance_amount = $total_till_month_amount = 0; @endphp @foreach ($sells as $sell) @php $documentation_charges = $sell->documentation_charges_with_discounts; $till_month_doc_charges = $sell->till_month_doc_charges_due; $payable_amount = $documentation_charges->sum('payable_amount'); // $received_amount = $documentation_charges->sum('received_amount'); $received_amount = $collections[$sell->id]; $balance_amount = $payable_amount - $received_amount; $till_month_amount = $till_month_doc_charges->sum('payable_amount') - $till_month_doc_charges->sum('received_amount'); $total_payable_amount += $payable_amount; $total_received_amount += $received_amount; $total_balance_amount += $balance_amount; $total_till_month_amount += $till_month_amount; @endphp @endforeach

{{ __('lang.sno') }}	{{ __('lang.project') }}	{{ __('lang.registration_no') }}	{{ __('lang.property') }}	{{ __('lang.customer') }}	{{ __('lang.amount') }}	{{ __('lang.received_amount') }}	{{ __('lang.balance_amount') }}	{{ __('lang.total_due_till_month') }}
{{ $loop->iteration }}	{{ $sell->branch->name ?? '-' }}	{{ $sell->registration_no ?? '-' }}	{{ $sell->product->product_unique_id ?? '-' }}	{{ $sell->customer->name ?? '-' }}	{{ Transaction::convert_money_format($payable_amount) }}	{{ Transaction::convert_money_format($received_amount) }}	{{ Transaction::convert_money_format($balance_amount) }}	{{ Transaction::convert_money_format($till_month_amount) }}
Total					{{ $transaction->convert_money_format($total_payable_amount) }}	{{ $transaction->convert_money_format($total_received_amount) }}	{{ $transaction->convert_money_format($total_balance_amount) }}	{{ $transaction->convert_money_format($total_till_month_amount) }}