beginTransaction(); $stmt = $pdo->prepare("SELECT status FROM surat_keluar WHERE id = ?"); $stmt->execute([$id]); $oldStatus = $stmt->fetchColumn(); $stmt = $pdo->prepare("UPDATE surat_keluar SET status = ? WHERE id = ?"); $stmt->execute([$newStatus, $id]); $stmt = $pdo->prepare("INSERT INTO surat_keluar_log (surat_keluar_id, old_status, new_status, note) VALUES (?, ?, ?, ?)"); $stmt->execute([$id, $oldStatus, $newStatus, $note]); $pdo->commit(); header('Location: /surat_keluar_view.php?id=' . $id . '&success=1'); exit; } $stmt = $pdo->prepare("SELECT * FROM surat_keluar WHERE id = ?"); $stmt->execute([$id]); $row = $stmt->fetch(); $logs = $pdo->prepare("SELECT * FROM surat_keluar_log WHERE surat_keluar_id = ? ORDER BY created_at DESC"); $logs->execute([$id]); $logs = $logs->fetchAll(); render_header('Detail Surat Keluar', 'keluar'); ?>