Swal.fire({ title: '$title', text: '$text', icon: '$icon', confirmButtonText: 'ตกลง' }).then(() => {"; if ($redirect) { echo "window.location='$redirect';"; } echo "}); "; } /* ========================================================== STAFF / ADMIN → เห็นทั้งหมด USER → เห็นเฉพาะของตัวเอง ========================================================== */ if ($ROLE == "user") { $filter = "WHERE beacons.user_id = $USER_ID"; } else { $filter = ""; } /* ========================================================== ADD BEACON (FIXED) ========================================================== */ if (isset($_POST['add_beacon'])) { $uuid = trim($_POST['uuid']); $major = intval($_POST['major']); $minor = intval($_POST['minor']); $place = trim($_POST['place']); $notify = $_POST['notify_type']; if ($ROLE == "user") { $owner = $USER_ID; } else { $owner = intval($_POST['user_id']); staff_cannot_edit_admin($owner, $conn); } $stmt = $conn->prepare(" INSERT INTO beacons (uuid, major, minor, location, user_id, notify_type) VALUES (?, ?, ?, ?, ?, ?) "); /* ✨ แก้ bind_param ให้ถูกต้อง */ $stmt->bind_param("siisis", $uuid, $major, $minor, $place, $owner, $notify); if ($stmt->execute()) { swal("สำเร็จ", "เพิ่ม Beacon สำเร็จ", "success", "beacons.php"); } else { swal("ผิดพลาด", "เพิ่มข้อมูลไม่สำเร็จ", "error", "beacons.php"); } } /* ========================================================== EDIT BEACON (FIXED) ========================================================== */ if (isset($_POST['edit_beacon'])) { $id = intval($_POST['beacon_id']); $uuid = trim($_POST['uuid']); $major = intval($_POST['major']); $minor = intval($_POST['minor']); $place = trim($_POST['place']); $notify = $_POST['notify_type']; $q = $conn->query("SELECT user_id FROM beacons WHERE id=$id"); $old = $q->fetch_assoc(); if (!$old) { swal("ข้อผิดพลาด", "ไม่พบข้อมูล Beacon", "error", "beacons.php"); exit; } if ($ROLE == "user" && $old['user_id'] != $USER_ID) { swal("สิทธิ์ไม่เพียงพอ", "คุณไม่มีสิทธิ์แก้ไข Beacon นี้", "error", "beacons.php"); exit; } if ($ROLE == "user") { $owner = $old['user_id']; } else { $owner = intval($_POST['user_id']); staff_cannot_edit_admin($owner, $conn); } $stmt = $conn->prepare(" UPDATE beacons SET uuid=?, major=?, minor=?, location=?, user_id=?, notify_type=? WHERE id=? "); /* ✨ แก้ bind_param: 7 ตัว ต้องใช้“siisisi” */ $stmt->bind_param("siisisi", $uuid, $major, $minor, $place, $owner, $notify, $id); $stmt->execute(); swal("สำเร็จ", "แก้ไขข้อมูลสำเร็จ", "success", "beacons.php"); } /* ========================================================== DELETE BEACON ========================================================== */ if (isset($_GET['del'])) { $id = intval($_GET['del']); $q = $conn->query("SELECT user_id FROM beacons WHERE id=$id"); $b = $q->fetch_assoc(); if (!$b) { swal("ผิดพลาด", "ไม่พบข้อมูล Beacon", "error", "beacons.php"); exit; } if ($ROLE == "user" && $b['user_id'] != $USER_ID) { swal("สิทธิ์ไม่เพียงพอ", "คุณไม่มีสิทธิ์ลบ Beacon นี้", "error", "beacons.php"); exit; } staff_cannot_edit_admin($b['user_id'], $conn); $conn->query("DELETE FROM beacons WHERE id=$id"); swal("สำเร็จ", "ลบ Beacon สำเร็จ", "success", "beacons.php"); } ?>

จัดการ Beacon

query($sql); while ($b = $res->fetch_assoc()): ?>
UUID:
Major: Minor:
ตำแหน่ง:
แจ้งเตือน:
เจ้าของ:
ลบ
+