<?php
include 'koneksi.php';
header('Content-Type: application/json');

try {
    // Ambil data occupant yang di-approve dan memiliki foto
    $stmt = $pdo->query("SELECT id_occupant, name, foto FROM occupant WHERE status = 'approved' AND foto IS NOT NULL AND foto != ''");
    $occupants = $stmt->fetchAll(PDO::FETCH_ASSOC);

    $faces = [];
    foreach ($occupants as $row) {
        $photoUrl = $row['foto'];
        // Jika tidak ada / di awal, biarkan sesuai relative path
        if (!file_exists(__DIR__ . '/' . $photoUrl)) {
            continue; // file fisik foto tidak ditemukan, skip.
        }
        $faces[] = [
            'id'   => $row['id_occupant'],
            'name' => $row['name'],
            'foto' => $photoUrl
        ];
    }

    echo json_encode(['status' => 'success', 'data' => $faces]);
} catch (PDOException $e) {
    echo json_encode(['status' => 'error', 'message' => 'Query error: ' . $e->getMessage()]);
}
?>