Farha
49 lines
1.4 KiB
PHP
49 lines
1.4 KiB
PHP
<?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();
|
|
?>
|