<?php
// DB 연결
$db_upbit = null;
$mysqlInfo = [];
$dbInfo = [];
$tableInfo = [];

try {
    require_once '/home/www/DB/db_upbit.php';
    if (isset($pdo)) {
        $db_upbit = $pdo;
        
        // MySQL 버전 정보
        $stmt = $db_upbit->query("SELECT VERSION() as version");
        $mysqlInfo['version'] = $stmt->fetch(PDO::FETCH_ASSOC)['version'] ?? 'Unknown';
        
        // MySQL 연결 상태
        $mysqlInfo['connected'] = true;
        
        // upbit_data 데이터베이스 크기
        $stmt = $db_upbit->query("
            SELECT 
                ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS size_mb
            FROM information_schema.tables 
            WHERE table_schema = 'upbit_data'
        ");
        $dbSize = $stmt->fetch(PDO::FETCH_ASSOC);
        $dbInfo['size_mb'] = $dbSize['size_mb'] ?? 0;
        
        // upbit_data 테이블 목록 및 크기
        $stmt = $db_upbit->query("
            SELECT 
                table_name,
                ROUND((data_length + index_length) / 1024 / 1024, 2) AS size_mb,
                table_rows
            FROM information_schema.tables 
            WHERE table_schema = 'upbit_data'
            ORDER BY (data_length + index_length) DESC
            LIMIT 20
        ");
        $tableInfo = $stmt->fetchAll(PDO::FETCH_ASSOC);
        
    } else {
        $mysqlInfo['connected'] = false;
    }
} catch (Exception $e) {
    $mysqlInfo['connected'] = false;
    $mysqlInfo['error'] = $e->getMessage();
}

// 디렉토리 정보 수집 함수
function getDirectoryInfo($path) {
    $info = [
        'exists' => false,
        'size' => 0,
        'size_mb' => 0,
        'size_gb' => 0,
        'file_count' => 0,
        'dir_count' => 0,
        'latest_file' => null,
        'latest_file_time' => null,
        'oldest_file' => null,
        'oldest_file_time' => null
    ];
    
    if (!is_dir($path)) {
        return $info;
    }
    
    $info['exists'] = true;
    
    // 디렉토리 크기 및 파일 수 계산
    try {
        $iterator = new RecursiveIteratorIterator(
            new RecursiveDirectoryIterator($path, RecursiveDirectoryIterator::SKIP_DOTS),
            RecursiveIteratorIterator::SELF_FIRST
        );
        
        $latestTime = 0;
        $oldestTime = time();
        $latestFile = null;
        $oldestFile = null;
        
        foreach ($iterator as $file) {
            if ($file->isFile()) {
                $info['size'] += $file->getSize();
                $info['file_count']++;
                
                $mtime = $file->getMTime();
                if ($mtime > $latestTime) {
                    $latestTime = $mtime;
                    $latestFile = $file->getPathname();
                }
                if ($mtime < $oldestTime) {
                    $oldestTime = $mtime;
                    $oldestFile = $file->getPathname();
                }
            } elseif ($file->isDir()) {
                $info['dir_count']++;
            }
        }
        
        $info['size_mb'] = round($info['size'] / 1024 / 1024, 2);
        $info['size_gb'] = round($info['size'] / 1024 / 1024 / 1024, 2);
        
        if ($latestFile) {
            $info['latest_file'] = basename($latestFile);
            $info['latest_file_time'] = date('Y-m-d H:i:s', $latestTime);
        }
        if ($oldestFile) {
            $info['oldest_file'] = basename($oldestFile);
            $info['oldest_file_time'] = date('Y-m-d H:i:s', $oldestTime);
        }
    } catch (Exception $e) {
        $info['error'] = $e->getMessage();
    }
    
    return $info;
}

// 데몬 파일 정보 수집
function getDaemonFiles($basePath = '/home/www') {
    $daemonFiles = [];
    $searchPaths = [
        $basePath,
        $basePath . '/DAEMON',
        $basePath . '/daemon',
        $basePath . '/GNU',
        $basePath . '/GNU/DAEMON',
        $basePath . '/GNU/daemon',
        $basePath . '/_DAEMON',
        $basePath . '/_daemon'
    ];
    
    foreach ($searchPaths as $path) {
        if (is_dir($path)) {
            $iterator = new RecursiveIteratorIterator(
                new RecursiveDirectoryIterator($path, RecursiveDirectoryIterator::SKIP_DOTS),
                RecursiveIteratorIterator::SELF_FIRST
            );
            
            foreach ($iterator as $file) {
                if ($file->isFile()) {
                    $filename = $file->getFilename();
                    // 접두사가 daemon_ 또는 cron_인 파일만 찾기
                    if (preg_match('/^(daemon_|cron_)/i', $filename)) {
                        $daemonFiles[] = [
                            'name' => $filename,
                            'path' => $file->getPathname(),
                            'size' => $file->getSize(),
                            'size_mb' => round($file->getSize() / 1024 / 1024, 2),
                            'modified' => date('Y-m-d H:i:s', $file->getMTime()),
                            'type' => pathinfo($filename, PATHINFO_EXTENSION)
                        ];
                    }
                }
            }
        }
    }
    
    return $daemonFiles;
}

// 크론 파일 정보 수집
function getCronInfo() {
    $cronInfo = [
        'crontab_exists' => false,
        'crontab_content' => null,
        'cron_files' => []
    ];
    
    // 현재 사용자의 crontab 확인
    $user = posix_getpwuid(posix_geteuid());
    $username = $user['name'] ?? 'www-data';
    
    // crontab 파일 경로들
    $cronPaths = [
        '/var/spool/cron/crontabs/' . $username,
        '/var/spool/cron/' . $username,
        '/etc/cron.d/',
        '/etc/cron.daily/',
        '/etc/cron.hourly/',
        '/etc/cron.weekly/',
        '/etc/cron.monthly/'
    ];
    
    // crontab 명령어로 확인
    $crontabOutput = @shell_exec('crontab -l 2>/dev/null');
    if ($crontabOutput) {
        $cronInfo['crontab_exists'] = true;
        $cronInfo['crontab_content'] = $crontabOutput;
        $cronInfo['cron_count'] = substr_count($crontabOutput, "\n");
    }
    
    // cron 디렉토리 파일들 확인
    foreach ($cronPaths as $cronPath) {
        if (is_dir($cronPath)) {
            $files = glob($cronPath . '*');
            foreach ($files as $file) {
                if (is_file($file)) {
                    $cronInfo['cron_files'][] = [
                        'name' => basename($file),
                        'path' => $file,
                        'size' => filesize($file),
                        'modified' => date('Y-m-d H:i:s', filemtime($file))
                    ];
                }
            }
        }
    }
    
    return $cronInfo;
}

// 프로세스 정보 수집
function getProcessInfo() {
    $processInfo = [
        'php_processes' => 0,
        'mysql_processes' => 0,
        'daemon_processes' => []
    ];
    
    if (strtoupper(substr(PHP_OS, 0, 3)) !== 'WIN') {
        // PHP 프로세스 수
        $phpProcs = @shell_exec("ps aux | grep '[p]hp' | wc -l");
        $processInfo['php_processes'] = (int)trim($phpProcs);
        
        // MySQL 프로세스 수
        $mysqlProcs = @shell_exec("ps aux | grep '[m]ysqld' | wc -l");
        $processInfo['mysql_processes'] = (int)trim($mysqlProcs);
        
        // 데몬 프로세스 확인
        $daemonProcs = @shell_exec("ps aux | grep -E '[d]aemon|upbit' | grep -v grep");
        if ($daemonProcs) {
            $lines = explode("\n", trim($daemonProcs));
            foreach ($lines as $line) {
                if (preg_match('/\S+\s+(\d+)\s+/', $line, $matches)) {
                    $processInfo['daemon_processes'][] = [
                        'pid' => $matches[1],
                        'cmd' => substr($line, strpos($line, $matches[1]) + strlen($matches[1]) + 1)
                    ];
                }
            }
        }
    }
    
    return $processInfo;
}

// 로그 디렉토리 정보
$logDirInfo = getDirectoryInfo('/home/www/DATA/UPBIT/log');

// 데몬 파일 정보
$daemonFiles = getDaemonFiles();

// 크론 정보
$cronInfo = getCronInfo();

// 프로세스 정보
$processInfo = getProcessInfo();

// 서버 정보 수집
function getServerInfo() {
    $info = [];
    
    // 기본 정보
    $info['php_version'] = PHP_VERSION;
    $info['server_software'] = $_SERVER['SERVER_SOFTWARE'] ?? 'Unknown';
    $info['server_name'] = $_SERVER['SERVER_NAME'] ?? 'Unknown';
    $info['server_addr'] = $_SERVER['SERVER_ADDR'] ?? 'Unknown';
    $info['document_root'] = $_SERVER['DOCUMENT_ROOT'] ?? 'Unknown';
    $info['script_filename'] = $_SERVER['SCRIPT_FILENAME'] ?? 'Unknown';
    $info['server_time'] = date('Y-m-d H:i:s');
    $info['timezone'] = date_default_timezone_get();
    
    // 메모리 정보
    $info['memory_limit'] = ini_get('memory_limit');
    $info['memory_usage'] = memory_get_usage(true);
    $info['memory_peak'] = memory_get_peak_usage(true);
    $info['memory_usage_mb'] = round($info['memory_usage'] / 1024 / 1024, 2);
    $info['memory_peak_mb'] = round($info['memory_peak'] / 1024 / 1024, 2);
    
    // 디스크 정보
    $info['disk_total'] = disk_total_space('.');
    $info['disk_free'] = disk_free_space('.');
    $info['disk_used'] = $info['disk_total'] - $info['disk_free'];
    $info['disk_usage_percent'] = round(($info['disk_used'] / $info['disk_total']) * 100, 2);
    
    // CPU 정보 (Windows)
    if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') {
        $info['os'] = 'Windows';
        $info['os_version'] = php_uname('v');
        $info['cpu_count'] = (int)shell_exec('echo %NUMBER_OF_PROCESSORS%');
    } else {
        $info['os'] = php_uname('s');
        $info['os_version'] = php_uname('r');
        $info['cpu_count'] = (int)shell_exec('nproc');
    }
    
    // 로드 평균 (Linux)
    if (function_exists('sys_getloadavg')) {
        $info['load_avg'] = sys_getloadavg();
    } else {
        $info['load_avg'] = null;
    }
    
    // PHP 설정
    $info['max_execution_time'] = ini_get('max_execution_time');
    $info['upload_max_filesize'] = ini_get('upload_max_filesize');
    $info['post_max_size'] = ini_get('post_max_size');
    $info['max_input_vars'] = ini_get('max_input_vars');
    
    // 업타임 (Linux)
    if (file_exists('/proc/uptime')) {
        $uptime = file_get_contents('/proc/uptime');
        $uptimeSeconds = (float)explode(' ', $uptime)[0];
        $days = floor($uptimeSeconds / 86400);
        $hours = floor(($uptimeSeconds % 86400) / 3600);
        $minutes = floor(($uptimeSeconds % 3600) / 60);
        $info['uptime'] = sprintf('%d일 %d시간 %d분', $days, $hours, $minutes);
    } else {
        $info['uptime'] = 'N/A';
    }
    
    // 네트워크 정보
    $info['http_host'] = $_SERVER['HTTP_HOST'] ?? 'Unknown';
    $info['remote_addr'] = $_SERVER['REMOTE_ADDR'] ?? 'Unknown';
    $info['request_uri'] = $_SERVER['REQUEST_URI'] ?? 'Unknown';
    
    return $info;
}

$serverInfo = getServerInfo();

// 메모리 제한 파싱
function parseSize($size) {
    $unit = preg_replace('/[^bkmgtpezy]/i', '', $size);
    $size = preg_replace('/[^0-9\.]/', '', $size);
    if ($unit) {
        return round($size * pow(1024, stripos('bkmgtpezy', $unit[0])));
    } else {
        return round($size);
    }
}

$memoryLimitBytes = parseSize($serverInfo['memory_limit']);
$memoryUsagePercent = $memoryLimitBytes > 0 ? round(($serverInfo['memory_usage'] / $memoryLimitBytes) * 100, 2) : 0;

require_once '/home/www/GNU/_PAGE/head.php';
?>

<!-- 웹 폰트 및 아이콘 추가 -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
<link rel="stylesheet" as="style" crossorigin href="https://cdn.jsdelivr.net/gh/orioncactus/pretendard@v1.3.8/dist/web/static/pretendard.css" />

<link rel="stylesheet" type="text/css" href="../../index.css">
<style>
    body {
        background: #020617;
        font-family: 'Pretendard', -apple-system, BlinkMacSystemFont, system-ui, Roboto, sans-serif;
    }
    
    /* 아이콘 스타일 추가 */
    .card-title i {
        color: #6366f1;
        width: 25px;
        text-align: center;
    }
    
    /* 로딩 애니메이션 */
    .loading-overlay {
        position: fixed;
        top: 0;
        left: 0;
        width: 100%;
        height: 100%;
        background: #020617;
        display: flex;
        justify-content: center;
        align-items: center;
        z-index: 9999;
        opacity: 1;
        animation: fadeOut 0.5s ease-out 0.3s forwards;
    }
    
    @keyframes fadeOut {
        to { opacity: 0; pointer-events: none; }
    }
    
    .loading-spinner {
        width: 50px;
        height: 50px;
        border: 4px solid rgba(99, 102, 241, 0.2);
        border-top-color: #667eea;
        border-radius: 50%;
        animation: spin 0.8s linear infinite;
    }
    
    @keyframes spin {
        to { transform: rotate(360deg); }
    }
    
    /* 페이지 스크롤바 스타일 */
    ::-webkit-scrollbar {
        width: 7px;
    }
    
    ::-webkit-scrollbar-track {
        background: #020617;
    }
    
    ::-webkit-scrollbar-thumb {
        background: rgba(99, 102, 241, 0.5);
        border-radius: 6px;
    }
    
    ::-webkit-scrollbar-thumb:hover {
        background: rgba(99, 102, 241, 0.7);
    }
    
    .server-container {
        max-width: 100%;
        margin: 0 auto;
        padding: 0px 20px;
    }
    
    .server-header {
        background: #08081d;
        border-bottom: 1px solid #0f172a;
        text-align: center;
        margin-bottom: 40px;
        padding: 30px 20px;
    }
    
    .server-header h1 {
        font-size: 32px;
        font-weight: 700;
        color: #45abff;
        margin-bottom: 10px;
    }
    
    .server-header p {
        color: #64748b;
        font-size: 14px;
    }
    
    .server-grid {
        display: grid;
        grid-template-columns: repeat(4, 1fr);
        gap: 25px;
        margin-bottom: 30px;
    }
    
    .server-card {
        background: #0f172a;
        border: 1px solid rgba(99, 102, 241, 0.2);
        border-radius: 5px;
        padding: 25px;
        box-shadow: 0 8px 32px rgba(0, 0, 0, 0.7);
        transition: all 0.3s ease;
    }
    
    .server-card:hover {
        border-color: rgba(99, 102, 241, 0.4);
        transform: translateY(-3px);
        box-shadow: 0 12px 40px rgba(0, 0, 0, 0.8);
    }
    
    .card-title {
        font-size: 18px;
        font-weight: 700;
        color: #cbd5e1;
        margin-bottom: 20px;
        padding-bottom: 12px;
        border-bottom: 2px solid rgba(99, 102, 241, 0.2);
        display: flex;
        align-items: center;
        gap: 10px;
        transition: all 0.2s ease;
    }
    
    .card-title:hover {
        color: #e2e8f0;
        border-bottom-color: rgba(99, 102, 241, 0.4);
    }
    
    .card-title.dark-red {
        color: #dc2626;
    }
    .card-title.dark-red i {
        color: #ef4444;
    }
    
    .info-row {
        display: flex;
        justify-content: space-between;
        align-items: center;
        padding: 12px 0;
        border-bottom: 1px solid rgba(148, 163, 184, 0.1);
        transition: all 0.2s ease;
    }
    
    .info-row:hover {
        padding-left: 5px;
        background: rgba(99, 102, 241, 0.03);
        border-radius: 4px;
    }
    
    .info-row:last-child {
        border-bottom: none;
    }
    
    .info-label {
        color: #64748b;
        font-size: 14px;
        font-weight: 500;
    }
    
    .info-value {
        color: #cbd5e1;
        font-size: 14px;
        font-weight: 600;
        text-align: right;
    }
    
    .progress-bar {
        width: 100%;
        height: 8px;
        background: rgba(148, 163, 184, 0.1);
        border-radius: 4px;
        overflow: hidden;
        margin-top: 8px;
    }
    
    .progress-fill {
        height: 100%;
        background: #667eea;
        border-radius: 4px;
        transition: width 0.3s ease;
    }
    
    .progress-fill.warning {
        background: #f59e0b;
    }
    
    .progress-fill.danger {
        background: #ef4444;
    }
    
    .status-badge {
        display: inline-block;
        padding: 4px 12px;
        border-radius: 5px;
        font-size: 12px;
        font-weight: 600;
        margin-left: 10px;
        transition: all 0.2s ease;
    }
    
    .status-badge:hover {
        transform: scale(1.05);
    }
    
    .status-ok {
        background: rgba(16, 185, 129, 0.2);
        color: #10b981;
        border: 1px solid rgba(16, 185, 129, 0.4);
    }
    
    .status-warning {
        background: rgba(245, 158, 11, 0.2);
        color: #f59e0b;
        border: 1px solid rgba(245, 158, 11, 0.4);
    }
    
    .status-danger {
        background: rgba(239, 68, 68, 0.2);
        color: #ef4444;
        border: 1px solid rgba(239, 68, 68, 0.4);
    }
    
    .full-width {
        grid-column: 1 / -1;
    }
    
    .metric-card {
        background: rgba(99, 102, 241, 0.08);
        border: 1px solid rgba(99, 102, 241, 0.15);
        border-radius: 5px;
        padding: 20px;
        text-align: center;
        transition: all 0.2s ease;
    }
    
    .metric-card:hover {
        transform: translateY(-2px);
        border-color: rgba(99, 102, 241, 0.3);
        background: rgba(99, 102, 241, 0.12);
    }
    
    .metric-value {
        font-size: 14px;
        font-weight: 600;
        color: #cbd5e1;
        margin: 10px 0;
    }
    
    .metric-label {
        font-size: 16px;
        color: #64748b;
        text-transform: uppercase;
        letter-spacing: 1px;
        font-weight: 600;
    }
    
    .refresh-btn {
        position: fixed;
        bottom: 30px;
        right: 30px;
        background: #667eea;
        color: #fff;
        border: none;
        border-radius: 5px;
        padding: 10px 25px;
        font-size: 14px;
        font-weight: 600;
        cursor: pointer;
        box-shadow: 0 8px 24px rgba(102, 126, 234, 0.4);
        transition: all 0.3s ease;
        z-index: 1000;
        display: flex;
        align-items: center;
        gap: 8px;
    }
    
    .refresh-btn:hover {
        background: #764ba2;
        transform: translateY(-2px);
        box-shadow: 0 10px 28px rgba(102, 126, 234, 0.5);
    }
    
    .refresh-btn:active {
        transform: translateY(0);
    }
    
    .table-list {
        max-height: 400px;
        overflow-y: scroll;
        margin-top: 15px;
        width: 100%;
        scrollbar-width: thin;
        scrollbar-color: rgba(99, 102, 241, 0.5) rgba(15, 23, 42, 0.5);
    }
    
    .table-item {
        display: flex;
        justify-content: space-between;
        align-items: center;
        padding: 12px 15px;
        margin: 8px 0;
        background: rgba(99, 102, 241, 0.05);
        border: 1px solid rgba(99, 102, 241, 0.2);
        border-radius: 5px;
        transition: all 0.2s ease;
    }
    
    .table-item:hover {
        background: rgba(99, 102, 234, 0.15);
        border-color: rgba(99, 102, 241, 0.4);
    }
    
    .table-name {
        color: #cbd5e1;
        font-weight: 600;
        font-size: 14px;
        flex: 1;
        min-width: 0;
        word-break: break-word;
    }
    
    .table-size {
        color: #64748b;
        font-size: 13px;
        font-weight: 600;
        margin-left: 10px;
    }
    
    .table-rows {
        color: #667eea;
        font-size: 12px;
        margin-left: 10px;
    }
    
    .file-list {
        max-height: 400px;
        overflow-y: scroll;
        margin-top: 15px;
        font-size: 12px;
        scrollbar-width: thin;
        scrollbar-color: rgba(99, 102, 241, 0.5) rgba(15, 23, 42, 0.5);
        width: 100%;
    }
    
    .file-item {
        display: flex;
        justify-content: space-between;
        align-items: center;
        padding: 10px 12px;
        margin: 6px 0;
        background: rgba(99, 102, 241, 0.05);
        border: 1px solid rgba(99, 102, 241, 0.2);
        border-radius: 5px;
        font-size: 12px;
        transition: all 0.2s ease;
        width: 100%;
        box-sizing: border-box;
    }
    
    .file-item:hover {
        background: rgba(99, 102, 234, 0.15);
        border-color: rgba(99, 102, 241, 0.4);
    }
    
    .file-name {
        color: #cbd5e1;
        font-weight: 600;
        font-size: 12px;
        flex: 1;
        min-width: 0;
        word-break: break-word;
        overflow: hidden;
        text-overflow: ellipsis;
    }
    
    .file-info {
        display: flex;
        gap: 15px;
        align-items: center;
        font-size: 11px;
        color: #64748b;
        flex-shrink: 0;
        white-space: nowrap;
    }
    
    .cron-content {
        max-height: 300px;
        overflow-y: auto;
        background: rgba(0, 0, 0, 0.3);
        border-radius: 5px;
        padding: 15px;
        margin-top: 10px;
        font-family: 'Courier New', monospace;
        font-size: 12px;
        color: #10b981;
        white-space: pre-wrap;
        word-break: break-all;
    }
    
    /* 스크롤바 스타일 */
    .table-list::-webkit-scrollbar,
    .file-list::-webkit-scrollbar,
    .cron-content::-webkit-scrollbar {
        width: 8px;
    }
    
    .table-list::-webkit-scrollbar-track,
    .file-list::-webkit-scrollbar-track,
    .cron-content::-webkit-scrollbar-track {
        background: rgba(15, 23, 42, 0.5);
        border-radius: 4px;
    }
    
    .table-list::-webkit-scrollbar-thumb,
    .file-list::-webkit-scrollbar-thumb,
    .cron-content::-webkit-scrollbar-thumb {
        background: rgba(99, 102, 241, 0.5);
        border-radius: 4px;
    }
    
    .table-list::-webkit-scrollbar-thumb:hover,
    .file-list::-webkit-scrollbar-thumb:hover,
    .cron-content::-webkit-scrollbar-thumb:hover {
        background: rgba(99, 102, 241, 0.7);
    }
    
    @media (max-width: 1400px) {
        .server-grid {
            grid-template-columns: repeat(3, 1fr);
        }
    }
    
    @media (max-width: 1024px) {
        .server-grid {
            grid-template-columns: repeat(2, 1fr);
        }
    }
    
    @media (max-width: 768px) {
        .server-grid {
            grid-template-columns: 1fr;
        }
        
        .refresh-btn {
            bottom: 20px;
            right: 20px;
            padding: 12px 20px;
            font-size: 12px;
        }
        
        .server-card.full-width > div:last-child {
            grid-template-columns: repeat(2, 1fr) !important;
        }
    }
    
    @media (max-width: 1920px) {
        .server-card.full-width > div:last-child {
            grid-template-columns: repeat(8, 1fr);
        }
    }
    
    @media (max-width: 1600px) {
        .server-card.full-width > div:last-child {
            grid-template-columns: repeat(4, 1fr);
        }
    }
</style>

<div class="loading-overlay">
    <div class="loading-spinner"></div>
</div>

<div class="server-container">
    <div class="server-header">
        <h1><i class="fa-solid fa-gauge-high"></i> 서버 관리 대시보드</h1>
        <p>실시간 서버 상태 모니터링</p>
    </div>
    
    <div class="server-grid">
        <!-- 시스템 정보 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-solid fa-circle-info"></i> 시스템 정보</div>
            <div class="info-row">
                <span class="info-label">운영체제</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['os']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">OS 버전</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['os_version']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">서버 이름</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['server_name']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">서버 주소</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['server_addr']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">서버 소프트웨어</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['server_software']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">서버 시간</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['server_time']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">타임존</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['timezone']) ?></span>
            </div>
        </div>
        
        <!-- PHP 정보 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-brands fa-php"></i> PHP 정보</div>
            <div class="info-row">
                <span class="info-label">PHP 버전</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['php_version']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">메모리 제한</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['memory_limit']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">최대 실행 시간</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['max_execution_time']) ?>초</span>
            </div>
            <div class="info-row">
                <span class="info-label">업로드 최대 크기</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['upload_max_filesize']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">POST 최대 크기</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['post_max_size']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">최대 입력 변수</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['max_input_vars']) ?></span>
            </div>
        </div>
        
        <!-- 메모리 사용량 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-solid fa-memory"></i> 메모리 사용량</div>
            <div class="info-row">
                <span class="info-label">현재 사용량</span>
                <span class="info-value"><?= $serverInfo['memory_usage_mb'] ?> MB</span>
            </div>
            <div class="info-row">
                <span class="info-label">최대 사용량</span>
                <span class="info-value"><?= $serverInfo['memory_peak_mb'] ?> MB</span>
            </div>
            <div class="info-row">
                <span class="info-label">사용률</span>
                <span class="info-value">
                    <?= $memoryUsagePercent ?>%
                    <?php
                    $statusClass = 'ok';
                    if ($memoryUsagePercent > 80) $statusClass = 'danger';
                    elseif ($memoryUsagePercent > 60) $statusClass = 'warning';
                    ?>
                    <span class="status-badge status-<?= $statusClass ?>">
                        <?= $memoryUsagePercent > 80 ? '위험' : ($memoryUsagePercent > 60 ? '주의' : '정상') ?>
                    </span>
                </span>
            </div>
            <div class="progress-bar">
                <div class="progress-fill <?= $memoryUsagePercent > 80 ? 'danger' : ($memoryUsagePercent > 60 ? 'warning' : '') ?>" 
                     style="width: <?= min($memoryUsagePercent, 100) ?>%"></div>
            </div>
        </div>
        
        <!-- 디스크 사용량 -->
        <div class="server-card">
            <div class="card-title dark-red"><i class="fa-solid fa-hard-drive"></i> 디스크 사용량</div>
            <div class="info-row">
                <span class="info-label">전체 용량</span>
                <span class="info-value"><?= number_format($serverInfo['disk_total'] / 1024 / 1024 / 1024, 2) ?> GB</span>
            </div>
            <div class="info-row">
                <span class="info-label">사용 중</span>
                <span class="info-value"><?= number_format($serverInfo['disk_used'] / 1024 / 1024 / 1024, 2) ?> GB</span>
            </div>
            <div class="info-row">
                <span class="info-label">사용 가능</span>
                <span class="info-value"><?= number_format($serverInfo['disk_free'] / 1024 / 1024 / 1024, 2) ?> GB</span>
            </div>
            <div class="info-row">
                <span class="info-label">사용률</span>
                <span class="info-value">
                    <?= $serverInfo['disk_usage_percent'] ?>%
                    <?php
                    $diskStatusClass = 'ok';
                    if ($serverInfo['disk_usage_percent'] > 90) $diskStatusClass = 'danger';
                    elseif ($serverInfo['disk_usage_percent'] > 75) $diskStatusClass = 'warning';
                    ?>
                    <span class="status-badge status-<?= $diskStatusClass ?>">
                        <?= $serverInfo['disk_usage_percent'] > 90 ? '위험' : ($serverInfo['disk_usage_percent'] > 75 ? '주의' : '정상') ?>
                    </span>
                </span>
            </div>
            <div class="progress-bar">
                <div class="progress-fill <?= $serverInfo['disk_usage_percent'] > 90 ? 'danger' : ($serverInfo['disk_usage_percent'] > 75 ? 'warning' : '') ?>" 
                     style="width: <?= $serverInfo['disk_usage_percent'] ?>%"></div>
            </div>
        </div>
        
        <!-- CPU 정보 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-solid fa-microchip"></i> CPU 정보</div>
            <div class="info-row">
                <span class="info-label">CPU 코어 수</span>
                <span class="info-value"><?= $serverInfo['cpu_count'] > 0 ? $serverInfo['cpu_count'] : 'N/A' ?></span>
            </div>
            <?php if ($serverInfo['load_avg']): ?>
            <div class="info-row">
                <span class="info-label">로드 평균 (1분)</span>
                <span class="info-value"><?= number_format($serverInfo['load_avg'][0], 2) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">로드 평균 (5분)</span>
                <span class="info-value"><?= number_format($serverInfo['load_avg'][1], 2) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">로드 평균 (15분)</span>
                <span class="info-value"><?= number_format($serverInfo['load_avg'][2], 2) ?></span>
            </div>
            <?php endif; ?>
        </div>
        
        <!-- 경로 정보 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-solid fa-folder-tree"></i> 경로 정보</div>
            <div class="info-row">
                <span class="info-label">문서 루트</span>
                <span class="info-value" style="font-size: 12px; word-break: break-all;"><?= htmlspecialchars($serverInfo['document_root']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">스크립트 경로</span>
                <span class="info-value" style="font-size: 12px; word-break: break-all;"><?= htmlspecialchars($serverInfo['script_filename']) ?></span>
            </div>
        </div>
        
        <!-- MySQL 정보 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-solid fa-database"></i> MySQL 정보</div>
            <div class="info-row">
                <span class="info-label">연결 상태</span>
                <span class="info-value">
                    <?php if ($mysqlInfo['connected']): ?>
                        <span class="status-badge status-ok">연결됨</span>
                    <?php else: ?>
                        <span class="status-badge status-danger">연결 실패</span>
                    <?php endif; ?>
                </span>
            </div>
            <?php if ($mysqlInfo['connected']): ?>
            <div class="info-row">
                <span class="info-label">MySQL 버전</span>
                <span class="info-value"><?= htmlspecialchars($mysqlInfo['version']) ?></span>
            </div>
            <?php else: ?>
            <div class="info-row">
                <span class="info-label">오류 메시지</span>
                <span class="info-value" style="font-size: 12px; color: #ef4444;"><?= htmlspecialchars($mysqlInfo['error'] ?? 'Unknown error') ?></span>
            </div>
            <?php endif; ?>
        </div>
        
        <!-- upbit_data 데이터베이스 정보 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-solid fa-coins"></i> upbit_data 데이터베이스</div>
            <?php if ($mysqlInfo['connected']): ?>
            <div class="info-row">
                <span class="info-label">데이터베이스 크기</span>
                <span class="info-value"><?= number_format($dbInfo['size_mb'], 2) ?> MB</span>
            </div>
            <div class="info-row">
                <span class="info-label">테이블 수</span>
                <span class="info-value"><?= count($tableInfo) ?>개</span>
            </div>
            <?php if (!empty($tableInfo)): ?>
            <div class="info-row" style="flex-direction: column; align-items: flex-start; padding: 15px 0;">
                <span class="info-label" style="margin-bottom: 10px;">주요 테이블 (상위 10개)</span>
                <div class="table-list" style="width: 100%;">
                    <?php foreach (array_slice($tableInfo, 0, 10) as $table): ?>
                    <div class="table-item" style="display: grid; grid-template-columns: 1fr auto auto; gap: 15px; align-items: center;">
                        <span class="table-name"><?= htmlspecialchars($table['table_name']) ?></span>
                        <span class="table-size"><?= number_format($table['size_mb'], 2) ?> MB</span>
                        <span class="table-rows"><?= number_format($table['table_rows']) ?> rows</span>
                    </div>
                    <?php endforeach; ?>
                </div>
            </div>
            <?php endif; ?>
            <?php else: ?>
            <div class="info-row">
                <span class="info-label">데이터베이스 정보</span>
                <span class="info-value" style="color: #ef4444;">연결 불가</span>
            </div>
            <?php endif; ?>
        </div>
        
        <!-- 로그 디렉토리 정보 -->
        <div class="server-card">
            <div class="card-title dark-red"><i class="fa-solid fa-file-lines"></i> 로그 디렉토리</div>
            <div class="info-row">
                <span class="info-label">경로</span>
                <span class="info-value" style="font-size: 12px; word-break: break-all;">/home/www/DATA/UPBIT/log</span>
            </div>
            <?php if ($logDirInfo['exists']): ?>
            <div class="info-row">
                <span class="info-label">디렉토리 존재</span>
                <span class="info-value">
                    <span class="status-badge status-ok">존재함</span>
                </span>
            </div>
            <div class="info-row">
                <span class="info-label">총 용량</span>
                <span class="info-value">
                    <?php if ($logDirInfo['size_gb'] >= 1): ?>
                        <?= number_format($logDirInfo['size_gb'], 2) ?> GB
                    <?php else: ?>
                        <?= number_format($logDirInfo['size_mb'], 2) ?> MB
                    <?php endif; ?>
                </span>
            </div>
            <div class="info-row">
                <span class="info-label">파일 수</span>
                <span class="info-value"><?= number_format($logDirInfo['file_count']) ?>개</span>
            </div>
            <div class="info-row">
                <span class="info-label">하위 디렉토리 수</span>
                <span class="info-value"><?= number_format($logDirInfo['dir_count']) ?>개</span>
            </div>
            <?php if ($logDirInfo['latest_file']): ?>
            <div class="info-row">
                <span class="info-label">최신 파일</span>
                <span class="info-value" style="font-size: 12px;"><?= htmlspecialchars($logDirInfo['latest_file']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">최신 파일 시간</span>
                <span class="info-value" style="font-size: 12px;"><?= htmlspecialchars($logDirInfo['latest_file_time']) ?></span>
            </div>
            <?php endif; ?>
            <?php else: ?>
            <div class="info-row">
                <span class="info-label">디렉토리 존재</span>
                <span class="info-value">
                    <span class="status-badge status-warning">존재하지 않음</span>
                </span>
            </div>
            <?php endif; ?>
        </div>
        
        <!-- 데몬 파일 정보 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-solid fa-gears"></i> 데몬 파일</div>
            <div class="info-row">
                <span class="info-label">발견된 파일 수</span>
                <span class="info-value"><?= count($daemonFiles) ?>개</span>
            </div>
            <?php if (!empty($daemonFiles)): ?>
            <?php 
            $totalSize = array_sum(array_column($daemonFiles, 'size'));
            $totalSizeMB = round($totalSize / 1024 / 1024, 2);
            ?>
            <div class="info-row">
                <span class="info-label">총 파일 크기</span>
                <span class="info-value"><?= number_format($totalSizeMB, 2) ?> MB</span>
            </div>
            <div class="info-row" style="flex-direction: column; align-items: flex-start; padding: 15px 0;">
                <span class="info-label" style="margin-bottom: 10px;">파일 목록 (최대 10개)</span>
                <div class="file-list">
                    <?php foreach (array_slice($daemonFiles, 0, 10) as $file): ?>
                    <div class="file-item">
                        <span class="file-name"><?= htmlspecialchars($file['name']) ?></span>
                        <div class="file-info">
                            <span style="color: #667eea;"><?= $file['type'] ?></span>
                            <span><?= number_format($file['size_mb'], 2) ?> MB</span>
                            <span style="font-size: 11px;"><?= htmlspecialchars($file['modified']) ?></span>
                        </div>
                    </div>
                    <?php endforeach; ?>
                </div>
            </div>
            <?php else: ?>
            <div class="info-row">
                <span class="info-label">데몬 파일</span>
                <span class="info-value" style="color: #f59e0b;">발견되지 않음</span>
            </div>
            <?php endif; ?>
        </div>
        
        <!-- 크론 파일 정보 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-solid fa-clock-rotate-left"></i> 크론 작업</div>
            <div class="info-row">
                <span class="info-label">Crontab 존재</span>
                <span class="info-value">
                    <?php if ($cronInfo['crontab_exists']): ?>
                        <span class="status-badge status-ok">설정됨</span>
                    <?php else: ?>
                        <span class="status-badge status-warning">없음</span>
                    <?php endif; ?>
                </span>
            </div>
            <?php if ($cronInfo['crontab_exists']): ?>
            <div class="info-row">
                <span class="info-label">작업 수</span>
                <span class="info-value"><?= $cronInfo['cron_count'] ?? 0 ?>개</span>
            </div>
            <div class="info-row" style="flex-direction: column; align-items: flex-start; padding: 15px 0;">
                <span class="info-label" style="margin-bottom: 10px;">Crontab 내용</span>
                <div class="cron-content"><?= htmlspecialchars($cronInfo['crontab_content']) ?></div>
            </div>
            <?php endif; ?>
            <?php if (!empty($cronInfo['cron_files'])): ?>
            <div class="info-row">
                <span class="info-label">Cron 디렉토리 파일</span>
                <span class="info-value"><?= count($cronInfo['cron_files']) ?>개</span>
            </div>
            <div class="info-row" style="flex-direction: column; align-items: flex-start; padding: 15px 0;">
                <span class="info-label" style="margin-bottom: 10px;">파일 목록</span>
                <div class="file-list">
                    <?php foreach (array_slice($cronInfo['cron_files'], 0, 4) as $file): ?>
                    <div class="file-item">
                        <span class="file-name"><?= htmlspecialchars($file['name']) ?></span>
                        <div class="file-info">
                            <span><?= number_format($file['size']) ?> bytes</span>
                            <span style="font-size: 11px;"><?= htmlspecialchars($file['modified']) ?></span>
                        </div>
                    </div>
                    <?php endforeach; ?>
                </div>
            </div>
            <?php endif; ?>
        </div>
        
        <!-- 프로세스 정보 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-solid fa-list-check"></i> 실행 중인 프로세스</div>
            <div class="info-row">
                <span class="info-label">PHP 프로세스</span>
                <span class="info-value"><?= $processInfo['php_processes'] ?>개</span>
            </div>
            <div class="info-row">
                <span class="info-label">MySQL 프로세스</span>
                <span class="info-value"><?= $processInfo['mysql_processes'] ?>개</span>
            </div>
            <?php if (!empty($processInfo['daemon_processes'])): ?>
            <div class="info-row">
                <span class="info-label">데몬 프로세스</span>
                <span class="info-value"><?= count($processInfo['daemon_processes']) ?>개</span>
            </div>
            <div class="info-row" style="flex-direction: column; align-items: flex-start; padding: 15px 0;">
                <span class="info-label" style="margin-bottom: 10px;">데몬 프로세스 목록</span>
                <div class="file-list">
                    <?php foreach (array_slice($processInfo['daemon_processes'], 0, 4) as $proc): ?>
                    <div class="file-item">
                        <span class="file-name">PID: <?= htmlspecialchars($proc['pid']) ?></span>
                        <div class="file-info">
                            <span style="font-size: 11px; color: #94a3b8;"><?= htmlspecialchars(substr($proc['cmd'], 0, 50)) ?>...</span>
                        </div>
                    </div>
                    <?php endforeach; ?>
                </div>
            </div>
            <?php else: ?>
            <div class="info-row">
                <span class="info-label">데몬 프로세스</span>
                <span class="info-value" style="color: #f59e0b;">실행 중인 데몬 없음</span>
            </div>
            <?php endif; ?>
        </div>
        
        <!-- 네트워크 정보 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-solid fa-network-wired"></i> 네트워크 정보</div>
            <div class="info-row">
                <span class="info-label">HTTP 호스트</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['http_host']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">클라이언트 IP</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['remote_addr']) ?></span>
            </div>
            <div class="info-row">
                <span class="info-label">요청 URI</span>
                <span class="info-value" style="font-size: 12px; word-break: break-all;"><?= htmlspecialchars($serverInfo['request_uri']) ?></span>
            </div>
        </div>
        
        <!-- 서버 업타임 -->
        <div class="server-card">
            <div class="card-title"><i class="fa-solid fa-stopwatch"></i> 서버 업타임</div>
            <div class="info-row">
                <span class="info-label">시스템 업타임</span>
                <span class="info-value"><?= htmlspecialchars($serverInfo['uptime']) ?></span>
            </div>
        </div>
        
        <!-- 빠른 메트릭 -->
        <div class="server-card full-width">
            <div class="card-title"><i class="fa-solid fa-chart-line"></i> 시스템 메트릭</div>
            <div style="display: grid; grid-template-columns: repeat(8, 1fr); gap: 15px;">
                <div class="metric-card">
                    <div class="metric-label">메모리 사용률</div>
                    <div class="metric-value"><?= $memoryUsagePercent ?>%</div>
                </div>
                <div class="metric-card">
                    <div class="metric-label">디스크 사용률</div>
                    <div class="metric-value"><?= $serverInfo['disk_usage_percent'] ?>%</div>
                </div>
                <div class="metric-card">
                    <div class="metric-label">PHP 버전</div>
                    <div class="metric-value"><?= htmlspecialchars($serverInfo['php_version']) ?></div>
                </div>
                <div class="metric-card">
                    <div class="metric-label">CPU 코어</div>
                    <div class="metric-value"><?= $serverInfo['cpu_count'] > 0 ? $serverInfo['cpu_count'] : 'N/A' ?></div>
                </div>
                <?php if ($mysqlInfo['connected']): ?>
                <div class="metric-card">
                    <div class="metric-label">DB 크기</div>
                    <div class="metric-value"><?= number_format($dbInfo['size_mb'], 1) ?>MB</div>
                </div>
                <?php endif; ?>
                <?php if ($logDirInfo['exists']): ?>
                <div class="metric-card">
                    <div class="metric-label">로그 파일 수</div>
                    <div class="metric-value"><?= number_format($logDirInfo['file_count']) ?></div>
                </div>
                <?php endif; ?>
                <?php if (!empty($daemonFiles)): ?>
                <div class="metric-card">
                    <div class="metric-label">데몬 파일 수</div>
                    <div class="metric-value"><?= count($daemonFiles) ?></div>
                </div>
                <?php endif; ?>
                <?php if ($cronInfo['crontab_exists']): ?>
                <div class="metric-card">
                    <div class="metric-label">크론 작업 수</div>
                    <div class="metric-value"><?= $cronInfo['cron_count'] ?? 0 ?></div>
                </div>
                <?php endif; ?>
            </div>
        </div>
    </div>
    
    <button class="refresh-btn" onclick="location.reload()"><i class="fa-solid fa-arrows-rotate"></i> 새로고침</button>
</div>

<?php require_once '/home/www/GNU/_PAGE/tail.php'; ?>