prepare("
SELECT
u.id,
CONCAT(u.prefixID,u.firstName,' ',u.lastName) AS fullname,
s.firstname AS school_name, u.username,
u.status
FROM users u
LEFT JOIN school s ON u.schoolID = s.schoolID
ORDER BY u.id DESC
");
// ✅ user_type_id = 1 และ → เห็นทุกอำเภอในจังหวัดตัวเอง
} elseif ($user_type_id == 1) {
$stmt = $pdo->prepare("
SELECT
u.id,
CONCAT(u.prefixID,u.firstName,' ',u.lastName) AS fullname,
s.firstname AS school_name,
u.status
FROM users u
LEFT JOIN school s ON u.schoolID = s.schoolID
WHERE u.leader = '$leader'
AND u.user_type_id = '2'
ORDER BY u.id DESC
");
// ✅ user_type_id = 2 → เห็นทุกตำบลในอำเภอตัวเอง
} elseif ($user_type_id == 2) {
$stmt = $pdo->prepare("
SELECT
u.id,
CONCAT(u.prefixID,u.firstName,' ',u.lastName) AS fullname,
s.firstname AS school_name, u.username, u.leader ,
u.status
FROM users u
LEFT JOIN school s ON u.schoolID = s.schoolID
WHERE u.leader = '$schoolID'
AND u.user_type_id = '4'
ORDER BY u.id DESC
");
}
$stmt->execute();
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>