@extends('layouts.admin')

@section('title', 'Database Backup & Restore')

@section('content')
<div class="container-fluid">
    <!-- Page Header -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h1 class="h3 mb-0 text-gray-800">Database Backup & Restore</h1>
            <p class="text-muted">Manage database backups and restore operations</p>
        </div>
        <div>
            <a href="{{ route('admin.database-backup.create') }}" class="btn btn-primary">
                <i class="fas fa-plus me-2"></i>Create Backup
            </a>
            <a href="{{ route('admin.database-backup.restore') }}" class="btn btn-warning">
                <i class="fas fa-undo me-2"></i>Restore Database
            </a>
        </div>
    </div>

    <!-- Requirements Check -->
    @if(!empty($requirements))
        <div class="alert alert-danger mb-4">
            <h6 class="alert-heading"><i class="fas fa-exclamation-triangle me-2"></i>System Requirements</h6>
            <ul class="mb-0">
                @foreach($requirements as $requirement)
                    <li>{{ $requirement }}</li>
                @endforeach
            </ul>
        </div>
    @endif

    <!-- Statistics Cards -->
    <div class="row mb-4">
        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-primary shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">
                                Total Backups
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800">
                                {{ $statistics['total_backups'] }}
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-database fa-2x text-gray-300"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-success shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-success text-uppercase mb-1">
                                Completed Backups
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800">
                                {{ $statistics['completed_backups'] }}
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-check-circle fa-2x text-gray-300"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-info shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                                Total Backup Size
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800">
                                {{ number_format($statistics['total_size'] / 1024 / 1024, 2) }} MB
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-hdd fa-2x text-gray-300"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6 mb-4">
            <div class="card border-warning shadow h-100 py-2">
                <div class="card-body">
                    <div class="row no-gutters align-items-center">
                        <div class="col mr-2">
                            <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                                Database Size
                            </div>
                            <div class="h5 mb-0 font-weight-bold text-gray-800">
                                {{ number_format($statistics['database_size'], 2) }} MB
                            </div>
                        </div>
                        <div class="col-auto">
                            <i class="fas fa-server fa-2x text-gray-300"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Recent Backups -->
    <div class="card shadow mb-4">
        <div class="card-header py-3">
            <div class="d-flex justify-content-between align-items-center">
                <h6 class="m-0 font-weight-bold text-primary">Recent Backups</h6>
                <a href="{{ route('admin.database-backup.backups') }}" class="btn btn-sm btn-outline-primary">
                    View All Backups
                </a>
            </div>
        </div>
        <div class="card-body">
            @if($recentBackups->count() > 0)
                <div class="table-responsive">
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th>Name</th>
                                <th>Type</th>
                                <th>Status</th>
                                <th>Size</th>
                                <th>Created</th>
                                <th>Created By</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($recentBackups as $backup)
                            <tr>
                                <td>
                                    <div class="fw-bold">{{ $backup->name }}</div>
                                    @if($backup->description)
                                        <small class="text-muted">{{ Str::limit($backup->description, 50) }}</small>
                                    @endif
                                </td>
                                <td>
                                    <span class="badge bg-{{ $backup->type_badge }}">
                                        {{ ucfirst($backup->type) }}
                                    </span>
                                </td>
                                <td>
                                    <span class="badge bg-{{ $backup->status_badge }}">
                                        {{ ucfirst($backup->status) }}
                                    </span>
                                </td>
                                <td>{{ $backup->formatted_file_size }}</td>
                                <td>{{ $backup->created_at->format('M d, Y H:i') }}</td>
                                <td>{{ $backup->creator->name ?? 'System' }}</td>
                                <td>
                                    <div class="btn-group" role="group">
                                        <a href="{{ route('admin.database-backup.show', $backup) }}" 
                                           class="btn btn-sm btn-outline-primary" title="View Details">
                                            <i class="fas fa-eye"></i>
                                        </a>
                                        @if($backup->status === 'completed' && $backup->fileExists())
                                            <a href="{{ route('admin.database-backup.download', $backup) }}" 
                                               class="btn btn-sm btn-outline-success" title="Download">
                                                <i class="fas fa-download"></i>
                                            </a>
                                        @endif
                                        <form method="POST" action="{{ route('admin.database-backup.destroy', $backup) }}" 
                                              class="d-inline" onsubmit="return confirm('Are you sure you want to delete this backup?')">
                                            @csrf
                                            @method('DELETE')
                                            <button type="submit" class="btn btn-sm btn-outline-danger" title="Delete">
                                                <i class="fas fa-trash"></i>
                                            </button>
                                        </form>
                                    </div>
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            @else
                <div class="text-center py-4">
                    <i class="fas fa-database fa-3x text-muted mb-3"></i>
                    <h5 class="text-muted">No backups found</h5>
                    <p class="text-muted">Create your first database backup to get started.</p>
                    <a href="{{ route('admin.database-backup.create') }}" class="btn btn-primary">
                        <i class="fas fa-plus me-2"></i>Create First Backup
                    </a>
                </div>
            @endif
        </div>
    </div>

    <!-- Quick Actions -->
    <div class="row">
        <div class="col-md-6">
            <div class="card shadow">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-primary">Quick Actions</h6>
                </div>
                <div class="card-body">
                    <div class="list-group list-group-flush">
                        <a href="{{ route('admin.database-backup.create') }}" class="list-group-item list-group-item-action">
                            <i class="fas fa-plus text-primary me-3"></i>
                            <strong>Create New Backup</strong>
                            <p class="mb-0 text-muted">Create a manual backup of the database</p>
                        </a>
                        <a href="{{ route('admin.database-backup.restore') }}" class="list-group-item list-group-item-action">
                            <i class="fas fa-undo text-warning me-3"></i>
                            <strong>Restore Database</strong>
                            <p class="mb-0 text-muted">Restore database from existing backup</p>
                        </a>
                        <a href="{{ route('admin.database-backup.backups') }}" class="list-group-item list-group-item-action">
                            <i class="fas fa-list text-info me-3"></i>
                            <strong>Manage Backups</strong>
                            <p class="mb-0 text-muted">View and manage all database backups</p>
                        </a>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-md-6">
            <div class="card shadow">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-primary">Storage Information</h6>
                </div>
                <div class="card-body">
                    <div class="mb-3">
                        <div class="d-flex justify-content-between">
                            <span>Database Size:</span>
                            <strong>{{ number_format($statistics['database_size'], 2) }} MB</strong>
                        </div>
                    </div>
                    <div class="mb-3">
                        <div class="d-flex justify-content-between">
                            <span>Total Backup Size:</span>
                            <strong>{{ number_format($statistics['total_size'] / 1024 / 1024, 2) }} MB</strong>
                        </div>
                    </div>
                    <div class="mb-3">
                        <div class="d-flex justify-content-between">
                            <span>Available Space:</span>
                            <strong>{{ number_format($statistics['available_space'] / 1024 / 1024 / 1024, 2) }} GB</strong>
                        </div>
                    </div>
                    <hr>
                    <div class="text-center">
                        <button type="button" class="btn btn-outline-secondary btn-sm" onclick="showCleanupModal()">
                            <i class="fas fa-broom me-2"></i>Cleanup Old Backups
                        </button>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Cleanup Modal -->
<div class="modal fade" id="cleanupModal" tabindex="-1">
    <div class="modal-dialog">
        <div class="modal-content">
            <form method="POST" action="{{ route('admin.database-backup.cleanup') }}">
                @csrf
                <div class="modal-header">
                    <h5 class="modal-title">Cleanup Old Backups</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <div class="mb-3">
                        <label for="keep_days" class="form-label">Keep backups for (days)</label>
                        <input type="number" class="form-control" id="keep_days" name="keep_days" value="30" min="1" max="365" required>
                        <div class="form-text">Backups older than this will be deleted</div>
                    </div>
                    <div class="mb-3">
                        <label for="keep_count" class="form-label">Minimum backups to keep</label>
                        <input type="number" class="form-control" id="keep_count" name="keep_count" value="10" min="1" max="100" required>
                        <div class="form-text">Always keep at least this many recent backups</div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-warning">Cleanup Backups</button>
                </div>
            </form>
        </div>
    </div>
</div>

<script>
function showCleanupModal() {
    new bootstrap.Modal(document.getElementById('cleanupModal')).show();
}

// Auto-refresh statistics every 30 seconds
setInterval(function() {
    fetch('{{ route("admin.database-backup.statistics") }}')
        .then(response => response.json())
        .then(data => {
            // Update statistics if needed
            console.log('Statistics updated', data);
        })
        .catch(error => console.error('Error updating statistics:', error));
}, 30000);
</script>
@endsection