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

<table class="table  table-bordered" style="border-top: 0px !important">
    <thead>
        <tr class= "fixed_tr">
            <th class = "text-center">{{__('lang.sno')}}</th>
            <th>{{__('lang.particulars')}}</th>
            <th >{{__('lang.ratio')}}</th>
            <th>{{__('lang.capital')}}</th>
            <th>{{__('lang.profit')}}</th>
            <th>{{__('lang.profit_ratio')}}</th>
            <th>{{$total_share}} % {{__('lang.working_share')}}</th>
            <th>{{__('lang.actual_profit_share')}}</th>
            <th>{{__('lang.profit')}}</th>
        </tr>
    </thead>
    <tbody>
        @php
            $total_ratio                    = 0;
            $total_capital_amount           = 0;
            $total_profit                   = 0;
            $total_working_share            = 0;
            $total_actual_profit_share      = 0;

            $net_profit_loss = abs($net_profit_loss);
        @endphp
        @foreach ($unofficial_company_investors_data as $unofficial_company_investor_data)
            
            @php
                $capital_amount             = $unofficial_company_investor_data['capital_amount'];
                $share_in_percentage        = $unofficial_company_investor_data['share_in_percentage'];
                $is_head_investor           = $unofficial_company_investor_data['is_head_investor'];

                if ($share_in_percentage == 0) {
                    $profit                     = 0;
                    $profit_rounded             = 0;
                    $profit_ratio_rounded       = 0;
                    $working_share_rounded      = 0;
                    $actual_profit_share        = 0;
                    $profit_percentage_rounded  = 0;
                } 
                else 
                {
                    $profit                         = $net_profit_loss * (($share_in_percentage)/100);
                    $profit_rounded                 = round($profit , 2);

                    if($capital_amount == 0) {
                        $profit_ratio = 0;
                    } 
                    else {
                        $profit_ratio               = ($profit/($capital_amount)) * 100;
                    }
                    $profit_ratio_rounded           = round($profit_ratio, 2);

                    $working_share                  = $profit * ($total_share/100);
                    $working_share_rounded          = round($working_share , 2);

                    if($is_head_investor) {
                        $working_share_rounded      = 0;
                    }

                    $actual_profit_share            = $profit_rounded - $working_share_rounded;

                    if($capital_amount == 0) {
                        $profit_percentage          = 0;
                    } 
                    else {
                        $profit_percentage          = ($actual_profit_share / ($capital_amount)) * 100;
                    }
                    $profit_percentage_rounded      = round($profit_percentage , 2);
                }

                $total_ratio                += $share_in_percentage;
                $total_capital_amount       += $capital_amount;
                $total_profit               += $profit_rounded;
                $total_working_share        += $working_share_rounded;
                $total_actual_profit_share  += $actual_profit_share;
            @endphp
            @if($share_in_percentage > 0)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td>{{ $unofficial_company_investor_data['investor_name'] ?? "-" }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($share_in_percentage ?? "-") }}%</td>
                    <td class="text-right">{{ $transaction->convert_money_format($capital_amount ?? "-") }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($profit_rounded ?? "-") }}</td>
                    <td class="text-right">{{ $profit_ratio_rounded }}%</td>
                    <td class="text-right">{{ $transaction->convert_money_format($working_share_rounded ?? "-") }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($actual_profit_share ?? "-") }}</td>
                    <td class="text-right">{{ $profit_percentage_rounded }}%</td>
                </tr>
            @endif
        @endforeach

        <tr>
            <th colspan="2" class = "text-right">{{__('lang.total')}}</th>
            <th class="text-right">{{$total_ratio}}%</th>              
            <th class="text-right">{{$transaction->convert_money_format($total_capital_amount)}}</th>              
            <th class="text-right">{{$transaction->convert_money_format($total_profit)}}</th>              
            <th class="text-right"></th>              
            <th class="text-right">{{$transaction->convert_money_format($total_working_share)}}</th>              
            <th class="text-right">{{$transaction->convert_money_format($total_actual_profit_share)}}</th>              
            <th class="text-right"></th>              
        </tr>
    </tbody>
</table>