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

</table>

<table>

    <tr>
        <th></th>
        <th></th>
        <th></th>
        <th>{{ $extra['branch'] ? $extra['branch']->name : 'All Projects' }}</th>
        <td colspan="2" style="font-size: 20px!important;text-align: center;">
            TRIAL BALANCE 
        </td>
        <td>
            @if ($search_by['from'] && $search_by['to'])
                <b>From:</b> {{ $transaction->date_format($search_by['from']) }}
                <b>To:</b> {{ $transaction->date_format($search_by['to']) }}
            @else
                <b>{{ 'Upto ' . $transaction->date_format(now()) }} </b>
            @endif
        </td>
    </tr>
</table>
{{-- Excel title format end --}}
@include('admin.partials.search_filters', ['params' => $params])
<table class="table table-bordered table-hover table-margin-width">
    <thead>
        <tr>
            @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "null")
                @if (isset($params['from']) && isset($params['to']))
                    <th scope="col" class="text-center" >  </th>
                @endif
                <th colspan="2" scope="col" class="text-center"></th>

                <th colspan="2" scope="col" class="text-center">DR</th>
                @if (isset($params['from']) && isset($params['to']))
                    <th scope="col" class="text-center" >  </th>
                @endif
                <th colspan="2" scope="col" class="text-center">CR</th>

            
            @endif

        </tr>

        <tr>
            <th scope="col" colspan="{{ $params['summary'] == 0 ? '' : '3' }}" style="width:27%;">{{__('lang.code')}}</th>
            <!--  <th scope="col" style=""></th> -->
            @if ($params['summary'] == 0)
                <th scope="col" class="width-40">{{__('lang.name')}}</th>
            @endif

            @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "null")

                @if (isset($params['from']) && isset($params['to']))
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important"> BF {{$transaction->systemSettingCurrency()}}</th>
                @endif
                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.official')}} {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.unofficial')}} {{$transaction->systemSettingCurrency()}}</th>
                @if (isset($params['from']) && isset($params['to']))
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important"> BF {{$transaction->systemSettingCurrency()}}</th>
                @endif
                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.official')}} {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.unofficial')}} {{$transaction->systemSettingCurrency()}}</th>
            @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 1)
                @if (isset($params['from']) && isset($params['to']))
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important"> BF {{$transaction->systemSettingCurrency()}}</th>
                @endif
                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.dr')}} {{__('lang.official')}} {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.cr')}} {{__('lang.official')}} {{$transaction->systemSettingCurrency()}}</th>
            @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 0)
                @if (isset($params['from']) && isset($params['to']))
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important"> BF {{$transaction->systemSettingCurrency()}}</th>
                @endif
                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.dr')}} {{__('lang.unofficial')}} {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important">{{__('lang.cr')}} {{__('lang.unofficial')}} {{$transaction->systemSettingCurrency()}}</th>
            @elseif(!isset($params['official_unofficial']))
                @if (isset($params['from']) && isset($params['to']))
                    <th scope="col" class="text-center" style="width:10%; padding:5px !important;vertical-align:middle !important"> BF {{$transaction->systemSettingCurrency()}}</th>
                @endif

                <th scope="col" class="text-right" style="width: 40%;padding:5px !important;vertical-align:middle !important">{{__('lang.dr')}} {{$transaction->systemSettingCurrency()}}</th>
                <th scope="col" class="text-right" style="padding:5px !important;vertical-align:middle !important">{{__('lang.cr')}} {{$transaction->systemSettingCurrency()}}</th>
            @endif
          
        </tr>
    </thead>
    @php
        $totalCR_official = 0;
        $totalDR_official = 0;

        $totalSubGroupCR_official = 0;
        $totalSubGroupDR_official = 0;

        $totalGroupCR_official = 0;
        $totalGroupDR_official = 0;

        $totalCR_unofficial = 0;
        $totalDR_unofficial = 0;

        $totalSubGroupCR_unofficial = 0;
        $totalSubGroupDR_unofficial = 0;
        
        $totalGroupCR_unofficial = 0;
        $totalGroupDR_unofficial = 0;



    @endphp

    @foreach ($data as $key_t => $type)
        <tbody>
            <tr style="border-top:4px solid;border-bottom:4px solid">
                <th colspan="100%"  > {{ $key_t }}
                </th>
            </tr>
        @foreach ($type as $key => $group)
            <tbody>
                <tr style="border-top:4px solid;border-bottom:4px solid">
                    <th colspan="100%" style="background: #ffffff !important;color: #000;"> <p style="margin:0px;padding-left:60px">{{ $key }}</p>
                    </th>
                </tr>

                @foreach ($group as $sub_key => $sub_group)
                    <tr style="border-top:4px solid;border-bottom:4px solid">
                        <th colspan="4" style="background: #ffffff !important;color: #000;"><p style="margin:0px;padding-left:100px">{{ $sub_key }}</p> </th>
                    </tr>
                    @php
                        $totalSubGroupCR_official = 0;
                        $totalSubGroupDR_official = 0;
                    @endphp
                    <!-- Heads -->
                    @foreach ($sub_group as $key => $value)
                    {{--     @php
                            echo "<pre>";
                            print_r($value);exit;
                        @endphp --}}
                        @php
                            $dr_official = 0;
                            $cr_official = 0;
                            
                            if ($value->official->dr > $value->official->cr) {
                                $dr_official = $value->official->dr - $value->official->cr;
                            } else {
                                $cr_official = $value->official->cr - $value->official->dr;
                            }
                            
                            $totalSubGroupCR_official += $cr_official;
                            $totalSubGroupDR_official += $dr_official;
                            
                            $totalGroupCR_official += $cr_official;
                            $totalGroupDR_official += $dr_official;
                            
                            $totalCR_official += $cr_official;
                            $totalDR_official += $dr_official;




                            $dr_unofficial = 0;
                            $cr_unofficial = 0;
                            
                            if ($value->unofficial->dr > $value->unofficial->cr) {
                                $dr_unofficial = $value->unofficial->dr - $value->unofficial->cr;
                            } else {
                                $cr_unofficial = $value->unofficial->cr - $value->unofficial->dr;
                            }
                            
                            $totalSubGroupCR_unofficial += $cr_unofficial;
                            $totalSubGroupDR_unofficial += $dr_unofficial;
                            
                            $totalGroupCR_unofficial += $cr_unofficial;
                            $totalGroupDR_unofficial += $dr_unofficial;
                            
                            $totalCR_unofficial += $cr_unofficial;
                            $totalDR_unofficial += $dr_unofficial;

                            
                            
                        @endphp
                        @if ($params['summary'] == 0)
                            <tr
                                @if ($search_by['transactions'] == 1) {{ App\Models\Common::hideCrAndDrColumn($dr_official, $cr_official) }} @endif>
                                @php
                                    if (!empty($extra['branch']) || !empty($search_by['from']) || !empty($search_by['to'])) {
                                        $route = route('reports_accounts_ledger.branch_wise.report') . '?income_expense_head_id=' . $value->head_id . '&branch_id=' . $extra['branch']->id . '&from=' . $search_by['from'] . '&to=' . $search_by['to'] . '&date_type=1&status=1&voucher_type=0&official_unofficial='.$params['official_unofficial'].'&action=Show';
                                    } else {
                                        $route = route('reports_accounts_ledger.branch_wise.report') . '?income_expense_head_id=' . $value->head_id . '&branch_id=0&from=&to=&date_type=1&status=1&voucher_type=0&action=Show';
                                    }
                                @endphp


                                <td class="text-right"> {{ $value->group_code . '.' . $value->sub_group_code . '.' . $value->head_code }} </td>
                                <td class="width-10"><a target="_blank"href="{{ $route }}">{{ $value->head_name }}</a></td>

                                


                                @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "null")
                                    @if (isset($params['from']) && isset($params['to']))
                                        <td class="text-right">{{ ($value->official->bf < 0 ? '('.$transaction->convert_money_format(abs($value->official->bf)).')' :$transaction->convert_money_format($value->official->bf)) }}   </td>
                                    @endif
                                    <td class="text-right"> {{ $transaction->convert_money_format($dr_official) }} </td>
                                    <td class="text-right"> {{ $transaction->convert_money_format($dr_unofficial) }} </td>
                                    @if (isset($params['from']) && isset($params['to']))
                                        <td class="text-right"> {{ ($value->unofficial->bf < 0 ? '('.$transaction->convert_money_format(abs($value->unofficial->bf)).')' :$transaction->convert_money_format($value->unofficial->bf)) }}  </td>
                                    @endif
                                    <td class="text-right"> {{ $transaction->convert_money_format($cr_official) }} </td>
                                    <td class="text-right"> {{ $transaction->convert_money_format($cr_unofficial) }} </td>
                                    

                                @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 1)
                                    @if (isset($params['from']) && isset($params['to']))
                                        <td class="text-right"> {{ ($value->official->bf < 0 ? '('.$transaction->convert_money_format(abs($value->official->bf)).')' :$transaction->convert_money_format($value->official->bf)) }} </td>
                                    @endif
                                    <td class="text-right"> {{ $transaction->convert_money_format($dr_official) }} </td>
                                    <td class="text-right"> {{ $transaction->convert_money_format($cr_official) }} </td>

                                @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 0)
                                    @if (isset($params['from']) && isset($params['to']))
                                        <td class="text-right"> {{ ($value->unofficial->bf < 0 ? '('.$transaction->convert_money_format(abs($value->unofficial->bf)).')' :$transaction->convert_money_format($value->unofficial->bf)) }}  </td>
                                    @endif
                                    <td class="text-right"> {{ $transaction->convert_money_format($dr_unofficial) }} </td>
                                    <td class="text-right"> {{ $transaction->convert_money_format($cr_unofficial) }} </td>

                                @elseif(!isset($params['official_unofficial']))
                                    @if (isset($params['from']) && isset($params['to']))
                                        <td class="text-right"> {{ ($value->official->bf < 0 ? '('.$transaction->convert_money_format(abs($value->official->bf)).')' :$transaction->convert_money_format($value->official->bf)) }} </td>
                                    @endif
                                    <td class="text-right" style=" ">{{ $transaction->convert_money_format($dr_official) }} </td>
                                    <td class="text-right" style=" ">{{ $transaction->convert_money_format($cr_official) }}</td>
                                @endif
                            </tr>
                        @endif
                    @endforeach
                    {{-- total subgroup --}}
                    <tr>
                        @if($params['summary'] == 0)
                            <th class="text-right" colspan="2" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important; color:black !important' }}"> {{__('lang.sub_total')}}</th>
                        @else
                            <th class="text-right" colspan="3" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important; color:black !important' }}"> <span style="margin: 0px;padding-left: 170px;">{{__('lang.sub_total')}}</span></th>
                        @endif

                        @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "null") 
                                @if (isset($params['from']) && isset($params['to']))
                                    <th class="text-right" >  </th>
                                @endif
                                <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupDR_official) }}</th>
                                <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupDR_unofficial) }} </th>
                                @if (isset($params['from']) && isset($params['to']))
                                    <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}">  </th>
                                @endif
                                <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupCR_official) }}</th>
                                <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupCR_unofficial) }} </th>
                         

                        @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 1)
                            @if (isset($params['from']) && isset($params['to']))
                                <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}">  </th>
                            @endif
                            <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupDR_official) }}</th>
                            <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupCR_official) }}</th>
                            
                        @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 0)
                            @if (isset($params['from']) && isset($params['to']))
                                <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}">  </th>
                            @endif

                            <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupDR_unofficial) }} </th>
                            <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupCR_unofficial) }} </th>

                        @elseif(!isset($params['official_unofficial']))
                            
                            @if (isset($params['from']) && isset($params['to']))
                                <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}">  </th>
                            @endif
                            <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupDR_official) }}</th>
                            <th class="text-right" style="{{ $params['summary'] == 0 ? '' : 'background: #DCDCDC !important;  color:black !important' }}"> {{ $transaction->convert_money_format($totalSubGroupCR_official) }}</th>
                        @endif


                        
                        
                        
                    </tr>
                @endforeach
                <tr>
                    <th class="text-right" colspan="{{ $params['summary'] == 0 ? '2' : '3' }}">{{__('lang.group_total')}}</th>

                    @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "null")
                            @if (isset($params['from']) && isset($params['to']))
                                <th class="text-right">  </th>
                            @endif
                            <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupDR_official) }}</th>
                            <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupDR_unofficial) }} </th>
                            @if (isset($params['from']) && isset($params['to']))
                                <th class="text-right">  </th>
                            @endif
                            <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupCR_official) }}</th>
                            <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupCR_unofficial) }} </th>
                            
                    
                         

                    @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 1)
                        @if (isset($params['from']) && isset($params['to']))
                            <th class="text-right">  </th>
                        @endif
                        <th class="text-right"> {{ $transaction->convert_money_format($totalGroupDR_official) }}</th>
                        <th class="text-right"> {{ $transaction->convert_money_format($totalGroupCR_official) }}</th>

                    @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 0)
                        @if (isset($params['from']) && isset($params['to']))
                            <th class="text-right">  </th>
                        @endif
                        <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupDR_unofficial) }} </th>
                        <th class="text-right"  > {{ $transaction->convert_money_format($totalGroupCR_unofficial) }} </th>

                    @elseif(!isset($params['official_unofficial']))
                        @if (isset($params['from']) && isset($params['to']))
                            <th class="text-right">  </th>
                        @endif
                        <th class="text-right" > {{ $transaction->convert_money_format($totalGroupDR_official) }}</th>
                        <th class="text-right" > {{ $transaction->convert_money_format($totalGroupCR_official) }}</th>
                    @endif
                </tr>
        @endforeach
    @endforeach
    <tr>
        <th class="text-right" colspan="{{ $params['summary'] == 0 ? '2' : '3' }}">{{__('lang.total')}}</th>

            @if (isset($params['official_unofficial']) && $params['official_unofficial'] == "null") 
                @if (isset($params['from']) && isset($params['to']))
                    <th class="text-right">  </th>
                @endif
                    <th class="text-right" > {{ $transaction->convert_money_format($totalDR_official) }}</th>
                    <th class="text-right" > {{ $transaction->convert_money_format($totalDR_unofficial) }}</th>
                @if (isset($params['from']) && isset($params['to']))
                    <th class="text-right">  </th>
                @endif        
                    <th class="text-right" > {{ $transaction->convert_money_format($totalCR_official) }} </th>
                    <th class="text-right" > {{ $transaction->convert_money_format($totalCR_unofficial) }} </th>
              

            @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 1)
                @if (isset($params['from']) && isset($params['to']))
                    <th class="text-right">  </th>
                @endif
                <th class="text-right"  > {{ $transaction->convert_money_format($totalDR_official) }}</th>
                <th class="text-right"  > {{ $transaction->convert_money_format($totalCR_official) }}</th>

            @elseif(isset($params['official_unofficial']) && $params['official_unofficial'] == 0)
                @if (isset($params['from']) && isset($params['to']))
                    <th class="text-right">  </th>
                @endif
                <th class="text-right"  > {{ $transaction->convert_money_format($totalDR_unofficial) }} </th>
                <th class="text-right"  > {{ $transaction->convert_money_format($totalCR_unofficial) }} </th>

            @elseif(!isset($params['official_unofficial']))
                @if (isset($params['from']) && isset($params['to']))
                    <th class="text-right">  </th>
                @endif
                <th class="text-right"  > {{ $transaction->convert_money_format($totalDR_official) }}</th>
                <th class="text-right"  > {{ $transaction->convert_money_format($totalCR_official) }}</th>
            @endif
        </tr>
    </tbody>

</table>