prepare("SELECT * FROM berita WHERE status = 'aktif' ORDER BY COALESCE(tanggal_publikasi, created_at) DESC"); $stmt->execute(); $berita = $stmt->fetchAll(); // Get latest galeri infrastruktur $stmt = $pdo->prepare("SELECT * FROM galeri_infrastruktur WHERE status = 'aktif' ORDER BY created_at DESC LIMIT 8"); $stmt->execute(); $galeri_infrastruktur = $stmt->fetchAll(); // Get latest galeri kegiatan $stmt = $pdo->prepare("SELECT * FROM galeri_kegiatan WHERE status = 'aktif' ORDER BY created_at DESC LIMIT 4"); $stmt->execute(); $galeri_kegiatan = $stmt->fetchAll(); // Get infrastructure gallery (up to 4) for the slider $galeri_slider = array_slice($galeri_infrastruktur, 0, 4); // Get latest videos try { $stmt = $pdo->prepare("SELECT * FROM video WHERE status = 'aktif' ORDER BY created_at DESC LIMIT 4"); $stmt->execute(); $videos = $stmt->fetchAll(); } catch (PDOException $e) { $videos = []; } // Get latest majalah $stmt = $pdo->prepare("SELECT * FROM majalah WHERE status = 'aktif' ORDER BY created_at DESC LIMIT 4"); $stmt->execute(); $majalah = $stmt->fetchAll(); // Get latest pengumuman $stmt = $pdo->prepare("SELECT * FROM pengumuman WHERE status = 'aktif' ORDER BY created_at DESC LIMIT 4"); $stmt->execute(); $pengumuman_sidebar = $stmt->fetchAll(); // Debug: Check if pengumuman data exists if (empty($pengumuman_sidebar)) { // If no pengumuman, try to get from majalah table as fallback $stmt = $pdo->prepare("SELECT * FROM majalah WHERE status = 'aktif' ORDER BY created_at DESC LIMIT 4"); $stmt->execute(); $pengumuman_sidebar = $stmt->fetchAll(); } // Get latest infografis $stmt = $pdo->prepare("SELECT * FROM infografis WHERE status = 'aktif' ORDER BY created_at DESC LIMIT 6"); $stmt->execute(); $infografis = $stmt->fetchAll(); // Fix path duplication issue for infografis (same as sidebar-data.php) foreach ($infografis as &$item) { if (isset($item['gambar'])) { // Use getFullUrl instead of getUploadUrl to avoid duplication $item['gambar_url'] = getFullUrl($item['gambar']); } } // Get active banners for slider $stmt = $pdo->prepare("SELECT * FROM banner WHERE status = 'aktif' ORDER BY urutan ASC, created_at DESC"); $stmt->execute(); $banners = $stmt->fetchAll(); // Get visitor statistics $visitorCounter = new VisitorCounter(); $stats = $visitorCounter->getStats(); // Include header include 'includes/header.php'; ?>

$banner): ?>

1): ?>

$banner): ?>

Berita Terkini

<?php echo htmlspecialchars($item['judul']); ?>

120) { $excerpt = substr($excerpt, 0, 120) . '...'; } echo htmlspecialchars($excerpt); ?>

Belum ada berita.

Berita

50) { $judul = substr($judul, 0, 50) . '...'; } // Format tanggal seperti pada gambar $tanggal_tampil = !empty($item['tanggal_publikasi']) ? $item['tanggal_publikasi'] : $item['created_at']; $tanggal = date('d/m/Y', strtotime($tanggal_tampil)); // Potong ringkasan (maksimal 80 karakter) $ringkasan = strip_tags($item['konten']); $ringkasan = trim($ringkasan); if (strlen($ringkasan) > 50) { $ringkasan = substr($ringkasan, 0, 50) . '...'; } $ringkasan = htmlspecialchars($ringkasan); // Path gambar $image_path = $item['gambar']; if (!empty($image_path) && strpos($image_path, 'uploads/berita/') !== 0) { $image_path = 'uploads/berita/' . $image_path; } if (empty($image_path)) { $image_path = 'assets/img/default-news.jpg'; // Gambar default jika tidak ada } ?>

Belum ada berita.

Video

Video tidak tersedia

Galeri Infrastruktur

Belum Ada Galeri Infrastruktur

Berita Terkini

Berita

Video

Galeri Infrastruktur

Aplikasi & Link Terkait