@extends('dashboard.layouts.app')

@section('content')
    @include('components.alert')

    @php
        $money = fn ($value) => number_format(round((float) $value, 2), 2);
        $percent = fn ($value) => number_format((float) $value, 0) . '%';
        $studentLabel = fn ($count) => $count === 1 ? 'student' : 'students';

        $statCards = [
            ['label' => 'Invoice Total', 'value' => $money($totals['contract']), 'icon' => 'ri:money-dollar-circle-line'],
            ['label' => 'Paid', 'value' => $money($totals['paid']), 'icon' => 'ri:bank-card-line'],
            ['label' => 'Consumed', 'value' => $money($totals['consumed']), 'icon' => 'ri:check-line'],
            ['label' => 'Unearned', 'value' => $money($totals['unearned']), 'icon' => 'ri:time-line'],
        ];
    @endphp

    <div class="container-fluid app-bg student-balances-page">
        <div class="page-shell">
            <div class="space-y-3">
                <x-page-title
                    title="Student Balances"
                    description="Review paid student courses by invoice total, paid amount, consumed value, unearned value, and passed sessions.">
                    <a href="{{ route('student_balances.index', array_merge(request()->query(), ['export' => 'csv'])) }}"
                       class="btn btn-outline-primary rounded-pill">
                        <iconify-icon icon="ri:file-excel-2-line"></iconify-icon>
                        Export
                    </a>
                </x-page-title>

                <div class="student-balance-note mb-3">
                    <iconify-icon icon="ri:information-line"></iconify-icon>
                    <span>
                        Only paid student courses are shown. Consumed value is calculated from the paid amount divided across course sessions, then multiplied by sessions whose scheduled time has already passed.
                    </span>
                </div>

                <div class="balance-stats">
                    @foreach ($statCards as $card)
                        <div class="balance-stat">
                            <span>
                                <iconify-icon icon="{{ $card['icon'] }}"></iconify-icon>
                                {{ $card['label'] }}
                            </span>
                            <strong>{{ $card['value'] }}</strong>
                        </div>
                    @endforeach
                </div>

                <div class="ui-card ui-card--table mt-3">
                    <div class="ui-card__header">
                        <div class="d-flex align-items-center gap-3 flex-wrap w-100">
                            <h6 class="mb-0 font-semibold text-gray-800 whitespace-nowrap" style="margin-right: auto;">
                                Filters
                            </h6>

                            <x-table-controls
                                :action="route('student_balances.index')"
                                searchName="search"
                                searchPlaceholder="search student, course, invoice"
                                formId="student-balances-table-controls"
                                :clearUrl="route('student_balances.index')"
                            />
                        </div>
                    </div>

                    <x-table
                        wrapperClass="student-balances-table-wrap"
                        :paginator="$rows"
                        emptyMessage="No matching student balances found."
                        :headers="[
                            'Student',
                            'Course',
                            'Sessions',
                            'Invoice Total',
                            'Paid',
                            'Consumed',
                            'Unearned',
                            'Progress'
                        ]">
                            @forelse ($rows as $row)
                                @php
                                    $collapseId = 'student-courses-' . md5($row['student_key']);
                                    $hasCoursesCollapse = $row['course_count'] > 1;
                                    $singleCourse = $row['courses']->first();
                                    $studentInitials = collect(explode(' ', trim($row['student_name'])))
                                        ->filter()
                                        ->take(2)
                                        ->map(fn ($part) => strtoupper(substr($part, 0, 1)))
                                        ->implode('') ?: 'S';
                                @endphp

                                <tr>
                                    <td>
                                        <div class="student-balance-student">
                                            @if ($hasCoursesCollapse)
                                                <button type="button"
                                                        class="balance-collapse-btn"
                                                        data-target="{{ $collapseId }}"
                                                        aria-expanded="false"
                                                        title="Show courses">
                                                    <iconify-icon icon="ri:arrow-down-s-line"></iconify-icon>
                                                </button>
                                            @endif

                                            <span class="student-balance-avatar">{{ $studentInitials }}</span>

                                            <span class="student-balance-copy">
                                                <strong>{{ $row['student_name'] }}</strong>
                                                <small>
                                                    {{ $row['student_ref'] ?: 'No reference' }}
                                                    @if ($hasCoursesCollapse)
                                                        - {{ $row['course_count'] }} courses
                                                    @endif
                                                </small>
                                            </span>
                                        </div>
                                    </td>

                                    <td class="text-center">
                                        @if ($hasCoursesCollapse)
                                            <span class="ui-pill ui-pill--info">Course total</span>
                                        @else
                                            <div class="balance-course-name">
                                                <strong>{{ $singleCourse['course_name'] }}</strong>
                                                <small>{{ $singleCourse['invoice_number'] }}</small>
                                            </div>
                                        @endif
                                    </td>

                                    <td class="text-center">
                                        <span class="ui-pill ui-pill--neutral">{{ $row['sessions_done'] }}/{{ $row['sessions_total'] }}</span>
                                    </td>
                                    <td class="text-center balance-money">{{ $money($row['contract']) }}</td>
                                    <td class="text-center balance-money">{{ $money($row['paid']) }}</td>
                                    <td class="text-center balance-money text-success">{{ $money($row['consumed']) }}</td>
                                    <td class="text-center balance-money text-warning">{{ $money($row['unearned']) }}</td>
                                    <td class="text-center">
                                        <div class="balance-progress">
                                            <span>{{ $percent($row['progress']) }}</span>
                                            <div class="balance-progress__track">
                                                <div class="balance-progress__fill" style="width: {{ min($row['progress'], 100) }}%;"></div>
                                            </div>
                                        </div>
                                    </td>
                                </tr>

                                @if ($hasCoursesCollapse)
                                    @foreach ($row['courses'] as $course)
                                        <tr class="balance-detail-row {{ $collapseId }}">
                                            <td></td>
                                            <td class="text-center">
                                                <div class="balance-course-name balance-course-name--nested">
                                                    <strong>{{ $course['course_name'] }}</strong>
                                                    <small>{{ $course['invoice_number'] }}</small>
                                                </div>
                                            </td>
                                            <td class="text-center">
                                                <span class="ui-pill ui-pill--neutral">{{ $course['sessions_done'] }}/{{ $course['sessions_total'] }}</span>
                                            </td>
                                            <td class="text-center balance-money">{{ $money($course['contract']) }}</td>
                                            <td class="text-center balance-money">{{ $money($course['paid']) }}</td>
                                            <td class="text-center balance-money text-success">{{ $money($course['consumed']) }}</td>
                                            <td class="text-center balance-money text-warning">{{ $money($course['unearned']) }}</td>
                                            <td class="text-center">
                                                <div class="balance-progress">
                                                    <span>{{ $percent($course['progress']) }}</span>
                                                    <div class="balance-progress__track">
                                                        <div class="balance-progress__fill" style="width: {{ min($course['progress'], 100) }}%;"></div>
                                                    </div>
                                                </div>
                                            </td>
                                        </tr>
                                    @endforeach
                                @endif
                            @empty
                                <tr>
                                    <td colspan="8">
                                        <div class="table-empty-state">
                                            <iconify-icon icon="ri:user-search-line"></iconify-icon>
                                            <h6>No matching student balances found.</h6>
                                            <p>Try changing the search keyword or clearing filters.</p>
                                        </div>
                                    </td>
                                </tr>
                            @endforelse

                            <tr class="balance-total-row">
                                <td colspan="2">Total</td>
                                <td class="text-center">
                                    <span class="ui-pill ui-pill--neutral">{{ $totals['sessions_done'] }}/{{ $totals['sessions_total'] }}</span>
                                </td>
                                <td class="text-center balance-money">{{ $money($totals['contract']) }}</td>
                                <td class="text-center balance-money">{{ $money($totals['paid']) }}</td>
                                <td class="text-center balance-money">{{ $money($totals['consumed']) }}</td>
                                <td class="text-center balance-money">{{ $money($totals['unearned']) }}</td>
                                <td class="text-center balance-money">{{ $percent($totals['progress']) }}</td>
                            </tr>
                        </x-table>

                    <div class="balance-table-footer">
                        <span>
                            @if ($rows->total() > 0)
                                Showing {{ $rows->firstItem() }}-{{ $rows->lastItem() }} of {{ $rows->total() }} {{ $studentLabel($rows->total()) }}
                            @else
                                Showing 0 {{ $studentLabel(0) }}
                            @endif
                        </span>
                        <span>Consumed is calculated from the paid amount only; unpaid invoice balances are not shown here.</span>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <script>
        document.addEventListener('click', function (event) {
            const button = event.target.closest('.balance-collapse-btn');

            if (!button) {
                return;
            }

            const targets = document.querySelectorAll('.' + button.dataset.target);

            if (!targets.length) {
                return;
            }

            const isOpen = !targets[0].classList.contains('is-open');
            targets.forEach(function (target) {
                target.classList.toggle('is-open', isOpen);
            });
            button.setAttribute('aria-expanded', isOpen ? 'true' : 'false');
        });
    </script>
@endsection

@push('styles')
    <style>
        .student-balances-page .ui-card {
            border: 1px solid #e5e7eb;
            border-radius: 18px;
            background: #fff;
            box-shadow: 0 10px 30px rgba(15, 23, 42, 0.06);
            overflow: hidden;
        }

        .student-balances-page .ui-card__header {
            padding: 1rem 1.25rem;
            border-bottom: 1px solid #eef2f7;
            background: #fff;
        }

        .student-balance-note {
            display: flex;
            align-items: center;
            gap: 0.65rem;
            border: 1px solid #bfdbfe;
            border-radius: 14px;
            background: #eff6ff;
            color: #1e40af;
            padding: 0.85rem 1rem;
            font-size: 0.86rem;
            font-weight: 700;
            line-height: 1.6;
        }

        .balance-stats {
            display: grid;
            grid-template-columns: repeat(4, minmax(0, 1fr));
            gap: 0.9rem;
        }

        .balance-stat {
            border: 1px solid #e5e7eb;
            border-radius: 18px;
            background: #fff;
            box-shadow: 0 10px 30px rgba(15, 23, 42, 0.06);
            padding: 1rem;
        }

        .balance-stat span {
            display: inline-flex;
            align-items: center;
            gap: 0.45rem;
            color: #64748b;
            font-size: 0.78rem;
            font-weight: 850;
        }

        .balance-stat strong {
            display: block;
            margin-top: 0.45rem;
            color: #111827;
            font-size: 1.25rem;
            font-weight: 950;
            font-family: ui-monospace, SFMono-Regular, Menlo, Monaco, Consolas, monospace;
            word-break: break-word;
        }

        .student-balances-table-wrap {
            width: 100%;
            overflow-x: auto;
        }

        .student-balances-page table {
            min-width: 1240px;
            vertical-align: middle;
        }

        .student-balances-page table thead th {
            background: #f8fafc;
            color: #475569;
            font-size: 0.78rem;
            font-weight: 850;
            text-transform: uppercase;
            letter-spacing: 0.035em;
            border-bottom: 1px solid #e5e7eb;
            white-space: nowrap;
        }

        .student-balances-page table tbody td {
            color: #334155;
            font-size: 0.9rem;
            font-weight: 600;
            border-color: #eef2f7;
            vertical-align: middle;
            white-space: nowrap;
        }

        .student-balances-page table tbody tr {
            transition: 0.16s ease;
        }

        .student-balances-page table tbody tr:hover {
            background: #f8fafc;
        }

        .student-balance-student {
            display: inline-flex;
            align-items: center;
            gap: 0.65rem;
            min-width: 260px;
        }

        .student-balance-avatar {
            width: 36px;
            height: 36px;
            border-radius: 13px;
            display: inline-flex;
            align-items: center;
            justify-content: center;
            background: linear-gradient(135deg, #eff6ff, #eef2ff);
            color: #2563eb;
            font-size: 0.78rem;
            font-weight: 900;
            flex-shrink: 0;
        }

        .student-balance-copy {
            display: flex;
            flex-direction: column;
            min-width: 0;
        }

        .student-balance-copy strong,
        .balance-course-name strong {
            color: #111827;
            font-size: 0.9rem;
            font-weight: 850;
            line-height: 1.35;
            max-width: 210px;
            overflow: hidden;
            text-overflow: ellipsis;
        }

        .student-balance-copy small,
        .balance-course-name small {
            color: #94a3b8;
            font-size: 0.76rem;
            font-weight: 650;
            margin-top: 0.1rem;
        }

        .balance-course-name {
            display: inline-flex;
            flex-direction: column;
            min-width: 220px;
            text-align: left;
        }

        .balance-collapse-btn {
            width: 32px;
            height: 32px;
            border: 1px solid #dbe3ef;
            border-radius: 12px;
            background: #fff;
            color: #475569;
            display: inline-flex;
            align-items: center;
            justify-content: center;
            transition: 0.16s ease;
            flex-shrink: 0;
        }

        .balance-collapse-btn:hover {
            background: #f8fafc;
            color: #2563eb;
        }

        .balance-collapse-btn[aria-expanded="true"] {
            background: #eff6ff;
            color: #2563eb;
            border-color: #bfdbfe;
        }

        .balance-collapse-btn[aria-expanded="true"] iconify-icon {
            transform: rotate(180deg);
        }

        .balance-money {
            color: #111827;
            font-family: ui-monospace, SFMono-Regular, Menlo, Monaco, Consolas, monospace;
            font-weight: 900;
        }

        .balance-progress {
            display: inline-grid;
            grid-template-columns: 42px 96px;
            gap: 0.45rem;
            align-items: center;
            color: #475569;
            font-size: 0.78rem;
            font-weight: 850;
        }

        .balance-progress__track {
            height: 7px;
            border-radius: 999px;
            background: #e5e7eb;
            overflow: hidden;
        }

        .balance-progress__fill {
            height: 100%;
            border-radius: inherit;
            background: #0f766e;
        }

        .balance-detail-row {
            display: none;
        }

        .balance-detail-row.is-open {
            display: table-row;
        }

        .balance-detail-row > td {
            background: #fbfdff;
            border-bottom-color: #edf2f7 !important;
        }

        .balance-detail-row > td:first-child {
            position: relative;
        }

        .balance-detail-row > td:first-child::after {
            content: "";
            display: inline-block;
            width: 32px;
            height: 1px;
            background: #cbd5e1;
            vertical-align: middle;
        }

        .balance-course-name--nested {
            padding-left: 0.75rem;
        }

        .balance-total-row td {
            border-top: 1px solid #cbd5e1;
            background: #f8fafc;
            color: #111827;
            font-weight: 950;
        }

        .balance-table-footer {
            display: flex;
            align-items: center;
            justify-content: space-between;
            gap: 1rem;
            flex-wrap: wrap;
            padding: 0.8rem 1.25rem;
            border-top: 1px solid #eef2f7;
            color: #64748b;
            font-size: 0.82rem;
            font-weight: 700;
            background: #fff;
        }

        .table-empty-state {
            padding: 3rem 1rem;
            text-align: center;
            color: #94a3b8;
            background: #fff;
        }

        .table-empty-state iconify-icon {
            display: block;
            font-size: 2.3rem;
            color: #cbd5e1;
            margin-bottom: 0.75rem;
        }

        .table-empty-state h6 {
            margin: 0;
            color: #475569;
            font-weight: 850;
        }

        .table-empty-state p {
            margin: 0.35rem 0 0;
            font-size: 0.9rem;
        }

        .table-pagination {
            padding: 1rem 1.25rem;
            border-top: 1px solid #eef2f7;
            background: #fff;
        }

        .student-balances-page .table-controls-form {
            max-width: 100%;
            overflow-x: auto;
            padding-bottom: 0.1rem;
        }

        .student-balances-page .table-controls-form::-webkit-scrollbar {
            height: 6px;
        }

        .student-balances-page .table-controls-form::-webkit-scrollbar-track {
            background: #f1f5f9;
            border-radius: 999px;
        }

        .student-balances-page .table-controls-form::-webkit-scrollbar-thumb {
            background: #cbd5e1;
            border-radius: 999px;
        }

        @media (max-width: 1199.98px) {
            .balance-stats {
                grid-template-columns: repeat(2, minmax(0, 1fr));
            }
        }

        @media (max-width: 991.98px) {
            .student-balances-page .ui-card__header > .d-flex {
                align-items: flex-start !important;
            }

            .student-balances-page .table-controls-form {
                width: 100%;
            }
        }

        @media (max-width: 767.98px) {
            .balance-stats {
                grid-template-columns: 1fr;
            }

            .balance-course-name--nested { padding-left: 0; }
        }

        @media (max-width: 575.98px) {
            .student-balances-page .ui-card__header,
            .table-pagination,
            .balance-table-footer {
                padding: 1rem;
            }
        }
    </style>
@endpush