<?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'; ?>