{{-- 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

            $max_value_other         = max(count($dr_transactions_other),count($cr_transactions_other));
            $other_head_range        = range(0,$max_value_other - 1);
            $total_received_other         = 0;
            $total_paid_other             = 0;
            
            $max_value_cash         = max(count($dr_transactions_cash),count($cr_transactions_cash));
            $cash_head_range        = range(0,$max_value_cash - 1);
            $total_received_cash         = 0;
            $total_paid_cash             = 0;

        @endphp

        <table class="table  table-bordered" style="border-top: 0px !important">
            <thead>
                <tr>
                    <th colspan="100%" class = "text-center"><h4>Overall Project Report</h4></th>
                </tr>
                <tr class= "fixed_tr">
                    <th scope="col" width = 5% class = "text-center">{{__('lang.sno')}}</th>
                    <th scope="col" width = 20% class = "text-center">{{__('lang.collection')}}</th>
                    <th scope="col" width = 15% class = "text-right">{{__('lang.amount')}}</th>
                    <td class="center-td" width = 5%></td>
                    <th scope="col" width = 5% class = "text-center">{{__('lang.sno')}}</th>
                    <th scope="col" width = 20% class = "text-center">{{__('lang.payment')}}</th>
                    <th scope="col" width = 15% class = "text-right">{{__('lang.amount')}}</th>
                </tr>
            </thead>
            <tbody>

                @foreach ($other_head_range as $key )
                    @php

                        $dr_transaction_other         = $dr_transactions_other[$key] ?? null;
                        $dr_amount                   = $dr_transaction_other->amount ?? 0;
                        $total_received_other         += $dr_amount;

                        $cr_transaction_other         = $cr_transactions_other[$key] ?? null;
                        $cr_amount                   = $cr_transaction_other->amount ?? 0;
                        $total_paid_other             += $cr_amount;


                        $head_data_dr                = $transaction->getHeadData($dr_transaction_other->income_expense_head_id);
                        $head_data_cr                = $transaction->getHeadData($cr_transaction_other->income_expense_head_id);

                    @endphp
                    <tr>
                        <td class = "text-center">{{ $dr_transaction_other ? $loop->iteration : ''}}</td>
                        <td> {{ $head_data_dr->name2 }}</td>
                        <td class = "text-right">{{ $dr_transaction_other ? $transaction->isNegative($dr_amount) : ''}}</td>
                        
                        <td class="center-td"></td>
                        
                        <td class = "text-center">{{ $cr_transaction_other ? $loop->iteration : ''}}</td>
                        <td> {{ $head_data_cr->name2 }}</td>
                        <td class = "text-right">{{ $cr_transaction_other ? $transaction->isNegative($cr_amount) : ''}}</td>
                    </tr>
                @endforeach

                <tr>
                    <th colspan="2" class = "text-right"> {{__('lang.total_received')}} </th>
                    <th class = "text-right"> {{$transaction->isNegative($total_received_other)}} </th>
                    <td class="center-td"></td>
                    <th colspan="2" class = "text-right"> {{__('lang.total_paid')}} </th>
                    <th class = "text-right"> {{$transaction->isNegative($total_paid_other)}} </th>
                </tr>
            
                <tr style="margin-top: 100px !important">
                    <th colspan="6" class = "text-right">{{__('lang.balance_upper')}}</th>
                    <th class = "text-right"> {{$transaction->isNegative($total_received_other - $total_paid_other)}} </th>
                </tr>
            </tbody>

            <tr>
                <td colspan="100%" style="height: 30px"> </td>
            </tr>

            <thead>
                <tr>
                    <th colspan="100%" class = "text-center"><h4>Overall Cash / Bank Report</h4></th>
                </tr>
                <tr class= "fixed_tr">
                    <th scope="col" width = 5% class = "text-center">{{__('lang.sno')}}</th>
                    <th scope="col" width = 20% class = "text-center">{{__('lang.collection')}}</th>
                    <th scope="col" width = 15% class = "text-right">{{__('lang.amount')}}</th>
                    <td class="center-td" width = 5%></td>
                    <th scope="col" width = 5% class = "text-center">{{__('lang.sno')}}</th>
                    <th scope="col" width = 20% class = "text-center">{{__('lang.payment')}}</th>
                    <th scope="col" width = 15% class = "text-right">{{__('lang.amount')}}</th>
                </tr>
            </thead>
            <tbody>

                @foreach ($cash_head_range as $key )
                    @php

                        $dr_transaction_cash         = $dr_transactions_cash[$key] ?? null;
                        $dr_amount                   = $dr_transaction_cash->amount ?? 0;
                        $total_received_cash         += $dr_amount;

                        $cr_transaction_cash         = $cr_transactions_cash[$key] ?? null;
                        $cr_amount                   = $cr_transaction_cash->amount ?? 0;
                        $total_paid_cash             += $cr_amount;


                        $head_data_dr                = $transaction->getHeadData($dr_transaction_cash->income_expense_head_id);
                        $head_data_cr                = $transaction->getHeadData($cr_transaction_cash->income_expense_head_id);

                    @endphp
                    <tr>
                        <td class = "text-center">{{ $dr_transaction_cash ? $loop->iteration : ''}}</td>
                        <td> {{ $head_data_dr->name2 }}</td>
                        <td class = "text-right">{{ $dr_transaction_cash ? $transaction->isNegative($dr_amount) : ''}}</td>
                        
                        <td class="center-td"></td>
                        
                        <td class = "text-center">{{ $cr_transaction_cash ? $loop->iteration : ''}}</td>
                        <td> {{ $head_data_cr->name2 }}</td>
                        <td class = "text-right">{{ $cr_transaction_cash ? $transaction->isNegative($cr_amount) : ''}}</td>
                    </tr>
                @endforeach

                <tr>
                    <th colspan="2" class = "text-right"> {{__('lang.total_received')}} </th>
                    <th class = "text-right"> {{$transaction->isNegative($total_received_cash)}} </th>
                    <td class="center-td"></td>
                    <th colspan="2" class = "text-right"> {{__('lang.total_paid')}} </th>
                    <th class = "text-right"> {{$transaction->isNegative($total_paid_cash)}} </th>
                </tr>
                
                <tr style="margin-top: 100px !important">
                    <th colspan="6" class = "text-right">{{__('lang.balance_upper')}}</th>
                    <th class = "text-right"> {{$transaction->isNegative($total_received_cash - $total_paid_cash)}} </th>
                </tr>
            </tbody>
        </table>