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

checkAdmin();

$log_db = getDB(DB_LOG_HOST, DB_LOG_NAME, DB_LOG_USER, DB_LOG_PASS);

$action = $_REQUEST['action'] ?? '';

try {
    if ($action === 'list') {
        $stmt = $log_db->query("SELECT * FROM system_logs ORDER BY id DESC");
        $logs = $stmt->fetchAll();
        foreach ($logs as &$log) {
            $log['created_at'] = formatThaiDate($log['created_at']);
        }
        echo json_encode(['data' => $logs]);
    } 
    else {
        echo json_encode(['status' => 'error', 'message' => 'Unknown action']);
    }
} catch (Exception $e) {
    echo json_encode(['status' => 'error', 'message' => 'Database Error: ' . $e->getMessage()]);
}