@extends('layouts.app')
@section('title','Database Backup')@section('page-title','Database Backup')
@section('content')
<div class="page-header d-flex align-items-start justify-content-between">
    <div><h1>Database Backup</h1><p>Create and download full database snapshots</p></div>
    <form action="{{ route('backup.create') }}" method="POST" id="backupForm">@csrf<button type="submit" class="btn btn-brand" id="backupBtn"><i class="bi bi-shield-plus me-2"></i>Create Backup</button></form>
</div>
<div class="alert alert-warning d-flex align-items-center gap-3 mb-4" style="border-radius:14px;"><i class="bi bi-info-circle-fill fs-5"></i><div style="font-size:14px;"><strong>Requirements:</strong> Backups use <code>mysqldump</code> on the server PATH. Files are stored in <code>storage/app/backups/</code>. Download and store off-site regularly.</div></div>
<div class="card"><div class="card-body p-0">
    <div class="table-responsive"><table class="table table-hover mb-0">
        <thead><tr><th class="ps-4">Filename</th><th>Size</th><th>Created By</th><th>Status</th><th>Created</th><th class="pe-4">Actions</th></tr></thead>
        <tbody>
        @forelse($backups as $backup)
        <tr>
            <td class="ps-4"><div class="d-flex align-items-center gap-2"><i class="bi bi-file-earmark-zip" style="font-size:18px;color:var(--accent)"></i><div style="font-size:13px;font-weight:600;">{{ $backup->filename }}</div></div></td>
            <td style="font-size:13px;">{{ $backup->size_formatted }}</td>
            <td style="font-size:13px;">{{ $backup->user?->name ?? '—' }}</td>
            <td><span class="badge-status badge-{{ $backup->status==='created'?'completed':'cancelled' }}">{{ ucfirst($backup->status) }}</span></td>
            <td style="font-size:12px;color:var(--text-muted-c)">{{ $backup->created_at->format('M j, Y H:i') }}<div style="font-size:11px;">{{ $backup->created_at->diffForHumans() }}</div></td>
            <td class="pe-4">
                <div class="d-flex gap-1">
                    @if($backup->status==='created')<a href="{{ route('backup.download',$backup) }}" class="btn btn-sm btn-icon btn-outline-brand" title="Download"><i class="bi bi-download"></i></a>@endif
                    <form action="{{ route('backup.destroy',$backup) }}" method="POST" onsubmit="return confirm('Delete this backup?')">@csrf @method('DELETE')<button type="submit" class="btn btn-sm btn-icon btn-outline-danger" title="Delete"><i class="bi bi-trash"></i></button></form>
                </div>
            </td>
        </tr>
        @empty
        <tr><td colspan="6" class="text-center py-5"><i class="bi bi-shield" style="font-size:48px;color:var(--text-muted-c)"></i><p class="mt-2 text-muted mb-0">No backups yet. Click "Create Backup" to generate one.</p></td></tr>
        @endforelse
        </tbody>
    </table></div>
</div>
@if($backups->hasPages())<div class="card-footer p-3" style="border-top:1px solid var(--border-c)">{{ $backups->links() }}</div>@endif
</div>
@endsection
@push('scripts')
<script>
document.getElementById('backupForm').addEventListener('submit',function(){
    const btn=document.getElementById('backupBtn');
    btn.disabled=true;btn.innerHTML='<span class="spinner-border spinner-border-sm me-2"></span>Creating...';
});
</script>
@endpush