@extends('layouts.master')
@section('css')
    <style>
        .group-name:hover {
            color: blue;
        }

        .select2-container .select2-search--inline .select2-search__field {
            margin-top: 9px !important;
        }

        .select2-container--default .select2-selection--multiple .select2-selection__choice__display {
            text-wrap: auto ! important;
        }

        .select2-selection.select2-selection--multiple {
            display: flex !important;
        }

        .card-body .col-md-3 {
            padding: 0 5px !important;
        }

        .card-body .col-md-2 {
            padding: 0 5px !important;
        }

        .card-body .col-md-1 {
            padding: 0 5px !important;
        }

        .card-body thead tr th {
            font-weight: 600;
        }

        .fr-nv-btm {
            margin-bottom: 10px !important;
        }

        .dt-buttons button {
            border-radius: 5px !important;
        }

        .daybk-rt-btns {
            display: flex;
            align-items: end;
            gap: 5px
        }

        tbody tr:hover {
            background-color: #c2c50a;
        }
    </style>
@endsection
@section('title')
    Extraction Of ({{ $voucherType->name }})
@endsection
@section('content')
    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-header d-flex  phcl-flx">
                    <h4 class="card-title mb-0 flex-grow-1 text-nowrap"> Extraction Of ({{ $voucherType->name }})</h4>
                    <a href="/admin/statistics-transaction/{{ $voucherType->id }}?from_date={{ app('request')->input('from_date') }}&to_date={{ app('request')->input('to_date') }}"
                        class="btn btn-primary go-back">Go Back</a>
                </div>
                <div class="card-body">
                    <div class="row mb-3">
                        <div class="col-md-3">
                            <label class="label">From Date</label>
                            <input class="form-control" value="{{ app('request')->input('from_date') }}" type="date"
                                name="from_date" id="from_date">
                        </div>
                        <div class="col-md-3">
                            <label class="label">To Date</label>
                            <input class="form-control" value="{{ app('request')->input('to_date') }}" type="date"
                                name="to_date" id="to_date">
                        </div>
                        <div class="col-md-1 mt-1 text-center daybk-rt-btns">
                            <button type="button" name="filter" id="filter" class="btn btn-sm btn-primary"><i
                                    class="ri-search-line fs-6"></i></button>
                        </div>
                    </div>
                    @php
                        $debitTotal = 0;
                        $creditTotal = 0;
                    @endphp
                    <table id="export_trial_balance"
                        class="table table-bordered dt-responsive nowrap table-striped align-middle" style="width:100%">
                        <thead>
                            <tr>
                                <th>Particulars</th>
                                <th style="width: 250px;">Debit</th>
                                <th style="width: 250px;">Credit</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($groups as $group)
                                @php
                                    $group->drAmount = 0;
                                    $group->crAmount = 0;
                                @endphp
                                @foreach ($group->descendantsAndSelf as $subGroup)
                                    @php
                                        $subGroup->drAmount = 0;
                                        $subGroup->crAmount = 0;
                                        $subLedgers = $subGroup->ledgers->pluck('id');
                                        $exists = $transactions->whereIn('ledger_id', $subLedgers);
                                        if ($exists->count() > 0) {
                                            $drExists = $exists->where('debitAmtTotal', '>', 0);
                                            $crExists = $exists->where('creditAmtTotal', '>', 0);
                                            if ($drExists->count() > 0 || $crExists->count() > 0) {
                                                foreach ($subGroup->ledgers as $subLedger) {
                                                    $subLedger->drAmount = 0;
                                                    $subLedger->crAmount = 0;
                                                    $subDrExists = clone $drExists;
                                                    $subDrExists = $drExists->where('ledger_id', $subLedger->id);
                                                    $subCrExists = clone $crExists;
                                                    $subCrExists = $crExists->where('ledger_id', $subLedger->id);
                                                    if ($subDrExists->count() > 0) {
                                                        $subLedger->drAmount = $subDrExists->sum('debitAmtTotal');
                                                        $subGroup->drAmount += $subLedger->drAmount;
                                                        $group->drAmount += $subLedger->drAmount;
                                                        $debitTotal += $subDrExists->sum('debitAmtTotal');
                                                    }
                                                    if ($subCrExists->count() > 0) {
                                                        $subLedger->crAmount = $subCrExists->sum('creditAmtTotal');
                                                        $subGroup->crAmount += $subLedger->crAmount;
                                                        $group->crAmount += $subLedger->crAmount;
                                                        $creditTotal += $subCrExists->sum('creditAmtTotal');
                                                    }
                                                }
                                            }
                                        }
                                    @endphp
                                @endforeach

                                @if ($group->drAmount > 0 || $group->crAmount > 0)
                                    <tr class="group-row" style="cursor: pointer;" data-group-id="{{ $group->id }}">
                                        <td><b>{{ $group->name }}</b></td>
                                        <td><b>{{ $group->drAmount == 0 ? '' : number_format($group->drAmount, 2) }}</b>
                                        </td>
                                        <td><b>{{ $group->crAmount == 0 ? '' : number_format($group->crAmount, 2) }}</b>
                                        </td>
                                    </tr>
                                    @foreach ($group->descendantsAndSelf as $subGroup)
                                        @if ($group->id != $subGroup->id)
                                            @if ($subGroup->drAmount > 0 || $subGroup->crAmount > 0)
                                                <tr class="sub-group-row sub-group-row-{{ $group->id }}"
                                                    style="display: none; cursor: pointer;"
                                                    data-sub-group-id="{{ $subGroup->id }}">
                                                    <td style="font-weight: 500;">
                                                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ $subGroup->name }}</td>
                                                    <td style="font-weight: 500;">
                                                        {{ $subGroup->drAmount == 0 ? '' : number_format($subGroup->drAmount, 2) }}
                                                    </td>
                                                    <td style="font-weight: 500;">
                                                        {{ $subGroup->crAmount == 0 ? '' : number_format($subGroup->crAmount, 2) }}
                                                    </td>
                                                </tr>
                                                @foreach ($subGroup->ledgers as $subLedger)
                                                    @if ($subLedger->drAmount > 0 || $subLedger->crAmount > 0)
                                                        <tr class="sub-ledger-row-{{ $subGroup->id }} sub-ledger sub-ledger-row-{{ $group->id }}"
                                                            style="display: none; cursor: pointer;"
                                                            data-ledger-id="{{ $subLedger->id }}">
                                                            <td>&nbsp;&nbsp;
                                                                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ $subLedger->name }}</td>
                                                            <td>{{ $subLedger->drAmount == 0 ? '' : number_format($subLedger->drAmount, 2) }}
                                                            </td>
                                                            <td>{{ $subLedger->crAmount == 0 ? '' : number_format($subLedger->crAmount, 2) }}
                                                            </td>
                                                        </tr>
                                                    @endif
                                                @endforeach
                                            @endif
                                        @else
                                            @if ($group->id == $subGroup->id)
                                                @foreach ($subGroup->ledgers as $subLedger)
                                                    @if ($subLedger->drAmount > 0 || $subLedger->crAmount > 0)
                                                        <tr class="direct-ledger-row-{{ $group->id }} direct-ledger"
                                                            style="display: none; cursor: pointer;"
                                                            data-ledger-id="{{ $subLedger->id }}">
                                                            <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{ $subLedger->name }}</td>
                                                            <td>{{ $subLedger->drAmount == 0 ? '' : number_format($subLedger->drAmount, 2) }}
                                                            </td>
                                                            <td>{{ $subLedger->crAmount == 0 ? '' : number_format($subLedger->crAmount, 2) }}
                                                            </td>
                                                        </tr>
                                                    @endif
                                                @endforeach
                                            @endif
                                        @endif
                                    @endforeach
                                @endif
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <th>Total</th>
                                <th>{{ number_format($debitTotal, 2) }}</th>
                                <th>{{ number_format($creditTotal, 2) }}</th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('script')
    <script src="{{ URL::asset('/assets/js/app.min.js') }}"></script>
    <script>
        $(document).ready(function() {
            let expandedGroups = JSON.parse(localStorage.getItem('expandedGroups') || '[]');
            let expandedSubGroups = JSON.parse(localStorage.getItem('expandedSubGroups') || '[]');

            // Restore expanded groups
            expandedGroups.forEach(function(groupId) {
                $('.sub-group-row-' + groupId).show();
                $('.direct-ledger-row-' + groupId).toggle();
            });

            // Restore expanded subgroups
            expandedSubGroups.forEach(function(subGroupId) {
                $('.sub-ledger-row-' + subGroupId).show();
            });

            // Expand/collapse group
            $('.group-row').click(function() {
                var groupId = $(this).data('group-id');
                $('.sub-group-row-' + groupId).toggle();
                $('.direct-ledger-row-' + groupId).toggle();
                $('.sub-ledger-row-' + groupId).hide(); // hide sub-ledgers

                // Save expanded groups
                if ($('.sub-group-row-' + groupId).is(':visible')) {
                    if (!expandedGroups.includes(groupId)) expandedGroups.push(groupId);
                } else {
                    expandedGroups = expandedGroups.filter(id => id !== groupId);
                }
                localStorage.setItem('expandedGroups', JSON.stringify(expandedGroups));
            });

            // Expand/collapse subgroup
            $('.sub-group-row').click(function() {
                var subGroupId = $(this).data('sub-group-id');
                $('.sub-ledger-row-' + subGroupId).toggle();

                // Save expanded subgroups
                if ($('.sub-ledger-row-' + subGroupId).is(':visible')) {
                    if (!expandedSubGroups.includes(subGroupId)) expandedSubGroups.push(subGroupId);
                } else {
                    expandedSubGroups = expandedSubGroups.filter(id => id !== subGroupId);
                }
                localStorage.setItem('expandedSubGroups', JSON.stringify(expandedSubGroups));
            });

            // Ledger click
            $('.sub-ledger, .direct-ledger').click(function(e) {
                e.preventDefault(); // prevent immediate navigation

                var ledgerId = $(this).data('ledger-id');
                var url = '/admin/ledger-report/' + ledgerId +
                    '?from_date=' + $('#from_date').val() +
                    '&to_date=' + $('#to_date').val() +
                    '&voucher_type=' + {{ $voucherType->id }};

                // Save expanded groups/subgroups again before going
                localStorage.setItem('expandedGroups', JSON.stringify(expandedGroups));
                localStorage.setItem('expandedSubGroups', JSON.stringify(expandedSubGroups));

                // Now navigate
                window.location = url;
            });

            // Filter button
            $('#filter').click(function(e) {
                e.preventDefault();
                window.location = window.location.href.split('?')[0] +
                    '?from_date=' + $('#from_date').val() +
                    '&to_date=' + $('#to_date').val();
            });
            $('.go-back').click(function(e) {
                e.preventDefault();
                localStorage.removeItem('expandedGroups');
                localStorage.removeItem('expandedSubGroups');
                window.location = $(this).attr('href');
            });
        });
    </script>
@endsection