51 lines
2.5 KiB
PHP
Executable File
51 lines
2.5 KiB
PHP
Executable File
|
|
<?php
|
|
header('Content-Type: application/json');
|
|
$pdo = new PDO("pgsql:host=localhost;dbname=adx_system", "admin", "admin123", [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
|
|
|
|
$action = $_GET['action'] ?? $_POST['action'] ?? '';
|
|
|
|
switch ($action) {
|
|
case 'overview':
|
|
case 'full':
|
|
$data = [
|
|
'cloud' => [
|
|
'huawei' => $pdo->query("SELECT COUNT(*) FROM admin.huawei_accounts")->fetchColumn(),
|
|
'regions_active' => $pdo->query("SELECT COUNT(*) FROM admin.huawei_regions WHERE is_active = true")->fetchColumn()
|
|
],
|
|
'email' => [
|
|
'o365' => $pdo->query("SELECT COUNT(*) FROM admin.office365_accounts")->fetchColumn(),
|
|
'gsuite' => $pdo->query("SELECT COUNT(*) FROM admin.gsuite_accounts")->fetchColumn()
|
|
],
|
|
'infrastructure' => [
|
|
'mta_servers' => $pdo->query("SELECT COUNT(*) FROM admin.mta_servers")->fetchColumn(),
|
|
'domains' => $pdo->query("SELECT COUNT(*) FROM admin.domains")->fetchColumn()
|
|
],
|
|
'data' => [
|
|
'leads' => $pdo->query("SELECT COUNT(*) FROM admin.leads")->fetchColumn(),
|
|
'campaigns' => $pdo->query("SELECT COUNT(*) FROM admin.campaigns")->fetchColumn()
|
|
],
|
|
'intelligence' => [
|
|
'knowledge_base' => $pdo->query("SELECT COUNT(*) FROM admin.knowledge_base")->fetchColumn(),
|
|
'brain_winners' => $pdo->query("SELECT COUNT(*) FROM admin.brain_winners")->fetchColumn()
|
|
],
|
|
'performance' => [
|
|
'top_isps' => $pdo->query("SELECT isp_target, inbox_rate FROM admin.brain_winners ORDER BY inbox_rate DESC LIMIT 5")->fetchAll(PDO::FETCH_ASSOC),
|
|
'campaigns_completed' => $pdo->query("SELECT COUNT(*) FROM admin.campaigns WHERE status = 'completed'")->fetchColumn()
|
|
]
|
|
];
|
|
echo json_encode($data);
|
|
break;
|
|
case 'campaigns':
|
|
$campaigns = $pdo->query("SELECT id, name, status, created_at FROM admin.campaigns ORDER BY id DESC LIMIT 20")->fetchAll(PDO::FETCH_ASSOC);
|
|
echo json_encode(['campaigns' => $campaigns]);
|
|
break;
|
|
case 'winners':
|
|
$winners = $pdo->query("SELECT * FROM admin.brain_winners ORDER BY inbox_rate DESC")->fetchAll(PDO::FETCH_ASSOC);
|
|
echo json_encode(['winners' => $winners]);
|
|
break;
|
|
default:
|
|
echo json_encode(['name' => 'Unified Dashboard API', 'actions' => ['overview', 'full', 'campaigns', 'winners']]);
|
|
}
|
|
|