=CURDATE())"]; if ($q !== '') { $where[] = "(judul LIKE ? OR ringkasan LIKE ? OR isi LIKE ?)"; $like = "%$q%"; array_push($params, $like, $like, $like); } if ($kat !== '') { $where[] = "kategori=?"; $params[] = $kat; } $whereSql = 'WHERE ' . implode(' AND ', $where); $rows = []; $total = 0; $dbError = ''; try { $total = (int)(db_one("SELECT COUNT(*) c FROM siapp_pengumuman $whereSql", $params)['c'] ?? 0); $rows = db_all("SELECT id, judul, kategori, ringkasan, isi, gambar_url, lampiran_url, prioritas, created_at, tanggal_mulai FROM siapp_pengumuman $whereSql ORDER BY FIELD(prioritas,'DARURAT','PENTING','NORMAL'), COALESCE(tanggal_mulai, DATE(created_at)) DESC, id DESC LIMIT $limit OFFSET $off", $params); } catch (Throwable $e) { $dbError = $e->getMessage(); } $pages = max(1, (int)ceil(max(0,$total) / $limit)); function keepqs_pro($extra = []){ $qs = $_GET; foreach($extra as $k=>$v) $qs[$k] = $v; return e($_SERVER['PHP_SELF'] . '?' . http_build_query($qs)); } $logo = pro_asset('pro_app_icon.png'); $logoHeader = pro_asset('pro_app_header.png'); ?> PRO App Rengel Tuban
PRO App
PRO App Rengel TubanPelayanan Rakyat Online • Desa Rengel
⚡ PRO APP • Rengel • Tuban

Informasi Desa Rengel

Berita, pengumuman resmi, pelayanan warga, laporan kejadian, Toko Tetangga, dan layanan digital Desa Rengel dalam satu platform.

Login AdminCommand CenterKelola Pengumuman

Berita & Pengumuman Resmi

informasi ditemukan
Tabel pengumuman belum siap atau koneksi bermasalah.
Belum ada informasi yang diterbitkan.
1): ?>
1): ?>« Awal‹ Prev / Next ›Akhir »