<?php
header('Content-Type: application/json; charset=utf-8');
require '../inc/connect.php';

$type   = isset($_GET['type']) ? $_GET['type'] : '';
$leader = isset($_GET['leader']) ? $_GET['leader'] : '';

if ($type == 'amp') {
    $sql = "SELECT schoolID, firstname FROM school WHERE user_type_id = '2' AND leader = ? ORDER BY firstname";
} elseif ($type == 'tambon') {
    $sql = "SELECT schoolID, firstname FROM school WHERE user_type_id = '4' AND leader = ? ORDER BY firstname";
} else {
    echo json_encode(["debug"=>"no type"]);
    exit;
}

try {
    $stmt = $pdo->prepare($sql);
    $stmt->execute(array($leader));
    $data = $stmt->fetchAll(PDO::FETCH_ASSOC);

    // ✅ Debug log (ส่งกลับมาด้วย)
    echo json_encode([
        "debug_sql" => $sql,
        "debug_leader" => $leader,
        "rows" => $data
    ]);
} catch (PDOException $e) {
    echo json_encode(["error"=>$e->getMessage()]);
}