prepare("SELECT e.HR_PREFIX_NAME, a.HR_FNAME, a.HR_LNAME FROM hr_person a LEFT JOIN hr_prefix e ON a.HR_PREFIX_ID = e.HR_PREFIX_ID WHERE a.HR_CID = :cid"); $stmtMaster->execute(['cid' => $master_super_admin_cid]); $masterRow = $stmtMaster->fetch(); if ($masterRow) { $master_name = $masterRow['HR_PREFIX_NAME'] . $masterRow['HR_FNAME'] . " " . $masterRow['HR_LNAME']; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $stmt = $pdo_sys->query("SELECT * FROM system_users ORDER BY id DESC"); while ($row = $stmt->fetch()) { // ดึงชื่อจาก HOSxP $name = 'ไม่พบชื่อใน HOSxP'; $stmtName = $pdo_hos->prepare("SELECT e.HR_PREFIX_NAME, a.HR_FNAME, a.HR_LNAME FROM hr_person a LEFT JOIN hr_prefix e ON a.HR_PREFIX_ID = e.HR_PREFIX_ID WHERE a.HR_CID = :cid"); $stmtName->execute(['cid' => $row['cid']]); $nameRow = $stmtName->fetch(); if ($nameRow) { $name = $nameRow['HR_PREFIX_NAME'] . $nameRow['HR_FNAME'] . " " . $nameRow['HR_LNAME']; } $roleBadge = $row['role'] === 'superadmin' ? 'badge-soft-primary' : 'badge-soft-info'; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } catch (PDOException $e) { echo ""; } ?>

ID	เลขบัตรประชาชน (CID)	ชื่อ - นามสกุล	สิทธิ์การใช้งาน (Role)	วันที่เพิ่ม	จัดการ
0	" . htmlspecialchars($master_super_admin_cid) . "	" . htmlspecialchars($master_name) . "	Master Super Admin	-	ไม่สามารถลบได้
" . $row['id'] . "	" . htmlspecialchars($row['cid']) . "	" . htmlspecialchars($name) . "	" . htmlspecialchars($row['role']) . "	" . format_thai_date($row['created_at'], true) . "	"; echo ""; echo "
Error: " . $e->getMessage() . "