@extends('layouts.admin')

@php
    $providers = collect();
    $providerEngines = [];
    $dashboardSettings = app(\Pterodactyl\BlueprintFramework\Extensions\betterdatabases\Services\Databases\Providers\DatabaseDashboardSettingsService::class);
    $sqlDashboardSettings = $dashboardSettings->all();
    $redisAllocationsEnabled = $sqlDashboardSettings['redis_allocations_enabled'];

    if (class_exists(\Pterodactyl\BlueprintFramework\Extensions\betterdatabases\Models\DatabaseProvider::class)) {
        $providerEngines = [
            \Pterodactyl\BlueprintFramework\Extensions\betterdatabases\Models\DatabaseProvider::ENGINE_MYSQL => 'MySQL / MariaDB',
            \Pterodactyl\BlueprintFramework\Extensions\betterdatabases\Models\DatabaseProvider::ENGINE_POSTGRESQL => 'PostgreSQL',
            \Pterodactyl\BlueprintFramework\Extensions\betterdatabases\Models\DatabaseProvider::ENGINE_MONGODB => 'MongoDB',
            \Pterodactyl\BlueprintFramework\Extensions\betterdatabases\Models\DatabaseProvider::ENGINE_REDIS => 'Redis',
        ];

        try {
            $providers = \Pterodactyl\BlueprintFramework\Extensions\betterdatabases\Models\DatabaseProvider::query()
                ->with('node')
                ->withCount('allocations')
                ->orderBy('engine')
                ->orderBy('name')
                ->get();
        } catch (\Throwable $exception) {
            $providers = collect();
        }
    }

    $providerRoutesLoaded = \Illuminate\Support\Facades\Route::has('admin.extensions.betterdatabases.post');
    $providerSettingsRouteLoaded = \Illuminate\Support\Facades\Route::has('admin.extensions.betterdatabases.patch');
    $providerStoreAction = route('admin.extensions.betterdatabases.post');
    $panelRedisPassword = config('database.redis.default.password');
    $panelRedisPasswordMissing = $panelRedisPassword === null || $panelRedisPassword === '' || strtolower((string) $panelRedisPassword) === 'null';
    $nativeHostCount = count($hosts);
    $providerCount = $providers->count();
@endphp

@section('title')
    Better Databases
@endsection

@section('content-header')
    <h1>Better Databases<small>Provider setup and SQL dashboard settings.</small></h1>
    <ol class="breadcrumb">
        <li><a href="{{ route('admin.index') }}">Admin</a></li>
        <li class="active">Better Databases</li>
    </ol>
@endsection

@section('content')
<style>
    .bd-page .box { border-top-width: 2px; }
    .bd-status-grid {
        display: grid;
        grid-template-columns: repeat(auto-fit, minmax(320px, 1fr));
        gap: 12px;
        margin-bottom: 18px;
    }
    .bd-status {
        border-left: 3px solid #3c8dbc;
        background: rgba(60, 141, 188, 0.12);
        padding: 12px 14px;
        color: #cfd8df;
    }
    .bd-status-danger {
        border-color: #dd4b39;
        background: rgba(221, 75, 57, 0.14);
    }
    .bd-status-warning {
        border-color: #f39c12;
        background: rgba(243, 156, 18, 0.14);
    }
    .bd-status-title {
        display: block;
        margin-bottom: 3px;
        color: #fff;
        font-weight: 600;
    }
    .bd-status p,
    .bd-help {
        margin: 0;
        color: #aeb9c2;
        line-height: 1.45;
    }
    .bd-settings-grid {
        display: grid;
        grid-template-columns: repeat(auto-fit, minmax(260px, 1fr));
        gap: 12px;
    }
    .bd-toggle {
        display: flex;
        min-height: 74px;
        align-items: center;
        justify-content: space-between;
        gap: 12px;
        margin: 0;
        padding: 12px;
        border: 1px solid rgba(255, 255, 255, 0.08);
        background: rgba(0, 0, 0, 0.12);
        cursor: pointer;
    }
    .bd-toggle strong {
        display: block;
        color: #d8e0e6;
        font-size: 13px;
    }
    .bd-toggle small {
        display: block;
        margin-top: 3px;
        color: #8f9ba5;
        font-weight: 400;
        line-height: 1.35;
    }
    .bd-toggle input[type="checkbox"] {
        display: none;
    }
    .bd-switch {
        position: relative;
        width: 42px;
        height: 22px;
        flex: 0 0 42px;
        border-radius: 20px;
        background: #596774;
        transition: background 160ms ease;
    }
    .bd-switch:after {
        position: absolute;
        top: 3px;
        left: 3px;
        width: 16px;
        height: 16px;
        border-radius: 50%;
        background: #fff;
        content: "";
        transition: transform 160ms ease;
    }
    .bd-toggle input[type="checkbox"]:checked + .bd-switch {
        background: #00a65a;
    }
    .bd-toggle input[type="checkbox"]:checked + .bd-switch:after {
        transform: translateX(20px);
    }
    .bd-box-subtitle {
        margin-left: 8px;
        color: #8f9ba5;
        font-size: 12px;
        font-weight: 400;
    }
    .bd-table-meta {
        display: block;
        margin-top: 4px;
        color: #8f9ba5;
        font-size: 12px;
    }
    .bd-inline-actions {
        display: inline-flex;
        gap: 4px;
        justify-content: flex-end;
    }
    .bd-inline-actions form {
        margin: 0;
    }
    .bd-provider-modal .modal-dialog {
        width: 760px;
        max-width: calc(100% - 30px);
    }
    .bd-wizard-steps {
        display: grid;
        grid-template-columns: repeat(4, 1fr);
        gap: 8px;
        margin-bottom: 18px;
    }
    .bd-wizard-steps button {
        display: flex;
        align-items: center;
        gap: 7px;
        min-height: 38px;
        border: 1px solid rgba(255, 255, 255, 0.08);
        background: rgba(0, 0, 0, 0.12);
        color: #8f9ba5;
        text-align: left;
    }
    .bd-wizard-steps button.active {
        border-color: #3c8dbc;
        background: rgba(60, 141, 188, 0.22);
        color: #fff;
    }
    .bd-wizard-steps span {
        display: inline-flex;
        width: 20px;
        height: 20px;
        align-items: center;
        justify-content: center;
        border-radius: 50%;
        background: rgba(255, 255, 255, 0.12);
        font-size: 12px;
        font-weight: 700;
    }
    .bd-wizard-check {
        display: block;
        min-height: 76px;
        margin-bottom: 15px;
        padding: 12px 14px;
        border: 1px solid rgba(255, 255, 255, 0.08);
        background: rgba(0, 0, 0, 0.12);
        cursor: pointer;
    }
    .bd-wizard-check input {
        margin-right: 8px;
    }
    .bd-wizard-check span {
        color: #d8e0e6;
        font-weight: 600;
    }
    .bd-wizard-check small {
        display: block;
        margin-top: 5px;
        color: #8f9ba5;
        line-height: 1.35;
    }
    .bd-engine-note {
        margin-bottom: 15px;
        padding: 14px;
        border-left: 3px solid #3c8dbc;
        background: rgba(60, 141, 188, 0.14);
    }
    .bd-engine-note-danger {
        border-left-color: #dd4b39;
        background: rgba(221, 75, 57, 0.14);
    }
    .bd-engine-note strong {
        display: block;
        margin-bottom: 4px;
        color: #fff;
    }
    .bd-engine-note p {
        margin: 0;
        color: #c8d2dc;
        line-height: 1.45;
    }
    .bd-engine-grid,
    .bd-review,
    .bd-review-engine {
        display: grid;
        grid-template-columns: repeat(auto-fit, minmax(220px, 1fr));
        gap: 10px;
    }
    .bd-engine-grid > div,
    .bd-review > div,
    .bd-review-engine > div {
        min-height: 58px;
        padding: 11px;
        border: 1px solid rgba(255, 255, 255, 0.08);
        background: rgba(0, 0, 0, 0.12);
    }
    .bd-review span,
    .bd-review-engine span {
        display: block;
        color: #8f9ba5;
        font-size: 12px;
    }
    .bd-review strong,
    .bd-review-engine strong {
        display: block;
        margin-top: 4px;
        color: #d8e0e6;
        overflow-wrap: anywhere;
    }
    [data-engine-copy] {
        display: none;
    }
</style>

<div class="bd-page">
<div class="row">
    <div class="col-xs-12">
        <div class="bd-status-grid">
            @if($panelRedisPasswordMissing)
                <div class="bd-status bd-status-danger">
                    <span class="bd-status-title">Main Redis has no password</span>
                    <p>Set <code>REDIS_PASSWORD</code> and keep port <code>6379</code> private before exposing Redis-related features.</p>
                </div>
            @endif

            <div class="bd-status {{ $redisAllocationsEnabled ? 'bd-status-warning' : '' }}">
                <span class="bd-status-title">Redis allocations are {{ $redisAllocationsEnabled ? 'enabled' : 'disabled' }}</span>
                <p>{{ $redisAllocationsEnabled ? 'Use only with private networking, generated passwords, memory limits, and one Redis process per allocation.' : 'Recommended default. Enable only for trusted infrastructure with isolated Redis allocation processes.' }}</p>
            </div>
        </div>
    </div>
</div>

@if($providerSettingsRouteLoaded)
    <div class="row">
        <div class="col-xs-12">
            <form action="{{ route('admin.extensions.betterdatabases.patch') }}" method="POST">
                {!! csrf_field() !!}
                <input type="hidden" name="_method" value="PATCH" />
                <input type="hidden" name="_section" value="settings" />
                <div class="box box-primary">
                    <div class="box-header with-border">
                        <h3 class="box-title">
                            Feature Gates
                            <span class="bd-box-subtitle">Backend enforced API access</span>
                        </h3>
                    </div>
                    <div class="box-body">
                        <div class="bd-settings-grid">
                            @php
                                $settingToggles = [
                                    'provider_mysql_enabled' => ['MySQL providers', 'Addon-managed MySQL/MariaDB databases.'],
                                    'provider_postgresql_enabled' => ['PostgreSQL providers', 'Isolated PostgreSQL databases and users.'],
                                    'provider_mongodb_enabled' => ['MongoDB providers', 'Isolated MongoDB databases and users.'],
                                    'redis_allocations_enabled' => ['Redis providers', 'Tenant Redis processes. Keep off unless trusted.'],
                                    'raw_sql_enabled' => ['Raw SQL console', 'Manual SQL endpoints for SQL dashboards.'],
                                    'imports_enabled' => ['Imports', 'Upload, preview, chunked, and external imports.'],
                                    'exports_enabled' => ['Exports', 'Full and selective database downloads.'],
                                ];
                            @endphp
                            @foreach($settingToggles as $settingKey => [$settingLabel, $settingHelp])
                                <label class="bd-toggle">
                                    <span>
                                        <strong>{{ $settingLabel }}</strong>
                                        <small>{{ $settingHelp }}</small>
                                    </span>
                                    <input type="hidden" name="{{ $settingKey }}" value="0" />
                                    <input type="checkbox" name="{{ $settingKey }}" value="1" @if($sqlDashboardSettings[$settingKey]) checked @endif />
                                    <span class="bd-switch"></span>
                                </label>
                            @endforeach
                        </div>
                    </div>
                    <div class="box-footer">
                        <span class="bd-help">Disabled features are blocked at the API layer, not only hidden in the frontend.</span>
                        <button type="submit" class="btn btn-sm btn-primary pull-right">Save Settings</button>
                    </div>
                </div>
            </form>
        </div>
    </div>
@endif

<div class="row">
    <div class="col-xs-12">
        <div class="box box-primary">
            <div class="box-header with-border">
                <h3 class="box-title">
                    Connections
                    <span class="bd-box-subtitle">{{ $nativeHostCount }} native, {{ $providerCount }} provider{{ $providerCount === 1 ? '' : 's' }}</span>
                </h3>
                <div class="box-tools">
                    @if($providerRoutesLoaded)
                        <button class="btn btn-sm btn-primary" data-toggle="modal" data-target="#newProviderModal">Add Provider</button>
                    @endif
                </div>
            </div>
            <div class="box-body table-responsive no-padding">
                <table class="table table-hover">
                    <tbody>
                        <tr>
                            <th>Name</th>
                            <th>Endpoint</th>
                            <th style="width: 150px;">Engine</th>
                            <th class="text-center" style="width: 120px;">Scope</th>
                            <th class="text-center" style="width: 120px;">Usage</th>
                            <th class="text-center">Status</th>
                            <th class="text-right">Actions</th>
                        </tr>

                        @foreach ($hosts as $host)
                            <tr>
                                <td>
                                    <a href="{{ route('admin.databases.view', $host->id) }}">{{ $host->name }}</a>
                                    <span class="bd-table-meta">Native host <code>{{ $host->id }}</code></span>
                                </td>
                                <td>
                                    <code>{{ $host->host }}:{{ $host->port }}</code>
                                    <span class="bd-table-meta">User {{ $host->username }}</span>
                                </td>
                                <td><span class="label label-primary">MySQL / MariaDB</span></td>
                                <td class="text-center">
                                    @if(! is_null($host->node))
                                        <a href="{{ route('admin.nodes.view', $host->node->id) }}">{{ $host->node->name }}</a>
                                    @else
                                        <span class="label label-default">None</span>
                                    @endif
                                </td>
                                <td class="text-center">{{ $host->databases_count }}</td>
                                <td class="text-center"><span class="label label-success">Enabled</span></td>
                                <td class="text-right">
                                    <a class="btn btn-xs btn-primary" href="{{ route('admin.databases.view', $host->id) }}">Manage</a>
                                </td>
                            </tr>
                        @endforeach

                        @foreach ($providers as $provider)
                            @php
                                $providerConnectionDatabase = null;
                                $providerConnectionDatabaseLabel = null;

                                if ($provider->engine === \Pterodactyl\BlueprintFramework\Extensions\betterdatabases\Models\DatabaseProvider::ENGINE_MONGODB) {
                                    $providerConnectionDatabase = array_get($provider->options ?? [], 'auth_database') ?: ($provider->database ?: 'admin');
                                    $providerConnectionDatabaseLabel = 'Auth DB';
                                }
                            @endphp
                            <tr>
                                <td>
                                    {{ $provider->name }}
                                    <span class="bd-table-meta">Provider <code>p{{ $provider->id }}</code></span>
                                </td>
                                <td>
                                    <code>{{ $provider->host }}:{{ $provider->port }}</code>
                                    <span class="bd-table-meta">
                                        @if($providerConnectionDatabaseLabel)
                                            {{ $providerConnectionDatabaseLabel }} {{ $providerConnectionDatabase }}
                                        @endif
                                        @if($provider->username)
                                            @if($providerConnectionDatabaseLabel) · @endif User {{ $provider->username }}
                                        @endif
                                        @if($providerConnectionDatabaseLabel || $provider->username) · @endif TLS {{ array_get($provider->options ?? [], 'tls') ? 'on' : 'off' }}
                                    </span>
                                </td>
                                <td>
                                    <span class="label label-info">{{ $providerEngines[$provider->engine] ?? $provider->engine }}</span>
                                    @if(array_get($provider->options ?? [], 'tls'))
                                        <span class="label label-success">TLS</span>
                                    @endif
                                </td>
                                <td class="text-center">
                                    @if(! is_null($provider->node))
                                        <a href="{{ route('admin.nodes.view', $provider->node->id) }}">{{ $provider->node->name }}</a>
                                    @else
                                        <span class="label label-default">Global</span>
                                    @endif
                                </td>
                                <td class="text-center">
                                    @if($provider->engine === \Pterodactyl\BlueprintFramework\Extensions\betterdatabases\Models\DatabaseProvider::ENGINE_REDIS)
                                        @php
                                            $redisOptions = $provider->options ?? [];
                                            $redisStart = array_get($redisOptions, 'redis_port_start');
                                            $redisEnd = array_get($redisOptions, 'redis_port_end');
                                            $redisCapacity = $redisStart && $redisEnd ? ($redisEnd - $redisStart + 1) : 0;
                                            $redisMax = array_get($redisOptions, 'redis_max_instances') ?: $redisCapacity;
                                            $redisUsed = \Pterodactyl\BlueprintFramework\Extensions\betterdatabases\Models\DatabaseProviderAllocation::query()
                                                ->where('database_provider_id', $provider->id)
                                                ->where('engine', \Pterodactyl\BlueprintFramework\Extensions\betterdatabases\Models\DatabaseProvider::ENGINE_REDIS)
                                                ->count();
                                        @endphp
                                        @if($redisStart && $redisEnd)
                                            {{ $redisUsed }} / {{ $redisMax }}
                                            @if(!$redisAllocationsEnabled)
                                                <span class="bd-table-meta"><span class="label label-danger">Global off</span></span>
                                            @endif
                                            @if(empty($redisOptions['redis_enable_allocations']))
                                                <span class="bd-table-meta"><span class="label label-warning">Allocations off</span></span>
                                            @endif
                                        @else
                                            <span class="label label-warning">Range needed</span>
                                        @endif
                                    @else
                                        {{ $provider->allocations_count }}
                                    @endif
                                </td>
                                <td class="text-center">
                                    @if($provider->enabled)
                                        <span class="label label-success">Enabled</span>
                                    @else
                                        <span class="label label-warning">Disabled</span>
                                    @endif
                                </td>
                                <td class="text-right">
                                    @if($providerRoutesLoaded)
                                        <span class="bd-inline-actions">
                                            <button class="btn btn-xs btn-primary" data-toggle="modal" data-target="#providerModal{{ $provider->id }}">Edit</button>
                                            <form action="{{ route('admin.extensions.betterdatabases.delete', ['target' => 'providers', 'id' => $provider->id]) }}" method="POST">
                                                {!! csrf_field() !!}
                                                <input type="hidden" name="_method" value="DELETE" />
                                                <button class="btn btn-xs btn-danger" type="submit">Delete</button>
                                            </form>
                                        </span>
                                    @else
                                        <span class="text-muted">Read only</span>
                                    @endif
                                </td>
                            </tr>
                        @endforeach

                        @if(count($hosts) < 1 && count($providers) < 1)
                            <tr>
                                <td colspan="7" class="text-center text-muted">No database connections have been configured.</td>
                            </tr>
                        @endif
                    </tbody>
                </table>
            </div>
            <div class="box-footer">
                <p class="text-muted small no-margin">
                    Native MySQL hosts and provider allocations share each server's Database Limit. The Databases column shows server-owned allocations created on each connection.
                </p>
            </div>
        </div>
    </div>
</div>
</div>

@php
    $providerDefaults = [
        'engine' => old('engine', 'mysql'),
        'port' => old('port', 3306),
        'options' => [],
        'enabled' => true,
        'node_id' => null,
    ];
@endphp

@include('admin.extensions.betterdatabases.partials.provider-modal', [
    'modalId' => 'newProviderModal',
    'title' => 'Add Database Provider',
    'action' => $providerStoreAction,
    'method' => 'POST',
    'provider' => null,
    'providerDefaults' => $providerDefaults,
    'providerEngines' => $providerEngines,
    'locations' => $locations,
])

@foreach($providers as $provider)
    @include('admin.extensions.betterdatabases.partials.provider-modal', [
        'modalId' => 'providerModal' . $provider->id,
        'title' => 'Edit Database Provider',
        'action' => route('admin.extensions.betterdatabases.put'),
        'method' => 'PATCH',
        'provider' => $provider,
        'providerDefaults' => $providerDefaults,
        'providerEngines' => $providerEngines,
        'locations' => $locations,
    ])
@endforeach

@endsection

@section('footer-scripts')
    @parent
    <script>
        $('.pProviderNodeId').select2();
        function refreshProviderEngineOptions(select, updatePort) {
            var selected = select.val();
            var port = select.find('option:selected').data('port');
            var target = $(select.data('port-target'));

            if (updatePort && target.length && port) {
                target.val(port);
            }

            var modal = select.closest('.modal');
            modal.find('[data-engine-options]').hide();
            modal.find('[data-engine-options="' + selected + '"]').show();
            modal.find('[data-engine-copy]').hide();
            modal.find('[data-engine-copy]').filter(function () {
                return String($(this).data('engine-copy')).split(' ').indexOf(selected) !== -1;
            }).show();
            modal.find('[data-review-engine]').hide();
            modal.find('[data-review-engine="' + selected + '"]').show();
            updateProviderWizardReview(modal);
        }

        function providerFieldValue(modal, field) {
            var input = modal.find('[data-review-field="' + field + '"]').first();

            if (!input.length) {
                return '-';
            }

            if (input.attr('type') === 'checkbox') {
                return input.is(':checked') ? 'Yes' : 'No';
            }

            if (input.is('select')) {
                return input.find('option:selected').text() || '-';
            }

            if (field === 'password') {
                return input.val() ? 'Provided' : 'Not changed';
            }

            return input.val() || '-';
        }

        function updateProviderWizardReview(modal) {
            modal.find('[data-review-value]').each(function () {
                var key = $(this).data('review-value');
                $(this).text(providerFieldValue(modal, key));
            });
        }

        function setProviderWizardStep(modal, step) {
            step = Math.max(1, Math.min(4, step));
            modal.data('wizard-step', step);
            modal.find('[data-wizard-step]').hide();
            modal.find('[data-wizard-step="' + step + '"]').show();
            modal.find('[data-wizard-nav]').removeClass('active');
            modal.find('[data-wizard-nav="' + step + '"]').addClass('active');
            modal.find('[data-wizard-prev]').toggle(step > 1);
            modal.find('[data-wizard-next]').toggle(step < 4);
            modal.find('[data-wizard-submit]').toggle(step === 4);
            updateProviderWizardReview(modal);
        }

        $('[data-provider-engine]').each(function () {
            refreshProviderEngineOptions($(this), false);
        }).on('change', function () {
            refreshProviderEngineOptions($(this), true);
        });

        $('[data-provider-wizard]').each(function () {
            setProviderWizardStep($(this), 1);
            updateProviderWizardReview($(this));
        });

        $('[data-provider-wizard]').on('shown.bs.modal', function () {
            var modal = $(this);
            refreshProviderEngineOptions(modal.find('[data-provider-engine]').first(), false);
            setProviderWizardStep(modal, 1);
        });

        $('[data-wizard-nav]').on('click', function () {
            setProviderWizardStep($(this).closest('[data-provider-wizard]'), parseInt($(this).data('wizard-nav'), 10));
        });

        $('[data-wizard-next]').on('click', function () {
            var modal = $(this).closest('[data-provider-wizard]');
            setProviderWizardStep(modal, parseInt(modal.data('wizard-step') || 1, 10) + 1);
        });

        $('[data-wizard-prev]').on('click', function () {
            var modal = $(this).closest('[data-provider-wizard]');
            setProviderWizardStep(modal, parseInt(modal.data('wizard-step') || 1, 10) - 1);
        });

        $('[data-provider-wizard]').on('input change', '[data-review-field]', function () {
            updateProviderWizardReview($(this).closest('[data-provider-wizard]'));
        });
    </script>
@endsection