{{-- Excel table title format start --}}
{{ config('settings.company_name') }}
{{ config('settings.address_1') }}
{{ $extra['branch'] ? $extra['branch']->name : 'All Projects' }} Vendor Liability Report @if ($search_by['from'] && $search_by['to']) From: {{ $transaction->date_format($search_by['from']) }} To: {{ $transaction->date_format($search_by['to']) }} @else {{ 'Upto ' . $transaction->date_format(now()) }} @endif
{{-- Excel title format end --}} @php $i = 1; @endphp {{-- {{dd($infos)}} --}} @foreach ($infos as $info) @php $cr += $info->cr; $dr += $info->dr; $i++; @endphp @endforeach @php $balance_amount_total = $dr - $cr; @endphp
S/no Vendor Name Paid Total Balance
{{ $i }} {{ $info->name }} {{ $transaction->convert_money_format($info->dr) }} {{ $transaction->convert_money_format($info->cr) }} @php $balance_amount = $info->dr - $info->cr; @endphp @if ($balance_amount > 0) {{ $transaction->convert_money_format($balance_amount) }} @else ({{ $transaction->convert_money_format(abs($balance_amount)) }}) @endif
Total {{ $transaction->convert_money_format($dr) }} {{ $transaction->convert_money_format($cr) }} @if ($balance_amount_total > 0) {{ $transaction->convert_money_format($balance_amount_total) }} @else ({{ $transaction->convert_money_format(abs($balance_amount_total)) }}) @endif