@extends('printlayout')
@section('content')

@php
    $runningDebit = 0;
    $runningCredit = 0;
    $runningBalance = 0;
    $TotalBalance = 0;

    // Function for formatting accounting values
    if (!function_exists('formatAccounting')) {
        function formatAccounting($amount)
        {
            return $amount < 0
                ? '(' . number_format(abs($amount), 2) . ')'
                : number_format($amount, 2);
        }
    }

    // Grouping data at multiple levels
    $groupedData = $ledgerentries->groupBy('GroupName')->map(function ($group) {
        return [
            'total_debit' => $group->sum('TotalDebit'),
            'total_credit' => $group->sum('TotalCredit'),
            'total_balance' => $group->sum('TotalDebit') - $group->sum('TotalCredit'),
            'entries' => $group->groupBy('AccountNature')->map(function ($nature) {
                return [
                    'total_debit' => $nature->sum('TotalDebit'),
                    'total_credit' => $nature->sum('TotalCredit'),
                    'total_balance' => $nature->sum('TotalDebit') - $nature->sum('TotalCredit'),
                    'entries' => $nature->groupBy('MainParentAccount')->map(function ($mainParent) {
                        return [
                            'total_debit' => $mainParent->sum('TotalDebit'),
                            'total_credit' => $mainParent->sum('TotalCredit'),
                            'total_balance' => $mainParent->sum('TotalDebit') - $mainParent->sum('TotalCredit'),
                            'entries' => $mainParent->groupBy('ParentAccount')->map(function ($parent) {
                                return [
                                    'total_debit' => $parent->sum('TotalDebit'),
                                    'total_credit' => $parent->sum('TotalCredit'),
                                    'total_balance' => $parent->sum('TotalDebit') - $parent->sum('TotalCredit'),
                                    'entries' => $parent
                                ];
                            })
                        ];
                    })
                ];
            })
        ];
    });
@endphp

<div style="text-align: center;">
    <h2 style="margin-top: 0">{{ __('sitelabel.TrialBalanceReport') }}</h2>
</div>

<div class="col-12 text-center">
    <span style="font-size:16px; padding:10px;"><strong>Year :</strong></span>
    <span style="font-size:16px; padding:10px;">{{ $YearNo }}</span>
    <span style="font-size:16px; padding:10px;"><strong>Month :</strong></span>
    <span style="font-size:16px; padding:10px;">{{ $MonthName }}</span>
</div>

<!-- Table Section -->
<table class="table table-bordered table-striped table-responsive">
    <thead>
        <tr>
            <th class="text-left" style="width:30%">{{ __('sitelabel.Account') }}</th>
            <th class="text-right" style="width:20%">{{ __('sitelabel.TotalDebit') }}</th>
            <th class="text-right" style="width:20%">{{ __('sitelabel.TotalCredit') }}</th>
            <th class="text-right" style="width:20%">{{ __('sitelabel.TotalBalance') }}</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($groupedData as $groupName => $group)
            <!-- Group Name Row -->
            <tr style="background: #f0f0f0; font-weight: bold;">
                <td colspan="4">{{ strtoupper($groupName) }}</td>
            </tr>

            @foreach ($group['entries'] as $accountNature => $natureData)
                <tr style="background: #e0e0e0;">
                    <td colspan="4" style="padding-left: 20px;"><strong>{{ strtoupper($accountNature) }}</strong></td>
                </tr>

                @foreach ($natureData['entries'] as $mainParentAccount => $mainParentData)
                    <tr style="background: #d0d0d0;">
                        <td colspan="4" style="padding-left: 40px;"><strong>{{ strtoupper($mainParentAccount) }}</strong></td>
                    </tr>

                    @foreach ($mainParentData['entries'] as $parentAccount => $parentData)
                        <tr style="background: #c0c0c0;">
                            <td colspan="4" style="padding-left: 60px;"><strong>{{ strtoupper($parentAccount) }}</strong></td>
                        </tr>

                        @foreach ($parentData['entries'] as $item)
                            @php
                                $TotalBalance += $item->TotalDebit - $item->TotalCredit;
                            @endphp
                            <tr>
                                <td style="padding-left: 80px;">{{ $item->Name }}</td>
                                <td style="text-align: right">{{ formatAccounting($item->TotalDebit) }}</td>
                                <td style="text-align: right">{{ formatAccounting($item->TotalCredit) }}</td>
                                <td style="text-align: right">{{ formatAccounting($TotalBalance) }}</td>
                            </tr>

                            @php
                                $runningDebit += $item->TotalDebit;
                                $runningCredit += $item->TotalCredit;
                            @endphp
                        @endforeach

                        <!-- Parent Account Total -->
                        <tr style="background: #c0c0c0; font-weight: bold;">
                            <td style="padding-left: 60px;">{{ __('sitelabel.Total') }}</td>
                            <td style="text-align: right">{{ formatAccounting($parentData['total_debit']) }}</td>
                            <td style="text-align: right">{{ formatAccounting($parentData['total_credit']) }}</td>
                            <td style="text-align: right">{{ formatAccounting($parentData['total_balance']) }}</td>
                        </tr>
                    @endforeach

                    <!-- Main Parent Account Total -->
                    <tr style="background: #d0d0d0; font-weight: bold;">
                        <td style="padding-left: 40px;">{{ __('sitelabel.Total') }}</td>
                        <td style="text-align: right">{{ formatAccounting($mainParentData['total_debit']) }}</td>
                        <td style="text-align: right">{{ formatAccounting($mainParentData['total_credit']) }}</td>
                        <td style="text-align: right">{{ formatAccounting($mainParentData['total_balance']) }}</td>
                    </tr>
                @endforeach

                <!-- Account Nature Total -->
                <tr style="background: #e0e0e0; font-weight: bold;">
                    <td style="padding-left: 20px;">{{ __('sitelabel.Total') }}</td>
                    <td style="text-align: right">{{ formatAccounting($natureData['total_debit']) }}</td>
                    <td style="text-align: right">{{ formatAccounting($natureData['total_credit']) }}</td>
                    <td style="text-align: right">{{ formatAccounting($natureData['total_balance']) }}</td>
                </tr>
            @endforeach

            <!-- Group Total -->
            <tr style="background: #f0f0f0; font-weight: bold;">
                <td>{{ __('sitelabel.Total') }}</td>
                <td style="text-align: right">{{ formatAccounting($group['total_debit']) }}</td>
                <td style="text-align: right">{{ formatAccounting($group['total_credit']) }}</td>
                <td style="text-align: right">{{ formatAccounting($group['total_balance']) }}</td>
            </tr>
        @endforeach
    </tbody>
    
    <!-- Grand Total -->
    <tfoot>
        @php
            $runningBalance = $runningDebit - $runningCredit;
        @endphp
        <tr>
            <td><strong>{{ __('sitelabel.GrandTotal') }}</strong></td>
            <td style="text-align: right"><strong>{{ formatAccounting($runningDebit) }}</strong></td>
            <td style="text-align: right"><strong>{{ formatAccounting($runningCredit) }}</strong></td>
            <td style="text-align: right"><strong>{{ formatAccounting($runningBalance) }}</strong></td>
        </tr>
    </tfoot>
</table>

@include('sign-subview.signandbuttons')

@endsection

@section('script')
@endsection