<?php
require_once __DIR__ . '/../config/database.php';

$db = new Database();
$conn = $db->getConnection();

$id = $_GET['id'] ?? null;

if (!$id) {
    echo json_encode(['success' => false]);
    exit;
}

// ambil SN dari item
$stmt = $conn->prepare("SELECT sn_onu FROM ftth_items WHERE id = ?");
$stmt->execute([$id]);
$item = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$item) {
    echo json_encode(['success' => false]);
    exit;
}

$sn = $item['sn_onu'];

// ambil histori anomali saja
$stmt = $conn->prepare("
    SELECT *
    FROM status_onu_histori
    WHERE sn = ?
    ORDER BY created_at DESC
    LIMIT 100
");

$stmt->execute([$sn]);
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);

echo json_encode([
    'success' => true,
    'sn' => $sn,
    'data' => $data
]);