<?php
include 'config.php';
checkLogin();

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $id = $_POST['id'];
    
    // Cek apakah level sedang digunakan
    $query = "SELECT COUNT(*) as total FROM db_user WHERE id_level = ?";
    $stmt = $koneksi->prepare($query);
    $stmt->bind_param('i', $id);
    $stmt->execute();
    $result = $stmt->get_result();
    $row = $result->fetch_assoc();
    
    if ($row['total'] > 0) {
        echo json_encode(['status' => 'error', 'message' => 'Tidak dapat menghapus level karena masih digunakan oleh user']);
        exit();
    }
    
    $query = "DELETE FROM db_level WHERE id = ?";
    $stmt = $koneksi->prepare($query);
    $stmt->bind_param('i', $id);
    
    if ($stmt->execute()) {
        echo json_encode(['status' => 'success', 'message' => 'Level berhasil dihapus']);
    } else {
        echo json_encode(['status' => 'error', 'message' => 'Gagal menghapus level']);
    }
}
?>