prepare("DELETE FROM server_logs");
$stmt->execute();
$message = "所有日志已清除";
} elseif ($logType === 'smtp') {
$stmt = $db->prepare("DELETE FROM server_logs WHERE log_type = 'SMTP'");
$stmt->execute();
$message = "SMTP日志已清除";
} elseif ($logType === 'pop3') {
$stmt = $db->prepare("DELETE FROM server_logs WHERE log_type = 'POP3'");
$stmt->execute();
$message = "POP3日志已清除";
}
}
// 获取日志统计
$stmt = $db->query("SELECT COUNT(*) as count FROM server_logs");
$totalLogs = $stmt->fetch()['count'];
$stmt = $db->query("SELECT COUNT(*) as count FROM server_logs WHERE log_type = 'SMTP'");
$smtpLogs = $stmt->fetch()['count'];
$stmt = $db->query("SELECT COUNT(*) as count FROM server_logs WHERE log_type = 'POP3'");
$pop3Logs = $stmt->fetch()['count'];
// 分页参数
$page = isset($_GET['page']) ? max(1, (int)$_GET['page']) : 1;
$perPage = 50;
$offset = ($page - 1) * $perPage;
// 过滤参数
$filterType = $_GET['type'] ?? 'all';
// 获取日志列表
if ($filterType === 'smtp') {
$stmt = $db->prepare("
SELECT l.*, u.username
FROM server_logs l
LEFT JOIN users u ON l.user_id = u.id
WHERE l.log_type = 'SMTP'
ORDER BY l.created_at DESC
LIMIT ? OFFSET ?
");
$stmt->execute([$perPage, $offset]);
$countStmt = $db->prepare("SELECT COUNT(*) as count FROM server_logs WHERE log_type = 'SMTP'");
$countStmt->execute();
$totalLogs = $countStmt->fetch()['count'];
} elseif ($filterType === 'pop3') {
$stmt = $db->prepare("
SELECT l.*, u.username
FROM server_logs l
LEFT JOIN users u ON l.user_id = u.id
WHERE l.log_type = 'POP3'
ORDER BY l.created_at DESC
LIMIT ? OFFSET ?
");
$stmt->execute([$perPage, $offset]);
$countStmt = $db->prepare("SELECT COUNT(*) as count FROM server_logs WHERE log_type = 'POP3'");
$countStmt->execute();
$totalLogs = $countStmt->fetch()['count'];
} else {
$stmt = $db->prepare("
SELECT l.*, u.username
FROM server_logs l
LEFT JOIN users u ON l.user_id = u.id
ORDER BY l.created_at DESC
LIMIT ? OFFSET ?
");
$stmt->execute([$perPage, $offset]);
}
$logs = $stmt->fetchAll();
$totalPages = ceil($totalLogs / $perPage);
// 获取日志设置
$logPath = $settingsRepo->get('log_path', '/var/log/mailserver');
$logMaxSize = $settingsRepo->get('log_max_size', 10485760);
?>
系统日志 - 邮件服务器
系统日志管理
日志存储路径：
日志文件最大大小： MB
1): ?>