<?php 
include_once '../db/koneksi.php';

if (isset($_GET['hapus'])) {
    $id = mysqli_real_escape_string($koneksi, $_GET['id']);
    
    // 1. Ambil informasi data dari database
    $query = mysqli_query($koneksi, "SELECT gambar_banner FROM tb_banner WHERE id_banner='$id'");
    $data = mysqli_fetch_assoc($query);
    
    if ($data) {
        $file_path = "../upload/banner/" . $data['gambar_banner'];
        
        // 2. Cek apakah file benar-benar ada di folder sebelum dihapus
        if (file_exists($file_path) && !empty($data['gambar_banner'])) {
            unlink($file_path); // Hapus file fisik dari folder
        }
        
        // 3. Hapus record dari database
        mysqli_query($koneksi, "DELETE FROM tb_banner WHERE id_banner='$id'");
        
        echo "<script>alert('Banner dan file gambar berhasil dihapus!'); window.location='banner';</script>";
    } else {
        echo "<script>alert('Data tidak ditemukan!'); window.location='banner';</script>";
    }
}

// Proses Tambah
if (isset($_POST['simpan'])) {
    $nama_file = $_FILES['gambar']['name'];
    $tmp_file = $_FILES['gambar']['tmp_name'];
    
    // Memberikan nama unik agar tidak tertimpa
    $nama_baru = time() . '_' . $nama_file; 
    $target_dir = "../upload/banner/";
    
    // Upload file
    if (move_uploaded_file($tmp_file, $target_dir . $nama_baru)) {
        mysqli_query($koneksi, "INSERT INTO tb_banner (gambar_banner, judul_banner, aktif) VALUES ('$nama_baru', '$_POST[judul]', 'Y')");
        echo "<script>alert('Banner berhasil diupload!'); window.location='banner';</script>";
    } else {
        echo "<script>alert('Gagal upload gambar!');</script>";
    }
}
?>

<div class="container-xxl flex-grow-1 container-p-y">
    <h4 class="fw-bold py-3 mb-4">Manajemen Banner</h4>

    <div class="card mb-4">
        <div class="card-body">
            <form method="POST" enctype="multipart/form-data">
                <div class="mb-3">
                    <label>Judul Banner</label>
                    <input type="text" name="judul" class="form-control" required>
                </div>
                <div class="mb-3">
                    <label>Pilih Gambar</label>
                    <input type="file" name="gambar" class="form-control" required>
                </div>
                <button type="submit" name="simpan" class="btn btn-primary">Simpan Banner</button>
            </form>
        </div>
    </div>

    <div class="card">
        <div class="table-responsive text-nowrap">
            <table class="table">
                <thead>
                    <tr>
                        <th>Gambar</th>
                        <th>Judul</th>
                        <th>Aksi</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                    $tampil = mysqli_query($koneksi, "SELECT * FROM tb_banner ORDER BY id_banner DESC");
                    while($d = mysqli_fetch_array($tampil)){
                    ?>
                    <tr>
                        <td><img src="../upload/banner/<?= $d['gambar_banner'] ?>" width="150" style="border-radius:5px;"></td>
                        <td><?= $d['judul_banner'] ?></td>
                        <td>
                            <a href="banner.php?hapus=true&id=<?= $d['id_banner'] ?>" 
                               class="btn btn-danger btn-sm" onclick="return confirm('Yakin ingin menghapus banner ini?')">Hapus</a>
                        </td>
                    </tr>
                    <?php } ?>
                </tbody>
            </table>
        </div>
    </div>
</div>