🛠️ Fix & Setup Tabel WebGIS SPBU

'; // ── 1. SPBU table ────────────────────────────────────────────── echo '

📌 Tabel: spbu

'; mysqli_query($conn, "CREATE TABLE IF NOT EXISTS `spbu` ( `id` int NOT NULL AUTO_INCREMENT, `nama_spbu` varchar(100) DEFAULT NULL, `no_wa` varchar(20) DEFAULT NULL, `buka_24jam` enum('Ya','Tidak') DEFAULT 'Tidak', `latitude` double DEFAULT NULL, `longitude` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); echo "

✅ Tabel spbu OK.

"; // ── 2. JALAN table — drop & recreate (pasti schema benar) ────── echo '

📌 Tabel: jalan

'; // Cek jumlah data dulu $cntR = mysqli_query($conn, "SELECT COUNT(*) as c FROM jalan"); $cnt = $cntR ? mysqli_fetch_assoc($cntR)['c'] : 0; echo "

ℹ️ Data jalan saat ini: $cnt record.

"; // Drop dan recreate karena schema mungkin salah mysqli_query($conn, "DROP TABLE IF EXISTS `jalan`"); $r = mysqli_query($conn, "CREATE TABLE `jalan` ( `id` int NOT NULL AUTO_INCREMENT, `nama_jalan` varchar(150) NOT NULL, `status_jalan` enum('Nasional','Provinsi','Kabupaten') DEFAULT 'Nasional', `panjang` double DEFAULT 0, `geom` longtext, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); if ($r) { echo "

✅ Tabel jalan di-recreate dengan schema yang benar (status_jalan ✓).

"; } else { echo "

❌ Error: " . mysqli_error($conn) . "

"; } // ── 3. PARSIL table — drop & recreate ────────────────────────── echo '

📌 Tabel: parsil

'; $cntR2 = mysqli_query($conn, "SELECT COUNT(*) as c FROM parsil"); $cnt2 = $cntR2 ? mysqli_fetch_assoc($cntR2)['c'] : 0; echo "

ℹ️ Data parsil saat ini: $cnt2 record.

"; mysqli_query($conn, "DROP TABLE IF EXISTS `parsil`"); $r2 = mysqli_query($conn, "CREATE TABLE `parsil` ( `id` int NOT NULL AUTO_INCREMENT, `nama_pemilik` varchar(150) NOT NULL, `status` enum('SHM','HGB','HGU','HP') DEFAULT 'SHM', `luas` double DEFAULT 0, `geom` longtext, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); if ($r2) { echo "

✅ Tabel parsil di-recreate dengan schema yang benar.

"; } else { echo "

❌ Error: " . mysqli_error($conn) . "

"; } // ── Verifikasi kolom ──────────────────────────────────────────── echo '

'; echo '

🔍 Verifikasi Kolom Tabel Jalan:

'; $cols = mysqli_query($conn, "SHOW COLUMNS FROM jalan"); while ($col = mysqli_fetch_assoc($cols)) { echo "

✓ {$col['Field']} ({$col['Type']})

"; } echo '

'; echo '

🎉 Fix selesai! Sekarang coba Tambah Jalan lagi.

'; echo '

⚠️ Hapus file ini setelah selesai!

'; echo '

→ Kembali ke SPBU Dashboard

'; mysqli_close($conn); ?>