@extends('admin.admin_dashboard')
@section('admin')

<script>window.__chmSkipDefaultFlash = true;</script>

<div class="page-content chm-db-backup">
    <x-chm.layout.page
        title="Database backups"
        subtitle="Manual snapshots and hourly scheduled backups — Super Admin only"
        icon="bx bx-data"
    >
        <x-slot:breadcrumb>
            <x-chm.breadcrumb-item :href="route('admin.dashboard')">Home</x-chm.breadcrumb-item>
            <x-chm.breadcrumb-item :href="route('site.setting')">System</x-chm.breadcrumb-item>
            <x-chm.breadcrumb-item :active="true">Database backups</x-chm.breadcrumb-item>
        </x-slot:breadcrumb>

        <x-slot:actions>
            <span class="badge bg-dark-subtle text-dark border">
                <i class="bx bx-shield-quarter me-1"></i> Super Admin
            </span>
            @if($stats['hourly_enabled'])
                <span class="badge bg-success-subtle text-success border">
                    <i class="bx bx-time-five me-1"></i> Hourly schedule on
                </span>
            @endif
        </x-slot:actions>

        @if(session('success'))
            <x-chm.alert type="success" class="mb-4">{{ session('success') }}</x-chm.alert>
        @endif
        @if(session('error'))
            <x-chm.alert type="danger" class="mb-4">{{ session('error') }}</x-chm.alert>
        @endif

        @if($migrationRequired ?? false)
            <x-chm.alert type="warning" class="mb-4" title="Setup required">
                The backup module needs its database table before you can create snapshots.
                <form action="{{ route('system.database-backups.setup') }}" method="POST" class="mt-3">
                    @csrf
                    <button type="submit" class="btn btn-warning">
                        <i class="bx bx-wrench me-1"></i> Initialize backup tables
                    </button>
                </form>
                <p class="small text-muted mb-0 mt-2">
                    Or via SSH: <code>php artisan migrate --force</code>
                </p>
            </x-chm.alert>
        @endif

        <div class="row g-3 mb-4">
            <x-chm.stat-card
                label="Stored backups"
                :value="$stats['total_count']"
                icon="bx bx-archive"
                color="primary"
                :sublabel="'max ' . $stats['max_backups']"
            />
            <x-chm.stat-card
                label="Latest backup"
                :value="$stats['latest_size_human']"
                icon="bx bx-hdd"
                color="info"
                :sublabel="$stats['latest_label']"
            />
            <x-chm.stat-card
                label="Last manual"
                :value="$stats['latest_manual_label']"
                icon="bx bx-user"
                color="success"
            />
            <x-chm.stat-card
                label="Last scheduled"
                :value="$stats['latest_scheduled_label']"
                icon="bx bx-time"
                color="warning"
                sublabel="every hour"
            />
        </div>

        <div class="row g-4">
            <div class="col-lg-4">
                <x-chm.card title="Manual backup" icon="bx bx-cloud-download">
                    <p class="text-muted small mb-3">
                        Creates an on-demand snapshot of <strong>{{ $stats['database_name'] }}</strong>.
                    </p>

                    @if($stats['size_validation_enabled'] && $stats['previous_size_bytes'] > 0)
                        <div class="chm-db-backup-validation mb-3">
                            <i class="bx bx-check-shield"></i>
                            <div class="small">
                                <strong>Size check enabled</strong><br>
                                New backup must be <strong>larger than {{ $stats['previous_size_human'] }}</strong>
                                (from {{ $stats['previous_at_label'] }}).
                            </div>
                        </div>
                    @elseif($stats['size_validation_enabled'])
                        <div class="chm-db-backup-validation mb-3">
                            <i class="bx bx-check-shield"></i>
                            <div class="small">
                                First backup has no size baseline. Later backups must grow larger than the previous file.
                            </div>
                        </div>
                    @endif

                    <form action="{{ route('system.database-backups.store') }}" method="POST" id="backup-form">
                        @csrf
                        <div class="mb-3">
                            <label for="notes" class="form-label">Notes <span class="text-muted">(optional)</span></label>
                            <textarea
                                id="notes"
                                name="notes"
                                rows="3"
                                class="form-control"
                                maxlength="500"
                                placeholder="e.g. Before August payroll migration"
                            >{{ old('notes') }}</textarea>
                        </div>

                        @if($stats['size_validation_enabled'] && $stats['previous_size_bytes'] > 0)
                            <div class="form-check mb-3">
                                <input class="form-check-input" type="checkbox" name="force" value="1" id="force-backup" @checked(old('force'))>
                                <label class="form-check-label small" for="force-backup">
                                    Force backup even if smaller than previous (skip size validation)
                                </label>
                            </div>
                        @endif

                        <div class="chm-db-backup-callout mb-3">
                            <i class="bx bx-info-circle"></i>
                            <div>
                                @if($stats['uses_php_dump_only'] ?? false)
                                    <strong>PHP backup mode</strong>
                                    <p class="mb-2 small">This server has <code>proc_open</code> disabled, so backups use PHP via the live database connection (no mysqldump).</p>
                                @endif
                                <strong>Storage location</strong>
                                <p class="mb-2 small"><code>{{ $stats['storage_directory'] ?? '—' }}</code></p>
                                <strong>Automatic hourly backups</strong>
                                <ul class="mb-0 ps-3 small">
                                    <li>Scheduler runs <code>db:backup --scheduled</code> every hour.</li>
                                    <li>Requires cron: <code>* * * * * php artisan schedule:run</code></li>
                                    <li>Scheduled runs also pass the size validation.</li>
                                </ul>
                            </div>
                        </div>

                        <button type="submit" class="btn btn-primary w-100" id="backup-submit" @disabled($migrationRequired ?? false)>
                            <i class="bx bx-save me-1"></i> Run manual backup
                        </button>
                    </form>
                </x-chm.card>
            </div>

            <div class="col-lg-8">
                <div class="card chm-card">
                    <div class="card-header bg-white d-flex justify-content-between align-items-center">
                        <div>
                            <h5 class="mb-0">Backup history</h5>
                            <small class="text-muted">Manual and hourly scheduled snapshots</small>
                        </div>
                    </div>

                    <div class="table-responsive">
                        <table class="table table-hover align-middle mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th>Created</th>
                                    <th>Type</th>
                                    <th>File</th>
                                    <th>Size</th>
                                    <th>Method</th>
                                    <th>By</th>
                                    <th>Status</th>
                                    <th class="text-end">Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($backups as $backup)
                                    <tr>
                                        <td class="text-nowrap">
                                            <div class="fw-semibold">{{ $backup->created_at->format('M j, Y') }}</div>
                                            <small class="text-muted">{{ $backup->created_at->format('g:i A') }}</small>
                                        </td>
                                        <td>
                                            <x-chm.status-badge
                                                :status="$backup->isScheduled() ? 'info' : 'neutral'"
                                                :label="$backup->typeLabel()"
                                            />
                                        </td>
                                        <td>
                                            <div class="fw-medium">{{ $backup->filename }}</div>
                                            @if($backup->notes)
                                                <small class="text-muted">{{ Str::limit($backup->notes, 60) }}</small>
                                            @endif
                                            @if($backup->error_message)
                                                <small class="text-danger d-block">{{ Str::limit($backup->error_message, 100) }}</small>
                                            @endif
                                        </td>
                                        <td>{{ $backup->humanSize() }}</td>
                                        <td><span class="badge text-bg-light border">{{ $backup->method }}</span></td>
                                        <td>{{ $backup->creator?->name ?? 'Scheduler' }}</td>
                                        <td>
                                            <x-chm.status-badge
                                                :status="$backup->isCompleted() ? 'success' : 'danger'"
                                                :label="ucfirst($backup->status)"
                                            />
                                        </td>
                                        <td class="text-end">
                                            <div class="d-inline-flex gap-1">
                                                @if($backup->isCompleted() && $backup->fileExists())
                                                    <a href="{{ route('system.database-backups.download', $backup) }}"
                                                       class="btn btn-sm btn-outline-primary"
                                                       title="Download">
                                                        <i class="bx bx-download"></i>
                                                    </a>
                                                @endif
                                                <form action="{{ route('system.database-backups.destroy', $backup) }}"
                                                      method="POST"
                                                      class="d-inline chm-confirm-delete-form"
                                                      data-confirm-title="Delete backup?"
                                                      data-confirm-text="This will permanently remove {{ $backup->filename }} from the server.">
                                                    @csrf
                                                    @method('DELETE')
                                                    <button type="submit" class="btn btn-sm btn-outline-danger" title="Delete">
                                                        <i class="bx bx-trash"></i>
                                                    </button>
                                                </form>
                                            </div>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="8">
                                            <x-chm.empty-state
                                                icon="bx bx-data"
                                                title="No backups yet"
                                                message="Run a manual backup or wait for the hourly scheduler."
                                            />
                                        </td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>

                    @if($backups->hasPages())
                        <div class="card-footer bg-white">
                            {{ $backups->links() }}
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </x-chm.layout.page>
</div>

<script>
document.addEventListener('DOMContentLoaded', function () {
    const form = document.getElementById('backup-form');
    const submit = document.getElementById('backup-submit');

    form?.addEventListener('submit', function () {
        submit.disabled = true;
        submit.innerHTML = '<span class="spinner-border spinner-border-sm me-2"></span>Creating backup…';
    });
});
</script>

@endsection