@php            
    
    $is_detail = $report_type  
@endphp

<table>
    <tr>
        <th></th>
        <th></th>
        <th></th>
        <td colspan="12" style="font-size: 20px!important;text-align: center;">
            {{ config('settings.company_name')}}
        </td>
    </tr>
    <tr> 
        <th></th>
        <th></th>
        <th></th>
        
        
        <td style="text-align: center;" colspan="12">
            
            {{ config('settings.address_1')}}, {{ config('settings.address_2')}}, {{ config('settings.city')}}
            
        </td>
    </tr>
    
</table>

<table>

    <tr>
        <th></th>
        <th></th>
        <th></th>
        
        <td colspan="12" style="font-size: 20px!important;text-align: center;">
            {{$heading}}
        </td>
    </tr>
    <tr> 
            <th></th>
            <th></th>
            <th></th>
        <td style="text-align: center;" colspan="12">
            
        @if($search_by['from'] && $search_by['to'])

                
                <b>From:</b> {{ $search_by['from'] }} 
                <b>To:</b> {{ $search_by['to'] }}
            
        @else

                <b>{{ 'Upto ' .now() }} </b>
        
        @endif
            
        </td>
    </tr>
    
</table>

   
<div>
    <table class="table table-bordered" style="width:50%">
        <thead>
            <tr>
                <th>{{__('lang.description')}}</th>
                <th>{{__('lang.amount')}}
                </th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>{{__('lang.all_expenses')}}</td>
                <td>{{  $transaction->convert_money_format($total_expenses) }}</td>
            </tr>

            
            @foreach ($investors as $investor)
            <tr>
                <td>{{ $investor->name }}</td>
                <td>{{  $transaction->convert_money_format($investor->invested_amount) }}</td>
            </tr>
                
            @endforeach

            @php
                $cash_and_bank_balance =  $total_expenses -$investors->sum('invested_amount');
            @endphp

            <tr>
                <td>{{__('lang.cash_and_bank_balance')}}</td>
                <td>{{ $transaction->convert_money_format($cash_and_bank_balance) }}</td>
            </tr>
        </tbody>


    </table>
</div>
<div>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>{{__('lang.detail_of_expenses_as_per_partner_ratio')}}</th>
                @foreach ($investors as $investor)
                <th class="text-center">
                    {{ $investor->name }} <br> {{ $investor->percentage }}%

                </th>
                @endforeach
                <th class="text-center">{{__('lang.total')}}</th>
            </tr>
        </thead>

        @php
            $grand_totals = [];
        @endphp
        <tbody>
            <tr>
                <td>{{__('lang.all_expenses')}}</td>
                @foreach ($investors as $investor)
                @php
                    $grand_totals[$investor->id] += $investor->expenses_share;
                @endphp
                <td>
                    {{ $transaction->convert_money_format($investor->expenses_share) }}

                </td>
                @endforeach
                <td>{{ $transaction->convert_money_format($investors->sum('expenses_share')) }}</td>
            </tr>
            <tr>
                <td>{{__('lang.invested_amount')}}</td>
                @foreach ($investors as $investor)
                @php
                    $grand_totals[$investor->id] += $investor->invested_amount;
                @endphp
                <td>
                    {{ $transaction->convert_money_format($investor->invested_amount) }}

                </td>
                @endforeach
                <td>{{ $transaction->convert_money_format($investors->sum('invested_amount')) }}</td>
            </tr>
            {{-- <tr>
                <td>{{__('lang.loan')}}</td>
                @foreach ($investors as $investor)
                @php
                    $grand_totals[$investor->id] += $investor->loan_amount;
                @endphp
                <td>
                    {{ $transaction->convert_money_format($investor->loan_amount) }}
                </td>
                @endforeach
                <td>-</td>
            </tr> --}}
            <tr>
                <td>{{__('lang.capital_excess_and_short')}}</td>
                @foreach($grand_totals as $grand_total)
                    <td>{{ $transaction->convert_money_format($grand_total) }}</td>
                @endforeach
                <td>{{  $transaction->convert_money_format($investors->sum('expenses_share') - $investors->sum('invested_amount'))  }} </td>
            </tr>
        </tbody>

    </table>
</div>