158 lines
8.0 KiB
PHP
Executable File
158 lines
8.0 KiB
PHP
Executable File
<?php
|
|
error_reporting(E_ERROR | E_PARSE);
|
|
$db_host = '127.0.0.1';
|
|
$db_name = 'adx_system';
|
|
$db_user = 'admin';
|
|
$db_pass = 'admin123';
|
|
|
|
try {
|
|
$pdo = new PDO("pgsql:host=$db_host;dbname=$db_name", $db_user, $db_pass);
|
|
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
} catch(PDOException $e) {
|
|
die("Connection Error: " . $e->getMessage());
|
|
}
|
|
|
|
# Fetch global tracking statistics
|
|
$stats = ['opens' => 0, 'clicks' => 0, 'leads' => 0, 'unsubscribes' => 0, 'optouts' => 0, 'total' => 0];
|
|
$tables = ['opens', 'clicks', 'leads', 'unsubscribes', 'optouts'];
|
|
|
|
foreach($tables as $table) {
|
|
try {
|
|
$stmt = $pdo->query("SELECT COUNT(*) as count FROM actions.$table");
|
|
$row = $stmt->fetch(PDO::FETCH_ASSOC);
|
|
$stats[$table] = intval($row['count']);
|
|
$stats['total'] += $stats[$table];
|
|
} catch(Exception $e) {
|
|
$stats[$table] = 0;
|
|
}
|
|
}
|
|
|
|
# Get recent actions from all apps
|
|
$recent_actions = [];
|
|
try {
|
|
$stmt = $pdo->query("SELECT 'OPEN' as type, created_at, process_id, client_id FROM actions.opens ORDER BY created_at DESC LIMIT 100");
|
|
$recent_actions = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
} catch(Exception $e) {
|
|
$recent_actions = [];
|
|
}
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<title>📊 GLOBAL Tracking Dashboard</title>
|
|
<meta charset="utf-8">
|
|
<meta http-equiv="refresh" content="30">
|
|
<style>
|
|
body { font-family: Arial, sans-serif; background: linear-gradient(135deg, #0a0e27 0%, #1a1a3e 100%); color: #fff; padding: 30px; margin: 0; }
|
|
.container { max-width: 1600px; margin: 0 auto; }
|
|
h1 { color: #00d4ff; font-size: 36px; margin: 0 0 10px 0; text-shadow: 0 0 20px rgba(0, 212, 255, 0.5); }
|
|
.info { color: #90caf9; font-size: 14px; margin-bottom: 30px; }
|
|
.stats { display: grid; grid-template-columns: repeat(auto-fit, minmax(180px, 1fr)); gap: 20px; margin-bottom: 40px; }
|
|
.stat { background: linear-gradient(135deg, #16213e 0%, #0f3460 100%); padding: 25px; border-radius: 12px; border-left: 5px solid #00d4ff; box-shadow: 0 4px 15px rgba(0, 0, 0, 0.3); }
|
|
.stat.total { grid-column: 1 / -1; border-left-color: #00d4ff; }
|
|
.stat-num { font-size: 42px; font-weight: bold; color: #00d4ff; margin-bottom: 10px; }
|
|
.stat.opens .stat-num { color: #4caf50; }
|
|
.stat.clicks .stat-num { color: #ff9800; }
|
|
.stat.leads .stat-num { color: #ff4081; }
|
|
.stat.unsubscribes .stat-num { color: #f44336; }
|
|
.stat.optouts .stat-num { color: #9c27b0; }
|
|
.stat.opens { border-left-color: #4caf50; }
|
|
.stat.clicks { border-left-color: #ff9800; }
|
|
.stat.leads { border-left-color: #ff4081; }
|
|
.stat.unsubscribes { border-left-color: #f44336; }
|
|
.stat.optouts { border-left-color: #9c27b0; }
|
|
.stat-label { font-size: 14px; color: #b0bec5; text-transform: uppercase; letter-spacing: 1px; }
|
|
.section { background: linear-gradient(135deg, #16213e 0%, #0f3460 100%); padding: 30px; border-radius: 12px; margin-bottom: 30px; border-left: 5px solid #00d4ff; box-shadow: 0 4px 15px rgba(0, 0, 0, 0.3); }
|
|
.section h2 { color: #00d4ff; font-size: 20px; margin-bottom: 20px; text-transform: uppercase; letter-spacing: 1px; }
|
|
.apps { display: grid; grid-template-columns: repeat(auto-fit, minmax(250px, 1fr)); gap: 20px; margin-bottom: 30px; }
|
|
.app-link { background: linear-gradient(135deg, #16213e 0%, #0f3460 100%); padding: 20px; border-radius: 10px; text-align: center; border: 2px solid #00d4ff; cursor: pointer; transition: all 0.3s; text-decoration: none; color: #fff; }
|
|
.app-link:hover { transform: translateY(-5px); box-shadow: 0 10px 30px rgba(0, 212, 255, 0.3); border-color: #00d4ff; }
|
|
.app-link.wevads { border-color: #00d4ff; }
|
|
.app-link.fmg { border-color: #4caf50; }
|
|
.app-link.bcg { border-color: #ff9800; }
|
|
.app-icon { font-size: 28px; margin-bottom: 10px; }
|
|
.app-name { font-size: 16px; font-weight: bold; margin-bottom: 5px; }
|
|
.logs-container { max-height: 500px; overflow-y: auto; background: rgba(0, 0, 0, 0.2); padding: 15px; border-radius: 8px; }
|
|
.log-item { background: rgba(15, 15, 35, 0.8); padding: 10px; margin-bottom: 8px; border-radius: 6px; font-size: 11px; font-family: monospace; border-left: 3px solid #4caf50; display: flex; justify-content: space-between; }
|
|
.log-time { color: #90caf9; margin: 0 10px; }
|
|
.refresh-info { text-align: center; color: #90caf9; font-size: 12px; margin-top: 30px; }
|
|
</style>
|
|
|
|
</head>
|
|
<body>
|
|
<div class="container">
|
|
<h1>📊 GLOBAL Tracking Dashboard</h1>
|
|
<p class="info">Consolidated metrics from all tracking servers | Auto-refresh: 30s | Last update: <?php echo date('Y-m-d H:i:s'); ?></p>
|
|
|
|
<div class="stats">
|
|
<div class="stat total">
|
|
<div class="stat-num"><?php echo number_format($stats['total']); ?></div>
|
|
<div class="stat-label">📊 Total Events</div>
|
|
</div>
|
|
<div class="stat opens">
|
|
<div class="stat-num"><?php echo number_format($stats['opens']); ?></div>
|
|
<div class="stat-label">📧 Opens</div>
|
|
</div>
|
|
<div class="stat clicks">
|
|
<div class="stat-num"><?php echo number_format($stats['clicks']); ?></div>
|
|
<div class="stat-label">🔗 Clicks</div>
|
|
</div>
|
|
<div class="stat leads">
|
|
<div class="stat-num"><?php echo number_format($stats['leads']); ?></div>
|
|
<div class="stat-label">⭐ Leads</div>
|
|
</div>
|
|
<div class="stat unsubscribes">
|
|
<div class="stat-num"><?php echo number_format($stats['unsubscribes']); ?></div>
|
|
<div class="stat-label">📵 Unsub</div>
|
|
</div>
|
|
<div class="stat optouts">
|
|
<div class="stat-num"><?php echo number_format($stats['optouts']); ?></div>
|
|
<div class="stat-label">❌ Optout</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="section">
|
|
<h2>🔗 Application Dashboards</h2>
|
|
<div class="apps">
|
|
<a href="http://89.167.40.150:5821/tracking/dashboard.php" class="app-link wevads">
|
|
<div class="app-icon">🎯</div>
|
|
<div class="app-name">WEVAL</div>
|
|
<div style="font-size: 12px; color: #90caf9;">5821</div>
|
|
</a>
|
|
<a href="http://89.167.40.150:5822/tracking/dashboard.php" class="app-link fmg">
|
|
<div class="app-icon">📮</div>
|
|
<div class="app-name">FMG</div>
|
|
<div style="font-size: 12px; color: #90caf9;">5822</div>
|
|
</a>
|
|
<a href="http://89.167.40.150:5823/tracking/dashboard.php" class="app-link bcg">
|
|
<div class="app-icon">🎨</div>
|
|
<div class="app-name">BCG</div>
|
|
<div style="font-size: 12px; color: #90caf9;">5823</div>
|
|
</a>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="section">
|
|
<h2>📋 Recent Activity (Last 100)</h2>
|
|
<div class="logs-container">
|
|
<?php if(count($recent_actions) > 0): ?>
|
|
<?php foreach($recent_actions as $action): ?>
|
|
<div class="log-item">
|
|
<span><?php echo $action['type']; ?></span>
|
|
<span class="log-time"><?php echo date('H:i:s', strtotime($action['created_at'])); ?></span>
|
|
<span>P:<?php echo $action['process_id']; ?> C:<?php echo $action['client_id']; ?></span>
|
|
</div>
|
|
<?php endforeach; ?>
|
|
<?php else: ?>
|
|
<div style="text-align: center; padding: 30px; color: #90caf9;">No recent activity</div>
|
|
<?php endif; ?>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="refresh-info">⟳ This page automatically refreshes every 30 seconds</div>
|
|
</div>
|
|
<?php include("includes/chatbot-widget.php"); ?>
|
|
|
|
</body>
|
|
</html>
|