{{-- Excel table title format start --}}
<table>
    <tr>
        
        <th></th>
        <td colspan="1"  style="font-size: 20px!important;text-align: center;">
            {{ config('settings.company_name') }}
        </td>
    </tr>
    <tr>
        
        <td style="text-align: center;" colspan="3">
            {{ config('settings.address_1') }}
        </td>
    </tr>

</table>

<table>

    <tr>
        
        <th>{{ $extra['branch'] ? $extra['branch']->name : 'All Projects' }}</th>
        <td colspan="1" style="font-size: 20px!important;text-align: center;">
            {{ $heading }}
        </td>
        <td>
            @if ($search_by['from'] && $search_by['to'])
                <b>{{__('lang.from')}}:</b> {{ $transaction->date_format($search_by['from']) }}
                <b>{{__('lang.to')}}:</b> {{ $transaction->date_format($search_by['to']) }}
            @else
                <b>{{ 'Upto ' . $transaction->date_format(now()) }} </b>
            @endif
        </td>
    </tr>
</table>
{{-- Excel title format end --}}

@php
    $count_dr       = count($dr_transactions);
    $count_cr       = count($cr_transactions);
    $max_value      = max($count_dr,$count_cr);
    $range          = range(0,$max_value - 1);
    $show_bf        = $search_by['from'] ? true : false;
    $total_received = $bf;
    $total_paid     = 0;

@endphp

<table class="table  table-bordered" style="border-top: 0px !important">
    <thead>
        <tr class= "fixed_tr">
            <th scope="col" width = 5% class = "text-center">{{__('lang.sno')}}</th>
            <th scope="col" width = 5% class = "text-center">{{__('lang.project_name')}}</th>
            <th scope="col" width = 7% class = "text-center">{{__('lang.voucher_date')}}</th>
            <th scope="col" width = 20% class = "text-center">{{__('lang.collection')}}</th>
            <th scope="col" width = 15% class = "text-right">{{__('lang.amount')}}</th>
            @if ($with_heads == "with_heads")
                <th scope="col" width = 10% class = "text-center">{{__('lang.cr_heads')}}</th>
                <th scope="col" width = 10% class = "text-center">{{__('lang.dr_heads')}}</th>
            @endif
            <td class="center-td" width = 5%></td>
            <th scope="col" width = 5% class = "text-center">{{__('lang.sno')}}</th>
            <th scope="col" width = 5% class = "text-center">{{__('lang.project_name')}}</th>
            <th scope="col" width = 7% class = "text-center">{{__('lang.voucher_date')}}</th>
            <th scope="col" width = 20% class = "text-center">{{__('lang.payment')}}</th>
            <th scope="col" width = 15% class = "text-right">{{__('lang.amount')}}</th>
            @if ($with_heads == "with_heads")
                <th scope="col" width = 10% class = "text-center">{{__('lang.cr_heads')}}</th>
                <th scope="col" width = 10% class = "text-center">{{__('lang.dr_heads')}}</th>
            @endif
        </tr>   
    </thead>
    <tbody>

        @if($show_bf)
            <tr>
                <td></td>
                <td><b>Balance from {{ $transaction->date_format($search_by['from']) }}</b></td>
                <td class = "text-right"><b>{{ $transaction->isNegative($bf) }}</b></td>
            </tr>
        @endif

        @foreach ($range as $key )
            @php
                $dr_transaction         = $dr_transactions[$key] ?? null;
                $dr_transaction_detail  = $dr_transaction ? $dr_transaction->getTransactionDetails($dr_transaction) : null;
                $dr_route               = $dr_transaction_detail->route;
                $dr_particulars         = $dr_transaction->particulars ?? null;
                $dr_voucher_no          = $dr_transaction->voucher_no ?? null;
                $dr_amount              = $dr_transaction->dr ?? 0;
                $total_received         += $dr_amount;

                $cr_transaction         = $cr_transactions[$key] ?? null;
                $cr_transaction_detail  = $cr_transaction ? $cr_transaction->getTransactionDetails($cr_transaction) : null;
                $cr_route               = $cr_transaction_detail->route;
                $cr_particulars         = $cr_transaction->particulars ?? null;
                $cr_voucher_no          = $cr_transaction->voucher_no ?? null;
                $cr_amount              = $cr_transaction->cr ?? 0;
                $total_paid             += $cr_amount;

                $collection_head_name              = [];
                $payment_head_name                 = [];
                if ($dr_transaction) {
                    $collection_head_name          = $dr_transaction->getTransactionHeadNames($dr_transaction);
                }

                if ($cr_transaction) {
                    $payment_head_name             = $cr_transaction->getTransactionHeadNames($cr_transaction);
                }

            @endphp
            <tr>
                <td class = "text-center">{{ $dr_transaction ? $loop->iteration : ''}}</td>
                <td class = "text-center">{{ $dr_transaction->branch->name}}</td>
                <td>{{ $transaction->date_format($dr_transaction->voucher_date)}}</td>
                <td>@if($dr_transaction) <a href="{{  $dr_route }}" target="_blank">({{$dr_voucher_no}})</a> {{$dr_particulars}} @endif </td>
                <td class = "text-right">{{ $dr_transaction ? $transaction->isNegative($dr_amount) : ''}}</td>
                @if ($with_heads == "with_heads")
                    <td>{{$collection_head_name['cr_head_name']}} <br>({{$collection_head_name['cr_group_name']}}-{{$collection_head_name['cr_sub_group_name']}})</td>
                    <td>{{$collection_head_name['dr_head_name_collection']}} <br>({{$collection_head_name['dr_group_name_collection']}}-{{$collection_head_name['dr_sub_group_name_collection']}})</td>
                @endif

                <td class="center-td"></td>

                <td class = "text-center">{{ $cr_transaction ? $loop->iteration : ''}}</td>
                <td class = "text-center">{{ $cr_transaction->branch->name}}</td>
                <td>{{ $transaction->date_format($cr_transaction->voucher_date)}}</td>
                <td>@if($cr_transaction) <a href="{{  $cr_route }}" target="_blank">({{ $cr_voucher_no }})</a> {{$cr_particulars}} @endif </td>
                <td class = "text-right">{{ $cr_transaction ? $transaction->isNegative($cr_amount) : ''}}</td>
                @if ($with_heads == "with_heads")
                    <td>{{$payment_head_name['cr_head_name']}} <br>({{$payment_head_name['cr_group_name']}}-{{$payment_head_name['cr_sub_group_name']}})</td>
                    <td>{{$payment_head_name['dr_head_name']}} <br>({{$payment_head_name['dr_group_name']}}-{{$payment_head_name['dr_sub_group_name']}})</td>
                @endif    
            </tr>
        @endforeach

        <tr>
            <th colspan="4" class = "text-right"> {{__('lang.total_received_amount')}} </th>
            <th class = "text-right"> {{$transaction->isNegative($total_received)}} </th>
            @if ($with_heads == "with_heads")
                <th></th>
                <th></th>
            @endif    
            <td class="center-td"></td>
            <th colspan="4" class = "text-right"> {{__('lang.total_paid_amount')}} </th>
            <th class = "text-right"> {{$transaction->isNegative($total_paid)}} </th>
            @if ($with_heads == "with_heads")
                <th></th>
                <th></th>
            @endif    
        </tr>
        <tr>
            <td></td>
        </tr>
        <tr style="margin-top: 100px !important">
            @if ($with_heads == "with_heads")
                <th colspan="14" class = "text-right">{{__('lang.balance_upper')}}</th>
            @else
                <th colspan="10" class = "text-right">{{__('lang.balance_upper')}}</th>
            @endif
            <th class = "text-right"> {{$transaction->isNegative($total_received - $total_paid)}} </th>
        </tr>
    </tbody>
</table>