@php

$is_official            = request()->is_official;
$show_official_tag      = !empty($is_official) && $is_official != 'combine';

$show_official          = ($is_official == 'official' ||  $is_official == 'separate' ||  $is_official == 'combine' || empty($is_official)); 
$show_unofficial        = ($is_official == 'unofficial' ||  $is_official == 'separate'); 

$is_summary             = request()->report_type =='summary';

$currency_code          = $transaction->systemSettingCurrency();
$with_bf                = request()->with_bf && !$is_summary;
$summary_sub_grp_ids    = request()->custom_summary_subgroup_ids ?? [];


@endphp
<table>
    <tr>
        <th></th>
        <th></th>
        <th></th>
        <td colspan="9" 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="9">
            {{ config('settings.address_1') }}
        </td>
    </tr>

</table>

<table>

    <tr>
        <th></th>
        <th></th>
        <th></th>
        <td colspan="9" style="font-size: 20px!important;text-align: center;">
            {{ $heading }}
        </td>
    </tr>
    <tr>
        <th></th>
        <th></th>
        <th></th>
        <td style="text-align: center;" colspan="9">
            @if ($search_by['from'])
                <b>{{__('lang.from')}}</b> {{ $transaction->date_format($search_by['from']) }}
            @endif

            {{__('lang.till')}}
            
            @if ( $search_by['to'])
                <b>{{__('lang.from')}}</b> {{ $transaction->date_format($search_by['to']) }}
            @endif

            @if (  !$search_by['to'] ||  !$search_by['to'])
                <b>{{  $transaction->date_format(now()) }} </b>
            @endif

           
        </td>
    </tr>

</table>

<table class="table table-bordered table-hover" style="font-size: 12px; width: 100%;">
    <thead>
        <tr class="fixed_tr">
            <th>{{__('lang.code')}}</th>
            <th>{{__('lang.name')}}</th>

            @if($show_official && $with_bf)
            <th class="text-right">{{__('lang.bf')}} {{ $currency_code }} @if($show_official_tag)  <br> ({{__('lang.official')}}) @endif</th>
            @endif

            @if($show_unofficial && $with_bf)
            <th class="text-right">{{__('lang.bf')}} {{ $currency_code }} <br> ({{__('lang.unofficial')}})</th>
            @endif


            @if($show_official)
            <th class="text-right">{{__('lang.dr')}} {{ $currency_code }} @if($show_official_tag)  <br> ({{__('lang.official')}}) @endif</th>
            <th class="text-right">{{__('lang.cr')}} {{ $currency_code }} @if($show_official_tag)  <br> ({{__('lang.official')}}) @endif</th>
            <th class="text-right">{{__('lang.balance')}} {{ $currency_code }} @if($show_official_tag)  <br> ({{__('lang.official')}}) @endif</th>
            @endif
           
            @if($show_unofficial)
            <th class="text-right">{{__('lang.dr')}} {{ $currency_code }}        <br> ({{__('lang.unofficial')}}) </th>
            <th class="text-right">{{__('lang.cr')}} {{ $currency_code }}        <br> ({{__('lang.unofficial')}}) </th>
            <th class="text-right">{{__('lang.balance')}} {{ $currency_code }}   <br> ({{__('lang.unofficial')}}) </th>
            @endif
        </tr>
    </thead>
    <tbody>

        @php
          
            $grand_dr           = 0;
            $grand_cr           = 0;
            $grand_bf          = $grand_bf_unofficial = 0;
        @endphp
        @foreach ($heads_data as $type_name => $type_data)
            <tr >
                <th colspan="100%" style="padding-left:30px" class="border_bottom bold">{{ $type_name }}</th>
            </tr>

            @foreach ($type_data as $group_name => $group_data )

                @php
                    $group_dr            =  $group_cr            = 0;
                    $group_dr_unofficial =  $group_cr_unofficial = 0;
                    $group_bf            =  $group_bf_unofficial = 0;
                @endphp
                <tr>
                    <td colspan="100%" style="padding-left:60px" class="border_bottom bold">{{ $group_name }}</td>
                </tr>

                @foreach ($group_data  as $sub_group_name => $sub_group_data )

                    @php
                        $sub_group_dr            =  $sub_group_cr            = 0;
                        $sub_group_dr_unofficial =  $sub_group_cr_unofficial = 0;
                        $sub_group_bf            =  $sub_group_bf_unofficial = 0;
                        $subgroup_id             =  reset($sub_group_data)['subgroup_id'];

                        $summary_group      =  $is_summary || in_array($subgroup_id,$summary_sub_grp_ids);


                        $sub_total_text = __('lang.sub_total');
                        if($summary_group){
                            $sub_total_text = $sub_group_name;
                        }

                    @endphp
                    <tr @if($summary_group) style="display: none" @endif >
                        <td colspan="100%" style="padding-left:90px" class="border_bottom bold">{{ $sub_group_name }}</td>
                    </tr>

                    @foreach ($sub_group_data as $head_data )
                        @php
                            $head_data                  = (object) $head_data;
                            $head_code                  = $head_data->head_code ?? '-';
                            $head_name                  = $head_data->head->name ?? '-';
                            $dr_sum                     = $head_data->dr_sum;
                            $cr_sum                     = $head_data->cr_sum;

                            $dr_sum_unofficial          = $head_data->dr_sum_unofficial;
                            $cr_sum_unofficial          = $head_data->cr_sum_unofficial;

                            $brought_forward            = $head_data->brought_forward;
                            $brought_forward_unofficial = $head_data->brought_forward_unofficial;

                            $balance                    = $brought_forward + ($dr_sum - $cr_sum);
                            $balance_unofficial         = $brought_forward_unofficial + ($dr_sum_unofficial - $cr_sum_unofficial);


                            $sub_group_dr                   += $dr_sum;
                            $sub_group_cr                   += $cr_sum;
                            $sub_group_bf                   += $brought_forward;


                            $sub_group_dr_unofficial        += $dr_sum_unofficial;
                            $sub_group_cr_unofficial        += $cr_sum_unofficial;
                            $sub_group_bf_unofficial        += $brought_forward_unofficial;

                            $group_dr                       += $dr_sum;
                            $group_cr                       += $cr_sum;
                            $group_bf                       += $brought_forward;

                            $group_dr_unofficial            += $dr_sum_unofficial;
                            $group_cr_unofficial            += $cr_sum_unofficial;
                            $group_bf_unofficial            += $brought_forward_unofficial;
                            
                            $grand_dr                       += $dr_sum;
                            $grand_cr                       += $cr_sum;
                            $grand_bf                       += $brought_forward;
                            
                            $grand_dr_unofficial            += $dr_sum_unofficial;
                            $grand_cr_unofficial            += $cr_sum_unofficial;
                            $grand_bf_unofficial            += $brought_forward_unofficial;

                            $route_data=[
                                'action'                 =>'Show',
                                'income_expense_head_id' => $head_data->head->id,
                                'is_official'            => request()->is_official,
                                'from'                   => $with_bf ? request()->from : null,
                                'to'                     =>  request()->to ,
                                'branch_id'              => request()->branch_id,
                            ];

                            $route     = route('reports_accounts_ledger.new.list',$route_data);
                            
                            $hide_head = $head_data->head->head_check == 1;
                        @endphp
                        
                        @if(!$summary_group && !$hide_head)
                            <tr>
                                <td class="text-right" style="padding-left:120px">{{ $head_code }}</td>
                                    <td>
                                        <a href="{{ $route }}" target="_blank">{{ $head_name }}</a>
                                    </td>

                                @if($show_official && $with_bf)
                                    <td class="text-right">{{ $transaction->isNegative($brought_forward) }}</td>
                                @endif

                                @if($show_unofficial && $with_bf)
                                    <td class="text-right">{{ $transaction->isNegative($brought_forward_unofficial) }}</td>
                                @endif

                                @if($show_official)
                                    <td class="text-right">{{ $transaction->isNegative($dr_sum) }}</td>
                                    <td class="text-right">{{ $transaction->isNegative($cr_sum) }}</td>
                                    <td class="text-right">{{ $transaction->isNegative($balance) }}</td>
                                @endif

                                @if($show_unofficial)
                                    <td class="text-right">{{ $transaction->isNegative($dr_sum_unofficial) }}</td>
                                    <td class="text-right">{{ $transaction->isNegative($cr_sum_unofficial) }}</td>
                                    <td class="text-right">{{ $transaction->isNegative($balance_unofficial) }}</td>
                                @endif
                            </tr>
                        @endif

                    @endforeach
                    

                    <tr class="@if($summary_group) sub_total_summary @endif">
                    
                            <th @if($summary_group)  style="padding-left:90px" class="sub_total" @else class="text-right" @endif colspan="2">{{ $sub_total_text }}</th>

                        @if($show_official && $with_bf)
                            <th class="sub_total">{{ $transaction->isNegative($sub_group_bf) }}</th>
                        @endif

                        @if($show_unofficial && $with_bf)
                            <th class="sub_total">{{ $transaction->isNegative($sub_group_bf_unofficial) }}</th>
                        @endif


                        @if($show_official)
                            <th class="text-right sub_total">{{ $transaction->isNegative($sub_group_dr) }}</th>
                            <th class="text-right sub_total">{{ $transaction->isNegative($sub_group_cr) }}</th>
                            <th class="text-right sub_total">{{ $transaction->isNegative($sub_group_bf + ($sub_group_dr - $sub_group_cr)) }}</th>
                        @endif

                        @if($show_unofficial)
                            <th class="text-right sub_total">{{ $transaction->isNegative($sub_group_dr_unofficial) }}</th>
                            <th class="text-right sub_total">{{ $transaction->isNegative($sub_group_cr_unofficial) }}</th>
                            <th class="text-right sub_total">{{ $transaction->isNegative($sub_group_bf_unofficial + ($sub_group_dr_unofficial - $sub_group_cr_unofficial)) }}</th>
                        @endif
                    </tr>

                @endforeach
               

                <tr>
                    <th class="text-right" colspan="2">{{__('lang.group_total')}}</th>
                    @if($show_official && $with_bf)
                        <th>{{ $transaction->isNegative($group_bf) }}</th>
                    @endif

                    @if($show_unofficial && $with_bf)
                        <th>{{ $transaction->isNegative($group_bf_unofficial) }}</th>
                    @endif

                    @if($show_official)
                        <th class="text-right">{{ $transaction->isNegative($group_dr) }}</th>
                        <th class="text-right">{{ $transaction->isNegative($group_cr) }}</th>
                        <th class="text-right">{{ $transaction->isNegative($group_bf + ($group_dr - $group_cr)) }}</th>
                    @endif

                    @if($show_unofficial)
                        <th class="text-right">{{ $transaction->isNegative($group_dr_unofficial) }}</th>
                        <th class="text-right">{{ $transaction->isNegative($group_cr_unofficial) }}</th>
                        <th class="text-right">{{ $transaction->isNegative($group_bf_unofficial + ($group_dr_unofficial - $group_cr_unofficial)) }}</th>
                    @endif
                </tr>
                
            @endforeach
            
        @endforeach

        <tr>
            <th class="text-right" colspan="2">{{__('lang.total')}}</th>
            @if($show_official && $with_bf)
                <th >{{ $transaction->isNegative($grand_bf) }}</th>
            @endif

            @if($show_unofficial && $with_bf)
                <th>{{ $transaction->isNegative($grand_bf_unofficial) }}</th>
            @endif

            @if($show_official)
                <th class="text-right">{{ $transaction->isNegative($grand_dr) }}</th>
                <th class="text-right">{{ $transaction->isNegative($grand_cr) }}</th>
                <th class="text-right">{{ $transaction->isNegative($grand_dr - $grand_cr) }}</th>
            @endif

            @if($show_unofficial)
                <th class="text-right">{{ $transaction->isNegative($grand_dr_unofficial) }}</th>
                <th class="text-right">{{ $transaction->isNegative($grand_cr_unofficial) }}</th>
                <th class="text-right">{{ $transaction->isNegative($grand_bf + ($grand_dr_unofficial - $grand_cr_unofficial)) }}</th>
            @endif
        </tr>
    </tbody>
    
</table>