@extends('layouts.app')

@section('title', 'Информация о студенте')

{{--
    Ports app/Views/student/show.php (legacy, 1716 lines) + the render()
    payload from App\Controllers\StudentController::show()
    (app/Controllers/StudentController.php:756-959) — see the Phase 8 plan.

    Every write form on this page is Laravel-native (@csrf) as of Phase 14 —
    payments/charges (PaymentController, Phases 9-10/12), frozen days
    (Phase 11), student edit/responsibles (Phase 13), and status
    change/tariff assignment (Phase 14) each moved once their last legacy
    caller was confirmed gone. The lessonStatusModal's fetch() still has no
    CSRF field at all, matching legacy LessonController::updateStudentStatus(),
    which never called verifyCsrf() either — its endpoint moved to
    LessonAttendanceController::updateStudentStatus() in Phase 27 (the JS
    here is unchanged, still posts the same JSON to the same URL).

    Role gating below mirrors the legacy view's per-section
    in_array($role, [...]) checks exactly — the page itself has no
    page-level role restriction (only SessionAuth::check()), which is a
    pre-existing gap flagged (not fixed) in the Phase 8 plan.
--}}


@php
    $attColorClass = $attendancePct < 50 ? 'ax-metric-value--danger' : ($attendancePct < 80 ? 'ax-metric-value--warning' : 'ax-metric-value--success');
    $latenessColorClass = $latenessCount > 0 ? 'ax-metric-value--danger' : '';
    $absencesColorClass = $absences > 0 ? 'ax-metric-value--danger' : '';
@endphp

@section('content')
<div class="container" style="max-width: 1040px;">

    @if (!$studentInfo)
        <div class="alert alert-warning">Информация о студенте не найдена.</div>
    @else

        {{-- SECTION 1 — Main info --}}
        <div class="ax-info-section">
            <div class="ax-info-section-header">
                <span class="ax-info-section-title">Общая информация</span>
                <div class="d-flex gap-2">
                    <button class="btn btn-warning btn-sm" data-bs-toggle="modal" data-bs-target="#editStudentModal">
                        Редактировать
                    </button>
                    <button class="btn btn-outline-secondary btn-sm" type="button" data-bs-toggle="modal" data-bs-target="#changeStatusModal">
                        Сменить статус
                    </button>
                    <button class="btn btn-outline-success btn-sm" type="button" data-bs-toggle="modal" data-bs-target="#discountModal">
                        Скидка
                    </button>
                    @if (\App\Support\Modules::enabled('student_password'))
                        <button class="btn btn-outline-danger btn-sm" type="button" data-bs-toggle="modal" data-bs-target="#studentPasswordModal">
                            Сменить пароль
                        </button>
                    @endif
                    @if ($role === 'admin')
                        <button class="btn btn-danger btn-sm" type="button" data-bs-toggle="modal" data-bs-target="#deleteStudentModal">
                            Удалить
                        </button>
                    @endif
                </div>
            </div>

            {{--
                Удаление ученика — admin only, and only for a student with no
                history behind them. StudentProfileController::destroyStudent()
                re-checks both server-side and refuses with a message naming
                what blocked it; this modal just states the rule up front so an
                admin isn't surprised by the refusal.
            --}}
            @if ($role === 'admin')
                <div class="modal fade" id="deleteStudentModal" tabindex="-1" aria-hidden="true">
                    <div class="modal-dialog modal-dialog-centered">
                        <div class="modal-content">
                            <form method="POST" action="/delete_student.php"
                                  onsubmit="return confirm('Удалить ученика безвозвратно? Это действие нельзя отменить!');">
                                @csrf
                                <input type="hidden" name="student_id" value="{{ $studentId }}">
                                <div class="modal-header bg-danger text-white">
                                    <h5 class="modal-title">Удаление ученика</h5>
                                    <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal"></button>
                                </div>
                                <div class="modal-body">
                                    <p>
                                        Ученик
                                        <strong>{{ trim($studentInfo->last_name.' '.$studentInfo->first_name.' '.($studentInfo->middle_name ?? '')) }}</strong>
                                        будет удалён безвозвратно вместе с учётной записью для входа.
                                    </p>
                                    <p class="mb-0 text-muted small">
                                        Удалить можно только ученика без истории. Если за ним есть платежи,
                                        начисления, посещаемость, группы или результаты — удаление будет
                                        отклонено: для таких учеников используйте статус «Не учится».
                                    </p>
                                </div>
                                <div class="modal-footer">
                                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                                    <button type="submit" class="btn btn-danger">Удалить</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            @endif
            <div class="ax-info-section-body">
                <div class="d-flex align-items-center gap-3 mb-3">
                    <div class="ax-avatar-circle">
                        {{ mb_strtoupper(mb_substr($studentInfo->last_name, 0, 1).mb_substr($studentInfo->first_name, 0, 1)) }}
                    </div>
                    <div>
                        <h4 class="mb-1">
                            {{ trim($studentInfo->last_name.' '.$studentInfo->first_name.' '.($studentInfo->middle_name ?? '')) }}
                        </h4>
                        @if (!empty($studentInfo->status_name))
                            <span class="badge bg-{{ $studentInfo->status_color }}">
                                {{ $studentInfo->status_name }}
                            </span>
                        @endif
                    </div>
                </div>

                <div class="ax-field-grid">
                    <div>
                        <div class="ax-field-label">Фамилия</div>
                        <div class="ax-field-value">{{ $studentInfo->last_name ?: '—' }}</div>
                    </div>
                    <div>
                        <div class="ax-field-label">Имя</div>
                        <div class="ax-field-value">{{ $studentInfo->first_name ?: '—' }}</div>
                    </div>
                    <div>
                        <div class="ax-field-label">Класс</div>
                        <div class="ax-field-value">{{ $studentInfo->class_name ?? '—' }}</div>
                    </div>
                    <div>
                        <div class="ax-field-label">Язык обучения</div>
                        <div class="ax-field-value">{{ $studentInfo->language_name ?? '—' }}</div>
                    </div>
                    <div>
                        <div class="ax-field-label">Формат обучения</div>
                        <div class="ax-field-value">{{ $studentInfo->learning_type_name ?? '—' }}</div>
                    </div>
                    <div>
                        <div class="ax-field-label">Цель</div>
                        <div class="ax-field-value ax-field-value--dummy">—</div>
                    </div>
                    <div>
                        <div class="ax-field-label">Статус</div>
                        <div class="ax-field-value">{{ $studentInfo->status_name ?? '—' }}</div>
                    </div>
                    <div>
                        <div class="ax-field-label">Кол-во договоров</div>
                        <div class="ax-field-value ax-field-value--dummy">—</div>
                    </div>
                    <div>
                        <div class="ax-field-label">Скидка за лояльность</div>
                        <div class="ax-field-value">{{ $studentInfo->discount_percent > 0 ? $studentInfo->discount_percent.'%' : 'Без скидки' }}</div>
                    </div>
                </div>
            </div>
        </div>

        {{-- SECTION 2 — Contacts --}}
        <div class="ax-info-section">
            <div class="ax-info-section-header">
                <span class="ax-info-section-title">Контакты</span>
                @if (in_array($role, ['admin'], true))
                    <button type="button" class="btn btn-outline-secondary btn-sm"
                            data-bs-toggle="modal" data-bs-target="#editResponsiblesModal">
                        Редактировать ответственных
                    </button>
                @endif
            </div>
            <div class="ax-info-section-body">
                <div class="ax-field-grid">
                    <div>
                        <div class="ax-field-label">Телефон студента</div>
                        <div class="ax-field-value">{{ $studentInfo->phone ?? '—' }}</div>
                    </div>
                    @if (\App\Support\Modules::enabled('student_iin'))
                        <div>
                            <div class="ax-field-label">ИИН</div>
                            <div class="ax-field-value">{{ $studentInfo->iin ?? '—' }}</div>
                        </div>
                    @endif
                    @if (\App\Support\Modules::enabled('student_agreement_number'))
                        <div>
                            <div class="ax-field-label">Номер договора</div>
                            <div class="ax-field-value">{{ $studentInfo->agreement_number ?? '—' }}</div>
                        </div>
                    @endif
                    <div>
                        <div class="ax-field-label">Цель</div>
                        <div class="ax-field-value">{!! nl2br(e($studentInfo->goal ?? '—')) !!}</div>
                    </div>
                    <div>
                        <div class="ax-field-label">Фамилия родителя</div>
                        <div class="ax-field-value">{{ $studentInfo->agent_last_name ?? '—' }}</div>
                    </div>
                    <div>
                        <div class="ax-field-label">Имя родителя</div>
                        <div class="ax-field-value">{{ $studentInfo->agent_first_name ?? '—' }}</div>
                    </div>
                    <div>
                        <div class="ax-field-label">Телефон родителя</div>
                        <div class="ax-field-value">{{ $studentInfo->agent_phone_number ?? '—' }}</div>
                    </div>
                    @if (in_array($role, ['admin'], true))
                        <div>
                            <div class="ax-field-label">Куратор</div>
                            <div class="ax-field-value">{{ trim($responsibles->curator_fullname ?? '—') }}</div>
                        </div>
                        <div>
                            <div class="ax-field-label">Менеджер</div>
                            <div class="ax-field-value">{{ trim($responsibles->manager_fullname ?? '—') }}</div>
                        </div>
                    @endif
                </div>
            </div>
        </div>

        {{-- SECTION 3 — Indicators --}}
        <div class="ax-info-section">
            <div class="ax-info-section-header">
                <span class="ax-info-section-title">Показатели</span>
                <form method="GET" class="d-flex align-items-center gap-2 mb-0" style="flex-wrap:wrap;">
                    <input type="hidden" name="student_id" value="{{ $studentId }}">
                    <label class="small text-muted mb-0">с</label>
                    <input type="date" name="date_from" value="{{ $dateFrom }}"
                           class="form-control form-control-sm" style="max-width:140px; width:100%;">
                    <label class="small text-muted mb-0">по</label>
                    <input type="date" name="date_to" value="{{ $dateTo }}"
                           class="form-control form-control-sm" style="max-width:140px; width:100%;">
                    <button type="submit" class="btn btn-primary btn-sm">Применить</button>
                </form>
            </div>
            <div class="ax-info-section-body">
                <div class="ax-metric-grid">
                    <div class="ax-metric-card">
                        <div class="ax-metric-label">Дата добавления</div>
                        <div class="ax-metric-value">
                            {{ $studentInfo->created_at ? date('d.m.Y', strtotime($studentInfo->created_at)) : '—' }}
                        </div>
                    </div>
                    <div class="ax-metric-card">
                        <div class="ax-metric-label">Последний урок</div>
                        <div class="ax-metric-value">
                            {{ $lastLessonDate ? date('d.m.Y', strtotime($lastLessonDate)) : '—' }}
                        </div>
                    </div>
                    <div class="ax-metric-card">
                        <div class="ax-metric-label">Часов в {{ config('app.name') }}</div>
                        <div class="ax-metric-value">{{ $hoursInAxioma }}</div>
                    </div>
                    <div class="ax-metric-card">
                        <div class="ax-metric-label">Посещаемость</div>
                        <div class="ax-metric-value {{ $attColorClass }}">{{ $attendancePct }}%</div>
                    </div>
                    <div class="ax-metric-card">
                        <div class="ax-metric-label">Опозданий</div>
                        <div class="ax-metric-value {{ $latenessColorClass }}">{{ $latenessCount }}</div>
                    </div>
                    <div class="ax-metric-card">
                        <div class="ax-metric-label">Пропусков</div>
                        <div class="ax-metric-value {{ $absencesColorClass }}">{{ $absences }}</div>
                    </div>
                    <div class="ax-metric-card">
                        <div class="ax-metric-label">Средний балл КР/ДЗ</div>
                        <div class="ax-metric-value {{ $avgKrDz !== null ? '' : 'ax-metric-value--dummy' }}">
                            {{ $avgKrDz ?? '—' }}
                        </div>
                    </div>
                    <div class="ax-metric-card">
                        <div class="ax-metric-label">Средний балл тестов</div>
                        <div class="ax-metric-value {{ $avgTestScore !== null ? '' : 'ax-metric-value--dummy' }}">
                            {{ $avgTestScore ?? '—' }}
                        </div>
                    </div>
                </div>
            </div>
        </div>

        {{-- SECTION 4 — Finance & Gamification (admin only) --}}
        @if (in_array($role, ['admin'], true))
            @php
                $totalPaid = (float) ($balance->total_paid ?? 0);
                $totalCharged = (float) ($balance->total_charged ?? 0);
                $net = $totalPaid - $totalCharged;
                if ($net >= 0) {
                    $payStatusLabel = 'Оплачено';
                    $payStatusClass = 'success';
                } elseif ($net > -5000) {
                    $payStatusLabel = 'Частично';
                    $payStatusClass = 'warning';
                } else {
                    $payStatusLabel = 'Долг';
                    $payStatusClass = 'danger';
                }
            @endphp
            <div class="ax-info-section">
                <div class="ax-info-section-header">
                    <span class="ax-info-section-title">Финансы и геймификация</span>
                    <div class="d-flex gap-2">
                        <button class="btn btn-success btn-sm"
                                data-bs-toggle="modal" data-bs-target="#addPaymentModal">
                            + Оплата
                        </button>
                        <button class="btn btn-outline-danger btn-sm"
                                data-bs-toggle="modal" data-bs-target="#addChargeModal">
                            + Начисление
                        </button>
                    </div>
                </div>
                <div class="ax-info-section-body">

                    <div class="ax-sub-label">Финансы</div>
                    <div class="ax-metric-grid">
                        <div class="ax-metric-card">
                            <div class="ax-metric-label">Оплачено (всё время)</div>
                            <div class="ax-metric-value ax-metric-value--success" id="totalPaidValue">{{ number_format($totalPaid, 0, ',', ' ') }} &#8376;</div>
                        </div>
                        <div class="ax-metric-card">
                            <div class="ax-metric-label">Долг за год</div>
                            <div class="ax-metric-value {{ $annualDebt > 0 ? 'ax-metric-value--danger' : 'ax-metric-value--success' }}" id="annualDebtValue">
                                {{ number_format(abs($annualDebt), 0, ',', ' ') }} &#8376;
                            </div>
                        </div>
                        <div class="ax-metric-card">
                            <div class="ax-metric-label">Статус оплаты</div>
                            <div class="ax-metric-value" style="font-size:14px;">
                                <span class="badge bg-{{ $payStatusClass }}" id="payStatusBadge">{{ $payStatusLabel }}</span>
                            </div>
                        </div>
                    </div>
                    <div class="mt-2">
                        <button class="btn btn-outline-secondary btn-sm"
                                data-bs-toggle="modal" data-bs-target="#paymentsModal">
                            Все платежи
                        </button>
                    </div>

                    <hr class="ax-section-divider">

                    <div class="ax-sub-label">Групповой тариф</div>
                    <div class="d-flex align-items-center justify-content-between p-2 rounded border mb-2" style="background:#f8fafc; font-size:14px;">
                        @if (!empty($studentInfo->general_tariff_name))
                            <div>
                                <strong>{{ preg_replace('/^\[manual\]\s*/', '', $studentInfo->general_tariff_name) }}</strong>
                                &nbsp;&middot;&nbsp;
                                {{ number_format((float) $studentInfo->general_tariff_price, 0, ',', ' ') }} &#8376;
                                / {{ (int) $studentInfo->general_tariff_lessons_count }} уроков
                                @if ((int) $studentInfo->general_tariff_lessons_count > 0)
                                    <span class="text-muted">({{ number_format((float) $studentInfo->general_tariff_price / (int) $studentInfo->general_tariff_lessons_count, 0, ',', ' ') }} &#8376;/ур.)</span>
                                @endif
                            </div>
                        @else
                            <span class="text-muted">Не назначен</span>
                        @endif
                        @if ($role === 'admin')
                            <button class="btn btn-outline-secondary btn-sm ms-2"
                                    onclick="openEditGeneralTariffModal({{ (int) ($studentInfo->general_tariff_id ?? 0) }})">
                                &#9998;
                            </button>
                        @endif
                    </div>

                    <div class="ax-sub-label">Индивидуальный тариф</div>
                    <div class="d-flex align-items-center justify-content-between p-2 rounded border" style="background:#f8fafc; font-size:14px;">
                        @if (!empty($studentInfo->individual_tariff_name))
                            <div>
                                <strong>{{ preg_replace('/^\[manual\]\s*/', '', $studentInfo->individual_tariff_name) }}</strong>
                                &nbsp;&middot;&nbsp;
                                {{ number_format((float) $studentInfo->individual_tariff_price, 0, ',', ' ') }} &#8376;
                                / {{ (int) $studentInfo->individual_tariff_lessons_count }} уроков
                                @if ((int) $studentInfo->individual_tariff_lessons_count > 0)
                                    <span class="text-muted">({{ number_format((float) $studentInfo->individual_tariff_price / (int) $studentInfo->individual_tariff_lessons_count, 0, ',', ' ') }} &#8376;/ур.)</span>
                                @endif
                            </div>
                        @else
                            <span class="text-muted">Не назначен</span>
                        @endif
                        @if ($role === 'admin')
                            <button class="btn btn-outline-secondary btn-sm ms-2"
                                    onclick="openEditIndividualTariffModal({{ (int) ($studentInfo->individual_tariff_id ?? 0) }})">
                                &#9998;
                            </button>
                        @endif
                    </div>

                    <hr class="ax-section-divider">

                    <div class="ax-sub-label">Жалобы и похвалы</div>
                    <div class="ax-metric-grid">
                        <div class="ax-metric-card">
                            <div class="ax-metric-label">Похвалы</div>
                            <div class="ax-metric-value ax-metric-value--success">{{ $praiseCount }}</div>
                        </div>
                        <div class="ax-metric-card">
                            <div class="ax-metric-label">Жалобы</div>
                            <div class="ax-metric-value {{ $complaintCount > 0 ? 'ax-metric-value--danger' : '' }}">{{ $complaintCount }}</div>
                        </div>
                    </div>
                    <div class="mt-2">
                        <button class="btn btn-outline-secondary btn-sm"
                                data-bs-toggle="modal" data-bs-target="#commentsModal">
                            Все записи
                        </button>
                    </div>

                    <hr class="ax-section-divider">

                    <div class="ax-sub-label">Геймификация</div>
                    <div class="ax-metric-grid">
                        <div class="ax-metric-card">
                            <div class="ax-metric-label">Имя героя</div>
                            <div class="ax-metric-value ax-metric-value--dummy">—</div>
                        </div>
                        <div class="ax-metric-card">
                            <div class="ax-metric-label">Опыт (XP)</div>
                            <div class="ax-metric-value ax-metric-value--dummy">—</div>
                        </div>
                        <div class="ax-metric-card">
                            <div class="ax-metric-label">Монеты</div>
                            <div class="ax-metric-value ax-metric-value--dummy">—</div>
                        </div>
                    </div>
                    <p class="text-muted small mt-2">Геймификация пока не настроена для этого студента.</p>

                </div>
            </div>
        @endif

        {{-- GROUPS --}}
        <div class="d-flex align-items-center justify-content-between mt-2 mb-3">
            <h5 class="mb-0">Группы студента</h5>
            @if (in_array($role, ['admin'], true))
                <button class="btn btn-primary btn-sm" type="button" data-bs-toggle="modal" data-bs-target="#addToGroupModal">
                    Добавить в группу
                </button>
            @endif
        </div>

        @if (!empty($groupInfo['active']) || !empty($groupInfo['inactive']))

            @foreach ($groupInfo['active'] as $group)
                @include('students._group_card', ['group' => $group])
            @endforeach

            @if (!empty($groupInfo['inactive']))
                <div class="mb-3">
                    <button class="btn btn-outline-secondary btn-sm w-100"
                            type="button"
                            data-bs-toggle="collapse"
                            data-bs-target="#inactiveGroups">
                        Бывшие группы ({{ count($groupInfo['inactive']) }}) &#9662;
                    </button>
                    <div class="collapse mt-2" id="inactiveGroups">
                        @foreach ($groupInfo['inactive'] as $group)
                            @include('students._group_card', ['group' => $group])
                        @endforeach
                    </div>
                </div>
            @endif

        @else
            <div class="ax-empty-state">
                        <i class="bi bi-people ax-empty-icon"></i>
                        Студент не состоит ни в одной группе.
                    </div>
        @endif

        {{-- Weekly test results --}}
        @if (in_array($role, ['admin', 'adviser'], true))
            <div class="card shadow-sm mb-4">
                <div class="card-body">
                    <h5 class="card-title">Результаты еженедельных тестов</h5>
                    @if (!empty($weeklyResults))
                        <div class="d-flex flex-wrap gap-2 mt-2">
                            @foreach ($weeklyResults as $res)
                                @php
                                    $scoreText = $res->score !== null ? "{$res->score}/{$res->max_score}" : '—';
                                    $passed = $res->score !== null && $res->score >= ($res->max_score / 2);
                                    $bgColor = $passed ? '#28a745' : '#dc3545';
                                    $tooltip = 'Дата: '.date('d.m.Y', strtotime($res->lesson_date ?? '')).
                                        "\nУчитель: ".($res->teacher_name ?? '—').
                                        "\nРезультат: ".$scoreText;
                                @endphp
                                <div class="p-2 text-white rounded"
                                     data-bs-toggle="tooltip" data-bs-placement="top"
                                     title="{{ $tooltip }}"
                                     style="background-color: {{ $bgColor }};">
                                    {{ $scoreText }}
                                </div>
                            @endforeach
                        </div>
                    @else
                        <p class="text-muted">Нет результатов тестов.</p>
                    @endif
                </div>
            </div>
        @endif

        {{-- ЕНТ results: null when the viewer isn't admin/adviser or the instance
             doesn't enter ЕНТ scores (MODULE_ADMIN_ENT_SCORES) — see show(). Same
             numbers and formatting as /teacher/ent_results.php, for one student. --}}
        @if ($entResults !== null)
            @php
                $entFmt = fn ($value) => rtrim(rtrim(number_format((float) $value, 1, '.', ' '), '0'), '.');
                $entSigned = fn ($value) => ($value >= 0 ? '+' : '−') . $entFmt(abs($value));
                $entTone = fn ($value) => $value === null ? 'ax-metric-value--dummy' : ($value >= 0 ? 'text-success' : 'text-danger');
            @endphp
            <div class="card shadow-sm mb-4">
                <div class="card-body">
                    <h5 class="card-title">Результаты ЕНТ</h5>
                    @if (empty($entResults['attempts']))
                        <p class="text-muted mb-0">Нет результатов ЕНТ.</p>
                    @else
                        <div class="ax-metric-grid mb-3">
                            <div class="ax-metric-card">
                                <div class="ax-metric-label">Попыток</div>
                                <div class="ax-metric-value">{{ count($entResults['attempts']) }}</div>
                            </div>
                            <div class="ax-metric-card">
                                <div class="ax-metric-label">Последний</div>
                                <div class="ax-metric-value">{{ $entFmt($entResults['latest']['total']) }}</div>
                                <div class="text-muted small">{{ date('d.m.Y', strtotime($entResults['latest']['date'])) }}</div>
                            </div>
                            <div class="ax-metric-card">
                                <div class="ax-metric-label">&Delta; к предыдущему</div>
                                <div class="ax-metric-value {{ $entTone($entResults['delta']) }}">
                                    {{ $entResults['delta'] === null ? '—' : $entSigned($entResults['delta']) }}
                                </div>
                            </div>
                            <div class="ax-metric-card">
                                <div class="ax-metric-label">С первой попытки</div>
                                <div class="ax-metric-value {{ $entTone($entResults['total_delta']) }}">
                                    {{ $entResults['total_delta'] === null ? '—' : $entSigned($entResults['total_delta']) }}
                                </div>
                            </div>
                            <div class="ax-metric-card" title="Средний прирост суммы баллов за одну попытку">
                                <div class="ax-metric-label">Ср. прогресс</div>
                                <div class="ax-metric-value {{ $entTone($entResults['avg_delta']) }}">
                                    {{ $entResults['avg_delta'] === null ? '—' : $entSigned($entResults['avg_delta']) }}
                                </div>
                            </div>
                            <div class="ax-metric-card">
                                <div class="ax-metric-label">Лучший</div>
                                <div class="ax-metric-value">{{ $entFmt($entResults['best']) }}</div>
                            </div>
                        </div>
                        <div class="table-responsive">
                            <table class="table table-sm align-middle mb-0">
                                <thead>
                                    <tr class="text-muted small">
                                        <th style="width:120px;">Дата</th>
                                        <th class="text-center" style="width:110px;">Итого</th>
                                        <th class="text-center" style="width:90px;">&Delta;</th>
                                        <th style="min-width:260px;">По предметам</th>
                                        <th style="min-width:140px;">Заметка</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($entResults['attempts'] as $attempt)
                                        <tr>
                                            <td>{{ date('d.m.Y', strtotime($attempt['date'])) }}</td>
                                            <td class="text-center fw-bold">
                                                {{ $entFmt($attempt['total']) }}
                                                @if ($attempt['max_total'] > 0)
                                                    <span class="text-muted fw-normal small">/ {{ $entFmt($attempt['max_total']) }}</span>
                                                @endif
                                            </td>
                                            <td class="text-center">
                                                @if ($attempt['delta'] === null)
                                                    <span class="text-muted">—</span>
                                                @else
                                                    <span class="{{ $attempt['delta'] >= 0 ? 'text-success' : 'text-danger' }}">{{ $entSigned($attempt['delta']) }}</span>
                                                @endif
                                            </td>
                                            <td>
                                                @forelse ($attempt['sections'] as $section)
                                                    <span class="badge bg-secondary fw-normal me-1 mb-1">
                                                        {{ $section['name'] }}: {{ $entFmt($section['score']) }}/{{ $entFmt($section['max_score']) }}
                                                    </span>
                                                @empty
                                                    {{-- Rows entered before ent_scores.section_id existed have no subject. --}}
                                                    <span class="text-muted small">без разбивки по предметам</span>
                                                @endforelse
                                            </td>
                                            <td class="text-muted small">{{ $attempt['note'] ?: '—' }}</td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    @endif
                </div>
            </div>
        @endif

        {{-- Frozen days --}}
        @if (in_array($role, ['admin', 'adviser'], true))
            <div class="card shadow-sm mb-4">
                <div class="card-body">
                    <h5 class="card-title">Замороженные дни</h5>
                    <div id="frozenDaysAlert"></div>
                    @if ($frozenDays)
                        <div class="table-responsive mb-3">
                            <table class="table table-bordered table-sm align-middle mb-0">
                                <thead class="table-light">
                                <tr><th>С</th><th>По</th><th>Причина</th><th>Действие</th></tr>
                                </thead>
                                <tbody>
                                @foreach ($frozenDays as $freeze)
                                    <tr>
                                        <td>{{ $freeze->date_from }}</td>
                                        <td>{{ $freeze->date_to }}</td>
                                        <td>{!! nl2br(e($freeze->reason)) !!}</td>
                                        <td>
                                            <form action="/delete_frozen_day.php" method="POST"
                                                  class="js-ajax-form" data-remove-target="tr" data-alert-target="#frozenDaysAlert"
                                                  onsubmit="return confirm('Удалить запись?');">
                                                @csrf
                                                <input type="hidden" name="id" value="{{ $freeze->id }}">
                                                <input type="hidden" name="student_id" value="{{ $studentId }}">
                                                <button type="submit" class="btn btn-sm btn-danger">Удалить</button>
                                            </form>
                                        </td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>
                    @else
                        <p class="text-muted">Нет замороженных дней.</p>
                    @endif
                    <hr>
                    <h6 class="mb-3">Добавить заморозку</h6>
                    <form action="/add_frozen_day.php" method="POST">
                        @csrf
                        <input type="hidden" name="student_id" value="{{ $studentId }}">
                        <div class="row">
                            <div class="col-md-4 mb-2">
                                <label class="form-label">С:</label>
                                <input type="date" name="date_from" class="form-control" required>
                            </div>
                            <div class="col-md-4 mb-2">
                                <label class="form-label">По:</label>
                                <input type="date" name="date_to" class="form-control" required>
                            </div>
                            <div class="col-md-4 mb-2">
                                <label class="form-label">Причина:</label>
                                <input type="text" name="reason" class="form-control">
                            </div>
                        </div>
                        <button type="submit" class="btn btn-primary mt-2">Добавить</button>
                    </form>
                </div>
            </div>
        @endif

        {{-- Status history --}}
        @if (in_array($role, ['admin', 'adviser'], true))
            <div class="card shadow-sm mb-4">
                <div class="card-body">
                    <h5 class="card-title">История статусов</h5>
                    @if ($statusHistory)
                        <div class="table-responsive">
                            <table class="table table-bordered table-sm align-middle mb-0">
                                <thead class="table-light">
                                <tr><th>Дата и время</th><th>Было</th><th>Стало</th><th>Причина</th><th>Кто изменил</th></tr>
                                </thead>
                                <tbody>
                                @foreach ($statusHistory as $change)
                                    <tr>
                                        <td>{{ date('d.m.Y H:i', strtotime($change->created_at)) }}</td>
                                        <td>
                                            @if ($change->old_status_name)
                                                <span class="badge bg-{{ $change->old_status_color }}">
                                                    {{ $change->old_status_name }}
                                                </span>
                                            @else
                                                <span class="text-muted">—</span>
                                            @endif
                                        </td>
                                        <td>
                                            @if ($change->new_status_name)
                                                <span class="badge bg-{{ $change->new_status_color }}">
                                                    {{ $change->new_status_name }}
                                                </span>
                                            @else
                                                <span class="text-muted">—</span>
                                            @endif
                                        </td>
                                        <td>{{ $change->reason_name ?? '—' }}</td>
                                        <td>{{ $change->changed_by_name ?? '—' }}</td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>
                    @else
                        <p class="text-muted mb-0">Изменений статуса ещё не было.</p>
                    @endif
                </div>
            </div>
        @endif

        <a href="/students.php" class="btn btn-secondary mb-4">Вернуться на панель</a>

    @endif {{-- end $studentInfo check --}}

</div><!-- /container -->

{{-- MODALS --}}

<!-- Lesson status -->
<div class="modal fade" id="lessonStatusModal" tabindex="-1">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Изменить статус урока</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body">
                <p id="modalLessonDate"></p>
                <p id="modalLessonFrozen" class="text-info fw-bold d-none">Заморожен</p>
                <ul class="list-unstyled small mb-3">
                    <li><strong>КР:</strong> <span id="modalLessonKr">—</span></li>
                    <li><strong>ДЗ:</strong> <span id="modalLessonDz">—</span></li>
                    <li><strong>Опоздание:</strong> <span id="modalLessonLateness">—</span></li>
                    <li><strong>Комментарии:</strong> <span id="modalLessonComments">—</span></li>
                </ul>
                <select id="modalStatusSelect" class="form-select">
                    <option value="attended">Присутствовал</option>
                    <option value="paid_absence">Оплачиваемый пропуск</option>
                    <option value="free_absence">Бесплатный пропуск</option>
                </select>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                <button type="button" class="btn btn-primary" id="saveLessonStatusBtn">Сохранить</button>
            </div>
        </div>
    </div>
</div>

<!-- Change student status -->
<div class="modal fade" id="changeStatusModal" tabindex="-1">
    <div class="modal-dialog">
        <div class="modal-content">
            <form method="POST" action="/change_status.php">
                @csrf
                <input type="hidden" name="student_id" value="{{ $studentId }}">
                <div class="modal-header">
                    <h5 class="modal-title">Сменить статус</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <div class="mb-3">
                        <label class="form-label">Новый статус</label>
                        <select name="status_id" id="changeStatusSelect" class="form-select" required>
                            <option value="">— Выберите статус —</option>
                            @foreach ($allStatuses as $st)
                                <option value="{{ $st->id }}">{{ $st->name }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Дата изменения</label>
                        <input type="date" name="status_date" class="form-control" value="{{ now()->toDateString() }}" required>
                    </div>
                    <div class="mb-3 d-none" id="changeStatusReasonWrap">
                        <label class="form-label">Причина (необязательно)</label>
                        <select name="reason_id" class="form-select">
                            <option value="">— Не указана —</option>
                            @foreach ($allStatusReasons as $r)
                                <option value="{{ $r->id }}">{{ $r->name }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                    <button type="submit" class="btn btn-primary">Сохранить</button>
                </div>
            </form>
        </div>
    </div>
</div>

<!-- Student discount -->
<div class="modal fade" id="discountModal" tabindex="-1">
    <div class="modal-dialog">
        <div class="modal-content">
            <form method="POST" action="/update_student_discount.php">
                @csrf
                <input type="hidden" name="student_id" value="{{ $studentId }}">
                <div class="modal-header">
                    <h5 class="modal-title">Скидка за лояльность</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <div class="mb-3">
                        <label class="form-label">Скидка</label>
                        <select name="discount_percent" class="form-select">
                            @foreach ([0, 5, 10, 15] as $pct)
                                <option value="{{ $pct }}" {{ (int) $studentInfo->discount_percent === $pct ? 'selected' : '' }}>
                                    {{ $pct > 0 ? $pct.'%' : 'Без скидки' }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                    <button type="submit" class="btn btn-primary">Сохранить</button>
                </div>
            </form>
        </div>
    </div>
</div>

@if (\App\Support\Modules::enabled('student_password'))
    <div class="modal fade" id="studentPasswordModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content">
                <form method="POST" action="/update_student_password.php">
                    @csrf
                    <input type="hidden" name="student_id" value="{{ $studentId }}">
                    <div class="modal-header">
                        <h5 class="modal-title">Сменить пароль ученика</h5>
                        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                    </div>
                    <div class="modal-body">
                        <div class="mb-3">
                            <label for="new_password" class="form-label">Новый пароль</label>
                            <input type="password" class="form-control" name="new_password" id="new_password" required minlength="6">
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                        <button type="submit" class="btn btn-primary">Сохранить</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
@endif

<!-- All payments modal -->
@if (in_array($role, ['admin'], true))
    <div class="modal fade" id="paymentsModal" tabindex="-1">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Все платежи</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <div id="paymentsModalAlert"></div>

                    {{-- Both tables below carry the student's full history (no row cap), so
                         this filter is what keeps an old account readable: it hides rows by
                         year client-side and re-totals what's left. --}}
                    <div class="d-flex flex-wrap align-items-center gap-2 mb-3">
                        <label for="financeYearFilter" class="form-label mb-0 small text-muted">Год:</label>
                        <select id="financeYearFilter" class="form-select form-select-sm" style="width:auto;">
                            <option value="">Все годы</option>
                        </select>
                    </div>

                    <h6>
                        Платежи
                        <span class="text-muted fw-normal small" data-finance-count="payment">(всего {{ count($payments) }})</span>
                    </h6>
                    @if (!empty($payments))
                        <div class="table-responsive" style="max-height:320px; overflow-y:auto;">
                            <table class="table table-sm table-hover align-middle mb-0">
                                <thead class="table-light" style="position:sticky; top:0; z-index:1;">
                                <tr>
                                    <th>Дата</th>
                                    <th>Период</th>
                                    <th>Тип</th>
                                    <th class="text-end">Сумма</th>
                                    <th>Описание</th>
                                    <th></th>
                                </tr>
                                </thead>
                                <tbody id="paymentsTableBody">
                                @foreach ($payments as $p)
                                    <tr data-payment-row="{{ $p->id }}"
                                        data-finance-row="payment"
                                        data-year="{{ substr((string) $p->payment_date, 0, 4) }}"
                                        data-amount="{{ (float) $p->amount }}">
                                        <td>{{ $p->payment_date }}</td>
                                        <td class="text-muted small">
                                            @if (!empty($p->start_date) || !empty($p->end_date))
                                                {{ $p->start_date ?? '—' }} &ndash; {{ $p->end_date ?? '—' }}
                                            @else
                                                —
                                            @endif
                                        </td>
                                        <td>
                                            @if (!empty($p->is_first_payment))
                                                <span class="badge bg-primary">Новый</span>
                                            @else
                                                <span class="badge bg-secondary">Повторный</span>
                                            @endif
                                        </td>
                                        <td class="text-end text-success fw-semibold">
                                            {{ number_format((float) $p->amount, 0, ',', ' ') }} &#8376;
                                        </td>
                                        <td class="text-muted small">{{ $p->description ?? '—' }}</td>
                                        <td>
                                            <form method="POST" action="/delete_payment.php"
                                                  class="js-ajax-form js-ajax-payment-charge-form"
                                                  data-remove-target="tr" data-alert-target="#paymentsModalAlert"
                                                  data-keep-modal-open="true"
                                                  onsubmit="return confirm('Удалить платёж?');">
                                                @csrf
                                                <input type="hidden" name="payment_id" value="{{ $p->id }}">
                                                <input type="hidden" name="student_id" value="{{ $studentId }}">
                                                <button type="submit" class="btn btn-outline-danger btn-sm py-0 px-1">&times;</button>
                                            </form>
                                        </td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>
                        <div class="text-muted small mt-1" data-finance-totals="payment"></div>
                    @else
                        <p class="text-muted">Платежей нет.</p>
                    @endif

                    @include('students._charges_table', ['charges' => $charges, 'studentId' => $studentId])
                </div>
            </div>
        </div>
    </div>

    <!-- All comments modal -->
    <div class="modal fade" id="commentsModal" tabindex="-1">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Жалобы и похвалы</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    @if ($allComments)
                        <div class="list-group list-group-flush">
                            @foreach ($allComments as $cm)
                                <div class="list-group-item px-0">
                                    <div class="d-flex justify-content-between align-items-start">
                                        <span class="badge bg-secondary me-2">{{ $cm->category_name }}</span>
                                    </div>
                                    <p class="mb-0 mt-1 small">{{ $cm->custom_text ?: $cm->text }}</p>
                                </div>
                            @endforeach
                        </div>
                    @else
                        <p class="text-muted">Записей нет.</p>
                    @endif
                </div>
            </div>
        </div>
    </div>
@endif

<!-- Edit responsibles -->
@if (in_array($role, ['admin'], true))
    <div class="modal fade" id="editResponsiblesModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content">
                <form method="post" action="/update_responsibles.php">
                    @csrf
                    <div class="modal-header">
                        <h5 class="modal-title">Редактировать ответственных</h5>
                        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                    </div>
                    <div class="modal-body">
                        <input type="hidden" name="student_id" value="{{ $studentId }}">
                        <div class="mb-3">
                            <label class="form-label">Менеджер</label>
                            <select name="manager_id" class="form-select">
                                <option value="">—</option>
                                @foreach ($managers as $m)
                                    <option value="{{ $m->id }}" {{ (($responsibles->manager_id ?? null) == $m->id) ? 'selected' : '' }}>
                                        {{ trim($m->name) }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Куратор</label>
                            <select name="curator_id" class="form-select">
                                <option value="">—</option>
                                @foreach ($curators as $c)
                                    <option value="{{ $c->id }}" {{ (($responsibles->curator_id ?? null) == $c->id) ? 'selected' : '' }}>
                                        {{ trim($c->name) }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                        <button type="submit" class="btn btn-primary">Сохранить</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
@endif

<!-- Edit student -->
<div class="modal fade" id="editStudentModal" tabindex="-1">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <form action="/update_student.php" method="POST">
                @csrf
                <div class="modal-header">
                    <h5 class="modal-title">Редактировать данные ученика</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <input type="hidden" name="student_id" value="{{ $studentId }}">
                    <div class="row g-3">
                        <div class="col-md-4">
                            <label class="form-label">Фамилия</label>
                            <input type="text" name="last_name" class="form-control"
                                   value="{{ $studentInfo->last_name }}" required>
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">Имя</label>
                            <input type="text" name="first_name" class="form-control"
                                   value="{{ $studentInfo->first_name }}" required>
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">Отчество</label>
                            <input type="text" name="middle_name" class="form-control"
                                   value="{{ $studentInfo->middle_name ?? '' }}">
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">Телефон</label>
                            <input type="text" name="phone" class="form-control"
                                   value="{{ $studentInfo->phone ?? '' }}">
                        </div>
                        @if (\App\Support\Modules::enabled('student_iin'))
                            <div class="col-md-4">
                                <label class="form-label">ИИН</label>
                                <input type="text" name="iin" class="form-control" maxlength="12" inputmode="numeric" pattern="\d{12}"
                                       value="{{ $studentInfo->iin ?? '' }}">
                            </div>
                        @endif
                        @if (\App\Support\Modules::enabled('student_agreement_number'))
                            <div class="col-md-4">
                                <label class="form-label">Номер договора</label>
                                <input type="text" name="agreement_number" class="form-control" maxlength="50"
                                       value="{{ $studentInfo->agreement_number ?? '' }}">
                            </div>
                        @endif
                        <div class="col-md-8">
                            <label class="form-label">Цель</label>
                            <textarea name="goal" class="form-control" rows="2" maxlength="500">{{ $studentInfo->goal ?? '' }}</textarea>
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">Класс</label>
                            <select name="class_id" class="form-select">
                                <option value="">—</option>
                                @foreach ($classes as $class)
                                    <option value="{{ $class->id }}" {{ ($studentInfo->class_id == $class->id) ? 'selected' : '' }}>
                                        {{ $class->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">Язык обучения</label>
                            <select name="language_id" class="form-select">
                                <option value="">—</option>
                                @foreach ($languages as $lang)
                                    <option value="{{ $lang->id }}" {{ ($studentInfo->language_id == $lang->id) ? 'selected' : '' }}>
                                        {{ $lang->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">Тип обучения</label>
                            <select name="learning_type_id" class="form-select">
                                <option value="">—</option>
                                @foreach ($learningTypes as $lt)
                                    <option value="{{ $lt->id }}" {{ ($studentInfo->learning_type_id == $lt->id) ? 'selected' : '' }}>
                                        {{ $lt->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">Статус</label>
                            <select name="status_id" class="form-select">
                                <option value="">—</option>
                                @foreach ($allStatuses as $st)
                                    <option value="{{ $st->id }}" {{ ($studentInfo->status_id == $st->id) ? 'selected' : '' }}>
                                        {{ $st->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-6">
                            <label class="form-label">Имя родителя/агента</label>
                            <input type="text" name="agent_first_name" class="form-control"
                                   value="{{ $studentInfo->agent_first_name ?? '' }}">
                        </div>
                        <div class="col-md-6">
                            <label class="form-label">Фамилия родителя/агента</label>
                            <input type="text" name="agent_last_name" class="form-control"
                                   value="{{ $studentInfo->agent_last_name ?? '' }}">
                        </div>
                        <div class="col-md-6">
                            <label class="form-label">Телефон родителя/агента</label>
                            <input type="text" name="agent_phone_number" class="form-control"
                                   value="{{ $studentInfo->agent_phone_number ?? '' }}">
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                    <button type="submit" class="btn btn-primary">Сохранить</button>
                </div>
            </form>
        </div>
    </div>
</div>

<!-- Add payment / Add charge -->
@if (in_array($role, ['admin'], true))
    <div class="modal fade" id="addPaymentModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Внести оплату</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <form action="/add_payment.php" method="POST">
                        @csrf
                        <input type="hidden" name="student_id" value="{{ $studentId }}">
                        <div class="mb-3">
                            <label class="form-label">Сумма <span class="text-danger">*</span></label>
                            <input type="number" name="amount" class="form-control"
                                   min="0" step="0.01" placeholder="50000" required>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Дата платежа <span class="text-danger">*</span></label>
                            <input type="date" name="payment_date" class="form-control"
                                   value="{{ date('Y-m-d') }}" required>
                        </div>
                        <div class="mb-3 row g-2">
                            <div class="col">
                                <label class="form-label">Период с</label>
                                <input type="date" name="start_date" class="form-control">
                            </div>
                            <div class="col">
                                <label class="form-label">Период по</label>
                                <input type="date" name="end_date" class="form-control">
                            </div>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Описание</label>
                            <input type="text" name="description" class="form-control"
                                   placeholder="Оплата за май, наличные...">
                        </div>
                        <div class="modal-footer px-0 pb-0">
                            <button type="submit" class="btn btn-success">Сохранить</button>
                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="addChargeModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Добавить начисление</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <div id="addChargeAlert"></div>
                    <form id="addChargeForm" action="/add_charge.php" method="POST"
                          class="js-ajax-form js-ajax-payment-charge-form"
                          data-replace-target="#chargesTableWrapper" data-alert-target="#addChargeAlert">
                        @csrf
                        <input type="hidden" name="student_id" value="{{ $studentId }}">
                        <div class="mb-3">
                            <label class="form-label">Сумма <span class="text-danger">*</span></label>
                            <input type="number" name="amount" class="form-control"
                                   min="0" step="0.01" placeholder="5000" required>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Дата начисления <span class="text-danger">*</span></label>
                            <input type="date" name="charged_date" class="form-control"
                                   value="{{ date('Y-m-d') }}" required>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Описание</label>
                            <input type="text" name="description" class="form-control"
                                   placeholder="Учебные материалы, пересдача теста...">
                        </div>
                        <div class="modal-footer px-0 pb-0">
                            <button type="submit" class="btn btn-danger">Сохранить</button>
                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
@endif

@if (in_array($role, ['admin'], true))
    <div class="modal fade" id="addToGroupModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Добавить в группу</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <form action="/add_student_to_group_from_profile.php" method="POST">
                        @csrf
                        <input type="hidden" name="student_id" value="{{ $studentId }}">
                        <div class="mb-3">
                            <label class="form-label">Группа</label>
                            <select name="group_id" class="form-select" required>
                                <option value="">— Выберите группу —</option>
                                @foreach ($groups as $g)
                                    <option value="{{ $g->id }}">{{ $g->group_name }} — {{ $g->teacher_name ?? 'без преподавателя' }}{{ $g->schedule_time ? ', '.$g->schedule_time : '' }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Дата начала</label>
                            <input type="date" name="joined_at" class="form-control" value="{{ date('Y-m-d') }}" required>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Дата окончания (необязательно)</label>
                            <input type="date" name="end_date" class="form-control">
                        </div>
                        <div class="mb-3">
                            <button type="submit" class="btn btn-primary">Сохранить</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
@endif

<!-- Tariff modals (from group card) -->
@if (in_array($role, ['admin'], true))
    <div class="modal fade" id="addTariffFromGroupModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Назначить индивидуальный тариф</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <form action="/add_student_tariff.php" method="POST">
                        @csrf
                        <input type="hidden" name="student_id" value="{{ $studentId }}">
                        <input type="hidden" name="group_id" id="atfg-group-id">
                        <div class="mb-3">
                            <label class="form-label">Тариф <span class="text-danger">*</span></label>
                            <select name="tariff_id" id="atfg-tariff-select" class="form-select" required
                                    onchange="fillAtfgDates()">
                                <option value="">— Выберите тариф —</option>
                                @foreach (array_merge($groupTariffOptions, $individualTariffOptions) as $t)
                                    <option value="{{ $t->id }}"
                                            data-duration="{{ $t->duration_days }}"
                                            data-price="{{ $t->price }}"
                                            data-lessons="{{ $t->lessons_count }}">
                                        {{ $t->name }}
                                        ({{ number_format((float) $t->price, 0, ',', ' ') }} &#8376; / {{ $t->lessons_count }} ур.)
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div id="atfg-preview" class="alert alert-info py-2 small mb-3" style="display:none;"></div>
                        <div class="row g-2 mb-3">
                            <div class="col">
                                <label class="form-label">Дата начала <span class="text-danger">*</span></label>
                                <input type="date" name="start_date" id="atfg-start-date"
                                       class="form-control" value="{{ date('Y-m-d') }}" required
                                       onchange="fillAtfgDates()">
                            </div>
                            <div class="col">
                                <label class="form-label">Дата окончания <span class="text-danger">*</span></label>
                                <input type="date" name="end_date" id="atfg-end-date" class="form-control" required>
                            </div>
                        </div>
                        <div class="modal-footer px-0 pb-0">
                            <button type="submit" class="btn btn-primary">Сохранить</button>
                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="editTariffFromGroupModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Редактировать индивидуальный тариф</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <form action="/edit_student_tariff.php" method="POST">
                        @csrf
                        <input type="hidden" name="student_id" value="{{ $studentId }}">
                        <input type="hidden" name="student_tariff_id" id="etfg-st-id">
                        <input type="hidden" name="group_id" id="etfg-group-id">
                        <div class="mb-3">
                            <label class="form-label">Тариф <span class="text-danger">*</span></label>
                            <select name="tariff_id" id="etfg-tariff-select" class="form-select" required
                                    onchange="fillEtfgDates()">
                                <option value="">— Выберите тариф —</option>
                                @foreach (array_merge($groupTariffOptions, $individualTariffOptions) as $t)
                                    <option value="{{ $t->id }}"
                                            data-duration="{{ $t->duration_days }}"
                                            data-price="{{ $t->price }}"
                                            data-lessons="{{ $t->lessons_count }}">
                                        {{ $t->name }}
                                        ({{ number_format((float) $t->price, 0, ',', ' ') }} &#8376; / {{ $t->lessons_count }} ур.)
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div id="etfg-preview" class="alert alert-info py-2 small mb-3" style="display:none;"></div>
                        <div class="row g-2 mb-3">
                            <div class="col">
                                <label class="form-label">Дата начала <span class="text-danger">*</span></label>
                                <input type="date" name="start_date" id="etfg-start-date"
                                       class="form-control" required onchange="fillEtfgDates()">
                            </div>
                            <div class="col">
                                <label class="form-label">Дата окончания <span class="text-danger">*</span></label>
                                <input type="date" name="end_date" id="etfg-end-date" class="form-control" required>
                            </div>
                        </div>
                        <div class="modal-footer px-0 pb-0">
                            <button type="submit" class="btn btn-primary">Сохранить</button>
                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="editGeneralTariffModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Групповой тариф</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <form action="/update_student_general_tariff.php" method="POST">
                        @csrf
                        <input type="hidden" name="student_id" value="{{ $studentId }}">
                        <div class="mb-3">
                            <label class="form-label">Тариф</label>
                            <select name="tariff_id" id="egt-tariff-select" class="form-select">
                                <option value="">— Без группового тарифа —</option>
                                @foreach ($groupTariffOptions as $t)
                                    <option value="{{ $t->id }}">
                                        {{ $t->name }}
                                        ({{ number_format((float) $t->price, 0, ',', ' ') }} &#8376;
                                        @if ($studentInfo->discount_percent > 0)
                                            &rarr; {{ number_format((float) $t->price * (1 - $studentInfo->discount_percent / 100), 0, ',', ' ') }} &#8376;
                                        @endif
                                        / {{ $t->lessons_count }} ур.)
                                    </option>
                                @endforeach
                            </select>
                            <div class="form-text">Используется как тариф по умолчанию для групповых занятий студента, пока для группы не назначен свой тариф.</div>
                        </div>
                        <div class="modal-footer px-0 pb-0">
                            <button type="submit" class="btn btn-primary">Сохранить</button>
                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="editIndividualTariffModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Индивидуальный тариф</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <form action="/update_student_individual_tariff.php" method="POST">
                        @csrf
                        <input type="hidden" name="student_id" value="{{ $studentId }}">
                        <div class="mb-3">
                            <label class="form-label">Тариф</label>
                            <select name="tariff_id" id="eit-tariff-select" class="form-select">
                                <option value="">— Без индивидуального тарифа —</option>
                                @foreach ($individualTariffOptions as $t)
                                    <option value="{{ $t->id }}">
                                        {{ $t->name }}
                                        ({{ number_format((float) $t->price, 0, ',', ' ') }} &#8376;
                                        @if ($studentInfo->discount_percent > 0)
                                            &rarr; {{ number_format((float) $t->price * (1 - $studentInfo->discount_percent / 100), 0, ',', ' ') }} &#8376;
                                        @endif
                                        / {{ $t->lessons_count }} ур.)
                                    </option>
                                @endforeach
                            </select>
                            <div class="form-text">Используется как тариф по умолчанию для индивидуальных занятий студента, пока для группы не назначен свой тариф.</div>
                        </div>
                        <div class="modal-footer px-0 pb-0">
                            <button type="submit" class="btn btn-primary">Сохранить</button>
                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Отмена</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
@endif

@endsection

@push('scripts')
<script>
    const studentDiscountPercent = {{ (int) $studentInfo->discount_percent }};

    document.addEventListener('DOMContentLoaded', () => {
        const tooltipEls = document.querySelectorAll('[data-bs-toggle="tooltip"]');
        tooltipEls.forEach(el => {
            new bootstrap.Tooltip(el, { trigger: 'click', html: true, placement: 'top' });
            el.addEventListener('click', e => { e.preventDefault(); e.stopPropagation(); });
        });
        document.addEventListener('click', () => {
            tooltipEls.forEach(el => bootstrap.Tooltip.getInstance(el)?.hide());
        });

        const groupMonths = {};
        document.querySelectorAll('.month-lessons').forEach(el => {
            const raw = el.id.slice('month-'.length);
            const last2 = raw.lastIndexOf('-', raw.lastIndexOf('-') - 1);
            const uid = raw.slice(0, last2);
            const month = raw.slice(last2 + 1);
            (groupMonths[uid] ??= []).push(month);
        });

        const currentMonthKey = new Date().toISOString().slice(0, 7);
        for (const uid in groupMonths) {
            groupMonths[uid].sort();
            const idx = groupMonths[uid].indexOf(currentMonthKey);
            showMonth(uid, idx !== -1 ? idx : 0);
        }

        // Payment/charge add/delete forms use the shared .js-ajax-form handler
        // (layouts/app.blade.php); this just patches the Финансы card's numbers from the
        // balance the server recomputed. Delegated on document (not bound per-form) because
        // add_charge.php's success handler swaps in a freshly server-rendered charges table
        // (#chargesTableWrapper) — per-element listeners on the old rows would be gone after
        // that replace, same reason the dictionaries page's row actions don't need rebinding.
        document.addEventListener('ajax-form:success', function (e) {
            if (!(e.target instanceof HTMLFormElement) || !e.target.classList.contains('js-ajax-payment-charge-form')) {
                return;
            }

            if (e.target.id === 'addChargeForm') {
                e.target.reset();
            }

            const balance = e.detail.balance;
            if (!balance) return;

            const totalPaidEl = document.getElementById('totalPaidValue');
            if (totalPaidEl) {
                totalPaidEl.textContent = balance.total_paid.toLocaleString('ru', { maximumFractionDigits: 0 }) + ' ₸';
            }

            const annualDebtEl = document.getElementById('annualDebtValue');
            if (annualDebtEl) {
                annualDebtEl.textContent = Math.abs(balance.annual_debt).toLocaleString('ru', { maximumFractionDigits: 0 }) + ' ₸';
                annualDebtEl.classList.toggle('ax-metric-value--danger', balance.annual_debt_positive);
                annualDebtEl.classList.toggle('ax-metric-value--success', !balance.annual_debt_positive);
            }

            const payStatusEl = document.getElementById('payStatusBadge');
            if (payStatusEl) {
                payStatusEl.textContent = balance.pay_status_label;
                payStatusEl.className = 'badge bg-' + balance.pay_status_class;
            }
        });

        // Финансы modal: both tables now render the student's whole history (payments never
        // had a cap; charges lost their LIMIT 30), so this narrows them by year and shows the
        // count/sum of what's visible. Rebuilt on ajax-form:success too, because adding or
        // deleting a row can add or drop a year — and add_charge.php replaces the entire
        // #chargesTableWrapper, taking its rows with it.
        const financeYearFilter = document.getElementById('financeYearFilter');

        function applyFinanceFilter() {
            if (!financeYearFilter) return;

            const year = financeYearFilter.value;
            const totals = { payment: { count: 0, sum: 0, total: 0 }, charge: { count: 0, sum: 0, total: 0 } };

            document.querySelectorAll('#paymentsModal tr[data-finance-row]').forEach(function (row) {
                const bucket = totals[row.dataset.financeRow];
                const visible = !year || row.dataset.year === year;
                row.style.display = visible ? '' : 'none';
                if (!bucket) return;

                bucket.total++;
                if (!visible) return;
                bucket.count++;
                bucket.sum += parseFloat(row.dataset.amount) || 0;
            });

            document.querySelectorAll('#paymentsModal [data-finance-totals]').forEach(function (el) {
                const bucket = totals[el.dataset.financeTotals];
                if (!bucket) return;
                const label = year ? 'за ' + year : 'за всё время';
                el.textContent = 'Показано: ' + bucket.count + ' — '
                    + bucket.sum.toLocaleString('ru', { maximumFractionDigits: 0 }) + ' ₸ ' + label;
            });

            // The server-rendered "(всего N)" in each heading would go stale after a delete,
            // which removes the row without re-rendering the table.
            document.querySelectorAll('#paymentsModal [data-finance-count]').forEach(function (el) {
                const bucket = totals[el.dataset.financeCount];
                if (bucket) el.textContent = '(всего ' + bucket.total + ')';
            });
        }

        function rebuildFinanceYears() {
            if (!financeYearFilter) return;

            const years = new Set();
            document.querySelectorAll('#paymentsModal tr[data-finance-row]').forEach(function (row) {
                if (row.dataset.year) years.add(row.dataset.year);
            });

            const previous = financeYearFilter.value;
            financeYearFilter.innerHTML = '<option value="">Все годы</option>';
            Array.from(years).sort().reverse().forEach(function (year) {
                const option = document.createElement('option');
                option.value = year;
                option.textContent = year;
                financeYearFilter.appendChild(option);
            });
            // Falls back to "Все годы" when the selected year no longer has any rows.
            financeYearFilter.value = years.has(previous) ? previous : '';

            applyFinanceFilter();
        }

        if (financeYearFilter) {
            financeYearFilter.addEventListener('change', applyFinanceFilter);
            rebuildFinanceYears();

            document.addEventListener('ajax-form:success', function (e) {
                if (!(e.target instanceof HTMLFormElement) || !e.target.classList.contains('js-ajax-payment-charge-form')) {
                    return;
                }
                // The shared handler dispatches this event BEFORE it removes the deleted row
                // / swaps in the new charges table (see layouts/app.blade.php for why), so
                // counting rows right here would count the pre-change DOM.
                setTimeout(rebuildFinanceYears, 0);
            });
        }

        const changeStatusSelect = document.getElementById('changeStatusSelect');
        const changeStatusReasonWrap = document.getElementById('changeStatusReasonWrap');
        const notStudyingStatusId = {{ (int) $notStudyingStatusId }};
        if (changeStatusSelect && changeStatusReasonWrap) {
            changeStatusSelect.addEventListener('change', function () {
                changeStatusReasonWrap.classList.toggle('d-none', Number(this.value) !== notStudyingStatusId);
            });
        }

        let currentLessonId = null;
        let currentBlock = null;
        const studentId = {{ $studentId }};
        const statusColors = { attended: '#28a745', paid_absence: '#dc3545', free_absence: '#007bff' };

        document.querySelectorAll('.lesson-block').forEach(block => {
            block.addEventListener('click', function () {
                currentLessonId = this.dataset.lessonId;
                currentBlock = this;
                document.getElementById('modalLessonDate').textContent = 'Урок от ' + this.dataset.date;
                document.getElementById('modalLessonFrozen').classList.toggle('d-none', !this.dataset.frozen);
                document.getElementById('modalLessonKr').textContent = this.dataset.kr || '—';
                document.getElementById('modalLessonDz').textContent = this.dataset.dz || '—';
                document.getElementById('modalLessonLateness').textContent = this.dataset.lateness || '—';
                document.getElementById('modalLessonComments').textContent = this.dataset.comments || '—';
                document.getElementById('modalStatusSelect').value = this.dataset.status;
                new bootstrap.Modal(document.getElementById('lessonStatusModal')).show();
            });
        });

        document.getElementById('saveLessonStatusBtn').addEventListener('click', () => {
            const newStatus = document.getElementById('modalStatusSelect').value;
            fetch('/update_student_lesson_status.php', {
                method: 'POST',
                headers: {
                    'Content-Type': 'application/json',
                    'X-CSRF-TOKEN': document.querySelector('meta[name="csrf-token"]').content
                },
                body: JSON.stringify({ lesson_id: currentLessonId, student_id: studentId, status: newStatus }),
            })
                .then(r => r.json())
                .then(data => {
                    if (data.success) {
                        currentBlock.dataset.status = newStatus;
                        currentBlock.style.backgroundColor = statusColors[newStatus];
                        bootstrap.Modal.getInstance(document.getElementById('lessonStatusModal')).hide();
                    } else {
                        alert('Ошибка: ' + data.message);
                    }
                })
                .catch(() => alert('Ошибка соединения'));
        });
    });

    function showMonth(uid, index) {
        const months = (window._gm ??= {})[uid] ?? (() => {
            const m = [];
            document.querySelectorAll(`.month-lessons[id^="month-${uid}-"]`).forEach(el => {
                m.push(el.id.slice(`month-${uid}-`.length));
            });
            m.sort();
            return (window._gm[uid] = m);
        })();

        if (!months.length || index < 0 || index >= months.length) return;
        months.forEach((month, i) => {
            const el = document.getElementById(`month-${uid}-${month}`);
            if (el) el.style.display = i === index ? 'block' : 'none';
        });
        const label = document.getElementById(`month-label-${uid}`);
        if (label) {
            const [year, month] = months[index].split('-');
            label.textContent = new Date(`${year}-${month}-01`).toLocaleString('ru-RU', { month: 'long', year: 'numeric' });
            label.dataset.currentIndex = index;
        }
    }

    function changeMonth(uid, step) {
        const label = document.getElementById(`month-label-${uid}`);
        showMonth(uid, parseInt(label?.dataset.currentIndex ?? 0) + step);
    }

    function openEditGeneralTariffModal(tariffId) {
        document.getElementById('egt-tariff-select').value = tariffId || '';
        new bootstrap.Modal(document.getElementById('editGeneralTariffModal')).show();
    }

    function openEditIndividualTariffModal(tariffId) {
        document.getElementById('eit-tariff-select').value = tariffId || '';
        new bootstrap.Modal(document.getElementById('editIndividualTariffModal')).show();
    }

    function openAddTariffModal(groupId) {
        document.getElementById('atfg-group-id').value = groupId;
        document.getElementById('atfg-tariff-select').value = '';
        document.getElementById('atfg-preview').style.display = 'none';
        document.getElementById('atfg-start-date').value = new Date().toISOString().split('T')[0];
        document.getElementById('atfg-end-date').value = '';
        new bootstrap.Modal(document.getElementById('addTariffFromGroupModal')).show();
    }

    function openEditTariffModal(stId, groupId, name, price, lessons, startDate, endDate) {
        document.getElementById('etfg-st-id').value = stId;
        document.getElementById('etfg-group-id').value = groupId;
        document.getElementById('etfg-start-date').value = startDate;
        document.getElementById('etfg-end-date').value = endDate;
        const sel = document.getElementById('etfg-tariff-select');
        let matched = false;
        for (const opt of sel.options) {
            if (parseFloat(opt.dataset.price) === price && parseInt(opt.dataset.lessons) === lessons) {
                sel.value = opt.value;
                matched = true;
                break;
            }
        }
        if (!matched) sel.value = '';
        fillEtfgDates();
        new bootstrap.Modal(document.getElementById('editTariffFromGroupModal')).show();
    }

    function fillAtfgDates() {
        _fillTariffDates('atfg-tariff-select', 'atfg-start-date', 'atfg-end-date', 'atfg-preview');
    }
    function fillEtfgDates() {
        _fillTariffDates('etfg-tariff-select', 'etfg-start-date', 'etfg-end-date', 'etfg-preview');
    }
    function _fillTariffDates(selId, startId, endId, previewId) {
        const sel = document.getElementById(selId);
        const startIn = document.getElementById(startId);
        const endIn = document.getElementById(endId);
        const preview = document.getElementById(previewId);
        const opt = sel.options[sel.selectedIndex];
        const duration = parseInt(opt?.dataset?.duration ?? 0);
        const price = opt?.dataset?.price;
        const lessons = opt?.dataset?.lessons;

        if (duration > 0 && startIn.value) {
            const d = new Date(startIn.value);
            d.setDate(d.getDate() + duration - 1);
            endIn.value = d.toISOString().split('T')[0];
        }
        if (price && lessons && duration) {
            const discounted = studentDiscountPercent > 0
                ? (parseFloat(price) * (1 - studentDiscountPercent / 100))
                : null;
            const priceHtml = discounted !== null
                ? `<s>${parseFloat(price).toLocaleString('ru')} ₸</s> ${discounted.toLocaleString('ru', {maximumFractionDigits: 0})} ₸ (-${studentDiscountPercent}%)`
                : `${parseFloat(price).toLocaleString('ru')} ₸`;
            const perLessonBase = discounted ?? parseFloat(price);

            preview.style.display = 'block';
            preview.innerHTML =
                `<strong>Цена:</strong> ${priceHtml} &nbsp;|&nbsp;` +
                `<strong>Уроков:</strong> ${lessons} &nbsp;|&nbsp;` +
                `<strong>За урок:</strong> ${(perLessonBase/parseInt(lessons)).toFixed(0)} ₸ &nbsp;|&nbsp;` +
                `<strong>Длительность:</strong> ${duration} дн.`;
        } else {
            preview.style.display = 'none';
        }
    }
</script>
@endpush