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

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    http_response_code(405);
    echo json_encode(['status' => 'error', 'message' => 'Metode tidak diizinkan']);
    $conn->close();
    exit;
}

$id = (int)($_POST['id'] ?? 0);
$status = strtolower(trim($_POST['bantuan_status'] ?? 'belum'));
$catatan = trim($_POST['bantuan_catatan'] ?? '');

if ($id <= 0) {
    echo json_encode(['status' => 'error', 'message' => 'ID tidak valid']);
    $conn->close();
    exit;
}

if (!in_array($status, ['belum', 'proses', 'sudah'], true)) {
    $status = 'belum';
}

$stmt = $conn->prepare("UPDATE penduduk_miskin SET bantuan_status = ?, bantuan_catatan = ?, bantuan_updated_at = CURRENT_TIMESTAMP WHERE id = ?");
$stmt->bind_param("ssi", $status, $catatan, $id);

if ($stmt->execute()) {
    $updatedAtResult = $conn->query("SELECT bantuan_updated_at FROM penduduk_miskin WHERE id = " . (int)$id . " LIMIT 1");
    $updatedAt = null;
    if ($updatedAtResult && $updatedAtResult->num_rows > 0) {
        $row = $updatedAtResult->fetch_assoc();
        $updatedAt = $row['bantuan_updated_at'] ?? null;
    }

    echo json_encode([
        'status' => 'success',
        'message' => 'Status bantuan berhasil diperbarui',
        'bantuan_updated_at' => $updatedAt
    ]);
} else {
    echo json_encode(['status' => 'error', 'message' => $stmt->error]);
}

$stmt->close();
$conn->close();
?>