@extends('layouts.app')
@section('title', __('home.app_patch_update'))

@section('css')
<style>
    .apu-pro {
        --apu-surface: #ffffff;
        --apu-border: rgba(15, 23, 42, 0.08);
        --apu-text: #0f172a;
        --apu-muted: #64748b;
        --apu-accent: #4f46e5;
        --apu-accent-2: #059669;
        --apu-danger: #dc2626;
        --apu-radius: 16px;
        --apu-shadow: 0 1px 2px rgba(15, 23, 42, 0.04), 0 4px 24px -4px rgba(15, 23, 42, 0.08);
        min-height: calc(100vh - 120px);
        position: relative;
        isolation: isolate;
    }
    .apu-pro__ambient {
        position: fixed;
        inset: 0;
        z-index: 0;
        pointer-events: none;
        background:
            radial-gradient(1000px 500px at 8% -8%, rgba(79, 70, 229, 0.12), transparent 55%),
            radial-gradient(800px 400px at 92% 0%, rgba(5, 150, 105, 0.08), transparent 50%),
            linear-gradient(180deg, #f1f5f9 0%, #f8fafc 45%, #f1f5f9 100%);
    }
    .apu-pro__wrap {
        position: relative;
        z-index: 1;
        max-width: 920px;
        margin-inline: auto;
        padding: 1.5rem 1rem 3rem;
    }
    @media (min-width: 768px) {
        .apu-pro__wrap { padding: 2rem 1.5rem 4rem; }
    }
    .apu-pro__crumb {
        display: inline-flex;
        align-items: center;
        gap: 0.5rem;
        margin-bottom: 1.25rem;
        font-size: 0.8125rem;
        font-weight: 500;
        color: var(--apu-muted);
    }
    .apu-pro__crumb a {
        color: var(--apu-accent);
        text-decoration: none;
    }
    .apu-pro__crumb a:hover { text-decoration: underline; }
    .apu-pro__hero {
        border-radius: var(--apu-radius);
        border: 1px solid var(--apu-border);
        background: var(--apu-surface);
        box-shadow: var(--apu-shadow);
        overflow: hidden;
        margin-bottom: 1.5rem;
    }
    .apu-pro__hero-accent {
        height: 4px;
        background: linear-gradient(90deg, #4f46e5, #059669);
    }
    .apu-pro__hero-body { padding: 1.5rem 1.25rem 1.75rem; }
    @media (min-width: 640px) {
        .apu-pro__hero-body { padding: 1.75rem 1.75rem 2rem; }
    }
    .apu-pro__eyebrow {
        font-size: 0.6875rem;
        font-weight: 700;
        letter-spacing: 0.12em;
        text-transform: uppercase;
        color: var(--apu-accent);
        margin: 0 0 0.5rem;
    }
    .apu-pro__title {
        font-size: 1.5rem;
        font-weight: 700;
        color: var(--apu-text);
        margin: 0 0 0.5rem;
        line-height: 1.2;
    }
    @media (min-width: 640px) {
        .apu-pro__title { font-size: 1.75rem; }
    }
    .apu-pro__lead {
        margin: 0;
        color: var(--apu-muted);
        font-size: 0.9375rem;
        line-height: 1.55;
        max-width: 52rem;
    }
    .apu-pro__panel {
        border-radius: var(--apu-radius);
        border: 1px solid var(--apu-border);
        background: var(--apu-surface);
        box-shadow: var(--apu-shadow);
        padding: 1.25rem 1.25rem 1.5rem;
    }
    @media (min-width: 640px) {
        .apu-pro__panel { padding: 1.5rem; }
    }
    .apu-pro__label {
        display: block;
        font-size: 0.875rem;
        font-weight: 600;
        color: var(--apu-text);
        margin-bottom: 0.5rem;
    }
    .apu-pro__file-row {
        display: flex;
        flex-wrap: wrap;
        align-items: center;
        gap: 0.75rem;
    }
    .apu-pro__file-input {
        position: absolute;
        width: 0.1px;
        height: 0.1px;
        opacity: 0;
        overflow: hidden;
        z-index: -1;
    }
    .apu-pro__file-btn {
        display: inline-flex;
        align-items: center;
        justify-content: center;
        padding: 0.5rem 1rem;
        font-size: 0.875rem;
        font-weight: 600;
        color: #fff;
        background: var(--apu-accent);
        border: none;
        border-radius: 10px;
        cursor: pointer;
        transition: filter 0.15s ease, transform 0.1s ease;
    }
    .apu-pro__file-btn:hover { filter: brightness(1.05); }
    .apu-pro__file-btn:focus-visible {
        outline: 2px solid var(--apu-accent);
        outline-offset: 2px;
    }
    .apu-pro__file-name {
        font-size: 0.8125rem;
        color: var(--apu-muted);
        word-break: break-all;
    }
    .apu-pro__hint {
        font-size: 0.8125rem;
        color: var(--apu-muted);
        margin: 0.75rem 0 0;
    }
    .apu-pro__actions {
        display: flex;
        flex-wrap: wrap;
        gap: 0.75rem;
        margin-top: 1.25rem;
    }
    .apu-pro__btn-primary {
        display: inline-flex;
        align-items: center;
        gap: 0.5rem;
        padding: 0.625rem 1.25rem;
        font-size: 0.875rem;
        font-weight: 600;
        color: #fff;
        background: linear-gradient(135deg, #4f46e5, #4338ca);
        border: none;
        border-radius: 10px;
        cursor: pointer;
        transition: opacity 0.15s ease, transform 0.1s ease;
    }
    .apu-pro__btn-primary:disabled {
        opacity: 0.55;
        cursor: not-allowed;
    }
    .apu-pro__btn-primary:not(:disabled):hover { filter: brightness(1.06); }
    .apu-pro__btn-ghost {
        padding: 0.625rem 1rem;
        font-size: 0.875rem;
        font-weight: 600;
        color: var(--apu-muted);
        background: transparent;
        border: 1px solid var(--apu-border);
        border-radius: 10px;
        cursor: pointer;
    }
    .apu-pro__btn-ghost:hover {
        border-color: rgba(15, 23, 42, 0.15);
        color: var(--apu-text);
    }
    .apu-pro__progress-wrap {
        margin-top: 1.5rem;
        display: none;
    }
    .apu-pro__progress-wrap.is-visible { display: block; }
    .apu-pro__progress-head {
        display: flex;
        justify-content: space-between;
        align-items: center;
        margin-bottom: 0.5rem;
        font-size: 0.8125rem;
        font-weight: 600;
        color: var(--apu-text);
    }
    .apu-pro__progress-pct { color: var(--apu-accent); font-variant-numeric: tabular-nums; }
    .apu-pro__progress-track {
        height: 10px;
        border-radius: 999px;
        background: rgba(15, 23, 42, 0.06);
        overflow: hidden;
    }
    .apu-pro__progress-bar {
        height: 100%;
        width: 0%;
        border-radius: 999px;
        background: linear-gradient(90deg, #4f46e5, #059669);
        transition: width 0.25s ease;
    }
    .apu-pro__progress-bar.is-indeterminate {
        width: 35% !important;
        animation: apu-indet 1.2s ease-in-out infinite;
    }
    @keyframes apu-indet {
        0% { transform: translateX(-100%); }
        100% { transform: translateX(280%); }
    }
    .apu-pro__log-section { margin-top: 1.5rem; }
    .apu-pro__log-title {
        font-size: 0.75rem;
        font-weight: 700;
        letter-spacing: 0.08em;
        text-transform: uppercase;
        color: var(--apu-muted);
        margin: 0 0 0.5rem;
    }
    .apu-pro__log {
        font-family: ui-monospace, 'Cascadia Code', 'Source Code Pro', Menlo, Consolas, monospace;
        font-size: 0.75rem;
        line-height: 1.5;
        color: #e2e8f0;
        background: #0f172a;
        border-radius: 12px;
        padding: 1rem 1rem 1rem;
        max-height: 320px;
        overflow: auto;
        white-space: pre-wrap;
        word-break: break-word;
        border: 1px solid rgba(255, 255, 255, 0.06);
    }
    .apu-pro__log-line--err { color: #fca5a5; }
    .apu-pro__log-line--ok { color: #6ee7b7; }
    .apu-pro__alert {
        margin-top: 1rem;
        padding: 0.75rem 1rem;
        border-radius: 10px;
        font-size: 0.875rem;
        display: none;
    }
    .apu-pro__alert.is-visible { display: block; }
    .apu-pro__alert--danger {
        background: rgba(220, 38, 38, 0.08);
        color: var(--apu-danger);
        border: 1px solid rgba(220, 38, 38, 0.2);
    }
    .apu-pro__spinner {
        display: inline-block;
        width: 1rem;
        height: 1rem;
        border: 2px solid rgba(255, 255, 255, 0.35);
        border-top-color: #fff;
        border-radius: 50%;
        animation: apu-spin 0.7s linear infinite;
        vertical-align: -2px;
    }
    @keyframes apu-spin { to { transform: rotate(360deg); } }
    .apu-pro__panel-spaced { margin-top: 1.5rem; }
    .apu-pro__subtitle {
        font-size: 1.125rem;
        font-weight: 700;
        color: var(--apu-text);
        margin: 0 0 0.5rem;
    }
    .apu-pro__form-grid {
        display: grid;
        gap: 1rem;
        margin-top: 1rem;
    }
    @media (min-width: 640px) {
        .apu-pro__form-grid {
            grid-template-columns: 1fr 1fr;
        }
    }
    .apu-pro__field-full { grid-column: 1 / -1; }
    .apu-pro__input {
        width: 100%;
        padding: 0.5rem 0.75rem;
        font-size: 0.875rem;
        border: 1px solid var(--apu-border);
        border-radius: 10px;
        background: #fff;
        color: var(--apu-text);
    }
    .apu-pro__input:focus {
        outline: 2px solid rgba(79, 70, 229, 0.35);
        outline-offset: 1px;
    }
    .apu-pro__alert--success {
        background: rgba(5, 150, 105, 0.08);
        color: #047857;
        border: 1px solid rgba(5, 150, 105, 0.25);
    }
    .apu-pro__current-db {
        display: grid;
        grid-template-columns: auto 1fr;
        gap: 0.25rem 1rem;
        font-size: 0.8125rem;
        margin: 0.75rem 0 0;
        padding: 0.75rem 1rem;
        background: rgba(15, 23, 42, 0.03);
        border-radius: 10px;
        border: 1px solid var(--apu-border);
    }
    .apu-pro__current-db dt { color: var(--apu-muted); font-weight: 500; }
    .apu-pro__current-db dd { margin: 0; color: var(--apu-text); word-break: break-all; }
    .apu-pro__sql-wrap { margin-top: 1rem; }
    .apu-pro__sql {
        width: 100%;
        min-height: 220px;
        padding: 0.75rem 1rem;
        font-family: ui-monospace, Consolas, monospace;
        font-size: 0.8125rem;
        line-height: 1.45;
        border: 1px solid var(--apu-border);
        border-radius: 10px;
        resize: vertical;
        box-sizing: border-box;
        background: #fff;
        color: var(--apu-text);
    }
    .apu-pro__check-row {
        display: flex;
        align-items: flex-start;
        gap: 0.5rem;
        margin-top: 1rem;
        font-size: 0.875rem;
        color: var(--apu-text);
    }
    .apu-pro__check-row input { margin-top: 0.2rem; flex-shrink: 0; }
    .apu-pro__sql-results { margin-top: 1.25rem; }
    .apu-pro__sql-card {
        margin-top: 0.75rem;
        padding: 1rem;
        border-radius: 12px;
        border: 1px solid var(--apu-border);
        background: rgba(15, 23, 42, 0.02);
    }
    .apu-pro__sql-card-title { font-size: 0.8125rem; font-weight: 700; margin: 0 0 0.5rem; color: var(--apu-text); }
    .apu-pro__sql-card pre {
        margin: 0 0 0.75rem;
        font-family: ui-monospace, Consolas, monospace;
        font-size: 0.75rem;
        white-space: pre-wrap;
        word-break: break-word;
        color: var(--apu-muted);
    }
    .apu-pro__sql-table-wrap { overflow: auto; max-width: 100%; }
    .apu-pro__sql-table {
        width: 100%;
        border-collapse: collapse;
        font-size: 0.75rem;
    }
    .apu-pro__sql-table th, .apu-pro__sql-table td {
        border: 1px solid var(--apu-border);
        padding: 0.35rem 0.5rem;
        text-align: start;
        vertical-align: top;
    }
    .apu-pro__sql-table th { background: rgba(15,23,42,.04); font-weight: 600; }
    .apu-pro__warn {
        margin-top: 0.75rem;
        padding: 0.75rem 1rem;
        border-radius: 10px;
        background: rgba(220, 38, 38, 0.06);
        border: 1px solid rgba(220, 38, 38, 0.2);
        color: #991b1b;
        font-size: 0.875rem;
    }
</style>
@endsection

@section('content')
<div class="apu-pro">
    <div class="apu-pro__ambient" aria-hidden="true"></div>
    <div class="apu-pro__wrap">
        <nav class="apu-pro__crumb" aria-label="breadcrumb">
            <a href="{{ action([\App\Http\Controllers\HomeController::class, 'index']) }}">@lang('home.app_patch_update_back')</a>
            <span aria-hidden="true">/</span>
            <span>@lang('home.app_patch_update')</span>
        </nav>

        <header class="apu-pro__hero">
            <div class="apu-pro__hero-accent"></div>
            <div class="apu-pro__hero-body">
                <p class="apu-pro__eyebrow">@lang('home.app_patch_update_eyebrow')</p>
                <h1 class="apu-pro__title">@lang('home.app_patch_update')</h1>
                <p class="apu-pro__lead">@lang('home.app_patch_update_intro')</p>
            </div>
        </header>

        @if (!$hasZip)
            <div class="apu-pro__alert apu-pro__alert--danger is-visible" role="alert">
                @lang('home.app_patch_update_admin_only')
            </div>
        @endif

        <div class="apu-pro__panel">
            <label class="apu-pro__label" for="apu-zip-input">@lang('home.app_patch_update_zip_label')</label>
            <div class="apu-pro__file-row">
                <input type="file" id="apu-zip-input" class="apu-pro__file-input" accept=".zip,application/zip" @if(!$hasZip) disabled @endif>
                <button type="button" class="apu-pro__file-btn" id="apu-zip-trigger" @if(!$hasZip) disabled @endif>@lang('home.app_patch_update_browse')</button>
                <span class="apu-pro__file-name" id="apu-zip-filename">—</span>
            </div>
            <p class="apu-pro__hint">@lang('home.app_patch_update_max', ['mb' => $maxUploadMb])</p>

            <div class="apu-pro__actions">
                <button type="button" class="apu-pro__btn-primary" id="apu-submit" @if(!$hasZip) disabled @endif data-label="@lang('home.app_patch_update_submit')">
                    <span id="apu-submit-label">@lang('home.app_patch_update_submit')</span>
                </button>
                <button type="button" class="apu-pro__btn-ghost" id="apu-clear-log">@lang('home.app_patch_update_reset')</button>
            </div>

            <div class="apu-pro__progress-wrap" id="apu-progress-wrap" aria-live="polite">
                <div class="apu-pro__progress-head">
                    <span id="apu-progress-label">@lang('home.app_patch_update_progress_upload')</span>
                    <span class="apu-pro__progress-pct" id="apu-progress-pct">0%</span>
                </div>
                <div class="apu-pro__progress-track">
                    <div class="apu-pro__progress-bar" id="apu-progress-bar" role="progressbar" aria-valuemin="0" aria-valuemax="100" aria-valuenow="0"></div>
                </div>
            </div>

            <div id="apu-alert" class="apu-pro__alert apu-pro__alert--danger" role="alert"></div>

            <div class="apu-pro__log-section">
                <p class="apu-pro__log-title">@lang('home.app_patch_update_log_title')</p>
                <div class="apu-pro__log" id="apu-log"></div>
            </div>
        </div>

        <div class="apu-pro__panel apu-pro__panel-spaced">
            <h2 class="apu-pro__subtitle">@lang('home.sql_runner_title')</h2>
            <p class="apu-pro__hint" style="margin-top:0">@lang('home.sql_runner_intro')</p>
            <div class="apu-pro__warn" role="alert">@lang('home.sql_runner_warn')</div>

            <p class="apu-pro__label" style="margin-top:1rem;margin-bottom:0.25rem">@lang('home.sql_runner_target')</p>
            <dl class="apu-pro__current-db">
                <dt>@lang('home.sql_runner_driver')</dt><dd>{{ e($sqlDb['driver']) }}</dd>
                <dt>@lang('home.sql_runner_host')</dt><dd>{{ e($sqlDb['host']) }}</dd>
                <dt>@lang('home.sql_runner_port')</dt><dd>{{ e($sqlDb['port']) }}</dd>
                <dt>@lang('home.sql_runner_database')</dt><dd>{{ e($sqlDb['database']) }}</dd>
                <dt>@lang('home.sql_runner_username')</dt><dd>{{ e($sqlDb['username']) }}</dd>
                <dt>@lang('home.sql_runner_password')</dt><dd>{{ $sqlDb['has_password'] ? __('home.sql_runner_password_set') : __('home.sql_runner_password_empty') }}</dd>
                @if(($sqlDb['socket'] ?? '') !== '')
                    <dt>@lang('home.sql_runner_socket')</dt><dd>{{ e($sqlDb['socket']) }}</dd>
                @endif
            </dl>

            <form id="sql-runner-form">
                <div class="apu-pro__sql-wrap">
                    <label class="apu-pro__label" for="sql-runner-text">@lang('home.sql_runner_label_sql')</label>
                    <textarea id="sql-runner-text" name="sql" class="apu-pro__sql" rows="10" placeholder="@lang('home.sql_runner_placeholder')" required></textarea>
                </div>
                <label class="apu-pro__check-row">
                    <input type="checkbox" id="sql-runner-tx" name="use_transaction" value="1">
                    <span>@lang('home.sql_runner_transaction')</span>
                </label>
                <div class="apu-pro__actions">
                    <button type="submit" class="apu-pro__btn-primary" id="sql-runner-submit" data-label="@lang('home.sql_runner_run')">@lang('home.sql_runner_run')</button>
                </div>
            </form>

            <div id="sql-runner-msg" class="apu-pro__alert apu-pro__alert--success" role="status" style="display:none;margin-top:1rem"></div>
            <div id="sql-runner-err" class="apu-pro__alert apu-pro__alert--danger" role="alert" style="display:none;margin-top:1rem"></div>
            <div id="sql-runner-results" class="apu-pro__sql-results" aria-live="polite"></div>
        </div>
    </div>
</div>

@if ($hasZip)
<script>
(function () {
    var applyUrl = @json(route('home.app_patch_update.apply'));
    var csrf = document.querySelector('meta[name="csrf-token"]');
    var token = csrf ? csrf.getAttribute('content') : '';

    var input = document.getElementById('apu-zip-input');
    var trigger = document.getElementById('apu-zip-trigger');
    var filenameEl = document.getElementById('apu-zip-filename');
    var submit = document.getElementById('apu-submit');
    var submitLabel = document.getElementById('apu-submit-label');
    var clearBtn = document.getElementById('apu-clear-log');
    var progressWrap = document.getElementById('apu-progress-wrap');
    var progressLabel = document.getElementById('apu-progress-label');
    var progressPct = document.getElementById('apu-progress-pct');
    var progressBar = document.getElementById('apu-progress-bar');
    var logEl = document.getElementById('apu-log');
    var alertEl = document.getElementById('apu-alert');

    var str = {
        upload: @json(__('home.app_patch_update_progress_upload')),
        apply: @json(__('home.app_patch_update_progress_apply')),
        done: @json(__('home.app_patch_update_progress_done')),
        selectFile: @json(__('home.app_patch_update_select_file')),
        httpError: @json(__('home.app_patch_update_http_error')),
        parseError: @json(__('home.app_patch_update_parse_error'))
    };

    var submitDefault = submit.getAttribute('data-label') || submitLabel.textContent;

    trigger.addEventListener('click', function () { input.click(); });
    input.addEventListener('change', function () {
        filenameEl.textContent = input.files && input.files[0] ? input.files[0].name : '—';
    });

    function setAlert(msg) {
        if (!msg) {
            alertEl.textContent = '';
            alertEl.classList.remove('is-visible');
            return;
        }
        alertEl.textContent = msg;
        alertEl.classList.add('is-visible');
    }

    function appendLog(line, cls) {
        var span = document.createElement('div');
        span.className = cls ? 'apu-pro__log-line ' + cls : '';
        span.textContent = line;
        logEl.appendChild(span);
        logEl.scrollTop = logEl.scrollHeight;
    }

    function setProgress(pct, label, indeterminate) {
        progressWrap.classList.add('is-visible');
        progressLabel.textContent = label;
        var v = Math.max(0, Math.min(100, Math.round(pct)));
        progressPct.textContent = v + '%';
        progressBar.setAttribute('aria-valuenow', String(v));
        if (indeterminate) {
            progressBar.classList.add('is-indeterminate');
            progressBar.style.width = '35%';
        } else {
            progressBar.classList.remove('is-indeterminate');
            progressBar.style.width = v + '%';
        }
    }

    function handlePayload(obj) {
        if (!obj || !obj.type) return;
        if (obj.type === 'log' && obj.line) {
            appendLog(obj.line);
            if (typeof obj.pct === 'number') {
                setProgress(obj.pct, str.apply, false);
            }
        } else if (obj.type === 'error' && obj.message) {
            appendLog(obj.message, 'apu-pro__log-line--err');
            setAlert(obj.message);
            setProgress(typeof obj.pct === 'number' ? obj.pct : 0, str.apply, false);
        } else if (obj.type === 'done') {
            setProgress(100, str.done, false);
            if (obj.success) {
                appendLog(str.done, 'apu-pro__log-line--ok');
            }
        }
    }

    clearBtn.addEventListener('click', function () {
        logEl.innerHTML = '';
        setAlert('');
    });

    submit.addEventListener('click', function () {
        if (!input.files || !input.files[0]) {
            setAlert(str.selectFile);
            return;
        }
        setAlert('');
        logEl.innerHTML = '';
        submit.disabled = true;
        submitLabel.innerHTML = '<span class="apu-pro__spinner"></span> ' + submitDefault;

        var form = new FormData();
        form.append('patch_zip', input.files[0]);
        form.append('_token', token);

        var xhr = new XMLHttpRequest();
        var lineBuf = '';
        var respPos = 0;
        var uploadFinished = false;

        function drainResponse() {
            var full = xhr.responseText;
            var chunk = full.slice(respPos);
            respPos = full.length;
            lineBuf += chunk;
            var parts = lineBuf.split('\n');
            lineBuf = parts.pop() || '';
            parts.forEach(function (raw) {
                var line = raw.trim();
                if (!line) return;
                try {
                    handlePayload(JSON.parse(line));
                } catch (e) { /* incomplete or noise */ }
            });
        }

        xhr.open('POST', applyUrl, true);
        xhr.setRequestHeader('X-Requested-With', 'XMLHttpRequest');
        xhr.setRequestHeader('Accept', 'application/x-ndjson, application/json');

        xhr.upload.addEventListener('progress', function (e) {
            if (!e.lengthComputable) return;
            var upPct = 14 * (e.loaded / e.total);
            setProgress(upPct, str.upload, false);
        });

        xhr.upload.addEventListener('load', function () {
            uploadFinished = true;
            setProgress(14, str.apply, true);
        });

        xhr.onreadystatechange = function () {
            if (xhr.readyState >= 3 && uploadFinished) {
                drainResponse();
            }
            if (xhr.readyState === 4) {
                submit.disabled = false;
                submitLabel.textContent = submitDefault;
                progressBar.classList.remove('is-indeterminate');
                if (xhr.status < 200 || xhr.status >= 300) {
                    setAlert(str.httpError.replace(':status', String(xhr.status)));
                    lineBuf = '';
                    respPos = 0;
                    return;
                }
                drainResponse();
                if (lineBuf.trim()) {
                    try {
                        handlePayload(JSON.parse(lineBuf.trim()));
                    } catch (e2) { /* ignore */ }
                }
                lineBuf = '';
                respPos = 0;
            }
        };

        xhr.send(form);
    });
})();
</script>
@endif

<script>
(function () {
    var sqlUrl = @json(route('home.app_patch_update.run_sql'));
    var csrf = document.querySelector('meta[name="csrf-token"]');
    var token = csrf ? csrf.getAttribute('content') : '';
    var form = document.getElementById('sql-runner-form');
    if (!form) return;

    var submitBtn = document.getElementById('sql-runner-submit');
    var msgOk = document.getElementById('sql-runner-msg');
    var msgErr = document.getElementById('sql-runner-err');
    var resultsEl = document.getElementById('sql-runner-results');
    var txCb = document.getElementById('sql-runner-tx');

    var str = {
        run: @json(__('home.sql_runner_run')),
        running: @json(__('home.sql_runner_running')),
        stmt: @json(__('home.sql_runner_statement')),
        rowsReturned: @json(__('home.sql_runner_rows_returned')),
        affected: @json(__('home.sql_runner_affected')),
        truncated: @json(__('home.sql_runner_truncated')),
        network: @json(__('home.sql_runner_network'))
    };

    function showOk(text) {
        msgErr.style.display = 'none';
        msgOk.textContent = text;
        msgOk.style.display = 'block';
    }
    function showErr(text) {
        msgOk.style.display = 'none';
        msgErr.textContent = text;
        msgErr.style.display = 'block';
    }

    function renderResults(body) {
        resultsEl.innerHTML = '';
        if (!body || !body.results || !body.results.length) return;
        var maxR = body.max_select_rows || 500;
        body.results.forEach(function (r) {
            var card = document.createElement('div');
            card.className = 'apu-pro__sql-card';
            var h = document.createElement('p');
            h.className = 'apu-pro__sql-card-title';
            h.textContent = str.stmt.replace(':n', String(r.index));
            card.appendChild(h);
            var pre = document.createElement('pre');
            pre.textContent = r.preview || '';
            card.appendChild(pre);
            if (r.ok && r.type === 'query') {
                var meta = document.createElement('p');
                meta.style.fontSize = '0.8125rem';
                meta.style.margin = '0 0 0.5rem';
                meta.textContent = str.rowsReturned.replace(':count', String(r.row_count));
                if (r.truncated) {
                    meta.textContent += ' ' + str.truncated.replace(':max', String(maxR));
                }
                card.appendChild(meta);
                if (r.rows && r.rows.length) {
                    var wrap = document.createElement('div');
                    wrap.className = 'apu-pro__sql-table-wrap';
                    var table = document.createElement('table');
                    table.className = 'apu-pro__sql-table';
                    var keys = Object.keys(r.rows[0]);
                    var thead = document.createElement('thead');
                    var trh = document.createElement('tr');
                    keys.forEach(function (k) {
                        var th = document.createElement('th');
                        th.textContent = k;
                        trh.appendChild(th);
                    });
                    thead.appendChild(trh);
                    table.appendChild(thead);
                    var tbody = document.createElement('tbody');
                    r.rows.forEach(function (row) {
                        var tr = document.createElement('tr');
                        keys.forEach(function (k) {
                            var td = document.createElement('td');
                            var v = row[k];
                            td.textContent = v === null || v === undefined ? '' : String(v);
                            tr.appendChild(td);
                        });
                        tbody.appendChild(tr);
                    });
                    table.appendChild(tbody);
                    wrap.appendChild(table);
                    card.appendChild(wrap);
                }
            } else if (r.ok && r.type === 'execute') {
                var p = document.createElement('p');
                p.style.fontSize = '0.8125rem';
                p.style.margin = '0';
                if (r.affected_rows != null) {
                    p.textContent = str.affected.replace(':count', String(r.affected_rows));
                } else {
                    p.textContent = r.note || '';
                }
                card.appendChild(p);
            } else {
                var pe = document.createElement('p');
                pe.style.color = '#dc2626';
                pe.style.fontSize = '0.8125rem';
                pe.textContent = r.error || '';
                card.appendChild(pe);
            }
            resultsEl.appendChild(card);
        });
    }

    form.addEventListener('submit', function (e) {
        e.preventDefault();
        showErr('');
        msgOk.style.display = 'none';
        resultsEl.innerHTML = '';

        var fd = new FormData();
        fd.append('_token', token);
        fd.append('sql', document.getElementById('sql-runner-text').value);
        if (txCb.checked) fd.append('use_transaction', '1');

        var label = submitBtn.getAttribute('data-label') || str.run;
        submitBtn.disabled = true;
        submitBtn.textContent = str.running;

        fetch(sqlUrl, {
            method: 'POST',
            body: fd,
            headers: {
                'X-Requested-With': 'XMLHttpRequest',
                'Accept': 'application/json'
            },
            credentials: 'same-origin'
        }).then(function (r) {
            return r.json().then(function (j) {
                return { ok: r.ok, status: r.status, body: j };
            });
        }).then(function (res) {
            submitBtn.disabled = false;
            submitBtn.textContent = label;
            renderResults(res.body);

            if (res.body && res.body.success) {
                showOk(res.body.message || '');
            } else {
                var err = (res.body && res.body.message) ? res.body.message : ('HTTP ' + res.status);
                if (res.body && res.body.errors) {
                    var first = Object.keys(res.body.errors)[0];
                    if (first && res.body.errors[first] && res.body.errors[first][0]) {
                        err = res.body.errors[first][0];
                    }
                }
                showErr(err);
            }
        }).catch(function () {
            submitBtn.disabled = false;
            submitBtn.textContent = label;
            showErr(str.network);
        });
    });
})();
</script>
@endsection