126 lines
8.6 KiB
PHP
Executable File
126 lines
8.6 KiB
PHP
Executable File
<?php
|
|
$pdo = new PDO('pgsql:host=localhost;dbname=adx_system', 'admin', 'admin123');
|
|
$stats = ['campaigns' => 0, 'offers' => 0, 'creatives' => 0];
|
|
try { $stats['campaigns'] = $pdo->query("SELECT COUNT(*) FROM admin.campaigns")->fetchColumn() ?: 0; } catch(Exception $e) {}
|
|
try { $stats['offers'] = $pdo->query("SELECT COUNT(*) FROM affiliate.offers")->fetchColumn() ?: 0; } catch(Exception $e) {}
|
|
try { $stats['creatives'] = $pdo->query("SELECT COUNT(*) FROM affiliate.creatives")->fetchColumn() ?: 0; } catch(Exception $e) {}
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html><head>
|
|
<meta charset="UTF-8">
|
|
<title>Campaign Manager - Préparation Campagnes</title>
|
|
<link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" rel="stylesheet">
|
|
<style>
|
|
*{margin:0;padding:0;box-sizing:border-box}
|
|
body{font-family:system-ui;background:#0a0a0f;color:#e2e8f0;min-height:100vh;padding:20px}
|
|
h1{color:#10b981;margin-bottom:10px}
|
|
.back-link{color:#5eead4;text-decoration:none;display:inline-block;margin-bottom:20px}
|
|
.process-box{background:#12121a;border-radius:12px;padding:20px;margin-bottom:20px;border:1px solid #333}
|
|
.process-title{color:#10b981;margin-bottom:15px;font-size:1.1rem}
|
|
.process-flow{display:flex;flex-wrap:wrap;gap:15px;align-items:center;justify-content:center}
|
|
.process-step{background:#1a1a2e;border:2px solid #333;border-radius:10px;padding:15px;min-width:130px;text-align:center}
|
|
.process-step .icon{font-size:1.8rem;margin-bottom:8px}
|
|
.process-step .num{width:24px;height:24px;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-size:0.8rem;font-weight:bold;margin-bottom:5px}
|
|
.process-step .title{font-weight:bold;font-size:0.85rem;margin-bottom:5px}
|
|
.process-step .desc{font-size:0.7rem;opacity:0.8}
|
|
.process-arrow{color:#10b981;font-size:1.5rem}
|
|
.summary{display:grid;grid-template-columns:repeat(auto-fit,minmax(150px,1fr));gap:15px;margin-bottom:25px}
|
|
.summary-card{background:#12121a;padding:20px;border-radius:12px;text-align:center;border-left:4px solid #10b981}
|
|
.summary-val{font-size:2rem;font-weight:bold;color:#10b981}
|
|
.summary-lbl{font-size:0.85rem;opacity:0.7}
|
|
.info-grid{display:grid;grid-template-columns:repeat(auto-fit,minmax(250px,1fr));gap:15px;margin-top:15px;font-size:0.85rem}
|
|
.info-grid div{background:#1a1a2e;padding:12px;border-radius:8px}
|
|
.panel{background:#12121a;border-radius:12px;padding:20px;margin-top:20px}
|
|
.btn{padding:10px 20px;border:none;border-radius:6px;cursor:pointer;background:#10b981;color:white;text-decoration:none;display:inline-flex;align-items:center;gap:5px}
|
|
</style>
|
|
|
|
</head><body>
|
|
|
|
<a href="/system-flows.php" class="back-link"><i class="fas fa-arrow-left"></i> Retour aux System Flows</a>
|
|
|
|
<div class="process-box">
|
|
<h3 class="process-title"><i class="fas fa-bullhorn"></i> Comment fonctionne la Préparation Campagne ?</h3>
|
|
<div class="process-flow">
|
|
<div class="process-step"><div class="icon">🎯</div><div class="num" style="background:#3b82f6;color:white">1</div><div class="title" style="color:#3b82f6">OFFER</div><div class="desc">Sélection offre<br>affiliate network</div></div>
|
|
<div class="process-arrow">→</div>
|
|
<div class="process-step"><div class="icon
|
|
# 3. Créer campaign-manager.php
|
|
cat > /opt/wevads/public/campaign-manager.php << 'EOFPHP'
|
|
<?php
|
|
$pdo = new PDO('pgsql:host=localhost;dbname=adx_system', 'admin', 'admin123');
|
|
$stats = ['campaigns' => 0, 'offers' => 0, 'creatives' => 0];
|
|
try { $stats['campaigns'] = $pdo->query("SELECT COUNT(*) FROM admin.campaigns")->fetchColumn() ?: 0; } catch(Exception $e) {}
|
|
try { $stats['offers'] = $pdo->query("SELECT COUNT(*) FROM affiliate.offers")->fetchColumn() ?: 0; } catch(Exception $e) {}
|
|
try { $stats['creatives'] = $pdo->query("SELECT COUNT(*) FROM affiliate.creatives")->fetchColumn() ?: 0; } catch(Exception $e) {}
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html><head>
|
|
<meta charset="UTF-8">
|
|
<title>Campaign Manager - Préparation Campagnes</title>
|
|
<link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" rel="stylesheet">
|
|
<style>
|
|
*{margin:0;padding:0;box-sizing:border-box}
|
|
body{font-family:system-ui;background:#0a0a0f;color:#e2e8f0;min-height:100vh;padding:20px}
|
|
h1{color:#10b981;margin-bottom:10px}
|
|
.back-link{color:#5eead4;text-decoration:none;display:inline-block;margin-bottom:20px}
|
|
.process-box{background:#12121a;border-radius:12px;padding:20px;margin-bottom:20px;border:1px solid #333}
|
|
.process-title{color:#10b981;margin-bottom:15px;font-size:1.1rem}
|
|
.process-flow{display:flex;flex-wrap:wrap;gap:15px;align-items:center;justify-content:center}
|
|
.process-step{background:#1a1a2e;border:2px solid #333;border-radius:10px;padding:15px;min-width:130px;text-align:center}
|
|
.process-step .icon{font-size:1.8rem;margin-bottom:8px}
|
|
.process-step .num{width:24px;height:24px;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-size:0.8rem;font-weight:bold;margin-bottom:5px}
|
|
.process-step .title{font-weight:bold;font-size:0.85rem;margin-bottom:5px}
|
|
.process-step .desc{font-size:0.7rem;opacity:0.8}
|
|
.process-arrow{color:#10b981;font-size:1.5rem}
|
|
.summary{display:grid;grid-template-columns:repeat(auto-fit,minmax(150px,1fr));gap:15px;margin-bottom:25px}
|
|
.summary-card{background:#12121a;padding:20px;border-radius:12px;text-align:center;border-left:4px solid #10b981}
|
|
.summary-val{font-size:2rem;font-weight:bold;color:#10b981}
|
|
.summary-lbl{font-size:0.85rem;opacity:0.7}
|
|
.info-grid{display:grid;grid-template-columns:repeat(auto-fit,minmax(250px,1fr));gap:15px;margin-top:15px;font-size:0.85rem}
|
|
.info-grid div{background:#1a1a2e;padding:12px;border-radius:8px}
|
|
.panel{background:#12121a;border-radius:12px;padding:20px;margin-top:20px}
|
|
.btn{padding:10px 20px;border:none;border-radius:6px;cursor:pointer;background:#10b981;color:white;text-decoration:none;display:inline-flex;align-items:center;gap:5px}
|
|
</style>
|
|
</head><body>
|
|
|
|
<a href="/system-flows.php" class="back-link"><i class="fas fa-arrow-left"></i> Retour aux System Flows</a>
|
|
|
|
<div class="process-box">
|
|
<h3 class="process-title"><i class="fas fa-bullhorn"></i> Comment fonctionne la Préparation Campagne ?</h3>
|
|
<div class="process-flow">
|
|
<div class="process-step"><div class="icon">🎯</div><div class="num" style="background:#3b82f6;color:white">1</div><div class="title" style="color:#3b82f6">OFFER</div><div class="desc">Sélection offre<br>affiliate network</div></div>
|
|
<div class="process-arrow">→</div>
|
|
<div class="process-step"><div class="icon">🎨</div><div class="num" style="background:#f59e0b;color:black">2</div><div class="title" style="color:#f59e0b">CREATIVE</div><div class="desc">HTML template<br>+ subject lines</div></div>
|
|
<div class="process-arrow">→</div>
|
|
<div class="process-step"><div class="icon">👥</div><div class="num" style="background:#10b981;color:white">3</div><div class="title" style="color:#10b981">SEGMENT</div><div class="desc">Liste cible<br>par ISP/pays</div></div>
|
|
<div class="process-arrow">→</div>
|
|
<div class="process-step"><div class="icon">⚙️</div><div class="num" style="background:#9333ea;color:white">4</div><div class="title" style="color:#9333ea">CONFIG</div><div class="desc">Headers, from<br>rotation rules</div></div>
|
|
<div class="process-arrow">→</div>
|
|
<div class="process-step"><div class="icon">✅</div><div class="num" style="background:#5eead4;color:black">5</div><div class="title" style="color:#5eead4">READY</div><div class="desc">Campagne<br>prête à envoyer</div></div>
|
|
</div>
|
|
<div class="info-grid">
|
|
<div><strong style="color:#3b82f6">🎯 Offers:</strong> Sélectionner depuis Double M, Everflow, CX3 ou créer offre custom</div>
|
|
<div><strong style="color:#f59e0b">🎨 Creatives:</strong> Templates HTML responsive avec spintax et personnalisation</div>
|
|
<div><strong style="color:#5eead4">👥 Segments:</strong> Filtrer leads par ISP, score, pays, engagement</div>
|
|
</div>
|
|
</div>
|
|
|
|
<h1><i class="fas fa-bullhorn"></i> Campaign Manager</h1>
|
|
<p style="opacity:0.7;margin-bottom:20px">Préparation des Campagnes Email</p>
|
|
|
|
<div class="summary">
|
|
<div class="summary-card"><div class="summary-val"><?=$stats['campaigns']?></div><div class="summary-lbl">Campagnes</div></div>
|
|
<div class="summary-card"><div class="summary-val"><?=$stats['offers']?></div><div class="summary-lbl">Offers</div></div>
|
|
<div class="summary-card"><div class="summary-val"><?=$stats['creatives']?></div><div class="summary-lbl">Creatives</div></div>
|
|
</div>
|
|
|
|
<div class="panel">
|
|
<h4 style="color:#10b981;margin-bottom:15px"><i class="fas fa-link"></i> Accès rapide</h4>
|
|
<div style="display:flex;gap:10px;flex-wrap:wrap">
|
|
<a href="/campaign-orchestrator.php" class="btn"><i class="fas fa-play"></i> Campaign Orchestrator</a>
|
|
<a href="/deliverability-hub.php" class="btn"><i class="fas fa-inbox"></i> Deliverability Hub</a>
|
|
</div>
|
|
</div>
|
|
|
|
</body></html>
|