<?php
require 'config.php';

// Proses Upload
if (isset($_POST['upload_gallery'])) {
    $judul = mysqli_real_escape_string($conn, $_POST['title']); // Gunakan mysqli_real_escape_string agar lebih aman
    
    if (!empty($_FILES['image']['name'])) {
        $foto = "gal_" . time() . "_" . $_FILES['image']['name'];
        
        // Pastikan folder uploads ada
        if (move_uploaded_file($_FILES['image']['tmp_name'], "uploads/" . $foto)) {
            // PERBAIKAN: Nama kolom disesuaikan dengan DB (judul, foto)
            $query = "INSERT INTO gallery (judul, foto) VALUES ('$judul', '$foto')";
            mysqli_query($conn, $query);
            echo "<script>alert('Foto Galeri Berhasil Ditambah!'); window.location='gallery.php';</script>";
        } else {
            echo "<script>alert('Gagal mengunggah file ke folder.');</script>";
        }
    }
}

// Proses Hapus
if (isset($_GET['hapus'])) {
    $id = $_GET['hapus'];
    // PERBAIKAN: Ambil kolom 'foto'
    $res = mysqli_query($conn, "SELECT foto FROM gallery WHERE id='$id'");
    $g = mysqli_fetch_assoc($res);
    
    if ($g) {
        if (file_exists("uploads/" . $g['foto'])) {
            unlink("uploads/" . $g['foto']);
        }
        mysqli_query($conn, "DELETE FROM gallery WHERE id='$id'");
    }
    echo "<script>alert('Foto Dihapus!'); window.location='gallery.php';</script>";
}

// PERBAIKAN: Ambil data terbaru
$gal = mysqli_query($conn, "SELECT * FROM gallery ORDER BY id DESC");
?>

<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Kelola Galeri</title>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css">
    <style>
        .img-gal { height: 150px; object-fit: cover; width: 100%; border-radius: 8px 8px 0 0; }
        .btn-xs { padding: 2px 8px; font-size: 10px; }
    </style>
</head>
<body class="bg-light p-4">
    <div class="container">
        <h4 class="mb-4 fw-bold">ADMIN - KELOLA GALERI FOTO</h4>
        <div class="row">
            <div class="col-md-4 mb-4">
                <div class="card shadow-sm border-0">
                    <div class="card-header bg-danger text-white">Tambah Foto Galeri</div>
                    <div class="card-body">
                        <form action="" method="POST" enctype="multipart/form-data">
                            <label class="small fw-bold">Keterangan Foto</label>
                            <input type="text" name="title" class="form-control mb-2" placeholder="Contoh: Rapat DPC" required>
                            
                            <label class="small fw-bold">Pilih File</label>
                            <input type="file" name="image" class="form-control mb-3" accept="image/*" required>
                            
                            <button type="submit" name="upload_gallery" class="btn btn-danger w-100">Upload Foto</button>
                        </form>
                    </div>
                </div>
                <div class="mt-3">
                    <a href="index.php" class="btn btn-secondary btn-sm">Kembali ke Dashboard</a>
                </div>
            </div>
            
            <div class="col-md-8">
                <div class="row">
                    <?php if (mysqli_num_rows($gal) > 0) : ?>
                        <?php while($g = mysqli_fetch_assoc($gal)) : ?>
                        <div class="col-md-4 col-6 mb-4">
                            <div class="card h-100 border-0 shadow-sm">
                                <img src="uploads/<?= $g['foto'] ?>" class="img-gal" onerror="this.src='https://via.placeholder.com/150?text=No+Image'">
                                <div class="card-body p-2 text-center">
                                    <p class="small mb-2 text-truncate"><?= $g['judul'] ?></p>
                                    <a href="?hapus=<?= $g['id'] ?>" class="btn btn-danger btn-xs" onclick="return confirm('Hapus foto ini?')">Hapus</a>
                                </div>
                            </div>
                        </div>
                        <?php endwhile; ?>
                    <?php else : ?>
                        <div class="col-12 text-center py-5">
                            <p class="text-muted">Belum ada foto di galeri.</p>
                        </div>
                    <?php endif; ?>
                </div>
            </div>
        </div>
    </div>
</body>
</html>