@use('App\Services\Date')
<div id="configuration">

    <div class="row">
        <div class="col-xs-12">
            <div class="card">
                <div class="card-body collapse in">
                    <div>
                        <div class="text-center">
                            <h2>
                                <strong>
                                    @lang('reports::reports.Trial Balance')
                                </strong>
                            </h2>
                            <h4><b>{{ $data['companyName'] }}</b></h4>
                            <h4>
                                @lang('reports::reports.as_of') <span dir="ltr">{{$data['dates']['to']}}</span>
                            </h4>
                        </div>
                        <div>
                            <table class="table table-borderless">
                                <thead style="border-bottom: 1pt solid black; border-top: 1pt solid black">
                                <tr>
                                    <th>@lang('reports::reports.account')</th>
                                    <th colspan="2">@lang('reports::reports.trial_balance.opening_balance')</th>
                                    <th colspan="2">@lang('reports::reports.trial_balance.period_transactions')</th>
                                    <th colspan="3">@lang('reports::reports.trial_balance.closing_balance')</th>
                                </tr>
                                <tr>
                                    <th></th>
                                    <th>@lang('reports::reports.debit')</th>
                                    <th>@lang('reports::reports.credit')</th>
                                    <th>@lang('reports::reports.debit')</th>
                                    <th>@lang('reports::reports.credit')</th>
                                    <th>@lang('reports::reports.debit')</th>
                                    <th>@lang('reports::reports.credit')</th>
                                    @if (request('exclude_net') == 0)
                                    <th>@lang('reports::reports.total closing balance')</th>
                                    @endif
                                </tr>
                                </thead>
                                <tbody>
                                    @php
                                    $debit_openning_balance =0;
                                    $credit_openning_balance =0;
                                    $debit_closing_balance =0;
                                    $credit_closing_balance =0;
                                    @endphp
                                    
                                    @foreach($data['categorizedAccounts'] as $categoryName => $accounts)
                                        @if($accounts['total_for_display'])
                                            <tr style="border-top: 1px solid #E3EBF3;"> <th colspan="8" class="text-bold" > {{$categoryName}}</th> </tr>
                                            @foreach($accounts as $account)
                                                @if(isset($account['total_for_display']) && isset($account['id']))
                                                    <tr style="text-indent: 1em;">
                                                        <td>
                                                            <a target="_blank"
                                                               href="{{route('company.reports.account-statement.index', ['subdomain' => $subdomain,'cost_center_id'=>request('cost_center_id'),'account_id' => $account['id'],'is_dates'=>request('is_dates'),'fiscal_year_id'=>request('fiscal_year_id'),'from' => request('from'),'to' => request('to')])}}">
                                                                {{ $account['code'] . ' - ' . $account['name'] }}
                                                            </a>
                                                        </td>
    {{--                                                    <td>@if(isset($account['opening']['debit'])) {{number_format($account['opening']['debit'],2)}} @else 0.00 @endif </td>--}}
                                                       
                                                        @if($account['default_type'] == 'debit')
                                                        @php
                                                        if(isset($account['opening']['total_balance']))
                                                        {
                                                            if($account['opening']['total_balance']>0)
                                                            {
    
                                                                $debit_openning_balance +=abs(@$account['opening']['total_balance']) ?? 0;
                                                            }
                                                            else{
                                                         $credit_openning_balance +=abs(@$account['opening']['total_balance']) ?? 0;
    
                                                            }
                                                        }
                                                        @endphp
                                                        <td class="text-center">@isset($account['opening']['debit']) @if($account['opening']['total_balance'] > 0)  {{ number_format(abs($account['opening']['total_balance']),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                        <td class="text-center">@isset($account['opening']['credit']) @if($account['opening']['total_balance'] > 0) {{ number_format(0,2)}} @else {{ number_format(abs($account['opening']['total_balance']),2)}}@endif @endisset</td>
                                                        @else
                                                        @php
                                                         if(isset($account['opening']['total_balance']))
                                                        {
                                                            if($account['opening']['total_balance']>0)
                                                            {
                                                                 $credit_openning_balance +=abs(@$account['opening']['total_balance']) ?? 0;
                                                            }else{
                                                                $debit_openning_balance +=abs(@$account['opening']['total_balance']) ?? 0;
    
                                                            }
                                                        }
                                                        @endphp
                                                        <td class="text-center">@isset($account['opening']['debit'])  @if($account['opening']['total_balance'] >= 0) {{ number_format(0,2)}} @else{{ number_format(abs($account['opening']['total_balance']) ,2)}}  @endif @endisset</td>
                                                        <td class="text-center">@isset($account['opening']['credit']) @if($account['opening']['total_balance'] > 0) {{ number_format(abs($account['opening']['total_balance'] ) ,2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
    
                                                        @endif
    
                                                        <td class="text-center">@isset($account['period']['debit'])  {{ number_format($account['period']['debit'],2)}} @endisset</td>
                                                        <td class="text-center">@isset($account['period']['credit'])  {{ number_format($account['period']['credit'],2)}} @endisset</td>
                                                        @if($account['default_type'] == 'debit')
                                                                    {{-- start for debit + period  debit - credit start (0) + period credit  --}}
                                                                    {{-- if the balance is negative add it in credit if it positive add it in debit --}}
                                                                  
                                                                   
                                                                            @php
                                                                            if(isset($account['opening']['total_balance']))
                                                                            {
    
                                                                                $period = ($account['opening']['total_balance'] + $account['period']['debit']) - (0 + $account['period']['credit']);
                                                                            }else{
                                                                                $period =0;
                                                                            }
                                                                            if($period > 0)
                                                                            {
                                                                                $debit_closing_balance += abs($period);
                                                                            }else{
                                                                                
                                                                                $credit_closing_balance += abs($period);
                                                                            }
                                                                            
                                                                            @endphp
    
                                                                        <td class="text-center" style="text-indent: 1em;">@isset($account['opening']['debit']) @if($period > 0)  {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                        <td class="text-center" style="text-indent: 1em;">@isset($account['opening']['credit'])  @if($period < 0)  {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                    @else
                                                                  
                                                                    @php
                                                                    if(isset($account['opening']['total_balance']))
                                                                            {
                                                                    $period = ($account['opening']['total_balance'] + $account['period']['credit']) - (0 + $account['period']['debit']);
                                                                            }
                                                                            else{
                                                                                $period =0;
                                                                            }
                                                                            if($period >0)
                                                                            {
                                                                                $credit_closing_balance += abs($period);
                                                                            }else{
                                                                                
                                                                                $debit_closing_balance += abs($period);
                                                                            }
                                                                      @endphp
    
                                                                    <td class="text-center" style="text-indent: 1em;">@isset($account['opening']['debit']) @if($period < 0)  {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                    <td class="text-center" style="text-indent: 1em;">@isset($account['opening']['credit'])  @if($period > 0)  {{ number_format(abs($period),2)}} @else  {{ number_format(0,2)}} @endif @endisset</td>
                                                                        {{-- <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['debit'])  {{ number_format($childAccount['closing']['debit'],2)}} @endisset</td>
                                                                        <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['credit'])  {{ number_format($childAccount['closing']['credit'],2)}} @endisset</td> --}}
                                                                    
                                                        @endif
                                                        {{-- <td class="text-center">@isset($account['closing']['debit'])  {{ number_format($account['closing']['debit'],2)}} @endisset</td>
                                                        <td class="text-center">@isset($account['closing']['credit'])  {{ number_format($account['closing']['credit'],2)}} @endisset</td> --}}
                                                        @if (request('exclude_net') == 0)    
                                                        <td class="text-center">
                                                            @isset($account['closing']['total_balance'])
                                                                @if($account['closing']['total_balance'] >= 0)
                                                                    {{ number_format($account['closing']['total_balance'],2)}}
                                                                @else
                                                                    {{ "(" . number_format(abs($account['closing']['total_balance']),2) . ")"}}
                                                                @endif
                                                            @endisset
                                                        </td>
                                                        @endif
                                                    </tr>
                                                    @isset($account['childs'])
                                                        @foreach($account['childs'] as $childAccount)
                                                            @if($childAccount['total_for_display'])
                                                                <tr style="text-indent: {{$childAccount['level'] +1}}em;">
                                                                    <td>
                                                                        <a target="_blank"
                                                                           href="{{route('company.reports.account-statement.index', ['subdomain' => $subdomain,'cost_center_id'=>request('cost_center_id'),'account_id' => $childAccount['id'],'is_dates'=>request('is_dates'),'fiscal_year_id'=>request('fiscal_year_id'),'from' => request('from'),'to' => request('to')])}}">
                                                                            {{ $childAccount['code'] . ' - ' . $childAccount['name'] }}
                                                                        </a>
                                                                    </td>
                                                                 
                                                                        @if($account['default_type'] == 'debit')
                                                                        
                                                                        @isset($childAccount['opening']['debit'])
                                                                        
                                                                            @php
                                                                            if(isset($childAccount['opening']) && $childAccount['opening']['total_balance'] >0)
                                                                            {
    
                                                                                $debit_openning_balance +=abs(@$childAccount['opening']['total_balance']) ?? 0;
                                                                            }else{
                                                                                 $credit_openning_balance +=abs(@$childAccount['opening']['total_balance']) ?? 0;
                                                                                 
                                                                                }
                                                                                @endphp
    
                                                                            @endisset
                                                                            <td class="text-center">@isset($childAccount['opening']['debit']) @if($childAccount['opening']['total_balance'] > 0)  {{ number_format(abs($childAccount['opening']['total_balance']),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                            <td class="text-center">@isset($childAccount['opening']['credit']) @if($childAccount['opening']['total_balance'] > 0) {{ number_format(0,2)}} @else {{ number_format(abs($childAccount['opening']['total_balance']),2)}}@endif @endisset</td>
    
                                                                        
                                                                        @else
                                                                        @php
                                                                        if(isset($childAccount['opening']) && $childAccount['opening']['total_balance'] >0)
                                                                            {
                                                                        $credit_openning_balance +=abs(@$childAccount['opening']['total_balance']) ?? 0;
                                                                            }else{
                                                                                $debit_openning_balance +=abs(@$childAccount['opening']['total_balance']) ?? 0;
    
                                                                            }
                                                                        @endphp
                                                                        <td class="text-center">@isset($childAccount['opening']['debit']) @if($childAccount['opening']['total_balance'] > 0) {{ number_format(0,2)}} @else{{ number_format(abs($childAccount['opening']['total_balance']),2)}}  @endif @endisset</td>
                                                                        <td class="text-center">@isset($childAccount['opening']['credit']) @if($childAccount['opening']['total_balance'] > 0) {{ number_format(abs($childAccount['opening']['total_balance']),2)}} @else  {{ number_format(0,2)}} @endif @endisset</td>
    
                                                                        @endif
                                 
                                                                    <td class="text-center" style="text-indent: 1em;">@isset($childAccount['period']['debit'])  {{ number_format($childAccount['period']['debit'],2)}} @endisset</td>
                                                                    <td class="text-center" style="text-indent: 1em;">@isset($childAccount['period']['credit'])  {{ number_format($childAccount['period']['credit'],2)}} @endisset</td>
                                                                    {{-- <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['debit'])  {{ number_format($childAccount['closing']['debit'],2)}} @endisset</td>
                                                                    <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['credit'])  {{ number_format($childAccount['closing']['credit'],2)}} @endisset</td> --}}
                                                                 
                                                                    @if($account['default_type'] == 'debit')
                                                                    {{-- start for debit + period  debit - credit start (0) + period credit  --}}
                                                                    {{-- if the balance is negative add it in credit if it positive add it in debit --}}
                                                                            @php
                                                                            if(isset($childAccount['opening']['total_balance']))
                                                                            {
                                                                                $period = ($childAccount['opening']['total_balance'] + $childAccount['period']['debit']) - (0 + $childAccount['period']['credit']);
                                                                            }else{
                                                                                $period =0;
                                                                            }
                                                                            if($period >0)
                                                                            {
                                                                                $debit_closing_balance += abs($period);
                                                                            }else{
                                                                                
                                                                                $credit_closing_balance += abs($period);
                                                                            }
                                                                            @endphp
    
                                                                        <td class="text-center" style="text-indent: 1em;">@isset($childAccount['opening']['debit']) @if($period > 0)  {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                        <td class="text-center" style="text-indent: 1em;">@isset($childAccount['opening']['credit'])  @if($period < 0)  {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                     @else
                                                                        @php
                                                                        if(isset($childAccount['opening']['total_balance']))
                                                                            {
                                                                      $period = ($childAccount['opening']['total_balance'] + $childAccount['period']['credit']) - (0 + $childAccount['period']['debit']);
                                                                            }else{
                                                                                $period =0;
                                                                            }
                                                                            if($period >0)
                                                                            {
                                                                                $credit_closing_balance += abs($period);
                                                                            }else{
                                                                                
                                                                                $debit_closing_balance += abs($period);
                                                                            }
                                                                       @endphp
    
                                                                    <td class="text-center" style="text-indent: 1em;">@isset($childAccount['opening']['debit']) @if($period < 0) {{ number_format(abs($period),2)}} @else{{ number_format(0,2)}} @endif @endisset</td>
                                                                    <td class="text-center" style="text-indent: 1em;">@isset($childAccount['opening']['credit'])  @if($period > 0) {{ number_format(abs($period),2)}} @else {{ number_format(0,2)}} @endif @endisset</td>
                                                                        {{-- <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['debit'])  {{ number_format($childAccount['closing']['debit'],2)}} @endisset</td>
                                                                        <td class="text-center" style="text-indent: 1em;">@isset($childAccount['closing']['credit'])  {{ number_format($childAccount['closing']['credit'],2)}} @endisset</td> --}}
                                                                    
                                                                    @endif
                                                                    @if (request('exclude_net') == 0)
                                                                    <td class="text-center" style="text-indent: 1em;">
                                                                        @isset($childAccount['closing']['total_balance'])
                                                                            @if($childAccount['closing']['total_balance'] >= 0)
                                                                                {{ number_format($childAccount['closing']['total_balance'],2)}}
                                                                            @else
                                                                                {{ "(" . number_format(abs($childAccount['closing']['total_balance']),2) . ")"}}
                                                                            @endif
                                                                        @endisset
                                                                    </td>
                                                                    @endif
                                                                </tr>
                                                            @endif
                                                        @endforeach
                                                    @endisset
                                                @endif
                                            @endforeach
                                        @endif
                                    @endforeach
                                    <tr style="border-bottom:1pt solid #00000036;border-top:1pt solid #00000036">
                                        <th>@lang('reports::reports.trial_balance.total')</th>
                                        <td class="text-center">{{number_format($debit_openning_balance,2)}}</td>
                                        <td class="text-center">{{number_format($credit_openning_balance,2)}}</td>
                                        <td class="text-center">{{number_format($data['total']['period']['debit'],2)}}</td>
                                        <td class="text-center">{{number_format($data['total']['period']['credit'],2)}}</td>
                                        <td class="text-center">{{number_format($debit_closing_balance,2)}}</td>
                                        <td class="text-center">{{number_format($credit_closing_balance,2)}}</td>
                                        @if (request('exclude_net') == 0)
                                        <td class="text-center">---</td>
                                        @endif
                                    </tr>
                                    <tr>
                                        <td colspan="7">
                                            @lang('reports::reports.accrual_basis')
                                            {{ Date::format(now(), 'datetime') }}
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>

                    </div>
                </div>
            </div>
        </div>
    </div>
</div>